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.