Senior Lead / Associate Architect - Oracle,Postgresql

Newt Global; Navalur; On-site; INR 3,500,000 - 7,500,000; Full time

Job summary

Newt Global is seeking a Senior Lead / Associate Architect - Oracle Database Architect in Chennai to drive large-scale database solutions. The role requires 9+ years of Oracle DB experience, architecture design, performance tuning, migration, and high-availability initiatives.

You will lead migrations and upgrades, implement RAC/ASM/Data Guard/GoldenGate, mentor engineers, and collaborate with development teams and clients to deliver scalable, secure database platforms.

Qualifications

• 9+ years of Oracle database experience.
• Expertise in Oracle 11g/12c/19c.
• Hands-on SQL, PL/SQL, and database design.
• Shell scripting experience on Linux/Unix.
• Oracle Database Migration and Upgrade experience.
• Experience with Data Guard, GoldenGate, RAC, ASM, RMAN.
• Database performance tuning and query optimization.
• Data modeling and database architecture.
• Strong client-facing and stakeholder management skills.
• Team leadership and project delivery experience.

Responsibilities

• Design, develop, and maintain enterprise-grade Oracle database solutions.
• Create and review database architecture, data models, schemas, and database standards.
• Collaborate with application development teams on database design and performance optimization.
• Lead Oracle database migration, consolidation, and upgrade initiatives.
• Develop automation solutions using Shell Scripting (Linux/Unix).
• Implement and manage Oracle RAC, ASM, Data Guard, and GoldenGate environments.
• Analyze SQL queries and optimize database performance.
• Ensure database scalability, availability, security, and disaster recovery readiness.
• Mentor database engineers and provide architectural guidance.
• Work directly with clients and stakeholders to understand business requirements and propose database solutions.

Skills

Oracle Database

SQL & PL/SQL

Shell Scripting

Database Migration

Oracle RAC/ASM

Data Guard

GoldenGate

Data Modeling

Data Architecture

Leadership

Stakeholder Management

Tools

RMAN

Oracle GoldenGate Tool

Oracle Data Guard

Job description

Job Title: Senior Lead / Associate Architect - Oracle Database Architect

Department: Engineering / Database Development & Architecture
Experience: 9-15 Years
Location: Chennai

Job Description

We are looking for an experienced Senior Lead / Associate Architect - Oracle Database Architect with 9+ years of experience in Oracle database development, architecture, performance tuning, migration, and high-availability solutions. The ideal candidate should have strong expertise in designing scalable database solutions, supporting application development teams, optimizing database performance, and leading enterprise database transformation initiatives.

Key Responsibilities

• Design, develop, and maintain enterprise-grade Oracle database solutions.
• Create and review database architecture, data models, schemas, and database standards.
• Collaborate with application development teams on database design and performance optimization.
• Lead Oracle database migration, consolidation, and upgrade initiatives.
• Develop automation solutions using Shell Scripting (Linux/Unix).
• Implement and manage Oracle RAC, ASM, Data Guard, and GoldenGate environments.
• Analyze SQL queries and optimize database performance.
• Ensure database scalability, availability, security, and disaster recovery readiness.
• Mentor database engineers and provide architectural guidance.
• Work directly with clients and stakeholders to understand business requirements and propose database solutions.

Required Skills

• 9+ years of Oracle Database experience.
• Strong expertise in Oracle 11g/12c/19c.
• Hands-on experience in SQL, PL/SQL, and database design.
• Strong Shell Scripting experience (Linux/Unix).
• Oracle Database Migration and Upgrade experience.
• Expertise in Data Guard, GoldenGate, RAC, ASM, and RMAN.
• Database Performance Tuning and Query Optimization.
• Experience in Data Modeling and Database Architecture.
• Strong client-facing and stakeholder management skills.
• Team leadership and project delivery experience.