Senior SQL Server DBA / Database Architect

Hybrid in Philadelphia, PA, US • Posted 8 hours ago • Updated 8 hours ago

Contract W2

Contract Independent

No Travel Required

Able to Sponsor

On-site

Depends on Experience

Fitment

Dice Job Match Score™

📊 Calculating match score...

Job Details

Skills

Database Architecture
Extract, Transform, Load
Microsoft SQL Server
Microsoft Azure
High Availability
Windows PowerShell
Scripting
SQL Azure

Summary

We are seeking a Senior SQL Server DBA / Database Architect for a critical enterprise engagement in Philadelphia, PA. This is a high-visibility, hands-on leadership role responsible for owning the complete database ecosystem across on-premises and Azure environments.

The ideal candidate will bring deep expertise in Microsoft SQL Server administration, database architecture, and advanced T-SQL development. This role requires strong experience in automation using PowerShell, ETL development with SQL Server Integration Services (SSIS), and cloud technologies including Azure SQL Database and other Azure data services.

This position demands strong leadership, ownership, and the ability to manage mission-critical production systems while driving performance optimization, security, and cloud migration initiatives.

Roles & Responsibilities:

Lead and manage enterprise-wide SQL Server database environments (On-Prem & Azure)
Design, implement, and maintain database architecture and standards
Develop and optimize stored procedures, views, functions, and complex T-SQL queries
Perform performance tuning, indexing strategies, and execution plan analysis
Implement and manage High Availability and Disaster Recovery solutions (Always On, Clustering, Log Shipping)
Create and maintain SQL Server Agent jobs, maintenance plans, and monitoring solutions
Automate administrative and deployment tasks using PowerShell scripting
Develop, deploy, and troubleshoot SSIS packages and ETL workflows
Lead cloud migration initiatives from on-prem SQL environments to Azure platforms
Ensure database security, compliance, encryption, and auditing standards
Perform root cause analysis and resolve critical production issues
Collaborate with application, infrastructure, and DevOps teams
Mentor junior DBAs and provide technical leadership

Required Skills:

10+ years of experience with Microsoft SQL Server (2016/2019/2022 preferred)
Strong expertise in T-SQL and database development
Advanced performance tuning and troubleshooting skills
Experience with High Availability & Disaster Recovery solutions
Strong PowerShell scripting and automation experience
Hands-on experience with SSIS (ETL development)
Experience with Azure SQL Database and cloud-based database solutions
Experience in database migration (On-Prem to Azure)
Strong communication and leadership skills

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.

Dice Id: 10483217
Position Id: 8898096
Posted 8 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.