SUMMARY

• Over 7 years experience as Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security and auditing.
• 7 years of experience as an Oracle DBA in Oracle 8i/9i/10g/11g technology architecture on various platforms.
• Experience in managing databases ranging from 500 G to 10 TB.
• Proficient in Oracle database installations 8i, 9i, 10g/11g RAC on UNIX/LINUX, HP - UX, SUN Solaris and Windows environment with hands-on experience in upgrading Oracle databases.
• Proficient in database administration activities such as upgrades, patches, cloning, backup and recovery, performance tuning and capacity planning.
• Extensive experience in developing and automating different shell scripts.
• Experience in configuring oracle Data Guard and streams.
• Strong Knowledge of 10g advanced features like ASM, AWR, ADDM, FLASHBACK, DBMS SCHEDULER, ASSM, AMM, ORADEBUG, SQL Profiling.
• Experience in applying oracle database patches using Opatch utility.
• Experience in installation and configuration of Oracle 10g RAC using ASM, configured user log on load balancing and failover on RAC database for high availability.
• Extensive performance tuning experience, specializing in instance tuning, Oracle9i, 10g and 11g RAC tuning and SQL optimization.
• Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM).
• Experienced in cross platform migrations from Windows to Linux, Solaris to Linux.
• Experience in Migration of Database from 9i to 10g, 10g to 11g.
• Knowledge of Data transfer between SQL Server and Oracle.
• Scheduling jobs through Oracle Job Scheduler, Cronjobs (UNIX), Autosys jobs, Scheduled Tasks (Windows).
• Periodic Database CLONING from production to Development and QA environments, maintaining Database Standards, Reviews, Documentation, Quality Assurance.
• Expertise in Oracle Golden Gate software.
• Experience in installing and configuring Golden Gate 9.5.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online.
• Experience in performance tuning of database, memory & I/O using tools such as AWR, ADDM, STATSPACK and analyzing queries using EXPLAIN PLAN, SQL-TRACE, and TKPROF.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Strong with SQL query Tuning, SQL Traces, SQLLDR, RMAN for backup and recovery, Oracle Datapump, Oracle Export/Import, Scheduler utilities.
• Expertise in maintaining Database Security.
• Experience in monitoring and maintenance of databases using Oracle Enterprise Manager (OEM), TOAD, Oracle GRID, ISQL*Plus, and SQL*Plus Command line scripts.
• Experience in handling of errors like ORA: 600 by raising oracle SR’s.
• Proactive database monitoring using 10g/11g Grid monitoring tool.
• Proficient in SQL, PL/SQL, stored procedures, packages, triggers, forms and reports, DBMS * and UTL * packages.
• Experience with data modeling, logical and physical database design.
• Knowledge on Oracle Support processes for technical requests with Metalink.
• Ability to function successfully in a highly stressful, 24x7 critical environment.
• Result oriented, self-motivated, Team player, ability to work independently.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x/11.x, Sun Solaris 2.6/8/9/10, Linux 2.x/3.x/4.x/5.x and Windows NT/95/98/00/XP/Vista, IBM AIX 4.x, 5L.

RDBMS: Oracle 8i, 9i, 10g, 11g, 10g/11g RAC

Languages: SQL, PL/SQL, Java, C, C++, UNIX Shell Scripting

Tools: RMAN, OEM, SQL*Loader, EXP/IMP, DataPump, Erwin, TOAD

Tuning tools: TKPROF, EXPLAIN PLAN, STATSPACK, SQL*TRACE, AWR, ADDM

Others: EMC, NetApp, Veritas NetBackup, IBM Tivoli, HP omni back up, TSM

PROFESSIONAL EXPERIENCE

Confidential, Bensalem, PA

Senior Oracle DBA

Responsibilities:

• Provided 24x7 on-call support for all the Production and Development Databases.
• Installed, configured and maintained Oracle Databases.
• Installed Oracle Cluster-ware to provide infrastructure for RAC and configured 2 node Oracle 10g RAC with ASM.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Refresh/Cloning of Database for development and testing purpose.
• Involved in Upgrade/Migration of the oracle databases from Oracle 10g to Oracle 11g.
• Used oracle 10g Datapump and export/import for data migration.
• Configured DATA GUARD to provide high availability by implementing physical stand-by database and worked with various Oracle 10g features: Streams, 10g Grid Control and Automatic Storage Management (ASM).
• Involved in Performance tuning using tools like Explain Plan, SQL*Trace, TKPROF and Stats pack
• Extensively used ADDM, AWR and ASSM features.
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
• Reading Alert log and user trace files and diagnosing the problem.
• Used RMAN for backup and recovery and performed backup validations.
• Continuous monitoring of database performance during peak and non-peak loads using AWR reports.
• Conducting sizing & capacity planning for oracle databases.
• Automation of startup shutdown on all production and development databases.
• Automation of data load using shell scripting and SQL*Loader.
• Load balancing, databases/schema/table re-organization using Quest Live-Reorg for faster performance.
• Upgrading development and production databases to Oracle 10g/11g.
• Installation and configuration of Oracle Client software and Tools.
• Analyzed the user requirements and designed partitioned tables for improving performance.
• Responsible for optimizing the queries and application tuning.
• Performed SQL tuning and assisted developers with coding PL/SQL.
• Developed scripts for startup and shutdown, health check of databases and scheduling of backups.
• Performed regular DBA activities including space management and performance monitoring.
• Involved in database installations/upgrades/patches, space management, capacity planning, backup & recovery, disaster recovery, database performance tuning, memory tuning, application tuning, security administration, Data Guard, real application clusters.
• Transforms logical database designs into physical databases; Builds and implements test, quality assurance, and production databases and environments; Coordinates strategies to move data between databases; Monitors database space requirements and adjusts for future needs.
• OEM installation and configuration for monitoring and performance tuning.
• Developed scripts for the automation of analyzing of tables.
• Hands-on experience in using Oracle Application Server 10g, in deploying and integrating enterprise’s applications
• Designing and implementation of database backup/restore methodologies troubleshooting performance and networking issues. Basic OS system administration.
• Proficient in communicating directly with internal resources on a daily basis,
• Able to work effectively with multiple teams at once. Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills and discipline for Change Management practices processes
• Implemented streams and Logical standby replication.
• Solid discipline providing end-users timely updates on their problems. Installing server software.

Environment: Oracle 8i/9i/10g/11g databases, 9i/10g DataGuard, 9i/10g RAC, 10g Datapump, Export/Import, Golden Gate, Physical Backups, RMAN,AWR, HP-UX v11i, HP 700 Series, Sun 3500,3800,6800, Sun Enterprise 450 & 880,Solaris 2.6 to 9.0, Red Hat Enterprise Linux 3.0/4.0/5.0,, Oracle Enterprise Manager.

Confidential, Indianapolis, IN

Oracle DBA

Responsibilities:

• Provided on-call support for both production and development databases.
• Involved in Capacity Planning, Hardware configuration for Oracle 10g RAC Environment.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace, TKPROF and Statspack.
• Migration of database from 9.2.0.6 and to 10.2.0.2.
• Assisted System and Network Administrators in Setting up the hardware for installing 10g RAC.
• Implemented 10g RAC consisting up to 3 nodes.
• Worked with Golden Gate Software to replicate the database.
• Involved in Performance tuning using tools like Explain Plan, SQL*Trace, TKPROF and Stats pack.
• Implemented 10g/11g Data guard with one physical database.
• Developed scripts to proactively monitor the databases and alert the DBA on events such as running out of extents, disk space and actively involved in Shell Scripting for various CRON jobs to be run.
• OS level activities like space monitoring of mount points.
• Responsible for handling some critical errors like ORA-600 by creating SR’s with Oracle Tech Support
• Developed shell scripts to monitor and maintain the Oracle database.
• Create table spaces, tables, and users for custom applications.
• Implemented backup & recovery functions using hot, cold and RMAN procedures.
• Involved in developing a disaster recovery (DR) plan & conducting/implementing a DR exercise.
• Extensively used ADDM, AWR, ASSM, AMM features of 10g
• Composed, maintained and monitored compliance to standards and practices; Assisted IT Analysts on technical database issues and features; resolved data integration issues.
• Create and maintain clone/staging database environment as well as hot standby database
• Enroll users and maintain system security, ensuring compliance with database license agreements
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues
• ASM implementation & maintenance.
• Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Loading bulk data from flat files using sql*loader and external tables

Environment: Sun Solaris 10, Oracle 9.0.1.5/ 9.2.0.1/ 10.1.0.2 , SQL*Loader, Sun Solaris 9, TOAD, OEM, Statspack, tkprof, Sun Enterprise 4500, SQL, RMAN, Datapump, Import/Export.

Confidential, Chicago, IL

Database Developer/Jr.DBA

Responsibilities:

• Provided 24*7 supports for the production database.
• Installing and maintaining Oracle databases.
• Upgraded 9i database to 10g and implemented sever partitioning.
• Performance tuning using tools like Explain Plan, SQL*Trace, TKPROF and Statspack.
• Used to do HOT backup every day and COLD backup once in two weeks on the application database techniques using RMAN and conducted disaster recovery drills
• Experience in Backup & Recovery and explaining SQL: optimized SQL statement by using hint to change the access path and join order; tuned table access, optimized full table scans and index lookups.
• Partitioning strategies for very large tables.
• Creating and managing tablespaces.
• Implementing range, list partitions, hash partitions.
• Creating and refreshing materialized views.
• Perform general technical troubleshooting.
• Performing all the database administration activities like space management in database, users and roles administration, schema management, checking alert.log of all the databases.
• Developed many PL/SQL functions, procedures, packages and triggers.
• Worked on several V$ views and dba * to monitor the database and solve different kinds of problems.
• Automation of startup shutdown on all production and development databases.
• Creating custom concurrent requests to perform database maintenance.
• Developing SQL scripts to monitor tablespace and extent growth.

Environment: Unix/Linux, Oracle 9i, SQL*Loader, HOT/COLD backups, PL/SQL, TOAD, OEM, Statspack, tkprof, RMAN, Export/import, Performance.

Confidential

Database Developer/Jr.DBA

Responsibilities:

• Installation, configuration and upgrading of Oracle server software and related products.
• Established and maintained sound backup and recovery policies and procedures.
• Training the client users and maintaining the documentation of the database.
• Actively involved in gathering requirements, system design, development, and application support.
• Managing users, roles and privileges, space management and creating storage structures.
• Creating and managing tablespaces and rebuilding the indexes.
• Developing SQL scripts to monitor tablespace and extent growth.
• Cloning the databases for different environments.
• Developed many PL/SQL functions, procedures, packages and triggers.
• Developed some forms and reports using Forms Builder and Reports Builder.
• Cross platform migration using export import from windows to Linux.

Environment: SQL*Loader, SQL*Plus, Shell Scripting, Windows-NT, HP-UX, Oracle 9i.