Roles and 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.
• 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.
• 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.

Posted By