Database Administrator

Contract Duration: 2 years

Qualifications and Required Skills:

Education: Degree in Computer Science, Information Technology, or a related field.

Certifications:

• Oracle DBA certification, preferably version 11g Release 2, 19c, or higher.
• Certified MySQL DBA or equivalent.

Experience:

• Minimum of 2 years of post-qualification experience in database administration, including both on-premise and cloud platforms (e.g., Oracle Cloud Infrastructure – OCI).

Technical Skills:

• Expertise in data backup, recovery, security, and integrity.
• Proficient in SQL and database performance tuning.
• Familiarity with database design principles and APIs.
• Knowledge of relational databases (e.g., PostgreSQL, MySQL).
• Understanding of NoSQL databases (e.g. MongoDB)
• Understanding of application servers like Tomcat.
• Knowledge of security best practices in database management.

Soft Skills:

• Strong analytical and troubleshooting skills.
• Ability to work under pressure and meet tight deadlines.
• Excellent communication and documentation skills.

Responsibilities:

Database Management and Maintenance

• Install and configure databases on various operating systems (e.g. UNIX-based OS, Windows).
• Design and maintain database architecture to optimize performance and management.
• Create, modify, and delete database objects (tables, views, indexes, stored procedures) based on approved change requests.
• Monitor database performance and implement optimization strategies.
• Ensure efficient storage management for systems and data files.
• Conduct regular data purging to maintain optimal database performance.
• Plan and execute database migrations, including version upgrades and transitions to new database systems.

Security and Compliance

• Enable auditing features and report access or process anomalies.
• Implement and manage database encryption, masking, and ISO27001 operational security guidelines.
• Perform periodic user access reviews and ensure compliance with licensing agreements.
• Conduct tests and evaluations to ensure data security, privacy, and integrity.

Backup and Recovery

• Implement Oracle RMAN backup and recovery solutions.
• Integrate RMAN backups with third-party tools like Veritas NetBackup.
• Ensure timely transaction log shipping and error-free data replication on standby servers.
• Maintain and test disaster recovery databases and update related Standard Operating Procedures

Performance and Troubleshooting

• Use database tools to analyze and optimize SQL scripts.
• Troubleshoot database issues and apply recommended solutions.
• Suggest and implement improvements to enhance database performance.
• Produce incident reports related to database issues and resolutions.

Collaboration and Documentation

• Create and update configuration documents for database systems.
• Actively participate in application testing and compatibility analysis with databases like Oracle 19c, 21c, and others.
• Work closely with developers to ensure compatibility with application servers (e.g., Tomcat).

Other Duties

• Manage database-specific licenses and maintain accurate records.
• Actively participate in testing new patches, updates, and database technologies.
• Perform any other cognate duties as assigned.

Key Expectations:

• Demonstrate proactive database management to prevent downtime and ensure high availability.
• Exhibit a commitment to security, compliance, and best practices.
• Deliver high-quality work within tight deadlines, ensuring the database systems meet organizational needs