SUMMARY:

• 11+ years as Oracle Database Administrator (Proficient in Database and Applications Administration Activities).
• Upgraded Database to 9i, 10G, 11G and 12c (12.1.0.2) from prior version
• Experienced in Space Management, Query Tuning and Application Tuning Cloned Oracle applications R12 and Databases.
• Leading and managing the offshore / On site model with 24 X 7 Production support
• Experience in working with RAC setups
• Implementing High Availability solutions with Oracle 10g RAC, Standby (Datagaurd)
• Installed Oracle Clusterware CRS, Clustered Install of Oracle 10g, applying opatch in clustered environments, created database / instances using DBCA on a four node cluster, troubleshooting RAC at OS / OCR / CRS / DB Level.
• Expertise in Installation, configuration, creation, upgrades and migrating Oracle environments (8i/9i/10g/11g/12c) on HP UNIX, AIX, Sun Solaris, Linux and Windows XP/NT servers.
• Keep track of resource utilization and make sure that effective utilization of the resources.
• Continuously audits and reports on all security and usage activity of all databases and at user level.
• Responsible for tuning of RMAN Backup using netbackup and tuning SAN and VERITAS I/O System.
• Setup and supported for Oracle 11g/12c High Availability (HA) solutions including ASM, Grid Controller and Data Guard.
• Generating data movement code, compiles code, execute the code and troubleshoot data movement problems.
• Atomized Proactive Monitoring works using Shell/Batch (DOS) Scripts and extensively documents all changes to the production database including time - logs.
• Setting up Flash Recovery Area in Automatic Storage Management for backup strategy.
• Migrated 10g& 11G databases from various OS to Linux
• Migrated Oracle Application databases of11i & R12 from various OS to Linux
• Applications sysadmin tasks like creating and managing users and their responsibilities
• Sound knowledge in workflow mailer and Discoverer configurations
• Extensive knowledge in working with the tools like OEM, TOAD, Export/ Import, Stats pack, SQL* Loader, SQL Analyze, TKPROF, and Oracle Supplied DBMS PACKAGE.
• Install the Oracle Business Accelerators for Oracle E-Business Suite environments n the client's hardware for training and implementation purposes
• Hot and cold Backup and recovery of Oracle 10g database using tools like RMAN
• Maintenance of Oracle User Accounts (Creating New Users, Modifying User Accounts, Administering user passwords, creating temporary accounts)
• Strong database, application and development tool troubleshooting expertise. Experienced in logical and physical database design, modeling. Hands on database performance and instance tuning for both RAC and NON-RAC environments. Managing Grid Control.
• Complies with all ETS security and audit standards. Ensures security of company information by ensuring database is secure and monitors environment to identify improper access
• Monitoring and ticketing tools like OEM, HPOV and BMC Remedy and other third part tools like KINTANA (HPPPMC), PVCS and Microsoft VSS.

TECHNICAL SKILLS:

DATABASE: 9i, 10g, 11g, 12c

DB Management: TOAD, OEM 11gR2/ 12c, OAM

Operating Systems: RHEL, Solaris 5.9/5.10, AIX 6.1/7.1, HP-UX, Windows

BI/Reporting tools: BO, OBIEE 11.1.1.5

Tuning Tools: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ASH, ADDM, SQLT

Programming: UNIX shell Programming (Bourne, corn), SQL, PL/SQL, HTML

PROFESSIONAL EXPERIENCE:

Confidential, NJ

LeadOracle DBA

Roles/Responsibilities:

• Upgraded CRS (Cluster Registry Services) from 11.2.0.3 to 12.1.0.2 on AIX 7.1
• Upgraded the database from 11.2.0.3to 12.1.0.2
• Maintained the customizations after the upgrade as they were before upgrade
• Configured daily backup jobs which in turn take care of the copy part for daily clone of PROD
• Created weekly PROD automatic restart job which takes care of cleaning of stale sessions and runs a sample request by sending the request log in mail to confirm the restart success
• Performance tuning of the databases including query tuning using SQL profiles and creating required indices, etc.
• Responsible for DB and applications Installations, EBS techstack and database upgrades, cloning, patching, RMAN backups and recovery.
• Refreshing the environments like RAC to RAC clones, RAC to Non RAC clones, EBS family pack upgrades, applications upgrade patching project
• Performing code migrations using the automated tool called STAT, Change Management, performing user and developer Requests/defects through their Change and Configuration Management Ticketing system (CCM)

Environment: Oracle 12c DB, IBM AIXservers, Linux Blade HS22 RAC, ASM, OCFS, Dataguard, RMAN, SSO, OBIEE, Hyperion, STAT Migration tool, OEM 12c Grid Control

Confidential, NJ

Sr.Oracle DBA

Roles/Responsibilities:

• Created Business Model, Logical Model & Physical model from documents using Erwin.
• Upgrade of Oracle 10g(10.2.0.4) Databases to 11g (11.2.0.4) on Solaris 10.
• Responsible for RAC support for production, development and test environments.
• Keep track of resource utilization and make sure that effective utilization of the resources.
• Adding Security at Schema and Database level and securing Listeners.
• Responsible for tuning of server parameters, network workload and disk IO etc.
• Used Grid Controller to monitor and schedule RMAN scripts to manage records of the backup and validated backups to ensure that the database can be recovered when necessary.
• Responsible for Performance tuning of complex SQL Queries pertaining to various stored procedures, Triggers etc.
• Extensive use of Enterprise Manager Tuning & Diagnostic Packs, Explain Plan, Sql Trace/TKprof was made to achieve this scalable.
• Created scripts and Database deployment Instructions for migration of DB Objects and Data Fixes to facilitate the Production Migration.
• Resolved performance issues with poorly performing queries and Locks. Used few tools such as Sql Tracing, and Stats pack as part of the troubleshooting.
• Oracle Applications Systems Administration. RMAN used in recovery, hot and cold backup of Oracle10G database.
• Registered customized applications, Apps. Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Installed Vertex and Quantum

Environment: Solaris/HP UNIX/AIX, Oracle 10.2.0.4/11.2.0.4, Toad, Stats pack, ERWIN, ADDM, AWR, ASM and VERITAS, OEM

Confidential, NJ

Sr.Oracle DBA

Roles/Responsibilities:

• 24x7 Production support of Oracle Applications Administration
• Performed day-to-day DBA jobs for managing 15+ Prod/Dev databases.
• Provide database administration on production, testing and development database servers.
• Estimate Storage requirement, Creation of Table spaces and other Database Primary Objects.
• Planning backup strategy and recovery procedures are sufficiently automated and documented.
• Upgrade of Oracle 11.1.0.2 Databases to 11.2.0.3.
• Optimize creating indexes and views database performance by analyzing objects, generating statistics
• Standardizing Instance configuration of various Oracle 11g databases.
• Resolved production performance issues with poorly performing queries using tools such as Sql Tracing and Stats pack.
• Involved in Partitioning of very large tables using list and range partitioning.
• Implementation and Maintenance of Database Security. Major point of contact of database Users as and when required and administers their respective quotas. Create and Maintain Roles and assign necessary privileges to users according to business rules.
• Perform tuning of databases based on analysis of utilities such as TKPROF, EXPLAIN PLAN, etc.
• Clone/Refresh of Production databases to Testing and training environments.
• Develop/customize shell scripts and Perl Scripts to automate routine DBA tasks of taking backups, exports/import, data pump and monitoring space availability and database performance database. Developed Standards for the developers.
• Creation of database objects like tables, indexes, stored procedures, snapshots and views etc.
• Creation of users and roles and maintaining system security.
• Monitor and Tuning of Database Performance by using various optimization techniques.
• Interacted with Oracle Support for resolving various critical database issues
• Employed various Oracle 10g Features/tools such as Automatic Database Diagnostics Monitor (ADDM), Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASS).
• Monitored All Servers using Oracle Enterprise Manager 10g Grid controls.

Environment: Linux/Windows/HP Unix, Oracle 10.2.0.4/11.2.0.4, Toad, Stats pack, SQL Tracing, TKprof, Oracle Enterprise Manager, AWR, ADDM and J2EE application.

Confidential, NY

LeadOracle DBA

Roles/Responsibilities:

• Upgrading oracle database from 9.2.0.7 to 11.1.0.7
• Migrating database from HP-UX to Linux
• Supporting Testing, Development and Production environments on more than 30 UNIX servers.
• Troubleshooting Database issues for other vendors and users.
• Automation of monitoring, backups jobs.
• Configured Multi-Threaded Server (MTS) architecture for optimum usage of system resources.
• Implemented multiple ARCHIVELOG destinations to archive redo logs to the development server to support immediate database recovery.
• Trained developers to optimize PL/SQL Procedures and SQL queries.
• Performed extensive database, application tuning for both production and QA databases to achieve high performance and scalability and was able to reduce sync up time from 10 hours to 2 hours.
• Setup automated collection of performance data using Oracle Stats pack utility and tuned Instance, application Sql, Indexes and tables to reduce contention on resources.
• Extensive use of Enterprise Manager Tuning & Diagnostic Packs, Explain Plan, Sql Trace/Tkprof was made to achieve this scalable.

Environment: Solaris/AIX, Oracle 8i/9i/10.2, Stats pack, SQL Tracing, TKprof, OEM and J2EE

Confidential, Bothell, WA

Sr. Oracle DBA

Roles/Responsibilities:

• Maintaining production, development &test databases and applications
• 24x7 Production Oracle Applications Administration
• Upgraded Oracle Database Version 9.2.0.8 to 10g (10.2.0.3) on Linux
• Migrated Oracle Database to Oracle Database Gateway for Teradata to have full business enterprise features
• Upgraded Oracle Applications 11.5.10.2 to 12.0.6 and Database 9.2.0.8 to 10g
• Upgraded database from Oracle 9i to Oracle 10g RAC on Windows
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC
• Created test environment through cloning production environment for developers to test on live data
• Setup and implementation of Oracle Financial Analyzer
• Generated reports and financial consolidations with Oracle Hyperion Financial Management
• Installed other supporting products for financial module like Oracle Essbase for modeling complex business scenarios and DRM/MDM
• Involved in developing a disaster recovery (DR) plan
• Perform SQL tuning and assist developers with coding PL/SQL
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK
• Reviewed the procedures and methods used to manage the staging and production data feeds all via materialized views (replication)
• Automation of tasks like backup/refresh and other jobs using
• Configuration of Workflow Notification Mailer, OAM, OEM10g
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack)
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP
• Worked closely with users group to ensure timely implementation of an ERP
• Oracle DataGuard Implementation for HA and remote DR site
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases
• Performance tuning of Oracle Database, applications and queries

Environment: Linux OEL4, Linux, Oracle 9.2.0.8/10.2.0.3, Toad, Stats pack

Confidential

Oracle DBA

Roles/Responsibilities:

• Supporting Testing, Development and Production environments on more than 30 UNIX servers.
• Troubleshooting Database issues for other vendors and users.
• Automation of monitoring, backups jobs.
• Password owner for all environments.
• Backup Strategies on Production databases.
• Configured Multi-Threaded Server (MTS) architecture for optimum usage of system resources.
• Implemented multiple ARCHIVELOG destinations to archive redo logs to the development server to support immediate database recovery.
• Trained developers to optimize PL/SQL Procedures and SQL queries.
• Documenting all the processes followed in the production DB work.
• Designed structure to keep all the logical backups of important schemas.
• As an Infra Team Member got Recognitions in Team meetings for the work in the project.
• Appreciations for quick problem solving.
• Trouble shooting technical problems remotely at Customer Sites.

Environment: Linux/Windows, Oracle 8.1/9.2,Oracle Enterprise Manager (OEM), Dot Net, SQL Tracing and TKprof