Senior Database Administrator American Hospital Dubai

Job Description
Senior Database Administrator

Role : Sr. Database Administrator, Backups & Cerner Backend Administrator

Responsibilities
Sr. DBA Responsibilities:

Install, Configure and Manager Manage Microsoft SQL 2012, 2016 & 2019, Oracle 11g & 19c, ERP Cloud Databases, MySQL, PostgreSQL databases.
Create and manage database instances, schema objects, and user accounts on All Databases
Implement and maintain database security and access controls
Manage Database upgrades, DB enhancements, performance optimizations, health checks.
Manage DB migrations, DB Upgrades to latest version and validation post upgrades.
Manage the administration and support of Cerner, Oracle Fusion ERP, My Care, and other third-party database applications.
Configure and manage Active Data Guard process between the production and Standby database and ensure the data is processed and in sync.
Monitor and manage the capacity of DB systems and provide storage and compute forecasts for future capacity needs.
Cerner Backend Administrator Responsibilities:

Manage Cerner PROD & CERT Domains – Client Installations & Maintenances and coordinate the complete domain maintenance with Cerner OMS Team.
Manage Cerner Non-Prod Domains (BUILD & TRAIN). Complete Domain Infrastructure along with Domain Maintenance, Domain Copy, Package Installs, Backend Server Maintenance.
Configure and manage Cerner Systems Hardware – Printers, Scanners and other End User peripherals and integration of these systems to Cerner Backend.
Manage Backend Systems of Cerner applications and ERP Domain – Application Nodes, Database Servers, 724 MidTier Server and all other standalone applications of Cerner.
Manage Backend Infrastructure for all the Cerner Production environment.
Configure and manage Backend Integration configuration of Cerner Systems with third party applications using FSI/OpenView and managing Open Link Servers.
Manage CAMM Backend Systems – Managing the file systems, databases and application configuration and DICOM Image viewer troubleshooting.
Manage complete 724 downtime infrastructure along with the Mid-Tier Server ETL process and the data extract to all the downtime PCs identified in the respective departments.
Backup Responsibilities:

Administer, configure, and optimize EMC Networker and Data Domain backup systems, ensuring consistent and reliable data backup and recovery.
Implement and manage backup policies, retention schedules, and disaster recovery strategies in compliance with organizational and regulatory requirements.
Monitor the backup environment for performance, capacity, and failure alerts. Identify and troubleshoot backup failures, hardware issues, and performance bottlenecks.
Create, schedule, and monitor backups for physical and virtual environments, ensuring all critical data is backed up according to the defined schedules.
Apply necessary patches, firmware upgrades, and system updates to the EMC Networker and Data Domain systems, keeping the environment up-to-date and secure.
Monitor and manage the capacity of backup storage systems, including Data Domain appliances, and provide forecasts for future capacity needs.
Work closely with other IT teams, including database, network, and server administrators, to ensure smooth integration and operation of backup systems within the overall IT infrastructure.
Ensure backups meet compliance standards and are ready for regular audits. Prepare audit reports and respond to audit inquiries as needed.
Qualifications
Bachelor’s degree in information technology/Engineer/Computer Science or equivalent is required
8+ years of experience in database administration, management, and optimization across various platforms.
5+ years of experience as Backup Administrator
8+ years of experience as Cerner Backend Administrator
Extensive experience managing databases such as Microsoft SQL Server (2012, 2016, 2019), Oracle (11g, 19c), and cloud-based databases.
Familiarity with Data Domain systems and related technologies
Ability to work independently and collaboratively in a team environment
Proficiency in backup and recovery software EMC Networker, EMC Data Domain, or similar tools.
Knowledge of database backup methods for systems like Oracle, Microsoft SQL, MySQL, PostgreSQL, and other enterprise databases
Excellent analytical and problem-solving skills.
Strong communication, collaboration, and interpersonal skills.

PROFESSIONAL EXPERIENCE:

Minimum of four (4) to six (6) years of Database Administration experience.
Knowledge of Oracle database architectures (Single Instance and Real Application Clusters (RAC)) and related utilities and tools on Oracle 9i, 10g, and 12c.
Knowledge and ha·nds on experience with Oracle Enterprise Manager 10g and 12c, Real Application Clusters, Partitioning, Diagnostics Tuning, Audit Vault Database Firewall, Database Vault, Advanced Security.
Knowledge of the SQL Server database architectures (Single Instance and HA) and related utilities and tools on SQL server 2005/2008/2012/2014/2016.
Knowledge of procedures for install upgrades, corporate database requirements, security, and backup recovery and automate the same.
Knowledge of troubleshooting databases by tracking database problems and performance using Oracle/SQL Server auditing features, dynamic performance views, server alert files, and tracing facilities.
Knowledge of database standards and procedures to cover instance parameters, object sizing, storage, and naming.
Knowledge of Local Area Network (LAN) and Wide Area Network (WAN) Networking, SharePoint, and MS Exchange.
Knowledge of Unix and Windows Administration preferred.
Knowledge of Business Intelligence and reporting preferred.
Skills in Database creation, user, roles, Tablespaces, data files, tables, indexes and views creation and maintenance.
Skills in Database administration following best practices, Database security, user and space management.
Skills in Database performance tuning and monitoring covering objects, tablespaces, and space management.
Skills in tuning and performance monitoring DBs to reduce 1/0 and rollback lock contentions.
Skills in Administering monitoring tools like DB Artisan, and SolarWinds to monitor Oracle and SQL server databases, space management, object growth and performance tuning.
Skills in Incident Management: Resolve single- and cross-technology, independently working with team members to resolve unusually complex or cross-technology incidents.
Skills in the Creation of users, granting roles and privileges.
Skills in Objects, Index, Tablespace, and Datafile space organization.
Skills in planning, installing and configuring Database back-ups for Oracle and SQL DB’s.
Skills in Planning Database recovery in case of Database crash and DR setup.
Skills Application performance monitoring and management.
Skills in Applying Patches to Oracle and SQL Databases.
Skills in Creation of scripts in UNIX, SQL and Oracle for task automation.
Ability to speak and write in English fluently.
* Note : Only shortlisted applicants will get contacted.