Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

ServIT Consulting LLC

NewBe an early applicant

SQL Database SME on AWS/Azure

Posted Updated

Description

SQL Database SME on AWS/Azure:

Location: On-site in Washington, DC

Experience: Must have a minimum of 10 years of related experience as a database administrator, specializing in supporting SQL environment.

Duties: Designs the database server architecture, to include installation, maintenance, and configuration. Performs troubleshooting and resolution management. Provide Support for advanced user jobs and analytics.

Job Description and Duties

  • Full‑time, on‑site position at DOT Headquarters, Washington, DC.
  • Provide in‑person support several days per week, with availability for either the early shift (starting 7:00 AM) or late shift (ending 7:00 PM) as needed.
  • Install, configure, and maintain enterprise‑level database platforms, including Microsoft SQL Server and supporting infrastructure across on‑premises and AWS and Azure Cloud environments.
  • Configure, manage, and optimize AWS and Azure Cloud SQL and Managed Instances (MI).
  • Plan and execute migrations of SQL databases from on‑premises to AWS and Azure Cloud (IaaS and PaaS).
  • Contribute to database architecture and capacity planning to ensure scalability, reliability, and security.
  • Design, implement, and maintain disaster recovery strategies for SQL environments targeting AWS and Azure Cloud.
  • Monitor the performance, integrity, and security of all database platforms and investigate anomalies.
  • Perform routine maintenance tasks: index optimization, statistics updates, and consistency checks.
  • Plan and perform upgrades, patching, and migrations for standalone and cloud‑hosted database servers.
  • Oversee and lead migration projects, including lift‑and‑shift and re-platforming efforts to AWS and Azure Cloud.
  • Manage database accounts, roles, and permissions according to least‑privilege and compliance requirements.
  • Audit database activity and maintain comprehensive logs of configuration and schema changes for compliance and forensics.
  • Implement encryption, secure connectivity (TLS/SSL), and other security controls for data at rest and in transit.
  • Maintain detailed, version‑controlled documentation for database environments, architecture diagrams, configurations, procedures, and runbooks.
  • Generate regular reports on performance, capacity growth, and usage trends for stakeholders.
  • Collaborate closely with development, infrastructure, and security teams to streamline deployments and accelerate incident resolution.
  • Mentor DBAs on AWS and Azure Cloud practices, establish operational best practices, and contribute to automation initiatives.
  • Demonstrated success managing enterprise database environments in hybrid (on‑premises) and AWS and Azure Cloud settings.
  • Proven expertise in planning and executing cloud migration projects; hands‑on experience with AWS and Azure Cloud Platform is a strong plus.

Required Education and Experience:

  • SQL Server and AWS or Azure Cloud Certified.
  • Hands on migrating Always-on and SQL Cluster to Azure and AWS Cloud.
  • Strong expertise in SQL Server administration both on‑premises and in AWS and Azure Cloud environments.

· In‑depth knowledge and hands‑on experience in SQL Migration on Cloud, SQL Server installation, configuration, optimization, and ongoing maintenance.

· Proven ability to manage SQL Server instances (versions 2022, 2019, 2017, 2016, 2014, 2012) across multiple platforms, including VMware, AWS and Azure Cloud (IaaS/PaaS), and on‑premises infrastructure.

· Capability to troubleshoot performance issues, analyze execution plans, and implement database performance optimizations.

  • Experience implementing database security solutions, such as Transparent Data Encryption (TDE) and SSL/TLS for secure data transmission.
  • Hands‑on experience migrating SQL clusters to AWS and Azure Cloud, including assessment of client requirements and providing detailed technical recommendations.
  • Ability to participate in on‑call rotations and perform mandatory monthly maintenance tasks

Preferred skills and qualifications:

· Full‑time, on‑site position at DOT Headquarters, Washington, DC.

· Provide in‑person support several days per week, with availability for either the early shift (starting 7:00 AM) or late shift (ending 7:00 PM) as needed.

· Install, configure, and maintain enterprise‑level database platforms, including Microsoft SQL Server and supporting infrastructure across on‑premises and AWS and Azure Cloud environments.

· Configure, manage, and optimize AWS and Azure Cloud SQL and Managed Instances (MI).

· Plan and execute migrations of SQL databases from on‑premises to AWS and Azure Cloud (IaaS and PaaS).

· Contribute to database architecture and capacity planning to ensure scalability, reliability, and security.

· Design, implement, and maintain disaster recovery strategies for SQL environments targeting AWS and Azure Cloud.

· Monitor the performance, integrity, and security of all database platforms and investigate anomalies.

· Perform routine maintenance tasks: index optimization, statistics updates, and consistency checks.

· Plan and perform upgrades, patching, and migrations for standalone and cloud‑hosted database servers.

· Oversee and lead migration projects, including lift‑and‑shift and re-platforming efforts to AWS and Azure Cloud.

· Manage database accounts, roles, and permissions according to least‑privilege and compliance requirements.

· Audit database activity and maintain comprehensive logs of configuration and schema changes for compliance and forensics.

· Implement encryption, secure connectivity (TLS/SSL), and other security controls for data at rest and in transit.

· Maintain detailed, version‑controlled documentation for database environments, architecture diagrams, configurations, procedures, and runbooks.

· Generate regular reports on performance, capacity growth, and usage trends for stakeholders.

· Collaborate closely with development, infrastructure, and security teams to streamline deployments and accelerate incident resolution.

· Mentor DBAs on AWS and Azure Cloud practices, establish operational best practices, and contribute to automation initiatives.

· Demonstrated success managing enterprise database environments in hybrid (on‑premises) and AWS and Azure Cloud settings.

· Proven expertise in planning and executing cloud migration projects; hands‑on experience with AWS and Azure Cloud Platform is a strong plus.

Skills

Apply

See also