Database Administrator - Tamheer Program

Position Overview

We are seeking a meticulous, analytical, and driven Database Administrator Trainee to join our Data Platform team through the Tamheer Program. This role is designed for individuals who are passionate about solving intricate technical challenges, analyzing system behaviors, and working with data to uncover insights into the inner workings of critical technology platforms. As a DBA Trainee, you will immerse yourself in production-scale database environments, gaining practical experience in database design, performance monitoring, optimization, security, backup, and recovery processes. This position demands precision and accountability, as even minor configuration errors or query mistakes can have significant consequences. We are looking for a candidate who approaches tasks methodically, validates their work rigorously, asks insightful questions, and maintains composure when troubleshooting technical issues.

Key Responsibilities

In this role, you will collaborate closely with seasoned Database Administrators, Data Engineers, and Platform Engineers to execute a wide range of technical responsibilities, including:

• Query Development and Optimization: Write, review, and optimize SQL queries to enhance performance and efficiency.
• Performance Analysis: Analyze database performance metrics to identify slow or inefficient queries and recommend improvements.
• Database Monitoring and Health Checks: Support ongoing monitoring efforts, conduct health checks, and perform capacity analysis to ensure optimal database performance.
• Backup, Recovery, and High Availability: Assist in database backup procedures, recovery operations, replication strategies, and high-availability configurations to minimize downtime and data loss.
• Incident Investigation: Participate in root cause analysis for database-related incidents and contribute to preventive measures.
• Benchmarking and Configuration Analysis: Conduct benchmarking exercises to compare database configurations, queries, and technologies, ensuring the best possible performance.
• Automation Development: Utilize Python to develop scripts that automate repetitive database and operational tasks, enhancing efficiency and reducing human error.
• Data Validation: Ensure the accuracy, consistency, and integrity of data through systematic validation processes.
• Technical Reporting: Prepare detailed technical reports, performance findings, and actionable recommendations for stakeholders.
• Documentation Support: Contribute to the documentation of database standards, operational procedures, and best practices to maintain a robust knowledge base.
• Change Management: Learn and assist in safe testing and deployment of database changes to critical environments, ensuring minimal disruption.
• Continuous Improvement: Participate in initiatives aimed at enhancing the Data Platform’s efficiency, reliability, and scalability.

Requirements

To thrive in this role, the ideal candidate should possess the following qualifications and attributes:

• Technical Foundations: Strong foundational knowledge of SQL, including the ability to write queries using joins, aggregations, filtering, and subqueries.
• Programming Skills: Basic proficiency in Python to support automation and scripting tasks.
• Analytical Abilities: Exceptional critical-thinking and problem-solving skills, with a keen eye for detail and a commitment to validating assumptions and results.
• Problem-Solving Mindset: A proactive approach to investigating technical problems, rather than accepting outcomes at face value.
• Communication and Documentation: Excellent written and verbal communication skills, with a focus on clear and concise technical documentation.
• Learning Agility: A strong desire to expand your knowledge of database technologies and production engineering practices.

Preferred Knowledge

While not mandatory, the following experiences and skills are advantageous for this role:

• Familiarity with database technologies such as MySQL, PostgreSQL, MongoDB, Redis, or similar systems.
• Basic understanding of Linux operating systems and command-line tools.
• Knowledge of database concepts, including indexes, transactions, schemas, and data types.
• Exposure to version control systems like Git, API integrations, cloud platforms, or container technologies.
• Experience with academic, personal, or graduation projects involving data management or automation.

Learning and Development Opportunities

This program offers a transformative learning experience where you will acquire in-depth knowledge of:

• How enterprise databases function at scale, including architecture and operational best practices.
• Techniques for database performance tuning and query optimization to enhance efficiency.
• Backup, recovery, replication, and disaster-recovery strategies to ensure data resilience.
• Database security principles and access-management practices to protect sensitive information.
• Monitoring, alerting, and incident investigation methodologies to maintain system reliability.
• Python-based automation techniques to streamline database operations and reduce manual intervention.
• Safe and structured change-management practices for deploying updates to production environments.
• How to adopt a Database Reliability Engineering mindset to build robust, scalable, and resilient database systems.

Ideal Candidate Profile

This role is well-suited for individuals who exhibit the following characteristics:

• A natural curiosity about the internal workings of systems and databases.
• A passion for dissecting and resolving complex technical challenges.
• Meticulous attention to detail, ensuring accuracy in all tasks and outputs.
• Confidence in asking questions and actively seeking feedback to enhance learning.
• A sense of ownership and accountability for your work, with a commitment to verifying results.
• Resilience in the face of challenges, viewing them as opportunities for growth and improvement.
• A long-term career aspiration in databases, cloud data platforms, or reliability engineering.