Senior Database Administrator

The Phoenix Group; New York (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

The Phoenix Group is seeking an experienced Database Administrator in New York with a strong focus on Microsoft Azure data services. You will monitor and optimize Azure SQL Databases and Managed Instances, review designs for performance and security, and implement scalable resource management to balance performance with cloud costs.

Working closely with governance teams, you will help ensure data integrity, availability, and security across core enterprise domains, including backups,

Qualifications

• 5+ years of experience as a Database Administrator, with at least 3 years focused on Azure data services.
• Deep, hands-on knowledge of Azure SQL Database, Azure SQL Managed Instance, and SQL Server.
• Proven track record building and optimizing enterprise pipelines using Azure Data Factory (ADF).
• Advanced T-SQL skills (writing/tuning complex queries, stored procedures, triggers, and views).
• Experience with automation scripts using Azure Native tooling.

Responsibilities

• Monitor, diagnose, and resolve performance bottlenecks across Azure SQL Databases and Managed Instances.
• Optimize complex queries, indexing, execution plans, and database configurations.
• Review table designs, stored procedures, views, and other database objects for optimization and security.
• Implement proactive resource management (DTU/vCore scaling) to balance performance with cloud cost-efficiency.
• Develop capacity plans by evaluating data growth rates for future needs.
• Ensure integrity, availability, and security of core enterprise data domains in collaboration with governance teams.
• Manage backup/recovery strategies, geo-replication, and failover groups to meet RPO/RTO objectives.
• Enforce data security policies, including Azure AD integration, Row-Level Security, Data Masking, and encryption at rest/in transit.
• Conduct regular security audits and vulnerability assessments.

Skills

Azure SQL Database

Azure SQL Managed Instance

SQL Server

Azure Data Factory

T-SQL skills

Azure automation

Tools

Microsoft Purview

Azure Synapse Analytics

Databricks

PowerBI

Datadog

Job description

• Monitor, diagnose, and resolve performance bottlenecks across Azure SQL Databases and Managed Instances.
• Optimize complex queries, indexing strategies, execution plans, and database configurations.
• Review table designs, stored procedures, views, and other database objects for performance optimization and security.
• Implement proactive resource management (DTU/vCore scaling) to balance high performance with cloud cost-efficiency.
• Continually evaluate data growth rates and develop capacity plans for future needs.

Core Enterprise Data Maintenance & Governance

• Ensure the absolute integrity, availability, and security of the organization's core enterprise data domains.
• Collaborate with data governance teams to implement data quality checks, schema validation, and deduplication processes.
• Manage data lifecycle strategies, including archiving and partitioning strategies for large-scale digital datasets.

High Availability, Security & Compliance

• Manage backup/recovery strategies, geo-replication, and failover groups to guarantee strict RPO and RTO objectives.
• Implement and enforce data security policies, including Azure Active Directory integration, Row-Level Security, Data Masking, and encryption at rest/in transit.
• Conduct regular security audits and vulnerability assessments.

Qualifications & Skills

Required Experience

• 5+ years of experience as a Database Administrator, with at least 3 years focused natively on Microsoft Azure data services
• Deep, hands-on knowledge of Azure SQL Database, Azure SQL Managed Instance, and SQL Server
• Proven track record building and optimizing enterprise-level pipelines using Azure Data Factory (ADF)
• Advanced T-SQL skills (writing/tuning complex queries, stored procedures, triggers, and views)
• Experience with automation scripts using Azure Native tooling

Preferred (Nice-to-Have)

• Experience with Microsoft Purview or other Core Enterprise Data Management tooling
• Familiarity with Azure Synapse Analytics or Databricks
• Familiarity with Microsoft Fabric and PowerBI
• Familiarity with Datadog or other observability platforms