Tech Stack
AzureBigQueryJavaMySQLPostgresPythonSQLSSIS
About the role
- Lead performance tuning efforts across large-scale SQL Server environments with high transaction volumes.
- Analyze and optimize SQL queries, indexes, and database configurations to improve application responsiveness.
- Monitor and troubleshoot database performance using tools such as Idera SQL Diagnostic Manager, Query Store, SQL Server Profiler, Dynatrace.
- Evaluate index statistics and fragmentation; recommend and implement improvements.
- Develop and maintain documentation of performance best practices for use by development and DBA teams.
- Manage core DBA functions including installation, upgrades, backup/recovery, and high availability (e.g., Always On Failover Clustering).
- Participate in capacity planning and performance forecasting.
- Collaborate with development teams to improve database-related application processes.
- Escalate complex issues and coordinate resolution with internal and external resources.
- Apply administration best practices in daily operations and contribute to continuous improvement efforts.
- Participate in a 24/7 Production support call rotation.
- Support and learn other DBMS as needed (BigQuery, MySQL, PostGreSQL).
Requirements
- Bachelor’s degree in computer science, Information Systems, or related field (or equivalent experience).
- 10+ years of hands-on experience as a SQL Server DBA in enterprise environments.
- Proven experience in high-transaction systems such as ecommerce, banking, or financial services.
- Strong understanding of database file structures, access methods, and performance analysis.
- Advanced knowledge of SQL Server tools and technologies: SSMS, SSIS, SSRS, Always On.
- Demonstrated ability to lead tuning efforts and mentor junior DBAs.
- Excellent analytical, communication, and problem-solving skills.
- Familiarity with application/database interaction and optimization strategies.
- Industry-recognized certifications (e.g., Microsoft Certified Database Administrator) preferred.
- Participation in a 24/7 production support call rotation.
- Willingness to learn and support other Database management systems (BigQuery, MySQL, PostGreSQL).
- Additional preferred skills: Java, Python, MuleSoft, Azure SQL, DevOps and CI/CD pipelines.