SUMMARY:

• Over 9+ years experience as a Oracle DBA, performing Test, QA, Production implementations and providing 24/7 production support.
• Oracle DBA expert, with primary expertise in Installing, upgrading, and configuration of Oracle databases from Oracle 7/8/8i to Oracle 9i/10g/11g RAC,/12c on HP, Linux and Windows Environment.
• Excel in Oracle performance management, using DBMS STATS, Optimizer Hints, Explain Plan, Estimate, and Compute Statistics for troubleshooting performance bottlenecks.
• Proficient in all DBA responsibilities such as user management (synonyms/privileges, roles, quotas, table, index, sequence), space management (tablespaces, rollback segment, monitoring, alert log, memory, disk I/O, CPU, network activity), performance tuning (TKPROF, STATSPACK), capacity planning, patching, and planning/implementation of enterprise backup and recovery strategies using RMAN.
• Wrote Shell Scripts for Backup and Recovery.
• Adept in OEM grid control 10g, SQL*plus, Export, Import and SQL*Loader and UNIX cpio, dd, tar and vol - copy.
• Experience at loading data from FLAT files and other databases, and phased tuning of databases to include design, application, shared pool, SGA, I/O, sort, undo, locks, shared server, SQL, and OS.
• Programming experience in creating Procedures, Packages, Functions and Triggers.
• Transaction optimization in high-rate OLTP instances by monitoring I/O bottle-necks related to object pinning, SGA allocation, shared pool, I/O, locks, sort space, redo log buffer etc.
• Databases Tuning with all initialization Parameters, and Initial Storage Parameters to tune the Database for optimal performance.
• Oracle database Performance tuning, formulating optimization strategies based on performance, cost and/or rules using TRACE, EXPLAIN, TKPROF, UTLBSTAT, UTLESTAT and STATSPACK.
• Database corruption (checks database status, and periodically verifies database integrity).
• Troubleshooting Database internal errors with Oracle-Support. Resolving Data-Corruption Issues.
• Implemented Oracle Auditing.
• Installing and Configuring Oracle-Enterprise Manager (OEM) for monitoring database proactively.
• Involved in Database Design and Modeling (Physical and Logical). Created many ER diagrams using Erwin.
• Versatile team player with excellent analytical, communication and inter personal skills.

TECHNICAL SKILLS:

Operating Systems: Linux AS 2.1/AS4.0, AIX 4.3, HP-UX 11i, Windows 2000/XP.

RDBMS: ORACLE 7/8/8i/9i/10g, 11g, RAC and 12c.

Maximum Architecture: 11g/10g RAC, Data guard

ERP Systems: Oracle E-business Suite 11i (11.5.5/8/9)

GUIs: VB scripts and Developer 2000 (Forms4.5/6i, Reports 2.0 / 6i)

GG: Oracle Golden Gate

Programming Languages: SQL, PL/SQL, HTML, C, Java, Shell Programming, SQL Loader

Tools: OEM, TOAD, RMAN, Export, Import, Datapump, Tkprof, STATSPACK, AWR, ADDM, TOAD7.6, DBVerify, Discoverer, Veritas,Developer2000, Visual Studio, JDBC, ERWIN 4.x, Grid Control(10g)

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ORACLE DBA

Responsibilities:

• Installing, configuring, and creating container database and pluggable database as part of Multi-tenant Oracle 12C database.
• Proactive Maintenance; Performance Management; Performing Backup via Rman/ddboost in nonpord; Performing Flashback; Flashback Database; Using Recovery Manager; Recovering from Critical Losses including recovering from loss of all control files; Monitoring and Managing Storage.
• Performing tablespace reorg in prod and nonprod.

Sr. ORACLE DBA

Responsibilities:

• Installing, configuring, and creating container database and pluggable database as part of Multi-tenant Oracle 12C database.
• Administering Oracle 12C database security.
• Utilizing Oracle 12C cloud control and enterprise express.
• Arranging Oracle 11G scheduling.
• Performing Oracle 11G performance tuning.
• Working with Oracle 11G advisory framework and Oracle 12C RMAN.
• Responsible for and maintaining enterprise wide production databases including: installation, configuration and upgrading of Oracle server software and related products. Implemented, maintain and ongoing monitoring backup and recovery system including policies and procedures along with periodical crash simulation testing.
• Moving Data via different methods; Configuring Recovery Manager; Performing Database Recovery; Recovering from User Errors; Dealing with Database Corruption;
• Monitoring database performance. Troubleshooting, identifying and tuning application code identifying performance issues, discuss such issues with developers and help tuning the code.
• Proactive Maintenance; Performance Management; Performing Backup; Performing Flashback; Flashback Database; Using Recovery Manager; Recovering from Critical Losses including recovering from loss of all control files; Monitoring and Managing Storage.
• Supported development team in tuning codes for better performance.
• Environment: PL/SQL, SQL, Oracle 11g, Oracle 12c, Linux/UNIX, RMAN, Data guard, Oracle (11g/12c), Oracle Diagnostic Tools RAC administration
• Installed, configured and implemented GoldenGate on UAT, QA and Prod
• Installed, configured and implemented GoldenGate on UAT, QA and Prod
• Implemented unidirectional and bindirectional replication using GoldenGate between Oracle databases, MS SQL Database and Oracle databases.
• Configured Replicat, Extract, data pump and Manager processes to manage replication using GoldenGate tool.
• Wrote Monitoring Scripts to manage Replicat, Extract, Manager and data pump processes.
• Performed troubleshooting to resolve Process Abends due to replication errors.
• Managed large Databases replications using GoldenGate Extract, Manager and Replicat processes.
• Installation, Configuration and Maintenance of oracle 12c/11g/10g/9i databases on AIX/oracle enterprise Linux servers.
• Installation and configuration of Grid Infrastructure 11gR2 RAC 3 nodes & Non-RAC
• Working with Application Development and testing teams for new project builds and troubleshooting the performance issues for SQL.
• Installation and configuration of Golden gate 11g to maintain the schema level replication and High Availability of database.
• Configuration and maintenance of active standby database 11gR2.
• Configuring RMAN backups in Tivoli Workload scheduler and CRON Jobs.
• Extensively worked on Database clone/refresh using RMAN, data pump, export and import manager utilities.
• Troubleshooting the database performance issues by analyzing Automated Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostics Monitor (ADDM) reports.
• Working in collaboration with Oracle labs, the UC4 Workload Automation Suite has been deeply integrated into the Oracle application portfolio.

Confidential

ORACLE DBA

Environment: Linux AS 4.0, Windows 2000, Oracle (9i/10g), 10g RAC, 10g OEM, TOAD 7.5, Putty, Erwin 4.5, SQL*Loader, TKPROF, EMC SRDF.

Responsibilities:

• Creation of the Development, Test and Production Oracle 9i, 10g, 11g databases.
• Installation and configuration of Oracle Databases 9i to 10g rel 2 & 10g to 11g
• Involved with designing 4 node RAC for high availability, scalability and improve performance.
• Converted single node database instance to 4 node 10g RAC instance using ASM, OCFS2 and cluster ware technology.
• Setting up Oracle read only replication with materialized views and developed scripts for automating the rebuilt process of replication.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.
• Wrote UNIX shell scripts for automation of different administrative activities and notifications, which will continuous, monitor the database and send warning, error massages to DBAs via email and pager.
• Cloning of production database to the test environment using Recovery Manager (RMAN), Datapump with oracle streams technology.
• Worked on setting up, testing of BCV (Business Continuity Volume) and to automate the process.
• Worked extensively on 10G grid control especially monitoring the database, configuration of different notifications, installing and configuring agent, listener, databases and adding them to the grid control.
• Worked on setting up of Oracle dataguard and EMC SRDF for the production database.
• Worked with backup team and was responsible for configuration and implementation of backup strategies using RMAN.
• Managing Application user profiles and managing concurrent managers, concurrent processing, load balancing etc.
• Implemented oracle auditing.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security). Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Analyzing table, SQL query and rebuilding indexes to improve query performance.
• Fine tune SQL queries using Explain Plan, Tkprof and Statspack.
• Setting up new environments (Development, Production etc). Database Sizing, Tablespace Management .
• Deciding the naming conventions of datafile, redo log files, table spaces, and segments.
• Export and Import of database objects to copy from one database to another database with use of datapump in 10g and convention oracle export, import for 9i database.
• Keeping database up-to-date by applying patches and worked with oracle support on different database issues.
• Documentation of Data Base Setup, replication setup, important scripts and administration of Server Environment.
• Supported release 2 (phase 1) cutover activity and stabilization of the environment after it went live.
• Provided on call support 24x7.
• Extensive experience in designing the Data models for OLTP & OLAP database system.
• Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like Erwin, EMBARCADERO ERStudio.

Oracle DBA

Environment: Oracle 9i/10g, 9i RAC, Sun Solaris 8, Import/Export, Datapump,TOAD, Veritas, OEM, RMAN, ERWIN, SQL, PL/SQL, TKPROF, RMAN.

Responsibilities:

• Involved in Installation of Solaris 2.6 & maintenance of Machines, Workstations and I/O Devices, Upgraded the Software.
• Coordinate, plan and analyze business requirements, procedures and problems to automate or improve existing Database systems and implement new systems.
• Create, upgrade and install Oracle databases using SQL scripts, allocating system storage and planning for future storage requirements for all databases.
• Responsible for installing and converting non-RAC database to two node RAC database using RAW and OCFS technology.
• Accountable for creating primary database storage structures (tablespaces) and modifying database structures according to each application project’s design specifications.
• Responsible for managing user accounts from enrolling users/system security to controlling/monitoring user access.
• Contribute to team efforts in reviewing existing systems, workflow/scheduling limitations, taking corrective measures, and providing expert technical assistance and support.
• Contribute to overall database management in a UNIX/Windows environment including:
• Monitor and optimize database performance, planning and scheduling backups using Crontab jobs, performing scheduled Restoration drills using test database in different scenarios, and maintaining/configuring achieved data on storage devices like Legato Media Manager.
• Spearheaded, designed and continue to execute hot backups using combination of incremental, differential and full backups in RMAN, as well as restore databases using RMAN utilities, Datapump and Veritas Netbackup.
• Clone production database to the test environment using Recovery Manager. (RMAN).
• Create primary storage structure and the objects, and run SQL Tuning scripts to gather performance data on sorts, gets, misses, cache hits, disk I/O activity, disk reads, etc.
• Consistently tune I/O by separating data files, stripping, and remaking log files, tables and indexes at different locations for reduced I/O contentions using Explain Plan, TKPROF, SQL Trace, Analyze, Hints and other tools.
• Troubles shoot and resolve locking, slow response, system crash, and other issues using SQL queries.