SUMMARY

• Oracle DBA with 8+ years of experience providing 24/7 production and development support for Oracle 12c, 11g, 10g, 9i databases across different platforms.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g and 12c with experience in very large scale database environment and mission critical large OLTP and OLAP systems.
• Robust experience in successfully migrating database from Non - ASM to ASM and Non-RAC to RAC through GoldenGate for 10g and 11g databases across multiple host platforms.
• Expertise in performing extraction, transformation and load process(ETL). Migrated huge volumes of flat file data into structured data using SQL loader and data pump utility.
• Installed and configured Oracle Identity Manager (OIM) and Oracle Role Manager with integration between the two in demo environment .
• Extensive expertise in Oracle Architecture, Capacity planning, space management, Performance Tuning, Backups, Recovery, RMAN backups, Optimization of SQL queries, Networking, Troubleshooting.
• Experience in Installation, Configuration, physical and logical backups, upgrade/migration, Cloning, Data pump, Data guard, Performance Tuning, RAC, ASM, GoldenGate, on different Confidential -UX, Sun Solaris, Linux, UNIX AIX, and Windows servers.
• Experience in installation, configuration and administering 2/3/4 node Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM) including active monitoring of ASM disk groups for their load balancing and redundancy.
• Installed and Administered Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems with active failover disk groups.
• Extensively worked on developing new packages and user defined DML and DDL triggers through PL/SQL scripts and created stored procedures.
• Expertise in bi-directional replication using GoldenGate also known as active to active replication to support DML and DDL activities on both databases.
• Implemented GoldenGate for data recovery and data migration for Oracle 11gR2 RAC multi nodes on IBM AIX and debugging GoldenGate issues such as extract, replicate rebuild and a bend.
• Implemented Data guard in the production environment and executed active standby database switchover and failover drills to effectively handle mission critical planned and unplanned outages.
• Planned and implemented DR & high availability solutions using OEL 10g Standby Database using Oracle Data Guard, 11g and 10g RAC.
• Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN and GoldenGate.
• Experience in installing Oracle patches and upgrades, Migration of database across different platforms.
• Setup Grid Control for Monitoring Exadata X3 and upgrading exadata database machine from half rack to full rack.
• Developed logical and physical data modeling techniques for both applications development and data warehousing.
• Excellent experience in various migration techniques like export/import, Data pump, backup restore, cloning, and data guard.
• Experience in Disaster Recovery set-up using Data Guard for critical environments and performing Disaster Recovery exercises annually.
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Experience in planning, installation & maintenance of Oracle Fail Safe 3.X on Microsoft clusters server configuration.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 9/10, Confidential -UX 11i v1.5, IBM AIX 5.3/6.1/7.1, RHEL 3.x, 4.x, 5.x, Linix and Windows.

Databases: Oracle 12c, 11g, 10g, 9i, 8i, Mysql, Microsoft Sql Server 2008,2012, PostgreSQL 8.4, 9.2, Real Application Cluster (RAC), ASM

DB Utilities: SQL*LOADER, Data Pump, RMAN, Opatch, TKPROF, Statspack, AWR, ADDM, SRVCTL, CRSCTL, ASMCMD, ASMCA, DBCA, ADRCI and DBUA.

Tools: Oracle Enterprise Manager 10g/11g/12c, TOAD 8.5, SQL Developer, Putty.

Languages: SQL, PL/SQL for Oracle, C.

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Senior Oracle DBA

Responsibilities:

• Working on 2-node to 5-node RAC databases from 50GB-20TB on both Confidential -UX and Linux.
• Monitoring and maintenance of Oracle 10g and 11g databases on Confidential -UX and Linux environments including ASM and Non-ASM.
• Configured GoldenGate Uni-Directional and Bi-Directional Table Replication.
• Having hands-on experience on implementing, upgrading and configuring the GoldenGate software for Oracle Database.
• Installed and configured Veridata for monitoring the GoldenGate replication used during the 10g to 11gR2 upgrade.
• Worked on the High availability of GoldenGate creating the GoldenGate VIPs and creating services for RAC databases. In case of one node getting failed GoldenGate will be failover to other node.
• Engaged with Vendors like Oracle, Siebel, Dell and Sun Microsystems.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Performed CRS and Database Upgrades from 11.1.0.7, 11.2.0.2 to 11.2.0.3.
• Installed Binaries and creating databases on different versions of oracle 10g/11g.
• Worked on smart flash cache with 10X improvement in response time in reads and 100X improvements in IOPS for reads over regular disks in EXADATA X3.
• Setup & configuration of Enterprise Manager (OEM) for complete control of Exadata environment via Ops Centre.
• Experience in improving DBRM to extensively work with I/O band width and intra database allocations through the resource manager of EXADATA X3.
• Applying patches to RDBMS, CRS, and AGENT.
• Ensured 24x7 database availability, using Oracle Failsafe and MS-Cluster Server.
• Worked on RAC S2S Metro cluster, where the database will be failover from site1 to site2 using service guard package.
• Configured Emcli setup for databases, which relocates the OEM targets when failover is done on S2S metro cluster.
• Restoration and recovery from backup.
• Involved in the process of tuning and refining queries of various applications.
• Optimization and tuning long running SQL queries using STA, Access advisor, Trace File, Sql Profiles, TKPROF and EXPLAIN PLAN.
• Extensive usage of ADDM, AWR, ASH, features of 10g.
• Database refreshes using Full Expdp and Impdp, RMAN Duplicate, DBPITR and Cloning.
• Implemented datacenter migrations from 11g RAC cluster to a different server through Symmetric Remote Data Facility (SRDF).
• Schema refresh, table refresh using data pump IMPDP, EXPDP.
• Performed Database migration, which includes migrating data from SQLServer 2008r2 to oracle 11203 Confidential -UX. loaded data into oracle tables using SQLLDR.
• Created DBlinks between oracle and SQL Server using database gateway for SQL Server.
• Performed Database migrations from old to new hardware to meet the standard using RMAN Duplicate.
• Monitoring the table growth, database growth, current users, and system resource usage.
• Implementing data guard to provide high availability of database for many MC and tier o applications.
• Involved in the performance tuning of various MC applications having long running queries.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Performed rolling patch upgrades on RAC environment for bug fixing.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

Environment: Confidential -UX, Red Hat Linux 6.0, Oracle RAC 10g/11g, Oracle 10g, 11g, PL/SQL, SQLLDR, GoldenGate, Oracle Enterprise Manager 9.2.0, Oracle 12c GRID, Oracle RAC, Data guard, TOAD 8.6, SQL server.

Confidential, Columbus, IN.

Oracle Database Administrator

Responsibilities:

• Migration from AIX to Linux using GoldenGate and Upgrades from 10g to 11gR2RAC
• Implemented Oracle 11g Active Data guard with maximum performance mode for FSFO and snapshot data guard.
• Converted databases from Non-ASM to ASM.
• Involved 24*7 in managing 170 databases.
• Patching security vulnerabilities as part of quarterly release, applying minipacks, maintenance pack, family pack and one-off patches.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary
• Handling Escalations, Sev1 Cases and other Critical cases.
• Highly experience in Cloning of Oracle application environment using Rapid clone and adconfiguration.
• RMAN Backup and cloning Database using RMAN Active Duplicate
• Exposure to Oracle Application tools and ad utilities like adpatch, adadmin, adconfig, adctrl etc. for the management and maintenance of Applications.
• Managing Workflow and its components through OAM.
• Implemented Oracle 11g GoldenGate for data replication through configuring the GGSCI and other GoldenGate processes.
• Troubleshooting network issues with respect to SCAN listeners and local listeners, configuring the virtual IPs and monitoring the load balance level of the RAC clusters.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment using RMAN utility.
• Responsible for SQL Server 2008 Database Backup and recovery. Monitoring the database backup, drive space, log space and Critical errors for all production servers.
• Used normal import and export and also data pump import and export for exporting and importing schemas, tables etc. from one database to another.
• Responsible for tuning the database performance issues like query tuning and memory tuning (SGA tuning) and also partitioned the tables and indexes for better performance.
• Have used different tools like TOAD (10.1), EXPLAIN PLAN, AWR, ADDM, Oracle enterprise manager (GRID CONTROL) 10.2.0.4 to solve the performance issues.
• Application user creation / responsibilities assignment, applying minipacks, maintenance pack, family pack and one-off patches.
• Troubleshooting Apps components like Forms, Apache and Concurrent Managers.
• Troubleshooting application failures including performance and database connectivity problems and job failures.

Environment: Confidential -UX, Windows, Solaries, AIX, Oracle 11g/10g, SQL, TOAD(10.1), Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Data Guard, GoldenGate, AWR, ADDM.

Confidential, Cary, NC

Oracle Database Administrator

Responsibilities:

• Worked on production environments of 9i, 10g and 11g databases through On-call pager support and assisted in daily performance tuning tasks.
• Installed, Configured and administered RAC and moved non RAC databases to RAC.
• Experience on Oracle RAC with SRDF Implementations for cross datacenter replication.
• Migrated SQL server 2008 database to SQL Server 2012 database in Microsoft Windows Server 2012 Enterprise Edition.
• Worked on generating AWR and ADDM reports and configuring explain plan for high load sql queries.
• Administered the CRON job scheduler for datacenter automation tasks and coordinated strategies to move data between databases using expdp/impdp.
• Handled connection requests from clients to net service name and resolving listener issues through net configuration assistant(netca) and oracle net manager (netmgr).
• Documented the necessary procedures as per the industry requirements for data guard, RAC installation and Datapump setup processes.
• Worked on configuring the ASM system on the storage server through appropriate oracleasm libraries.
• Auditing the actitvies of the all the users logged to the database server through audit trail logs and administered the security of the user sessions.
• Configured a catalog database for RMAN and taken backups on different incremental levels.
• Worked on resolving tickets through various ticketing tools like Confidential service manager, and monitored the alerts through OEM grid enterprise manager.
• Monitored the automatic diagnostic repository(ADR) for storing the diagnostic data and has created oracle support service request if the problem persists.
• Maitaining stripping, mirroring and online storage reconsideration and dynamic rebalancing through Oracle ASM and manage raw partitions.

Environment: Oracle 9i/10g/11g, SQL, PL/SQL, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Data Guard, Shell Scripts, AWR, ADDM, RHEL 4.0.

Confidential

Junior Oracle DBA

Responsibilities:

• Provided 24x7 Support of Critical Databases and worked on enhancing the Database Monitoring process.
• Upgrading database from 8i to 9i and troubleshooting issues during upgrade, applying patches to fix issues.
• Responsible for refreshing/cloning test instances with Production Instance periodically.
• Administration of databases- Physical and logical structures.
• Creating and Managing users, Granting and Revoking privileges for the users in order to ensure the Database security.
• Automated jobs to run backups, disk cleanup for logs and archive logs, gather statistics.
• Identify and troubleshoot long running queries, locked sessions to improve overall performance.
• Established and wrote the Database Administrators Procedures document for the IT department.
• This document highlights all standards for the DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards, policies, practices and procedures.
• Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection & self-tuning purposes.
• Monitored the databases and added the data files to the tablespaces or resizing the tablespaces and monitored the sessions running on the databases.
• Managed and supported users by creating roles and privileges for database access and data manipulation.
• Reported the database storage capacities to Project Management and organized the capacity planning of the production database.

Environment: Oracle 9i/8i, Solaris, Linux, RHEL 3.0, Confidential -UX.

Confidential

Database Administrator

Responsibilities:

• Providing Production support and troubleshooting user issues.
• Performing daily database operations, maintenance and support.
• Administration of databases- Physical and logical structures.
• Export/Import data to/from Production and Non Production systems as required.
• Expertise in database backup and recovery management (Hot/Cold, Exp/Imp).
• Identifying and resolving resource contention issues and monitoring database performance.
• Solving the issues based on Alert logs.
• Maintaining of Space requirements on the Tablespaces by adding/re-sizing data files based upon the space available on the file systems and existing volumes.
• Creating and Managing Users, Granting, Revoking privileges for the users in order to ensure the Database security.
• Responsible for refreshing/cloning test instances with Production Instance periodically.
• Creation of Database Links and Materialized Views between different databases.
• Coordinate with Oracle Support to resolve database performance issues.
• Monitor the operating system response in terms of CPU usage, disk space, and swap space by using various like VMSTAT, ISOSTAT and TOP.