Database Engineer

Job Description - Database Engineer (2500000K)

Responsibilities

• Manage databases by administering, installing, configuring, upgrading, and patching.
• Monitor and optimize database performance, utilizing advanced skills in database tool usage including capacity planning with a detailed analysis and recommendation.
• Perform database backup and complex recovery.
• Troubleshoot and recover from complex database issues.
• Automate routine tasks using scripts and open-source tools.
• Provide strong technical assistance and advice to application teams.
• Co-ordinate with internal IT and escalate to vendors for timely response/recovery.
• Gather requirements, design business and technical aspects, develop, test, implement, and write queries, stored procedures, cursors, triggers, and scripts in open-source database technologies.

Qualifications

• Minimum requirement of 8-9 years of experience in database administration, encompassing installation, configuration, backup/recovery, database tuning, and support for application design and development.
• Proficiency in physical database modelling, information engineering, multi-tier design and development, and open systems.
• Demonstrated knowledge and experience in database high availability and disaster recovery techniques and concepts.
• Experience in performance analysis (IO, CPU, etc.) and optimization (indexes, partitions, schema re-design, etc.).
• Familiarity with geo-redundant database architectures (Always-On, Active/Active, Master/Master, etc.) is advantageous.
• Relevant experience with EDB Postgres, MongoDB, Oracle, and SQL Server is preferred.
• Good interpersonal, analytical, and problem-solving skills.
• Strong communication skills and ability to work independently with minimal supervision.