Title: Sr SQL Server Functional /Application DBA V2014 - 2022 Work Location: NYC, NY Duration: 1yr The client is looking for an experienced SQL Server Database Administrator (DBA) with a focus on performance optimization, query tuning, database design, and troubleshooting. This is likely for a critical project within the banking sector, given the emphasis on recent banking experience and the need for high-level support in a global unit. Job Description Summary:
- The role involves ensuring that new database code meets company standards for performance and reliability.
- Providing developers with insights into the most resource-intensive queries and suggesting improvements.
- Designing indexes for existing applications and advising developers on efficient database designs.
- Conducting training sessions for application developers on SQL Server best practices.
- Serving as the go-to person for T-SQL queries and database-related questions.
Skills Required:
- Minimum 10+ years of general database administration tasks.
- Minimum 7+ years of experience working as a SQL Server DBA.
- Experience with SQL Server 2014 - 2019.
- Proficiency in SSIS package creation and debugging.
- Expertise in stored procedure development and tuning.
- Exposure to data replication techniques.
- Experience in identifying and improving resource-intensive queries.
- Proficiency in designing indexes and optimizing existing applications for performance.
- Experience in designing efficient database structures, including tables and datatypes.
- Familiarity with advanced features such as clustering, encryption, replication, etc.
- Ability to advise on efficient database designs and implementations across data centers.
- Recent experience performing Level 3 support.
- On-call troubleshooting for SQL Server service outages.
- Ability to troubleshoot and improve query performance based on user complaints.