Database Developer

Key Responsibilities:

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:

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

Infrastructure-as-Code (Terraform, CloudFormation)

DevOps practices and CI/CD pipelines

Agile methodologies

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

Knowledge of:

Container technologies (Docker, Kubernetes)

Database monitoring and observability tools

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