Senior Engineer - Database Administration

Overview Presight, an ADX-listed public company limited by shares whose majority shareholder is Abu Dhabi company G42, is the region’s leading big data analytics company powered by Artificial Intelligence (“AI”). It combines big data, analytics, and AI expertise to serve every sector, of every scale, to create business and positive societal impact. With its world-class computer vision, AI and omni-analytics platform as its engine, Presight leverages all-source data to support insight-driven decision making that shapes policy and creates safer, healthier, happier, and more sustainable societies.

The Opportunity Presight is looking for an experienced professional Senior Engineer - Database Administration (DBA) with technical skills and knowledge that extends across Applications/Server/Storage/Network technologies to administer a large, complex production DB environment. The role performs highly effective centralized database administration for multiple databases, troubleshoot and provide system level support/ guidance/ solutions to ensure a 24X7 operations of mission critical applications.

Responsibilities Key Responsibilities:

• Ensure DB availability 24X7 for mission critical applications.
• Proactively manage and maintain security standards and controls.
• Implements and maintains database security and encryption.
• Actively seek to optimize and simplify DB architecture.
• Take ownership of performance and capacity monitoring aspects of the DB.
• Execution of data migration jobs and scripts as required.
• Assist the infrastructure team in sizing hardware used for the DB.
• Support and collaborate with product developers.
• Contribute to the creation and maintenance of disaster recovery plans.
• Create a reliable backup strategy, oversees backup, clustering, mirroring, replication and failover.
• Determine and document DB policies, procedures and standards.
• Performance testing and evaluation to ensure data security, privacy and integrity.
• Identification of bottle necks and deadlock issues.
• Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.
• Performs maintenance operations daily, weekly and monthly on Oracle and SQL servers and databases, and information systems for ensuring efficient program operations.
• Performs database backups and restorations and recovers corrupted databases.
• Evaluates and recommends new database technologies.
• Develops, manages, and tests database and information system backup and recovery plans.
• Prepares written materials for documenting activities, providing written reference, and conveying information.
• Prepares and distributes reports, including but not limited to weekly and monthly status reports to management.
• Interface with Oracle Corporation for technical support including patch management and version control.
• Good knowledge of SQL, PLSQL, LINUX, WINDOWS, SCRIPTING.
• Comply with QHSE policies, procedures, and related risk assessments.

Qualifications

• Bachelor's in Computer Science or related field and minimum 6 years of experience as DBA.
• Ideally, Oracle Certified DB Professional (OCP) with more than 6 years’ experience with Oracle, in a lead role.
• Good knowledge of MS SQL Server, PostgreSQL, and native replication tools.
• Minimum of two years administering database platform specific advanced features.
• Experience should include DB design, capacity planning, performance tuning, storage management, Data Partitioning, back-up and recovery, managing schemas, data security, report generation, and DB clustering technologies.
• Extensive UNIX/LINUX experience.
• Oracle HA and replication (Data Guard, RMAN, Data pump, GoldenGate etc.).
• Hands-on experience with DB standards and end user applications.
• Experience with Shell script, Python.
• Strong attention to detail and self-starter.
• Experience with an organization reliant on 24/7 reliability on its database.

What we look for If you are a performance-driven, inquisitive mind with the agility to adapt to ambiguity, you will fit right in. You should be eager to explore opportunities to build meaningful collaborations with stakeholders and aspire to create unique customer-centric solutions. Bias for action and a passion to conquer new frontiers in the AI space is at the heart of the Presight community.

What working at Presight offers

• Culture: An open, diverse and inclusive environment with a global vision that encourages personal growth and focuses on ground-breaking, industry-first innovations.
• Career: Outstanding learning, development & growth opportunities via structured training programs and innovative, high-tech projects.
• Rewards: A competitive remuneration package with a host of perks including healthcare, education support, leave benefits and more.