SUMMARY

• Total 11+ years of professional experience in the IT industries. 8+ years of experience in area of Oracle Database Administration in Installing, configuring, maintaining RAC, Datagaurd, Physical & Logical Standby environments. 1+ years of experience in ETL tool Informatica.
• Oracle Database administration skills for various releases of Oracle 12c/11g/10g on Red Hat Linux, IBM AIX, HP - UX and Windows environments.
• Strong configuration and troubleshooting skills in ASM.
• Good experience in Performance Tuning reading stats pack/AWR reports, analyzing the Execution Plans.
• Installation and creation of Oracle Databases on Linux and Windows Plat forms.
• Strong experience in Database migration and up-gradation in various platforms. Done several Database patch-set installations as well in one-off patch installation using opatch.
• Strong exposure as Oracle Database Migration / Upgrade Specialist and involved in up gradation of more TEMPthan 10 Databases each sizing Confidential least 500GB from 10g to11g and 11g to 12c.
• Good knowledge and experience on cross platform Database Migration.
• Set up and manage database security by creating new users, roles, profiles and provide required user privileges in development, test and production environments.
• Experience in full life cycle of database administration. Worked both as a Development and Production environments.
• Strong experience in Backup & Recovery, in user managed backups as well with Recovery Manager (RMAN).
• Implemented Oracle Advanced Security features like 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.
• Experience in perform different methods of backups like Hot, Cold and Logical.
• Expertise in cloning database for testing and development environments.
• Experience in configuring and troubleshooting Data Guard on Linux & Windows.
• Installation and configuration of RAC with ASM on multi node systems, 11g and 10g in different operating systems.
• Experience in working with data model tool Erwin.
• Solid expertise in third party supporting software likes TOAD.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc.) by using tools/utilities by Automated Workload Repository (AWR), 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.
• Hands-on experience with Installation, Managing and Configuration of MS SQL Server 2014 on Windows Server 2008.
• Good experience of OEM 11g/12C grid monitoring configuration.
• 24*7 on-call production database support and maintenance including remote database support.
• 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 and then upgrading them to Oracle 11g.

TECHNICAL SKILLS

Operating Systems: UNIX (Sun Solaris 10/11), HP-UX 10.x/11i v3, AIX 5.3/6.1, RHEL 3/4/5/6, Windows XP/2008, Oracle Linux

Cloud: Microsoft Azure

Databases: RDBMS Oracle 12c/11g/10g/9i, MS SQL Server

Tools: & Utilities: SQL*LOADER, Goldengate, ASM, AWR, ADDM, OPATCH, SRVCTL, CRSCTL, ASMCMD, DBCA, Oracle Enterprise Manager(OEM), Export/Import, Data Pump, Oracle Universal Installer, Database Configuration Assistant, Database Upgrade Assistant, Recovery Manager RMAN, cloning, SQL expert, TOAD, Oracle Grid Control, Oracle Cluster ware

Languages: SQL, PL/SQL, UNIX Shell Scripting

Replication: Goldengate, Dataguard, Streams, Transportable Tablespace, Materialized views

High Availability Solutions: Oracle Real Application Clusters (RAC), Dataguard, Automatic Storage Management (ASM), Database Mirroring, Log Shipping, Golden Gate

ETL Tool: Informatica

PROFESSIONAL EXPERIENCE

Confidential, Tukwila, WA

Sr. Oracle DBA

Responsibilities:

• Perform Database migrations from one Data Center to other Data Center.
• Database migration from On-Prem to Microsoft cloud technology Azure and supporting AHM application databases in Microsoft cloud technology Azure.
• Involving in the requirements gathering from application and development teams.
• Database Installation, Administration, Up-gradation and Installing Patches.
• Helping the application teams during their testing.
• Maintaining standalone database RAC databases (High Availability), both On-Prem and Azure cloud.
• Maintain the existing databases and troubleshooting the performance issues.
• Performing the databases backups and making sure the data is safe.
• Developing Shell scripts to automate the database changes and schedule the jobs.
• Monitoring the databases by using OEM 13c.
• Configured the Data guard for switchover and failover and theirby providing high availability.
• Provide production on-call support.

Environment: Oracle 11g & 12c, Microsoft Cloud Azure, Red Hat Enterprise Linux, Windows, Oracle RAC, Dataguard, Goldengate, RMAN, EXP/IMP Data pump, OEM, Toad, Putty.

Confidential, Weehawken, NJ

Sr. ORACLE DBA

Responsibilities:

• Setting up of Dev, Test, Preproduction and Production Environments.
• Cloning Oracle Applications and Databases between Dev, Test, Preprod and Production Environments.
• Installed, Configuration and deployment of Oracle 11g database and Real Application Clusters (RAC) on different nodes with ASM (Automatic Storage Management) on Linux RHEL & HP-UX Itanium.
• Performed conversion of Non ASM database to ASM database.
• Refreshing data on cloned instance of Oracle application by cloning.
• Performed database refreshes and schema refreshes using Data pump (Expdp and Impdp) creating indexes, synonyms, sizing tables.
• Implemented active Data Guard to provide high availability of databases and for disaster recovery (DR).
• Installation, Configuration and Troubleshooting Goldengate12c software.
• ConfiguredGoldengateDownstream Mining and replication components for replication.
• Performed Zero Downtime Database Data Center Migration usingGoldengateand Dataguard.
• Created new schemas, roles, profiles and provide required user privileges in development, test and production environments.
• Implemented Oracle advanced security features like TDE on columns and tablespaces.
• Monitoring and supporting day today activities of the production and development databases
• Configuring Incremental Backup (RAMN) for database and restoring database.
• Configuring Backup for Applications and restoring Applications Hot and Cold backup.
• Performed SQL tuning, application and database tuning.
• Creating scripts for Forms compilation and deployment.
• Configured cross platform Migration from Windows to Linux using RMAN.
• Installing 12c binaries and upgradation database from 11g to 12c.
• Tuning SQL statements using EXPLAIN PLAN.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Monitored the databases and added the data files to the tablespaces or resizing the tablespaces and monitored the sessions running on the databases.
• Managed and supported users by creating roles and privileges for database access and data manipulation.
• Modified shell scripts for backup and recovery, Imported and exported procedure, implementing transportable table spaces.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Installed SQL Server 2014 in stand-alone windows server bit systems.
• Performed full, differential and log backups (scheduled backup jobs) on SQL Server databases.
• Working on ITIL process of Incident management and change management using SM7 (Service Manager 7) tool.
• Responding and working with Application Development teams.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.

Environment: Oracle 11g & 12c, Red Hat Enterprise Linux, HP-UX, Windows, Oracle RAC, Dataguard, Goldengate, RMAN, EXP/IMP Data pump, OEM, Toad, Putty, SM7 & CQ for tickets.

Confidential

Sr. Oracle DBA

Responsibilities:

• Organize application changes and Implementation them 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 RDBMS and Client software in various environments.
• Monitoring and Performance tuning ofGoldengatesessions Confidential OS level, Database level and GGSCI level and investigate replication failures using ggserr.log, report files and Logdump utility.
• Developed Shell scripts, SQL & PL/SQL scripts for monitoringGoldengateprocesses and their stats running on 60+ servers from one single database repository providing table level granularity with end-to-end replication map and thus maintain history of allGoldengateprocesses for later analysis.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities.
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control.
• Oracle Grid Control11gInstallation 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. Oracle Advanced Security features like TDE (Transparent Data Encryption), Data Vault and Audit Vault
• Daily incremental backup and weekly full backup of databases using RMAN.
• Loading data into database tables using SQL *Loader.
• Regular database management on10g and 11g OEM.
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement.
• Granting roles and privileges to end users.
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily health checkup of the database using TKPROF, AWR, and ADDM.
• Monitoring alert log/system log.
• Managing Database Locks and blocking sessions.
• Working on ITIL process of Incident management and change management using SM7 (Service Manager 7) tool.
• Defragmentation of tables and indexes for improved performance and efficiency.
• Customize scripts as per the business requirement.

Environment: Red Hat Enterprise Linux, Solaris, Windows, Oracle 10g and 11g, oracle RAC, RMAN, TOAD, ASM, Dataguard, Putty, SM7.

Confidential, CO

Oracle DBA

Responsibilities:

• Handling Day To Day Activities - Resolving Service Requests.
• Installed and Configured Oracle databases on Linux.
• Maintenance the production, development and testing environments.
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Restoration and Recovery of databases Confidential the times of occurrence of critical failures.
• Responsible for installing and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pumps, Exports/Imports 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 in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Responsible for migration of databases.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,
• Implemented advanced feature of Oracle 10g such asAutomatic 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.

Environment: Oracle 10g, RMAN, TOAD, RAC, ASM, Dataguard, OEM Grid Control, Red Hat Enterprise Linux, HP-UX

Confidential, TX

Oracle DBA

Responsibilities:

• Monitoring & Managing the Table spaces and data files growth and Monitoring locks and various sessions.
• Installation and configuration of Oracle software 10g version.
• 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.
• Configured the Data guard for switchover and failover and theirby providing high availability.
• 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 cold 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.
• Worked as a team member to provide 24x7 on-call production database support.

Environment: Linux, Windows, Oracle 9i and 10g, RMAN, TOAD, ASM, Dataguard, OEM Grid Control.

Confidential, TX

Oracle DBA

Responsibilities:

• Responsible for installing and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement.
• Granting roles and privileges to end users.
• Managing, troubleshooting and resolving oracle database and application issues.
• Loading data into database tables using SQL *Loader.
• 24/7 Support for the production, development and test databases service tickets.

Environment: Oracle 9i and 10g, Linux, Windows 2003 server, TOAD.

Confidential

Informatica Developer

Responsibilities:

• Gatheird business requirements from Business Analyst.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load.
• Worked on loading of data from several flat files to Oracle database Targets.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.

Environment: Informatica Power Center, Erwin, Oracle 9i, Toad, Windows, Flat files, SQL, Relational Tools, Clear Case.