SUMMARY

• Over 8+ Years of experience in Oracle Database Administration (Oracle databases 8i/9i/10g/11g, 12c running on HP - UX, SUN SOLARIS, AIX, Red Hat Linux and Windows.
• Expert in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, TAR support, Unix shell scripting and documentation.
• Proven Experience with 11g Release 2, 10g Release2, 9.2.0.2 - 9.2.07 , 8.1.7.4
• Performed several cross-platform upgrades and migrations and single node to RAC conversions.
• Involved in policy formulation and Physical and Logical design of Database.
• Upgrading the databases to version 12c from 11g and 10g.
• Experience in Configuring Single instance to multimode, Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), Data guard.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like tkprof, sql profile Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM).
• Expertise Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Experienced in Backup and Recovery, Disaster Recovery policy formulation and implementations.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Experienced in Data Migrations using oracle export/import, data pump.
• Good experience with replication tools installations and configurations.
• Supported Golden Gate and Shareplex replications both unidirectional.
• Configuration of Oracle Golden Gate from Oracle to Oracle database.
• Replication using Initial Data Load and Online Change Synchronization.
• Responsible for the configuring Oracle Goldengate EXTRACT, REPLICAT, PUMP and their parameters.
• Experience in Configuring DML and DDL Synchronization.
• Experience with Oracle 12c/11g/10g features: Flash-Back Recovery, Data pump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo management, Grid Monitoring and Recycle Bin.
• Proficient with Database Cloning, Migration, Standby Database, Data Guard and Patching of Oracle Databases and Oracle Applications.
• Implemented Data guard for Disaster Recovery Setup using 11g Active Data guard.
• Experience in Configuring Oracle DATA GUARD with Physical and Logical Standby, also familiar with 11g ACTIVE DATA GUARD.
• Extensive experience with replication solutions like Oracle Streams, Shareplex, Golden Gate and heterogeneous replication usingIBMCDC/IIDR.
• Experience with case management of DB2 technical support.
• Installed, configured and troubleshoot Oracle Internet Directory (OID), Oracle Virtual Directory (OVD).
• Expertise with usage of tools including Oracle Enterprise Manager (OEM), TOAD, Sql Developer.
• Experience in Unix Shell Scripting for automating the DBA tasks and schedule Jobs in UNIX environment.
• Good experience in Migrating 11g to 12c Database, Upgrade 11.2 RAC to 12c RAC.
• Extensively used utility SQL LOADER, External Tables to load data from flat file to database.
• Configured and implemented Golden Gate and Streams for Data Replication materialized views and advanced replication methods.
• Experience in Installation, configuration ofAIXIBMpSeries Machines of 5L, 6.1 & 7.1
• Strong work experience with tools like Toad, PL/SQL Developer, Oracle SQL Developer, OEM Grid Control.
• Wrote Server-side Stored Procedures and Triggers, formulated RMAN Backup/Recovery strategies, Optimizing Query Plan, Performance Tuning, Explain Plan, TKPROF, and Stats Pack.
• Managed ASM configuration and migration of database from clustered file system to ASM.
• UNIX Systems Administration - Database and application integration efforts; CVS system installation experience; Heavy UNIX shell scripting, CRON jobs.
• Actively involved in resolving pre or post-implementation problems and work around.
• Experienced in technical documentation.
• Involved in upgrading and migrating the databases from 11.2.0.1 to 11.2.0.4.(PSU and CSU)
• Sound analytical, troubleshooting, problem-solving skills, and equipped with excellent communication and interpersonal abilities, and an acceptable teammate.
• On call 24X7 Production Support. Willingness to work beyond regular hours.

TECHNICAL SKILLS

OPERATING SYSTEMS: HP-UX 10.x/11.x, Sun Solaris 8/9/10, AIX 5.2/5.3/6.1, Red Hat Linux RHEL 7.3/8/9, SUSE 10.0 and Windows NT/2000/2003.

LANGUAGES: SQL, MYSQL,PL/SQL, C, C++, XML, Unix Shell Scripting, VMware, Perl, HTML, PHP

Database: OEM, DATA GUARD, Recovery Manager (RMAN), Data-pump, STATSPACK, ASH, AWR, TKPROF, ADDM,, ETL, MongoDB, Clusters, EMC Storage, DTS, Developer 2000, SQL Loader, TOAD,SQL*LOADER, putty, WinSCP3, SQL*PLUS, Net Backup, EXPLAIN PLAIN, SecureCRT

PROTOCOLS: FTP, SFTP, Ssh, Telnet, TCP/IP

Replication: Golden Gate, Oracle Multi-master Replication, Data Guard, Shareplex.

Front End Tools: Power Builder 8, Visual Basic 6, Business Objects, Developer 2000, Oracle Discoverer, Oracle Reports 6i

Utilities: SQL*Plus, SQL * Loader, SQL * Net, Toad, ER-Win, Visual Safe Source, Subversion, PL/SQL Developer

Backup Utilities: RMAN, HP Omni Data Protector, SQL Backtrack,), VERITAS Net backup, Export/Import

Oracle Monitoring Systems: OEM 9i/10g, Oracle 12c Cloud Control, Oracle EBS, Oracle Golden Gate Director

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Database Administrator

Responsibilities:

• Supported 100+ production instances (RAC) databases.
• Involved in 24x7 support for production database with on-call pager.
• Experienced in handling database issues using OEM as well as command prompt.
• Upgrading the databases to version 12c from 11g and 10g.
• Configuration, Administration and Maintenance of Oracle 11gR2 Real Application Cluster Databases on UNIX platforms and achieving High Availability.
• Performing various tasks like administering RAC using SRVCTL, CRSCTL, administering storage components, parameter management, and configuring high availability features for RAC.
• Configuring and Maintaining Oracle Data Guard for disaster recovery Business Continuity Plan.
• Tuning and diagnosing of database performance by query Optimization.
• Up-gradation and Migration of Database from 10g to 11gand then to 12c and also applying patches whenever required
• Data Refresh from Production to Test and Development environments using RMAN and Data Pump.
• Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of database environments.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures.
• Worked on RMAN backup and recovery. Recovered the databases (full recovery) during database upgrade and point in time recovery as per the user request using RMAN.
• Created the dblinks (private and public), synonyms (private and public) and views. Validated the views and compiled the views which are invalid.
• Worked with maintaining the OCR and VOTING DISK in normal and external redundancies and also worked with cluster ready services (CRS) and used CRSCTL for maintaining CRS.
• Worked on resolving the gap between primary and standby databases in dataguard by registering the missing archive logs in the standby database.
• Developing and Implementing EXADATA database.
• Daily Health Check Up and performance statistics of the Database using OEM, AWR and ADDM.
• Performance tuning with AWR, ADDM, ASH, SQL Plan Management, SQL Tuning advisor, SQL Access advisor, Memory advisor, Segment Advisor, SQL Trace and TKProf, StatsPack.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Installed, configured and troubleshoot Oracle Internet Directory (OID), Oracle Virtual Directory (OVD).
• Setup and configured Oracle Internet Directory (OID).
• Connecting to any database as OVD global user from Sqlplus, OEM and secure CRT using Kerberos ticket.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• Utilized SQL*loader and data pump import to load data into tables and Oracle Flashback Data Archives.
• Implemented Data Guard and created Physical Stand by database for high availability and Maintained Database.
• Work with VMware Infrastructure Client in supporting our Windows 2003 & 2008, Linux Enterprise 5 Server environment.
• Automate server checks for various DB2 dependent subsystems likeIBMTSM,IBMILTM, EMC Networker and such.
• PSU, CSU patches hasbeenappliedfor variousoracleversionsinvariousoperation systems
• Creating ORACLE SR and following up timely to get the solution.
• Implemented Golden Gate Replication: Configured Extract, Replicate processes for Golden Gate.
• Worked onMongoDBdatabase concepts such as locking, transactions, indexes, Sharding, replication, schema design.
• Oracle Golden Gate Process is configured in such way that it will not create any load on production and read data from Archive logs of the production.
• Experience in Using Golden Gate to maintain Live Standby Database
• Experience in Configuring DML and DDL Synchronization.
• Experience in Configuring Oracle Golden Gate in Heterogeneous environment (operating systems and databases)
• Worked on various tech refresh projects(role switchover) using Data Guard broker in all non prod and production environments.
• Successful replication of Oracle Database 11g using Initial Load, Online Synchronization and Datapump process of Golden Gate.
• Installed and configured Oracle Golden Gate on Solaris RAC cluster.
• Troubleshooting Golden Gate issues by checking report files, trail files and ggs error log files.
• Standby Database (Data Guard)setup and configuringDB links.

Environment: Red Hat Linux, Sybase, Oracle 11g, 12c RAC, VMware, SQL*Plus, OEM, TOAD, RMAN, TKPROF, SQL Trace, STATSPACK, ADR, AWR, ASM,MongoDB, ADDM, IBMAIX, Linux Oracle 11g and 12c RDBMS, Oracle Golden Gate, ASM, Data Guard, Active Data Guard, 12c Cloud control, Oracle Exadata X4-2s, Mongo DB.

Confidential, Raleigh, NC

Oracle DBA

Responsibilities:

• 24X7 Production database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database and applications issues.
• Created/managed Oracle Databases in 11g and 12c RAC in both windows and Linux.
• SupportedIBMIIDR/CDC heterogeneous data replication - implementation, upgrades, support between Oracle and DB2/Mainframe.
• Applying approved patches and modifications, in accordance with policies and procedures established by the Postal Service.
• Experienced in Data Migrations using oracle export/import, data pump.
• Implementing appropriate database security administration and ensuring that logon IDs are unique. Managing sessions and authentication and implementing account time-outs.
• Testing database software to ensure that security mechanisms are functioning properly. Tracking database software vulnerabilities, and deploying database security patches.
• Developed SuperCluster/Exadata database consolidation plan for non-prod databases.
• Installation and configuration of Golden gate for replication and resolve issues to sync Databases
• Installed upgraded and patched DB2 software and associated applications.
• ConfiguredIBMIIDR/CDC heterogeneous (DB2-Oracle) replication on Exadata.
• Ensuring the availability of databases by implementing database backup and recovery procedures.
• Setting up and managing accounts for systems under their control in accordance with policies and procedures established by the Postal Service.
• Implementedstronguserauthenticationusingthewalletforexternal password store
• Cloning database from Prod to CAT(Using RMAN catalog)
• Configured Disaster Recover and Logical standby for Production database in 10G.
• Tune databases performance, Schedule backup, jobs using OEM Grid Control.
• Involved optimizing database schemas, SQL queries, database procedures, and installation.
• Cloned/Refreshed Oracle Databases using RMAN for development and testing.
• InstalledMongoDB, created setup replica sets, data scaling and clusters. Installed MMS and setup monitoring agents. Configured alerts for relevant mongo metrics
• Installed, and configured RAC9i,10g,11g databases using ASM
• Created the dblinks (private and public), synonyms (private and public) and views. Validated the views and compiled the views which are invalid.
• Worked with maintaining the OCR and VOTING DISK in normal and external redundancies and also worked with cluster ready services (CRS) and used CRSCTL for maintaining CRS.
• Tuned SQL statements using explain plan and Tkprof. Monitoring and Performance tuning.
• Written shell scripts for digitization the process and for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• PresentedIBMIIDR/CDC data replication and OEM 12c Change Management.
• Installed and configured Oracle SOA suite.
• Supported upgrades from oracle 9i to 10g, 9i/10g.
• Performed migration from 9i to 10g from AIX to Linux.
• Tuning SQL queries using AWR, ADDM, TKPROF, EXPLAIN PLAN, and SQL TRACE.
• Worked on Data pump (Expdp / Impdp), Import / Export for logical database maintenance.
• Performing Backup/Recovery of all the Oracle databases using RMAN and also setup RMAN catalog for the same.
• Involvedin patching 10g ASM instances and CPU patching for RACinstances and single instances.
• Experience in SQL*Loader, loading data from text files.
• Performed scheduling of Change Control-activities and scheduling jobs.

Environment: Oracle 12c/11g RAC/10g RAC, 9i, ASM, RDBMS, Data Guard, VMware, Data pump, DB2, UNIX Shell Scripting, SUN SOLARIS 10, ETL, OEM, MySQL, MongoDB, SAP, Perl, PL/SQL, Red Hat Enterprise Linux 4.x, Explain Plan, Tkprof, OracleEBS, SQL*LOADER, SOA suite, Cloud Control, UNIX/Linux, RMAN, AIX 6.1, 5.1 and RHEL 5, 4.

Confidential, San Francisco, CA

Sr. Oracle DBA

Responsibilities:

• Installed, configured and monitored multi node Oracle 12c/11g/10g RAC.
• Converted a single instance database to Oracle RAC.
• Installed and configured Data Guard using physical and logical standby for high availability and reporting purpose.
• Experience with creating script for data modeling and data import and export. Extensive experience in deploying, managing and developingMongoDBclusters. Experience in creating JavaScript for using DML operation withMongoDB
• Data pump Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.
• Installed and tested LDAP directory client-server software onIBMAIXto run in production environment on all servers running EPIC software.
• ConfiguredASM in Oracle 11gRelease2 databases
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Work within the production support team and maintain operational consistency and efficiency.
• Performance Monitoring and tuning using STATSPACK, TKPROF, EXPLAIN PLAN, AWR, and ADDM.
• Up gradation of Database from 9i to 10g, 9i to 11g, 10g to 11g and applying patches whenever required.
• Implemented transportable tablespace to migrate database from 11g to 12c.
• Performed migration from 9i to 10g from AIX to Linux.
• Supported upgrades from oracle 11g to 12c, 9i/10g/11g/12c.
• Performed DB2 installation and configuration.
• Install and configure SOA Suite 11.1.1.3.
• Oracle EBS upgrade from 11.5.10.2 to 12.1.3.
• Tune databases performance, Schedule backup, jobs using OEM Grid Control.
• Involved in creating Tables, Indexes, Triggers, Sequences, Procedures and Packages.
• Cloned Oracle Databases and Oracle applications for development and testing.
• Applied upgrade patches toRACdatabases 9i,10g.11g,ASM, Clusterware
• Involved in Data modeling, Logical database design, physical database design, normalization and renormalization.
• Maintained Shareplex unidirectional replication for the billing server ARBOR.
• Management of security, granting and revoking permissions to users/roles as and when required.
• Writing UNIX shell scripts for backup and recovery, Import and export procedure.
• Writing PL/SQL functions, procedures, packages and triggers.
• Installed upgraded and patched DB2 software and associated applications.
• Planning and Execution of RMAN backup and recovery based on SLAs.
• Create and maintain Fusion, Oracle EBS Suite environments, DB templates, RAC environments, Zip DB for entire Oracle product development division.
• Experience in Identifying performance bottlenecks on high volume transaction systems.
• Database administration tasks involving installation, performance tuning, space management, user management, backup & recovery strategy planning.
• Experience on Data Modeling tools such as Erwin Data Model and ER Studio.
• Provide development and production support related to database.
• Install Oracle RAC 10gon Oracle Enterprise Linux Using VMware Server.
• Working with QA and Development teams for the regular database support.
• Daily Health Check Up of the Databases and applications

Environment: Oracle 12c/11g RAC/10g RAC, 9i, ASM, Data Guard, VMware, MongoDB, Shareplex, OracleEBS, Data pump, DB2, UNIX Shell Scripting, SUN SOLARIS 10, ETL, OEM, RDBMS, MySQL, SAP, Perl, PL/SQL, SOA suite, Cloud Control, Linux, RMAN, AIX 6.1, 5.1 and RHEL 5, 4.

Confidential, Charlotte, NC

Oracle DBA

Responsibilities:

• Installed, configured and administered 3 node 11gR2 RAC with ASM on Redhat Linux.
• Configured the Public Network/Private Interconnect for RAC.
• 24X7 on Call Production Support for 3 Node/4.5TB RAC Cluster
• As a part of maintenance activity excluded some tables from replication without shutting down the whole replication in Shareplex and later included in the configuration file.
• Configured and maintaining Data Guard (Physical Standby database) for the production database and tested for switchover, failover, activating the standby to primary and zero data loss.
• Maintenance and monitoring of oracle 11gR2/10g database instances hosted on Linux (RHEL5) and Sun platform.
• Administered multiple environments (up to 25TB), automating backups and checks, restore, validation/integrity checks, growth modeling and predictions, and system expansion; assisted with upgrade efforts withMongoDB
• Performed DB2 installation and configuration on OS Mainframe platform.
• Migrate 11g to 12c Database, Upgrade 11.2 RAC to 12c RAC -- Configure Containers, Implement Audit Vault and new database security features.
• Upgraded Oracle EBS Database to 11g (11.2.0.3) RAC in both TEST and PRODUCTION environment.
• Upgraded databases from Oracle 9ito Oracle 10g &Oracle10g to Oracle 11g and migration of the databases using transport tablespaces export/import, data pump utilities.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Worked on transportation of Tablespaces, Data Archival, and Database Defragmentation.
• Used Opatch utility for applying CPU and One-off patches & RDBMS patch set Upgrade (PSU).
• Creation of database server from scratch and implementing ASM file systems
• DBA activities such as configuring Grid events, Regular Backup’s, Replication, Tuning, and troubleshooting performance issues.
• Clone copy of production databases into test databases for application upgrade testing.
• Installed, configured, and maintained Oracle Fusion Middleware with SOA Suite.
• Assisted developers in tuning SQL statements in the applications for Performance tuning and Query Optimization
• Assisted developers and also involved in creating stored Procedures, Triggers, Functions, Cursors and Packages.
• Developed SQL,PL/SQL Programssuch as procedures, functions, packages and triggers
• Provided 24 * 7 on-call Production support for Oracle 10g and 11g
• Responsible for memory and Application tuning of the databases using Oracle utilities like OEM, SQL Trace, TK Prof and Explain Plan.
• Partitioning of large tables for fine tuning performance.
• Designed and implemented crash recovery strategies using RMAN, Hot, Cold and Logical backup plans.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Recovered Data block corruption using RMAN.
• Installed upgraded and patched DB2 software and associated applications.
• Installed and configured 11g Grid Control and deployed the agents to several target production/test/dev database environments.
• Extensively used 11g Grid Control for monitoring databases proactively.

Environment: Oracle 11g/10g, RAC, MongoDB, Red Hat Linux, RDBMS, Cloud Control, Solaris 10, Oracle Enterprise Manager, Data Guard, ASM, OEM, PL/SQL, Data pump, ETL, SAP, Unix shell scripting, Oracle EBS, Perl, DB2, SOA suite, MySQL, Shareplex, AIX 5.1, UNIX, RMAN, Toad.

Confidential

Oracle DBA

Responsibilities:

• Installed Oracle 9i and created databases to evaluate new features like Persistent INIT.ORA parameters (SPFILE), Oracle Flashback, Oracle Managed files Management, Automatic Undo space management, online operations like—Table redefinition, online index rebuild
• IBM PSM/IPM systems support for 1200+ print queues on multiple AIX servers for support of IBMinternal
• Monitor server loads and re-start server processes to maintain seamless customer support.
• Installed Oracle 10g on Development and Test environments and upgraded the environments from Oracle 9i to 10g.
• Performed CRUD operations like Update, Insert and Delete data inMongoDB.
• Responsible for User Management and Role Management using SQL authentication.
• Experience configuring RMAN with Data Protector for Backup, Data Recovery & Data Protection
• Applied patches of Oracle 9i, 8i (8.1.5/8.1.7 ) Enterprise Edition on Sun Solaris UNIX server and windows NT/2000 server.
• Tested and Implemented procedures to detect the poor database performance, collecting required information, root cause analysis
• Tuned and improved the performance of the Oracle databases.
• Configured the Public Network/Private Interconnect for RAC.
• Experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning.
• Installed Golden Gate for replication in Test Environment.
• Implemented Table Partitioning for large tables.
• Involved in load testing and capacity planning of Production/Development databases.
• Configured and implemented RMAN utility (8i/ 9i) for backups and recovery.
• Developed shell scripts, PL/SQL procedures to monitor the databases and scheduled UNIX cron jobs and Oracle DBMS JOBS.

Environment: Oracle 8i/9i/10g, SUN SOLARIS 5.9, RAC, ASM, HP-UX 11.0, Import/Export, OEM, SQL* LOADER, FTP, RMAN, STATSPACK, EXPLAIN PLAN, Perl, TKPROF, JDBC, MySQL, Data Guard, SQL, UNIX/Linux, PL/SQL, and Windows NT/2000.

Confidential

Oracle Developer

Responsibilities:

• Installing, configuring and administering ORACLE 9i/8i on LINUX and Solaris.
• Worked in Development Support for Oracle based systems and Unix based Server environments
• Perform capacity planning required to create and maintain database environments.
• Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and manageability.
• Planning Backup and Recovery Strategies for various database environments.
• Developed Recovery procedures that are applied for complete and incomplete recoveries depending on the type of failure.
• Created PL/SQL and shell scripts to automate batch jobs through crontab.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Writing scripts for the system and database for the effective functionality and report generation.
• Applied High priority, security patches downloaded from Meta link.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Upgraded databases from Oracle 8i to Oracle 9i.
• Monitoring Database for fragmentation and correcting them.
• Experienced with Space Management and Security.
• Management of table space growth, monitoring data files additions, extent growth
• Performed Database, OS and application tuning.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Used Database export/import using exp& imp utilities to take logical backups.
• Performed Data loads using SQL loader utilities.
• Contact to the development team to solve the issues with the new enhancement releases.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.

Environment: Oracle8i/9i, Linux, Solaris, PL/SQL, UNIX/Linux, Windows NT/2000, Toad.