SUMMARY:

• Over 9 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i, Oracle 10g (RAC, Data Guard & Streams),Oracle 11g,Oracle 12c

OPERATING SYSTEMS: HP - UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10,11 AIX 5.1, 5.2, 5.3,7.1,Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP.

LANGUAGES: SQL, PL/SQL, T-SQL,MYSQL,C, C++, VB, UNIX Shell Scripting, Ksh, bash and Perl Scripting.

SOFTWARES, APPLICATIONS & TOOLS: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, VCS, Shareplex, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, ERwin, TOAD Data Modeler, Rational Rose, VERITAS Net Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.

WEB TOOLS: HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metalink, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Brooklyn NY

Sr Oracle DBA

Responsibilities:

• Migrated 8 TB production database from 11.2.0.3 version to 12.1.0.2 version and also migrated the database from Solaris 10 to EXADATA X-5 machine.
• Configured Golden gate to replicate transactions from 11g source database (8 Node RAC) to 12c target database (5 Node RAC) so that we can cutover to 12c database with minimum downtime.
• Configured 5 node Standby database for 12c production database and also configured it as snap shot standby database so that we can test production load and performance using RAT (Real application testing).
• Converted Physical standby database to snap shot database so that we can capture 11g Production database and replay it on snap shot standby database using RAT for performance testing and tuning before cut over to 12c Database.
• Installed 13c Cloud control on Oracle Linux and also installed agents on SOLARIS and IBM servers using push method and silent installation.
• Worked on Configuring 11 Node RAC and Supported critical application on this RAC database.
• Configured 11 node Data guard environment for disaster recovery of Production database.
• Merged 11 Production single instance databases in to one database which is 11-Node RAC database.
• Supported mission critical databases and extensively involved in resolving the performance issues.
• Worked on Configuring OEM 12c Enterprise management system on Solaris and IBM machines and installed all different platform agents to monitor the production databases.
• Worked on configuring and setting up notifications for database alerts and incidents from OEM 12c.
• Worked on implementing standard RMAN backup policies and successfully was able to restore huge database when required.
• Using RMAN successfully recovered 30 days of production data which was deleted due to application code bug.
• Worked on resolving performance related issues with AWR,ASH,ADDM,SQLT reports
• SQL performance tuning in a RAC Environment
• Assist with database administration activities as requested, responding and fixing all database issues
• Assist in sizing database objects for effective space management and optimal performance.
• Assist in create partition tables for 11g RAC Environment.
• Worked on application releases and provided support for application team to fix the release related issues.
• Worked on data guard failover and switchover operations using DG broker.
• Worked on recovering standby database using SCN incremental backups from Production primary database.
• Worked on refreshing production databases on sandbox for application testing using export/imports and RMAN active duplicate.
• Worked on Real application testing to have access the work load before migrating and upgrading production databases.
• Provided on call support for every 3 weeks and provided support on weekends.

Sr. Oracle DBA

Responsibilities:

• Golden Gate Implementation: Migrated critical application data from 10g Database to Exadata 11gR2 (11.2.0.3) using Golden gate technique.
• Migrated 4T application schema to Exadata Machine Database using Oracle Golden Gate with minimumdown time.
• Provided support for 3 Oracle Exadata machines - Prod, DR, QA - to be used for mission critical applications.
• Architecting and implemented a RAC database solution for a global laboratory application. The database environment also includes a physical standby database for DR and a logical standby database for reporting.
• Designed and implemented a RAC database for in-house global CRM application.
• Maintained a 99.99% uptime for all databases by using DBA best practices and proactive monitoring.
• Supported 24T Data warehouse environment.
• Implemented and provided support to IDEXX Germany team in migration their production environments to the 11gR2 database server machines.
• Designing, implementing and supporting backup and recovery solutions using RMAN, Data Guard and flashback database technologies.
• Partitioned large tables using DBMS REDEFINITION technique, so that the applications never had downtime.
• Responsible for setting and managing user accounts, and granting required privileges to users.
• Played a key role in release management and change management for many production deployments.

Environment: Windows 2000/2003/XP , AIX 5.2/5.3 and Red Hat Linux 5.4, SOA , Oracle 10g and 11g, Exadata X2, TOAD 11.0, SQL tuning optimizer, Oracle Enterprise Manager (GC), EM12c, RMAN, RAC, ASM, DataGuard, ASM, SCP/SFTP, Shareplex, TKPROF, Explain plan, AWR, ADDM, ASH, SQL Developer, SQL* Plus, PL/SQL, Golden Gate.

Sr. Oracle DBA

Responsibilities:

• 24x7 Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Involved in installation of Oracle 11g RAC using cluster ware and ASM.
• Resolved complex RAC issues which involved with virtual IP addresses, Subnet masks while assisting the functional team.
• Managed and resolved RAC (10g, 11g), ASM and cluster ware issues.
• Successfully applied latest Patch Set Update (11.1.0.7.10 ) on 11gR1 databases.
• Used OPatch Utility to install one-off patches to fix specific bugs on Oracle Database.
• Tuned the database instances based on the reports generated by AWR,ADDM,EXPLAIN PLAN,TKPROF, ASH and STATSPACK.
• Performed sql tuning by generating execution plan and AWRSQRT reports for the required sql statements.
• Implemented cleanup strategy method to cleanup huge loads of old data in a well design techniques and executed the strategy successfully without having any impact on the business logic.
• Intensively worked with developers and helped them by improving the database performance.
• Responsible for providing documentation for database design, analysis, modifications, creating schemas etc.
• Management of schemas, objects partitioning the tables & indexes.
• Involved in refreshing the QA databases with PRODUCTION backups
• Effectively restored and recovered database by using Oracle RMAN techniques.
• Developed scripts for monitoring Tablespace sizes, alert log files, Tablespace growth and implemented Crontab job to alert if the tablespace size exceeds above 80%.
• Responsible for taking backup of schemas, tables and table spaces using Oracle 11g Data pump.
• Expertise in using the parameters of Oracle export/ import Data pump.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints and database access.
• Responsible for setting and managing user accounts and granting required privileges to users.
• Responsible for moving files to remote serves with secure SCP/FTP techniques.
• Played a major role in release management and change management for Production Deployments.
• Responsible in handling some critical and generic errors like ORA-600, ORA-7445 by creating SR’s with oracle Tech support.

Environment: Windows 2000/2003/XP , AIX 5.2/5.3 and Red Hat Linux 5.4, SOA , Oracle 10g and 11g, TOAD 11.0, SQL tuning optimizer, Oracle Enterprise Manager (GC), RMAN, RAC, DataGuard, ASM, SCP/SFTP,Shareplex, TKPROF, Explain plan, AWR, ADDM, ASH, SQL Developer, SQL* Plus, PL/SQL, SQL* Loader, T-SQL, SQL Server 2005, Golden Gate.

Data collection and Verification Associate

Responsibilities:

• Verify the data in the central repository database of the client portal and also need to verify the data is accurate as per the client SLA.
• Mentored Junior Associates in the team.
• Provided Training sessions to Junior about the client console.
• Maintained and administered client database.
• Been involved in Quality testing to meet the Client SLA.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem.
• Recognition and resolution of database issues.
• Installation, Upgrade and Configuration of Oracle 9i and 10g Databases.
• Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
• Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
• Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.
• Oracle Streams Bi-Directional replication implementation at Table, Schema and Database Level .
• Implemented backup strategies using hot/cold, exp/imp used on the business req.
• Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery (TSPITR) using RMAN.
• Implemented Streams replication between RAC and non RAC database environments.
• Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink)

Environment: HP-UX 11, Red Hat Linux4, Windows 2000/2003, Oracle 9.2.0.8/ 10.2.0.3/ 11 i, DB2, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL*Plus, PL/SQL, ASM, J2EE, ToadV9.7 & SQL, Navigator V6.1.