Senior Database Architect, PostgreSQL Job in
- Intellect Design Arena
- 8 to 18 Yrs
- Chennai
- 2 months ago
- Email to a friend
- Report this job
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!,
Employement Category:
Employement Type: Full timeIndustry: IT Services & Consulting
Role Category: Not Specified
Functional Area: Not Specified
Role/Responsibilies: Senior Database Architect, PostgreSQL Job in
Contact Details:
Company: Intellect Design ArenaLocation(s): Chennai
+ View Contact
Keyskills: PostgreSQL Oracle RAC Database Architecture Data Modeling PLSQL Resource Management Disaster Recovery Communication Skills Leadership Skills SQLPlus SQL Developer SQLLoader
Fraud Alert to job seekers!
₹ Not Specified
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