SUMMARY:

• Over 8+ years of experience as an Oracle DBA in Production, Development and Test environments, and transforming business strategies of various organizations into efficient and integrated global business solutions.
• Expert in Oracle 12c/11g/10g, 12c/11g/10g RAC installation, administration, performance tuning, upgrades on Solaris, HP - UX, Redhat Enterprise Linux, Windows platforms.
• Deep knowledge of Oracle 11g Grid Infrastructure, Clusterware, ASM, RAC internal, Active Data Guard in RAC environment.
• Good experience in Oracle Database Installation, configuration and Administration, Backup and Recovery, Database Migrations.
• Experienced in Oracle Goldengate, Informatica and ETL Jobs management and processes.
• Participated in analysis and designing ofOracleExadataServer for infrastructure and related projects.
• Experience working onORACLEEXADATAMachine X6-2for the extreme performance of the database.
• Excellent experience in Performance tuning of oracle databases using Oracle Grid Control AWR, ADDM, and tuning of SQL scripts using SQL Trace, TKProf, Explain Plan, and Hints.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases, Application Servers and Middle Tiers.
• Interface with Oracle technical teams for upgrades, latest version and utilities.
• Well versed in using Oracle Tools (SQL*Loader, Svrmgr, Export/Import), Oracle Enterprise Manager(OEM), SQL* Plus, SQLServer Enterprise Manager
• Disk space management (Tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database network connectivity). Dealing with Oracle Parameters, SGA tuning.
• Experience in Flashback Versions Query, Flashback Table, Flashback Database, Oracle Data Pump, Export, Import, SQL* Plus, Toad Automatic Workload Repository, performance Tuning.
• Experience in Transportable Table spaces, Automatic Shared Memory Management, Backup & Recovery using hot backups, cold backups, Rman backups with the use of SQL skills.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, ERWIN Data modeling, Logical and Physical database design.
• Management of schemas, objects, partitioning the tables, indexes, USERS and PRIVILEGES 11g OEM Grid Monitoring.
• Performance testing and tuning, capacity planning, and database monitoring.
• Performed Database Refreshes.
• Written shell scripts to enable general users to startup, shutdown databases, automate export, backups.
• Strong experience in providing 24/7 support for corporate databases, timely resolution of tickets, and on-call rotation.
• Resolved database network problems using Oracle Net Configuration Assistant(NETCA)
• Strong experience in working with various project, application and infrastructure teams, in large enterprise projects.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, T-SQL,shell scripting C, C++, C#, JAVA, VB

Protocols: TCP/IP, HTTP and FTP

Data Replication: Oracle GoldenGate 11gR2, 12c

Operating Systems: UNIX (Solaris 9, 10, AIX 3.2, 5.3, HP-UX11), Red hat 2.1, 3.x, 4.x, 5.x (32bit, 64bit), Windows 95/98/NT, Windows 2000/XP, Linux, AIX.HP-UX, SCO UNIX, Sun Solaris, Linux, AIX, Windows NT (4.0), Windows. Sql Server 2005/2003/2000 RDBMS/Server Oracle 9i/10g/11g/12c,SQL Server 2005/08/12 & MS-Access,PostgreSQL,MYSQL

Report Tools: Crystal Reports, SSRS

Oracle Database Tools: SQL*Loader, TKPROF, Toad, SQL Developer, OEM Grid Control, Data guard, SQL*Loader, STATSPACK & AWR, DBCA, Automatic Database Diagnostic Monitor (ADDM) and ASM (Automatic Storage Management), Export/Import, Data Pump, RMAN, SRVCTL, DBCA, Oracle Net, ERWin, RMAN, Logminer, OEM 12c

Tools: & Utilities: Winscp3, ERWIN. Putty,Toad 7.5, Unix utilities (awk, sed, vi), ksh, bash. SQL Server 2005/2000, SSIS, SSRS. Informatica PowerCenter, Devops,AWS,RDS

Modeling Methodology: UML, MS-VISIO

Version Controller: Visual SourceSafe, Team Foundation Server

PROFESSIONAL EXPERIENCE:

Confidential

Jr. Oracle DBA

Environment: Oracle 11g/12c, RAC, goldengate, Oracle HTTP Server, Web Cache, Data Replication, ETL Jobs, Performance Tuning.

Responsibilities:

• Data tracking and arranging, communication, meetings with various solution leads and housekeeping.
• Trouble shooting of issues faced in various environments including Dev, Test and Production.
• Maintain and monitor all the related applications in all the environments that is, development, staging and productionInstalled, configured, and managedOracledatabase 12C onExadata(X6 2) box.
• Migrated 12COracledatabases fromExadataX4 to X6 using both physical and logical methods.
• Migrated databases from non-Exadataservers to theExadataDatabase Machine using the RMAN 11g duplicate standby and using Rconfig method.
• Performance tuning of oracle databases using Oracle Grid Control AWR, ADDM, and tuning of SQL scripts using SQL Trace, TKProf, Explain Plan, and Hints.
• Management of schemas, objects, partitioning the tables, indexes, USERS and PRIVILEGES 11g OEM Grid Monitoring.
• Administration of Database, RAC (Real Application Cluster), High Availability server maintenance with Dataguard Installation and Configuration.
• Perform regular Oracle export, Import Data Pump activities in test, stage and Production.
• Performed other regular DBA activities including space management and performance monitoring.
• Perform Database Refreshes for test, stage and Production environment.
• Perform Release activities and Database activities coordination’s between DevOps and Production support.
• Work with the Business Analysts/ Developer/ team members to prepare specification during the project requirements stage. Direct the offshore team for documentation of functional requirements for client submission and approvals.
• Requirements Gathering and Analysis
• Identify the root cause of the issues and providing a permanent solution.
• Work with the client in proposing solutions for the overall stability of the applications.
• Coordinate with onsite and offshore team during developing, testing and deployment.
• Working closely with the developers on SQL/PLSQL, TSQL Coding queries and ETL Jobs and Application Code tuning.
• Coordinate with client and vendors in case of production issues.

Confidential

Database Administrator

Environment: Oracle 11g/12c, RAC, goldengate, Informatica, Oracle HTTP Server, Web Cache, Data Replication, ETL Jobs, Performance Tuning.

Responsibilities:

• Provide on-call and off-hours production support as necessary to ensure proper functioning of SD&E Cloud, Platform, Application, and Data Layer Support (CPADs) applications such as CCR-R (Common Customer Repository - Relational).
• Thoroughly troubleshoot and resolve production application and database issues related to the CCR-R application
• Maintain and monitor all related database production environments
• Technologies include Oracle, Database Performance Tuning, Golden Gate, ETL, and Informatica
• Monitor and troubleshoot ETL and Informatica data loads into supported databases
• Work on maintenance of Golden Gate setup and troubleshoot ongoing data replication issues
• Monitor Oracle database performance and ensure that database parameter settings are optimal
• Provide consultation for tasks normally performed by Application DBAs to resolve database-related issues
• Analyzing and monitoring system resources associated with database performance such as CPU, memory utilization, and I/O performance
• Support major and minor application releases through software installation
• Monitor and test system performance and provide performance statistics, reports, and recommendations
• Develop and maintain appropriate documentation as necessary
• Provide consultative assistance with developmental activities as necessary.
• Responsible for detailed investigation of database issues
• Capture requirements and perform detailed analysis for new database builds, storage analysis, and hardware requirements
• Consult with end-users to assist in determining current operating procedures and improvement suggestions based on best practices
• Requirements gathering and validation with solid understanding of customer’s framework, products, technology, and work practices
• Coordinate with end-users to understand problems, arrange meetings, and conference calls.
• Coordinate with onsite and offshore team during developing, testing and deployment.
• Working closely with the developers on SQL/PLSQL, TSQL Coding queries and ETL Jobs and Application Code tuning.

Confidential, TX

Database Administrator

Environment: Oracle 11g/12c, RAC, Goldengate, Informatica, Oracle HTTP Server, Web Cache, Data Replication, ETL Jobs, Performance Tuning.

Responsibilities:

• Data tracking and arranging, communication, meetings with various solution leads and housekeeping.
• Trouble shooting of issues faced in various environments including SIT, UAT and Production.
• Maintain and monitor all the related applications in all the environments that is, development, staging and productionPerformance tuning of oracle databases using Oracle Grid Control AWR, ADDM, and tuning of SQL scripts using SQL Trace, TKProf, Explain Plan, and Hints.
• Management of schemas, objects, partitioning the tables, indexes, USERS and PRIVILEGES 11g OEM Grid Monitoring.
• Administration of Database, RAC (Real Application Cluster), High Availability server maintenance with Dataguard Installation and Configuration.
• Performed other regular DBA activities including space management and performance monitoring.
• Work with the Business Analysts to prepare functional specification during the project requirements stage. Direct the offshore team for documentation of functional requirements for client submission and approvals.
• Requirements Gathering and Analysis
• Identify the root cause of the issues and providing a permanent solution.
• Work with the client in proposing solutions for the overall stability of the applications.
• Coordinate with onsite and offshore team during developing, testing and deployment
• Coordinate with client and vendors in case of production issues.

Confidential, VA

Environment: Oracle 10g/11g RAC, Grid, OEM, AWR, ASM, SQL*Plus, Grid Control, Data Guard, RMAN, Oracle TOAD 9.4, Database Cloning, Sun Solaris.

Responsibilities:

• Responsible for 24 X 7 Production database administration, support and monitoring.
• Configured and installed Oracle 11g with two nodes RAC in ASM storage with normal redundancy on Solaris 10/ Redhat Linux 6 .
• Supported different OLTP/OLAP Databases like Production, Development, Testing, and .
• Performed Data load on different databases using SQL*Loader/Datapump.
• Proactive database monitoring and management using 11g/12g grid control tool OEM.
• Performed database and memory tuning using tools like TKPROF, EXPLAIN PLAN, OPTIMIZER, AWR,ADDM and SQL tuning advisor.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading development and production databases to Oracle 11g.
• Provided support to Application Database Administrators in designing the database.
• Planned, tested and implemented backup strategies using RMAN, Oracle Utilities (Export/Import) and OS methods.
• Implemented Hot, Cold and Logical backup plans.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Involved in Design and implementation of oracle 11g Data Guard both physical/logical standby databases.
• Performed other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations/Upgrade/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.

Confidential, VA

Environment: Oracle 10g/11g RAC, Grid, OEM, AWR, ASM, SQL*Plus, Grid Control, Data Guard, RMAN, Oracle TOAD 9.4, Database Cloning, Sun Solaris.

Responsibilities:

• Responsible for 24 X 7 Production database administration, support and monitoring.
• Configured and installed Oracle 11g with two nodes RAC in ASM storage with normal redundancy on Solaris 10.
• Installation, upgradation, and deployment of weblogic server.
• Migrated Oracle databases from windows to Solaris and vice versa.
• Supported different OLTP/OLAP Databases like Production, Development, Testing, and .
• Performed Data load on different databases using SQL*Loader/Datapump.
• Involved in logical and physical databases design.
• Weblogic Administration Installation, configuration and troubleshooting.
• Proactive database monitoring and management using 11g/12g grid control tool OEM.
• Performed database and memory tuning using tools like TKPROF, EXPLAIN PLAN, OPTIMIZER, AWR,ADDM and SQL tuning advisor.
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading development and production databases to Oracle 11g.
• Applied patches to Oracle Databases.
• Provided support to Application Database Administrators in designing the database.
• Planned, tested and implemented backup strategies using RMAN, Oracle Utilities (Export/Import) and OS methods.
• Implemented Hot, Cold and Logical backup plans.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Involved in Design and implementation of oracle 11g Data Guard both physical/logical standby databases.
• Performed other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations/Upgrade/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.

Confidential, CT

Assist in Database Administartor

Environment: Oracle 10g/11g RAC, Grid, OEM, AWR, ASM, SQL*Plus, Grid Control, Data Guard, RMAN, Oracle TOAD 9.4, Database Cloning, Sun Solaris.

Responsibilities:

• Daily Health Checkup of the database using Statspack, AWR, ADDM.
• Responsible for administration and supporting Oracle 11g, 10g and 9i databases in DEV, QA, UAT and Prod environments
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Downsizing and defragmenting the Large Databases by export/import
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM
• Performed Upgrade of development, production and QA databases from oracle 10.2.0.3 to Oracle 11gR1.
• Migration of database from oracle 10g to oracle 11g on Sun Solaris server.
• Worked on Automatic Storage Management (ASM) for managing data in SAN
• Monitoring and resolving tickets in different environments
• Export and Import of database objects to copy from one database to another database between different environments
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities)

Confidential

Database Management

Environment: Oracle 10g/11g RAC, Grid, OEM, AWR, ASM, SQL*Plus, Grid Control, Data Guard, RMAN, Oracle TOAD 9.4, Database Cloning, Sun Solaris.

Responsibilities:

• Administration configuring and monitoring daily backups, troubleshooting errors, to improve performance.
• Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Creating new environments for data loading and manipulation for various states in the US, according to the specification provided by Century Link.
• Assisting the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
• Involved in the documentation of every task involved in the recovery issues or backups.
• Setting up and monitoring Cron jobs to schedule database backups with the help of RMAN scripts and daily night exports.
• Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
• Tuned and optimized SQL Query, SGA and monitoring the statspack report generated from snapshots taken at the peak business hours.
• Monitored and tuned rollback segment, temporary tablespace, redo log buffer, sort area size.
• Monitored & maintained as necessary the following: Alert logs for instances, backups, database connection availability directly & via SQL*Net, database process count, exports & their backups, listener for SQL*Net and space in Oracle owned file systems.
• Extensively involved in design physical and logical models of the database using ERWIN.
• Used Explain Plan to monitor the query execution and views to make sure the operations run without roadblocks.
• Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Creation of various database objects including materialized views.
• Troubleshooting errors and using the expdp/impdp utiliy on a very regular basis for copying data across schemas.
• Running scripts and monitoring the load process to avoid roadblocks in ETL jobs running for a long duration.
• Troubleshooting expdp/impdp errors, configuring storage accordingly.

Confidential

DBA

Environment: Redhat Linux, Sun Solaris, Windows 98/NT/2000, Oracle 9i, 10g, Oracle Enterprise Manager, STATSPACK, TKPROF, EXPLAIN PLAN, RMAN.

Responsibilities:

• Installation of Oracle Databases for the Development environment on Redhat Linux and Windows 2000.
• Managing access rights to various users/schemas.
• Monitored the utilization of Database Objects.
• Proactively monitoring the database’s health and taking preventive or corrective actions.
• Defining the system parameters according to the database requirement
• Ensure data consistency in the database
• Performing Backup and Recovery activities at different levels of Hot backups, Cold backups, Export and Import (logical).
• Performing other activities like Script running, Scheduling activities, Generating Stats pack reports, Tkprof, SQL*Loader.
• Providing 24x7 DBA support during the implementation phase.
• Oracle database creation and cloning for test and development instances.
• Estimated database capacity managed system disk space and system resources.