SUMMARY

• Over 8 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g and11g.
• Data transferring with export/import utilities and Data Pump and SQL* Loader.
• Database backup concepts and options such as user - managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.
• Experienced in installing and setting up Oracle 12c, 11g R1/R2, 10g, databases.
• Deployed Standby databases using Data Guard 11G (Maximum Performance).
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch as well as database upgrades
• Installed and maintained Real Application Clusters (RAC)
• Performing complete and incomplete recovery during disasters, failures and user errors.
• Configuring user creation, their roles and privileges profiles to control access over database objects.
• Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.
• Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.
• Tuning of database using Utlstat scripts Statspack and dynamic performance views to monitor system statistics and wait events, AWR, ADDM and Tuning of SGA.
• Extensive experience in database production support.
• Experience as On-Call 24x7 production DBA support, application/development DBA, system administrator.
• Monitored physical I/O and Proper sizing of rollback segments.
• Optimized SQL using explain plan, Auto trace feature and TKPROF to analyze the execution plan and tune the statements.

TECHNICAL SKILLS

Databases: Oracle 11G/10G/12C

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL.

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump,, TOAD, Oracle SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, Columbia MD

Database Administrator

Environment: Oracle 11.2.0.4, 10.2.0.5, 12.1.0.2, RHEL 6.6, RAC, RMAN, OEM, Datapump, AWR, ADDM, ASH

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure proactive problem recognition and resolution of database issues.
• Day - to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs.
• Performed hot and cold backup and recovery using RMAN and UNIX Scripts
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Monitored database and system performance.
• Configured the Event Manager to notify support personnel.
• Worked on application and database security (data access, passwords, network, etc.)
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
• Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases and discovering issues that could potentially cause disasters
• Monitored the server's memory, disk, CPU I/O and network to establish baseline and peak performance for applications using UNIX command line utilities.
• Analyzed SQL queries causing performance problems.
• Administer database user accounts. Create, modify and deactivate user accounts assign
• Work cooperatively with developing team to make structural changes to the databases.
• Implement table partitioning/indexes etc. to improve performance and data management and monitor user access rights
• Perform RMAN configuration, database backup which included (hot and cold) and recovery, troubleshoot and resolve related issues.
• PL/SQL Tuning and bottlenecking: Tuning and fixing some performance problems using AWR/ADDM and EXPLAIN PLAN.

Confidential, Little Rock AR

Database Administrator

Environment: Oracle 11.2.0.3, 10.2.0.5, RHEL 5.5, Sun Solaris 10.0, DataGuard, RMAN, OEM, Datapump, AWR, ADDM, ASH

Responsibilities:

• Worked in an environment comprising 200 databases with the largest databases each of size 5 TB.
• Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Capacity planning of tables, indexes, table spaces and databases to allow for growth potential.
• Worked with application developers to address and clarify data requirements to resolve technical and functional issues.
• Enforced corporate business rules through adequate user/resource/object management.
• Reconcile functional and technical problems through interaction with the client by researching and identifying the defined issue and by fully testing and confirming possible solutions to the problem.
• Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.
• Involved in performing upgradation from Oracle 9i, 10g to Oracle 11.2.0.3 RAC database.
• • Experience in using Golden Gate to support data replication in the Oracle database environment.
• Experienced in installing and setting up Oracle 12c, 11g R1/R2, 10g, databases.
• Worked on POC on OEM 12c Cloud, installed in all our non -prod databases, have good knowledge on 12c.
• Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS
• Experience in Data Migrations using oracle export/import, datapump, sqlldr.
• Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN.
• Proficient in using OEM and RMAN.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Designing the logical and physical database structure.
• Schema design experience using ERwin, expert scripting experience in Perl and all Unix shell scripting variations.
• Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
• Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
• Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
• Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
• Achieved optimal performance tuning by using explain plan, STATSPACK, SQL TRACE, TKPROF utilities.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Creating database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.
• Troubleshoot and resolved log gap in Data Guard Configuration

Confidential - Denver, CO

Database Administrator

Environment: Oracle 11g/10g/9i, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, DataPump.

Responsibilities:

• Installation of oracle 11g databases in production, development and test environments depending on project requirements.
• Configuration of Listener and Tnsnames.
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
• Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
• Designed Logical and physical database for business transaction functionality.
• Provide production support for the deployed project till it is stabilized.
• Collaborated with the UNIX system Administrator to configure any software and hardware requirements that will function with the Oracle Database
• Refreshing development/test database from production using Export/Import & RMAN backups.
• Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
• Managing database security.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Defragmentation of tables and indexes for improved performance and effective space management.
• Managed Database Maintenance Activities to achieve optimum database uptime.
• Written SQL scripts to create database objects like tables, views and sequences.
• Created procedures and functions using PL/SQL.
• Preparation of High Level & Low Level Design documents.

Confidential - Deerfield, IL

Oracle Production Support Database Administrator

Environment: Oracle 11.2.0.3, 10.2.0.2, Sun Solaris 10.0.

Responsibilities:

• Estimating table sizes, table spaces.
• Created database objects like tables, tablespaces, buffer pools, indexes and views.
• Analyzing tables and indexes for performance tuning..
• Ensured that the ICD-9-CM diagnosis and procedure codes & CPT codes requirements are thoroughly understood by all the stakeholders to in corporate appropriate changes in the recording system.
• Creation, maintenance, backups and restoration of databases.
• Analysis and Designing Database.
• Create a PL/SQL function, stored procedure, package to support reports.
• Refreshing and manipulating data in tables using PL/ SQL procedures.
• Creation of logins and user ids and setting up privileges and procedures for protection of data
• Monitored and tuned rollback segment, temporary table space, redo log buffer, sort area size.
• User creation with proper roles and privileges.
• Data migration between databases using both Oracle 11g and 10g export/import utility and Oracle 11g exp/imp data pump.
• Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.
• Ran scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.