Assistant Lead Engineer - SQL Database Administrator (Ref 26357a)

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)
. 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