Job Purpose:To provide technical expertise for Databases to ensure Integrity, Security, Availability and performance. Dynamically provide technical and infrastructure support to database related to initiatives. Efficiently manage operational activities ,Initiatives, Compliance mandates, Security guidelines on all designed activities including installation of software, upgrades , patches, code deployment, Database Checklists, Security initiatives, ETL tasks related to SAP DI and related applications.Key Tasks and Duties:Database Administration: Primary: Oracle/MSSQL Secondary(optional): MySQL, MongoDB, Postgres• Manage all database configuration for DBMS software servers and application tools, ensuring that version and change control procedures are observed, applying fixes, maintaining overall health of databases, ETL and other related applications.• Manage configuration of container-based databases to maintain and optimize the resource utilization• Monitor database activity and ensure efficient access to data, and sufficient allocated resources. Undertakes regular exercises to optimize database performance using daily check list and pattern of effort.• Maintain databases in accordance with database and system security policies. Ensures compliance with Trust Domain standard and NBO IT Security Policy.• Ensure database services meeting RPO and RTO of business. Plan for backup and recovery of database, planning and managing exercises to prove recovery procedures. • Through problem management process, database problems are investigated, diagnosed and resolved.• Optimize database performance through periodic re-org activity on database & automate reoccurring activities in available tool. Prevent or minimize recurrence of database issues.• Forecast DB growth • Work on storage usage optimization and cleanup activities for data older than retention policy• Design and Implement backup and recovery for databases• Implement DB failover technology• Estimate future DB trends for H/W usage & user load. Implement new solutions in the field as needed by the organization.Data Management: ETL (Extract, Transform, Load) & Data consolidation/movement –Data IntegratorExplore ETL solution data integrator (DI). For BI related tasks, identify the different application and implement integration through DIPlan, design, implement and load data across platforms and across applications formulating a workflow and improve performance and comply with audit requirementsManage the various jobs and schedule to provide business related MIS data on time and adhere to service levels accordinglyManage the backup and recovery mechanism and time to time version upgrade of the DI serverProcess & ProcedureTrack & Document tasks especially long tasks and project activities. Build a knowledge base of regular tasks, potential issues etc.Capture best practices, draft QMS processes optimize organizational effectiveness.Align with supervisor to meet the objective of the organizational expectation.Have regular communication with supervisors & other team members.
اشترك مجاناً واختر تخصصاتك، وسنرسل لك الوظائف المناسبة مباشرة على واتساب
اشترك عبر واتساب مجاناً