Cloud Database Architect

Newt Global Consulting, LLC; Chennai District; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

Newt Global Consulting, LLC is seeking a candidate experienced in End-End Migrations to join their Internal Product Engineering Team. This hybrid role involves leading migrations from Oracle and MS SQL Server to PostgreSQL, designing secure databases, and optimizing queries.

Qualified candidates should have robust experience with Anaplan model building and Data Hub design while being adept at collaborating with cross-functional teams.

Qualifications

• Strong hands-on experience in Anaplan model building (modules, lists, actions, UX dashboards).
• Experience in Data Hub design and data integration.
• Good understanding of ALM (Dev/Test/Prod deployments).
• Knowledge of PLANS & DISCO modeling best practices.

Responsibilities

• Lead large-scale Oracle & MS SQL Server to PostgreSQL migrations.
• Design secure, scalable database architectures ensuring high performance.
• Perform query optimization and implement performance tuning.
• Collaborate with cross-functional teams and manage HA/DR strategies.

Skills

Anaplan model building

Data Hub design and data integration

ALM (Dev/Test/Prod deployments)

PLANS & DISCO modeling best practices

Tools

AWS DMS

Ora2Pg

Azure DMS

PL/pgSQL

Python

Shell

Bash

Job description

Requirement - End-End Migrations experience candidate

Project - Internal Product Engineering Team

Work Mode - Hybrid (3 days WFO)

Shift Timing - General (11 AM to 8 PM)

Key Responsibilities

• Lead large-scale Oracle & MS SQL Server to PostgreSQL migrations, including cloud modernization on AWS, Azure, or GCP, by defining optimal strategies (rehost, replatform, refactor).
• Design secure, scalable database architectures ensuring high performance, data integrity, and minimal downtime during migrations.
• Perform query optimization, convert PL/SQL/T-SQL to PL/pgSQL, and implement performance tuning, indexing, and partitioning.
• Collaborate with cross-functional teams, manage HA/DR and backup strategies, and leverage migration tools (AWS DMS, Ora2Pg, Azure DMS) while mentoring teams and enforcing best practices.

Required Skills

• Strong hands-on experience in Anaplan model building (modules, lists, actions, UX dashboards)
• Experience in Data Hub design and data integration
• Good understanding of ALM (Dev/Test/Prod deployments)
• Knowledge of PLANS & DISCO modeling best practices

Good to Have Skills

• Understanding of PL/PGSQL, Schema & Code Conversion, Oracle to PGSQL Migrations, On-Prem to Cloud Migrations, Any Scripting language like (Python / Shell / Bash)

Certifications

• AWS / AZURE are added advantages

Customer Handling

• Handling US / Europe based customers, Creating POC / Project Estimations