Database Administrator

Job Description

The ideal candidate will be responsible for the installation, configuration, maintenance, and performance tuning of our databases, ensuring their availability, reliability, and security.

Key Responsibilities:

· Install, configure, and maintain Oracle and PostgreSQL databases.

· Perform database backups, restores, and disaster recovery operations.

· Monitor database performance and optimize queries and indexes for improved performance.

· Analyze and resolve performance issues through query optimization, indexing, and tuning.

· Implement and monitor database performance metrics and alerts.

· Conduct regular database health checks and performance reviews.

· Ensure database security through user management, access control, and encryption.

· Implement and enforce database security policies and compliance requirements.

· Monitor and audit database activities to detect and respond to security threats.

· Apply patches, updates, and upgrades to databases and related systems.

· Manage database migrations and version upgrades with minimal downtime.

· Develop and maintain documentation for database configurations, procedures, and policies.

· Provide technical support and troubleshooting for database-related issues.

· Collaborate with development and operations teams to resolve database-related problems.

· Participate in on-call rotation and respond to critical incidents as needed.

· Design and implement robust backup and recovery strategies for databases.

· Test and validate backup and recovery procedures to ensure data integrity and availability.

· Monitor backup processes and address any issues related to backup failures.

Qualifications and Preferred Skills:

· Bachelor’s degree in computer science, Information Technology, or a related field.

· Proven experience as a Database Administrator with expertise in Oracle and PostgreSQL.

· Strong knowledge of database design, data modeling, and SQL.

· Experience with database performance tuning, backup and recovery, and security practices.

· Familiarity with scripting languages (e.g., Python, Shell) for automation tasks.

· Excellent problem-solving skills and attention to detail.

· Strong communication and collaboration abilities.

· Certifications in Oracle Database Administration (e.g., OCA, OCP) and PostgreSQL.

· Experience with additional database technologies or cloud databases (e.g., AWS RDS, Azure SQL).

· Knowledge of database high availability solutions and clustering.

Full-time