Oracle DBA

Location:

Minneapolis, MN, 55415

Salary:

$60/hr

Posted:

April 07, 2017

Contact this candidate

Resume:

Mani

+1-860-***-****

********@*****.***

Professional Summary

Over 8+ years of experience as an Oracle Database Administrator in the Database Installation, Development and Production System Support leading global teams in a wide variety of cutting edge environments.

Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, streams, partitioning, database security, troubleshooting, database design, Unix shell scripting, korn shell scripting and documentation.

Experience in OLTP/DSS database systems, managing large Oracle databases (VLDB) and data warehouse systems.

5 years of experience in Installation and Involved in Implementing RAC Database with 2, 3 and 4 nodes on Linux/Aix/Solaris.

Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.

Working as Principle Consultant mentoring junior dba's, took initiatives on new projects writing scripts and reviewing changes, Cloud Infrastructure, Cloud PaaS and SaaS Support.

Supporting different Oracle different databases and als using Oracle Enterprise Manager Cloud Control 12c running on top of WLS.

Wrote Applications which sits on oracle cloud using PLSQL, and TRIGGERS etc.

Strong experience with Oracle Databases (11g/10g), RAC on different flavours of UNIX.

3+ years of Proficient Experience supported by Data Guard for disaster recovery purpose.

Experience ensuring the high availability, integrity of databases & database designing.

Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA).

Create mappings between the fields in the source and target systems as well as identifying relationships within a source (implicit foreign keys, lookup tables, etc.).

Data sourcing, data mapping, data profiling, data mining, documenting data definition.

Work with functional business units to understand business processes and data flows to support

effective data integrations between systems.

Implemented Materialized views, database links. Regular database management on 9i and 11g OEM

Managing Oracle ASM File Access Control for Disk Groups.

Proficient in implementation of Oracle Streams in unidirectional table level (local capture).

Managed streams for data replication, data protection.

Work across multiple functional projects to understand data usage and implications for data migration.

Assist in designing, planning and managing the data migration process.

Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements.

Prepare data migration plans including migration risk, milestones, quality and business sign-off details.

Manage assigned risks and monitor potential impacts as part of the data migration plan.

Develop best practice, processes, and standards for effectively carrying out data migration activities.

Using Golden Gate 11g for testing purpose in the table level.

Configured database 10g, 11g for ORACLE FLASHBACK TECHNOLOGY.

Managed Materialized Views for data replication purpose.

7 years of strong experience in Hot/Cold Backup and Recovery.

Strong Experience in Cloning of databases using RMAN, User-Managed Backup.

Strong trouble shooting, problem solving, analytical and design skills.

Strong knowledge of database architecture design, including data partitioning and application partitioning.

Translating the logical data models to physical design and validate the SQLs (Adding PK's, triggers synonyms.

Very good experience in applying Patches (Patching), Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and runinstaller, also involved in Upgrading and Migration of a Oracle server to higher version available.

Experience with Installation, Configuration, Upgrades, Migrations, Administration and Patching of Oracle Databases and Oracle Applications.

5 years of Extensive Experience in Installing and Upgrading Oracle 9i/10g databases on production, test and development environments on Linux.

3 years of experience in Implementing Data Pump, Export and Import using transportable tablespace.

6 years of Extensive Performance Tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.

Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.

Strong skills in shell, perl and korn shell scripting to automate jobs.

Monitoring instance performance, tablespace utilization, database objects, connectivity and database availability, verification / validation of database backups, and server space availability and maintenance.

Experience in Troubleshooting oracle databases using sqltrace utilities.

Excellent Knowledge on Oracle Support processes for technical requests with Metalink.

6 years of proficient experience in SQL, PL/SQL, Perl Scripting, Shell Scripting, Korn Shell Scripting, Partitioning, Data modeling, Oracle Data Dictionary – meta data, Logical and Physical Database Design, Backup and Recovery procedures.

Experiencing in basic and advanced replication.

6 years of Experience in using OEM, TOAD.

3 years of Experience in Implementing and configuring 10g OEM Grid Control.

Creating and managing database objects such as tables, indexes, and partition tables, views, rebuilding indexes and optimizing the code to improve the performance.

Expertise in maintaining Database Security using auditing.

Expertise in loading data from flat files using external tables, SQL*Loader.

Proven ability to adapt to demanding schedules and changing priorities.

Very good experience in solving ORA-600, ORA-1555, ORA-7445 errors.

Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.

Result oriented, self-motivated, Team player, ability to work independently and within a team.

Ability to function successfully in a highly stressful, 24x7 mission critical environment.

Education

Bachelors of Science from Bhagwant University, Ajmer, India.

Technical Skills

Operating Systems

HP-UX 10.x, 11.x, Linux RHEL 2.1, 3.x, 4.x, Windows NT,XP,V

RDBMS

Oracle 12c/11g/10g, RAC 12c/11g/10g

Languages

SQL, PL/SQL, C, C++, Perl, Korn, UNIX Shell Scripting, Java

Tools

RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD, DATAGUARD, Golden Gate, ASM

Tuning Tools

AWR, ADDM, ASH

Database Modeling

Erwin 9.0/7.0, UML 2.0

Professional Experience

Master Card Nov 2015- Current

Minneapolis MN

Lead Oracle Database Administrator

RESPONSIBILITIES:

Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Red Hat Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.

Installation, Cloning, Configuration and Administration of Oracle 12c/11gR2 RAC.

Installed RAC on Oracle 12c/11gR2 and worked on ASM feature of Oracle.

Set up, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.

I worked in managing multi-terabyte databases like more than 10 terabytes in this project.

Upgraded Oracle Database from 10.2.0.4 to 11.2.0.3 to 11.2.0.4 to 12cR1.

Create mappings between the fields in the source and target systems as well as identifying relationships within a source (implicit foreign keys, lookup tables, etc.).

Data sourcing, data mapping, data profiling, data mining, documenting data definition.

Work with functional business units to understand business processes and data flows to support

effective data integrations between systems.

Implemented Materialized views, database links. Regular database management on 9i and 11g OEM

Experience ensuring the high availability, integrity of databases & database designing.

Creating and managing database objects such as tables, indexes, and partition tables, views, rebuilding indexes and optimizing the code to improve the performance.

Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).

Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.

Working as Principle Consultant mentoring junior dba's, took initiatives on new projects writing scripts and reviewing changes, Cloud Infrastructure, Cloud PaaS and SaaS Support.

Wrote Applications which sits on oracle cloud using PLSQL, and TRIGGERS etc.

Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication materialized views.

Work across multiple functional projects to understand data usage and implications for data migration.

Assist in designing, planning and managing the data migration process.

Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements.

Prepare data migration plans including migration risk, milestones, quality and business sign-off details.

Manage assigned risks and monitor potential impacts as part of the data migration plan.

Develop best practice, processes, and standards for effectively carrying out data migration activities.

Created and maintained immediate failover with up to the minute data to minimize the recovery time mission critical systems using oracle GOLDEN GATE (Testing Purpose).

Cloning databases using scripts as well as RMAN.

Set up backup and recovery procedure using RMAN and setup Autosys jobs.

Installed and Implemented Backup & Recovery procedures.

Implement Hot, Cold and Logical backup plans.

Created duplicate databases using RMAN duplicate.

Worked on TSPITR using RMAN.

Created and Configured Data Servers, Physical Schemas, Logical Schemas, Models, Interfaces and Packages.

Strong trouble shooting, problem solving, analytical and design skills.

Strong knowledge of database architecture design, including data partitioning and application partitioning.

Translating the logical data models to physical design and validate the SQLs (Adding PK's, triggers synonyms.

Troubleshooting the issues on Oracle Data Integrator establishment and replication setup.

Applied CPU/PSU patches for oracle database version 11.2.0.3.

Utilized SQL*loader and data pump import to load data into tables.

Refresh schema using Export/Import. Creating the database, tablespaces, tables, indexes, settings privileges and user logins.

Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms

Performance Tuning use of SQL diagnostic (ADDM, SQL Adviser) and Oracle utilities like AWR.

I have very good experience in MySQL.

Table Partitioning, creating Index Organized tables, Creating Locally managed Tablespaces.

I know how to solve these errors ORA-600, ORA-1555, ORA-7445.

24x7 production database support.

A self-motivated, responsible and reliable team player with a set of strong technical skills.

Excellent analytical, interpersonal and communication skills.

Enthusiasm in learning new technologies.

Environment: Oracle Server 12c/11g/10g, SQL, PL/SQL, RAC, RHEL6

Anthem Aug 2013-Nov 2015

Richmond VA

Sr. Database Developer/Administrator

RESPONSIBILITIES:

Converted a single instance database to Oracle RAC 10g and implemented 4 node 11g RAC on test environment.

Implemented Materialized views, database links. Regular database management on 9i and 11g OEM

Installation, Configuration and Administration of 4 node Oracle 10g RAC.

Installed and Upgraded Oracle 11g database from Oracle 10g database on test and development environments.

ASM and CRS installation and new database creation for 10g RAC.

Was involved in developing a disaster recovery (DR) plan and Stand by Database.

Setup of Standby database for faster disaster recovery and data guard setup for high availability.

Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.

Implemented Streams, Data Pump, Export & Import utilities on both 9i and 10g Databases.

Used RMAN for backup and recovery. Performed backup validations using RMAN.

Implemented and Involved in Hot, Cold and Logical backup plans.

Performed database cloning to setup test and development database.

Migration of Database from 9.2.0.6 and to 10.2.0.2.

Work across multiple functional projects to understand data usage and implications for data migration.

Assist in designing, planning and managing the data migration process.

Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements.

Prepare data migration plans including migration risk, milestones, quality and business sign-off details.

Manage assigned risks and monitor potential impacts as part of the data migration plan.

Develop best practice, processes, and standards for effectively carrying out data migration activities.

Involved and Implemented Database migration from Oracle9i to Oracle 10g.

Experience ensuring the high availability, integrity of databases & database designing.

Creating and managing database objects such as tables, indexes, and partition tables, views, rebuilding indexes and optimizing the code to improve the performance.

Create mappings between the fields in the source and target systems as well as identifying relationships within a source (implicit foreign keys, lookup tables, etc.).

Data sourcing, data mapping, data profiling, data mining, documenting data definition.

Work with functional business units to understand business processes and data flows to support

effective data integrations between systems.

Lead analysis and development work to support data integration between legacy systems and the new ERP system, including required interim data integrations for phased functional migration to the new ERP system

Lead data conversion, data cleansing, de-duplication, and data maintenance efforts during and after ERP systems implementation

Performed Database Administration activities such as Upgrades, Patches, TAR-Support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.

Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.

Proactive database monitoring using 10g grid monitoring tool.

Developer Environment Setup, Support, Cloning and Refreshes.

Strong trouble shooting, problem solving, analytical and design skills.

Strong knowledge of database architecture design, including data partitioning and application partitioning.

Translating the logical data models to physical design and validate the SQLs (Adding PK's, triggers synonyms.

Monitoring Stock Inventory levels and sales/invoice of various products using data modeling tool Erwin.

Used External Tables to Load data from flat files to database.

Implemented different Partition methodologies to improve performance and manageability.

Diagnose and troubleshoot Database problems and failures

Written Korn, Perl, shell scripts for digitization the process.

Load balancing, databases/schema/table re-organization for faster performance.

Installation of Oracle version 10g on Solaris, HP-UX and AIX boxes.

Database dot release upgrades using oracle universal installer and catpatch.sql

Rebuilding of Indexes

Conducting sizing & capacity planning for Oracle databases.

Upgraded Discoverer Administrator from older version to new for administrative tasks and also applied most recent patches.

Experience in reading Alert. Log and User trace Files and Diagnosing the Problem.

Scheduling jobs through Oracle job Scheduler.

Automation of Startup Shutdown on all Production and Development Database.

Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables, Cold Backups.

Used TOAD tool for querying and troubleshooting PL/SQL queries and codes.

Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby Serves.

I know how to solve these errors ORA-600, ORA-1555, ORA-7445.

Strong working experience in 24x7 Production database administration.

Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment.

Environment: Oracle Server 10g /9i, SQL, PL/SQL, Sun Solaris 9, HP-UX 11, Red Hat Linux 4.x

Intuit Inc. Oct 2011 – Aug 2013

Reno NV

Sr. Oracle Database Administrator

RESPONSIBILITIES:

Implemented 2 node RAC Database on Linux Operatin System.

Proficient with Standby Database, Data Guard and Replication.

Experienced in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.

Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.

Installed and supported OEM on Linux.

Creating and managing database objects such as tables, indexes, partition tables, views, rebuilding indexes and optimizing the code to improve the performance.

Create table spaces, tables, and users for custom applications.

Implemented and worked Streams, Data Pump, Export and Import utilities.

Experience ensuring the high availability, integrity of databases & database designing.

Implemented and Involved in local and downward streams.

Implement Hot, Cold and RMAN backup plans.

Implemented Materialized views, database links. Regular database management on 9i and 11g OEM.

Taking Backups on scheduled time and monitoring scheduled Backups.

Performed database cloning to setup test and development database on different operating systems.

Refresh/Cloning of Database and applications for development, testing.

Database patching using opatch.pl perl script.

Upgrading development and production databases to Oracle 9i to 10g.

Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions).

Experience in SQL tunning using STATSPACK, EXPLAIN PLAN and TKPROF.

Data refresh from production to test and development.

Installed and Configured Grid monitoring tool for Oracle 10g Database.

Good knowlede of Developer Environment Setup, Support, Cloning and Refreshes.

Used External Tables to Load data from flat files to database.

Implemented different Partition methodologies to improve performance and manageability.

Diagnose and troubleshoot Database problems and failures.

Conducting sizing & capacity planning for Oracle databases.

Perform SQL tuning and assist developers with coding PL/SQL

Performed PL/SQL querying and troubleshooting errors in queries using TOAD tool.

Write Korn shell scripts to monitor and maintain the Oracle database.

Write SQL scripts to monitor tablespaces and extent growth.

I know how to solve these errors ORA-600, ORA-1555, ORA-7445.

Resolve various application failures due to data entry errors or system errors.

Involves identifying problems and implementing corrective actions.

Providing Solutions to the Problem Faced by end Users Or Programmers

Automation of Startup Shutdown on all Production and Development Database.

Worked with team to support 24x7 production environments.

Environment: HP-UX 11, Sun Solaris 2.8/2.9 RHEL 4.x, PL/SQL

Hewlett Packard Oct 2009- Sep 2011

Columbia, SC

Oracle Database Administrator

RESPONSIBILITIES:

Responsible for administering and supporting production and development Oracle 9i databases.

Installation of Oracle on Linux.

Performed installations of Oracle 7x, 8i, 9i and SQL Server 2000 & 2005 databases.

Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.

Other duties include applying oracle database patches, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries, monitoring and optimizing database performance.

Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.

Perform SQL tuning and assist developers with coding PL/SQL.

Instance cloning done to create test and training environments.

Created PL/SQL procedures (jobs) to automate maintenance tasks.

Partitioned large tables to increase the performance.

Creating and managing database objects such as tables, indexes, partition tables, views, rebuilding indexes and optimizing the code to improve the performance.

Monitoring of database for growth and performance

Monitoring Database for fragmentation and correcting them.

Customization and development of Unix shell scripts and Perl Scripts.

Experience ensuring the high availability, integrity of databases & database designing.

Good Experience tranfering files by using ftp, sftp, scp and pscp.

Implemented and Involved in Partitioning strategies for very large tables.

Diagnose and troubleshoot Database problems and failures

Implementing range, list partitions, hash sub partitions.

Creating and refreshing materialized views.

Configured scripts to monitor activity with database.

I know how to solve these errors ORA-600, ORA-1555, ORA-7445.

Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle Server 8i/9i, SQL, PL/SQL, Linux/Unix, Solaris

Contact this candidate