Resume

Database Administrator

Location:

St. Charles, IL

Posted:

October 08, 2020

Contact this candidate

Resume:

Summary

Database Administrator with *+ Years of experience as Oracle DBA (19/12c/11g/10g/9i/8i) which includes Installation, Configuration, Performance Tuning, Backup/Recovery, Disaster Recovery, up-gradation, cloning, patching, RAC, ASM, 24X7 On-Call production support and PL/SQL coding on different HP-UX, Sun Solaris, Linux, AIX, and Windows.

Proficient with Database Cloning, Migration, Data Guard and Patching of Oracle Databases and Oracle Applications.

Experience in Database Encryption.

Every good knowledge of version update and patching.

Flexibility in working with teams for production of database.

Experience in using 10g and 11g features like Data pump, Flash-Back Recovery, ASM and Compression

Upgrading the databases from 9i and 10g to 11gr2, 11g to 12c and 12c to 19c

Upgrading RERP from 12.1 to 12.2

Experienced in maintenance of security infrastructure, identification/authorization security and maintaining Database Security using auditing

Oracle Database Administration / Application Design, Development Design and Administration. Extensive experience in custom development / data quality analysis, Legacy data processing, stored procedures, Triggers, indexing strategies.

Good hands on experience in configuring and maintaining11g ORACLE ENTERPRISE MANAGER(OEM)

Applied PSU,CPU and security patches, java upgrade in database, EBS and FMW, Web Logic sever patches, RERP online patches etc.

Configured and implemented Oracle Streams and adding new tables to streams

Knowledge in Oracle Golden gate.

Worked on SOA Suite upgrade from 11g to 12C

Experience in working with RAC with N number of clusters

Day to day monitoring experience using RAC

Working knowledge on architecture and components of RAC

Delivering SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzing SQL trace dumps for 9i/10g/11g.

Experience in Operational data store, data cleansing, backup and restoration strategies and SAN.

Used PL/SQL (Stored procedures, triggers, packages (DBMS_*, UTL_*)), SQL* PLUS, SQL* LOADER and SQL tuning of Oracle database.

Extensive Experience in Oracle Architecture, I/O tuning, Memory Tuning, Performance Tuning, Backups, Recoveries, RMAN backups, Optimization, Crash/Disaster Recovery, Networking, Troubleshooting

Expertise in Trouble shooting day to day production issues in 24*7 production

Exceptional troubleshooting and analytical problem-solving skills.

Excellent problem solving skills with strong technical background and interpersonal skills.

Preparing Standard Operating Procedures documents for all databases under support

Hands on in managing partitioned tables like creating the partitioned tables,addition of new partitions, compression,exchange partitioning and carrying out maintenance activities.

Good Written and verbal Communication skills with a customer service oriented attitude.

Proficient with new features: Active Dataguard, configuring Snapshot standby database.

Automated Rebuilding indexes, Partition additions and space additions

Performance tuning, backup and recovery, space management, database security, Auditing.

Cloning the Database from Prod to Dev using USER MANAGED and RMAN techniques.

Migrate schemas using traditional exp/imp and Oracle Data pump utilities.

Technical Skills

al Skill

Relational Databases:

1.Oracle 9i (9.2.0.1, 9.2.0.4, 9.2.0.5, 9.2.0.6, 9.2.0.7, 9.2.0.8)

2.Oracle10g Release 2 (10.2.0.1, 10.2.0.3, 10.2.0.4)

3.Oracle 11g Release 1 (11.1.0.6,11.1.0.7,11.2.0.1)

4.Oracle 11g Release 2 (11.2.0.1, 11.2.0.2,11.2.0.3,11.2.0.4)

High Availability & Tuning/Monitoring:

1.Oracle Management Server (OMS) 9i, 10g &11g.

2.Oracle Enterprise Manager (OEM) 9i, 10g & 11g.

3.Data-Guard 10g& 11g.

4.Database Cloning (Manual, RMAN)

5.Standby Databases (Manual, RMAN) (Physical & Logical)

6.RMAN 9i, 10g & 11g.

7.Tuning with SQLT,ADDM

8.Active Database Cloning with duplicate

Operating Systems:

1.Solaris 8,9,10

2.HP-UX

3.Aix

4.Linux

Languages and Scripting

1. C

2. SQL

3. PL/SQL

4. Shell Scripting

Project Experience

Client : Wells Fargo, IL Jan 2019 - Till Date

Role : Database Administrator

Employer : ERPA, Inc

RESPONSIBILITIES:

24x7 Production database and application support.

Upgraded databases from 11gr2 to 12c and 12c to 19c.

Upgraded RERP from 12.1 to 12.2

Patching an upgrading windows servers.

Created DataGuard standby databases, worked on patching primary/standby.

Involved with installation and maintenance of Primary and Standby Database (Oracle Data Guard) for High Availability and Disaster Recovery Purpose.

Restoration and Recovery of databases at the times of occurrences of critical failures.

Responsible for installing, upgrading ad configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Cloning/Refreshed Oracle databases and Oracle Applications.

Refresh Non-production databases from production to RMAN duplicate.

Applied PSU,CPU and security patches, java upgrade in database, EBS and FMW.

Monthly password changes in EBS and FMW.

Moving data between databases using Data Pump.

Performed large batch jobs, and tuning of SQL queries and database systems.

Partitioned large tables for better performance and manageability

Implemented downstream capture at the destination database using Oracle Streams

Handling different issues in RAC environment

Installation of RAC components /Nodes for Web Center Portal

Worked on creating new users, responsibilities, concurrent requests and monitoring concurrent jobs.

Experience in SQL, PL/SQL, Database procedures, triggers & packages (DBMS_*, UTL_*)), SQL* PLUS, SQL* LOADER and SQL tuning of Oracle database.

Clear documentation was prepared on all the processes like program specification, bugs fixing, logs and change requests for future references.

ENVIRONMENT: Oracle 12.2.0.1,12.2.0.2 AWR, Red Hat Linux 7.7, Windows 2012, FMW, SOA, Oracle E Business Suite, Streams, OBIEE and Web Portal, SQL Developer, TOAD, RAC.

Client :Norfolk Southern, GA July 2018 - Jan 2019

Role : Database Administrator

Employer : ERPA, Inc

RESPONSIBILITIES:

24x7 Production database and application support.

Upgraded databases from 10g, 11gR2 and 12c.

Worked on migrating the databases from mainframe to Oracle

Created User accounts, Role and granting required access permissions and privileges to the database based on applications they are accessing

Partitioned large tables for better performance and manageability

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups, File system backups and Logical backups using data pumps

Creating and Maintenance of different types of Tablespaces and adding datafiles when ever required.

Automated jobs to run backups, disk cleanup for logs and archive logs, gather statistics.

Identify and troubleshoot long running queries, locked sessions to improve overall performance.

Established and wrote the Database Administrators Procedures document for

the IT department.

Clear documentation was prepared on all the processes like program specification, bugs fixing, logs and change requests for future references.

ENVIRONMENT: Oracle 11.2.0.4, Red Hat Linux6.1/6.7, Windows 2012, SQL Developer, TOAD.

Client :Wells Fargo Chicago, IL June 2016 - June 2018

Role : Oracle DBA

Employer : ERPA, Inc

RESPONSIBILITIES:

24x7 Production database and application support.

Upgraded databases from 10g, 11gR2 and 12c.

Installed, configured and maintained Oracle 10g and 11gR2.

Involved in annual Disaster Recovery (DR/BCP) validation activities.

Created DataGuard standby databases, worked on patching primary/standby.

Involved with installation and maintenance of Primary and Standby Database (Oracle Data Guard) for High Availability and Disaster Recovery Purpose.

Restoration and Recovery of databases at the times of occurrences of critical failures.

Cloning/Refreshed Oracle databases and Oracle Applications.

Refresh Non-production databases from production to RMAN duplicate.

Oracle Application (EBS) cloning using rapid clone

Implemented Oracle database backup and recovery solutions using RMAN and manual methods.

Applied PSU,CPU and security patches, java upgrade in database, EBS and FMW.

Monthly password changes in EBS and FMW.

Upgraded FMW 11g to 12c, 12.2.1.1 to 12.2.1.2.

Moving data between databases using Data Pump.

Performed large batch jobs, and tuning of SQL queries and database systems.

Created User accounts, Role and granting required access permissions and privileges to the database based on applications they are accessing

Partitioned large tables for better performance and manageability

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups, File system backups and Logical backups using data pumps

Configured and implemented Oracle Streams

Implemented downstream capture at the destination database using Oracle Streams

Resolved streams synch issues.

Perform other regular DA activities including space management and performance monitoring.

Worked on SOA Suite upgrade from 11g to 12c

Handling different issues in RAC environment

Installation of RAC components /Nodes for Web Center Portal

Creating scripts for maintenance issues in RAC environment

Load and transform data using SQL*Loader ad External tables Logical and Physical Database design

Worked on creating new users, responsibilities, concurrent requests and monitoring concurrent jobs.

Experience in SQL, PL/SQL, Database procedures, triggers & packages (DBMS_*, UTL_*)), SQL* PLUS, SQL* LOADER and SQL tuning of Oracle database.

Worked with UNIX, Storage and Networking teams to implement infrastructure related changes.

Worked with Oracle Support to resolve various issues reported

Clear documentation was prepared on all the processes like program specification, bugs fixing, logs and change requests for future references.

ENVIRONMENT: Oracle 11.2.0.4, 11.2.0.3, AWR, Red Hat Linux6.1/6.7, Windows 2012, FMW, SOA, Oracle E Business Suite, Streams, OBIEE and Web Portal, SQL Developer, TOAD, RAC.

Client : Wolters Kluwer Chicago, IL Dec 2015 - May 2016

Role : Oracle DBA

Employer : ERPA, Inc

RESPONSIBILITIES:

Installed and configured 11g single instance.

Active duplicate cloning of the databases using RMAN

Configured Recovery catalog for all databases in the environment

Created shell scripts and batch scripts for RMAN incremental, cumulative and full back up on Linux and windows.

Performed and prepared Recovery steps.

Install, patch and maintain oracle software.

Creating users and assigning roles and privileges.

Tuned all oracle instance components including SQL/PLSQL.

Control all migrations of oracle schema objects.

Working with application teams in order to enhance the performance of database with the help of AWR, Explain plan and other performance reports.

Involved in server maintenance and quarterly patching applying activities.

Used Stored procedures, triggers, packages using PL/SQL, SQL* PLUS, SQL* LOADER.

Implemented the process of documenting critical tasks performed.

Handled other general database administration activities.

Starting and stopping Web Logic Services.

Worked on OEM 11g.

Database backup and Recovery.

Prepared and monitored documentation on applications and databases.

Generated and analyzed AWR reports for performance tuning

Registered Red Hat Classic subscription for OS.

ENVIRONMENT: Oracle 11.2.0.4, 11.2.0.3, AWR, Red Hat Linux6.1/6.7, Windows 2012, GRC, UC,SWIF, PL/SQL, SQL Developer, TOAD, SQL Plus

Client : Kimberly Clark Knoxville, TN Feb 2015 - Nov 2015

Role : Oracle DBA

Employer : ERPA, Inc

RESPONSIBILITIES:

24*7 production Support for mission critical production systems.

Active duplicate cloning of the databases using RMAN.

Cloning from cold backup using RMAN.

Used EXPLAIN PLAN, TKPROF to tune SQL queries.

Used normal import and export and also datapump import and export for exporting and importing schemas, tables etc from one database to another.

Responsible for moving data from Production to lower environments for various testing cycles using Oracle data pump and also refresh the UAT and Test environments with Prod data.

Security Administration including the management of profiles, roles, users and their privileges.

Configure and manage RMAN backup using GRID.

Flash back technology.

Experience in opening, managing, and resolving Oracle Service Requests.

Resolve issues during migration from different ASM disk groups following up with Oracle.

Manage the Cluster Services in case of any abnormal failures. Worked with users in tuning their bad SQL.

Tuned and optimized SQL Query, SGA, Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.

Worked on Database optimization by setting various initialization parameters on Oracle request.

Restorations of databases using RMAN. Experience in various recovery scenarios.

Upgrading the databases to higher versions of oracle by manual and DBUA.

Generating AWR reports on regular basis to identify the database performance at peak load.

Tuning the SQL statement by analyzing the explain plan and ADDM reports

Implemented stored scripts in catalog for effective use of RMAN.

Experience in planning and implementing the maintenance activities to reduce fragmentation and improve performance.

Working with the solution design team and identifying solutions to the new business functionalities. Preparing the weekly and monthly status reports to the management.

Tuning memory parameters

Performed logical backups, Hot/Cold Backup and Recovery and Cloning of databases using RMAN

Responsible for Logical and Physical data modeling.

Extensive performance tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.

ENVIRONMENT: Oracle 11g/10g, Sun Solaris, Linux, TKPROF, AWR, Red Hat Linux 4/5, Data Guard, Windows.

Client : Synopsis India Jan 2011 - Oct 2014

Role : Oracle DBA

Employer : MouriTech

RESPONSIBILITIES:

Provided 24x7 Support of Critical Databases and worked on enhancing the Database Monitoring process.

Troubleshooting issues during upgrade, applying patches to fix issues.

Upgrade of database from 9.2.0.8 to 10gR2.

Provided production database support, including creating and maintaining databases, backup and recovery, security, upgrades. Responsible for refreshing/cloning test instances with Production Instance periodically,

Applying patches for fixing issues and adding functionality.

Administration of databases- Physical and logical structures.

Applied and provided feedback regarding in-house technical standards and processes.

Creating and Managing users, Granting and Revoking privileges for the users in order to ensure the Database security.

Creating and Maintenance of different types of Tablespaces.

Automated jobs to run backups, disk cleanup for logs and archive logs, gather statistics.

Identify and troubleshoot long running queries, locked sessions to improve overall performance.

Established and wrote the Database Administrators Procedures document for

the IT department.

Managed and supported users by creating roles and privileges for database access and data manipulation. Reported the database storage capacities to Project Management.

Used PL/SQL (Stored procedures, triggers, packages (DBMS_*, UTL_*)), SQL* PLUS, SQL* LOADER and SQL tuning of Oracle database.

Organized the capacity planning of the production database.

This document outlines all standards for the DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards, policies, practices and procedures.

Supported development projects on database activities (Oracle, DB2, and MySQL).

ENVIRONMENT: Oracle 10g/9i, Solaris 2.6/2.8, Linux, HP-UX, PL/SQL, SQL Plus.

Client : Chanikya Design Patterns HYD, India Feb 2010 - Nov 2010

Role : DBA