We provide IT Staff Augmentation Services!

Senior Oracle Dba (consultant) Resume

Jersey City, NJ

PROFESSIONAL SUMMARY:

  • Over 20 years of extensive experience as an Oracle in Production, Test and Development Environments under UNIX /Windows Platforms.
  • Extensive experience in Database Software Installation, configuration, Upgrade, Migration, Capacity Planning, Estimation, Logical, Physical Modeling, RMAN Backup, Disaster Recovery Planning, Performance Tuning, User Management, Security, Audit and Troubleshooting.
  • Provided Support for Implementation, Upgrade and Evaluation of various New and Third Party Applications.
  • Monitoring and Optimizing the Performance of the Database, use of SQL diagnostic and tuning tools like Automatic Workload Repository AWR, Automatic Database Diagnostic Monitor ADDM, TKPROF, EXPLAIN PLAN, AUTOTRACE, and trend analysis.
  • Administrated very large Database of various Sizes - 10GB to 40TB.
  • Configured, Supported High Availability Oracle 11gR2/12C Databases with RAC or no-RAC, Data Guard.
  • Managed projects from requirement phase to implementation phase working with business analysts, infrastructure teams and outside vendors.
  • Installation, Configuration and Support of Oracle High Availability Solutions such as Standby Database with and without Data Guard Broker setup.
  • Designed and implemented various High end Oracle Exadata solutions for OLTP/DSS Systems.
  • Expert in analyzing database problems and providing innovative solution to the problems.
  • Excellent in system level and application level performance tuning performance tuning
  • Successful in meeting or exceeding customer expectations through detailed analysis and design, creative engineering and development, followed by efficient execution and delivery.

TECHNICAL SKILLS:

Database: Oracle 12c, Oracle 11gR2/10g, Oracle 9i/8i

Languages: SQL, PL/SQL, PRO*C, Shell Scripting, AWK

Tools: 12C Cloud Control, 11G Grid Control, Data Guard, RMAN, ASM, GoldenGate, ERWIN Designer. O/S AIX, Sun Solaris, Linux, Windows, Exadata

PROFESSIONAL EXPERIENCE:

Confidential, East Rutherford, NJ

Senior ORACLE DBA (Consultant)

Environment:

  • ORACLE 11g/12c, ORACLE 11g/12c RAC, ORACLE 12c RAC One Node, OEM Cloud Control, Data Guard
  • GoldenGate, PL/SQL, SQLPLUS, ASM/ACFS, Solaris and Linux.

Responsibilities:

  • Migration 11g databases to 12c Multi-tenant RAC or RAC One Node databases.
  • Applied quarterly patches for grid and database on 11gR2/12c.
  • Setup and implementation of Oracle GoldenGate Replicator with databases to Database Warehouse System.
  • Provisioning the coherence cluster with Oracle 12C Enterprise Manager.
  • Performed Oracle DataGuard broker configuration implementation as DR strategies.
  • Maintained high availability databases and implemented Disaster recovery plans using Oracle DataGuard/ RAC
  • Participated in many BCM tests by planning and implementing Dataguard switchover / failover using database flashback to avoid rebuilding standby databases after the testing.
  • Implemented advanced security for database and data redaction.

Confidential, Jersey City, NJ

Senior ORACLE DBA

Environment:

  • ORACLE 11g/12c, ORACLE 11g/12c RAC, OEM Cloud Control, Data Guard, RMAN
  • PL/SQL, SQLPLUS, GoldenGate, ASM/ACFS, Solaris and Linux

Responsibilities:

  • Support involves handling multiple Oracle 11g/12c RAC with Oracle Clusterware across various applications hosted in Oracle 10g /11g and 12C Databases across Linux and Solaris.
  • Provided Confidential 24x7 global supports for over 3000 databases.
  • Migration 11g/12c databases from New Jersey datacenter to Georgia 12c Multi-tenant cloud datacenter.
  • Installed patch set for grid and database to upgrade to 11gR2/12c
  • Support involves in designing, building and managing oracle RAC and ASM databases for high available system.
  • Installed and configured Oracle GoldenGate on 11gR2/12c for replication between databases
  • Convert EMC-based DR / BCV settings to Data Guard standby databases.
  • Implemented daily refresh DEV/QA databases from PROD using RMAN Active Database Duplication
  • Trouble-shoot database run-time errors and slow performance issues.
  • Recover database due to data corruption / loss or human errors.
  • Build my own Exadata on VM for testing environment.
  • Work with Patchmgr Process for applying and testing Oracle ExaData patches.
  • Hand on experience on commands Dcli, Cellcli, asmcmd, svrctl, crsctl etc..
  • Performed DR test RAC and Non-RAC environments using Data Guard broker.
  • Expert in setting up and troubleshooting DR solution using oracle data guard. Tested the oracle data Guard solution performing switch over process.

Confidential, Jersey City, NJ

Senior ORACLE DBA

Environment:

  • ORACLE 9i/10g/11g, 11gR2 RAC, OEM Cloud Control, DataGuard, RMAN, Exadata, GoldenGate
  • PL/SQL, SQLPLUS, SRDF, BCV, Solaris and Linux.

Responsibilities:

  • Supported critical application as trading system and fix income system.
  • Daily Database maintenance, monitoring and troubleshooting.
  • Implemented database security, managing users and their privileges.
  • DBA Administration on Exadata/Supercluster
  • Support involves handling multiple Oracle 11g RAC
  • Develop and maintain scripts for monitoring, troubleshooting and administration of the databases.
  • Write and maintain a DBA utility for a quick lookup of real-time database information as backup, table space, patches and file system.
  • Configuration and Maintenance of Oracle 11g Data Guard for Multiple databases for Disaster Recovery and Reporting Purpose.
  • Handling various backup and Recovery operations using RMAN and Shell Script.
  • Implemented BCV for database backups Refresh
  • Support GoldenGate replication, setup parameter for extract, pump and replicate processes.
  • Installed, setup and configured GoldenGate schema / Tables based replication.
  • Responsible for tuning database objects including datafile placement to resolve I/O contention, memory performance, SQL, PL/SQL and stored procedures statement tuning.
  • Involved and Worked on SAN Replications using SRDF Synch/Split for Cloning, Weekly Backup and Site Synch purpose.
  • Performed multiples of migration/upgraded from Oracle 9i/10g to Oracle 11g/12c Database with and without RAC Infrastructure.
  • Helped in Design, Implemented new Database Projects including Hardware Selection, Software Evaluation, Capacity Planning and Migration of Database between Different Instances
  • Working on BMC Remedy/DBsymphony/Service Now for Incident management and Change request.

Confidential, New York City, NY

Senior ORACLE DBA

Environment:

  • ORACLE 8i, ORACLE 9i, Oracle context, Oracle OEM, Oracle FailSafe,
  • Oracle Data Guard, Oracle RMAN, Oracle Partition, PL/SQL, SQLPLUS,
  • Linux, Window NT, Window 2000 and ERWin.

Responsibilities:

  • Responsible for database standards, policies and procedures.
  • Coordination implementation and project administration across multiple Application systems.
  • Performed Linux system administration roles with Dell hardware.
  • Developed procedure and functions using PL/SQL, SQL and Developed critical reports.
  • Data modeling database design and data loading strategy for loading a star schema Data Mart.
  • Data warehouse requirements study affinity analysis for a strategic framework based on business queries.
  • Developers maintained and enhanced the data warehouse and the data mart and provided production support for the daily ETL Extraction Transformation Loading process.
  • Created Oracle stored procedures, functions, packages, triggers, views, tables, indexes and constraints for the applications.
  • Responsible for tuning database objects including datafile placement to resolve I/O contention, memory performance, SQL, PL/SQL and stored procedures statement tuning.
  • Upgrade Oracle 8i to 9i.
  • Created primary databases and standby database(Data Guard 9i).
  • Implemented database security, managed users and their privileges, backup strategy, and tested failover implementation.
  • Responsible for Oracle Server/Client installation, configuration, and upgrade on Linux / Windows 2000/NT, configuration InterMedia (Oracle 8i) / Oracle Context (oracle 9i).
  • Design and implement backup methods and disaster recovery strategies.
  • Monitor database growth and provide database capacity planning for applications expansion.
  • Implemented Fine Grained Access Control database security.

Confidential . New York City, NY

Database Manager and Senior ORACLE DBA.

Environment:

  • UNIX(Solaris), VERITAS Volume Manager, Window NT, ORACLE 8, 8i
  • Oracle InterMedia, Oracle Replication, Oracle RMAN, Oracle OEM V2
  • Oracle Partition, EMC BCV, and ER Win V3.5.2
  • PL/SQL, SQL and PeopleSoft Tool 7.5

Responsibilities:

  • Management of corporation database along with supervisory tasks.
  • Managed DSS (Decision Support System) and OLTP (On Line Transaction Processing system) full life cycle projects.
  • Responsible for tuning SQL queries (using EXPLAIN PLAN and TKPROF) with indexes and hints.
  • Responsibilities included the definition of high level architecture, technology, configuration and capacity requirements to support any proposed data warehouse/data mart activity.
  • Responsible for the logical and physical architecture of a corporate wide data warehouse.
  • Used PL/SQL, SQL Loader, Transportable Tablespace as part of ETL process to populate the operational data store.
  • Created primary databases and standby database.
  • Responsible for design and implement Master-to-Master replication database.
  • Used Oracle InterMedia(ConText Option) for text search engine.
  • Work closely with the technical staff to manage, enhance, and maintain PeopleSoft finance and other database applications.
  • Provide client with 24*7 on call for production Peoplesoft administration support.
  • Designed, created and configured databases for PeopleSoft applications.
  • Capacity Planning, Database Performance Tuning, Memory Tuning, Application Tuning and Monitoring and Database Administration.
  • Managed application and database upgrade.
  • Backup and Recovery using both conventional approach and Oracle Recovery Manager (RMAN).
  • Developed a star schema data warehouse data model for the 10 million members E-mail system and partition and maintain the data warehouse.
  • Created Data Models and using ERWin.
  • Created SQL, PL/SQL and shell scripts for automation of daily tasks.
  • Implementing oracle new features to applications.
  • Develop and maintain scripts for monitoring, troubleshooting and administration of the databases.
  • Maintain data dictionaries to ensure system integration and consistency.
  • Identify application programs with performance problems, and make recommendations to technical staff to improve performance.

Confidential, Jersey City, NJ

Coordinator ORACLE DBA and Senior DataBase Analyst

Environment:

  • UNIX(Solaris), ORACLE 7.3, ORACLE 8, 8i, PL/SQL, SQL,
  • Oracle Web Server V3.0, Oracle ConText Option V2.3, ER Win V3.

Responsibilities:

  • PL/SQL and SQL generation of database reports Standardizing cooperate databases.
  • Coordinated implementation and project administration across multiple systems.
  • Configured, Installed and Upgraded the ORACLE servers
  • Upgraded Oracle 7 to 8 and 8 to 8i.
  • Installed Oracle Web Server V3 and Oracle ConText Option V2.
  • Implemented the snapshot replication database.
  • Created databases and database objects.
  • Maintaining backup and recovery databases.
  • Database maintenance, monitoring and troubleshooting.
  • Implemented database security, managing users and their privileges.
  • Monitored Database and application tuning.
  • Partitioned and archive the 5 million records table.
  • Replicating data to multiple databases.
  • Evaluated oracle features and oracle related products.
  • Created Data Models and used ERWin 3.5

Confidential, New York City, NY

ORACLE DBA and Senior Programmer Analyst

Environment:

  • Windows 95, ORACLE 7, PL/SQL, SQL, PowerBuilder V5, ER Win and Window NT.

Responsibilities:

  • Created databases and database objects.
  • Remodeling databases and refreshing data.
  • Maintaining backup and recovery databases.
  • Monitoring database performance, tuning and auditing.
  • Managed the size and I/O weights for tablespaces.
  • Converted the application system from SQL*FORMS V3 to PB V5.
  • Created Data Models and using ERWin.
  • Troubleshooting stored procedures and queries.

Confidential, White Plain, NY

Senior Programmer Analyst and ORACLE DBA. ( Consultant )

Environment:

  • HP-UNIX, MS Windows, ORACLE 7, PL/SQL, SQL, SQL*FORMS V4, V4.5
  • ORACLE REPORT V2, V2.5 and SQL*LOADER.

Responsibilities:

  • Creating databases and database objects.
  • Database logical and physical design.
  • Creating stored procedures and database triggers for the applications.
  • Redesigning the Parts Tracking System (PTS) which improved control over customer orders and returns, improved problem detection, reduced inventory carried and back order level, and improved existing security and control mechanisms.
  • Designed The Pricing System which improved control products price and price history.
  • Created the “1-800 # Consumer Reporting System” which analyzed the requirement of consumers and generated analytic reports.

Hire Now