Database Administrator - SQL/PostgreSQL

Job Description :

Database Administrator (DBA) to manage and optimize our database systems. The ideal candidate will be proficient in PostgreSQL, SQL, and MongoDB, with a solid understanding of relational database management systems (RDBMS), database security, optimization, and disaster recovery strategies. This role will play a key part in ensuring database integrity, performance, security, and scalability.

Key Responsibilities :

Database Administration :

• Design, implement, and manage PostgreSQL, SQL, and MongoDB databases.

• Configure and maintain RDS (Relational Database Service) instances and related cloud-based database solutions.

Performance Optimization & Monitoring :

• Monitor database health, performance, and capacity planning.

• Optimize queries, indexing, and database structures to improve efficiency.

• Implement database monitoring tools for proactive issue detection and resolution.

Security & Compliance :

• Ensure PostgreSQL/RDBMS security best practices are followed.

• Manage user roles, permissions, encryption, and access controls.

• Conduct regular security audits to safeguard sensitive data.

Disaster Recovery & Backup :

• Develop and implement backup and recovery strategies to ensure data availability.

• Plan and test disaster recovery procedures for business continuity.

Database Development & Support :

• Assist in schema design, indexing, and data migrations.

• Support development teams in query optimization and database-related troubleshooting.

• Ensure database upgrades, patches, and maintenance are executed efficiently.

Requirements :

• Proficiency in PostgreSQL and SQL (strong query writing, performance tuning).

• Proficiency in MongoDB, including experience in NoSQL data structures.

• Good understanding of RDS (AWS RDS, Azure SQL Database, etc.).

• Strong knowledge of PostgreSQL/RDBMS security mechanisms (roles, privileges, encryption).

• Experience with database performance tuning, indexing, and monitoring tools.

• Expertise in backup and disaster recovery planning.

• Ability to work with large-scale database architectures and troubleshoot performance issues.

• Experience with cloud-based database solutions (AWS, Azure) is a plus.

• Familiarity with scripting languages (Python, Bash) for automation is a plus.