Assistant Lead Engineer - Database Developer / Administrator (Ref 26357)

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

Licence no: 12C6060

Pay: Up to $8,500.00 per month

Work Location: In person