Vice President- Database Architect
- Intellect Design Arena
- 18 - 22 years
- Chennai
- 2 months ago
- Email to a friend
- Report this job
Job Description
About the RoleWe are seeking a Senior 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, optimize, 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 optimization 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.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Database Architect / Designer
Employement Type: Full time
Contact Details:
Company: Intellect Design ArenaLocation(s): Chennai
Keyskills: Database architecture ADDM TDE performance tuning PostgreSQL Oracle RAC architectures AWR application tuning MIS Reporting
Similar positions
Intellect Design Arena
Intellect Design Arena Ltd, a specialist in applying true digital technologies, is the worlds first full spectrum Banking and Insurance technology products company, across Global Consumer Banking, Central Banking, Global Transaction Banking (iGTB), Risk, Treasury and Markets, and Insuran...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in