Short Description
We
are seeking a highly skilled Database Administrator to manage and optimize our
Oracle and PostgreSQL databases.
Complete 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
Bachelors 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.