SUMMARY:

• Total 14+ years of IT industry experience as astute Oracle database administrator with focus on creating strategic solutions, Implementation, Rollout, Upgrade, Support and Proposal Activities and leading key customer engagements for Oracle E - business suite applications DBA Activities.
• Leading a team of 15 DBAs and handling a range of 500+ Oracle database administration into 24x7 support model On/Off across globe and responsible for supporting various database issue used by business groups within Customer domain
• Worked in the volume of Solution Architect/ Lead Appsdba/Senior Oracle DBA performed in previous engagements and having Strong Technical hands in IT as Oracle database administrator in high - end enterprise environment of more than 600 databases (DB size: from 100 GB to 6 TB)
• Leading weekly/monthly meetings with Customer leadership team, Organizational stake holders, team members, GDC Partners to review assignment priorities, anticipate work items needs, assess and manage DB & Apps users portfolios and develop strategies for key priorities work items.
• Analyzing ticket request and projects to determine level of detail and resources required, communicating clearly with clients about expected outcome and timeline, and delivering targeted expectation/information that is accurate and actionable.
• Maintaining an expectation of excellence in both written and verbal communication, as well as a dedication to superior customer service with an emphasis on relationship building.
• Staying abreast of trends in prospect all latest DB/OS release by reading relevant news articles and white papers, testing out new products, and sharing ideas and information with colleagues.
• Continuously developing knowledge and professional skills through internal/external trainings, shadowing of colleagues, research works, and local and regional conferences and workshops.
• As Senior member, he is also accountable for developing junior members expertise with regard to corporate ethics & culture. Worked on the Project Plan, Project Estimation for the various projects, gather the system requirements and prepare scope document for DBA activities. have participated in a wide array of activities in support of multi-tier production and development environments which include the installation and configuration of Oracle RDBMS versions 12c, 11g, 10g on UNIX/Linux/Windows platforms, database administration, production support, installation, configuration, upgrades, patches, database security, troubleshooting database design, UNIX shell scripting, Backups and Recoveries, Data pump, Data Replication, Performance Tuning and OEM.
• Hands on experience on Oracle 10g/11gR1/11gR2/12c, installed and configured on different platforms like Linux, RHEL, Oracle Solaris,
• Experience in configuring high availability systems like Real Application Clusters RAC.
• Experience in installation of Oracle RAC with ASM and manage RAC instance using Crsctl and Svrctl utility.
• Planned and Implemented Disaster Recovery DR and HA using RAC, Data Guard, Oracle VCS
• Experience in configuring, managing and monitoring both Physical standby and Logical standby database using Data Guard and Have hands on experience on Active Data guard.
• Having good experience in migrating databases with zero downtime across the cross platforms.
• Having good experience in Installation of 12C Grid Control and experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control OEM grid 12c /11g.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control OEM.
• Experience in installation and configuration of Oracle Golden gate GG both unidirectional and bidirectional.
• Cloning of Oracle Applications 11i Database with Rapid Clone, Auto Config and Rapid install in Single Node & Two Node environment.
• Extensive usage of AD Utilities like Adpatch, Adadmin, Adctrl, License manager, Adaimgr (Auto Upgrade) etc.
• Having good experience in Installation of 12C Grid Control on OEL 6.3 and experience in mo
• Hands on experience for Oracle Applications upgrade from 11.5.8 to 11.5.9/11.5.10.2 by applying maintenance and family packs.
• Generate and interpret Automatic Workload Repository AWR, Active Session History ASH, and Automatic Database Diagnostic Monitor ADDM reports using OEM.
• Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance.
• Experience in implementing and planning backup and recovery strategies using Recovery Manager RMAN. Performed block recovery, data files and databases using RMAN.
• Created cloned databases for development and test environments using RMAN and User managed cloning
• Installed patches using Opatch utility and upgraded databases from 9i/10g to 11gr2 and expertise in applying Oracle PSU and CPU patches.
• Implemented data transfer using Transportable Table Spaces TTS, Data Pumps and Export/Import utilities.
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Utilized SQL Loader to migrate or load data to Oracle.
• Experience in using SQL, PL/ SQL procedures, functions, triggers and packages.
• Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.
• Worked on different types of storage structures SAN/NAS.
• Good knowledge on Oracle support process for technical requests using Metal link and other support features.
• Good written and verbal communication skills, self-motivated team player and good analytical thinking.
• 24*7 on-call production database support and maintained remotely.
• Well adhered to ITSM and ITIL processes like change control, problem management, incident management
• Adhered to security compliance like and SOX compliance
• Managing strong team of 15 experienced DBAs in offshore onshore support model
• Expertise in Complete Oracle database lifecycle from concept to design, architecture, hardware selection, installation and patches.
• Well versed in Installing JAVA, Spatial, XML, InterMedia on various Production/Dev/Test databases.
• Experience in using 10g Data pump, ASM, ADDM, and AWR.
• Experience in executing performance Tests, Performance Analysis, and Performance Tuning
• Strong hands-on experience in setting up disaster recovery environment (SRDF/BCV) for Oracle Database based applications, implementing Oracle Golden Gate Replication setup, VCS, OEM 12C Administration, 11g RMAN for backup and recovery, Data guard - Physical and logical standby database management, 12c/11g Data pump, ADDM, AWR along with Oracle database backup and recovery, performance tuning and troubleshooting, sizing and space management.
• Possesses very good technical skills combined with outstanding leadership ability, project management and creative problem-solving skills in both strategic and tactical areas.

TECHNICAL SKILLS:

Oracle 12c/11g/10g: 11i/R12

Operating Systems: Sun Solaris 5.8/5.9/5.10, Red Hat Linux RHEL 5.x 6.x, Windows 2000/2003

Languages: UNIX Shell Scripting, SQL, PL/SQLOracle Advanced Features Oracle Applications R12/11i (11.5.8/11.5.9 ), VCS, Oracle Data Guard 11g/10g, Oracle RAC 11g R2, Oracle Golden Gate

Tools: /Utilities Oracle Enterprise Manager OEM Grid Control 12c, Toad, SQL Navigator, SQL Loader, AWR, Patch Management, Data pump, Data Guard

PROFESSIONAL EXPERIENCE:

Lead Oracle DBA (Solution Architect)

CONFIDENTIAL, Norwalk, CT

• Leading a team of 15 DBAs and handling a range of 500+ Oracle database administration into 24x7 support model On/Off across globe and responsible for supporting various database issue used by business groups within Customer domain.
• Automated daily database health check process by designing, developing a set of batch and SQL/PL-SQL scripts, reduced daily database checking time significantly
• Developed and automated database and windows system cleanup process by oracle RMAN, batch and SQL scripting. eliminated existing database hang issue caused by disk space and fast recovery area fullness.
• Designed, create and implemented database backup/recovery strategies and processes. Created a comprehensive script set for database backup including cold, hot, export backup with various methods: tablespace-based backup, RMAN etc. Practiced and expertise in different recovery scenarios including Flashback and data miner.
• Automated database, system, and Oracle Application Server by creating different scripts in shell, Perl and PL/SQL for security auditing, health check, system monitoring, backup, log file clean, performance tuning etc. All reports and alert messages are automatically sent to DBAs/SAs via email.
• Responsible for on-call duty for system and customer support. Expert in database performance tuning using Statspack, SQL Trace, Event Analysis, Automatic Database Diagnostic Monitor (ADDM) and Automatic Workload Repository (AWR).
• Installed and utilized Oracle Management technology Oracle Grid Control
• Created, configured, monitored, and re-instantiated oracle database Data Guard. Performed failover, role switch and read-only report on Data Guard.
• Installed, configured, implemented and maintained Ora9iAS and Ora10gAs for Business Intelligence
• Resolved standby database synchronization issue, configured and initiated standby database using RMAN backup/recovery mechanism.
• Established and automated local RMAN backup process via RMAN, batch and SQL scripting, MML client configuration. Worked on Golden Gate replication design, installing, configuration.
• Upgrading current production database systems from 11gR2 to 12c, including 12c installation, CPU patching, database migration with data pumping tools.
• Implemented database security configuration in the new production, including database wallet, tablespace encryption, access control list (ACL) and user profiles/roles management.
• Responsible for Application release deployment, production support, application database-related issue troubleshooting in development, testing and production systems.
• DR & ORT Support: Conducting quarterly DR/ORT test using SRDF/BCV split method & ORT method for all Mission critical apps across GE CAPITAL as per Compliance/Audit guidelines, all applications must execute a Disaster Recovery (DR) test, though non-critical applications can ride along.
• Critical SPU Patching: Applying Semi-Annual CPU/SPU ORACLE Security patches to GECA PRODUCTION AND Non-Prod databases along with Installations, Cloning, Patching, Upgradations, Migration of Oracle databases.
• Performance tuning proactive support to all performance related issues happening in all Oracle databases across GECA with use of AWR, ADDM, ASH, SQL Tuning Advisor.
• OEM 12C Administration: Implementation of OEM 12c across various Non-Production database for 24*7 proactive alert monitoring. Proactive response based support to all database related alerts which come through Server monitoring scripts and troubleshooting with RCA.
• Audit and Compliance: Maintaining audit & compliance standards across all GECA Production/Non-Production databases using multiple audit scripts. Monitoring database space issues, backups, availability of databases to the users and log files.
• Golden Gate Replication Setup:
• Installing GG software on source/target database, setting up Golden gate replication processes (Manager process, Capture Extract process, replication process), Troubleshooting issues related to GG replication.
• 24*7 DBA support by maintaining successful onshore-offshore model, including multiple geographical support from Onsite (US/UK) and Offshore (INDIA) from NOIDA, Bengaluru and HYDERABAD. setting and maintaining OEM 12c (OEM agent deployment, OMS installation) for Monitoring all database & Troubleshooting issues related to OEM 12c.
• Extensive usage of AWR, ADDM, ASH, SQLH reports to counter performance issue and Work closely with developments team for various day to day database issues.
• Make non-prod databases available after cloning from Production hot backup/cold backup based on various application team request.
• Supporting Application team in various production deployments, Installing Oracle clients on application servers, data/schema migration from prod to non-prod using extensive usage of data pump.
• Establish and standardize best practices and implementation methodologies for support & maintenance efficiency.
• Coordinate project deliverables with clients, internal resources, Off-shore Resources and third-party partners. Support and build security system-features to conform to audit procedures mandates.
• Data migration and optimization of data placement and organization (partitioning & Materialized-view deployment/use).
• As an Accomplished Oracle-certified DBA with expertise in performance tuning, crisis management, and high availability I am responsible of making sure of systems ‘increased reliability and maximized productivity.

Confidential

Lead Oracle DBA (System Analyst)

• As DBA lead for Data Center Migration, extensively involved in architecture, hardware selection, installation and patches, database creation, backup/recovery scripting and database performance monitoring, automated scripted creation and refresh of reporting databases from production for the new 10g servers.
• Created Oracle 10g databases for Willow production/dev/qa/support environment
• Migration of Oracle 8i from old server to Oracle 10g on new Server using full export/import.
• Installing JAVA, Spatial, XML, intermedia on newly built Oracle 10g server for various Production/Dev/Test databases.
• Completed Oracle character set migration from single byte like US7ASCII, WE8ISO8859P1 to Multibytes like AL16UTF16, UTF8
• Managing Databases, including security, space management, database migrations, database and system tuning, database refreshes, backups and restores, and user resource management.
• Maintain production databases to ensure integrity, performance, accessibility, and recoverability of data.
• Production Support including rotating On Call duties with other team members.
• Develop long-term strategy for historical data retention and archival plan for storage needs; defines data retention, backup, and recovery for all data.
• Recommend and implement new Oracle features or software enhancements
• Coordinate with development teams to ensure that implementation regarding infrastructure security are fully understood and can be leveraged.
• Troubleshoot and tune for system and performance problems; identifies and resolves information flow, content issues, and assist with transformation of business requirements into logical data models
• Established database backup/recovery strategy for different databases
• Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
• Performance tuning several production databases using AWR, Statspack, Autotrace, tkprof
• Backup & Recovery management
• Performing database cloning UAT environments
• Application monitoring and handling application issues with database
• Meeting with application owner/developers to plan of Go-Live and progress of the project.
• Extensively involved in dry run of each Production database on new 10g server.
• Tuning queries giving issues in production/QA databases using statspack, AWR
• Monitoring of space on File systems on servers & Table spaces
• Patch deployment in various environment

  Duties included database creation, tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers

Confidential

Lead Oracle Apps DBA

• Cloning of Oracle Applications 11i Database with Rapid Clone, Auto Config and Rapid install in Single Node & Two Node environment.
• Extensive usage of AD Utilities like Adpatch, Adadmin, Adctrl, License manager, Adaimgr (Auto Upgrade) etc.
• Hands on experience for Oracle Applications upgrade from 11.5.8 to 11.5.9/11.5.10.2 by applying maintenance and family packs.
• Troubleshooting of Applications 11i issues (Forms/ Apache/ Discoverer/ Concurrent Manager)
• Hands on experience on Oracle Discoverer Upgrade/Jinitiator upgrade from 1.1.8.16 to 1.1.8.25
• Oracle OCM Installation for 11i application instances.
• Experienced in Oracle 11i System Administration tasks like Creating Applications Users, Registering Reports, and Installing Printers etc
• Experienced in Cloning and Patching for Oracle applications 11.5.10,11.5.9 and 11.5.8
• Applying mini packs and consolidated patches with Adpatch utility.
• Hands-on experience in Discoverer Upgrade from 4.1.41 to 4.1.48
• Creation of Database Application Users and Front end Application users. Managing Data Groups and Request Groups and Menus.
• Creation of Specialized Concurrent Managers, Assigning Work shifts.
• Handled/supported technical issues related to Application and database including patch management and dealing with Oracle Support for many production and test/development databases
• Troubleshooting issues related to concurrent manager
• Experience in Performing performance Tests, Performance Analysis, Performance Tuning
• Capacity planning, Install, configure OLTP, Data warehouse (DSS) databases (Oracle 9i & 10GR2) Either in shared environment/standalone environment as well as on VMware virtual machines.
• Involved in database upgrade from 11.1.0.6 to 11.1.0.7 for DEV and TEST environments.
• Experience in configuring and maintaining Oracle Replication by using Oracle streams for Data replication from production system to Data warehouse on RAC Environment.
• Implemented the database with ASM storage, skilled towards database tuning and hands on experience in database security (auditing), recovery, archival concepts and procedures.
• Configured and Managed ASM disks and disk groups through Grid Control utility.
• Upgrade the production and development databases from 9i to 10g
• Created and maintained standby databases using database replication (Data Guard) for high availability.
• Performing SQL*Loader jobs for loading data from text files
• Disaster recovery planning; implemented database backups and disaster recovery strategies using RMAN and data pump export, import.
• Supported very large database with heavy OLTP and batch activities, Writing and testing PL/SQL procedures (stored procedure, triggers, function, cursors and packages) for maintaining tables, retrieving data from tables and managing users. Responsibilities included working with developers to tune the PL/SQL, SQL.
• Actively worked on performance tuning of instance (SGA and PGA) and Physical database that included resolving fragmentation and disk contention. Use Partitioning and indexing feature of Oracle 10g to improve performance.
• Designed and Implemented database security using Oracle roles and privileges.
• Experienced in optimizing SQL and PL/SQL tuning using CBO, explain plan, TKPROF, STATSPACK, ADDM, and AWR.
• Involved In query optimization and using rule based optimizers and cost based optimizers
• Work with a geographically dispersed team for round-the-clock monitoring of production systems
• Cloning and patching for Oracle 11.5.8, and 11.5.9,11.5.10
• Completed export and import of different databases using Oracle Export / Import utilities and data pump.