Responsibilities

Lead migration and conversion of on-premises / cloud databases (MSSQL, Oracle) to PostgreSQL on cloud-managed database services
Design, develop, and optimize SQL queries, stored procedures, triggers, and functions in at least one of: MSSQL, Oracle, or PostgreSQL
Collaborate with application teams to ensure seamless integration, data integrity, and minimal downtime during migrations
Ensure database code meets performance, security, and coding standards
Diagnose and resolve performance bottlenecks (query plans, indexing, I/O, memory utilization)
Implement indexing strategies, partitioning, and query optimization techniques tailored to MSSQL, Oracle, or PostgreSQL on cloud-managed platforms
Monitor and fine-tune performance post-migration using native cloud tools
Configure and manage cloud-managed database services across AWS and Azure for MSSQL, Oracle, and PostgreSQL workloads
Implement backup, recovery, and disaster recovery strategies aligned to RPO/RTO objectives
Design and support high availability and scalability patterns
Enforce security (encryption, IAM roles, least privilege) and governance best practices
Maintain migration runbooks, schema mappings, and conversion logic
Produce reports on migration progress, performance metrics, and cost optimization
Communicate updates and risks clearly to stakeholders
Implement database security policies and access controls
Stay current with security threats and apply patches/updates as needed

Requirements

Bachelor’s degree in computer science or a related field with 8–10 years of experience in database development and migration for MSSQL, Oracle, and PostgreSQL
Must have hands-on experience as a database developer with strong skills in SQL programming
Proficiency in SQL, T-SQL, PL/SQL, and scripting languages
Strong understanding of database design principles
Experience with database performance tuning and optimization
Knowledge of database security and compliance requirements
Exposure to database administration tasks on MSSQL, Oracle, or PostgreSQL is preferable
Excellent problem-solving and troubleshooting skills
Ability to work independently and collaboratively in a team
Effective communication and documentation skills
Proven experience in database conversion from MSSQL and Oracle to PostgreSQL in cloud environments
Strong knowledge of database architecture, design principles, and performance tuning
Hands-on experience with cloud-managed database services (AWS RDS/Aurora, Azure SQL Database, Azure Database for PostgreSQL)
Experience with data migration and movement tools, including on-premises database tools (e.g., Backup utilities, Data Pump) and cloud services (e.g., AWS DMS, AWS Glue, AWS Athena)
Familiarity with DevOps tools and automation for database deployments (PowerShell, Git, CI/CD pipelines)
Understanding of cloud infrastructure components (networking, load balancers, virtualization) and commercial cloud platforms (AWS, Azure)
Experience supporting high-availability production systems in cloud environments is advantageous
Software development experience in any programming language is a plus
Strong analytical and critical thinking skills with a service excellence attitude
Ability to work independently and collaboratively with Senior Application DBAs and application teams
Excellent verbal and written communication skills for interaction with technical and business stakeholders
Certifications in MSSQL, Oracle and PostgreSQL database developer
Experience with cloud-based database services (e.g., AWS RDS, Azure Database)
Experience on database migration and replication technologies

Shortlisted candidates will be offered a 1 Year agency contract employment.