Senior DBA
Qatar Islamic Bank
Total years of experience :26 years, 11 Months
Install and Configure Sybase ASE 15 on Oracle Solaris 5.10 and Oracle on IBM Power VM servers.
24 * 7 Sybase ASE production support for phoenix core banking, Internet banking and SMS databases
Automated the dump and load of databases using shell scripts
Schedule and monitor Database maintenance activities such as re indexing, reorg, DBCC during maintenance slots
Implement Change Requests on SQL Server, ASE and Oracle databases as per the change management process
Working with Applications Support and IT Operations team to resolve incident tickets
Created new ASE Sybase devices and added to the database as part of the capacity management process
Extensively worked with Oracle/Microsoft/Sybase support on critical SEV-1 calls to resolve the production issues.
Installed Sybase Server with varying sort orders and character sets as well as different page sizes
Migration of phoenix core banking databases to the SQL Server 2012 with 0 down time and 0 budgetary cost
Implement SQL server HA solutions such as Failover Clusters, Log Shipping, Mirroring and Replication
Diagnose and tune system performance using tools such as SQL Profiler, DTA, AWR and advisories.
Active participation in DRMS and Bank’s strategic projects.
Good experience in applying Service Packs/Cumulative Updates on SQL Servers and Oracle
Expertise in Database Administration of SQL Server (2005/2008/2008 R2/2012)
Design and implement Storage solutions, backup and recovery strategy for SQL Server and Oracle Databases.
Planning and implementing Oracle 12c RAC for backspace Omni-Channel and SMS application systems
24*7 Oracle Production support for core banking database of size 5 TB and various channel databases.
Supporting 400+ SQL server databases and 13+ RAC instances for a variety of critical banking application systems.
Installation and configuration of Multi node Oracle E-Business suite Database and Technology stack
Installation and configuration of Oracle 10g/11g/12c RDBMS single and Real Application Cluster instance
Oracle 11i/R12 E-Business suite administration thru Oracle Application Manager (OAM)
Manage and administer SQL (2005 / 2008/ 2012 ) server databases
Periodical Cloning of Database and EBS Application instance using RMAN and Rapid clone
Apply patches and perform upgrades to the E-Business suite Applications and Technology Stack
Plan, test, document and implement Oracle Critical Patch Updates as per the Patch Management Schedule
Conduct Preventive Maintenance to maintain overall Health of the Oracle E-Business Suite
Monitoring and troubleshooting Applications components such as workflow system, Concurrent Managers and Java Workflow mailers
Proactively identify performance issues, develop action plan and implement the solution to resolve the issue
Efficient in using Oracle tools for identifying and resolving performance issues
Plan, implement Oracle 11g Active Data guard disaster recovery solution and document SOP for the same
Database Consolidation using Oracle 12c Multitenant container and Pluggable databases
Plan, implement Oracle 11g OBIEE (Oracle Business Intelligence Enterprise Edition) architectural components
Value Engineering to maximize the return on IT Infrastructure Investment and Planning for upgrades
Migration of RPD, Catalog (Reports and Dash board) to OBIEE 11g from OBIEE 10g
Installation, configuration of Mobility patch to create BI mobile applications
Installation configuration of Oracle 11g ODI ( Oracle Data Integrator) for Data Ware House ETL operations
Support for building company’s strategic Data mart and Data Ware House projects
Support for Oracle Financial / SCM / Project / HR, manufacturing and BI consultants
Linux Administration(RHEL/OEL) and Prepare shell Unix scripts to handle Unix/ Oracle related tasks
ITIL: Service Desk, Incident, Change Management and Capacity planning of Database Storage.
Creating and Managing Oracle Service Requests (SR’s) with My Oracle Support Meta link
Design and implement Maximum Availability environment using Oracle RAC, ASM and Data Guard
Install and Configure Oracle 11g Grid Infrastructure for Oracle 11g Real Application Clusters
Zero-Downtime Database Upgrade and Active-Active Replication Using Oracle GoldenGate 11g R2
Administering Oracle Cluster ware using crsctl, srvctl, oifcfg and Enterprise Manager
Upgrading, Patching and troubleshooting Grid Infrastructure environment
Configure Load Balancing, Transparent Application failover and integrating with services
Creating and managing High availability of services and using them with the client
Managing voting disk, Oracle Cluster Registry (OCR) and free list contention
Troubleshooting and debugging the Oracle RAC Cluster environment
Adding a node to the cluster and removing node from 11g cluster
Patching Oracle RAC environment using all node, minimum down time and rolling patching
Proficiency in RMAN backup and Recovery procedures
Install, Configure and maintaining Oracle 12c RDBMS in Linux
Creation of Multitenant container and Pluggable databases
Migration of non-container databases to Container databases
Plugging, Unplugging, cloning of PDBs and Oracle 12c User security
RMAN backup and Recovery of Container and pluggable databases
Oracle EBS cloning, patching, database optimization and performance tuning
Planning and Implementing changes to the production systems as per Client’s Change Management Process
Plan, Organize and control a team of DBAs and System Administrators to realize the bank’ projects
Planning and implementing three node Oracle 11g RAC HA systems on IBM PowerVM
Planning and implementing DR solution for Online banking using Oracle 11g Active Data Guard
Review of HP Load Runner Performance testing reports and guided the team for tuning opportunities
Vendor management on procuring new hardware and software for operational and project requirements
Planning and Implementing changes to the production systems as per Bank’s Change Management Process
Prepare and circulate Fortnight status report on key deliverables for Senior Management Review
Design and Implement Rating system for DBA team to evaluate performance and Recommend Rewards
Train DBAs on new Features, technologies and enforce ITIL Standards
Install, configure, up gradation of Oracle 9i/10g/11g databases on HP-UX, IBM-AIX, LINUX and Windows
Responsible DBA for managing Core Banking, credit card, debit card, collection and trade innovation databases
Plan and Upgrade Collection database from 8.1.7.4 to Oracle 10g R2 and post migration performance tuning
Plan and Upgrade Credit Card Management database from Oracle 9i to 10g R2 as part of Covered card Project
Install and configure Oracle 10g WLS (Web Logic Server) and 10g Application server components
Plan, Implement and maintain Oracle and SQL server Security standards as provisioned by IS
Plan, Implement and Document Physical and Logical backup and recovery procedures
Plan and implement disaster recovery site for the bank’s core critical systems and databases
Plan and Implement disaster recovery site for Oracle R12 E-Business suite and application database
Experience in Oracle EBS 11i/R12 single and Multi-node Configuration on UNIX and Windows systems
Experience in Oracle EBS Application 11i / R12 instance cloning to the test / development system
Good Knowledge and experience in patching oracle E-Business Suite application 11i and R12
Experience in Troubleshooting Oracle database 10g / 11g and 11i / R12 Application systems
Diagnose and resolve Concurrent Manager, Workflow system and Workflow mailer issues
Experience in using autoconfig to manage Oracle Applications Configuration
Upgrading Oracle Applications Database from 9i to 10g to 11g, Upgrading Oracle Applications from 11i to R12
Experience in Configuring Oracle Workflow inbound / outbound Java mailers in OAM
Perform Configuration changes of Oracle APPS, 10g Application Servers and databases as and when required
Integrate SSO with R12 apps and Implement WNA Kerberos authentication with AD to OID synchronization
Experience in setting up Oracle 10g discoverer server and integrating with the Oracle EBS 11i / R12
Configuring public middle Tiers/DMZ Servers of ORACLE 11i/R12 Applications
Create and Manage Oracle 10g / 11g Active Data Guard and document the switch over and failover process
Create and Configuration of Oracle 10g Application server components (http, forms and report Services, OC4j, OID/SSO, 10g Discoverer) and deployment of J2EE applications.
Solutions Architecting and Implementing Oracle Identity Management and Integration with Oracle EBS R12
Solutions Architecting and Implementing Oracle Internet Directory in HA mode using ASR (Directory Level) replication
Managing OC4J and Configuring J2EE Applications in High Available Mode (Oracle AS 10g Clusters)
Monthly consolidated report on Memory, CPU, I/O utilization, performance statistics and capacity planning
Periodically Review Critical Patch Updates (CPU) and schedule to test and move to the production instances.
Installing & configuring software MKS Toolkit and Visual Studio 2013 with Oracle Application R12.1
-Commendable member role in setting up a bank’s core critical systems and databases since its inception thru different phases like UAT/SIT and supported post implementation, production issues seamlessly until stabilized.
-Second Level Support for 30+ Unix Servers (HP, IBM, SUN)
-Daily Health Check of Servers by Monitoring Syslog’s, Event logs and File Systems
-Creation of Physical & Logical Volumes, Volume groups and File systems on HP-UX, IBM-AIX and Linux
-Extend Logical Volumes, File Systems and Volume groups.
-Log Service calls with HP/GBM/MDS support for the issues and Resolution
-OS Account Management such as Users, Groups creation, Locking and Unlocking of User Accounts
-Schedule Preventive Maintenance of Servers and Review and action on Preventive Maintenance checklist
-Use of a glance utility on HP-UX, topas & NMON on IBM-AIX to monitor Server Performance
-Monitor, tune, size, backup, recover, analyse, defrag and migrate 8i, 9i, 10g databases and 10g Application servers.
-Defining database objects such as tablespaces, tables, indexes and their future storage requirements
-Physical design of the database, object sizing and placement as per Application Requirements.
-Creation of Users, Roles, Profiles and controlling database access (RBS) thru Security profiles and Custom roles.
-Refreshing databases to the UAT/SIT environments as and when required for testing and Integration.
-OLTP / Batch Production database Support for Emaar Properties, Dubai bank and Amlak Finance.
-Headed a team of highly motivated and technically sound engineers.
-Generating innovative business enquiries, profitability in business, customer relationship and team morale.
-Install and Configure Novell server and end to end LAN infrastructure support as per business requirements
-Manage Annual Maintenance Contract of Novell LAN Network Servers management.
-Manage Netware Volumes File System Security and login Scripts using Netware Administrator.
-Create Objects such as Users, Groups, Printers and Netware Volumes
-Configure Novell NDS, IP tunneling network printer and migrate Netware Volumes to Windows NT
-Corporate training on Novell and Oracle technologies
-Fine-tuning and troubleshooting of Netware servers and dependent Network modules.
-Novell Netware Network service and support
