DataBase Administrator

We are seeking a highly experienced Senior /Junior Database Administrator with expertise in managing and optimising Data

Warehouse and Data Lake environments. The ideal candidate will possess comprehensive knowledge of database

architecture data modelling ETL processes and performance tuning. The role requires a strategic thinker who can

design and implement scalable solutions to support the organizations data needs effectively.

Responsibilities :

Database Management

Oversee the administration of Data Warehouse and Data Lake platforms ensuring optimal performance

reliability and security.

Design implement and maintain database schemas tables indexes and views for efficient data storage and

retrieval.

Monitor database systems to identify and resolve performance bottlenecks capacity constraints and other

issues proactively.

Conduct regular backups disaster recovery planning and implement security measures to safeguard sensitive

data.

2. Data Integration and ETL:

Collaborate with crossfunctional teams to understand data requirements and develop robust ETL processes for

data ingestion transformation and loading.

Implement and optimize data integration workflows to ensure seamless transfer of data between disparate

systems and platforms.

Automate ETL processes where applicable to improve efficiency and reduce manual intervention.

3. Data Mode ling and Optimization:

Design and optimize data models to support analytical reporting adhoc queries and data visualisation

requirements.

Work closely with data architects and analysts to ensure data structures align with business objectives and

reporting needs.

Utilize indexing strategies partitioning techniques and other performance tuning methods to enhance query

performance and overall system efficiency.

4. Capacity Planning and Scaling:

Perform capacity planning assessments to forecast resource requirements and scalability needs for future

growth.

Implement scaling strategies to accommodate increasing data volumes and user concurrency while maintaining

system performance.

Evaluate and recommend hardware software and cloud solutions to support the organizations evolving data

infrastructure requirements.

5. Documentation and Training:

Document database configurations procedures and best practices to facilitate knowledge sharing and ensure

operational continuity.

Requirements

Education

Bachelors degree in Computer Science Information Technology or related field. Masters degree preferred.

Experience

Proven experience (5 years) as a Senior Database Administrator with a focus on Data Warehouse and Data Lake

environments

Technical Skills

Indepth knowledge of database management systems such as Oracle SQL Server MySQL or PostgreSQL.

Handson experience with big data technologies like Hadoop Spark and related ecosystems (e.g. Hive HBase

Kafka).

Proficiency in SQL programming and scripting languages (e.g. Python Shell) for automation and data

manipulation tasks.

Strong analytical and problemsolving skills with a keen attention to detail.

Excellent communication and interpersonal skills with the ability to collaborate effectively across teams and

departments.

Industry certifications such as Oracle Certified Professional (OCP) Microsoft Certified Solutions Expert (MCSE) or

Cloudera Certified Professional (CCP) are a plus.