Database Administrator at Broadleaf Services Inc

Broadleaf Services Inc; Manassas (VA); Vor Ort; USD 120.000 - 170.000; Vollzeit

Zusammenfassung

Broadleaf Services Inc. in Manassas, VA is seeking a Database Administrator for a full-time, on-site role. The candidate will maintain SQL Server health, tune queries, and work with Azure SQL Managed Instances to ensure high availability and performance.

The role also covers infrastructure as code, CI/CD pipelines, security reviews, monitoring, and data migrations from on-premises SQL Server to Azure SQL MI, with emphasis on reliability and cost efficiency.

Qualifikationen

• Mastery of SQL Server internals and T-SQL performance tuning.
• Experience managing Azure SQL Managed Instances and HA architectures.
• Strong knowledge of Azure networking, VNets, DNS, and private connectivity.
• Proven automation experience with IaC and CI/CD pipelines.
• Understanding of cloud security, encryption, and auditing.

Aufgaben

• Maintain core database health and performance tuning for SQL Server.
• Architect, provision and manage Azure SQL MI environments.
• Lead migrations from on-premises SQL Server to Azure SQL MI.
• Develop IaC and automated deployment workflows with IaC tools.
• Implement DB DevOps practices with version-controlled schemas and pipelines.
• Enforce least-privilege access and manage secrets and encryption.
• Design end-to-end monitoring and alerting for databases.
• Support AI-enabled data initiatives and data governance.

Kenntnisse

SQL Server internals

Azure SQL MI

Cloud networking

DevOps practices

Security & auditing

Security+

Tools

Git

CI/CD tools

Terraform

Bicep/ARM

Azure CLI

Jobbeschreibung

Apply for Database Administrator at Broadleaf Services Inc in Manassas, VA, US. This Full time on site position offers great opportunities for career growth.

Key Responsibilities

• Database 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 screening.

Preferred Qualifications

• Proven 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.