Job Description

SQL DATABASE ADMINISTRATOR (DBA)

We are Looking for a SQL DATABASE ADMINISTRATOR (DBA)for one of our esteemed clients based in Dubai, United Arab Emirates.

Title: SQL DATABASE ADMINISTRATOR (DBA)

Location: Abu Dhabi, UAE

Experience : Mid-level to Senior candidate with at least five years of experience in database administration, specifically with SQL databases.

Profile Summary: The primary objective of the Comprehensive SQL Database Transition and Management Service in this context is to ensure the continuity, efficiency, and security of the clients SQL database operations following the departure of their previous Database Administrator (DBA).

Responsibilities:

1. Initial Assessment and Planning - The primary objective of the Comprehensive SQL Database Transition and Management Service in this context is to ensure the continuity, efficiency, and security of the clients SQL database operations following the departure of their previous Database Administrator (DBA). This service aims to mitigate operational impacts and restore optimal database performance and reliability. Specifically, the objectives are:

a. Seamless Transition: To provide a smooth transition of database management responsibilities from the previous DBA to our team, ensuring minimal disruption to the clients operations.

b. Operational Continuity: To quickly assess and address any immediate operational challenges or disruptions in the SQL database to restore normal business functions and data accessibility.

C. Database Health Assessment: To conduct a thorough evaluation of the current state of the SQL database, identifying areas for improvement, optimization, and potential risks.

d. Performance Optimization: To implement necessary optimizations and configurations to enhance the performance, efficiency, and scalability of the SQL database, supporting current and future business needs. Security and Compliance: To review and strengthen the databases security posture, ensuring data integrity, confidentiality, and compliance with relevant data protection regulations.

e. Data Integrity and Recovery: To ensure the integrity of the database data through regular backups, validation processes, and establish a robust disaster recovery plan to minimize data loss in case of incidents. Training and Documentation: To provide comprehensive documentation on the database environment and conduct training sessions for the clients team to understand basic operations, best practices, and how to handle minor issues.

f. Ongoing Support and Maintenance: To offer proactive and reactive support for the SQL database, including regular maintenance, updates, and timely response to any issues or queries to ensure continuous smooth operation.

g.Strategic Database Management: To work closely with the client in planning and executing strategic database initiatives that align with their business goals, including scalability solutions, technology updates, and integration with new applications.

h.Transparent Communication: To maintain open and transparent communication with the client, providing regular updates on database health, performance metrics, and any recommendations for improvements.

2.Review the Existing Database - Analyze the current database schema, data volume, data types, stored procedures, triggers, and any custom functions or scripts. This includes understanding the databases version and any dependencies it has on external services or applications.

3. Assess Infrastructure and Security - Evaluate the current database hosting environment, whether its on- premises or in the cloud, and review the security measures in place.

4. Documentation and Agreement. Create comprehensive documentation of the databases current structure, configurations, and any identified issues or challenges.

5. Pre-Transition Preparation:

a.Backup Data: Ensure that there are complete and tested backups of the database to prevent any data loss during the transition.

b.Set Up the Environment: Prepare the new database environment, ensuring it meets the required specifications for hosting the SQL database.

6. Data Migration:

a.Data Cleansing: Cleanse the data if necessary to improve quality and performance in the new environment. Migration Testing: Perform a dry run of the data migration in a test environment to identify potential issues and assess the impact on applications or services.

b.Migration testing and execution.

Experience: Looking for a Mid-level to Senior candidate with at least five years of experience in database administration, specifically with SQL databases.

Technical Skills:

Proficiency in SQL database management, migration, and optimization.

Experience with data backup and recovery techniques.

Familiarity with cloud services and infrastructure as it relates to database hosting and management.

Knowledge of data security and compliance standards.