Database Administrator

JOB DESCRIPTION DATABASE ADMINISTRATOR (POSTGRESQL / MYSQL)

Job Title:

1. Job Summary

We are looking for an experienced Database Administrator with strong expertise in PostgreSQL and MySQL database administration, performance optimization, security, backup and recovery, and high-availability solutions. The candidate will be responsible for managing database environments, ensuring system stability and availability, optimizing database performance, and providing technical support to application development and project teams.

2. Roles and Responsibilities

• Install, configure, upgrade, monitor, and manage multiple PostgreSQL and MySQL database instances in standalone and clustered environments.
• Perform database server patching, replication setup, log shipping, and database migrations.
• Monitor database performance, stability, capacity, and availability using appropriate monitoring tools.
• Perform database performance tuning and query optimization by analyzing database and operating system performance.
• Design, implement, and maintain high-availability (HA), database clustering, and disaster recovery (DR) solutions.
• Manage database security, user access rights, permissions, and authentication mechanisms.
• Develop and maintain database definitions, structures, documentation, standards, and administration guidelines.
• Design and optimize physical database structures, including advanced database features such as partitioning.
• Write, review, and optimize SQL queries, stored procedures, functions, and triggers.
• Manage database object deployments and ensure all required database objects are backed up before deployment.
• Implement and maintain database backup, restoration, and recovery procedures to ensure data integrity and business continuity.
• Provide operational support for mission-critical and high-availability database systems.
• Collaborate with application development teams on database design, security, query optimization, and performance improvement.
• Provide technical guidance, assistance, and mentoring to project team members on PostgreSQL and MySQL database management.
• Identify database performance bottlenecks and implement appropriate tuning and optimization recommendations.
• Ensure database reliability, scalability, security, and compliance with organizational standards.

3. Required Skills and Qualifications

• Minimum 5 years of experience in database administration.
• Strong hands-on experience with PostgreSQL and MySQL database management.
• Good understanding of database concepts, architecture, and development practices.
• Experience in database installation, configuration, upgrades, patching, and migrations.
• Knowledge of database replication, clustering, high availability, and disaster recovery.
• Hands-on experience in database performance tuning, query optimization, and troubleshooting.
• Experience in backup and recovery strategies and database object deployment.
• Knowledge of SQL, stored procedures, functions, triggers, and database partitioning.
• Understanding of database security, access control, and user privilege management.
• Experience with database monitoring tools and operating system performance analysis.
• Strong analytical, problem-solving, communication, and collaboration skills.
• Ability to support mission-critical database environments and work effectively with cross-functional teams.

4. Educational Qualification

B.E./B.Tech. in Computer Science, Information Technology, MCA, or an equivalent or higher qualification from a recognized university.