SQL Database SME on AWS/Azure
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
Sign in to read and join the discussion.