MegThink
Website:
megthink.com
Job details:
Position: PostgreSQL DBA - Database Administrator
Experience: 12+ Years (Primarily in PostgreSQL)
Location: Mumbai Dadar (Work from Office)
NP- serving to 15 days
Key Responsibilities:
1. 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.
2. 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.
3. Performance Monitoring & Optimization:
Monitor database performance, identify bottlenecks, and implement optimization
strategies.
Regularly conduct database health checks, tuning, and maintenance tasks.
4. 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.
5. 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.
6. 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.
7. 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:
Experience: 10-12+ years of experience as a Database Administrator, primarily with PostgreSQL.
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.
Educational Qualifications:
Bachelor’s degree in Computer Science, Information Technology, or a related field (or
equivalent experience).
Click on Apply to know more.