Senior Oracle/SQL Database Administrator/Team Leader
Emirates Investment Bank P.J.S.C.
مجموع سنوات الخبرة :16 years, 6 أشهر
• Ensure that availability of services exceeds the defined service levels
• Oracle/SQL Database Design, Deployment and Post Implementation Support (24x7)
• Directly Responsible for Upgrade of Oracle/SQL Database from legacy Versions
• Installation, configuration and maintenance for ORACLE RAC/SQL Clusters and Standalone systems
• Ensure License Compliance and Support Renewals and Liaison with vendors for support tickets
• Configuration of Standby DBs using Oracle Data Guard for High Availability and Disaster Recovery
• Restoration and Recovery of databases at the times of occurrence of sudden failures
• Responsible for Updates, Hotfixes and Security Patches
• Implemented Oracle/SQL Backup & Recovery using RMAN and other Automated Procedures
• Performance tuning of Oracle/SQL DB to decrease query time, Backup windows and End of Day Process of Core Banking System
• User Accounts Creation and Handling Roles by granting required privileges
• Detailed DB performance analysis using various tools OEM, AWR, ASH, OS monitoring tools
• Participate in the implementation of technologies and platforms supporting a complex corporate highly virtualized hybrid infrastructure, and the maintenance, monitoring and support of the environment
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers
• Expertise in SQL tuning using tracing, execution plans, wait events, advisors
• Continuous monitoring of DB performance during peak and Off Times
• Worked with developers to provide queries and tuning the queries for better performance
• Resource Management (Create and manage Indexes, Clusters, Tables), allocate and manage physical storage structures like Data files, Redo logs, Control files.
• Realtime Replication of Data from primary to standby databases via automated scripts
• Implement Highly Available DBs for Systems using clustering or different replication techniques
• Managing Disaster Recovery site to ensure real time data synchronization for seamless failover
• Planning and conducting Disaster Recovery Exercise
• Actively involved in Business Continuity Plan development to cater with unforeseen disasters
• Designing systems with High Availability to adhere with Recovery Time Objectives (RTO) and Recovery Time Objectives (RTO) set by Business Team
• Coordination with Internal and Auditors to ensure compliance on SOPs
• Writing Configuration Documents and, Service Delivery guidelines
• Upgraded Core Banking Oracle 11g single Node DB to 12c R2 Two Node RAC ASM
• Solely Handled Core Banking Oracle/SQL Databases Migration to a new Datacenter
• Improved EOD Time from 9.5 hours to 45 Minutes by optimizing the performance
• Successfully took charge for Administration of Central Bank Apps and Databases like ICCS, FTS, DDS, CAD, IPI
• Additionally, managed HRMS, ZAG Trader and Clear Stream
• Other Day to Day System Administration Tasks
• Create and maintain all databases required for development, testing and production use for Arab Bank GCC Region
• Responsible for administration of Databases of business applications of ARAB BANK SQL & RAC/ASM & NON-RAC Databases 10g, 11g & 12c on AIX & Windows environments
• Perform capacity planning to deploy new database instances
• Plans and implements backup and recovery of Oracle/SQL using a combination of incremental, differential and full RMAN backups (Symantec NetBackup System)
• Administer disaster recovery site using oracle data guard & SAN Replication SRDF
• Maintenance for all of Databases (system security, Technical Controls, Tablespace, privileges, roles, Analyzing and validating database objects)
• Provide technical support to application development teams
• Evaluate releases of Oracle/SQL and its tools, and third-party products to ensure that the site is running the most appropriate products
• Performs database re-organizations as required to improve performance and ensure maximum uptime of the database
• Assist Head of IT with impact analysis of any changes made to the database objects
• Apply upgrade patches released by Oracle and ensure the database servers are updated
• Perform database and related applications’ tuning and performance monitoring.
• Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle
• Installation, configuration and updating new software and operating system For AIX System.
• Responsible for administration and support for more than 25 Production AIX LPARs.
• Implement and maintain security controls on files, systems, and networks as per AIX technical control.
• Network support over AIX systems; including modifying network adapters, interfaces and network troubleshooting.
• Work as a team member and provide 24x7 supports when required
• Administrator on many disaster recovery sites using oracle data guard inside Syria and between BLOM Bank Syria & BLOM Bank Lebanon
• Responsible for the technical administration aspects of the Bank's Oracle and SQL Database infrastructure and Core Banking System (Integrated Computerized Banking System 'ICBS')
• Responsible for RAC Servers, SAN Storage, ASM, instances
• Supported more than 40 Database instances
• Maintenance of production database and development database which includes tablespace, space management, user creation, privileges, roles etc.
• Automated hot backups using RMAN
• Identifying and troubleshooting database performance and tuning issues
• Debugging, troubleshooting Oracle PL/SQL packages and stored procedures
• Development of oracle forms and reports for Oracle databases
• Responsible for database security and preventing data loss
• Responsible for managing Microsoft SQL Server
• Responding to queries in a timely manner for problem resolution
Computer engineering - Information Technology Specialist 2003 - 2008