Resume

Oracle DBA

Location:

Milwaukee, WI

Posted:

August 18, 2017

Contact this candidate

Resume:

Shailender Kumar Gautam

949-***-****

Professional Summary:

Total 13+ years experience as Oracle Database Administrator (Proficient in Oracle Database Administration Activities) like developing customized business applications, database design, database administration and experience on UNIX (Solaris, HP-UX, AIX), Linux, Windows NT 4.0/2000/2003/2008/2012 with Oracle(8.0.5,8i,9i,10g,11g,12c),Developer 6i/9i,Sql net, Sql*Plus, etc.

Oracle Certified Professionals (9i/10g) Database Administrator

Hands on experience of 9i/10g/11g RAC implementation, maintenance and support, Oracle Data guard (9i/10g/11g) both logical & Physical Standby experience on Unix & Windows XP/NT servers.

Expertise in OEM 12c Cloud control and 10g Grid Control.

Extensive experience with Oracle Database Migration/Upgrade from 9i to 10g and from 10g to 11g, and to 12c.

Extensive experience of PSU patching and bug fixes on the top of Oracle RAC/Non-RAC Production/Non-Production databases.

Currently managing 200+ Oracle Production Support Databases with the total size of 3.0+ TB and 400 Oracle Instances on Dev/Test and Production Environment.

Extensive experience of 9i/10g/11g RAC implementation, maintenance and support

Used Oracle 10g streams for Data replication, Data warehouse loading, Event notification as well as business event management. Experience with database backup, restore, and disaster recovery procedures. Hands on experience of database backups and Recovery strategies using RMAN (9i/10g), 11g/10g Data pump (expdp, impdp) and 9i Export Import

(exp, imp), shell scripts for hot/cold backups.

Excellent experience in designing OBIEE Dashboards, OBI Answers, and Analytics using Administration Tool of Oracle Business Intelligence Enterprise Edition on Top of Data Marts and Data warehouse.

Extensive experience in Data warehouse environments with Star Schema and SnowFlake Architecture.

Experience as On-Call 24x7 production DBA support, development DBA.

Managing team, achieve team and individual targets, addressing any issues of concern.

Strong in data (system) analysis, DBA support of phases of Software Life Cycle (design & development, implementation) in large-scale multi-user (systems) environments.

Strong experience in tuning database performance from system as well as query tuning perspective. Involved in optimizing SQL queries. Monitoring and optimizing the Performance of the database, tuning Management, Change Management, capacity planning, and SQL tuning. Expertise in Creating/troubleshooting/monitoring script, creation of log files, packages & development of scripts for SQL*Loader, Export, Import, PL/SQL.

Working experience with Very-Large databases (VLDB), data migration.

Worked on EMC Symetrix DMX, EMC CLARiON NAS devices, Hitachi, IBM, DMX SAN storage devices

Expertise in Managing Large Scale Projects.

Technical Skills:

Database: Oracle 11g/10g/9i/8i/8.x/7.X, SQL Server 2000/2005 Hardware: Sun Sparc E series, HP 9000, IBM RS6000, Compaq, EMC OS: Linux, Sun Solaris, HP-UX,Tru64 UNIX, IBM-AIX, Windows NT DB Tools : OEM, RMAN, Data Pump, Export/Import, SQL Loader, Oracle 10gAS, Oracle 9iAS,OID, 10/11g RAC/12c, Data Guard, Toad, 9i/10g/11g Data Guard, Oracle streams.

Miscll Tools : Veritas Clusters, Veritas NetBackup, Tivoli Data Protection, Cron Processes, Dameware, Secure CRT, Remedy, VCS, Hummingbird, Actuate reporting, Callidus True Comp Incentive Management System

Languages: SQL*Plus, PL/SQL, C, Unix Shell Scripting, Perl, csh, ksh, bash Education: B.E Mechanical Engg.

Certifications: Oracle Certified Professional (9i/10g) Database Administrator. Experience Details:

Employer: Next Generation Professionals, LLC, Los Angles, CA Client: HCL America, Milwaukee, WI July-2016 to till date Role: Lead Oracle DBA

Responsibilities:

Database refresh/replication from Production to Testing, Development, QA Environments using RMAN / Data Guard / Hot Back-ups and Schema level Exports / Data Pumps.

Installation & Configuration of Oracle 10g/11g RAC/12c.

Implemented Automatic Storage Manager (ASM).

Installed Oracle 11g Enterprise Server (11.2.0.3) and upgraded existing Oracle 10g databases to 11g version and from 9i to 10g.

Upgraded Oracle 9i to 10g and 10g to 11g.

Supported Operating Systems for RHEL, HP-UX & Solaris running Oracle database servers.

Extensive knowledge of PSU patching on Oracle RAC/Non-RAC Production/Non- production databases.

Implemented Oracle Data Guard 11g/10g (Logical and Physical) as Oracle’s data protection, High Availability and disaster recovery solution.

Providing backup and recovery strategies, setting up and implementing the backup & recovery procedures for Oracle9i/10g databases.

Databases upgrades from older versions to newer versions.

Good experience and hands on skill by working on physical and logical standby databases.

12c/11g/10g/9i/8i database performance tuning on AIX, SOLARIS AND LINUX boxes.

Setting up and managing RMAN, Hot and Cold Backups, Export/Import.

Interacting with developers in identifying the requirements and designing and implementing the database schema model.

Optimizing stored procedures and long running queries using indexing, hints, Business Logic/Requirements and query optimization techniques.

Upgraded Oracle database 9i to 10g, 10g to 11g and 11g to 12c.

Managing 12c/11g/10g/9i databases running on Veritas cluster (Active-Passive).

Providing backup and recovery strategies, setting up and implementing the backup & recovery procedures for Oracle9i/10g/11g/12c databases.

Provide Primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.

Capacity planning for all the Stage Servers (Performance Analysis, Storage Growth and Automatic Storage Management (ASM) and Grid) Controlling and monitoring user access to the database.

Extensively Used Explain Plan, SQL Trace, AWR, ADDM and ASH reports to Monitor Performance Tuning.

Downsizing, Defragmentation / Reorganization of DBs Using Export/ Import, Data Pump, cloning them using RMAN Duplicate features.

Created users, db links and grant privileges according to the requirements.

Create Database maintenance plans, including updating statistics, re-indexing, structure modification, index. Maintenance of system Documentation.

Implemented Oracle Data Guard 10g as Oracle’s data protection, High Availability and disaster recovery solution. Configured disaster recovery site with physical standby database for high availability using Oracle Datagaurd.

Performed Database Refresh in RAC Environment using transportable table spaces, expdb and impdb, on Solaris, Red Hat Linux and UNIX Platforms.

Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.

Mentoring the DBA team (on site & off shore) and imparting various DBA trainings helping in day to day activities.

Rendering 24*7 on call production DBA support.

Organization : TriCore Solutions, Norwell, MA Dec-2013 to Apr-2016 Designation : Principal Consultant Oracle DBA

Client: Handling multiple Clients (Wydot, GCC, LGH, Puma, sherwin-williams etc.) Role & Responsibilities:

Database Administration Activities:

Managing 4 node RAC setup

Installation & Configuration of Oracle 10g/11g RAC/12c.

Performing production installs and database patching.

Implementation of Oracle OEM agent.

Managing database performance using OEM 10g grid (10.2.0.4) and 12c.

Handling and monitoring materialized view replication using db-links.

Good experience and hands on skill by working on physical and logical standby databases

9i /10g database performance tuning on AIX, SOLARIS AND LINUX boxes

Running RDA and AWR to diagnose database performance issues 4

Employer: Next Generation Professionals, LLC, Los Angles, CA Client: Biogen, Cambridge, MA Oct-2011 to Dec-2013 Role: Sr. Oracle DBA

Responsibilities:

Performed load balancing on two client node & four client nodes RAC.Define services

(load balancing) in Oracle 10g RAC.

Installation & Configuration of Oracle 10g/11g RAC.

Implemented Automatic Storage Manager (ASM).

Installed Oracle 11g Enterprise Server (11.2.0.3) and upgraded existing Oracle 10g databases to 11g version and from 9i to 10g.

Installed & Configured Oracle 10g Grid Control for monitoring over 35 Prod / Non Production hosts.

Upgraded Oracle 9i to 10g and 10g to 11g.

Supported Operating Systems for RHEL, HP-UX & Solaris running Oracle database servers.

Extensive knowledge of PSU patching on Oracle RAC/Non-RAC Production/Non- production databases.

Implemented Oracle Data Guard 11g/10g (Logical and Physical) as Oracle’s data protection, High Availability and disaster recovery solution.

Providing backup and recovery strategies, setting up and implementing the backup & recovery procedures for Oracle9i/10g databases.

Database refresh/replication from Production to Testing, Development, QA, & ITG Environments using RMAN / Data Guard / Hot Back-ups and Schema level Exports / Data Pumps.

Databases upgrades from older versions to newer versions.

Maintaining 100 % SLA towards client’s response and actions/resolutions

Backup handling using hot and rman jobs.

Implemented new features of Oracle 11g like Automatic Memory Management, Automatic SQL Tuning, AWR Baseline Enhancements, Case Sensitive Passwords, Data Recovery Advisor, Database Replay, Query Result Cache, Read-Only Tables, Secure Files, SQL Access Advisor, and SQL Performance Analyzer.

Create Database maintenance plans, including updating statistics, re-indexing, structure modification,capacity planning and index analysis.Maintenance of system Documentation.

Database refresh/replication from Production to Testing, Development, QA, & ITG Environments using RMAN / Data Guard / Hot Back-ups and Schema level Exports / Data Pumps

Enabling monitoring.

Handling Streams and Propagations.

Database Cloning.

Performed Database Refresh in RAC Environment using transportable table spaces, expdb and impdb, on Solaris, Red Hat Linux and UNIX Platforms.

Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.

Mentoring the DBA team (on site & off shore) and imparting various DBA trainings .Helping in day to day activities.

Rendering 24*7 on call production DBA support.

Provide Primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.

Setting up and managing RMAN, Hot and Cold Backups, Export/Import.

Interacting with developers in identifying the requirements and designing and implementing the database schema model.

Optimizing stored procedures and long running queries using indexing, hints, Business Logic/Requirements and query optimization techniques.

Downsizing, Defragmentation / Reorganization of DBs Using Export/ Import, Data Pump, cloning them using RMAN Duplicate features.

Created users, db links and grant privileges according to the requirements.

Create Database maintenance plans, including updating statistics, re-indexing, structure modification, index. Maintenance of system Documentation.

Developed shell scripts and PL/SQL procedures and scheduled Cron jobs and DBMS_JOBS to monitor the database performance.

Mentoring the DBA team (on site & off shore) and imparting various DBA trainings

.Helping in day to day activities.

Rendering 24*7 on call production DBA support.

Employer: Next Generation Professionals, LLC, Los Angles, CA Client: BART (Bay Area Rapid Transit) Oakland, CA Apr-2009 to Sept-2011 Role: Sr. Oracle DBA

Responsibilities:

Installed Oracle 11g Enterprise Server (11.1.0.6.0) and upgraded existing Oracle 10g databases to 11g version.

Migrating data from SunOS sparc9 to Linux (RHEL 4 Nahant update 7).

Oracle streams setup global database level as well as Schema level between single- single instance, single-RAC instances, RAC-single instance and from RAC-RAC instances uni-directional.

Configuriing Streams for High Availability.Daily monitoring and troubleshooting of streams issues. Monitoring the status i.e. capture and apply rate and latency of streams.

Installed and configured Oracle OEM Grid control for monitoring over 80 Prod / Non Prod Hosts and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.

Configured, implemented, 10g RAC with ASM disk on Linux servers.

Did Extensive Performance Tuning of RAC Databases including Interconnect Tuning too.

Implemented Automatic Storage Manager (ASM) ASM on EMC SAN.

Performed Database Refresh in RAC Environment using transportable table spaces, expdb and impdb, on Solaris, Red Hat Linux and UNIX Platforms.

Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.

Capacity Planning for all the Stage Servers (Performance Analysis, Storage Growth and Automatic Storage Management (ASM) and Grid) Controlling and monitoring user access to the database.

Excellent experience in designing OBIEE Dashboards, BI Answers, and Analytics using Administration Tool of Oracle Business Intelligence Enterprise Edition on Top of Data Marts and Data warehouse.

Extensively Used Explain Plan, SQL Trace, AWR, ADDM and ASH reports to Monitor Performance Tuning.

Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.

Worked extensively with packages, SQL and PL/SQL codes in test and development environments.

Performed database Cloning to setup test and development database.

Writing Shell Scripts for the system and database for effective functionality and report generation.

Maintaining schemas and partitioning tables.

Provided ERD diagrams using the ERWIN tool and developed physical and logical models of the databases.

Rendering 24*7 on call production DBA support.

Environment: Linux (RHEL), Sun Solaris,sun4u sparc SUNW,Oracle (10g/11g),SQL server 2005,PL/SQL, SQL Scripting, UNIX Shell Scripting, STATSPACK, AWR, ADDM, ERWIN,TOAD, Enterprise Manager.

Employer: Next Generation Professionals, LLC, Los Angles, CA Client: T-Mobile, Bellevue, WA Nov-2007 to Apr-2009 Role: Sr. Oracle DBA

Project: Installation, Upgrade and Maintenance of Oracle Servers and migration of 9i to10g &10g to11g also settings up Oracle 10g RAC. Implementation of 11g new features & implementation of TDE, Configuration & setting of 10g Grid control, RMAN, 10g Flash back, ASM, Quest Shareplex and Schema Manager, Space Manager, VERITAS Clusters Failover, Net BackUP, EMC Time Finder/SRDF, Raid, Raw Devices, DSS, Quick IO, Installation set up of SQL Server 2000/2005, Oracle SQL Backtrack, Oracle Warehouse Builder, SQL Loader. OS: AIX 5L, HP-UX 11.0, Linux (RHEL), Sun Solaris, Tru64 5.1B, Windows NT. Hardware: IBM POWER5+ Servers, IBM RS/6000, HP9000, Sun E5000, Software: Oracle (9i/10g/11g), Pro*C, PL/SQL, SQL Scripting, Unix Shell Scripting, Unix CRON jobs, BMC patrol monitoring, AWR, ADDM, STATSPACK, DBArtisan, TOAD. Environment: Sun Solaris 9, Sun Clusters 3.2, HP-UX 11.0, Windows NT/2000/2003, VERITAS, Quick IO

Responsibilities:

Installed and configured 10g Real Application Cluster (RAC) and added 2 Nodes to make it a 6 Node RAC. Maintaining large OLTP databases on RAC Environment.

Added and relocated the OCR Mirror and Voting Disks to existing RAC Setups to prevent Single Point of failure and scheduled & tested their physical and logical backups.

Did Extensive Performance Tuning of RAC Databases including Interconnect Tuning too.

Configured installed & supported 10g RAC on Sun clusters 3.2

Implemented Automatic Storage Manager (ASM).

Implemented and Monitored streams in RAC environment.

Setup of Oracle two way replication using Oracle streams. Configuring Streams for High Availability.Daily monitoring and troubleshooting of streams issues.

Monitoring the status i.e. capture and apply rate and latency of streams.

Experience in Billing, Service Order, Workflow, Provisioning, and IDSS.f

Installed and configured Oracle Enterprise Manager (10g grid) to assist in managing databases, application servers and web servers.

Installed & Configured Oracle 10g Grid Control for monitoring over 50 Prod / Non Prod Hosts. Upgraded the Oracle 10.2.0.1 Grid Control Setup Including OMS, Database and Agent to version 10.2.0.4.Installed Intelligent Agent at target hosts. Migrated the OMS repository from 10.2.0.3 Grid Control to newly setup 10.2.0.4 Grid Setup Successfully to see the historical reports using new Grid Control.

Used Congos, RUP, Agile & database change management techniques to support Dev / Testing teams.

Upgraded Oracle 9i to 10g and 10g to 11g.

Migration of Oracle Databases from Linux to Solaris.

Supported Operating Systems for RHEL & Solaris running Oracle database servers.

Used Transportable Table Space (TTS) for migrating Data.

Implemented new features of Oracle 11g like Automatic Memory Management, SQL Tuning, AWR Baseline Enhancements, Case Sensitive Passwords, Data Recovery 7

Advisor, Database Replay, SQL Access Advisor, SQL Performance Analyzer Table Compression Enhancements, Tablespace Encryption, and Temporary Tablespace Enhancements to the Dev/TST/PROD environments successfully.

Implemented FGA (Fine Grained Auditing) as per Co. policies. Involved in Internal & external audits.

Used VPD for masking columns. Expertise in TDE implementation.

Used Transparent Database Encryption (TDE) to encrypt data stored on disk, encrypted columns in an existing table, created encrypted tablespace, regenerated the database master key.

Installation set up, configuration & implementation of Audit Vault 10.2.3.

Support Oracle Teams in Audit action plan tasks.

Involved in compliance reporting and Audit validation.

Installation & configuration of 10gAS for Single sign on (SSO).Well versed with OID/LDAP configuration & troubleshooting.

Installed & Configured Oracle application Server.

Involved in Risk Management analysis of DB systems.

Installed Version 5.1B-4 and prior Tru64 UNIX patch kits.

Implemented Oracle Data Guard 10g (Logical and Physical) as Oracle’s data protection, High Availability and disaster recovery solution.

Installation and Configuration of SQL server 2005 on windows server.

Implemented Log Shipping for hot standby in SQL server 2005 for High availability. Implemented 2 node clusters in SQL server 2005.

Designed data marts using Star Schema (Logical and Physical) Design. Performance tuning using Star Query hint. Added and deleted dimensions from Star Schema.

Involved with aggregation of fact tables. Helped the ETL transformation developers in tuning and scheduling. Helping report developers (Crystal Reports and Discoverer Users).

Worked with Oracle Warehouse Builder (OWB) and oracle workflow to design and schedule. Installed and upgraded patches from 10.2.0.1 to 10.2.0.2 and also managed OWB repositories, import export MDL files.

Providing backup and recovery strategies, setting up and implementing the backup & recovery procedures for Oracle9i/10g databases.

Installation, Upgrade and Configuration of Oracle Advanced Security Option (ASO).

Extensive Performance Tuning, Memory (SGA) Tuning, Locks and Latch resolution in DBBC and Shared pool. Monitoring and optimizing the Performance of the database using AWR/ADDM tools, Statspack & tkprof.Worked in conjunction with the development team to fine tune SQL and PL/SQL Code and evaluating and monitoring database to resolve performance issues including troubleshooting errors, recovering database and failures as needed.

Recovering the database from Block corruption, Objects-drop and using TSPITR.

Used Materialized Views (snapshots) for replication of data.

Monitoring logs, alerts, managing Batch Jobs (Alteration, Automation, Tuning, Failure)

Database refresh/replication from Production to Testing, Development, QA, & ITG Environments using RMAN / Data Guard / Hot Back-ups and Schema level Exports / Data Pumps.

Provide Primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.

Setting up and managing RMAN, Hot and Cold Backups, Exports. Migrated RMAN catalog to different server Purged 49 Terabytes of RMAN un-usable and obsolete backups using TSM and relieved huge space.

Interacting with developers in identifying the requirements and designing and implementing the database schema model.

Administering, maintaining, developing and implementing policies and procedures for ensuring the accessibility, integrity and security of all databases by strictly following the SOX -policies and procedures and documentation of every step.

Optimizing stored procedures and long running queries using indexing, hints, Business Logic/Requirements and query optimization techniques.

Using Data Transformation Services – ETL loads from Production to Warehouse environments.

Downsizing, Defragmentation / Reorganization of VLDBs Using Export/ Import, Data Pump, cloning them using RMAN Duplicate features.

Created users, db links and grant privileges according to the requirements.

Create Database maintenance plans, including updating statistics, re-indexing, structure modification, capacity planning and index analysis. Maintenance of system Documentation.

Developed shell scripts and PL/SQL procedures and scheduled Cron jobs and DBMS_JOBS to monitor the database performance.

Mentoring the DBA team (on site & off shore) and imparting various DBA trainings

.Helping in day to day activities.

Rendering 24*7 on call production DBA support.

HCL Infosystems Ltd., New Delhi (India) Sep-2005 to June-2007 Title : Provide Facilities Management of Database

Client : Easy Bill (P) Ltd. (A Hero Group Company) Duration : Sept 2005 to June 2007

O/S : Windows XP, Windows Server 2000/2003

Back End : Oracle 9i, SQL Server 2000.

Team Size : 7 members

Tools : EB operator, Easy operator, Correction Utility Validation Utility, Banking Utility.

Responsibilities:

Installation, and Configuration of Oracle 9i.

Setting up Hot and Cold Backups, Exports.

Responsible for monitoring and optimizing all database performance including the design, creation, and structural integrity of database objects in the production environment.

Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations. Configuring scripts for backups (hot, cold and incremental).

Installation, setup and configuration of logical and physical Database.

Planned, scheduled and assisted in implementation of infrastructure enhancements and upgrades, development, test, production.

Performing Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments.

Installation of MS SQL Enterprise servers on test and development boxes.

Interacting with Developers in identifying the requirements and designing and implementing the Database Schema.

Administering Oracle Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts,granting the privileges to users and groups.

Plan and Schedule the Online/Offline Backups.

Administering, maintaining, developing, and implementing policies and procedures for ensuring the accessibility, integrity and security of all databases.

Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups.

Automated processes using Cron jobs. Writing new stored procedures and modifying existing ones and tune them such they perform well. 9

Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.

De-fragmentation/Reorganizing of database using Export/Import.

Extensive Performance Tuning, Memory (SGA) Tuning, etc. Computer Partner, Noida (India) Dec-2003 to Sept-2005 Title : Vista

Client : WebCT Inc. (USA)(www.webct.com)

Duration : Dec 2003 to Sept 2005

O/S : Windows XP, Windows Server 2000/2003

Back End : Oracle 8i, 9i.

Team Size : 7 members

App. Server : Web Logic 8.1 SP4

Responsibilities:

Installation, Upgrade and Configuration of Oracle 8i, 9i EM.

Setting up and RMAN Hot and Cold Backups, Exports.

Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations. Configuring scripts for backups (hot, cold and incremental).

Performing Database Administration and Management activities in a safe, recoverable and professional manner that ensures the

Interacting with Developers in identifying the requirements and designing and implementing the Database Schema.

Administering the Oracle Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, granting the privileges to users.

Plan and Schedule the Online/Offline Backups.

Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.

De-fragmentation/Reorganizing of database using Export/Import.

Solving day-to-day problems, Trouble shooting.

Contact this candidate