SQL Database Administrator

**Main Purpose**

A skilled SQL DBA can help prevent data loss, minimize downtime, and optimize database performance, ultimately contributing to the overall success of an organization.

**Roles and Responsibilities**
- Install, configure, and upgrade SQL database management systems and implementation of best practices for database server setup and configuration
- Optimizing database performance by monitoring and fine-tuning SQL queries, indexing, and other database components to ensure efficient data retrieval
- Implementation and maintenance of database security measures, including user access controls, encryption, and auditing, to protect sensitive data
- Maintaining comprehensive documentation of database configurations, processes, and procedures is crucial for future reference and compliance
- Establish and execute data backup and recovery procedures to ensure data integrity and availability, including disaster recovery plans.
- Collaborate with developers, system administrators, and other teams to meet database requirements and provide technical support.
- Maintain a knowledge repository of emerging technology and industry best practices trends, pursue relevant certifications, and expand technical capabilities to match evolving organisational needs.
- Monitoring of database growth trends and plan for scalability by assessing hardware requirements and making recommendations
- Assisting in data migration projects, ensuring data is moved accurately and efficiently between systems.

**Closing date for Applications is the 31st January 2025**

**Competencies**and**Minimum**Requirements**:
**Knowledge**
- Sound knowledge of relational and non-relational database systems like MS SQL, MySQL, Oracle, MongoDB, etc., and their specific features.
- Strong command of SQL language for querying and database manipulation.
- Ability to design efficient and normalized database schemas, including defining tables, relationships, indexes, and constraints
- Skills in optimising SQL queries and database performance by analyzing query execution plans, indexing strategies, and database configuration.
- Understanding of how stored procedures, user-defined functions, and triggers work to encapsulate business logic within the database.
- Familiarity with cloud services like AWS, Azure, or Google Cloud and their interactions with data operations.
- Familiarity with data analytics and reporting tools such as Tableau, Power BI, etc.
- Understanding of the business domain and how data supports and enhances business operations
- Continuous updating of knowledge related to emerging trends in data operations and technology.

**Qualification**
- A Btech or bachelor's in a relevant field, such as Computer Science, Information Technology, or a related discipline.
- Demonstrates a foundational understanding of IT service management
- Cloud and/or on-premises certification in SQL Server administration

**Experience**:

- 5-7 years of Hands-on experience in designing, managing, and optimizing both relational and/or NoSQL databases. Experience in backup and recovery processes and disaster recovery planning.
- Skills in optimizing SQL queries and database performance by analyzing query execution plans, indexing strategies, and database configuration
- Demonstrate competency in SQL server auditing, access control, and role membership. Database encryption methods
- 5 -7 years of experience with SQL Server Reporting Services and SQL Server Analysis Services
- 3 years of experience in data virtualization tools like Tableau, Power BI, Business Objects
- Knowledge of ETL (Extract, Transform, Load) processes to integrate data from various sources into a centralized database system