Database Administrator

Position:DBA

Location : Des Moines. Iowa

DBA – Job Description

Primary Responsibilities

• Lead database migration activities for SQL Server and other database platforms as part of a large-scale data center migration to AWS.

• Review and validate database discovery outputs, dependencies, clustering configurations, replication requirements, and migration readiness assessments.

• Define and execute database migration strategies, including rehost migrations to AWS EC2 and migrations to Amazon RDS where appropriate.

• Perform database compatibility assessments across SQL Server, Oracle, PostgreSQL, MySQL, and other supported database platforms.

• Establish and validate database replication, synchronization, backup, and recovery mechanisms using native tools and AWS migration services.

• Develop database migration runbooks, cutover procedures, rollback plans, and validation checklists for migration waves.

• Execute database migration testing, dry-run failovers, and production cutovers in accordance with approved migration plans.

• Validate database integrity, application connectivity, transaction consistency, and performance following migration activities.

• Serve as the primary database escalation point during migration and cutover events, troubleshooting replication, performance, connectivity, and configuration issues.

• Coordinate closely with client application teams, infrastructure teams, cloud architects, and migration resources to ensure successful migration execution.

• Support licensing compliance reviews, BYOL (Bring Your Own License) considerations, and database operational readiness activities.

• Participate in hypercare support, post-migration stabilization, and operational handoff activities.

Secondary Responsibilities

• Validate database readiness for each migration wave, including capacity planning, replication health, backup validation, and recovery testing.

• Support migration factory operations by providing database-specific guidance during wave planning and migration execution.

• Collaborate with application teams to identify database dependencies and support end-to-end migration testing activities.

• Optimize database performance and recommend remediation activities for migrated workloads running in AWS.

• Assist in implementing monitoring, alerting, backup, and operational support processes for migrated databases.

• Maintain migration documentation, database inventories, runbooks, SOPs, and knowledge repositories.

• Support automation initiatives related to database provisioning, migration, validation, and operational processes.

• Ensure adherence to security, compliance, and governance requirements throughout migration execution.

• Facilitate knowledge transfer and transition of migrated databases to operations and managed services teams.

Required Skills & Experience

• Strong hands-on experience administering Microsoft SQL Server (primary skill)

• Working knowledge of Oracle, PostgreSQL, MySQL, MongoDB, and Amazon RDS platforms

• Experience supporting large-scale data center, VMware, and cloud migration programs

• Expertise in SQL Server Always On Availability Groups, Failover Cluster Instances (FCI), Replication, Log Shipping, Backup & Recovery

• Experience with AWS Database Migration Service (DMS), Amazon EC2, Amazon RDS, CloudWatch, and migration tooling

• Strong database performance tuning, troubleshooting, and optimization skills

• Experience supporting production cutovers and wave-based migration execution models

• Familiarity with high-availability, disaster recovery, and failover architectures

• Excellent communication, stakeholder management, and documentation skills

• AWS and/or database certifications preferred

• Experience working in regulated or highly governed environments is a plus