DBA Architect Data Analytics and ETL

Educational Requirements

Bachelor of Engineering, Bachelor Of Technology, Master Of Technology, Master Of Engineering

Service Line

Engineering Services

Responsibilities

• Experience: 11-15 Years
• Location: Hyderabad, Chennai, Bangalore
• 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.

Technical and Professional Requirements:

• 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
• Data Quality & Validation Frameworks
• Data Analytics & BI
• SQLPL/SQL
• Stored Procedures & Functions
• Stakeholder Management

Preferred Skills:

• Technology->ETL & Data Quality->ETL - Others
• Technology->Data Services Testing->Data Warehouse Testing
• Technology->Database->Database- ALL
• Technology->Database Administration->PostGreSQL->PostGreSQL