Job
Description
About the Role We are seeking an experienced Database Architect with deep expertise in PostgreSQL and Oracle RAC to lead our database architecture and operations. This is a senior level role that requires a hands-on professional who can design, optimise, and manage enterprise-grade database solutions while ensuring high availability, security, and performance. The ideal candidate will be responsible for leading a team, managing production support, and driving database optimisation strategies. Key Requirements Deep understanding of Oracle RAC, Standalone Databases, Primary vs. Standby Architectures (Physical & Logical), and Data Space Optimization. Experience in Application Performance Tuning, Oracle Architecture, and Data Modeling. Hands-on expertise in Oracle tools such as SQLPlus, SQL Developer, SQLLoader, Materialized Views, Explain Plan, SQLRT, SPM, and PL/SQL. Strong knowledge of Database Metrics collection & MIS Reporting. Proven experience in Resource Management, Task Assignment, and Technical Impact Analysis. Overall 18+ years of experience with 8+ years of strong PostgreSQL experience with expertise in database installation (Oracle 19c and above). Ability to handle Disaster Recovery (DR) drills and ensure robust recovery strategies. Familiarity with Change Log Management, Process Orientation, and Compliance Mandates. Strong communication and leadership skills to interact with cross-functional teams, clients, and stakeholders. Key Responsibilities Lead a team to provide support for business-as-usual (BAU) operations and production systems. Define and manage KRAs (Key Result Areas) for the team and oversee performance appraisals. Experience in preparing Support Rosters, planning for major activities like upgrades/EOY etc Ensure efficient task allocation, tracking, throughput management, conflict resolution, and attrition handling within the team. Design, implement, and maintain PostgreSQL and Oracle RAC architectures, ensuring scalability and reliability. Provide production support and resolve database-related issues while ensuring minimal downtime. Conduct database performance tuning, application tuning, and data model optimization. Plan and execute major activities such as database upgrades, end-of-year processing, disaster recovery (DR) drills, and migrations. Analyse AWR, ADDM, and SAR reports to optimize database performance. Implement and manage data security controls such as TDE (Transparent Data Encryption), Redaction, PII Masking, and other compliance-related mandates. Oversee database recovery, backup strategies, and troubleshooting of control file corruptions. Collaborate with internal project teams to provide tailored database solutions based on business needs. Represent the organization in client, bank, and auditor discussions to address database-related inquiries. Drive process improvements and service-level enhancements through automation and best practices. Why Join Us Lead cutting-edge database architecture initiatives in a dynamic product based organisation. Engage in strategic discussions and have a significant impact on the company's database infrastructure and performance. Competitive salary and benefits package with opportunities for growth. If you're a seasoned database architect with a passion for performance, scalability, and security, we'd love to hear from you! Apply now and be part of our journey toward innovation and excellence!,
