SUMMARY

• Over 8 years of experience in Information Technology as an Oracle DBA on Linux, UNIX and Windows operating system environments.
• Experience as a Production support/Operations DBA with Multi - Terabyte 24x7/large databases and as a Development Engineer/Data Warehouse DBA.
• Expert in maintaining very Large Databases involved in Data warehouse and ERP Applications of various sizes - 10TB.
• Responsible for both managing and supporting all Production, Development and Staging instances of Oracle Version’s 8i, 9i, 10g & 11g.
• Configured and maintained Real Application Clusters environment for high availability and scalability.
• Experience in configuring Data Guard -- Physical Standby and Logical Standby Databases.
• Very good experience BMC Remedy Tool for ticketing system.
• Experience in setting backup and recovery procedures using RMAN and Flashback Technologies-Flashback Databases, Flashback Tables etc.
• Experience in implementing Automatic Storage Management for simple storage interface.
• Experience in installing and configuring/Monitoring Enterprise Manager Grid Control.
• Experience in configuring and Installing/using various Quest Tools- Fog light, TOAD.
• Strong knowledge in Guardium/Lumigent Database security and auditing appliance.
• Strong knowledge and experience in using Oracle Configuration and Provisioning Pack.
• Expertise in SQL and PL/SQL, writing stored procedures, triggers and functions.
• Extensive knowledge in working with the tools like Grid Control, Oracle Portal, Oracle Enterprise Manager, TOAD, SQL developer, Datapump, Exp/Imp, Fog light.
• Good experience using JIRA application for on-boarding databases to OEM.

TECHNICAL SKILLS

Database: Oracle (8i, 9i, 10g, 11g), MS SQL 2000/2005.

Operating systems: Sun Solaris, AIX, HP-UX, Windows 2000/2003/2008 , Windows NT, Redhat Linux.

Programming Scripting languages: C, C++, C#, Java, SQL, PL/SQL, Oracle Forms(10g,9i,6i,4.5)/Reports(10g,9i,6i), T-SQL, Shell/Perl scripting.

Tools: Oracle Grid Control 5, SQL*Loader, RMAN, Toad, Remedy, Quest tools, Weblogic, LogMiner, Statspack, Foglight, TKPROF, Data-pump, DBCA, DBUA.

PROFESSIONAL EXPERIENCE

Confidential, Oklahoma City, OK

Sr. Oracle DBA

Environment: Oracle 12.1.0.1, 11.2.0.4, RMAN, Linux, Windows, OEM 12C, FLOW-CAL, FLAIRDOCS

Responsibilities:

• Installation, configuration of Oracle Database 12C.
• Involved in configuring container and pluggable database in Oracle 12c.
• Upgrade lower environment databases from 11.2.0.4 to 12.1.0.1 on RAC.
• Applied PSU 20299016 on 12.1.0.1.0 to upgrade to 12.1.0.1.7.
• Refresh lower environments from production backups using rman backups.
• Refresh lower environments schemas using expdp/impdp.
• Manual decommission of rac databases.
• Generate health check report on rac databases and troubleshoot them on monthly basis.
• Create dB links as requested from application folks.
• Restart rac cluster during OS patches.
• Setup cleanup jobs via OEM for FLOWCAL application.
• Monitor, troubleshoot rman level 0, incremental backups, archive log backups via OEM.
• Migrate databases from Windows to Linux 64 bit via RMAN.
• Good experience working in Cherwell and Service now ticketing system.
• Flashback queries using flashback transaction query, dba flashback txn state, dba flashback txn report and package dbms flashback.transaction backout ().
• Setup tablespace monitoring for production and lower environment databases via VCOPS.
• Convert RAC databases to Single-Instance databases.
• Setup DR databases for all the production databases.
• Disable and decommission DR databases from production when needed.

Confidential, Shelton, CT

Sr. Oracle DBA

Environment: Oracle 11gR2, EMC Networker, Avamar, RMAN, Linux, AIX, OEM 10G

Responsibilities:

• Create users, take care of tablespaces issues in databases when needed.
• Adding datafiles using brtools utility for SAP databases.
• Installed 11.2.0.4 software along with SBP Patch for SAP databases.
• Restore and recover databases through RMAN when needed.
• Perform databases upgrades using dbua utility from 11.2.0.3 to 11.2.0.4.
• Kicking off backups and monitoring using EMC Networker.
• Involved in restore and recovery testing using Avamar tool for lower environment SAP databases.
• Restore and recover databases using EMC Networker.
• Work with EMC support and storage admin to restore databases in case of index failures caused by networker in the database server.
• Gather stats, re-organize tables and rebuild indexes using brconnect.
• Involved in SAP System SRDF refresh (Physical disks refreshes), restore and recovery testing for SAP Production databases.
• Involved in Large Table and schema refreshes from production to test databases of size 500GB for data staging.
• Involved in active cloning a database through RMAN for testing database patches.
• Setup RMAN scripts, backups from one environment to another.
• Changing retention policy of specific rman level 0 backup s as per application needs.
• Cloning oracle home from one environment to the other.
• Flashback databases or tables when needed.
• Analyze ongoing activities and report to PM s by making use of ASH reports through 10G OEM.
• Tuning direct path reads by altering hidden parameter serial direct read from TRUE to FALSE to reduce the I/O and by creating indexes on respective tables to eliminate full table scans.
• Increasing SGA and PGA AGGREGATE TARGET to increase the performance of user I/O.
• Clear blocking sessions or deadlocks when needed in case of table locks.

Confidential, Wilmington, DE

Sr. Oracle DBA

Environment: Oracle 11gR1, 11gR2, BBDA, RAC, Stand-Alone, ASM, Data guard, RMAN, Linux, AIX, Solaris

Responsibilities:

• 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.
• Work with SA for setting up local mount points for BBDA agent, Oracle cluster and RDBMS binaries for Database Builds.
• Raise appropriate EURC s to add keon host groups on the server for built DBA and make sure all appropriate keon host groups, users and groups exist before the DB builds kicks off.
• Identify, assign and accept the PRIME Work Order allocated for DB builds.
• Build 11gR2 RAC/Stand-alone databases using Blade Logic Automation (BBDA) on Linux, AIX and Solaris.
• Build 11GR1 RAC/Stand-alone databases manually on Linux, AIX and Solaris using GTI standard scripts.
• Configure ASM on both stand-alone as well as RAC databases during the built process.
• Add, drop, and re-balance ASM disks using ASMCA.
• Configure Disaster Recovery (Active Data-Guard) for both RAC and stand-alone databases.
• Changing database character set from WE8ISO8859P15 to WE8MSWIN1252 manually using csscan utility.
• Supporting PNET and SAP databases for Tech Refresh Project.
• Experience working with PRIME/TAMS inventory work orders.
• On-board oracle, oragrid users to EPV.
• Run ESM scans for the dB’s built and make sure jobs are green.
• On-board databases to DBPORTAL.
• On-board built databases to appropriate LOB OEM using JIRA application.
• Generate JIL files for maintenance jobs using the response files.
• Configure and test DBATOOLS jobs scripts.
• Perform setup of maintenance jobs in AUTOSYS and promote jobs.
• Develop database run-book.
• Apply and rollback patches in both standalone and RAC databases.
• Perform Oracle RMAN test and recovery.
• Create Service Requests to oracle and fix problem using Oracle support team.
• Handle the databases to QA, by completing the PRR process.
• Complete and close the PRIME Work Order once allocated db builds are complete.
• Decommission of Single Instance and RAC databases when needed.

Confidential, Durham, NC

Sr. Oracle DBA

Environment: Oracle 9i/10g/11g, AIX 5.3/6.1, OEM, RMAN

Responsibilities:

• Manually Upgrading 9i, 10G and 11.2.0.1 databases to 11.2.0.3 on AIX 64-bit servers.
• Installing 11.2.0.3 Oracle Software for the Oracle upgrades.
• De-installing Oracle 11.2.0.3 software using de-installs utility.
• Installing OPatch utility of version 11.2.0.3.4 and applying PSU 14275605 for 11.2.0.3 upgrades.
• Manual creation of 11.2.0.3 database.
• Setting up logical back-up (exp and imp) by making use of pipes.
• Migrating schemas from Oracle database to the other.
• Decommissioning Oracle databases.
• Identifying Control-M jobs using Go-Global.
• Tracing out the SQL s in prod databases using tkprof and tuning them by making use of SQL profiles using OEM.
• Creating materialized views for resultant tables and refreshing them to eliminate the full table scans in the SQL.
• Making use of SQL Advisor to identify indexing and partitions using OEM.
• Tuning SGA and PGA parameters.
• Identifying performance issues by making use of diagnostic pack by generating AWR, ASH and ADDM reports.
• Switching database to failover server by using Veritas Cluster Manager.
• Monitoring table-spaces using IBM Tivoli Enterprise Portal to resolve space issues.
• Working with HP service center for any production database changes.
• Working with Triole Service Desk (Ticketing System) for lower environment changes.
• 24X7(On-call) support for the databases once every week and once in weekend every two months.

Confidential, Buffalo, NY

Sr. Oracle DBA

Environment: Oracle 9i/10g/11g, Solaris 10, RHEL, AIX5.3, OEM/Grid, RMAN.

Responsibilities:

• Configured and Installed ORACLE 10g, 11g software on Red Hat Linux 4 Servers.
• Upgrade oracle 10g databases to 11.2.0 version
• Created and monitored Physical standby databases on maximum protection, performance mode using Dataguard for Disaster Recovery and performing production databases Maintenance.
• Configured Automatic Storage Management (ASM) for 10g RAC databases for reducing disk
• Performing Database Refreshes using Exp/Imp, Datapump, Sql*Loader and RMAN.
• Installed, configured Oracle 10g & 11g RAC with advanced features
• Very good experience with Oracle 10g RAC administration and HA environment.
• Setup the Oracle Advanced Replication using DB links & materialized views.
• Good experiences with UNIX shell scripting.
• Identifying instance Top Waits root cause and bad queries, writing suggested solution reports about Instance tuning and Query tuning.
• Experience in setting backup and recovery procedures using RMAN and Flashback Technologies-Flashback Databases, Flashback Tables etc
• Very good experience with Oracle RMAN & other backup utilities
• Very good experience with Remedy tool for ticket monitoring and assistance.
• Good experience with Oracle database & application performance tuning.

Confidential, NY

Sr. Oracle DBA

Environment: Oracle 8i, 9i/10g/11g, SQL SERVER 2005, Oracle AS, Solaris 10, REDHAT Linux 4, Windows Server 2008, HP-UX 11.2, Oracle Grid Control 5, SAN, Datapump, RMAN, Golden Gate, SQL *Loader, Exp/Imp, Remedy and Toad.

Responsibilities:

• Implemented Oracle Data pump and stream instantiation, created single and multiple source environments, managed LCR s in Oracle Streams.
• Providing full life cycle on DBA/on call support for Production Databases, Administering, UAT, Development and QA databases.
• Translating technical and Business requirements into efficient Logical and Physical data models.
• Installed & configured Weblogic server on UNIX platform and deployed applications.
• Contention and providing centralized management for Disks.
• Supported installation and setup of ORACLE Cluster’s and RAC database.
• Monitoring and Administrating ORACLE RAC databases on ORACLE 11g Clusters.
• Used Weblogic server to integrate the OID enabled applications.
• Good experience with multi master replication setup & Administer with Golden Gate tool.
• Setup reporting server using ORACLE Streams from various data sources.
• Performed database Migration from Windows platform to Linux using RMAN (Convert) and Datapump.
• Analyzing the Automatic Database Diagnostic Monitor Reports from various Databases in various time intervals, creating BASELINE and monitoring performance metrics of Databases WORKLOAD.
• Experience with BMC Remedy tool for all change management process.
• Upgraded few production databases from version ORACLE 10g to ORACLE 11g.
• Enhancing performance using various components like SQL TUNING ADVISOR, ACCESS TUNING ADVISOR, SEGMENT ADVISOR, UNDO ADVISOR and Automatic Shared Memory Management.
• Resolve database performance issues, database capacity issues and other distributed data issues (OLTP).
• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.
• Identifying instance Top Waits root cause and bad queries, writing suggested solution reports about Instance tuning and Query tuning.
• Performed Table, Index Partitions for increased performance and for better storage management.
• Monitoring and performance enhancement using session Tracing, Statspack and CPU utilization.
• Identifying bottlenecks and wait based analysis using Oracle Wait Interface.
• Documented the Role Transition method from Primary to Standby and vice versa of Dataguard environment.
• Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager.
• Performed software cloning, tuning, patch management and deployment using Configuration and Provisioning, Diagnostic and Tuning Packs.
• Performing Backups (BLI, Full, Cumulative, Differential), Recoveries using RMAN-Netbackup.
• Used Flashback technologies-Flashback Table, Flashback Query & Flashback Database to recover from user errors and minimize the Full/Incomplete database recoveries.
• Performed database Audits/Fine Grained auditing, reports regarding the SOX-compliance activities against financial data, in regular basis on user operations involving sensitive database objects.
• Performing Database Refreshes using Exp/Imp, Datapump, Sql*Loader and RMAN.
• Writing Triggers and debugging Stored Procedures and Functions-PL/SQL.
• Wrote Shell and Perl scripts for monitoring and automating tasks of various Databases.
• Performed Backup and Refreshed SQL SERVER 2005 Databases using SSMS.
• Identified performance bottlenecks and performed performance tuning of SQL SERVER.
• Performed Export and Import utilities in SQL SERVER databases.
• Monitored Performance of databases and Administrated user security of MS SQL 2005.
• Monitored SQL SERVER Databases and assisted developers in debugging T-SQL Procedures etc.

Confidential, NY

Oracle DBA

Environment: Windows-NT, Oracle 8x/9i, 10g, Redhat Linux, TOAD, Export/Import utilities

Responsibilities:

• Performed Installations of Oracle software on various Windows and UNIX servers.
• Designed and developed Web-enabled Oracle Forms & Reports. Including Forms based on stored procedures.
• Designed and implemented hot backups using a combination of incremental differential and full backups using RMAN and Hot/Cold.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
• Installed, configured Oracle 9i RAC in Red Hat Linux servers.
• Migrated the databases from Oracle 9i to 10g in cross platform.
• Contributed to team effort by accomplishing related results as needed.
• Responsible for optimizing the queries and application tuning.
• Performed PL/SQL tuning and assist developers with coding PL/SQL.
• Controlling and monitoring user access to the database for new and existing databases.
• Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.
• Involved in numerous Shell Scripting pertaining to the activities of the DBA.
• Reorganized data files, identification and elimination of contention factors like I/O, buffers and locks.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Planning and scheduling for the backup of database information using Crontab jobs.
• Generated daily, weekly and monthly reports regarding total revenue management.
• Installed ORACLE Enterprise Manager GRID CONTROL and configured it server targets for a centralized monitoring system.
• Monitored databases Performance using ORACLE Enterprise Manager (OEM) and Grid Control.
• Monitored and maintained Security by managing Roles/Privileges for users of the databases.
• Worked on AWR repository, Statspack report and Session Trace 10046 to find/fix root causes for performance degradation in the databases.
• Responsible for Instance Tuning, I/O Tuning, Identifying and fixed contention waits.
• Used ORACLE Wait Interface, to identify the top most wait events and their causes.
• Used advisor, tasks like ADDM, SQL Tune, Access Tune and Undo Advisors for performance tuning.
• Resolved several performance bottlenecks and poorly tuned Ad hoc SQL Statements.
• Installed and updates critical security Patches using Enterprise Manager and O PATCH.
• Worked extensively with tools like SQL * Loader, Data pump, Exp/Imp, for loading data into database and monitoring and querying databases using TOAD etc.

Confidential

Jr. Oracle DBA/Developer

Environment: C/C++, Oracle 8i, 9i, Reports2.5, Oracle Designer, PL/SQL, Solaris 5, Windows 2000/NT

Responsibilities:

• Installing new versions of database software and perform maintenance functions of the database.
• Compiling and debugging packages with in-house code, and assisting the developers with optimizing and tuning the PL/SQL code.
• Wrote Scripts to perform HOT/COLD backups.
• Created user’s and maintained security with roles and privileges.
• Cloning/Refreshing databases from hot/cold backups.
• Setup connectivity to databases using NET 8 for clients and server side.
• Developed and maintained the system using Oracle Forms, Oracle Reports, SQL*Plus and PL/SQL.
• Creating database objects such as tables, views, procedures and functions and executed them using SQL*Plus. Created indexes to improve the system performance.
• Involving in creation of triggers and handling exceptions.
• Wrote Embedded SQL in C (Pro * C).
• Developing various Business and ad-hoc Reports.
• Creating Data Flow Diagram, Entity Relationship Diagram from Designer.
• Involving in writing PL/SQL Triggers, Procedures, Functions and Packages.
• Various stored procedures were written to achieve the back end functionality.
• Analyzed performance bottlenecks and provides appropriate solutions.
• Wrote various scripts in PERL and SHELL for database health and space checks.
• Development, Testing, Implementation and Training.