Database Administraton

Position Summary

Reporting to the IT Infrastructure Manager, the Database Administrator will be responsible for overseeing and maintaining the organization's database systems and safeguarding data integrity ensuring the security, efficiency, and availability of databases to meet the organization’s data requirements.

Key Responsibilities

Database Design and Implementation:

Design and create database structures according to organizational needs.

Install and configure various database management systems (DBMS) like MySQL, PostgreSQL, SQL Server, etc.

Database Maintenance:

Conduct regular backups and recovery operations for data availability and integrity.

Monitor database performance, identifying and resolving bottlenecks.

Set up database monitoring solutions to track performance and health.

Establish alerts for critical events and performance thresholds.

Security and Access Control:

Implement and maintain security measures to protect sensitive data.

Define and enforce access control policies, including user roles and permissions.

Apply software patches and updates to maintain database security.

Data Migration and Integration:

Plan and execute data migration projects between databases or systems.

Develop and maintain data integration processes for seamless data flow.

Performance Optimization:

Optimize database queries and indexes to enhance system performance.

Address performance-related issues promptly.

High Availability and Disaster Recovery Planning:

Develop and maintain disaster recovery plans to minimize data loss in system failures.

Configure and maintain high availability solutions for uninterrupted database access.

Scaling and Capacity Planning:

Plan for database scalability, both vertically and horizontally, to accommodate growing workloads efficiently.

Documentation:

Maintain comprehensive documentation of database configurations, procedures, and policies.

Training and Support:

Provide training and support to end-users and team members on database-related issues and best practices.

Key Qualifications

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

Experience as a Database Administrator or in a similar role.

Database Management Skills: Proficient in managing various database systems, including relational (MySQL, PostgreSQL, SQL Server) and NoSQL databases (Amazon DynamoDB).

Experience with scripting and automation tools, such as Python and AWS CLI.

Cloud Services Expertise: Demonstrates experience with AWS Database services (RDS, Aurora, Amazon DynamoDB, Redshift, Database Migration Service, RDS Proxy).

Industries:Oil & Energy

Function: Web Development