SUMMARY

• Hard - working and enthusiastic with extensive Oracle DBA experience including 7 years as an Oracle DBA.
• A highly result oriented Skilled Oracle DBA certified Professional with extensive experience as Oracle DBA (12c, 11G, 10G, 9i, and 8i) on various platforms Windows, UNIX, LINUX, SUN SOLARIS and IBM AIX (Production, Development and Test environment Proficient).
• Experience included providing support to over 100 Development, Test and Production Databases including critical Production Financial Databases comprising of complex and challenging Unix, Linux, Solaris, Windows environment in Oracle versions 10g, 11g and 12c.
• Extensive technical knowledge on Database Migrations, Installation, Upgrade, Reorg, Cloning, Patching, Unix and Shell Scripting, RAC, RMAN, Performance Tuning, Proactive Database monitoring, Performing routine Health Checks, Automating scripts and DBA Tasks, Capacity Planning, Database Backup and Recovery.
• Implemented Oracle11g RAC systems with ASM on Linux servers.
• Specialized in Migration of Oracle databases from Oracle 8i, 9i, 10G to the latest releases - Oracle 10G and 11G.
• Experience in planning & implementation of Backup & Recovery strategy, RMAN. Performance Tuning AWR/ stackpack for as tuning of application, shared pool, buffer cache, I/O distribution, rollback segments, redo mechanisms and SQL code.
• Refreshing test and development databases as needed with production data using Data Pump (expdp, impdp).
• Proficient in ORACLE DBA - Installation of Oracle RAC, ASM and Streams configuration. Designing & Testing of database, administration, backup & recovery strategy implementation according to the volatility of the data, user management, performance monitoring/tuning and database security.
• An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management.

TECHNICAL SKILLS

Operating System: Solaris 10, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, 7, Linux, Windows server 2003

RDBMS: Oracle 8i/9i/10g/11g/12c, SQL Server, Sybase, Teradata

Languages: Oracle SQL, PL/SQL, T-SQL, Bash/Korn Shell scripting, HTML, Perl, C Programming.

Database Tools: Oracle Golden Gate, SQL Developer, SQL Listener, Toad, App Designer, DataMover, SQL*Loader, SQL*Plus, SQL Navigator, BRTOOLS, Grid Control,Goldengatev11.1/11.2RMAN, Export/ Import, Data pump, RM (Replication Manager) - emc2 backup toolAppworx 6, Goldengate Manager, SQL server Enterprise Manager.

Telnet Tools: PuTTy, Secure Shell, MobaXterm

Ticketing Tools: BMC Remedy, Bridge clarify, CMR (Change management request)

Others: NAGIOS, MRTG, SNMP, WinCSP, FileZilla.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Sr. Oracle DBA

Responsibilities:

• Hands on experience on Installation, Upgrade & Patching of Oracle Database and its components.
• Implemented the Upgradation of database from 10g to 11g.
• Database Cloning activities as per client request - Production to Test environment.
• Performed Refresh on Staging and DEV environments from production using conventional export/import and datapump utility.
• Monitor database health, regular backups on daily basis.
• Maintenance and monitoring of Database and Listener.
• Checking Alert log, trace files, and other database job logs.
• Worked independently with oracle support to resolve outstanding issues or bugs under the supervision of the team lead.
• User creation and providing necessary Roles, Privileges and quota as per the requirement.
• Managing table spaces, data files, redo logs files and maintaining Indexes.
• Written the Shell Scripts in coordination with system admin for monitoring the alter logs, disk spaces at O/ S level, table spaces at DB level, to check the availability of database and listeners, and automated jobs through cronjobs.
• Good knowledge on various tools like RMAN, exp/imp, expdp/impdp etc provided by oracle for database backup and recovery. Able to take all forms of physical and logical backups.
• Good knowledge of Oracle backup and recovery scenarios.
• Troubleshooted issues related to locks, session hangs, blocking sessions etc and provide details to the project teams.
• Good understanding on oracle dictionary related views and information available within those views.
• Direct interaction with development team and client partners on daily basis to resolve the issues.
• Working with online (development) team to resolve online issues within SLA.
• Planned, designed and implemented RMAN backup strategy for Oracle 10g on Solaris 10 server

Environment: s: Oracle 10g, 11g, SQL*Plus, SQL,Red Hat Linux/Unix/IBM AIX, Putty, Remedy, Service Catlog, Terminal Service, RAC,RMAN, Oracle Enterprise Manager,Winscp,Toad, Application Designer and Data Mover.

Confidential, Folsom, CA

ORACLE DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition and resolution of database issues. .
• Involved in capacity planning and configured 11gr2 RAC for high Availability.
• Converted single instance database to RAC Databases.
• Configured databases for BI and worked on databases sizes from 2TB to 30TB.
• Applied patches to Oracle Databases using Opatch utility and upgraded databases manually and implemented Up-gradation of databases from 10.2.0.x to 11.2.0.x.
• Involved in migrating HP-Unix databases from 10g/11g to 11gR2 Red hat-Linux.
• Involved in configuration of parameter files for extract process in primary and replica process in standby using Golden Gate.
• Installed Golden Gate for replication of database on 11gR2 RAC environment.
• Configured parameters for the Bi-directional replication using Golden-Gate.
• Extensively used data-pump at schema level for migrating data from Solaris to Linux.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Troubleshooting RMAN whenever backup failed and Configured retention policy, archive log deletion policy for Production databases and registered databases in catalog server.
• Involved in Management of schemas, objects partitioning the tables & indexes.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Perform other regular DBA activities including space management and performance Tuning. Extensive Performance Tuning, Memory (SGA) Tuning.
• Taking periodic Backup of the Database and the software using RMAN and supporting VERITAS Net-backup Team.
• Familiar with ORA-600 error. Involved with this ERROR.
• Involved in Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints

Environment: s: Oracle 10g, 11gR1/R2, HP-Unix 7i, RHEL 5.x, OEL 6.3, OEM 10g/11g, RMAN, RAC, ASM, Data guard, Virtualization Tools, AWR, ADDM, ASH, Data pumps.

Confidential, Indianapolis, IN

Level 2 Oracle Operational DBA

Responsibilities:

• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, Physical and Logical Standby database for Test, Development and Production for various home-developed applications.
• Familiarizing myself with Oracle 12c on a Single Instance and Two nodes RAC Database by performing installation, configuration and monitoring DB activities.
• Develop upgrade roadmap and perform upgrade from 11.2.0.4 to 12.1.
• Installing ASM environment and migrating database from NON-ASM to ASM storage Instance.
• Thorough understanding of architecture and operational mechanism of CRS, GNS, GPNP.
• Configured SCAN as a cluster alias for load balancing and as a client connection failover mechanism.
• Used Oracle Golden Gate for Basic and Advanced Data Replication between Oracle Database Servers and Legacy Databases
• Performed History pull to synch-up data between Oracle to Non-Oracle (Tandem, SQL Server) databases using Golden Gate
• Set up DDL/Bi-directional replication
• Built Oracle MAA Physical Standby and Logical Standby and configure Data Guard Broker for High Availability/Disaster Recovery purpose.
• Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file table spaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL tuning Automation, Flashback Database, compression techniques etc.
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF for optimized results
• Write and automate UNIX shell, SQL scripts, and Grid Control for ease in administrative tasks and monitor databases to optimize performance, resource use, and physical implementations of databases
• Worked on Capacity Planning, Space Management, Security Management, Auditing, Shell scripting, Memory and Tuning.
• Working with Application Development team to address any issues they encounter and provide support and resolution action plan.
• Addressing and supporting both Test and Development tickets in co-ordination with Application Development Team.

Environment: Oracle11g/12c with RAC, Oracle Golden Gate, Oracle Data Guard, HP-UX 11i v3, Sun Solaris 10, RHEL 6.x, TOAD.

Confidential

Oracle Database Admin

Responsibilities:

• Installation and Configuration of Oracle Database (10g) on on Solaris and Windows Platforms.
• Scheduling shell scripts or dbms jobs using Crontab or DBMS SCHEDULER (monitoring script, listener check, backup script) etc.
• Creating and managing of database users, roles, privileges, profiles and database links.
• Creating and managing tables, functions, stores, procedures and optimization.
• Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
• Involved in performance monitoring and tuning of the database.
• Knowledge and good experience with database backup and recovery methods using RMAN, Data Pump.
• Expertise in oracle utilities like Export/import,/expdp/impdp sql loader, RMAN etc
• Daily Health check of the Database. And monitoring the log files, backups, database space usage and the use of system resources.
• Perform general technical trouble shooting and give consultation to Development/Application teams.
• Installed and Configured the Golden Gate software and created manager, extract, replicate trail files.
• Preparing HLD, LLD, User Manual and Reviewing Code
• Worked beyond regular hours based on business demands. Provided 24x7 on-call production supports

Environment: s: Oracle 10g, 11g, SQL*Plus, SQL and PL/SQL programming and development, UNIX Systems (Linux, HP - UNIX), Putty, Terminal Service, RAC, Data Guard, RMAN,VERITAS Net Backup 4.5, OEM, Sun Cluster, Citrix Servers.

Confidential

Database Administration

Responsibilities:

• Reportal administration activity (Schedule job management, provisioning and troubleshooting)
• Requirement analysis, Test requirements gathering and Designing test strategies.
• Involved in Backup activities
• Leading the whole project and managing a team size of 3 people.
• Fine-tuned the processes in all servers
• Functional testing of Reportal front end.
• Presenting to the customer Weekly & Monthly data.
• Analyze and resolve the major live incidents as per agreed SLA.
• Trained colleagues and new bees on Reportal and network related topics
• Work on the Upgrade plans of the application.
• Rising issues when any server or application goes down getting it resolved by continuous interaction with Infrastructure team located in Italy

Environment: s: Unix (sed,awk), Perl, Shell Scripting, SQL, SNMP (Perl Libraries and OS Tools), PHP,RRDTool, SQLite, Nagios (Alarm Dashboard).