SUMMARY

• Oracle DBA with strong experience of over 6 years in heterogeneous environments including UNIX/LINUX, WNDOWS, AIX, Sun Solaris HP - UX, AIX, Red Hat, operating systems.
• Monitored and managed various databases (10g.R1, 11g.R1 &R2 and 12c) SQL Servers, My SQL Net Server and their components on an agile FDLC. As well as AWR
• Expertise in installation, configuration creating databases using DBCA and scripts, as well as upgrading the database using DBUA, Data pump and upgrade scripts and applying patches (CPU/PSU) on oracle database.
• Expertise in life cycle (SDLC) knowledge including production support, upgrades, performance tuning, cloning, space management, security patches, migration, backup and recovery, Data Guard, Golden Gate, and RAC (2 node).
• Participated in the planning and implementation of off-site Disaster-Recovery planning and testing and configuration of physical and logical Standby Database (Data Guard) and tested for business continuity/Disaster recovery plan
• Experience in Performance Tuning using ASH, ADDM, AWR, Explain Plan, STATSPACK, TKPROF and SQL Tuning Advisor, SQL TRACE.
• Implemented Flashback technology and its various features in Oracle 10g.R1/11g.R1&2.
• Performed Backup &Recovery for databases, Schemas & objects as well as recovering critical and Non-critical files using RMAN, User-Managed backups & Data pump.
• Experience as On-Call 24x7 production DBA support, application/development DBA.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g 11g and 12c r2, with experience in very large-scale database environment and mission critical large OLTP and OLAP systems.
• Hands on experience in Oracle 10g/11g 12c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).
• Good experience RAC Clusterware administration, Configuration and Patching.
• Extensive experience in Data guard configuration and implementing; Golden Gate as well as maintaining standby databases.
• Hands on experience in Grid control, Streams, Golden Gate Replication.
• Setup Oracle Enterprise Manager (OEM) and Grid Control for 10g, 11g and 12c for database monitoring/performance/diagnostics.
• Extensive experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Table spaces.
• Good experience in writing/editing UNIX Shell Scripts as well as Patching and upgrading
• Expertise in upgrading Oracle Development and Production databases from 8i to 9i, 9i to 10g & 11g, 10g to 11g, 11g to 12c
• Know legible in managing very large Data Warehouse databases.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB.
• Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.
• Experience in Capacity Planning and Bench Marking.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.
• Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams.
• Implemented and configured of Oracle Enterprise manager (OEM) Grid Control 12C and Oracle Management Server for maintenance and monitoring of production databases, multiple databases and application servers.
• Extensively managed Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisor, SQL tuning and Metrics, using Grid Control of Oracle Enterprise Manager (OEM) 12C.
• Strong Exposure in creation on an Oracle 12c Multi-tenant RAC data base with 2 node cluster and instances using ASM storage.
• Extensively used Oracle Enterprise Manager (OEM), TOAD, SQL*DEVELOPER, SQL*PLUS and command-line for maintaining and monitoring databases, as well as setting up security profiles for users connecting to the database. I have also created and managed users, roles and granted privileges to different user profiles as needed.
• Extensive experience in performance monitoring and tuning of database, instances, SGA, I/O, and Rollback segment, using different methods and detecting locks.
• Implemented security measures on databases by configuring transparent database encryption (TDE), network encryption, strong authentication using Oracle password verification function and implementation of views/ materialized views.
• Proactive, goal oriented DBA with good communication /presentation skills, a devoted attention to detail team player who takes pride delivering projects in a timely fashion.
• Fast learner and work well under supervision as well as independently and stops at nothing until goals are met. Ability to adapt to new skills & technologies and dedicated to maintaining high standards. I am open and flexible to providing on-call and after hours support, including overnight and over the weekends.

TECHNICAL SKILLS

RDBMS: Oracle 12c, Oracle 11g RAC, Oracle 10g RAC, oracle 9i, oracle 8i, Oracle 7.3, SQL Server, MySQL.

Operating Systems: Solaris 9/10, Linux RHAT 4/5,6, HP-UX 10.x/11.x, AIX 5.2/5.3, Microsoft Windows NT, 2000/2003/2005. High Availability, Tuning& Monitoring Products Oracle 12c RAC, Oracle 10g RAC, Oracle 11g RAC,

Tools & Utilities: ASM, Data Guard, Grid Control (OEM), Tkprof, Statspack, AWR, ADDM, ASSM, TOAD, RMAN, Export/Import, Data Pump (expdp/impdp), SQL Loader, EXPLAIN PLAN, Putty, Win-scp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

ETL & Reporting Tools: Informatica, Power Center 8.5/8.0,Data Stage6.0,1.0, Business Objects Xi R26.1, Oracle Data Integrator, SASBackup Tools: Veritas Netback up, NetApp, HP Omni Back, TSM,EMC

PROFESSIONAL EXPERIENCE

Oracle database administrator

Confidential

Responsibilities:

• 24x7 Production database and applications support as well AWR cloud service.
• Installed, configured, and maintained Oracle 10g,11gR2 and 12C R2
• Upgraded databases from Oracle 9i, 10g, 11g and 12C R2
• Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle Data Guard) for High Availability and Disaster Recovery purpose.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Created databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance; and applied patches.
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Performed block recovery using RMAN and Moved data between databases using Data Pump.
• Performed large batch jobs, tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Partitioned large tables for better performance and manageability.
• Installed and configured Golden Gate for replication.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Migrated databases from Sun Solaris, HP-UX to IBM AIX, and Windows to Linux.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Worked with Data Pump to take the logical backups of databases.
• Experienced in performing Point-in-Time Recovery.
• Performed Capacity Planning and Bench Marking
• Load and Transform data using SQL*Loader and External Tables
• Logical and Physical Database Design
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.

Oracle database administrator

Confidential

Responsibilities:

• Successfully installed and configured Oracle 11g and 12c databases on Linux, windows and AIX OS platforms.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Implemented oracle 12c active standby database for test database environment.
• Utilized rman recover table functionality and created proof of concepts for our pre-prod environment.
• Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.
• Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
• Documented all Oracle 12c installation/Up gradation work and delivered KT to all team peers.
• Worked with projects/operations/professional services team and co-ordinate multiple tasks at hand with expertise and solid plan.
• Administer User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Import/export utilities for cloning/migration of small sized databases and Data pump
• Import/export to move data between 11g and 12c database environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Implemented Flashback technology of the Oracle 11g and 12c along with Recycle in for a faster recovery of the databases and database objects.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Performed Database upgrade from Oracle 10g (10.2.0.5) to Oracle 11g (11.2.0.4) and also, upgraded from Oracle 11g (11.2.0.4) to 12c for Standalone and RAC database .
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Involved in the installation, configuration and extended support to Oracle 11g and 12c two Node RAC (Real Application Cluster) with ASM file system on RHEL Linux platform.
• Installed and configured ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD and OEM for database management and monitoring
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.

Environment : Oracle 12c R2 11g RAC/10g RAC, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, ASM,OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader, Golden Gate, IBM AIX V6.1, RHEL 6.7, SQL* Plus, TOAD 10.0.

Oracle database administrator

Confidential

Responsibilities:

• Installation, configuration, and upgrades of Oracle databases 10g, 11g and 12c RDBMS software.
• Experience in upgrading databases and applied PSU to multiple databases.
• Monitored health of database by keep an eye on all Alert log and trace files and if any error comes find out the root cause & analysis for resolution.
• Regular maintenance activities like cloning, patching and custom code migration provide by developer and working with their issues.
• Successfully implemented Backup & Recovery using RMAN, which includes hot backups and Cold backups.
• Proficiency in backup and recovery procedures including RMAN techniques.
• Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Implemented and managed optimum physical database design (table space, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.
• Monitored Day-Day Backups, Log's & recovering them as per the requirement.
• Gathered, analyzed, and normalized relevant information related to, and from business processes.
• Identified poor SQL and pass to development teams for review.
• Involved in designing and implementing Oracle backup and recovery methods and disaster recovery methods using RMAN.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Performed Database Refresh in RAC Environment using transportable table spaces, expdp, and impdp on Solaris, Red Hat Linux and UNIX Platforms.
• Successfully Implemented key RMAN 11g and 12c new features such as block change tracking, use of flashback recovery area and taking incrementally updated backup to meet backup and recovery goals.
• Experience on Performance tuning tools like AWR, ADDM, ASH, Stats packs, TKPROF, Explain Plan.
• Generated DDL statements for creation of new database objects like tables, views, sequences, synonyms, indexes and created triggers, packages, procedures, functions and granted privileges.
• Implemented and monitored all databases using Oracle Enterprise Manager (OEM) for maximum uptime and optimal performance.
• Supporting multiple databases for production, development, and test staging purposes on RHEL Linux environments.
• Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.
• Configured and administered unidirectional replication on Oracle Golden Database.
• C reated database objects in operational data store and maintaining them in Golden Gate.
• Implemented initial Data Load, Batch/Online replication, and Security in Golden Gate.
• Capacity planning: Allocate system storage and plan future storage requirements.
• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC.
• Physical and Logical Standby database for Test, Development and Production for various custom applications like Portfolio Management Systems and vendor applications like SAP Business solutions
• Involved in 24x7 on-call support for two Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
• Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT, and Granting required privileges to users.
• Applying upgrade patch, maintenance and interim patches on all the databases using opatch, migration of Databases from 11.2.0.4 to 12.1
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g on Linux platform using ASM.
• Efficiently performed installation, setup and creation of two node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Developed compliance reports and performed auditing at higher levels.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab .
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases
• Performing monthly and annual performance reports for trend analysis and capacity planning.
• Assist in SQL tuning and providing consultation such as creating materialized views, adding indexes, dropping unnecessary indexes, using hints wherever possible, amongst others.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Experience with service now and remedy ticketing systems.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments and Oracle OLTP .
• Experience with PeopleSoft, OEB Application server.
• Exposure to MySQL database, SQL Server 2012 11.0

Environment: Oracle 12 C 10.2.0.4, 11gR1, OEL 6.3, HP-Unix, Windows server 2008R2, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, RMAN, Data Pump, TOAD.