[Remote] SQL Database Administrator
Note: The job is a remote job and is open to candidates in USA. Pacer Group is seeking an Aurora PostgreSQL Database Administrator for a contract role supporting Amazon Aurora PostgreSQL environments. The role focuses on database modernization and migration, including schema assessment, AWS DMS configuration, migration testing, data reconciliation, performance testing, and PostgreSQL tuning.
Responsibilities
- Plan and execute end-to-end database migrations to Aurora PostgreSQL
- Assess schemas, dependencies, data volumes, compatibility gaps, and migration risks
- Configure and troubleshoot AWS DMS Full Load and CDC
- Perform schema, SQL, procedure, trigger, index, and data-type conversions
- Conduct migration testing, data reconciliation, performance testing and cutover rehearsals
- Tune SQL queries, indexes, execution plans, statistics and PostgreSQL configuration
Skills
- Amazon Aurora PostgreSQL
- AWS DMS
- AWS SCT / DMS Schema Conversion
- Python / Bash / Shell / SQL
- Automated database deployment and validation
Benefits
- Medical
- Dental
- Vision
- 401(k)
Company Overview
Company H1B Sponsorship