| Onsite Work -- Applications SQL DBA in New York City office.NY -No H1B, CPT&OPT at York, New York, USA |
| Email: [email protected] |
| From: Vivek Yadav, SoniTalent corp [email protected] Reply to: [email protected] Hi, My name is Vivek Yadav and I am a Staffing Specialist at Sonitalent llc. I am reaching out to you on an exciting job opportunity with one of our clients. Job title: Applications SQL DBA Location: New York City office.NY ( Onsite ) Duration: 12+ months Mode of Interview: Phone/ Skype Visa: No H1B, CPT&OPT Job Description: Our Client is seeking consultants who will participate on a Global DBA team. The team will ensure that the new database code meets company standards for readability, reliability, and performance. This role is on-site in their New York City office. Design indexes for existing applications, choosing when to add or remove indexes. Seeking Applications DBA, not just a production DBA Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc). Consultant must have experience: 1) Writing and improving SQL Server T-SQL queries for at least a year. You will be known amongst the office as the go-to person for T-SQL questions. 2) Designing tables and picking datatypes o Using Profiler traces and other tools to find the most frequently run queries. 3) Using free tools like sp_BlitzIndex and DMV queries to answer questions about index usage. 5) On-call troubleshooting for SQL Server service outages. 6) Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem. Skills Need: Must have 4 + years of Recent Banking experience. Must have recent and extensive experience performing Level 3 support (The highest level Support). These positions are for a Global DBA unit. Consultants must have experience working Constantly with DBs sizes of 30TB or more Experience working with large-scale enterprise application setup across Data centers. Must have a Minimum of 10+ years conducting general database administration tasks (e.g. DB implementation, DB code deployments, DB backups, creation of DB user accounts). Minimum of 7+ years experience working as a SQL Server DBA. Must have experience as an Functional & Application DBA. Must have at least 5 years administering database platform specific advanced features (e.g. clustering, encryption, logical/physical standby, ETL, replication) and performance optimizing server database servers and SQL code. Minimum of 5+ years experience working in a SQL DBA Role with multiple databases and SQL development experience. Proficient in MS SQL Server 2014 - 2019. SSIS Package creation and debugging skills. Stored procedure development and tuning. Data replication exposure. Keywords: access management database golang microsoft New York |
| [email protected] View all |
| Tue Feb 20 22:33:00 UTC 2024 |