SQL Server Azure DBA

BRAINS WORKGROUP, INC.; Woodbridge Township (NJ); Hybrid; USD 170,000 - 185,000; Full time

Job summary

BRAINS WORKGROUP, INC. is seeking a Senior DBA to manage SQL Server environments and the Azure data platform in a hybrid Central New Jersey setting. The role emphasizes on-call support, modernization, and cloud adoption for mission-critical databases.

The ideal candidate will have strong automation skills, experience with Azure-native services, and exposure to PostgreSQL. This is a permanent full-time opportunity with a robust benefits package.

Qualifications

• 8+ years of SQL Server administration experience in large-scale enterprises.
• Hands-on with Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs.
• Experience with PostgreSQL is a plus and beneficial for hybrid environments.
• Strong PowerShell scripting and automation capabilities.

Responsibilities

• Administer and support SQL Server environments 2016–2025 and Azure databases.
• Provide L3 operational support and senior escalation for complex incidents.
• Design, implement, and test high availability, DR, and recoverability solutions.
• Automate operational processes using PowerShell, dbatools.io, and IaC where applicable.
• Collaborate with security, cloud, and development teams to optimize performance.

Skills

SQL Server

Azure SQL DB

PostgreSQL exposure

PowerShell

Tools

dbatools.io

Azure Automation

Git

Job description

Senior DBA (SQL Server and Azure Data Platform)

Hybrid commute, 5 days per 2 weeks on-site in Central NJ Locations.

This is a permanent FT career opportunity, with base salary range 170 -185K DOE, plus around ~20% bonus and great benefits package.

Senior Database Administrator (SQL Server & Azure Data Platform)

We are seeking a highly skilled Senior SQL Server DBA with deep expertise in Microsoft SQL Server and Azure data platform technologies. The ideal candidate will also have solid exposure to PostgreSQL.

This role is responsible for the design, administration, automation, security, performance, and resiliency of mission-critical database platforms supporting enterprise business applications.

The ideal candidate combines traditional DBA expertise with modern cloud, automation, observability, and infrastructure-as-code capabilities. This individual will serve as a senior escalation point for database operations while driving platform modernization, operational excellence, cloud adoption, and continuous improvement initiatives.

Key Responsibilities

Database Administration & Operations

• Administer and support Microsoft SQL Server environments from SQL Server 2016 through SQL Server 2025, and Azure-resident database platforms.
• Provide L3 operational support and serve as a senior escalation resource for complex database incidents and service requests.
• Ensure database platform availability, reliability, performance, and recoverability for business-critical systems.
• Manage database lifecycle activities including installation, configuration, patching, upgrades, migrations, and decommissioning.
• Participate in a 24x7 on-call rotation supporting production database environments.

High Availability, Disaster Recovery & Resiliency

• Design, implement, and support high availability and disaster recovery solutions.
• Administer technologies including:
  • SQL Server Availability Groups
  • Log Shipping
  • Transactional Replication
  • Failover Cluster Instances
  • Azure-based DR architectures
• Validate and regularly test recovery procedures to ensure compliance with business RTO and RPO objectives.
• Manage enterprise backup, recovery, and retention strategies.

Azure Database Platform

• Architect, deploy, and support database solutions across:
  • Azure SQL Database
  • Azure SQL Managed Instance
  • SQL Server on Azure Virtual Machines
  • Azure Storage and backup services
• Assess existing workloads and develop migration strategies for cloud adoption and modernization.
• Implement and optimize Azure-native capabilities, including monitoring, security, Azure Elastic Jobs, Azure Automation Runbooks, and Cloud Shell automation.
• Partner with cloud engineering teams to ensure database platforms align with enterprise Azure standards and landing zone requirements.
• Plan, architect, and execute seamless database migrations from on-premises environments to Azure Cloud, as well as reverse migrations from Azure Cloud to on-premises environments.
• Perform performance and cost engineering to optimize cloud resource utilization across Azure SQL tiers.

Performance Engineering & Optimization

• Troubleshoot and resolve complex database and application performance issues.
• Partner with development teams to optimize schema design, indexing strategies, stored procedures, ETL processes, and application queries.
• Establish proactive performance monitoring and capacity planning practices.

Automation & Platform Engineering

• Automate operational processes using:
  • PowerShell
  • dbatools.io
  • Azure Automation
  • Git-based source control workflows
• Develop repeatable solutions that reduce manual effort and improve operational consistency.
• Support Infrastructure-as-Code and configuration management initiatives where applicable.
• Drive continuous improvement through scripting, self-service capabilities, and operational automation.

Monitoring, Observability & Capacity Management

• Proactively monitor database health, availability, capacity, and performance using enterprise monitoring platforms.
• Support and optimize tools such as:
  • OpsRamp
  • SQL Sentry
  • Azure Monitor
  • Log Analytics
• Identify trends and risks before they impact service delivery.
• Lead storage growth forecasting and capacity planning efforts.

Security, Compliance & Governance

• Implement database security best practices and regulatory controls.
• Partner with Information Security teams to address vulnerabilities, hardening standards, and remediation activities.
• Support audit requests and regulatory examinations as required.

Collaboration & Leadership

• Act as a trusted technical advisor to application, infrastructure, cloud, and security teams.
• Mentor junior DBAs and contribute to team knowledge sharing and technical development.
• Participate in architecture reviews and provide database design guidance for new initiatives.
• Develop and maintain operational runbooks, standards, procedures, and architecture documentation.

Required Qualifications

• 8+ years of SQL Server administration experience in large-scale enterprise environments.
• Deep expertise administering SQL Server 2016 through SQL Server 2025.
• Hands-on experience with:
  • Azure SQL Database
  • Azure SQL Managed Instance
  • SQL Server on Azure Virtual Machines
• Advanced troubleshooting skills across the database, operating system, storage, and network layers.
• Strong PowerShell scripting and automation experience.
• Experience with database monitoring and observability platforms.
• Strong understanding of cloud architecture, networking, and security principles.
• Excellent written and verbal communication skills.

Preferred Qualifications

• Experience with dbatools and large-scale SQL Server fleet administration.
• Familiarity with Infrastructure as Code concepts and tools.
• Experience supporting hybrid cloud environments.
• Experience with CI/CD pipelines and database DevOps practices.
• Exposure to Delphix, Redgate, or similar database lifecycle management platforms.
• Knowledge of Azure governance, landing zones, and enterprise cloud operating models.
• Financial services or highly regulated industry experience.
• Experience with PostgreSQL is a plus.
  • Implement PostgreSQL HA and DR strategies using WAL archiving, physical and logical streaming replication, and cross-region replication.
  • Expertise in PostgreSQL authentication, row-level security, role-based access control, pgAudit, logging, and automated compliance enforcement.
  • Good understanding of PostgreSQL extensions such as pgvector, pg_cron, and pg_stat_statements.

Keywords: SQL DBA PostgreSQL Azure CI/CD DevOps Delphix Redgate