Database Administrator

Paycom; Manassas (VA); On-site; USD 120,000 - 165,000; Full time

Job summary

Broadleaf Services seeks a senior Database Engineer to optimize SQL Server performance, tune T-SQL, and manage Azure SQL Managed Instances with automated backups and HA. You’ll steer migrations from on‑premise SQL Server and Oracle to Azure, handling discovery, rehearsal, cutover, and rollback planning while championing IaC for repeatable environments.

Responsibilities include securing data with modern IAM, building monitoring pipelines, and enabling AI-ready data pipelines with RAG-friendly

Qualifications

• Mastery of SQL Server internals, advanced T-SQL engineering, concurrency control, and relational database design.

Responsibilities

• Maintain core database health with SQL Server and T-SQL performance tuning.
• Architect and manage Azure SQL Managed Instances, sizing, backups, and HA configurations.
• Lead migrations from on-prem SQL Server (and Oracle) to Azure SQL MI.

Skills

SQL Server internals

T-SQL engineering

Azure SQL Managed Instances

Data platform migrations

Infrastructure as Code

DevOps & CI/CD

Security and IAM

Cloud networking (Azure)

Monitoring & telemetry

Vector AI / retrieval patterns

Tools

Git

CI/CD platforms

Terraform

Bicep/ARM

Azure CLI

PowerShell

Job description

Key ResponsibilitiesDatabase Engineering & Optimization: Maintain core database health with a deep focus on SQL Server and T-SQL performance tuning. Analyze execution plans, design advanced indexing strategies, manage statistics, resolve blocking/deadlocks, and proactively troubleshoot query regressions.Cloud Architecture & Lifecycle Management: Architect, provision, and maintain Azure SQL Managed Instances (MI). Define service tiers, calculate vCore/storage sizing, configure instances, and establish robust automated backup and restore testing procedures.Data Platform Migrations: Lead complex migration initiatives transferring workloads from on-premises SQL Server (and ideally Oracle) to Azure SQL MI. Own the entire lifecycle: dependency discovery, compatibility assessment, migration rehearsal, validation, cutover, and rollback planning.Infrastructure as Code & Automation: Treat database infrastructure as software. Utilize PowerShell, Azure CLI, Git, and Bicep/ARM or Terraform to construct repeatable, automated database environments and standard operations.Database DevOps Implementation: Establish database DevOps paradigms. Implement source-controlled schema changes, build CI/CD deployment pipelines, execute peer reviews, and orchestrate pre/post-deployment validation with clear rollback procedures.Cloud Security & Identity Management: Secure the data estate by enforcing least-privilege access using Microsoft Entra ID, database roles, and managed identities. Oversee secrets management, auditing, encryption, and regular privileged-access reviews.Telemetry & Operational Discipline: Design end-to-end monitoring using Azure Monitor and Log Analytics. Build query telemetry pipelines, establish proactive alerting, author runbooks, and manage capacity, service-level objectives (SLOs), and cost-to-performance ratios.Modern Data & AI Platform Awareness: Support AI-enabled enterprise applications by bridging the gap between database platforms and data pipelines. Provide foundational support for data governance, quality, metadata management, embeddings/vector search, and Retrieval-Augmented Generation (RAG) patterns, advising on when to integrate MI with specialized analytics or search engines.Required Skills and Qualifications:Core Database Expertise: Mastery of SQL Server internals, advanced T-SQL engineering, concurrency control, and relational database design.Azure Data Platforms: In-depth, practical experience managing Azure SQL Managed Instances and associated high-availability architectures.Cloud Networking: Strong command of Azure networking concepts, including VNets, subnets, DNS, custom routing, private connectivity, network security groups (NSGs), hybrid connectivity, and latency optimization.Automation & DevOps Tooling: Proven experience with Git, CI/CD platforms, and Infrastructure as Code frameworks (Terraform, Bicep, or ARM templates).Security Frameworks: Solid understanding of modern identity management, encryption at rest/in transit, and cloud auditing compliance.CompTIA Security+Ability to successfully pass a security screeningPreferred QualificationsProven track record of executing large-scale Oracle-to-Azure database migrations.Familiarity with vector databases, AI integration frameworks, and specialized big data analytics solutions.Broadleaf Services is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to disability or veteran status.