Database Administrator

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.