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.