Database Administrator

We are seeking a highly skilled and motivated Database Administrator (DBA) to join our dynamic team at Abacus. The ideal candidate will possess expertise in Oracle and PostgreSQL databases, along with a strong background in database replication, deployment, and cluster application architecture. This role requires an individual with excellent problem-solving skills, the ability to manage multi-terabyte datasets, and a proactive approach to database administration and project lifecycle management.

• →Manage and maintain Oracle and PostgreSQL databases, ensuring high performance, availability, and scalability.
• →Configure and manage database deployment, clustering, replication and load-balancing technologies to enhance performance.
• →Write and optimize complex queries and stored procedures for efficient data management.
• →Handle multi-terabyte datasets effectively, ensuring data integrity and security.
• →Implement and maintain database security, backup, and recovery strategies according to industry best practices.
• →Diagnose and resolve complex database issues, leveraging excellent problem-solving and analytical skills.
• →Oversee the full project lifecycle, including initiation, planning, execution, control, and closure, while maintaining technical excellence.
• →Provide daily production support and manage customer interface, proactively addressing issues to minimize downtime.
• →Prepare functional and technical specification documents to align with project requirements.
• →Manage and track ticket queues, ensuring compliance with SLAs, KPIs, and OLAs.
• →Ensure adherence to Software Quality Processes and project timelines, delivering quality results within deadlines.
• →Mentor and guide team members, fostering a collaborative and motivated work environment.
• →Act as the single point of contact between the team and project stakeholders, facilitating effective communication and resolution of issues.
• →Manage and optimize large data pipelines in a production support environment.

Requirements:

• →Must-Have Skills: Proficiency in Oracle and PostgreSQL, database replication, deployment, and cluster application architecture.
• →Minimum 3 years of experience in software development and database administration.
• →Experience with database clustering and load-balancing technologies is highly advantageous.
• →Knowledge of configuring active-active configuration for databases.
• →Strong knowledge of database security, backup, and recovery best practices.
• →Proven ability to manage multi-terabyte datasets in a production environment.
• →Expertise in writing queries and stored procedures.
• →Excellent problem-solving and analytical skills.
• →Strong organizational and leadership abilities to oversee project lifecycles and mentor team members effectively.
• →Familiarity with tracking and managing ticket queues, SLAs, KPIs, and OLAs.
• →Proven ability to prepare detailed functional and technical specification documents.
  

Immediate joining preferred