Assistant Lead Engineer - Database Developer

Job Details

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 ##

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

Not Mentioned - Not Mentioned - Not Mentioned - Age: 14-60 ## Skills - AWS DMS - Azure SQL Database - Azure Database for PostgreSQL - CI CD pipelines ##

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

How to Apply

Apply on NCS: | Email: info@foundit.in | Phone: 8069857811