Database Administrator (DBA)

NAWe are seeking an experienced Database Administrator (DBA) with a strong background in PostgreSQL and knowledge of UPI PSP (Unified Payments Interface, Payment Service Provider) database schema to join our team. The ideal candidate will have in-depth experience in database management, optimization, and security, with a focus on supporting high-availability, transaction-heavy applications.

Key Responsibilities:
• Database Management & Maintenance:
• Administer, maintain, and optimize PostgreSQL databases to ensure high performance, reliability, and availability.
• Perform database tuning and troubleshooting to resolve issues with query performance, data integrity, and access.
• Database Design & Development:
• Collaborate with developers and architects to design database structures that support application requirements.
• Develop and maintain schemas, indexes, tables, views, and functions.
• Performance Monitoring & Optimization:
• Monitor database performance, identify bottlenecks, and implement optimization strategies.
• Regularly conduct database health checks, tuning, and maintenance tasks.
• Data Security & Compliance:
• Implement and manage database security, including user roles and permissions, to ensure data integrity and compliance with regulatory standards.
• Conduct regular security audits and backups to safeguard critical data.
• Database Migration & Version Control:
• Support database version upgrades, migrations, and the implementation of new features in PostgreSQL.
• Ensure database changes are documented, versioned, and tested to maintain stability.
• Backup & Disaster Recovery:
• Develop and execute backup and disaster recovery plans for critical data assets.
• Ensure regular backups, data replication, and failover strategies are in place.
• UPI PSP Schema Knowledge (Plus):
• Leverage knowledge of UPI PSP database schema and structure for financial or payment processing applications, optimizing database performance for transaction-heavy workloads.

Requirements

Must Have Skills (Non -Negotiable Core Competencies): Postgre SQL Database Administration, Replication, Master Slave Set Up, Failover Mechanism, Backup and Restore, Archive Policies, BFSI Exposure

Requirements:

Experience: 7+ years of experience as a Database Administrator, primarily with PostgreSQL.

Educational Qualifications:

Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).

Technical Skills:
• Proficiency in PostgreSQL database management, tuning, and optimization.
• Strong knowledge of SQL, PL/pgSQL, indexing, and query optimization.
• Experience in database security, access controls, and regulatory compliance.
• Familiarity with backup, disaster recovery, and high-availability strategies.

Nice-to-Have: Knowledge of UPI PSP (Unified Payments Interface, Payment Service Provider) database schema.

Soft Skills: Strong problem-solving skills, attention to detail, and the ability to collaborate with cross-functional teams.

Good to Have Skills: Sharding, Schema Design​

Salary: 18-1+ LakhsThis offer from "TalentXplore" has been enriched by Jobgether.com and got a 65% flex score.