PROFESSIONAL SUMMARY:

• 8+ Years of experience as Oracle Database Administrator with good knowledge in 10g/11g and Data guard. Worked on UNIX and Windows based OS and have experience in Installation, Configuring, Fine - tuning, Back-up and Restore procedures and Monitoring Data base. Good communication skills and problem solving abilities in critical situations. Quick learner with ability to adapt to new environment start contributing to the project.
• Experience working on Oracle 10g,11g databases, Good Understanding of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
• Good Knowledge and experience in installation, maintaining and upgrading Oracle 10g, 11g and RAC databases.
• Hands on experience in test, production and development databases.
• Created and managed database security by creating new users, roles, profiles and provide required user privileges in development, test and production environments.
• Experience in perform different methods of backups like Hot, Cold and Logical.
• Experience with logical backups of the database using Data Pump (Expdp and Impdp) .
• Implemented RMAN backup (Full, incremental and cumulative) and recovery strategy using configuration of Recovery catalog for multiple databases.
• Experience in Cloning and refreshing the databases
• Experience in creating SQL script for performing DB recovery.
• Experience in implementing and working with Data guard (physical and Logical Standby) on Linux.
• Experienced in Configuring, Installing and Maintaining Real Application Cluster (RAC) database for high scalability and availability in test and production databases. Successfully implemented Adding/Deleting RAC nodes, TAF and Load Balance.
• Experience in SQL Tuning issues using AWR reports, ADDM reports, ASH reports, Explain Plan, SQL Trace Utility.
• Sound Knowledge in Golden Gate
• Experience in scheduling jobs using crontab to comply with data logging and monitoring specs
• Experience in working on various OLTP and OLAP databases both in clustered and non-clustered environment.
• Provide 24/7 on call support on rotation basis
• Experience in administering, tuning and monitoring database using OEM.

TECHNICAL SKILLS:

Industry Verticals: Finance, Telecommunications, Pharma, Insurance

Operating System: Linux (RHEL5, RHEL 7), Sun Solaris, Windows,

Database: Oracle 9i/10g/11g, MySQL 5.x, MySQL (Cluster), DB2, SQL Server, MongoDB, HBASE.

Oracle DBA: RMAN, Cloning, Refresh, Data Guard, Logical Backup, Physical Backup, OEM, ASM, RAC

Methodologies and Tools: Waterfall, Agile, RAD, Iterative

Language: C, C++, SQL, PL/SQL, Stored Procedures, Object-Oriented Programming

MS Office Tool: MS-Word, MS-Excel, PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential, OH

Oracle DBA

Responsibilities:

• Managed and supported users by creating roles and privileges for database access and data manipulation.
• To Provide core DBA support with daily monitoring and troubleshooting of Oracle 11g databases with Data guard
• Implemented Oracle Database 11g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Implemented advanced feature of Oracle 11g such as Automatic Workload Repository (AWR) for monitoring database performance.
• Convert NON ASM database to ASM Database.
• Setting up of Dev, Test, Preprod and Production Environments.
• Created User accounts, Roles and granting required access permissions and privileges to the database.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Monitoring and supporting day to day activities of the production and development databases
• Configuring Backup (RMAN) for database and restoring database.
• Performed database refreshes and schema refreshes using Data pump (Expdp and Impdp)
• Monitored the databases and added the data files to the tablespaces or resizing the tablespaces and monitored the sessions running on the databases.
• Automated day to day tasks by scheduling jobs using crontab
• Configuring Backup for Applications and restoring Applications Hot and Cold backup.
• Monitoring alert log/system log.
• Worked as a team member to provide 24x7 on-call production database support.
• Large databases (size in TB) and also large number of databases in multi OS environments & OLTP.

Environment: Oracle 11g, Linux, UNIX, RMAN, Data guard, RAC, ASM, Data pump, OEM

Confidential, CA

Oracle DBA

Responsibilities:

• Managing and creating Oracle 10g database
• Managing user Accounts
• Performing Export & Import operations
• Monitoring & Managing the Tablespaces and datafiles growth
• Taking Export dump daily for Backup purpose
• Responsible for taking full cold database backup
• Loading data into database tables using SQL *Loader.
• Regular database management tasks using OEM.
• Performed configuring and scheduling RMAN Backup/Recovery
• Performed Cloning the databases using RMAN
• Supported in Oracle performance Tuning methods
• Involved in upgrading Oracle9i to Oracle10g database
• Administering the 10gR2 RAC database
• Large databases (size in TB) and also large number of databases in multi OS environments
• Performed implementing and working with Data guard (physical standby)
• Scheduling backup of database using crontab jobs.
• Working Knowledge of installation and configuration of Golden Gate in UNIX environment. 
• Involved in Installation and configuration of Golden Gate on 11g database for the replication. 
• Implemented Bi-Directional replication in Golden Gate from target to source and source to target.
• Involved in creating Tables, Indexes, Triggers, Sequences, Procedures and Packages. 
• Created custom PL/SQL procedures to read data from flat files to dump into Oracle database using SQL * Loader.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER.

Environment: Oracle 10g/11g, Exp/Imp, Data guard, OEM, SQL Loader, RMAN, Golden Gate.

Confidential, VA

ORACLE DBA

Responsibilities:

• Resizing the data files and adding data files to tablespaces as per the requirement
• Taking the backup of the database regularly using Logical, Cold and Hot Backups
• Restored databases using RMAN to fix corruption and storage issues.
• Performed Backup and Recovery activities using RMAN
• Maintaining data files, control files, online redo log files and archive log files
• Experience in Partitioning and creating Global, Local Indexes on Partitioned Tables
• Maintaining data files, control files, online redo log files and archive log files
• Administered databases on Linux, Centos and Solaris.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES etc. for easy and effective management of Oracle networking.
• Performed schema refresh using logical backups
• Monitoring Alert logs for any errors, problems or processes running

Environment: Oracle 9i/10g/11g on LINUX, Solaris.

Confidential, NY

Oracle DBA

Responsibilities:

• Design and Create new databases based on requirements of the application / project 
• Responsible for all the database related jobs for all the instances, performance tuning, backup and recovery, managing users & privileges, resource limits. Administration of database objects such as indexes, tables, views, constraints, and stored procedures. 
• Performed database tuning using explain plan, TKPROF, stats pack and other custom utilities 
• Installed, configured 10gRAC on two-node cluster, created databases in both in standalone and RAC environment. 
• Developed RMAN backup scripts and automating the RMAN backup scripts. 
• Provide  DBA  support to developers, developed stored procedures and triggers. Also Provide on call support related to  Oracle DBA  activities. 
• Taking reviews of physical database models. Develop procedures to troubleshoot issues. 
• Handled day-to-day database activities including performance monitoring and tuning to ensure the efficient and accurate operation of the database software. Scheduling maintenance and health check of the applications and databases 
• Analyzing the schemas and individual tables
• Developed scripts for cloning, monitoring, database backup and recovery. 
• Experience in Identifying performance bottlenecks on high volume transaction systems. 
• Implemented different Partition methodologies to improve performance and manageability. 
• Management of security, granting and revoking permissions to users/roles as and when required. 
• Writing UNIX shell scripts
• Working with QA and Development teams for the regular database support. 
• Installed, configured and monitored multi node  Oracle   11g RAC databases  
• Installed and configured Data Guard using physical and logical standby for high availability and reporting purpose. 
• Data pump Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN. 
• Cloned  Oracle  Databases and  Oracle  applications for development and testing.    

Environment: RMAN, AIX, RAC, OEM, SQL, PL/SQL, AWR, Toad, OEM, EXPDP, IMPDP, EXP, IMP, Unix Shell scripting, Oracle 9i, Oracle 10g, Oracle 11g, RHEL.

Confidential

Oracle DBA

Responsibilities:

• Installed and configured 10g Enterprise Manager (OEM).
• Responsible for QA, Test and Prod Oracle 10g databases, build and administration.
• Worked with OEM Oracle Enterprise Manager, Net Configuration Assistant.
• Changed the data files locations as per the space availability and required.
• Gather Oracle Database Statistics - like Tablespace sizes, Data files sizes, etc.
• Creation of Database Health Check reports (including database growth, CPU /memory utilization, Top sql etc.)
• Used import/export utility and Data Pump utility to transfer data.
• Cloning/Refreshing the production database to UAT/DEV environment as per the application user requests
• Refreshing development database from production using export/import, Data pump and RMAN Duplicate.
• Performing Regular Backup’s, Restore and Recovery whenever it is necessary.
• Availability as On-Call 24x7 Production DBA.
• Installation, Upgrade and Configuration of Oracle 10g, 11g databases on Linux/Solaris platforms.
• Installation, Configure, setup of 10g RAC; Add new nodes to RAC 10g Cluster to distribute the load
• Performed upgrades from 10g to 11g and applied quarterly patches.
• Setting up RMAN, Hot and Cold Backups, Exports
• Created and Managed user, table spaces, data files and archive log. 
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance. 
• Communicate and coordinate with Oracle using My Oracle for major database issues/ problems.
• Interacted with user for troubleshooting problems with database performance and SQL query tuning.

Environment: ETL, RMAN, AIX, RAC, OEM, SQL, PL/SQL, AWR, Toad, OEM, EXPDP, IMPDP, EXP, IMP, Unix Shell scripting, Oracle 9i, Oracle 10g, Oracle 11g, RHEL.