SUMMARY

• Around 9 years of experience as Oracle Database Administrator in various domains and on a variety of UNIX and Windows platforms with Oracle (19c/18c/12c/11g/10g/9i/8i).
• Extensive experience in installation and configuration of Oracle 19c,18c,12c,11g, 10g, 9i, & 8i on all environments on SUN SOLARIS, HP - UX, IBM-AIX, WINDOWS, REDHAT-LINUX.
• Highly competent in Administration, Monitoring and specialized in Advanced DBA skills such as Performance Tuning, Database Backup and Recovery, Data guard, Data Pump, RAC, Golden gate.
• Migration and Upgradation databases to 12c to 18c, 12c to 19c, 11g to 12c, 10g to 11g, 9i to 10g.
• Installed, configured, and updated EXADATA machines.
• Expert in Real Application Cluster (RAC) environment with Automatic Storage Management (ASM) on Oracle 10g, 11g,12c,198c and 19c.
• Installation, Configuration and Maintenance of Oracle 9i/10g/11g/12c/18c/19c RAC on two node and four node configurations with multi-tenant architecture.
• Experience in Supporting Exadata, Oracle RAC and Golden Gate.
• Extensive experience in migration of databases with export/import, expd/impdp, RMAN.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Configured Data guard to provide high availability by implementing Physical stand by database.
• Design and Document backup and disaster recovery plans for critical databases using conventional HOT, COLD and RMAN backups.
• Installation and configuration of Oracle cloud control 12c, and expertise in ASM storage and Oracle 11g/12c/18c/19c clusterware.
• Experience in Real Application Clusters (RAC) setup, configuration, and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.
• Experience in conversion of Single Node Instance to Multi node RAC with ASM.
• Strong skills in SQL* PLUS, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.
• Expertise in tuning the databases for optimal performance.
• Laid hands-on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN.
• Proficient in maintenance of Production, Testing, Development, RAC, Standby databases/ Data Guard for OLTP and DATAWAREHOUSE using customized shell scripts and experienced in Data Modeling.
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, export/import, expdp/impdp.
• Experience in applying security Patches to the database and SPU, PSU using opatch Utility.
• Managing rollback segments redo log files, control files and data files.
• Experience in bi-directional and broadcast replication from source to target databases using Golden Gate 9.5 and Golden Gate 10.0.
• Intensively used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries.
• Expertise in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate issues.
• Implemented data load by replication methods like Materialized views, Golden Gate from OLTP systems into data warehouse databases.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online system.
• Implementation of Flashback Technology and Created and monitored database objects like Tables, Indexes, Views, Users and DB links.
• Experience in Migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP.
• Managed resources for ongoing development of integration.
• Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Stats pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzed SQL trace dumps.
• Used Oracle Data Integrator for High performance batch loads.
• Good experience in Creation and Maintenance of Database Objects like Packages, Stored Procedures, Functions, Triggers, Database Link, Snapshot, Roles, Privileges, Tables, Constraints, Views, and Indexes. Monitoring and managing local table partitioning.
• Responsible for code efficiency and Data integrity for all deliverables
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Possess good leadership, excellent communication and time management and presentation skills with excellent technical, analytical, interpersonal, problem solving and organizational skills.
• Work 24 x7, weekends, late hours. Less guidance, documentation of methods, plans & daily work. Work in Team or as stand-alone person.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 9/10, HP-UX 11i v1.5, AIX 5.3/6.1/7.1, RHEL 3/4/5/7, Windows 2008, Windows 2003Windows 2000/NT, Windows XP.

Databases: Oracle 19c,18c,12c,11g, 10g, 9i, 8i, Mysql, Microsoft Sql Server 2005, Oracle 12c/11g/10g Real Application Cluster (RAC), ASM

DB Utilities: SQL*LOADER, exp, imp, EXPDP, IMPDP, RMAN, Opatch, TKProf, UtlbstatUtlestat, Statspack, AWR, ADDM, QOPATCH, NID, DBVERIFY, SRVCTL, CRSCTL, ASMCMD, DBCA, ADRCI and DBUA

Tools: Oracle Enterprise Manager 10g/11g/12c and 13c, TOAD, SQL Developer, PuttySQL*PLUS, iSQL*Plus, ERWIN 4.14, SQL- Navigator, LogMiner and Flashback data Archive, Macromedia Flash, Quest Fog light, VERITAS Net Backup, Legato backup, Cisco Tidal, Performance and Web Portals, BMC Remedy, HP Quality Center Dream-weaver, MS Office.

Languages: SQL, PL/SQL for Oracle, MYSQL, C, C++, XML.

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, Indiana

Sr. Oracle DBA

Responsibilities:

• Design, Implement and support multiple scalable, highly available, zero downtime, multi-site load balancing Oracle based 50+ TB Oracle Database systems using Oracle 10g/11g/12c/19c including RAC and ASM, Golden gate.
• Installed Oracle 12c GRID software and created upgraded Oracle GRID software and databases from 11g to 12c.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Sized multiple Oracle databases depending on the application requirement with the overhead storage required for the oracle.
• Designed, Configured, and maintained backup and recovery policies including RMAN backups and scheduling RMAN full and incremental backups using Autosys.
• Migrated Oracle databases from red hat Linux to Oracle EXADATA using RMAN cloning.
• Used oracle 11g/12c AWR and ADDM to monitor database activities and performance tuning.
• Performed Range partitioning as cause to improve the performance of the database.
• Proactive performance monitoring and capacity planning for further database and server growth.
• Migration and upgradation databases to 12c to 19c,12c to 18c,11g to 12c,10g to 11g,9i to 10g
• Installation, Configuration and Maintenance of Oracle 9i/10g/11g/12c/18c/19c RAC on two node and four node configurations
• Installed and configured oracle 12c Golden gate software for data replication from multiple sources to target databases.
• Migrated multi-terabyte databases to Exadata machine using data pump utility.
• By using EXADATA provided support to a combination of database system such as OLTP and OLAP.
• Installed, Upgraded Golden gate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering update of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Implemented OEM 12c Repository database, OEM 12 C Agent, and golden gate plug-in Installation.
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities).
• Administrating databases across development, QA, UAT and PROD environments via use of command line and Oracletools Oracle Enterprise Manager Cloud 12c.
• Worked on SQL Tuning and how to use the available tools outside of Oracle Enterprise Manager
• Installed and Administered Oracle 12c multi-tenant,11g & 10g RAC software with ASM.
• Implemented & Managed Physical Standby and even Configured Automatic Storage Management (ASM).
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12c cloud control.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Refresh database using import/export from production to UAT, SQL*LOADER used to load the data from flat files to oracle tables. Used ETL to extract data from database and transform the data to different databases.
• Implemented partitioning on large tables, expertise in using composite partitioning, local indexes and global indexes.
• Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA).
• Managing Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisor, SQL tuning and Metrics, using Grid Control of Oracle Enterprise Manager (OEM) 12C.
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Implemented database monitoring and tuning, application, and queries using ADDM, ASH, AWR, Explain Plan and OEM.
• Worked with UNIX shell scripts, materialized views, Capacity planning.
• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day operations.
• Providing database support for development and deployment of database scripts in Development, Test, Pre-Production and Production environments.
• Involved in 24 X 7 support for 8TB, 4 node production RAC database.

Environment: Oracle 19c,18c,12c, 11gR2, 10g, RAC, ASM, Exadata, Golden Gate, Dataguard, Oracle Enterprise Manager Grid Control(OEM), RDBMS, Explain plan, Statspack, Sun Solaris, Redhat Linux, Windows, SQL*LOADER, PL/SQL, TOAD, SQL Tuning Advisor, SQL Performance Analyzer, SQL server 2008, Shell Scripting.

Confidential, Charlotte, NC

Sr. Oracle DBA

Responsibilities:

• Design, Implement and support multiple scalable, highly available, zero downtime, multi-site load balancing Oracle based 50+ TB Oracle Database systems using Oracle 10g/11g/12c including RAC and ASM, Golden gate.
• Installed 12c Databases and Responsible for upgrading Oracle 10g RAC to 11g RAC.
• Playing vital role in streamlining all the databases on AIX, HP-UX, Linux, Solaris.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
• Worked closely with the system operations team on database deployment processes and database capacity planning.
• Maintained DATA GUARD to provide high availability by implementing physical stand-by database and snapshot-standby and worked with Oracle 11g features 11g Grid Control and Automatic Storage Management (ASM).
• Upgraded oracle RAC databases from 10g to 11g.
• Implemented Oracle 11g OPS Center and fully integrated hardware and storage Arrays to the Grid Control.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
• Scheduled database maintenance tasks such as tables/indexes analysis, index rebuild, materialized views refresh and db exports.
• Working with Database Monitoring tools like TOAD, BMC PATROL.
• Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 10TB to 30TB on a 6 node RAC.
• Installed and configured oracle 10g and 11g Management Agent (silent and Agent push) and cloned it to the multiple nodes.
• Installed oracle 10g Data Guard Physical Standby at DR site for production nodes.
• Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g, and exadata servers.
• Performance tuning of oracle databases using Sql Access Advisor, Sql Performance Analyzer, sql Tuning Advisor.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine-tuned further.
• Migrated the entire rdbms database to EXADATA machine.
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining and row migration.
• Used ITIL problem management process to minimize the adverse impact of errors and to prevent recurring incidents related to that error.
• Worked on SQL, PL/SQL Programming, and performance tuning.
• Installing agent 12c on the server. Adding high Available database with CRS, scheduling Backups through OEM12c.
• Implemented RMAN Image Copy Backup Strategy for very large Databases in minimizing the downtime for recovery.
• Managed VLDB (Very Large Database) for large number of users.
• Implemented and administered Oracle Golden Gate (v10) for Database Replication between production and reporting node, by using Oracle Streams in parallel to secure data and having the availability of the database during regular the upgrade or maintenance operation.
• Worked on oracle 11g New Features for Administration and Tuning.
• Responsible for Capacity Planning and Upgrade of Hardware and storage Arrays.
• Applied Critical Patch Updates and Patch Set Update (CPU/PSU) on various platforms using Universal Installer and OPatch Utility.
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
• Responsible for managing databases on VCS Cluster and VCFS file systems.
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Configured SNMP Agent on UNIX nodes for monitoring the server health and outages.
• Responsible for monitoring and administering EMC Storage Arrays using Navisphere.
• 24*7 Production Technical Support and Hardware Support.

Environment: Oracle 12c,11g R1,11g R2, SUN SPARC,Sun STOREDGE 6140, 6130, 3500, EMC Storage, VERITAS NetBackup, Solaris 10, 9, 8 AIX 5.2, 5.3 BMC Patrol, 11g OPS center.

Confidential

Oracle DBA

Responsibilities:

• Install,Setup and configured 10g/11g RAC on Redhat and AIX using Automatic Storage Management (ASM).
• Provide support for all assigned projects, which also includes database backup and recovery, performance tuning, capacity planning and monitoring.
• Security compliance on all supported databases following internal and corporate security guidelines.
• Updating Database, Schema refresh and objects comparison using Erwin.
• Configured Oracle Grid and RMAN with TSM based on end-client environments.
• Tuned SGA by Library Cache, Dictionary Cache. Tuned OS by reducing paging/swapping. Tuned I/O which includes separation of data files and redo log files.
• Demonstrated experience in working on Root Cause Analysis for oracle database issues.
• Implementing database security and audit, removing default passwords, configuring permissions for binaries and secure other executables.
• Handled different magic tables to store data with help of triggers.
• Perform TSM Installation and configuration of server and clients including AIXv5.1 server and Windows NT, Solaris and HP UNIX clients. Administering TSM Server daily for reclamation, availability of tapes, tapes to be sent to safe site, to check whether backup schedule run properly, managing Tape Library.
• Using Query commands and Activity logs to check for problems and activities done.
• Provide solutions and service for configurations with TSM server involving more than 300 clients.
• Defining and modifying Barcode rules or labels for the Tape libraries to provide auto adding of new volumes.
• Deciding time for Backup process to take and implementing schedules accordingly.
• Writing Scripts with TSM server with queries to generate statistics and reports.
• Write scheduling scripts to supervise and schedule TSM tasks for backup and archive clients.
• Monitoring of Network performance of all clients for better backup performance.
• Creating Device classes and storage pools and registering nodes under TSM server.
• Restoration of Data for Users in the event of requirement or Systems crash.
• Documented AIX Servers, TSM Server and done Hardware labeling.

Environment: Oracle 10g/11g, HP-UX 11i, AIX 5.2, SQL Server 2005, J2EE, Erwin, TSM