SUMMARY

• Extensive IT Experience in Oracle Database Administration on Oracle versions and have comprehensive knowledge and experience in each and every aspect of Creating, Installing, Upgrading, Patching Oracle Database Software, Backup and Recovery Strategies, Managing Security and Users, Disk Space, Oracle File System Management, Task Scheduling, Oracle Data Guard, Performance Monitoring and Tuning, Real Application Clusters (RAC), and Oracle Flashback Technology based on UNIX (Linux), and Windows OperatingSystems.
• Experienced in Installation, Configuring, and Maintenance Oracle Enterprise Manager Grid Control agents for enterprise database monitoring.
• 7+ years of Extensive work experience on Oracle versions in Database Administration.
• Experienced with all facets of Oracle DBA day - to-day activities like production, database monitoring, Backup &Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.
• Managing oracle 12c, 11g RAC (6, 4, 2 node) in production, Development and non-production environments.
• Experience includes using Golden Gate to support data replication in theOracle database environment.
• Proven Experience in high Availability like RAC and implemented 11g RAC 2/4 Node with ASM/Non-ASM storage.
• Experienced in using 11g features Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
• Good experience in applying security patches and migration of Oracle server from 10g to 11g, 9i to 10g & 8i to 9i.
• Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.
• Install/Support/Maintain on SQL Server databases with NoSQL/Mongo database.
• Worked with SAN, NAS for ASM disks
• Configured Automatic storage management (ASM) with EMC storage for managing data in SAN.
• Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g.
• Extensive Experience with Recovery Manager (RMAN), Oracle Automatic Storage Management (ASM), Oracle Data Guard.
• Responsible for creatingSpatialData Standards for Facilities, Infrastructure and Environment (SDSFIE) compliant GIS datasets.
• Extensively worked on Oracle 12C, 11g RAC, 10g, 9i, Sql server 2012, RAC, ASM, OEM, Grid Control, RMAN, Flash Database, Data Guard Standby Database, Database Tuning, Database Security, Profiles and Privileges to the Various Users on Objects, and Optimization by Explain Plan and Rollback Segment and SQL TRACE facility, Maintaining Backup & RECOVERY in Sun/Linux UNIX systems administration, Shell programming.
• Proved Experience in Maintaining Documentation and Capacity Planning.
• Strong experience in working with oracle memory tuning (ASMM, AMM).
• Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance tuning.
• Experience on no SQL databases like Mark logic and mongo.
• Working with SUN, DELL, HP hardware and their storage system with RAID management.
• Well versed in creating and managing of Tables, table spaces, Segments, Extents, and Data Blocks.
• Well experienced in managing data files, redo logs, rollback segments, stored procedures, functions, packages and Triggers.
• Experienced in Database links and Materialized Views.
• Expertise in Tuning SQL statement against the database and its objects.
• Hands on experience in complete recovery, incomplete recovery (PITR), Flashback Recovery, Disaster Recovery, recovering data files, table spaces, and control files.
• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
• Performed backups using conventional hot & cold backups and RMAN.
• Experienced in moving the data using Logical backup utilities like Export, Import, Data Pump Export, Data pump Import.
• Strong skills in SQL* PLUS, PL/SQL, UNIX Shell scripts (KSH and CSH).

TECHNICAL SKILLS

Databases: Oracle11g R2 RAC, 10gR2RAC, 9i, Mongo

Operating Systems: HP-UX, Sun Solaris, RHEL 5.x, RHEL 6,x, Red Hat9,AIX, Linux and Windows, IBM DB2, Informix on IBM

Languages: SQL, PL/SQL, Java, C, UNIX Shell Scripting

Tools: RAC,RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD, DB Artisan 4.0, Migration, ASM, Cloning, Replication.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control

ETL Tools: Informatica 5.1, Share Plex

Data Modeling: Erwin, DB Artisan, Rational Rose, SOX

Other: EMC, Net App, VERITAS, Golden Gate,OracleWallet

GUI Tools: OracleEnterprise manager, TOAD, Data Loader, PLSQL Developer, SQL Developer

Storage/Server: NetApp, HP EVA,OracleVM

PROFESSIONAL EXPERIENCE

Confidential, MO

Sr. Oracle DBA

Responsibilities:

• Installed and configured 4 node RAC environments on Oracle 11gR2 with ASM/NON-ASM File system on Linux environments. Experienced with SRVCTL, CRSCTL, OCR and Voting Disk.
• Implemented Physical standby for disaster recovery using Data Guard on Oracle 11g.
• Performed cross platform migrations from Oracle 9i, 10g to Oracle 11g.
• Installed and configured OEM Grid Control agents 11g and 12c on Solaris, Linux server.
• Installed 11gR1/2 and 10g Oracle RDBMS and provision databases on Linux & Solaris 10.
• Upgraded and Migrated Databases from 10g to 11g and applying patches as needed.
• Performance monitoring and tuning up of the Database using STATSPACK, AWR, ADDM.
• Performance tuning of Oracle Database Objects by fixing row chaining.
• Performed LOGICAL BACKUPS for Database migration using Data Pump, Export/Import and Transportable Table spaces.
• Install/Support NoSQL/Mongo databases.
• Within Cloud Services the Customer Management team is focused on operations and account management capabilities for the Cloud Services Customers.
• Worked closely withDBAto develop and maintainOraclespatialdatabases.
• Worked on SAN / RAID configuration.
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL Trace, Tk prof, Analyze, ADDM and Explain Plan Methods
• Installation, configuration, upgrade and maintenance of Oracle databases of Oracle 10g & Oracle 11g on RHEL.
• Installed Oracle spatial 10g and migrated Arcsde data to Oracle spatial at Virtual DBA. Wrote PL/SQL code for Geocoding application.
• Implemented zero downtime migration and upgrade of 10g to 11gR1 database using Oracle Streams.
• Involved in database Export/Import and performing backups using RMAN.
• Working with Networked Attached Storage (NAS) & Tivoli Storage Management (TSM).
• Involved in the Analyzing and monitoring the system performance and tune accordingly.
• Worked actively in planning for storage space requirements and placing them for optimum I/O performance.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using Golden gate.
• Implemented Stream, Golden Gates for Active-Active Replication between the Datacenter for High Availability.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Supported SQL server OLAP cubes along with installations and maintenance upgrades.
• Worked intensively on database migrations.
• Maintained 110 Databases, Implemented 30 Production database, 40 Development database, 40 Test database.
• Experience in Managing Process using Change control and Cab process.
• Developed PL/SQL programs (Functions, Procedures, Packages and Triggers).
• Created Users, Roles, Privileges, Profiles and managing security.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*Net connectivity.
• Experiences with OID servers.
• 24X7 production support and on call rotation.

Environment: s: Oracle 11g/10g/9i, Mongo, RAC, RMAN, Import/Export, Data Guard, Streams, ASM, Performance tuning, Patchset, Upgrade, Migration, SQL, PL/SQL, SQL*PLUS, Korn Shell, Perl Scripting, Sun Solaris and Linux.

Confidential, VA

Senior Oracle DBA

Responsibilities:

• Installed Oracle Database 11gR2 with Real Application Cluster (RAC) with CRS and ASM in SOLARIS environment.
• Worked on creation and deletion of RAC resources like listener/instance and database.
• Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizingoracleprocesses and increasing SGA overall.
• Administer Mongo databases, i.e. install, check alert log, health check of database.
• Coordinate and suggest PM, SA and LOB DBA to allocate and setup disks for data files, backups and achieve log sizes for ASM through SAN storage, SAN storage to setup VOTING and OCR ASM LUNS per cluster, swap storage and shared memory needed per each node.
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Configuration and implementation of Golden Gate based replications through GGSCI.
• Bi-directional replication and Uni-directional replication in Golden gate.
• Perform Daily Monitoring ofOracleinstances usingOracleEnterprise Manager, monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• Create multiple 11g databases on RHEL5 in development.
• Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC 2 nodes on IBM AIX and debugging Golden Gate issues such as extract or replicate rebuild and abend.
• Managed users and maintained security, populated databases of Oracle 10g & Oracle 11g on RHEL, Solaris and Windows 2003.
• Created Oracle package for Cartographic Generalization using Oracle Topology and Spatial that produces smoother map borders that corrects data errors.
• Used scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache server configuration.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Involved in EDW support for OLTP and OLAP Data warehouse application.
• Rebuilding of Indexes for better performance ofOracledatabase.
• Upgraded Oracle database using DBUA or Data Pump Export/Import.
• Implemented Migration Strategies based on cost, time, and platforms requirements.
• Restore and point-in-time Recovery of database using RMAN techniques.
• Implemented Golden Gate Technology onOracle11g/10g.
• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad.
• Worked on development of PL/SQL stored procedures, Triggers.
• Performance monitoring and tuning the database using OEM, AWR and ADDM analysis.
• Have automated/monitored backup strategies for different databases.
• Written Shell scripting which monitors the server's performance and logs output on periodic basis to database using Perl Scripting.
• Designed and developedSQL Server Analysis Services(SSAS) databases andOLAP cubesused in ad-hoc analytic research and automated reporting.
• Experience in using flashback feature oforaclethroughout the project.
• OracleExadata Management was efficiently used in the project.

Environment: Oracle11gR2/10g, RHEL, RAC, RMAN, PL/SQL, Stored procedures, SQL*Loader, Toad for Oracle, Golden Gate, OEM, SQL Loader, UNIX, Solaris, Linux, AIX 5.x, Windows.

Confidential, Collins, IA

Oracle DBA

Responsibilities:

• Part of core Development DBA team maintaining Development databases.
• Involved in designing data warehousing boundaries and parameters, Data Transformation, PL/SQL.
• Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Tuning of the database using TKPROF utility, tuned the Shared pool and buffer cache to have better performance. Point in time recovery for recovering the master data when the tables are dropped by user errors.
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL Trace, Tk prof, Analyze, ADDM and Explain Plan methods.
• Working Experience with Latest TOAD 9.6 having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents, Log Miner, Segment Advisor, Database Monitor, Server Stat's, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.
• Supported SAN Migration and ASM migration, allotted new candidate disks.
• Installation and configuration of Oracle databases on LINUX platforms.
• Administering the physical aspects of the databases such as creation of Table spaces, Users, Rollback segments, creating data files, helping users in creating database objects.
• Configured and maintained data loads in huge Data warehousing systems using the Informatica Power Center ETL tool. Supported data warehousing and databases.
• Advanced troubleshooting using trace files, alert log, and external links (Meta link or Oracle Support).
• Analyzing performance issues and providing recommendation based on testing results using Oracle's tools like AWR, ASH& Data Recovery advisor.
• Configured Standby database for production database.
• Oracle Database Performance Tuning and SQL Tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF etc.
• Involved in EDW support for OLTP and OLAP Data warehouse application
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Configured Standby database for production database.
• Participate in establishing and involving database standards within the company.
• Preparing cluster, configuring and Installation of cluster ware and Oracle RAC on RHEL.
• Performance monitoring, Database tuning and Application tuning, Cluster Interconnect tuning using Dictionary views, OEM Tuning Pack, Diagnostic Pack.
• Implemented database auditing, data security and Remediate high-risk violation in production environment and Gathering schema stats and monitoring the index usage.
• Monitoring Database Activities, Checking for Table space Availability, Checking the Alert Log File for errors.
• Troubleshoot /Configuration of tnsnames, listeners setup.
• Responsible for online and offline backups and recoveries of the oracle database.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Create new database users as required. Plans and implements backup and recovery of the Oracle database.

Confidential

Oracle Applications DBA

Responsibilities:

• I was responsible for the support and maintenance of the company's financial and student databases.
• Involved in the upgrade of the11.5.5 applications instance to 11.5.8 and the database from 8i to 9.2.0.4 onto RAC nodes.
• Administered and maintained production, development, QA, test and patch instances of the Oracle production databases on a round-the-clock basis.
• Configured the workflow notification mailer.
• Installed and managed the daily business intelligence DBI 6.0.
• Reviewed, explored and applied the Oracle applications patches when the business requirements demanded.
• Oracle 9i Spatial and Locator: for Geographic data processing
• Worked on OLTP and OLAP database systems.
• Cloned the Oracle applications production system for development purposes, using RAPID clone.
• Developed and implemented the Disaster Recovery (DR) strategy for Oracle E-Business Suites.
• Developed and implemented backup and recovery strategies.
• Checked alert logs and troubleshoot and resolved the database issues, adding data files, resizing data files and analyzing tables, recovering and renamed the databases to create and sink the development data with production data in RAC environments.
• Installed Oracle RAC 9i on Linux Platforms.
• Interacted with the Oracle customer support and logged iTAR when required.
• Patched security vulnerabilities when released by Oracle support.

Environment: Red Hat Linux, HP-Unix, Oracle Applications 11.5.8/11.5.9, (Financials & CRM Modules), Oracle 9i, Oracle Forms 6i, OAM, License Manager, STATSPACK, Rapid wiz, Rapid Clone, Auto upgrade, Adpatch, Adadmin, Adctrl, Toad 7.3, SQLplus, OEM, EMC Storage)

Confidential

DBA

Responsibilities:

• Installed, created and maintained new oracle 9i and 8i instances.
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security).
• Coordinated with Infrastructure and storage teams to resolve performance issues and to improve system response and run times.
• Connectivity with different client programs using ODBC.
• Writing scripts to move data files, for monitoring system activities (I/O CPU), memory usage at process level, file growth, user login, and user's setup.
• Performed work related to importing and exporting data using IMP and EXP tools in Oracle file structures.
• Involvement in all phases of the project life cycle.
• Developed and modified PL/SQL code to make new enhancements or resolve problems as per customer requirements.
• Involved in optimizing SQL statements using indexes and hints.
• Setting up configuration parameter of MySQL Database (my.inf).
• Frequent analysis of objects or schemas to improve the speed of the database.
• Analyze SQL statements using Explain plan.

Environment: Oracle 10g, 9i RHEL, UNIX Shell Scripts, TOAD, PL/SQL Developer, SQL Server 2000