SUMMARY

• Over 7+years of Experience in Oracle database administration and core Database Administration, tuning, development, analysis, design, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, backup and recovery, cloning, auditing, SQL, PL/SQL, troubleshooting and documentation.
• Also oracle database 11g Administrator certified Associate.
• Hands on experience in installing and maintaining 12c, 11g, 10g databases.
• Established Backup policy using RMAN and Network backups. Also used Data Pump, Traditional Export and Import.
• Managing Backup, Restore using RMAN and conventional UNIX shell scripts.
• Oracle Database Administration in a variety of environments including Linux, HP - UX, AIX
• Used Automatic workload repository (AWR), Automatic Database Diagnostic Monitor (ADDM) Reports for trouble shooting performance issues and Capacity Planning. Extensively used Explain Plan, TKPROF and SQL Trace.
• Worked with Partition Tables. Partitioned Tables and sub-partitions as per the requirement of the Applications to improve performance and data management.
• RMAN procedure for backup and recovery.
• Managed Oracle server in high Availability environments using Failover, Clustering, Mirroring, Data Guard and Cloning technologies.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.
• Experience in maintenance of Production, Testing, Development, RAC, Standby databases/ Data Guard.
• Worked closely with Developers helping them identify and fix issues. (eg.’s correcting a PL/SQL procedure to receive emails after completion of their program).
• Having sound knowledge in MySQL and hands on experience X - query.
• Worked and Activated change control tickets for various production applications by following Enterprise change management system.
• Created tablespaces and managed tablespaces by adding/deleting/resizing data files.
• Created schema (tables, Indexes, views, sequences, synonyms, packages).
• Setup database auditing, granted privileges to users through system/object roles.
• 24 x 7 production support when required (for the issues like installing new system, production issues and the problems with the production scripts etc).
• Experienced in Oracle Support processes for technical requests through MOS (Metalink) and other support procedures.
• Documented all Oracle database installations and database operations.
• Hands on experience in SQL and PL/SQL programming language. Created, debugged, and modified stored procedures, triggers, tables, views, user-defined functions etc.
• Involved in tuning of SQL queries by using Quest SQL optimizer and manually by Explain plan.

TECHNICAL SKILLS

Database: Oracle 12c/11g/10g

Operating System: Linux, HP-UX 11/11i, Sun Solaris, and Windows NT/2000/2003

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: /Utilities: SQL*Loader, Data Pump (Export/Import), OEM, TOP, RMAN, TOAD, AWR, ADDM, STATSPACK, TKPROF, Crystal Reports, Oracle Grid Control.

PROFESSIONAL EXPERIENCE

Confidential, King of Prussia, PA

Oracle DBA

Responsibilities:

• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Developed tools to migrate the data from legacy systems to oracle database.
• On-Call 24x7 DBA support for very large databases.
• Played a crucial role in installing and configuring 11g Oracle database.
• Worked on physical and logical design of the Databases which includes Database, tablespace, and index and partition creation.
• Experience in implementing RMAN backups and recovering databases using those RMAN backups.
• Provided database support for very large databases (VLDB) of size more than 3 Terabytes.
• Extensively worked on performance tuning to achieve optimal Database performance.
• Proactively monitored Databases by reviewing AWR and ADDM reports regularly to find any potential issues.
• Worked with development team and system admin for resolving various performance issues.
• Applying Quarterly patches and Version change patch bundles.
• Refresh/Cloning of Database and applications for development and testing purpose
• Worked closely with Developers helping them identify and fix issues. (eg.’s Correcting a PL/SQL procedure to receive emails after completion of their program)
• Provide technical assistance and backup for all team members during system problems and implementation both during business hours and off hours.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks

Environment: Linux Red Hat, Oracle 12c/10g/11g, OID (Oracle Internet Directory), Oracle Name server, BMC Remedy for Change management, BMC Patrol, BMC SQL-Back Track

Confidential, New York, NY

Jr. Oracle DBA

Responsibilities:

• Designing system architecture, Sizing the hardware servers, Network architecture etc. for running Oracle Databases and Applications in Production environment.
• Used Data Guard (Standby Database) for OLTP instances.
• Building and refreshing the materialized views.
• Creating and dropping users, allocating resources, creating and updating Schemas.
• Proper distribution of data to avoid fragmentation and routinely generate the Report for database health as manually Defragment data.
• Reorganizing the database at regular intervals to remove row migrations, fragmentation in the database using export and import utilities.
• Complete responsibility and control for writing DDL, DML and security of databases.
• Decided and Implemented table and Index Partitioning of major Tables for better performance, handling and management of data.
• Configured Listener for external procedure.
• Tuned the System Global Area (SGA) components dynamically according to the requirement after observing different Hit Ratios, caching of small tables in the Database Buffer Cache, keeping the mostly used and huge packages in the Shared Pool.
• Developing backup and restore procedures using RMAN with recovery catalog, configuring and managing Flash recovery areas on remote sites.
• Validating and testing daily backups and coordinating with the customers during maintenance activities and system reboots.
• Monitoring disk space and database space usage to ensure proper functioning of production databases.
• Cloning the database and the database refresh of the TTD environments with the production databases.

Environment: ORACLE 10g/11g, Oracle 10g/11g RAC, ASM, RHEL 4.x, SUN SOLARIS 10, HP-UX 11, Toad, SQL, Data Pump, OEM, RMAN, SQL*Loader, OLTP, Oracle Applications.

Confidential

Jr.Oracle Database Administrator

Responsibilities:

• Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL.
• Used SQL* Loader to load data into different tables.
• Created tablespaces and managed tablespaces by adding/deleting/resizing data files.
• Created schema (tables, Indexes, views, sequences, synonyms, packages).
• Setup database auditing, granted privileges to users through system/object roles.
• Mapping Operational Repository to Business Repository elements and incorporating the build rules.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Extensively used PL/SQL to extract data from different tables with 20 Million records in some of the tables.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using SQL Trace, TKPROF, STATSPACK, Explain Plan, automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Created db link for inserting large tables directly without taking export.
• Used STATSPACK for Database Monitoring and Database Performance.
• 24 x 7 production support when required (for the issues like installing new system, production issues and the problems with the production scripts etc).
• Based on the user selection and finally storing the output as a flat file for further processing for the next module.
• Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used.
• Incorporated validation rules for promotion history table and updating tables.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.

Environment: Oracle 10g, PL/SQL, SQL*Plus, Export, Import and Windows 2003 & Linux.