We are seeking a highly experienced Senior Database Administrator with expertise in managing and optimizing Data

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

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

design and implement scalable solutions to support the organization's data needs effectively.

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 cross-functional 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 Modeling and Optimization:

- Design and optimize data models to support analytical reporting, ad-hoc queries, and data visualization

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 organization's evolving data

infrastructure requirements.

5. Documentation and Training:

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

operational continuity.

Skills

Education

- Bachelor's degree in Computer Science, Information Technology, or related field. Master's degree preferred.

Experience

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

environments

Technical Skills

In-depth knowledge of database management systems such as Oracle, SQL Server, MySQL, or PostgreSQL.

- Hands-on 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 problem-solving 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.