SUMMARY

• An Oracle Database Administrator with over 6 years of experience which includes Installation, Configuration, Migration, Database Backup & Recovery, data guard implementation, Tuning Confidential Instance level and SQL level, Cloning, Space Management, Database Security, Auditing, Troubleshooting, Managing Oracle 11g/10g R2 databases and documentation in heterogeneous environments. Worked on various Oracle versions like 10g, 11g Databases across various platforms such as Solaris, AIX, UNIX, Linux, HP and Windows.
• Extensive experience with Database Cloning and Refreshing pre - prod/dev databases with prod/pre-prod databases.
• Thorough understanding and excellent experience in tuning, assigning proper indexes such as BITMAP or B-Tree Index according to requirement.
• Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and stepwise.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Listeners, PL/SQL,UNIX Shell Programming.
• Excellent experience in Performance tuning of oracle databases using Oracle Grid Control, AWR, ADDM, TKPROF,STATSPACK, and tuning of SQL scripts using SQL Trace, Explain Plan, and Hints.
• Install, configure and upgrade to Oracle 12c; consolidate multiple databases into multi-tenant database containers; evaluate and implement latest database technology and new Oracle 12c features.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Proficient in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.Supportive individual capable of managing incidents, being proactive in terms of preventive maintenance and knowledgeable in terms of risk management.
• Expert in support and maintenance, performance tuning, shell scripting, database upgrades and enhancements, etc.
• Have great passion for technology, attentive to detail, team player, results oriented, fast-paced, multi-tasker with a proven track record, and entrepreneurial. Developed Recovery Manager (RMAN) scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Experience in Configuring Single instance to multimode, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM) and Data guard and Streams.
• Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
• Strong Knowledge and experience of Creating Users, Public Synonyms, materialized views, Database Links, roles, profiles, privileges, Audit Triggers and assigning roles to users.
• Experience in creation of project presentations for progress meetings and other high level discussions.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

TECHNICAL SKILLS

Software development methodologies: RUP, SDLC, UML

Front-End Tools: MS Excel, MS Word, MS Visio, MS ProjectDatabases Oracle 12c, Oracle 11g, Oracle 10g

Oracle Database tools: SQL*Loader, TKPROF, Toad, OEM, ToadTKPROF, EXPLAIN PLAN,STATSPACK, AWRADDM, ASH, SQL, Developer, Grid Control,GG

Operating Systems: Solaris 10/9/8, Sun Sparc, RHEL 5.X/4.XOEL, HP UX 11i, Windows 2000/2003 server

PROFESSIONAL EXPERIENCE

Confidential, North Charleston SC

Oracle DBA

Responsibilities:

• Applied quarterly security patches (CPU & PSU) for the databases
• Upgraded Oracle database from 10.2.0.5 to 11.2.0.2 and used Oracle RMAN and tools such as SQL BACKTRACK to refresh and clone databases as needed by the client.
• Used Oracle OEM grid control and Toad to manage and tune the databases as needed including fusion middleware applications for optimal performance.
• Used Oracle Recovery manager (RMAN) and SQL BACKTRACK to backup Oracle databases to ensure a point-in-time recovery as needed by client.
• Enhanced UNIX shell scripts to manage database alerts, backups, startup scripts etc and ran AWR reports to tune all areas of the database.
• Cloned Oracle 10g and 11g databases using recovery manager duplication procedures and refreshed the test and development environments as needed by client.
• Created Oracle 11g and 12c databases for 2 large Applications, from planning and testing through production.
• Created database reorganization procedures, scripted database alerts, and monitored scripts.
• Handled database server tuning, application tuning, maintaining documentation, capacity planning and database security.
• Responsible for Oracle 11g and 12c logical and physical database design, implementation, and maintenance.
• Used Explain Plan and Oracle optimizer hints to enhance performance of SQL statements. Performed the user requirements and troubleshooting activities and resolved connectivity issues.
• Identified and reduced/eliminated non-idle wait events such as scattered file read, sequential file read wait event, log file completion, in queue, and buffer latch waits.
• Provide 3rd level support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/DataProtector, trace analysis, service creation, cluster and system management.
• Engineering, implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC), Oracle Streams, Oracle Advanced Replication and specific network storage and clustering solutions.

Environment: Oracle 11.1.0.4/11.2.0.4/11gR2, RHEL 5 and 6, Oracle Enterprise Manager Grid Control, OEM Database control, PL/SQL, Shell Scripting,, TOAD.

Confidential, Middletown, NJ

Oracle Database Administrator

Responsibilities:

• Analyzed and tuned the Database to identify potential database issues such as response delay, locking contention, even server down time by using tools like STATSPACK, EXPLAIN PLAN, and TKPROF.
• Implemented Data Guard on Oracle 11g with high availability and performance configurations and participated in Data Guard Fail over tests.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Monitoring several databases varying Terra byte sizes using Oracle Enterprise Manager Grid Control.
• Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Export and Import of database objects to copy from one database to another database.
• Install, configure and upgrade to Oracle 12c; consolidate multiple databases into multi-tenant database containers; evaluate and implement latest database technology and new Oracle 12c features.
• Perform database monitoring and tuning to ensure databases run Confidential peak performance; troubleshooting production performance issues.
• Used tracing, ASH, AWR, ADDM, Explain plan and SQL tuning advisor to tune reports and jobs, from hours to minutes.
• Installation and configuration of Oracle databases environments (10/11g), upgrades, patching for security vulnerabilities (CPU and PSU).
• Investigating suspicious database activity using Auditing.
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• 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.
• Expertise in UNIX Shell Scripting and automated many common tasks using CRONTAB including: Backups, exports and imports, archiving old records and verification of such processes.
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Extensive experience in daily batch and report monitoring, space management, index rebuilds, statistics collection and other Oracle housekeeping tasks.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Worked closely with project managers, programmers, and testers to ensure the database integrity and security and generated test data and tested new database consistency with existing databases to meet the functionalities requirements
• Involved in query optimization and using rule based optimizers and cost based optimizers.
• Performed database performance tuning, STATSPACK reports automation, stress test on production copy for scalability, resolving production performance issues.

Environment: Oracle 10.1.0.4/10.2.0.4/11gR2, RHEL 5 and 6, Oracle Enterprise Manager Grid Control, OEM Database control, PL/SQL, Shell Scripting, TOAD.

Confidential, Richmond, VA

Oracle Database Administrator

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports and providing recommendations.
• SQL tuning and Application Performance monitoring.
• Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.
• Applying Quarterly security Patches (CPU/PSU) and applying Patch set and One-off Patches..
• Responsible for proactively managing database growth and trends to ensure database availability and propose recommendations based on transaction volumes, usage growth and response times as a part of capacity planning exercise.
• Ensure that the databases do not run out of space with automated scripts
• Conducting sizing and capacity planning for oracle databases.
• Responsible for tuning of long running query’s by creating B-Tree and BITMAP indexes.
• Resolving issues related to Network Congestion, Memory (SGA and PGA),CPU & IO and other oracle related issues.
• Migration of database from one server to another server.
• Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.
• Responsible for configuring dataguard physical and standby database setup for high availability and handling synchronization issues between primary and standby.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Done migration of non ASM database to ASM database.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports and providing recommendations.
• Handling and debugging of high priority and sudden database service interruption issues like service interruption due to ORA-600 errors in the dump and database hung due to ORA 7445 errors and restoring the service to normal and providing efficient root cause analysis.
• Capacity Planning for OLTP environment- Allocating system storage and planning future storage requirements for the existing and new databases.
• Proactive performance monitoring by implementing UNIX scripts and automated jobs (Grid) for alerts.
• Refreshing databases and Migration of databases from various environments for Testing, Development work.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Sizing the SGA, db buffers, shared SQL area, log buffer based on the requirements.
• Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.

Confidential, Mt Laurel, NJ

Junior Oracle Database Administrator

Responsibilities:

• Conducted meetings with user groups to get functional requirements.
• Met with client groups to determine user requirements and goals. Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures.
• Development of standard documentation package (Requirements, Specification, Design, Operations, and Quality Testing Plans).
• Partner with IT team to develop reporting solution using MS Reporting Services to improve daily reporting process and enhanced ad-hoc reporting capabilities.
• Analyzed business requirements and segregated them into high level and low level Use Cases, activity diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Articulated business requirements from user interviews and then convert requirements into technical specifications.
• Wrote functional requirements and test cases for a large-scaleecommerce mortgage servicing and origination web applications.
• Interviewed SME’s (Subject Matter Experts), asking detailed questions and carefully recording the requirements in a format that could be reviewed and understood by both business people and technical people.
• Analyzed test phases including product test, integration test, and system test.
• Actively involved in walkthroughs and meetings with development team to discuss related issues.

Environment: Microsoft Visio, Lotus Notes, Microsoft Excel, Microsoft Word