SUMMARY:

• Results oriented Certified Oracle DBA having 9+ years of experience in database administration, system maintenance, production support, RAC, performance tuning, standby, replication, space management, installation, migration, backup recovery, cloning and database security.
• Worked as a dedicated team member responsible for monitoring/support of oracle databases performing release upgrades including overall performance tuning/patch management.
• Documented all technical details including operations, maintenance and end user application issues.
• Installed and configured Oracle 9i, 10g, 11g, 12c on Sun Solaris, AIX, UNIX/LINUX, HP - UX and Windows environment.
• Synch - up database environments (DEV, QA) after each major release or production change.
• Implemented One node RAC and four node 11g RAC clusters on Linux platform and AIX LPARs having GPFS cooked SAN Storage.
• Provided support to the Database system Infrastructure area that had few critical Business Systems including TR, Bills Order and Tracking, Online Charges.
• Co-ordinate with UNIX administrators and management team for space management, problem resolution, capacity planning, software version control, evaluation and support on various servers.
• Established standby/cloned database via Data Guard for Database Disaster Recovery
• Employed predefined UNIX scripts to cleanup database files such as outdated archived redo logs and trace files out of bdump, udump and audit directories.
• Trouble shoot and Configured Sql*Net files according to client and server settings to transfer data.
• Worked on export/import, data pump and SQL Loader.
• Data warehouse analysis and design for diverse legacy system integration.
• Process/workflow analysis, project management from analysis and design for implementation.
• Conceptual data modeling, logical and physical data modeling.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, StatsPack, and SQL Trace.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Standby Databases, Backup and Recovery procedures.
• Worked closely with the application, development and middleware teams for bug fixes and escalation of critical issues related with WAS.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*Loader.
• Worked with team of DBAs in migration of databases from oracle 10g to 11g, 12c.

TECHNICAL SKILLS:

Operating Systems: HP-UX, Sun Solaris, AIX, Red Hat Linux Windows NT/2000 RDBMS Oracle 12c/11g/10g/9i

DB Management:  TOAD, OEM, DBArtisan, SQL Developer, Grid Control,

Tools/Utilities: RMAN, OEM, Oracle Management Server, SQL*Loader, SQL Server, Export/Import, TOAD, Data pump, Query builder, Net Backup, MS Access, Web Sphere, HACMP.

Tuning Tools: Tkprof, Explain Plan, StatsPack, ADDM & AWR

PROFESSIONAL EXPERIENCE:

Confidential, Bay City, MI

Responsibilities:

• Provided support to development team enhancing application components while writing, debugging database packages, procedures, functions and queries to maintain production data and address production support tickets.
• Assisted developers in optimizing SQL, PL/SQL code, Performed Query tuning, Instance/Memory tuning by using various performance tools Tkprof, Explain Plan, Optimizer Hints, ADDM, AWR, SQL tuning advisor etc.
• Coordinated Application Support Team, Infrastructure and Capacity Management Team by providing them required information regarding capacity planning through in-depth trend analysis to calculate space utilization, application growth, and projected database sizing.
• Implemented database management strategy and performed full, incremental and cumulative backups using RMAN utilizing the recommended Backup strategy through Grid control.
• Planned Backup/Restoration Strategy. Automated RMAN Backups, Logical Backups, weekly data load by scheduling Data-Pump code through shell scripts in the Cron.
• Installed and configured 12c multi-tenant Databases with Container database CDB and Pluggable databases PDB.
• Installed, Configured Bi-Directional GoldenGate Replication on 11g/12c environments, resolved conflicts between source and target.

Environment: 10g,11g,12c RMAN, Solaris, RHEL, ACFS, TSM, SQL Developer, ASM, GoldenGate.

Confidential - Philadelphia, PA

Oracle DBA

Responsibilities:

• Worked on a project analyzing, recommending, implementing active data guard, real application cluster RAC to provide HA, DR solutions while monitoring, managing both OLTP, DWS environments.
• Configured 11gR2 machines, Migrated MySQL databases to Linux environments.
• Developed/customized UNIX shell scripts to automate routine DBA tasks like monitoring, reclaiming space, memory utilization and memory tuning. Checking Alert Logs, Archive Logs, Trace files and to work proactively on alerts for the file system and CPU issues.
• Worked closely with the development teams and operations team to manage, support and consolidated more than 50 MySQL instances into 11gR2 databases.
• Worked on partitioning of tables for data warehouse operations for achieving faster response time. Partitioned tables based on range, list hash methodology.
• Configured databases for flash back recovery to have faster fault tolerance by using flash back database, flashback query and flash back table features.
• Involved in deploying new application replication using GoldenGate ensuring synchronization between the databases.

Environment:10g,11g,12c RMAN, LINUX, MySQL Work Bench, SQL Developer, ASM, GoldenGate.

Confidential,Warren, NJ

Responsibilities:

• Installed 11g/12c SGI, 12c RAC databases on Linux, Solaris machines using ASM storage. Applied patches in various environments and upgraded databases from 10.2. to 11.2 to 12.1 following Verizon Standards and Quality Assurance.
• Tested Functional tests and performance tests with real life data load associating with test team.
• Attended meetings regarding up-gradation project and gave different recommendations to how to make faster upgrade to make database down time to the least.
• Worked with the Production/Development team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance.
• Database Tuning - Tuning Applications, Memory Tuning and Tuning Disk Usage.
• Created new database objects like tables, procedures, functions, indexes, views using T-SQL in production/Development environment for SQL Server 2008/2012.

Environment: Oracle 10g,11g, 12c OEM, RMAN, Sql Server, SharePlex, TOAD, Oracle Grid Control, AWR, UNIX.

Confidential,VA

Responsibilities:

• Assisted FRIT DBA’s team along with Oracle Team to migrate Oracle 10g to 11.2.0.3 RAC1 node databases from Solaris to AIX LPAR’s with GPFS.
• Provided Control-M team RMAN scripts to perform automatic full and incremental backups. Tuned backup for performance by parallelizing channel allocation. Performed complete and incomplete recovery using RMAN
• Prepared in advance oracle start up and shut down scripts. Worked with Integration Engineer to complete post installation steps on IBM - AIX power servers to provide successful HACMP technology solution with properly configuring oracle configuration files, system configuration files etc.
• Created new user accounts and assigned them profiles and roles according to Dev requirements.
• Created PL/SQL functions to facilitate business function and calculations.
• Maintained SQL Server 2008 environments resolving permissions, space issues and daily routine jobs.

Environment: Control - M Scheduler, XenoBridge, Sun Solaris, AIX, SQL Server 2008, 11g RAC1 Node.

Confidential,VA

Responsibilities:

• Evaluated, Tested Oracle 11g and prepared road map for migration to Oracle 11g release 2.
• Lead the team members of offshore applications developers for mortgages and loan deployment and provided project progresses to the project manager during weekly meeting.
• Managed and monitored standby databases using Oracle Data Guard to ensure high availability, data protection, max performance and disaster recovery.
• Created and maintained the data model and physical Integrity of the database.
• Migrated existing DEV & TEST 9i, 10gR2 environment databases to oracle 11g databases from HP - UNIX to Linux and AIX platforms while supporting 28 other Prod/Dev dbs of 1 to 5 Terabytes sizes.
• Trouble Shoot errors of IBM Web Sphere Application Server 5.1 along with the middleware team as well apps teams while fetching data source objects and while generating connection pools.

Environment: Toad, Data Pump, RMAN, HP-UNIX, AIX, Linux, HACMP,11g/10g/9i, SQL Server 2008

Confidential, TN

Responsibilities:

• Provided Development DBA support for developer queries and requests, Which includes query tuning, server tuning, identifying problematic code, etc
• Suggested and improved system design and architecture, this includes built New Oracle 10g/11g RAC Databases that comply with FedEx standards and existed modelling patterns using ASM Physical and standby systems, enabling LDAP authentication and configuring RMAN backups.
• Monitored the operating system response in terms of CPU usage, Monitored utilized disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, IOSTAT and TOP.
• Worked with oracle support services to resolve issues, and applied oracle escalation procedures, patches followed by standard built documentation and best practices as well refined these based on experience and new findings from database vendors.
• Responded to all database alerts, warnings, and errors in a timely consistent manner.
• Escalated complex issues to internal team members and third party group members as appropriate.

Environment: Oracle 10g/11g, TKPROF, Stats Pack, SQL* Loader & DB-Artisan