Database Administration Lead
Job Description
<p><strong>Reports to:</strong> ICT Director</p><p><strong>Location:</strong> Beirut</p><p><strong>Position Summary:</strong> </p><p>Responsible for building database systems of high availability and quality depending on end user’s specialized role. Also responsible for designing and implementing databases in accordance to end users information needs and views. Ensures that all our databases are consolidated under one management line for better accountability, data consistency, backup and recovery. Ensures that data is available, protected from loss and corruption, and easily accessible as needed</p><p> </p><p><strong>Primary Duties and Responsibilities: </strong> </p><p><em>Data Management</em></p><p>• Keeps the database up and running smoothly 24/7 considering both backend data structure and frontend accessibility for end-users</p><p>• Builds database systems of high availability and quality depending on each end user’s specialised role</p><p>• Provides proactive and reactive data management support and training to users</p><p>• Determines, enforces and documents database policies, procedures and standards</p><p>• Responds in a timely manner to user-reported errors</p><p>• Suggests changes and improvements for maintenance or protection</p><p>• Regularly liaises with ICT members (software, BAS and SNU)</p><p>• Designs databases with both front-end and back-end users in mind</p><p>• Maintains awareness of trends and developments in database administration</p><p> </p><p><em>Software installation and Maintenance</em></p><p>• Collaborates on the initial installation and configuration of a new Oracle, SQL Server etc database</p><p>• Handles the transfer of data from the existing system to the new platform</p><p>• Monitors database performance, implements changes and applies new patches and versions when required; identifies problems that arise</p><p> </p><p><em>Data Extraction, Transformation, and Loading</em></p><p>• Efficiently imports large volumes of data that have been extracted from multiple systems into a data warehouse environment</p><p>• Cleans external data and transforms it to fit the desired format so that it can be imported into the central repository</p><p>• Protects the database against threats or unauthorized access</p><p> </p><p><em>Database Backup and Recovery</em></p><p>• Creates backup and recovery plans and procedures based on industry best practices</p><p>• Uses existing backups to restore lost information to the system in case of any server failure or data loss</p><p>• Uses high-speed transaction recovery techniques and backup data</p><p>• Minimises database downtime and manages parameters to provide fast query responses</p><p>• Ensures that the database is adequately backed up and able to be recovered in the event of memory loss </p><p> </p><p><em>Security & Authentication </em></p><p>• Performs tests and evaluations regularly to ensure data security, privacy and integrity</p><p>• Implements best practices of information security </p><p>• Consults audit logs to see who has done what to the data</p><p>• Controls who has access to data </p><p>• Protects the database against threats or unauthorized access</p><p> </p><p><em>Capacity Planning</em></p><p>• Analyzes usage level (capacity), storage space in server and backup </p><p>• Assesses OMT’s database and data size in order to predict future database needs and storage</p><p>• Reports on metrics regarding usage and performance</p><p> </p><p><em>Performance Monitoring & Database Tuning</em></p><p>• Monitors databases for performance as part of the on-going system maintenance</p><p>• Makes necessary configuration changes to software or add additional hardware capacity in case system is slowing down</p><p>• Analyzes performance monitoring results and ensures tweaking database where need to operate as efficiently as possible</p><p>• Proactively tunes systems based on application and usage instead of waiting until a problem arises</p><p> </p><p><em>Troubleshooting</em></p><p>• Restore lost data or correct an issue to minimise damage, a Understands and responds to problems and restores lost data in a timely manner</p><p>• Ensures corrective actions are taken to minimize damage </p><p> </p><p><strong>Knowledge, Skills, and Abilities:</strong> </p><p><em>Qualifications:</em></p><p>• University Degree in Computer Science, Information Technology, Management Information Systems, Computer & Communication Engineering or any relevant field</p><p>• Advanced certification as an MCDBA or MCSD for .NET is a plus </p><p> </p><p><em>Technical Skills:</em></p><p>• Proficiency in English and Arabic; French is a plus </p><p>• Proven working experience as a Database Administrator</p><p>• Hands-on experience with database standards and end user applications</p><p>• Excellent knowledge of data backup, recovery, security, integrity and SQL</p><p>• Familiarity with database design, documentation and coding</p><p>• Previous experience with DBA case tools (frontend/backend) and third party tools</p><p>• Familiarity with programming languages API</p><p>• Proficiency in data manipulation languages, including MS SQL, Oracle Database, Hadoop, or PostgreSQL. </p><p> </p><p><em>Relevant Experience:</em></p><p>• 9-14 years</p><p> </p><p><strong>Key Behavioural Competencies:</strong> </p><p>• Ability to recommend & to implement proactively solutions to potential problems</p><p>• Ability to adapt to a fast-moving IT landscape and a fast dynamic environment</p><p>• High level of personal integrity </p><p>• Excellent organizational and time-management skills</p><p>• Strong attention to details</p><p>• Highly skilled in managing difficult situations</p><p>• Strong analytical thinking while researching, collecting, mapping and analysing data</p><p>• Critical thinking</p><p>• Project Management</p><p> </p><p><strong>Key Interactions: </strong> </p><p>• External: ICT suppliers, software providers, third party companies</p><p>• Internal: All departments and units across the company especially Senior –Managerial and Middle-Managerial level employees</p><p> </p>
