SUMMARY

• Oracle Certified Professional with 10 years of Oracle DBA experience and 1+ year as Mysql and 6 months of postgres DBA.
• Experience in Installing, Creating, Upgrading and maintaining Oracle Database 11g & 10g Software.
• Experience in Oracle’s Real Application Clusters (RAC).
• Experience working with ASM, SCAN - IP, VIP, CRS, OCR, Voting Disk, DNS Server etc.
• Experience Working with Regular Cloning & RMAN Cloning.
• Proficient in working with Data Guard for production system in case of disaster recovery, maintained primary and standby databases, Data Guard Broker.
• Experience in working on RMAN backups (Full, Incremental, Cumulative and SCN) and also on cold backups.
• Skilled in performing Logical backup using Traditional export/import and Data pump export/import.
• Experienced in Space Management, Resource management and Capacity Planning.
• Experienced in applying patches including Patchsets and CPU/PSU,One-Off patches on Standalone, RAC and Standby Databases using Universal Installer and OPatch Utility.
• Worked on Oracle GRID Control and Oracle Enterprise Manager
• Exposure to several industry sectors - Banking, Airlines, Insurance,, Health,Manufacturing, Food industry
• Refreshing the Production over the Dev, UAT and keeping the Test Instances in sync with other Instances
• Worked on many day to day activities like creating tablespaces, adding datafiles, resizing, creating users, granting privileges, resetting password etc.
• Experience in Mysql database creation non-GTID and upgrade from 5.5 to 5.6 version
• Good experience in Creation and Maintenance of Database Objects like Packages, Stored Procedures, Functions, Triggers, Database Link, Snapshot, Roles, Privileges, Tables, Constraints,Views and Indexes.Monitoring and managinglocal table partitioning.
• Proven ability to prioritize and complete multiple tasks within stipulated time.
• Excellent team player, a quick learner and exhibits proficiency quickly.
• Strong analytical, communication and leadership skills.
• Good pressure handling capability along with problem solving ability.
• Good interpersonal skills with an ability to work well with others in teams and collaborative work situations.
• Ability to accept change and adapt to organizational change and shifting priorities.
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import).
• Worked on many Database troubleshooting issues.
• Worked on many day to day activities like creating tablespaces, adding datafiles, resizing, creating users, granting privileges, resetting password etc.
• Worked with different teams like Network Team, Application team, SA Team, Development team etc.
• Trained in Hadoop Administration

TECHNICAL SKILLS

Operating Systems: AIX, Windows,Linux,HP-UX,Solaris

Database: Oracle 10g/11g,ODA 11g,12c in ODA, Mysql 5.6,postgresql

Oracle Tools: Expdp/impdp Veritas NetBackup on linux, DBverify, Oracle Enterprise Manager grid control,DBCA,Oracle streams

Tools: Vantive, BMC Remedy 7.1, Maestro,Tivoli(TSM),Service Center,SM9 Ticketing tool,Data Protector,Putty,Winscp,ftp,sftp,BMC

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Configured and installed standalone DR servers on ASM
• Responsible for Oracle Database Administration to provide application operation support services.
• Applied PSU Patches on 11g Oracle databases
• Hands on experience in creating physical standby databases, and involved in converting physical to snapshot standby, and also Active Data-guard.
• Monitored the Applications and database using OEM
• Reorganization of tables, indexes for defragmentation of tablespaces using shrink and export import methods
• Creation of database maintenance plans, rebuild indexes and integrity checks.
• Migration to 12c database from 11g
• Implemented RMAN Backups, Creation of catalog database.
• Responsible for migration of data and implementing structural changes from development servers to production servers using Export, Import
• Diagnose and troubleshoot Database problems and failures.
• Performed planned switchover and failover to physical standby database
• Configured Data guard-broker and involved in registering of databases in Data guard broker using utility DGMGRL.
• Manage Oracle RAC database configurations utilizing Veritas Cluster Server (VCS), and Data Guard to ensure maximum availability and data protection.
• Performed database refresh from Prod to Dev.
• Modify database structures as required by developers due to business or application requirements, clone development databases for testing and training
• Upgraded 11g Oracle Databases.
• Worked on Migrating database on cross platforms.
• Moved objects from one Tablespace to another Tablespace.
• Worked on troubleshooting many Primary & Standby Databases during larger sync gaps
• Troubleshooting RMAN whenever backup is failed and resolved issues.
• Configured RMAN retention policy, archive log deletion policy for Production databases.
• Worked on activating standby databases to make it primary
• Generated Explain Plan & AWR Reports.
• Dropped and recreated Redo log groups and Members.
• Experience in implementing and maintaining database security.

Environment: Oracle 11g,12c RMAN,OEM, Shell Scripting,Remedy,Linux, 11g Grid Control,Veritas net backup,Tivoli backup,Data pump,DBCA

Confidential

Oracle DBA

Responsibilities:

• Installation, Configuration and maintenance of Oracle11g database on UNIX.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• DBA activities including creation, management, startup and shutdown of Oracle databases, management of data files, redo log files, control files, tablespaces, segments, extents and data blocks & physical storage.
• Worked on creating, monitoring and management of database users, granting/revoking of system/object privileges, management of roles & resources and setting of init.ora parameters.
• Prepared the MOP’s (Method of Procedure) for renaming the Database, Creating and upgrading the DB
• Responsible for working on LUN's, SRVCTL, OCR and Voting Disk of 10g/11g RAC.
• Setup and configure Standby database (Physical & Logical) for high availability.
• Created Different Disk Groups for ASM (Automatic Storage Management).
• Created Database links.
• Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
• Providing Remote Support for the Production Databases
• Performed database Cloning to setup test and development database
• Created standby databases local and remote for many databases.
• Automation of Startup Shutdown on all Production and Development Database
• Worked on Capacity Planning, Space Management, Security Management, Auditing, Shell scripting
• Detect corrupted blocks by using DBVERIFY utility.

Environment: Oracle 11g RMAN,OEM, Linux,Remedy,Winscp,Citrix, Veritas net backup,Tivoli backup,Vantive,Remedy

Confidential

Oracle DBA

Responsibilities:

• Responsible for Oracle Database Administration to provide application operation support services.
• Monitored the production/non-production mysql alert logs for database errors
• Migration of Mysql databases using mysql dump
• Rebuilding mysql slave server with non-GTID
• Resolving the issues/alerts received for Mysql databases
• Actively working with other teams for Server Consolidation & Database Consolidation
• Daily tasks includes resolving the incident tickets received from the Monitoring team using remedy and Vantive Tools
• Completion of Service Requests and security forms received from clients on regular basis for database activities
• Refreshed couchbase database on windows using GUI
• Maintained RMAN catalog server and registered databases in catalog server.
• Monitoring daily data refresh of reporting databases.
• Assisted developers in getting database connection from the client using SQL *net.

Environment: Oracle 11g RMAN,OEM, Linux,Remedy,Vantive,Sun Solaris,Couch base,Mysql,Exadata

Confidential

Oracle DBA

Responsibilities:

• Supported 100+ databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
• Creation of databases on ODA servers.
• Involved in RAC ONE NODE Database creation
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database.
• Migration to 12c database from 11g
• Converting single instance database to Real Application Cluster (RAC).
• Database creation & planning. Managing the physical design of the database.
• Monitored and involved in trouble shooting the golden gate process during the on-call periods
• Created, Configured and Set up RMAN Catalog databases and registered target databases with the Catalog.
• Plan, coordinate, and implement network security measures.
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes
• Managed GUI based Postgresql databases on Vmware
• Database migration from 10g to 11g on different platforms on 12c ODA servers
• Monitoring the databases and servers are done using grid control and Service center tools
• Allocating system storage and planning future storage requirements for the database system.
• Resolving the issues/alerts received during on-call periods
• Participated in development of enterprise-wide security standard methodology, and ongoing deployment.
• Performing daily Health Check of the databases assigned as primary DBA
• Actively working with other teams for Server Consolidation & Database Consolidation
• Daily tasks include resolving the incident tickets received from the Monitoring team using DWNG tool
• Develop upgrade roadmap and perform upgrade of Database from 10g to 11g.
• Database tuning at the instance level using AWR,ADDM reports and OEM.
• 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
• Worked on Capacity Planning, Space Management, Security Management, Auditing, Shell scripting
• Involved in importing the production data to lower environments for testing purpose.

Environment: Oracle 10g,11g RMAN,OEM, ODA,RMAN,Linux,Remedy,Service center,Sun Solaris,Golden gate, postgresql

Confidential

Oracle DBA

Responsibilities:

• Database creation & planning. Managing the physical design of the database.
• Allocating system storage and planning future storage requirements for the database system.
• Installing Oracle 11g, grid agent on various platforms.
• Upgrading the databases, catalog from 10g to 11g
• Applying Oracle Patches using OPATCH on RAC database
• Provided support in managing Oracle streams databases
• Database refresh using RMAN,duplicate,logical backups.
• DR test using SQL,DGMGRL and flashback method
• Schema and table refresh using datapump
• Databases Backup and Recovery using RMAN and Data Protector backups
• Using the flashback feature to roll back the database at particular time as per requirement
• Monitoring the databases and servers are done using grid control and Service Manager(SM9).
• Restored & Recovered datafiles from standby to primary using service
• Recovered standby database using service from RMAN
• Exported, Imported Schemas and Tables, Remapped Schemas and Tablespaces.
• Imported Schemas & Tables using network link.
• Worked on Flashback Tables & Databases.
• Worked on block corruption and fixed the corrupted blocks.

Environment: Oracle 10g,11g RMAN,OEM, ODA,RMAN,Linux,Remedy,Service center,SM9,HP backup tool,Sun Solaris

Confidential

Oracle DBA

Responsibilities:

• Maintaining more than 300 Prod/QA/Dev/LAB databases in 24X7 Environment.
• Database and server monitoring using grid control and BMC Patrol.
• Database creation & planning. Managing the physical design of the database.
• Allocating system storage and planning future storage requirements for the database system.
• Reorganization of tables, indexes for defragmentation of tablespaces
• Installing Oracle 10g, grid agent on various platforms.
• Upgrading the databases from 9i to 10g in standby environment. Catalog upgrade.
• Applying Oracle Patches using OPATCH. i.e. Bug Fixes, CPU and PSU Patches.
• Managing the High availability for the databases using HACMP.
• Creation of Physical standby databases for high availability
• Monitoring log apply services & log transport services.
• Configuring dataguard for standby databases
• Backup and Recovery of the databases using RMAN and TSM backups
• Implementing and managing Table Partitioning for Performance enhancements.
• Documentation of performed tasks for future reference.
• Performing daily Health Check of all the databases
• Monitoring and Troubleshooting of Database Replication issues
• Daily tasks includes resolving the incident tickets received using Remedy
• Completion of Service Requests received from clients on regular basis for database activities includes which refresh of data, Data changes in database, database creations, RMAN backups failures
• Worked with third party Maestro for any database related jobs failures
• DR Exercise: Perform planned switchover and failover to physical standby database with and without Data Guard Broker

Environment: Oracle 10g,11g, RMAN,OEM, ODA,RMAN,Linux,Remedy,Service center,HP backup tool,AIX,Maestro backup tool,, Citrix,Winscp, Veritas net backup,Tivoli backup

Confidential

Oracle DBA Trainer

Responsibilities:

• Monitoring database and system health and performance.
• Monitoring alert log and trace files.
• Managing controls files and redo log multiplexing.
• Responsible for Oracle Database Administration to provide application operation support services.
• Documentation of performed tasks for future reference.
• Provided support to client by traveling to client sites, and rectifying the problems raised for current and prospective customers.
• Creation of user, roles and assigning privileges
• Documentation of performed tasks for future reference.
• Prepared daily, weekly and monthly reports for clients

Environment: Oracle 10g,11g RMAN,OEM,RMAN,Linux,Remedy,TOAD,Windows