Overview
On Site
Hybrid
BASED ON EXPERIENCE
Contract - Independent
Contract - W2
Contract - 3+ mo(s)
Skills
SQL SERVER
SCRIPTING
PYTHON
BASH
JAVASCRIPT
SHELL
RUBY
PERL
PERFORMANCE TUNING
Job Details
Client: Health Insurance
Job: Senior DBA
Location: Onsite 3 days per week in center city Philadelphia
Duration: Contract to hire (3-6 months)
Job Title: Senior SQL Server Database Administrator - Performance Optimization & Troubleshooting Focus
Position Summary:
We are seeking a highly skilled Senior SQL Server Database Administrator to join our dynamic IT team. This role is critical to ensure the performance, reliability, and scalability of our enterprise database systems. The ideal candidate will bring deep expertise in SQL Server, with a strong emphasis on performance tuning, query optimization, and troubleshooting in high-volume, mission-critical environments. You will collaborate closely with cross-functional teams including Application Development, Server Administration, Networking, and other DBAs to proactively identify and resolve performance bottlenecks and contribute to strategic database initiatives.
Key Responsibilities:
Qualifications:
Additional Skills (Preferred but Not Required):
Job: Senior DBA
Location: Onsite 3 days per week in center city Philadelphia
Duration: Contract to hire (3-6 months)
Job Title: Senior SQL Server Database Administrator - Performance Optimization & Troubleshooting Focus
Position Summary:
We are seeking a highly skilled Senior SQL Server Database Administrator to join our dynamic IT team. This role is critical to ensure the performance, reliability, and scalability of our enterprise database systems. The ideal candidate will bring deep expertise in SQL Server, with a strong emphasis on performance tuning, query optimization, and troubleshooting in high-volume, mission-critical environments. You will collaborate closely with cross-functional teams including Application Development, Server Administration, Networking, and other DBAs to proactively identify and resolve performance bottlenecks and contribute to strategic database initiatives.
Key Responsibilities:
- 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.
- Participation in a 24/7 Production support call rotation.
- Willingness to learn and support other Database managements systems as needed (BigQuery, MySQL, PostGreSQL).
Qualifications:
- 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, etc.
- 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.
Additional Skills (Preferred but Not Required):
- Experience with Java in performance-sensitive applications.
- Familiarity with Python for automation or scripting tasks.
- Exposure to MuleSoft (Mule) integration platform.
- Understanding of cloud-based SQL Server deployments (e.g., Azure SQL).
- Knowledge of DevOps practices and CI/CD pipelines involving database components.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.