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 wif 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 wif teh 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 teh 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 wif 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 wif EMC support and storage admin to restore databases in case of index failures caused by networker in teh 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 teh 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 teh me/O and by creating indexes on respective tables to eliminate full table scans.
• Increasing SGA and PGA AGGREGATE TARGET to increase teh performance of user me/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 wif 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 teh server for built DBA and make sure all appropriate keon host groups, users and groups exist before teh DB builds kicks off.
• Identify, assign and accept teh 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 teh 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 wif PRIME/TAMS inventory work orders.
• On-board oracle, oragrid users to EPV.
• Run ESM scans for teh 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 teh 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 teh databases to QA, by completing teh PRR process.
• Complete and close teh 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 teh 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 teh other.
• Decommissioning Oracle databases.
• Identifying Control-M jobs using Go-Global.
• Tracing out teh 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 teh full table scans in teh 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 wif HP service center for any production database changes.
• Working wif Triole Service Desk (Ticketing System) for lower environment changes.
• 24X7(On-call) support for teh 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 wif advanced features
• Very good experience wif Oracle 10g RAC administration and HA environment.
• Setup teh Oracle Advanced Replication using DB links & materialized views.
• Good experiences wif 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 wif Oracle RMAN & other backup utilities
• Very good experience wif Remedy tool for ticket monitoring and assistance.
• Good experience wif 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 teh OID enabled applications.
• Good experience wif multi master replication setup & Administer wif 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 teh Automatic Database Diagnostic Monitor Reports from various Databases in various time intervals, creating BASELINE and monitoring performance metrics of Databases WORKLOAD.
• Experience wif 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 wif 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 teh 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 teh Full/Incomplete database recoveries.
• Performed database Audits/Fine Grained auditing, reports regarding teh 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 teh databases from Oracle 9i to 10g in cross platform.
• Contributed to team effort by accomplishing related results as needed.
• Responsible for optimizing teh queries and application tuning.
• Performed PL/SQL tuning and assist developers wif coding PL/SQL.
• Controlling and monitoring user access to teh database for new and existing databases.
• Writing Oracle scripts for teh SQL and PL/SQL requirements for various applications.
• Involved in numerous Shell Scripting pertaining to teh activities of teh DBA.
• Reorganized data files, identification and elimination of contention factors like me/O, buffers and locks.
• Worked wif database export & import scripts to backup database structures and automation procedures.
• Planning and scheduling for teh 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 teh databases.
• Worked on AWR repository, Statspack report and Session Trace 10046 to find/fix root causes for performance degradation in teh databases.
• Responsible for Instance Tuning, me/O Tuning, Identifying and fixed contention waits.
• Used ORACLE Wait Interface, to identify teh 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 wif 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 teh database.
• Compiling and debugging packages wif in-house code, and assisting teh developers wif optimizing and tuning teh PL/SQL code.
• Wrote Scripts to perform HOT/COLD backups.
• Created user’s and maintained security wif 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 teh 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 teh 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 teh 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.