DBA Architect (Oracle/PostgreSQL) – Data Analytics & ETL

Job description

**ABOUT THE ROLE** We are seeking an experienced **DBA Architect** with deep expertise in **Oracle and PostgreSQL database architecture, data engineering, ETL solutions, and enterprise analytics platforms** . The ideal candidate will lead the design, modernization, optimization, and governance of enterprise-scale data ecosystems while driving database, ETL, and analytics strategies aligned with business objectives. This role requires strong technical leadership, architectural vision, and stakeholder management capabilities to deliver scalable, secure, and high-performing data platforms. **RESPONSIBILITIES** - Define and drive enterprise database, data warehouse, ETL, and analytics architecture roadmaps. - Design and implement highly available, secure, and scalable Oracle and PostgreSQL database solutions. - Architect enterprise data warehouses, data lakes, and modern data platforms to support business intelligence and analytics requirements. - Lead database modernization, migration, and cloud transformation initiatives. - Design ETL and data integration frameworks for batch and real-time data processing. - Establish database governance, security, auditing, compliance, and data lifecycle management standards. - Drive performance tuning, capacity planning, optimization, and high-availability strategies across enterprise environments. - Provide technical leadership to DBA, Data Engineering, ETL, and Analytics teams across multiple projects. - Lead architecture reviews, solution governance, and implementation of industry best practices. - Collaborate with business stakeholders to define data strategies, KPI frameworks, and analytics solutions. - Ensure robust backup, disaster recovery, business continuity, and data protection mechanisms. - Drive innovation through automation, modernization programs, and cloud-native data platform adoption. **QUALIFICATIONS** - **Experience:** 10–15+ years of experience in Database Architecture, Data Engineering, and Analytics. - **Location:** Bangalore, Chennai, Hyderabad. - **Education:** B.E./B.Tech in Computer Science, Information Technology, or equivalent. - Minimum 10+ years of hands-on experience in enterprise database and data platform technologies. - Minimum 5+ years of experience in Architecture or Technical Leadership roles. - Proven experience designing large-scale OLTP, OLAP, Data Warehouse, and Analytics platforms. - Experience leading enterprise database modernization, migration, and transformation initiatives. **REQUIRED SKILLS** **Database Architecture** - Oracle Database Architecture (12c/19c/21c) - PostgreSQL Architecture & Administration - Oracle RAC - Data Guard - ASM - Exadata - PostgreSQL High Availability & Replication - Database Clustering - Capacity Planning & Performance Engineering - Database Security, Auditing & Compliance - Backup, Recovery & Disaster Recovery Solutions - Business Continuity Planning - Database Governance & Data Lifecycle Management - Large-Scale OLTP & OLAP Architecture **ETL & Data Engineering** - Enterprise ETL Architecture - Data Integration Frameworks - Informatica - Talend - SSIS - DataStage - Enterprise Data Warehouse Design - Kimball & Inmon Methodologies - Batch & Real-Time Data Processing - Data Lake & Lakehouse Architectures - Metadata Management - Data Lineage - Data Quality & Validation Frameworks **Data Analytics & BI** - Analytics Platform Architecture - Enterprise Reporting Solutions - Data Modeling & Information Management - KPI Framework Design - Executive Dashboards - Data Visualization & Storytelling - Predictive Analytics - Business Intelligence Solutions - Large-Scale Data Analysis & Optimization **Technical Expertise** - SQL - PL/SQL - Stored Procedures & Functions - Advanced Query Optimization - Performance Tuning & Optimization - Solution Architecture & Governance - Stakeholder Management - Technical Leadership **PREFERRED SKILLS** - AWS Data Services - Azure Data Services - Google Cloud Platform (GCP) - Snowflake - Databricks - Power BI Architecture - Tableau Architecture - Python - Shell Scripting - DevOps & CI/CD for Data Platforms - Data Governance & Master Data Management (MDM) - AI/ML Data Platforms - Enterprise Migration & Modernization Programs - Cloud-Native Data Engineering Solutions