Database Administrator

Required / Desired Skills

Skill

Required / Desired

Amount

of Experience

Bachelor s degree in computer science, Information Technology, or a related field.

Required

Proven experience as a Database Administrator with expertise in Oracle and PostgreSQL.

Required

Strong knowledge of database design, data modelling, and SQL.

Required

Experience with database performance tuning, backup and recovery, and security practices.

Required

Familiarity with scripting languages (e.g., Python, Shell) for automation tasks.

Required

Certifications in Oracle Database Administration (e.g., OCA, OCP) and PostgreSQL.

Required

Experience with additional database technologies or cloud databases (e.g., AWS RDS, Azure SQL).

Highly desired

Knowledge of database high availability solutions and clustering

Key Responsibilities

Assists in developing standard IT configuration and asset management methodology

Develop CMDB policy, processes, and knowledge base

Conduct reporting on configuration audits and reconciliation

Maintains CIs to ensure CMDB accuracy and completeness

Drives visibility on process adherence and compliance improvement opportunities

Works with other ITSM processes to understand new requirements and identify how Configuration management can support or replace

Support and administer the tool for configuration and asset management, ServiceNow Discovery, and additional applications or modules as assigned

Conduct discovery workshops to uncover and consolidate disparate data sources while managing the expected business outcomes, use cases, the ServiceNow Common Service Data Model (CSDM), and platform governance

Create and document requirements for efficient process design that includes self-service options with limited manual effort

Manage the operational integration and centralization of IT Asset Management processes, such as requests and procurement, reports and dashboards, data accuracy/integrity, and extending the scope of Asset Management

Demonstrate experience in implementing and managing ServiceNow CMDB, CSDM, Hardware and Software Asset Management processes, procedures, and governance

Draft technical process documentation

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.

Analyse 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 modelling, 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.