SUMMARY:

• Over 6 (six) years of Oracle Database Administrator experience with very strong knowledge within Information Technology. As a very motivated professional looking towards leading and challenged in a position with an organization utilizing expertise, supervision and superlative oracle database skills to benefit mutual growth and success. A self - motivated, responsible and reliable team player with a set of very strong technical and professional skills.

TECHNICAL SKILLS:

Operating Systems: Oracle Linux, RHEL, Solaris and Windows.

Databases: Oracle, MS SQL Server and Sybase.

Tools: & Utilities: TOAD, WinSCP, Putty and SQL Developer. AWR, ADDM, Erwin

Languages: Java, J2EE, .Net, SQL, PL/SQL and UNIX Shell Scripting.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Oracle Database Admin

Responsibilities:

• Experienced in full life cycle of database administration and setting up of Development, Test, Preproduction and Production environments.
• Installation and creation of Oracle Databases on Linux and Windows Platforms.
• Strong experience in Database Migration and Upgradation in various platforms.
• Strong exposure as Oracle Database Migration/Upgrade specialist and involved in up-gradation of more than 10 Databases each sizing at least 500GB from 11g to 12c.
• Good knowledge and experience on cross-platform Database Migration.
• Set up and manage database security by creating Schemas, Roles, Profiles and provided required user privileges in development, test and production environments.
• Strong experience in Backup & Recovery, in user-managed backups as well with Recovery Manager (RMAN).
• Experience in perform different methods of backups like Hot, Cold and Logical.
• Implemented Oracle Advanced Security features TDE (Transparent Data Encryption), Data Vault and Audit Vault.
• Having good knowledge on Oracle's security framework of Virtual Private Database (VPD) and fine-grained access control.
• Experienced in working with data model tool Erwin.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning) using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Extensive experience in installation and implementing OEM and TOAD.
• Experience developing Oracle database code using SQL and PL/SQL.
• Extensive knowledge and experience on ETL processing using Informatica Tool.
• Good experience of OEM 11g/12C grid monitoring configuration.
• Created Database maintenance plans for compressed full DB backup and transaction log backup.
• Working on ITIL process of Incident management and change management using SM7 (Service Manager 7) tool.
• Excellent inter personal communication, analytical and problem-solving skills.
• Extremely dedicated, self-motivated, Pro-Active and willing to assume responsibility.
• Downsizing and defragmenting the very large Databases by export/import, cloning by using RMAN duplicate database features.
• Cloning Oracle Applications and Databases between Dev, Test, Preprod and Production Environments.
• Installed, Configuration and deployment of Oracle 11g & 12c Real Application Clusters (RAC) on Linux.
• Performed conversion of Non ASM database to ASM database.
• Performed database refreshes using Data Pump (expdp/impdp).
• Implemented active Data Guard to provide high availability of databases and for disaster recovery (DR).
• Experienced in configuring and troubleshooting Data Guard on Linux & Windows.
• Installation, Configuration and Troubleshooting Goldengate 12c software.
• Configured Goldengate Downstream Mining and replication components for replication.
• Performed Zero Downtime Database Data Center Migration using Data guard.
• Tuning SQL statements using EXPLAIN PLAN.
• Responding and working with Application Development teams.
• 24/7 on-call production database support and maintenance including remote database support.

Confidential, Rockville, MD

Oracle DBA

Responsibilities:

• Handling day to day activities - Resolving Service Requests.
• Installed and Configured Oracle databases 11gR2 on Linux.
• Maintenance the production, development and testing environments.
• Responsible for installing and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Responsible in configuring and backing up database using RMAN, Hot backups and Incremental backups.
• Extensive use of Oracle Data pumps (Export/Import) utility for moving data among the servers.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Responsible for migration of databases.
• Configured Oracle Data guard for Oracle Disaster recovery. Restoration and Recovery of databases at the times of occurrence of critical failures.
• Configured the Data guard for switchover and failover and thereby providing high availability.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Implemented advanced feature of Oracle 11g such as Automatic Workload Repository (AWR) for monitoring database performance.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Implemented Oracle Database 11g Six-Nodes Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Monitoring & Managing the Tablespaces and data files growth and Monitoring locks and various sessions.
• Created databases, allocated system storage and planned future storage requirements for the database.
• Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Used the standby database for doing different operations like taking backups, recoveries, collecting statistics and running various reports without disturbing the production database.
• Coordinated operating system setup/upgrades and infrastructure troubleshooting in partnership with system administrators.
• Implemented Recovery Manager (RMAN) Recovery Catalog performed Complete and Incomplete recovery.
• Performed Hot Backups and maintained database availability to support non-stop Business operations.
• Implemented Cloning to migrate data from Prod to Test and Dev databases.
• Created users, roles and granted privileges according to the business requirements
• Responsible for taking full database backup, Regular checking of Alert log file, Performance Tuning and Providing support for the smooth functioning of the Database to developers
• Performed Capacity planning and storage management.
• Estimation of database growth and analysis.
• Coordination with the team and ORACLE Support for troubleshooting the database issues.
• Modified shell scripts for backup and recovery, Imported and exported procedure, implementing transportable table spaces.
• Performed point-in-time recovery with Flashback in regular basis.
• Managing, troubleshooting and resolving oracle database and application issues.
• 24/7 Support for the production, development and test databases service tickets.

Confidential, Sacramento, CA

Oracle DBA

Responsibilities:

• Organize application changes and Implement accordingly.
• Accommodate growing business by designing new database and examining existing environment.
• Provides database consulting for application environment planning, sizing and provisioning.
• Installation, Configuration and Maintenance of Oracle Database and Client software in various environments.
• Migration of databases from 10g to 11g using data pump (export/import.)
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control.
• Oracle Grid Control 11g Installation and Configuration.
• Configuration of Physical Standby database for maximum performance mode -Oracle Data Guard.
• Virtual database setup to limit the user to access table columns only the admin not the application users.
• Implemented Oracle Advanced Security features TDE (Transparent Data Encryption), Data Vault and resolving Audit reports.
• Daily incremental backup and weekly full backup of databases using RMAN.
• Loading data into database tables using SQL Loader.
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients and development teams.
• Tablespace monitoring, Performance monitoring and tuning for performance improvement.
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily health checkup of the database using AWR, and ADDM.
• Monitoring alert log/system log.
• Managing Database Locks and blocking sessions.
• Defragmentation of tables and indexes for improved performance and efficiency.
• Customize scripts as per the business requirement.
• Mentored other team members for better business growth.