- Perform deep-dive analysis of existing database schemas, code objects, and architecture

- Execute schema conversion from proprietary databases (MSSQL) to open-source platforms (PostgreSQL, Aurora)

- Develop and implement data migration strategies using AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT)

- Configure data replication and cutover strategies for seamless migration

- Collaborate with cross-functional teams including application developers, DevOps, and infrastructure teams

- Perform database performance tuning, optimization, and capacity planning

- Create technical documentation including architecture diagrams, migration runbooks, and IaC scripts

- Conduct database and application testing with new database engines

- Provide production deployment and cutover preparation assistance

Required Skills & Qualifications :

- Bachelor's degree in Computer Science, Information Technology, or related field

- 5+ years of strong experience in database administration and migration projects

- Proficient in :

Microsoft SQL Server (MSSQL)
PostgreSQL/Amazon Aurora PostgreSQL-Compatible Edition
Amazon RDS and database services on AWS
SQL query optimization and performance tuning
Database design principles and normalization
AWS Database Migration Service (DMS)
AWS Schema Conversion Tool (SCT)
Database backup, recovery, and high-availability configurations

- Strong understanding of :

Database architecture patterns
Data replication and synchronization
Failover and disaster recovery strategies
Database security and compliance requirements
ETL/ELT processes

Preferred Skills :

- Experience with :

1. AWS cloud services (RDS, Aurora, DMS, CloudFormation)

2. Infrastructure-as-Code (Terraform, CloudFormation)

3. DevOps practices and CI/CD pipelines

4. Agile methodologies

- SSIS/SSRS migration to AWS services (Glue, MWAA, Step Functions)

- Knowledge of :

1. Container technologies (Docker, Kubernetes)

2. Database monitoring and observability tools

3. Data governance and compliance frameworks

Soft Skills :

- Strong analytical and problem-solving abilities

- Excellent communication skills for technical and non-technical stakeholders

- Strong attention to detail and documentation skills

- Client-facing experience and stakeholder management