SQL Database Admin

Role: SQL Database Admin

Location: Newtown Square PA (Hybrid 2-3 days in office every week)

The candidate will be a team player in a technology organization responsible for clients Database Infrastructure environment. The Senior SQL Server Database Administrator plays a critical role in ensuring the reliability performance and security of our enterprise data environment. This position is ideal for someone who thrives in complex technical ecosystems enjoys solving performance challenges and can guide architectural decisions that support long-term scalability

Key Responsibilities:

• Design implement and maintain SQL Server databases across development test and production environments.
• Optimize database performance through indexing strategies query tuning and resource monitoring.
• Manage high availability and disaster recovery solutions (Always On clustering log shipping replication).
• Oversee database security access controls encryption and compliance with internal and external standards.
• Perform database upgrades migrations patching and capacity planning.
• Develop and maintain automation scripts for routine tasks using PowerShell or similar tools.
• Collaborate with application developers data engineers and infrastructure teams to support new and existing solutions.
• Troubleshoot complex database issues including performance bottlenecks blocking deadlocks and storage constraints.
• Create and maintain documentation standards and best practices.
• Mentor junior DBAs and contribute to continuous improvement initiatives.

Required Qualifications:

• 8-10 years of hands-on experience administering Microsoft SQL Server in enterprise environments.
• Deep expertise in SQL Server versions 2016 and above.
• Knowledge of SSIS SSRS or SSAS.
• Experience with cloud database platforms (Azure SQL Managed Instance AWS RDS for SQL Server).
• Strong proficiency in T SQL query optimization and execution plan analysis.
• Proven experience with HA/DR technologies (Always on Availability Groups clustering replication).
• Solid understanding of Windows Server networking fundamentals and storage concepts.
• Experience with monitoring tools (SQL Sentry Redgate SolarWinds DPA or similar).
• Strong analytical and problem solving skills with the ability to work independently.
• Excellent communication skills and the ability to collaborate across teams.

Preferred Qualifications

• Familiarity with DevOps pipelines CI/CD and Infrastructure as Code (Terraform ARM etc.).

Certifications such as Microsoft Certified: Azure Database Administrator Associate or similar.