SQL Server Database Administrator
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+25 more
Job description
- Own the administration, monitoring, maintenance, and performance of enterprise SQL Server environments across Production, Development, and QA.
- Administer Azure SQL Database, Azure Synapse Analytics, Azure Storage (ADLS Gen2), Azure Data Factory, and Azure Key Vault.
- Manage and support Microsoft Fabric including Workspaces, Capacities, Lakehouse, Warehouse, OneLake, Deployment Pipelines, Semantic Models, and Direct Lake.
- Monitor and optimize database performance through query tuning, indexing strategies, execution plan analysis, and troubleshooting deadlocks, blocking, and resource contention.
- Implement database security, RBAC, encryption (TDE, Always Encrypted), auditing, and compliance standards.
- Manage backup, recovery, disaster recovery, capacity planning, and high availability solutions.
- Lead database migration initiatives from on-premises SQL Server and Azure Synapse to Azure and Microsoft Fabric.
- Collaborate with Infrastructure, Cloud, Data Engineering, and Analytics teams to support enterprise data platforms.
- Automate DBA operations using T-SQL, PowerShell, and Azure DevOps CI/CD practices.
- Act as the escalation point for production incidents, perform root cause analysis, maintain operational documentation, and participate in a 24×7 on-call rotation.
Requirements
- Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience).
- 7+ years of IT experience with 5+ years of hands-on enterprise SQL Server Database Administration.
- Strong experience with:
- SQL Server Administration
- Azure SQL Database
- Azure Synapse Analytics
- Azure Data Factory
- Azure Storage (ADLS Gen2)
- Azure Key Vault
- Microsoft Fabric Administration
- Expertise in:
- SQL Server performance tuning and optimization
- Query optimization, execution plans, indexing, deadlocks, and blocking analysis
- Backup & Recovery, High Availability, Disaster Recovery, and Capacity Planning
- Database Security, RBAC, TDE, Always Encrypted, Row-Level Security, and Auditing
- Strong proficiency in T-SQL and PowerShell (Python is a plus).
- Experience with Azure DevOps, Git, and CI/CD for database deployments.
- Hands-on experience planning and executing SQL Server migrations to Azure and Microsoft Fabric.
- Good understanding of Power BI integration with SQL Server, Azure Synapse, and Microsoft Fabric.
- Excellent troubleshooting, documentation, communication, and stakeholder management skills.
Preferred Qualifications
- Experience with Microsoft Fabric migration projects.
- Experience in Healthcare, including HIPAA compliance, PHI data handling, and healthcare data standards.
- Knowledge of Dataflows Gen2, Data Pipelines, OneLake governance, and Direct Lake optimization.
Benefits & conditions
Up to $45 an hour - Contract, Pulled from the full job description
- Health insurance
- Vision insurance
- Dental insurance, * Dental insurance
- Health insurance
- Vision insurance
About the company
AgreeYa is a global Systems Integrator and is seeking an experienced SQL Server Database Administrator to join our growing team. We are seeking an experienced Senior SQL Server Database Administrator to own and manage our enterprise database platform across on-premises and Azure environments. The ideal candidate will have deep expertise in SQL Server, Azure SQL Database, Azure Synapse Analytics, and emerging Microsoft Fabric technologies. This role is responsible for ensuring database reliability, security, performance, and availability while leading the migration of our data platform from on-premises SQL Server and Azure Synapse to Microsoft Fabric., AgreeYa is a global systems integrator delivering competitive advantage for its customers through software, solutions, and services. Established in 1999, AgreeYa is headquartered in Folsom, California, with a global footprint and a team of more than 2,200 staff across offices. AgreeYa works with 500+ organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom, Banking, Financial Services & Insurance, Healthcare, Utility & Energy, Technology, Public sector, Pharma & Biotech, and others. Please visit us at www.agreeya.com for more information.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.indeed.comGood distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
Making Data Warehouses Fast: A Developer’s Story
Data Analyst Salary in the UK
Data Engineer Salary UK
Highest Paying Tech Companies for Developers