[Hiring] Senior SQL Database Administrator / AWS Aurora Migration Engineer @Zolon Tech Inc.

Role Description

Zolon Tech Inc. is seeking an experienced Senior SQL Database Administrator (DBA) / AWS Aurora Migration Engineer to support the migration of the Armed Forces Public Information Management System (AFPIMS) from its existing on-premises infrastructure to the Amazon Web Services (AWS) Cloud environment. The selected candidate will be responsible for assessing, planning, migrating, configuring, securing, optimizing, and maintaining the AFPIMS Microsoft SQL Server databases as part of the transition to AWS Aurora.

The DBA will play a critical role in ensuring the successful migration of database systems supporting thousands of Department of Defense (DoD) websites hosted through the AFPIMS platform.

The position requires extensive experience with:

• Microsoft SQL Server administration
• Database migrations
• AWS database services
• Data integrity
• Performance optimization
• Security compliance
• Disaster recovery

Important Technical Consideration: AWS Aurora does not provide a native Microsoft SQL Server engine. The selected DBA must assess compatibility and support the conversion of existing SQL Server databases to an approved Aurora engine, such as Aurora PostgreSQL, including necessary schema, stored procedure, and application changes. The DBA will work closely with the AFPIMS Development Team to ensure application compatibility.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related technical discipline, or equivalent professional experience.
• Minimum 8–10 years of experience administering enterprise Microsoft SQL Server environments.
• Minimum 3 years of experience supporting AWS cloud database environments or comparable cloud database migrations.
• Demonstrated experience migrating Microsoft SQL Server databases to PostgreSQL or another non-SQL Server database platform.
• Experience supporting enterprise applications in production environments.
• Experience with large-scale database migrations and complex application dependencies.
• Experience supporting DoD, federal government, or similarly regulated environments.

Requirements

• Expert proficiency in Microsoft SQL Server Administration
• Expert proficiency in SQL Server Database Migration
• Advanced proficiency in AWS Aurora PostgreSQL
• Advanced proficiency in AWS Database Migration Service (DMS)
• Advanced proficiency in AWS Schema Conversion Tool (SCT)
• Expert proficiency in SQL Server T-SQL
• Advanced proficiency in PostgreSQL / PL/pgSQL
• Advanced proficiency in Database Performance Tuning
• Advanced proficiency in Database Backup and Recovery
• Intermediate proficiency in AWS CloudWatch Monitoring
• Intermediate proficiency in AWS IAM and KMS
• Advanced proficiency in Database Security and Encryption
• Advanced proficiency in SQL Server to PostgreSQL Schema Conversion
• Advanced proficiency in Database Replication and CDC
• Advanced proficiency in Database Disaster Recovery
• Intermediate proficiency in PowerShell / Python Scripting
• Intermediate proficiency in NIST SP 800-53 / DoD Security Requirements

Location

Remote

Clearance

DoD active Secret