Job Description
We are seeking a Senior Database Developer with Oracle DBA expertise . This role focuses on MSSQL, Oracle, and PostgreSQL database programming. The engineer will work closely with Senior Application DBAs and application teams to manage and implement database deliverables, ensuring high-quality migration and development in cloud-managed environment.
This is a 2 years Direct Contract with Synapxe.
Role & Responsibilities
- Lead migration and conversion of on-premises and cloud databases (MSSQL, Oracle) to PostgreSQL on cloud-managed database services, ensuring seamless integration, data integrity, and minimal downtime.
- Design, develop, and optimise SQL queries, stored procedures, triggers, and functions in at least one of MSSQL, Oracle, or PostgreSQL, ensuring code meets performance, security, and coding standards.
- Diagnose and resolve performance bottlenecks related to query plans, indexing, I/O, and memory utilisation, implementing optimisation techniques tailored to cloud-managed platforms.
- Configure and manage cloud-managed database services across AWS and Azure, designing high availability, scalability, and disaster recovery strategies aligned to RPO/RTO objectives.
- Enforce database security policies including encryption, IAM roles, and least privilege access, and stay current with security threats and patches.
- Maintain migration runbooks, schema mappings, and conversion logic, and produce reports on migration progress, performance metrics, and cost optimisation.
- Communicate updates, risks, and technical findings clearly to both technical and business stakeholders.
Requirements
- 8–10 years of experience in database development and migration for MSSQL, Oracle, and PostgreSQL.
- 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 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, virtualisation) 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
Apply Now
NOTE: It only takes a few minutes to apply for a meaningful career in HealthTech - GO FOR IT!!