TECHNICAL SKILLS:

• Oracle DB 10g/11g/12c/13c/18c
• RAC (5yrs), TOAD 11.5,
• UNIX scripting (10yrs)
• Oracle E - Business 12.1
• Oracle RMAN (10yrs)
• Data Warehouse (6yrs)
• (AWS), (EC2), & RDS . VPC. Azure virtual machine (VM)
• Data Replication
• SQLPlus, PL/SQL, Exadata, Cellcli,Dcli.DB2 DB2 UDB
• PlateSpin migrate, PlateSpin Recon, PlateSpin Protect P2V, V2P, V2V,Goldengate
• Performance Tuning, LUW Upgrades (10yrs)
• Active DataGuard
• OEM 12c Cloud Control
• DB2 SQL Server 20012/2014 2008 , MYSQL 5.6
• Platforms (Linux, Solaris, Windows, HP-UX, AIX)
• ASM, ASMCMD
• Big data, Hadoop, Tuxedo, Weblogic, NoSQL, Oracle.
• Oracle Data Pump Export, Tsunami UDP
• AWS Database Migration Service,

PROFESSIONAL EXPERIENCE:

Confidential, Alabama

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 Developed scripts for the creation of the physical database schema, data security and protection. Administration skills in sizing, capacity planning in large-scale enterprise environment, Design, document and build table, column, index and view definitions to storage requirements and drive space and growth accommodations, Optimize and tuning of workloads, query or package changes and optimizations to ensure and improve system performance and reliability, designed, monitored, and administer databases, Determine processes that should be developed/automated to improve efficiency and reliability, Experienced planning and installing Oracle RAC databases on 11g an 12g.
• Worked with network and storage teams to plan and create environments. Responsible for the creation and maintenance of complex UNIX shell scripts for the administration of databases
• 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’
• Strong experience on Red hat Linux and Windows enterprise server systems., Worked with PCI projects to secure production environments.,Worked with storage teams to present storage and add storage for ASM and ACFS file systems., Configured TNS, VIP and SCAN listeners, Experience with partitioning and indexing, and working with large data sets.
• Experience in Oracle performance tuning. Created SQL tracing and used tkprof, SQL baselines, and Grid control. Configured and scripted RMAN backup and recovery processes.
• Performed point in time recovery using RMAN and flashback operations.
• Strong knowledge of SQL, analytic queries, and PL/SQL.
• Provided support for Oracle Enterprise Manager Grid Control and Agents for database monitoring/performance/diagnostics.
• Experienced in setting up and maintaining Oracle GoldenGate bi-directional replication

Confidential, Middleton, WI

Sr. Oracle Database Administrator - Lead Consultant

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.
• 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 active Dataguard 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 command line. Used OEM12 cloud control and Bigbrother for monitoring and support of the systems running in Oracle 9i, 10g 11g and 12c
• Utilized expertise in database performance tuning, sql query tuning to improve response time of the queries, database health checkups. Also very capable of participating in performance tests and identify high performing queries and make them perform well.

Confidential, Corning, NY

Sr. Oracle/SQLServer/Exadata Database Administrator - Lead Consultant

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 Server instances 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 data centers 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.
• Monitored availability, Diagnosed performance, Managing backup and recovery, Automating routine day-to-day DBA task, Ensuring continuous availability of the Oracle database., scheduled, 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 repo ting 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.
• We used One-Step Migration to migrate small databases that can be shut down for 24 to 72 hours to AWS. The source database is extracted, and the extracted data is migrated to the destination database in AWS. The destination database in AWS is tested and validated for data consistency with the source. Once all validations have passed, the database is switched over to AWS.
• We used Two-Step Migration to migrate database that requires only minimal downtime and can be used for databases of any size
• The data is extracted from the source database Confidential a point in and migrated while the database is still up and running. Because there is no downtime Confidential this point, the migration window can be sufficiently large. After you complete the data migration, you can validate the data in the destination database for consistency with the source and test the destination database on AWS for performance, for connectivity to the applications, and for any other criteria as needed.
• Used Zero-Downtime Migration for AWS migration that require database migration with no downtime.

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.
• Monitored availability, Diagnosed performance, Managing backup and recovery, Automating routine day-to-day DBA task, Ensuring continuous availability of the Oracle database.
• 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

Computer Scientist/ Sr. DBA

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 Confidential Meds Manager Bundle application (HMM, HCI & HCR) Also installed, monitor and maintain 315 SQL Server 2000 /2005 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.
• Used JBoss to Enables Business Rules Management by enabling the development, storage, execution and management of business rules and policies in applications and SOA deployments. Single distribution that integrates JBoss Rules Dev & Management Consoles

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 Confidential 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 Confidential 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