Environment: AODB (Airport Operations Database), FIDS (Flight Information Display) , Oracle E-Business Suite R12.1.2 & R12.2.3 , Oracle 11g ,12c extended RAC, Microsoft SQL Server 2005/2008,OBIEE,Hyperion Planning and Budgeting, Sun Solaris Cluster, Oracle/Red Hat Linux

• To supervise the Database Administrators, together with the administration and accuracy of the databases and report to Database Manager.
• Upgraded the Oracle E-Business Suite applications and database from R 12.1.2/DB 11.2.0.1 to R12.2.3/DB 11.2.0.4 on a 2 node extended Oracle RAC database environment, SSL, SSO & DMZ Setup.
• Oracle Business Suite R12.2 custom application top setup
• Administering Oracle Business Suite R12.2.3 includes patching, cloning, stop and start etc.
• Handles the production support for 20+packaged/custom applications, 25+ Oracle databases, and 10+ MSSQL instances and provided 99.9+% uptime for all business critical applications like AODB, FIDS, Oracle E-Business suite R12, OBIEE, Hyperion and other Airport business support applications.
• Primary responsibility is to provide production support to AODB, FIDS, Oracle E-Biz suite and bolt-on applications.
• Implemented robust disaster recovery / business continuity solutions
• Migration of Oracle Database from 11g to 12c
• Oracle 10G SSO implementation for R12.
• SSL & DMZ setup for R12.
• Upgraded of Oracle 10G to 11G Oracle Access Management and configured SSO in Ebiz .
• Handled configuration of OID integration with Active Directory and Windows Native Authentication
• Configured External tier for Oracle EBS R12 with SSO authentication
• Installation, up gradation and administration of BI Apps with OBIEE 11G which includes Informatica, DAC.
• Implemented ISO 27001 ISMS certification for the database environments. Implementing technical projects working with cross functional teams, external vendors & service providers.
• Upgraded, migrated and consolidated legacy Oracle from Oracle 8i to Oracle 10g from IBM AIX to Sun Solaris and Microsoft SQL Server 2005 to SQL Server 2008 database environments to Highly Available environments.
• Performance Tuning of Database and Applications.
• Implemented OEM 12C Grid Control.
• Design, document and implement SQL and Oracle Application Server and Databases RMAN Backup, Restore & Clone Strategy.
• Handled migration of more than 50 Production SQL Servers and SQL 2008 Servers
• Provided round the clock support for 200+ Databases, 20+ Application Servers, and 8 Oracle E-Business Suite environments including DEV/SIT/UAT/PROD and applied required patches.
• Ensured the validity & efficiency of the implemented architecture by conducting DR, Performance and HA testing for critical services
• Worked in implementation of RMAN backup policies, retention, expiry, keep forever, delete obsolete, delete expired backups, change backup status available, unavailable
• MS SQL Server 2005 to SQL Server 2008 Database Upgrade
• Migration & up gradation of SQL Server 2008 R2 databases to Sql 2012 & Sql 2014/2016 & 2017
• Always on High Availability setup in Sql 2014
• MS Sql cluster installation configuration

Worked as Team LEAD.

Line manager to the team and to provide technical leadership to team of professionals & handling multiple clients at a time includes Dubai Bank ,DWTC, Masafi , Alokozay , Aman Insurance, Amity Insurance, Al Rostamani etc..

• Responsible for the development of infrastructure to support all aspects of database services, provision including service, security, maintenance, monitoring, recovery, performance tuning and consistency checking.
• Provide training and mentoring to junior engineers, DBA's and technicians.
• Perform on-going risk assessment, service management framework implementation and project reporting to the management and business partners.
• Achieve efficiency gains using automation, process improvement, cost saving/avoidance and provide monthly data to the management.

Worked as a DBA for DWTC on-site for a period of 45 days , was only DBA for complete DWTC which includes 8 to 10 PROD oracle DB’s & 40 Sql Server DB’s and EBS R12 instances , OBIEE 11G Etc..

Below I had included only 2 projects details for glance.

Project-1: Dubai Bank (Database Administrator)

Client: Dubai Bank

Team Size: 2

Technologies: Oracle EBS R 12.0.4,Oracle 9i,10g,11g ,MS Sql Server 2000,2005,2008

Role: Lead DBA

Operating Systems: RHEL 5.4,HPUX ,IBM AIX, Linux ,Solaris

Responsibilities:

• Was onsite over Dubai Bank from Feb 2012 till Dec 31
• Maintaining around 12 Oracle PROD DB’s including 1 R12 Apps Instance, 200 PROD Sql Databases.
• Changed the complete backup strategy of all Oracle Instances to Oracle Standards using RMan.
• Configured Oracle 10g Grid Control to monitor all the instances from a single point.
• Created Cron jobs for database alerts and backup
• Health checkup of oracle application instances (Prod,Test, Development and UAT)
• Checking Alert log, Apache log, and concurrent manager log files daily
• Checking and compiling invalid objects, clearing cache and bouncing the Apache
• Administrating and responding to Oracle SR's
• Performing system administration job and AOL.
• Trouble shooting various issues during day-to-day activities
• Administering and maintaining 3 databases (Prod,Test and Development)
• Installed and configured OBIEE
• Import and export of the schemas from one database to another
• Monitoring Tablespace
• Monitoring alert logs (e.g. using custom scripts to look for ORA-600 errors)
• Cloning instances of .R12
• Patch analysis and applying patches as requested
• Applying Database Patches and application patches.
• Writing Scripts in Linux to automate monitoring processes for the database and Applications.(e.g. Database Growth scripts, Tablespace monitor scripts etc.)
• Performing weekly and monthly activities in database and Application.
• Setting up oracle Database in new server.
• Taking Database performance by running AWR reports weekly.
• Working closely with SR in case of any issue.
• Implementing RMAN incremental backups with catalog mode and scheduling it to run daily.
• Worked on schema migration using export import utility.
• Installing, configuring and administering the Oracle 10G Discoverer.
• Configured Stand by database.
• Configured OEM Grid Control.
• Performing all sysadmin related tasks.

Project-2: Data Center Migration, Up gradation & Managed Services

Client: Masafi

Team Size: 3

Technologies: Oracle EBS R 12.0.6

Role: Lead DBA

Operating Systems: RHEL 5.4

Responsibilities:

• Moved the complete masafi data center from Etisalat Datacenter to Masafi Warehouse.
• Configured the Disaster recovery for PROD using Data Guard.
• Configured Workflow mailer in EBS R12.
• Changed the complete backup strategy of all Oracle Instances to Oracle Standards using RMan.
• Configured Oracle 10g Grid Control to monitor all the instances from a single point.
• Created Cron jobs for database alerts and backup
• Health checkup of oracle application instances (Prod,Test, Development and UAT.
• Line manager to the team and to provide technical leadership to team of professionals

Technologies: Oracle EBS R12.1.2 on Solaris Spark 10

Role: DBA

Operating Systems: Solaris spark 10, Windows Server 2003

Responsibilities:

• Worked as an ONLY DBA for the entire big organization, need to completely take care of 1 EBS PROD, 1 OBIEE PROD and all the test instances with the continuous support anytime as and when required.
• Improved the performance of Oracle Applications R12.
• Installed and Configured OEM 10g grid control
• Monitoring alert logs (e.g. using custom scripts to look for ORA-600 errors)
• Monitoring Database using OEM and custom scripts
• Applying database patches and application patches
• Databases lock management
• Regular monitoring of System logs
• Performing Various Daily ,weekly and monthly programs
• Managing all the instances which include 2 production database along with many test instances.
• Monitoring Tablespaces
• Cloning EBS instances R12.1.2
• Upgraded EBS instance from R12.0.6 to R12.1.2 in test instances
• Upgraded Databases( from 10.2.0.1 to 11.2.0.2)
• Application of NLS patches and request for Translation Synchronization Patches.
• Taking Care of Clients requests.
• Performing SYSADMIN related tasks of Oracle Applications.
• Administering the Oracle 10G Discoverer.
• Installing, Configuring, troubleshooting, upgrading and monitoring OBIEE & BI Apps.
• Completed the up gradation of 10g OBIEE to 11g OBIEE
• Administering the 10g RAC environment which is being used for the Site ERP solutions.

Escalating the issue to oracle with SR raising on oracle and implementing the solution according to the business requirement

Worked as a part of team supporting for multiple projects like below from offshore india

AMSC Oracle APPS DBA (Implementation Project) USA

Starrett Oracle APPS DBA (Up gradation Project) USA

Calipers USA - OBIEE Implementation & Apps DBA Support

RISO Oracle Apps DBA & OBIEE

Project-5: OBIEE Support with Databases

Client: WYNDHAM World Wide

Team Size: 2

Technologies: OBIEE,Oracle 10G AS and BI Apps on Solaris

Role : DBA

Operating Systems: Sun Solaris

Responsibilities:

• Installing and Configuring OBIEE and BI Apps.
• Monitoring and maintaining OBIEE
• Performing all kinds of OBIEE Sys Admin related tasks
• Up gradations of OBIEE
• Installing and configuring Oracle 10g AS
• Troubleshooting and Maintaining Oracle 10g AS
• Creating and Maintaining Data sources of OBIEE which includes Oracle, sql server, Mysql.
• Installing, configuring and maintaining ODI, Informatica and DAC.
• Upgraded Informatica from 7.1.4 to 8.6.1
• Upgraded Dac from 7.9.4 to 10.1.3.4.1 standalone version Creating and maintaining Data warehouse databases for OBIEE instances for PROD and test instances.

Project-6: SQL Server

Client: American Towers Corporation

Team Size: 3

Technologies: SQL Server 2000,2005 & 2008

Role : DBA

Operating Systems: Windows Server 2000

Responsibilities:

• Installation of MS SQL Server 2000 & 2005
• Backup Strategy for the production instance.
• Creating the Maintenance plan for taking the regular backups.
• Security in SQL Server that includes Logins, Roles,
• Database Availability in SQL Server that includes Replication and Log Shipping
• Monitoring the SQL Server performance.
• Monitoring SQL server log files and system log file and checking for any errors.
• Monitoring the custom application performance which is using sql server database.
• Applying the patches (Sql server and Custom Application)
• Cloning the database and application
• Installing and using Lite Speed for SQL Server which includes creating backups, recovery and maintenance plans

Maintaining around 12 Oracle PROD DBs including 1 R12 Apps Instance, 200 PROD Sql Databases.Changed the complete backup strategy of all Oracle Instances to Oracle Standards using RMan.Configured Oracle 10g Grid Control to monitor all the instances from a single point.Created Cron jobs for database alerts and backupHealth checkup of oracle application instances (Prod,Test, Development and UAT)Checking Alert log, Apache log, and concurrent manager log files dailyChecking and compiling invalid objects, clearing cache and bouncing the ApacheAdministrating and responding to Oracle SRsPerforming system administration job and AOL.Trouble shooting various issues during day-to-day activitiesAdministering and maintaining 3 databases (Prod,Test and Development)Installed and configured OBIEEImport and export of the schemas from one database to anotherMonitoring TablespaceMonitoring alert logs (e.g. using custom scripts to look for ORA-600 errors)Cloning instances of .R12Patch analysis and applying patches as requestedApplying Database Patches and application patches.Writing Scripts in Linux to automate monitoring processes for the database and Applications.(e.g. Database Growth scripts, Tablespace monitor scripts etc.)Performing weekly and monthly activities in database and Application.Setting up oracle Database in new server.Taking Database performance by running AWR reports weekly.Working closely with SR in case of any issue.Implementing RMAN incremental backups with catalog mode and scheduling it to run daily.Worked on schema migration using export import utility.Installing, configuring and administering the Oracle 10G Discoverer.Configured Stand by database.Configured OEM Grid Control.Performing all sysadmin related tasks.

Moved the complete masafi data center from Etisalat Datacenter to Masafi Warehouse.Configured the Disaster recovery for PROD using Data Guard.Configured Workflow mailer in EBS R12.Changed the complete backup strategy of all Oracle Instances to Oracle Standards using RMan.Configured Oracle 10g Grid Control to monitor all the instances from a single point.Created Cron jobs for database alerts and backupHealth checkup of oracle application instances (Prod,Test, Development and UAT.