SUMMARY:

• A technocrat with over 8 years of experience in Database Build, Administration, Client Servicing and Troubleshooting/Technical Production Support.
• Experience in maintaining Oracle Database running on UNIX/LINUX (Sun Solaris, HP - UX, AIX, RedHat Linux) and Windows.
• Excellent experience in production support, installation, configuration, upgrades, Migrations, patches, performance tuning, backup and recovery, cloning, space Management, database security, auditing.
• Responsible for, both managing and supporting all Production, Development instances of Oracle Version 8i, 9i, 10g, 11g and 12c.
• Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, SATSPACK, OEM Grid Control and manual scripts.
• Installed and configured Oracle 12c Enterprise manager to monitor and report the Database health for over 500+ databases.
• Good experience RAC Clusterware administration, Configuration and Patching.
• Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
• Experience in administrating Exadata Machine.
• Implemented High availability using Golden Gate Replication.
• Implanted Uni-directional and Bi-directional replication using various versions of Golden gate.
• Installed, configured and managed Golden Gate replication between both RAC and non-RAC environments.
• Refresh/Create database using RMAN Duplicate/Alternate host restores and perform data refreshes using Datapump utility, Transportable Tablespace, Traditional EXP/IMP.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB .
• Creating Perl shell/ Unix Shell scripts to automate database operation.
• Experience of Install, Configure and Create SQL Server Database for SQL Server 2008 R1/R2, 2012, 2014 Version.
• Oracle Support processes for technical requests through Metalink.
• Experience in administering various 24x7 On-Call Production Support for critical applications.

TECHNICAL SKILLS:

Operating system: Windows 2008, 2012, Sun Solaris 9, 10, Linux RHEL 5, 6, AIX 5.3, 6.1, HP UX 11.

Database: ORACLE 8i/9i/10g/11g/12c, SQL Server 2008/2012/2014 and MySQL

Language: SQL, Oracle PL/SQL (stored procedures, packages, triggers, and query tuning), UNIX, Shell scripting, Perl and PowerShell Script.

Tools: RAC, Exadata, OEM Cloud Control (OEM), SQL* Loader, ASM, Export/Import, Golden Gate, TOAD, Data pump, Data Guard Broker &, SQL Server Management Studio.

PROFESSIONAL EXPERIENCE:

Sr. Oracle DBA

Confidential, Mountain View, CA

Responsibilities:

• Creating database for new projects and configuring GG setup.
• Applying CPU patch to fix the bug by OPATCH utility in RAC node.
• Experienced with Golden Gate 12c installation and configuration
• Resolved replication issues in Golden Gate.
• Converting Replicate from Classic to Integrate and Integrate to Classic.
• Working with Application owner for any new table to add in existing Golden Gate configuration.
• Closely working Application team for schema refresh and access issues.
• Configuring and installation third party application like REVPRO and SABRIX.
• Configuring Web logic and tomcat services for application deployments.
• Integrate third partly application with Oracle EBS suite.
• Applied patch on Oracle EBS suits to fix the bug.
• Granting User Responsible in Oracle EBS suite.
• Configuring Uni-direction and Bi-direction Golden Gate replication pair.
• Configuring DB links as per Application requirement.
• Deploying the scripts in database on the advice of application team.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Setting up CDR built in Golden Gate future to resolving Conflicts.

Oracle DBA

Confidential, Sacramento, CA

Responsibilities:

• Good knowledge and lot of hands-on experience in implementation of database servers (includes HA setup like RAC, Goldengate and data guard).
• VM server validation and working with server admin team for configuration changes.
• Oracle Grid and binary installation on new VM servers.
• Implementing OEM cloud control and installation of OEM agent in servers.
• Migrating the Oracle database to new VM’s through rman and datapump.
• Maintained all existing databases and new installations at current and stable production levels.
• Applied patches, quarterly patch security updates to existing instances.
• Configuration backup script and scheduling on new VM’s database server.
• Creation of clone database using RMAN for testing.
• Monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock and latch contention on new VM’s.
• Automation of Startup, Shutdown on all production and development databases.
• Applied patch to fix the bug in database by OPATCH utility like PSU (patch set update), CPU (critical patch update) and one of patch or single patch.
• Upgrading the oracle database from 11.2.0.3 to 11.2.0.4 to support future migration project to VM’s.
• Replication and Extracting data and applying on production using Golden Gate.
• Installed, configured Golden Gate to replicate data from production to reporting database.

Oracle DBA

Confidential, Plano, TX

Responsibilities:

• Managed and maintained hosted development, test systems, non-hosted client systems, as well as internal systems running Oracle applications in a 24X7 environment.
• Applying the quarterly Oracle DB PSU's.
• Involved in building a physical Standby for the Production RAC servers with Data guard.
• Experience in trouble shooting DR issues, applying logs manually, monitoring DR and its replication.
• Automation of Startup, Shutdown on all production and development databases
• Deploying the scripts in database on the advice of application team.
• Working on End User requests in the database.
• Logical Backup of Databases using Export and Import Utility as well as using Data pump.
• Proactive analysis of systems by running AWR, ADDM reports and taking necessary measures.
• Added, modified or removed users, roles and privileges, profiles, and other data accesses.
• Perl scripting, shell scripting and PL/SQL programming to resolve business problems of various nature.

Oracle DBA

Confidential

Responsibilities:

• Creation and Maintenance of Oracle databases as per the specification provided by application team, taking care of disk space, memory and other available resources.
• Implemented and maintained database security (creates and maintains users, roles and Assign privileges).
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Responsible to setting up a 2-node RAC cluster environment with Oracle 11g and applying patches.
• Applying Oracle Security patches to applicable Oracle databases.
• Creating new 12c database and loading data through Data pump and Import utility.
• Involved in configuring ASM disk groups and tuning balancing power.
• Taking responsible in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Administration of full/half rack Exadata database
• Creating databases and logins with permissions in SQL Server DB as per the developer's request.
• Job Monitoring and making sure all jobs run successfully every night on Oracle and SQL Server DB.
• Worked on Backup and Restore for Oracle and SQL server databases.
• Index creation, analyzing, rebuilding, tables analyzed, gather statistics.

Oracle DBA

Confidential

Responsibilities:

• Provided 24x7 on-call support to the Production databases as a primary DBA.
• Installing & applying patches for Oracle 9i, Oracle 10G, 11G, 10G RAC & 11G RAC software.
• Involved in building a physical Stanby for the Production RAC servers with Data guard.
• Trouble shooting DR issues, applying logs manually, monitoring DR and its replication.
• Responsible in adding an additional node a stand-alone database and get the cluster services available for that.
• Resolved the issues in conflicts between the target and source database in GoldenGate.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Set up Security and audit on servers, user's access per firm policy and standards. Maintained Top security for applications.
• Partitioned large tables for better performance and manageability.
• Implement "Stored Procedures and Triggers" based on business plans using PL/SQL.
• Installation of Oracle Database servers (ASM, clusterware, grid and database software installation).
• Scheduling backup policy and writing UNIX shell scripts for scheduling automated backup.
• Creating Perl and UNIX shell script utilities for parsing or reformatting user data and compiling user information reports for various support purpose.
• Querying the databases using the PowerShell scripts in windows environments.
• Deploying the scripts in database on the advice of application team.
• Regular monitoring of all DB environments (RAC, data guard & single instance).
• Configuring server and database monitoring for all servers and database in OEM.
• Testing switch over and switch back in the servers in DR site and primary site.
• Installed and configured Data Guard 10g, 11g using physical standby for high availability databases and configuring Snapshot database for reporting purpose.
• Maintain, upgrade, troubleshoot all enterprise oracle and SQL server databases.
• Worked for the Database security and compliance team, which involved certifying the newly built databases according to the minimum security baselines set at enterprise level for Oracle as well as SQL Server.
• Upgraded multiple SQL Server Databases from SQL Server 2012 to 2014 Version.
• Worked on Backup and Restore for Oracle and SQL server databases.
• Database refresh in various servers using RMAN (both single instance & RAC setup).
• Installation of oracle client in the application server and also adding up tns entry and setting up database connectivity.
• Knowledge on Oracle Exadata database administration.
• Troubleshooting the problems and issues and finding a workaround and avoiding down time for all the environments.
• Hands-on experience in working on DR-drill activity various times and ensuring that activity is completed perfectly.
• Knowledge on set up oracle Golden gate b/w miscellaneous platforms in real time Environments.

Oracle DBA

Confidential

Responsibilities:

• Creation of Tablespaces, data files, users etc., for the project requirement.
• Controlling the users operations by limiting the memory spaces and grant the necessary roles, privileges and profiles to the users.
• Performed regular RMAN backups to safeguard from User errors and Media failures.
• Creation of clone database using RMAN for testing.
• Using TKPROF, STATSPACK to find ways to improve the database’s performance.
• Creation of Clone database for the test database environment using RMAN.
• Logical Backup of Databases using Export and Import Utility as well as using Datapump.
• Recovery of lost objects and data files.
• RMAN Backup and recovery strategies.
• SQL Loader and PL/SQL Object creation.
• Implementation of DATAGUARD Physical Standby.
• Monitor/manage database space utilization and growth, tablespace usage and extents, to include allocating and planning disc storage, modifying database structure.
• Gathering AWR, ADDM, ASH, tkprof reports.
• Good knowledge about RAC concept, worked on many cluster ware issues.
• Checking the Archive log shipping between the Primary and the standby (DR) databases and troubleshooting it by rebuilding the Standby databases.
• Managing customer service operations for rendering and achieving quality services.
• Responsible for resolving customer complaints on performance bottlenecks.
• Providing value added customer services by attending customer queries and issues.