We provide IT Staff Augmentation Services!

Sr Oracle Dba Analyst Resume

Brentwood, NY

SUMMARY:

Over 18 plus years of experience in the information technology industry with 15 plus years of experience in SR.Oracle Database Administration (DBA) / 5 +Years Project Tech Lead in Financial Industry, Telecommunication, Retails, Chemical Industry and Real Estates Information * Manage Production database maintenance activities, responsible for task assignment, developing and tracking to project plans, managing issues and team building. Expertise includes: 24x7 Production Oracle Database, Share point, 12C / RAC 11g, GRID control / Data guard * SAP ECC,BW,BI,GRC,CRM Oracle Databases (OLTP/VLDB TERA/EXA Data Base), Database Design (Physical & Logical), Data Modeling and database Migration, RAC Administration, Performance tuning, Disaster Recovery Solutions, RMAN, GRID Control, Capacity Planning for new and existing production systems, Oracle Utilities

TECHNICAL SKILLS:

Database: Oracle 12c/ 11G/10G/9i RAC, ORACLE 12c/11g/10g Grid 12c/11g/10g/9i MySql, SQL - Server, GreenPlum, Postgresql, HANA, mysql, noSQL

Tool: Big Data Hadoop HDFS, Cassandra/MongoDB/NOSQL, Green plum, AWS, SAP BRTOOLS / SQL BACKTRACK SQL Loader, EXADATA/RMAN, OEM GRID CONTROL/DB Control, DB2, OPEN VMS RDB, SQR, SQL SERVER, INFOMIX, Oracle Portal, UNIFY RDBMS,, SQL*Trace, TKPROF, ETL. TOAD, Oracle Application Server, JDA ODBMS Software, Confidential, EMC Storage, PostgreSQL, Golden Gate

Applications: Vendavo, MQ series, ORACLE EBS,ORACLE HRMS, PAYROLL & FINANCIAL, SAP 6.0/7.0 APO,ECC,BW,BI,GRC,CRM Applications Terra bytes Databases, SAP ECC (MM, PP, GL), ERWIN, SAP BRTOOLS RMAN, PL/SQL, SQL PLUS, SQL, C, SQL Net, ODBC, DATA WAREHOUSING / Informatica /ETL. PRO*C, DB2-COBOL, SHELL Script, PERL, ASP, HTML, VBScripts/Java, ABAP/4, WEB Application Servers, WEB Logic Servers, VISIO, PostgreSQL

O/S: HPUX, OPEN VMS/VAX, IBM-AIX, UNIX, LINUX Red Hat, WINDOWS NT/XP/7 EMC, Sun Solaris, NOVELL, NetWare, TCP/IP.

PROFESSIONAL EXPERIENCE:

Confidential, Brentwood, NY

Sr Oracle DBA Analyst

Responsibilities:

  • Managing Daily Database issues, Performance tuning, database maintenance activities,
  • Supporting and upgrading oracle 11g/12c & Installing RAC databases and Data Guard, DR, Creating High Availability,
  • Providing recommendations to developers/end users on the issues such as database design and application architecture, SQL/PLSQL Tuning
  • Coordinating with the application teams to diagnose and correct application database issues,
  • Issue escalation, managing the relationship between Data Management and other technical and business areas using 12 cloud control,
  • Database Migrations, performance tuning of Oracle 11g/12c, RMAN BACKUP
  • Data Encryption, Security, Manageability, Guard and Disaster Recovery, data privacy, data recovery, data maintenance, data integrity,
  • Space management, Formulate the requirements for a high performing database and apply experience in database tuning methodologies.
  • Supporting Greenplum DB, Oracle EBS, AWS Oracle Database, Migrating data to AWS Oracle DB

Environment: 12C /11g, Big Data Hadoop / Exadata, Greenplum, Data guard DR / HA, AWS, PostgreSQL,ORACLE EBS, 11g Share point, GRID CONTROL/OEM MS project, PRO*C,ETL, PL/SQL, SQL Loader, C, RMAN, SUN SOLARIS, Linux Read Hat, Windows NT, SAN, WEB Logic Servers, UNIX, LINUX, Shell Scripts KSH, ASP, FTP, MS Sql Server, HANA, mysql, noSQL, Multi-Tenant, In-Memory, RAC One Node

Confidential, Fort Washington, PA

Sr. Oracle DBA

Responsibilities:

  • Supporting and upgrading oracle 11g/10G RAC databases Data Guard, DR, High Availability
  • Assist in the day-to-day administration of all databases in production, Q&A and development.
  • Perform daily maintenance tasks, procedures and any other database tasks that require attention, Troubleshooting and resolving Golden Gate multi-master replication
  • Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues and any other issues affecting the database. This work can be done with 3rd party support teams and/or monitoring vendor.
  • Responsible for ON-Call Supports, managing Database issues & Golden Gate Performance tuning, database maintenance activities, Coordinating with the application teams to diagnose and correct application database issues, Issue escalation, managing the relationship between Data Management and other technical and business areas using OEM, Database Migrations, performance tuning of Oracle 10g/11g/12c,RMAN BACKUP, Oracle Data Vault, Data Encryption, Security, Manageability, Guard and Disaster Recovery.

Environment: 11g /10gRAC, ASM Data guard DR / HA, 11g/10g Share point, GRID CONTROL/OEM MS project, PRO*C, PL/SQL, SQL-Loader, Exadata, C, RMAN, ETL,SUN SOLARIS, Linux Read Hat, Windows NT, SAN, WEB Logic Servers, UNIX, LINUX, Shell Scripts KSH, ASP, FTP, Golden Gate

Confidential, Hopkins, MN

Sr. Oracle DBA

Responsibilities:

  • Supporting and upgrading oracle 11g/10G RAC/over 2500 databases, SAP Databases, Data Guard, DR, High Availability
  • Responsible for ON-Call Supports, managing Database issues, Performance tuning, database maintenance activities, Coordinating with the application teams to diagnose and correct application database issues, Issue escalation

Environment: 11g/10gRAC, ASM Data guard DR / HA, 11g/10g Share point, GRID CONTROL/OEM MS project, PRO*C, PL/SQL, SQL Loader, C, RMAN, SUN SOLARIS, Linux Read Hat, Windows NT, SAN, WEB Logic Servers, UNIX, LINUX, Shell Scripts KSH, ASP, FTP

Confidential, Mt. Laurel, NJ

Sr Oracle DBA - Development

Responsibilities:

  • Supporting 11g Databases/10G RAC for Development/ System Integration Environment
  • Tuning PL/SQL Procedures/Packages and SQL using Tkprof, Automatic Workload Repository, ASH (Active Session History),Explain Plan, SQL Plan Manager, SQL Tuning Pack, SQL Hint and Optimizer
  • Helping ETL developers and providing application development solution to Development Team and co-coordinating database development activities and support of large Data Warehousing and Business Intelligence related database applications.
  • Responsible for managing Database issues, Performance tuning, database maintenance activities

Environment: 10gRAC, ASM, 11g/10g SQL Plus, GRID CONTROL/OEM MS project, PRO*C, PL/SQL, SQL Loader, C, ETL, RMAN, SUN SOLARIS, Linux Read Hat, Windows NT, SAN, WEB Logic Servers, UNIX, LINUX, Shell Scripts KSH, ASP, FTP, PL/SQL Procedure Builder, ODBC, JDBC,TCP/IP, TOAD, MS SQL SERVER, DB2

Confidential, Philadelphia, PA

Sr. Oracle DBA / Teach Lead

Responsibilities:

  • Performed Tuning PL/SQL Procedures/Packages and SQL using Tkprof, Automatic Workload Repository, ASH (Active Session History),Explain Plan, SQL Plan Manager, SQL Tuning Pack, SQL Hint and Optimizer 10g and 11g
  • Completed two Oracle Database Upgrade/Migration project (from 9i to 10g)
  • 24*7 Production DBA support for over 100 SAP 6.0/7.0 (ECC APO,,BW,BI,GRC,CRM Applications ) Terra bytes Databases, responsible for managing 10g/9i Database issues, VLDB database design and configuration Performance tuning, database maintenance activities, Coordinating with the application teams to diagnose and correct application database issues, Issue escalation, managing the relationship between Data Management and other technical and business areas, Database Migrations, performance tuning of Oracle 10g .
  • Implemented RMAN backup with TSM, TDPO Backup server, OEM /GRID CONTROL/ Monitoring Using SAP BRTOOLS
  • Implementing 10g RAC / 11g RAC Databases for SAP ECC 7.0 Environment, Set up Audit Processing for System Security, Supporting SQL server 2005

Environment: 10g/11g RAC, OEM Grid / DB control, Vendavo Application, SAP R3 / SAP 6.0/7.0 ECC,BW,BI,GRC,CRM Applications, SQL Plus, SAP BRTOOLS / SQLBACKTRACK, server 2005, Ms project, PRO*C, PL/SQL, SQL Loader, C, RMAN, IBM AIX,TIVOLI TSM Backup server, SAP Data warehouse BW, Terra Data TDP WEB Logic Servers, DB2, Shell Scripts KSH, ASP, FTP, PL/SQL Procedure Builder, ODBC, JDBC,TCP/IP, MS Sql Server, OPEN VMS RDB

Confidential, New York, NY

SR Lead DBA / Project Manager

Responsibilities:

  • Designed and Implemented Oracle Disaster Recovery Solutions for Trading Applications
  • Designed and Implemented 10G RAC for Development Environment, Performed Tuning
  • Involved in Designing/Implementing COLOCATION/DATA Centers, daily and long term operation of all the database servers, supporting 24/7 Production Oracle databases.

Environment: 10gRAC, ASM, DATA GUARD, 9i/10g SQL Plus, GRID CONTROL/OEM Ms project, PRO*C, PL/SQL, SQL Loader, C, RMAN, SUN SOLARIS, Linux Read Hat, Windows NT, Hitachi SAN, Collocation/Data Center, WEB Logic Servers, UNIX, LINUX, Shell Scripts KSH, ASP, FTP, PL/SQL Procedure Builder, ODBC, JDBC,TCP/IP, TOAD, Sybase

Confidential, Parsippany, NJ

Sr Oracle DBA

Responsibilities:

  • Performed Tuning SQL using Tkprof, Automatic Workload Repository, ASH (Active Session History),Explain Plan, SQL Plan Manager, SQL Tuning Pack, SQL Hint and Optimizer 10g
  • RAC Installations, RAC database performance and tuning, Responsible for analysis, design, and implementation of database systems in support of Business and Infrastructure technologies Database Migrations, performance tuning of Oracle 10g (RAC) on Linux using GRID CONTROL/OEM,RMAN BACKUP

Environment: RAC Oracle 8i/9i/10g, DataGaurd, SQL Plus, OEM, GRID-CONTROL,Ms project, PRO*C, PL/SQL, SQL Loader, C, RMAN, SUN SOLARIS, AIX, Linux Read Hat, Windows NT, EMC Storage, Data Warehousing /ETL, WEB Application / Servers, WEB Logic Servers, UNIX, LINUX, Shell Scripts KSH, ASP, FTP, PL/SQL Procedure Builder, ODBC, JDBC, SQL Net/Net 8, TCP/IP, TOAD, Sybase, Perl, DB2

S R. ORACLE DBA

Confidential, Middletown, NJ

Responsibilities:

  • Air Products serves customers in industrial, energy, technology and healthcare markets worldwide with a unique portfolio of atmospheric gases, process and specialty gases, performance materials, and equipment and services
  • Managed the Database Migration and Software Installation for Vonage Voice Data application. Installed Oracle on Confidential Cluster
  • Administered over 100 Oracle databases, totaling 25TB size
  • Responsible for 24x7 supporting Production 5.7 Confidential Database / QA / Development Databases on Sun Solaris, AIX, Linux Read Hat and Windows NT
  • Responsible for 24x7 supporting Production Confidential Database / QA / Development Databases, Cloning Database, Testing Backup, Creating Standby database using Data Guard, HOT Standby (Physical Standby) Logical Standby, RMAN, Performance tuning. Capacity Planning Using OEM, Data conversion / Migration, Database backup and recovery Partitioning.

Environment: Oracle 8i/9i/10g, DataGaurd, Confidential Database Environment, SQL Plus, PRO*C, PL/SQL, SQL Loader, C, RMAN, SUN SOLARIS, AIX, Linux Read Hat, Windows NT, Data Warehousing / ETL Confidential Cluster Java, WEB Application Servers

Hire Now