TECHNICAL SKILLS:

• Oracle DB 10g/11g/12c
• RAC (5yrs), TOAD 11.5,
• UNIX scripting (10yrs)
• Oracle E - Business 12.1
• Oracle Discoverer plus 11.1.1.6.0, PS SCM
• Data Warehouse (6yrs)
• Oracle RMAN (10yrs) & AVAMAR,
• SQLPlus,PL/SQL, T-SQL,Cellcli,Dcli .
• TIBCO, PlateSpin migrate,PlateSpin Recon, PlateSpin Protect P2V, V2P, V2V,Goldengate
• Performance Tuning, Upgrades (10yrs)
• Oracle DataGuard
• Exadata/Exalogic ZFS
• OEM 12c Cloud Control
• SQL Server 20, MYSQL 5.6
• Platforms (Linux, Solaris, Windows, HP-UX, AIX)
• ASM, ASMCMD
• Big data, Hadoop, Tuxedo, Weblogic, NoSQL, Oracle cloud, Traffic Director

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• As a lead DBA, Provided technical expertise for the planning, analysis, design, implementation, and support of the company ECOM and data warehouse systems running in sixteen different Oracle RAC clusters.
• Supported PeopleSoft Financial /SCM and SAP applications . Provided technical assistance for backup, performance tuning, network administration, maintenance, migration, patches and upgrade support for more than 185 oracle and instances running in Linux, AIX and windows platform.
• Installed and configured Goldengate 12c and dataguard v11 in the primary and DR systems move/replicate database and, Diagnosed and resolved database issues related to but not limited to installation, configuration and performance Oracle RAC in Linux and SQL Server 2012 running Windows Virtual Server 2012 SP2.
• Perform database maintenance as per Company requirements, scheduled cron jobs to maintain automation of database backups. Implementing high availability concepts like mirroring & replication. Plan, schedule and coordinate database/application patching, and Implemented Database refresh, upgrade and migration as requested.
• Lead the Migration of ASM diskgroups/disks using Oracle OEM 12c cloud control and sometime SQL commad line.
• Used OEM12 cloud control and Bigbrother for monitoring and support of the systems running in Oracle 9i, 10g 11g and 12c -2
• Installed and configured Goldengate in the SCM space, to replicate between OLTP and OLAP PeopleSoft SCM environments. Also dataguard configured to support the physical and logical standby database for Disaster Recovery. Also used Recover point replication to establish a DR and maintained a Continious data capture between the source (Prod) and target servers (DR).
• Manage all aspects of physical database administration including setup, installations, upgrades, patches, security, backup and recovery, space management, performance tuning, schema management and capacity planning for Oracle 11g Enterprise Data Warehouse., Monitor the Exadata Database Machines in Production, Dev and BC environments. Assist in Exadata upgrades, Support Application teams and their projects to enhance, troubleshoot and performance tune while exploring SQL programming for query performance improvements, Support Oracle Databases in Production, Test and Development environments, Install, upgrade and test Oracle Gateway software.

Confidential

Sr. Oracle/SQLServer/Exadata Database Administrator

Responsibilities:

• Provided technical expertise for the planning, analysis, design, implementation, and build of a datacenter and Disaster Recovery system. Served as the Lead Oracle/Exadata DBA and supported 78 Oracle instances running on different servers as standalone and sis different RAC clusters running in two Exadata rack X2-2 and X3-2 and X5-2
• Supported PeopleSoft Financial /SCM and SAP applications running in Exalogic X2-2. Provided technical assistance for backup, performance tuning, network administration, maintenance, migration and upgrade support for more than 243 oracle and SQL Serverinstances running in Linux and windows platform housed in VBlock 720 and 340 racks. Assisted in integration of Exalogic applications into current IT actionable events and solutions. Implemented procedures for database performance and tuning of all database instances in the Exadata rack. Created certified processes and procedures for maintenance and upgrading of all database machines. Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Installed and configured Goldengate 12c and dataguard v11 in the primary and DR datacenters to move/replicate database in VBlock.Monitored, Diagnosed and resolved database issues related to but not limited to installation, configuration and performance Oracle RAC in Linux and SQL Server 2012 running Windows Server 2012 SP2.
• Perform database maintenance as per Company requirements and schedule cron jobs to maintain automation of database backups. Implementing high availability concepts like mirroring & replication. Plan, schedule and coordinate database/application patching, and Implemented Database refresh, upgrade and migration as requested.
• Lead the Migration of EBS R12.1.3 to 12.2 -- Migrate Single Instance to RAC, Setup PCP, and Configure Active Data Guard - Goldengate replication to a reporting system. Developed strategies for disaster recovery services of all database machines along with advisory services. Used PlateSpin Migrate to automate the migration of workloads among physical, virtual machines and volume imaging housed in both Windows and Linux platforms.
• Used Hadoop & NoSQL to analyze Big data generated by scanners, mobile devises, Readers, science facilities and produced meaningful outputs. Used Oracle Traffic Director to optimize application-to application communication in our Exalogic X5-2. and X3-2
• Supported three two nodes Oracle clusters running in Exadata X2-2 Machine and another two node cluster running in X3-2 Machine using applications running in X4-2 Exalogic machine. Installed and configured Goldengate in the SCM space, to replicate between OLTP and OLAP PeopleSoft SCM environments. Also dataguard configured to support the physical and logical standby database for Disaster Recovery. Also used PlateSpin Protect to establish a Prod Physical server and Virtual server DR and maintained a Continious data capture between the source (Prod) and target Virtual servers (DR).

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Played an active role in monitoring the overall performance and tuning the various Oracle 11.2.3 production databases running in Solaris spark 10 and in windows server 2008. Also supported several other Oracle 11g instances running in test and development servers. Strong Experience in performance tuning and large DB migration
• Supported and monitored the Oracle E-business apps 12.1, the concurrent manager and Discoverer plus 11.1.1.6. Applied needed application and database patches including adpatches and CPU/SPU patches. Also cloned the Database/apps using rapidclone as needed by developers and apps admins for testing with live production data of more 7.3TB.
• Advanced skills and proven experience with Oracle 10g/11g RAC, Strong Database and RAC implementations experience and troubleshooting skills in mission critical environment
• Setting up and maintaining DataGuard on 10g/11g with MAA, Strong knowledge of Oracle Database
• Installed Oracle dataguard to support our current production database as primary and our DR database as
• Conducted a successful PCP exercise to switchover from Production primary to our DR standby database and physical standby and a logical standby databases.
• Handled security issues concerning creating and administering roles, object and system privileges for users, user account creation, and maintenance, and installed and configured Oracle database 12c in a windows server.
• Migrate and compile scripts and packages from one instance to other as needed by the developers.
• Successfully installed and configured Oracle Enterprise Manager 12c Cloud Control. Also installed 11g database, Weblogic, configured Oracle Management Server in Linux and configured 12c agents in all the production servers and some test server making it possible to monitor, maintain, apply patches and clone the monitored database instances as needed.

Confidential

Sr. Database Administrator

Responsibilities:

• Troubleshot and resolved major tuning issues with Oracle 10g in four UNIX boxes. Converted two old Solaris boxes running Oracle 9i to Oracle 10g. Also reinstalled and maintained four boxes running Oracle 11g R 2 and RAC. Lead the project of building, implementing and maintaining Oracle DataGuard in the current 11g Oracle database server and SAP environment. Produced entity relationship diagrams, Data definition language parameters, database normalization schemas, and oversee Logical to physical database mapping. Responsible for database maintenance, UNIX scripting, Oracle Data Guard, DR, ASM, Grid Control, and RMAN support.
• Managed and supported several oracle DB instance running in production housing high traffic online extraction, analysis and ipayment applications. Used Oracle GoldenGate to move data between like-to-like and heterogeneous systems, and between Oracle and non-Oracle databases including Microsoft SQL Server and MySql, Lead major Migration project from MySql to Oracle 11g

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Support a fifteen-terabyte data warehouse; play a lead role in enterprise-wide database optimization and instance and resource monitoring. Perform root cause analysis on failures. Resolve performance tuning related issues, reports, and queries. Support existing 10g RAC three node Database
• Started and managed biweekly optimization meetings with enterprise user groups to address and resolve performance-related issues with a high degree of success. Also installed, monitor and maintain 85 SQL Server 2005/2008 database instances. Recently installed SQL SERVER 2012
• Successfully set up a four-node cluster and RAC data warehouse on Linux (Oracle UBL) using ASM/OCFS2. Identified, led, and established automation of repetitive processes to minimize errors
• Also carried out configuration, performance tuning, applying patches, working with stored procedures, triggers, security, troubleshooting, and managing backup and recovery plans for all the databases. Completely eliminated space errors by implementing proactive space monitoring and effective space allocation. Experience with BIDS, SSRS and SSIS

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Installed, upgrade and configured Oracle Enterprise Databases 11.1 to 11.2 and configure dataguard 11g for DR with two physical standby database and one logical standby database for upgrade, migrations and patch sets application
• Used AWR report, ADDM, V$view, trace files, SQL trace and SQLplan, Alert log, tkproff, iostats,vmstat, netstat etc to handle proactive SQL and DB performance tuning. User RMAN, dpimp/dpexp, transportable tablespaces, Oracle dataguard, goldengate, OS copy etc for managing backup and recoveries.
• Used Goldengate to perform a zero downtime cross platform database migration (AIX to Red Hat Linux) and also a database upgrade and patch application from 10g to 11g Release 2 using a combination of RMAN, Cross Platform Transportable Tablespace (TTS) and GoldenGate

Confidential

Computer Scientist/ Sr. DBA (Contractor)

Responsibilities:

• Installed and configured Enterprise Management Grid control 11g R 1 (11.1.0.1) on Linux x86 with Oracle 11g R 2 RDBMS and WebLogic Server. Also install the corresponding OEM grid agents in all the 15 server having Oracle instances including RAC
• Used the Standby Database wizard to create a physical, snapshot, and logical standby database or import an existing physical, snapshot, or logical (RAC or non-RAC) standby database. Supported the existing Dataguard 11.
• Performed SQL tuning by using Explain Plan and Tkprof AWR, ADDM reports, Making structural changes to the databases when database design changes are to be implemented
• Implementation and maintenance of read only snapshots and snapshot logs Migration from Oracle 10g R2 to Oracle 11R2 using Oracle Data Migration Assistant and other utility. Refreshing development/test database from production using Export/Import

Confidential

Sr. Database Administrator

Responsibilities:

• Installed Oracle 10g in four UNIX boxes. Upgraded two Solaris boxes running Oracle 9i to Oracle 10g. Also installed and maintained a box running Oracle 11g R 2. Lead the project of building, implementing and supporting Oracle DataGuard in the current 10g Oracle database server and SAP environment
• Used AWR report, ADDM, V$view, trace files, SQL trace and SQLplan, Alert log, tkproff, iostats,vmstat, netstat etc to handle proactive SQL and DB performance tuning. User RMAN, dpimp/dpexp, transportable tablespaces, Oracle dataguard, goldengate, OS copy etc for managing backup, migration, upgrades and recoveries
• Managed and support several oracle DB instance running in production housing high traffic online banking applications like Cashplus, Payplus, Ipayment
• Installed and configured 11g R2 (11.2.0.1) 3-Node RAC primary to 2-Node RAC Physical Standby DataGuard on Oracle Enterprise Linux
• Used Goldengate to perform a zero downtime cross platform database migration (AIX to Red Hat Linux) and also a database upgrade from 10g to 11g Release 2 using a combination of RMAN, Cross Platform Transportable Tablespace (TTS) and GoldenGate. On-call responsibilities include 24/7 coverage

Confidential

Sr. Database Administrator

Responsibilities:

• Installed Oracle RDBMS 10g and 11g and upgraded Oracle 9i to Oracle 10g using existing dataguard standby DB. Also supported the system on call 24x7. Also installed, monitor and maintain 115 SQL Server 2000 databases. Installed and supported Red Hat clustering
• Lead the project of implementing and maintaining two node Oracle 10g RAC on LINUX X86 64 RHEL 3AS Oracle database server. For Shared Storage used OCFS for Cluster Registry and Voting Disks & ASM for all other database related files. Installed, supported and maintained Tivoli Media manager
• Used Goldengate to perform a zero downtime cross platform database migration (AIX to Red Hat Linux) and also a database upgrade and patch application from 10g to 11g Release 2 using a combination of RMAN, Cross Platform Transportable Tablespace (TTS) and GoldenGate
• Created Data Guard configurations that in corporate a primary database, to new or existing (physical, logical, or snapshot) standby database, redo transport services, and log apply services
• Installed Oracle GoldenGate on Oracle Media Pack for Linux x86-64 on an Oracle 11g database. Configure data pump, manager, extract source and destination to tables, data from DB in AIX to DB in Linux

Confidential

Sr. Database Administrator

Responsibilities:

• Led Oracle DBA. Administer, monitor and maintain 36 Oracle databases and SAP running mostly in UNIX boxes and windows 2003 server. Implemented and supported McKesson Meds Manager Bundle application (HMM, HCI & HCR) Also installed, monitor and maintain 315 SQL Server databases. Experience with SSRS and SSIS
• Installed, configured and supported OEM grid control 10g. Install and configure oracle RAC (four nodes) in four different machines in production servers. Apply parches to upgraded the database from 9.2.0.1 to 9.2.0.7. Design, develop and test processes to extract, transform, and load (ETL) data from varying data sources to the data warehouse
• Participated Oracle Financial 11.0.3 to 11.5.8 upgrade with migration from HP-UX to Linux Suse 7 SLES.Upgraded and supported multi-country, multi-language 11.5.8 to 11.5.9 installation of virtually all financial and discrete manufacturing modules, including DP, ASCP, Call Center and Email Center

Confidential

Sr. Database Administrator

Responsibilities:

• Administered, monitored and maintained 28 Oracle databases running mostly in UNIX box with six databases running on windows 2003 server. Also monitor and maintain 286 SQL Server databases running 67 different application servers. Install and configured Oracle 10gAS (on windows server 2003) clustered application server in two production boxes. implemented and supported McKesson Meds Manager bundle application (HMM, HCI & HCR)
• Installed and configured oracle RAC in four different nodes in production servers. Use Oracle Grid Control Software within Oracle Enterprise Manager 10g for automatic grid monitoring, space management, performance monitoring and alerting DBA and other System Managers. Applied parches to upgraded the database as the system requires. Strong experience in database maintenance and UNIX scripting, Oracle Data Guard, ASM, Grid Control, and RMAN

Confidential

Sr. Database Administrator

Responsibilities:

• Designed and wrote ETL code using PL/SQL to extract and load large data from seven different severs into the Confidential data mart. Installed Oracle RDBMS 9.2.0.6 and created the test, QA and production database. Support the need of seven Business Object developer needs for creating and maintaining the Universe
• Installed and configured Oracle Enterprise Manager Grid control, and also implemented the OEM agents in all servers housing oracle instance. Used Oracle Enterprise Manager 10g grid monitoring, space management, performance monitoring and alerting DBA and other System Managers. Designs, implements and maintains complex databases and database dictionaries, overall monitoring of standards and procedures, and integration of systems through database design
• Performed backup and recovery management/Strategies using Oracle tool RMAN, dataguard, imp/exp, transportable tablespaces and third party tool Veritas Backup

Confidential

Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle 10gAS (on windows server 2003) clustered application server in two production boxes, Install and configure oracle RAC in four different machines in production servers. Upgraded the database from 9.2.0.4 to 9.2.0.5. Assisted in transitioning applications to cluster environment, configured and tuned the cluster database (four nodes) for better performance
• Installed and configured oracle database 9.2.0.4 in test machine, and later applied patch to upgrade to 9.2.0.6. Administer and maintain two Oracle Application Server 10gAS, four GSSIS database servers, two GTID/Verification application servers, two ETL severs, two Web servers, two Cognos application Reports Servers, and Two ftp servers
• Performed regular monitoring, tuning and maintenance of Production/test databases, Web services, forms and reports services. Troubleshoot Database and Web server related problems and make sure to keep the downtime to a minimum. Created new databases as needed. 24x7 on call support

Confidential

Sr. Business Systems Analyst

Responsibilities:

• Worked with AMDOCS Billing team to redesign, test, and run and implement new application Fix/changes Provide production DBA activities with 24 x 7 support for Oracle database in Ensemble. Assisted in installing, testing and implementing the Enabler system. Perform Backup/recovery, database refresh, database performance and tuning
• Installed, Developed, monitored, and maintained Oracle 8i/9i database, stored procedures, functions, triggers, packages and instance. Designed data warehouse / data mart system ETL, and created relational data objects eg tables, views, materialized views, sequences, external tables

Confidential

DBA /Business Systems Analyst

Responsibilities:

• Provided administrative supports for PEOPLESOFT 7.5 and 8 with Oracle running on HP. Upgraded the application from 7.5 to 8.0. Provided migrations of SQL and SQR patches
• Installed, Migrated, Upgraded, and Configured Oracle Applications 10.5 to 11 and Databases running on various platforms including Solaris, Linux and HP servers
• Coordinated and participated in 24x7 on Call DBA Support and served as the main analyst for the AMDOCS Ensemble conversion. Managed and maintained all jobs, tables, applications relating to Billing and Obligation modules

Confidential

Database/Application Developer

Responsibilities:

• Performed numerous Oracle Database and Tools upgrades from RDBMS version 7 through 9i. Performed numerous application and database tuning assignments on Oracle Applications, legacy, custom and third party systems
• Used PL/SQL and SQL*Plus to developed a major archive program that compiles all account payable information in the Oracle financial system, Maintained and managed several programs written in C++ and Pro*C used for report creation in the Oracle and Sybase databases
• Managed the fixed assets (FA), Payable (PA), GL, Order entry and purchasing modules of the oracle financial system, used the concurrent manager to schedule oracle jobs and reports