Database Administrator

Webmobril Technologies; New Delhi; On-site; INR 700,000 - 1,200,000; Full time

Job summary

Webmobril Technologies in Delhi is seeking an experienced Database Administrator with strong PostgreSQL and MySQL expertise to manage, optimize, and secure critical databases. You will ensure high availability, implement disaster recovery, and support performance across multiple environments.

You will collaborate with application developers and operations teams to implement backups, migrations, partitioning, monitoring, and SQL optimization, while upholding security and best practices for robust

Qualifications

• Minimum 5 years of experience in database administration.
• Strong hands-on PostgreSQL and MySQL management.
• Understanding of database concepts, architecture, and development practices.
• Experience in installation, configuration, upgrades, patching, and migrations.
• Knowledge of replication, clustering, HA, and DR.
• Performance tuning, query optimization, and troubleshooting.
• Backup and recovery strategies and deployment processes.
• SQL, stored procedures, functions, triggers, and partitioning.
• Security, access control, and user privileges management.
• Experience with monitoring tools and OS performance analysis.
• Strong analytical, problem-solving, and collaborative skills.

Responsibilities

• Install, configure, upgrade, monitor, and manage PostgreSQL and MySQL instances in standalone and clustered environments.
• Patch, replicate, ship logs, and migrate databases.
• Monitor performance, stability, capacity, and availability using tools.
• Tune performance and optimize queries.
• Design and maintain HA, clustering, and DR solutions.
• Manage security, access rights, and authentication.
• Develop documentation, standards, and administration guidelines.
• Design and optimize physical structures, including partitioning.
• Write and optimize SQL, stored procedures, functions, and triggers.
• Manage deployment of database objects with backups before deployment.
• Maintain backup, restore, and recovery procedures for data integrity.
• Provide operational support for mission-critical DB systems.
• Collaborate with development teams on design, security, and performance.
• Provide guidance and mentoring on PostgreSQL and MySQL DB management.
• Identify bottlenecks and implement tuning recommendations.

Skills

PostgreSQL

MySQL

Database Administration

Performance Tuning

High Availability

Disaster Recovery

Education

B.E./B.Tech./MCA in CS/IT or equivalent

Job description

JOB DESCRIPTION DATABASE ADMINISTRATOR (POSTGRESQL / MYSQL)

Job Title: Database Administrator Experience: Minimum 3 Years Qualification: B.E./B.Tech. in Computer Science/Information Technology, MCA, or equivalent/higher qualification from a recognized university Required Skills: PostgreSQL, MySQL, Database Administration, Performance Tuning, High Availability, Disaster Recovery

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.