SUMMARY

• Results oriented Certified Oracle DBA having 8 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.
• Database Farms Physical Infrastructure Builds.
• Database Server Builds (9i, 10g and 11gR2).
• Database Cluster Builds (RAC).
• Database DR Solution.
• Database Backup & Recovery (RMAN).
• Database protection using Data Guard.
• Database Storage Management (ASM).
• Database Replication.
• Database Migrations.
• Database Upgrade.
• Database Monitoring (Grid Control).
• Database Cross platform Data Movement (Transportable Table spaces).
• Administration skills in RHEL.
• Proficient in Performance Tuning / Instance Tuning.
• Proficient in ASH, AWR and ADDM reports.
• Proficient in AIX, Solaris, HPUX, Other flavors on Linux.
• Proficient in SQL Server Database Administration.
• Proficient in UNIX Shell scripting.
• Proficient in TOAD and SQL Developer.
• Installed and configured Oracle 9i, 10g, 11g 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 Oracle 11g

TECHNICAL SKILLS

Operating Systems: HP-UX, Sun Solaris, AIX, Red Hat Linux Windows NT/2000

RDBMS: Oracle 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, Stats Pack, ADDM & AWR

PROFESSIONAL EXPERIENCE

Confidential - Warren, NJ

Sr. Oracle DBA

Responsibilities:

• Installed 11g databases on Linux, applied patches in various environments and upgraded databases from 10.2/11.2 following Confidential 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.
• Configured Data Guard to provide high availability by implementing 11g R2 Physical Standby database.
• Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
• Cluster Installation and Configuration, Administering databases in RAC for high availability.
• Installation, Configure, setup of 11g RAC on Linux.
• Add new nodes to RAC 11g Cluster to distribute the load.
• Installed and implemented 10g RAC with 4 nodes with ASM.
• Upgraded Databases from 10g to 11g and applied patches as per requirement.
• Worked extensively on data center migrations on multiple database versions. i.e., 9i, 10g and 11g.
• Responsible for installing and configuring Golden Gate for Oracle using 11g R2
• Database migration from 10g to 11g.
• 24x7x365 production support.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• SQL, PL/SQL Tuning and Monitoring.
• Compared and contrasted multiple snapshots using AWR.
• Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
• Responsible for setting up Oracle Golden Gate to help in propagating information between databases.
• Recovered databases and clone applications Using RMAN.
• Responsible for resolving several complex recovery scenarios (including RMAN) with critical production database.
• Extensively used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
• OEM Grid Control installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable table spaces and RMAN.
• Performed Import and Export using Oracle Data pump utilities
• Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
• Used external tables and SQL*Loader to import data from flat files.
• Monitored database space requirements and adjusted for future needs.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues. Basic OS system administration.
• Create and maintain users, roles and privileges
• Generated ASH, AWR, ADDM reports from Grid Control and command line.
• Part of On-call rotation to support 24/7 every few weeks.
• 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.
• Developed/customized UNIX shell scripts to automate routine DBA tasks like monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and to work proactively on alerts for the file system and CPU issues.
• Assisted developers in optimizing their queries. Responsible for monitoring and optimizing the performance of the databases.
• Performed Query tuning, Instance/Memory tuning by using various performance tools Tkprof, Explain Plan, ADDM, AWR etc.
• Planned Backup/Restoration Strategy planned and scheduled Backups, taking Logical Backups with Export/Import utilities RMAN and Data Guard
• Database Tuning - Tuning Applications, Memory Tuning and Tuning Disk Usage.
• Involved in Installation and configuration of Oracle 11g RAC--2 node cluster with OCFS2 on Linux using ASM storage for testing and development.

Environment: Oracle 10g,11g, OEM, RMAN, DBUA, TOAD, Oracle Grid Control, AWR, UNIX.

Confidential - Richmond, VA

Oracle DBA

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 to them profiles and roles according to Dev Env requirements.
• 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.
• Created PL/SQL functions to facilitate business function and calculations.
• Modified, developed new SQL codes to develop new enhancements.
• Implemented Oracle & Application Software Patches.

Environment: Control - M Scheduler, XenoBridge, Sun Solaris, AIX, HACMP, 10g, 11g RAC1 Node.

Confidential - Richmond, VA

Oracle DBA

Responsibilities:

• Evaluated, Tested Oracle 11g and prepared road map for migration to Oracle 11g release 2.
• Implemented Unix Shell scripts to schedule backups of DB as well to monitor the oracle database processes, User processes and log files on the DEV, QA and PROD environments.
• Created and maintained the data model and physical Integrity of the database.
• Managed and monitored standby databases using Oracle Data Guard to ensure high availability, data protection, max performance and disaster recovery.
• Migrated existing DEV & TEST 9i, 10gR2 environment databases to oracle 11g databases from HP - UNIX to Linux and AIX platforms.
• 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.
• Performed Database and SQL tuning by using various Tools like Stats Pack, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.
• Supported Maintenance of 28 Production/Development Databases on various servers with volume ranging from 1 to 1.6 Terabytes Databases.

Environment: Toad, Data Pump, RMAN, HP - UNIX, AIX, Linux, Web Sphere, HACMP, Oracle11g/10g/9i

Confidential, TN

Oracle DBA

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, ASM Physical and standby systems, enabling LDAP authentication and configuring RMAN backups.
• Provided ongoing support of production database environment, space projection and reclamation, query performance tuning of existing applications.
• Installed, configured and tuned oracle 10g/11g databases.
• Patched Oracle production RAC databases hosted on Linux environment.
• Monitored the operating system response in terms of CPU usage, 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 to use as needed, 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, 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