We provide IT Staff Augmentation Services!

Oracle Dba Developer Resume Profile

Columbus, OhiO

Experience Summary

  • Expertise in installing, configuring and maintaining Standalone and RAC databases on various platforms.
  • 24/7 support for Production databases and responsible for round-the-clock database operations. Offered solutions for Production/Development of database applications and ensured customer satisfaction as the prior important.
  • Experienced in maintaining large Production, UAT, QA and DEV environments.
  • Over 9 years of Information Technology experience which includes Oracle Database Administration on 24x7 critical production and large databases of over 6-10 TB using Oracle 12c, 11g, 10g, 9i, 8i.
  • Strong experience in Oracle DBA tasks like Installation, creation, maintenance, performance tuning, problem identification, resolution and migration in production and development environments.
  • Creating new Oracle databases using DBCA or database scripts. Installing creating new ASM disk group or raw devices for RAC DBs.
  • Planned and Implemented DR High Availability oracle solutions using Data Guard, Streams.
  • Proficiency using Flash-Back Recovery, Automatic Storage Manager ASM Automatic Database Diagnostic Manager ADDM .
  • Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TK prof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR and ADDM.
  • Installation, maintenance and tuning of RAC Applications. Used rapid install and other Oracle Application maintenance utilities like OEM.
  • Installed Oracle 10g RAC software with ASM File systems.
  • Experience in installing and configuring APEX 4.2.5 and Listener Services ORDS from two different servers.
  • Experience in Installing Oracle 11gR2 Forms and Reports.
  • Hands-on Experience in installing and configuring 10.3.6 11g Oracle WebLogic server.
  • Experience in cloning the process of copying an existing Oracle installation to a different location and updating the copied bits to work in the new environment.
  • Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.
  • Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control OEM .
  • Involved and Configured Oracle 11g database instance running across two oracle RAC nodes on Red Hat Linux AS 4 Server.
  • Performed large batch jobs, and tuning of SQL queries and database systems.
  • Experience on installing 2012 SQL Server Microsoft Management Studio service pack 2.
  • Hands-on experience in configuring, creating Analysis Services SSAS and Reporting Services SSRS .
  • Experience in writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
  • Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
  • Worked extensively on Oracle Version Upgrading, Migrations and Patching.

Technical Summary

Database:

Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g, Oracle 11gr2, 12cR2, SQL Server, MySQL, SSAS, SSRS, Oracle10g, RAC.

Technologies:

Oracle Enterprise Manager OEM , Data pump Import/Export, RMAN, SQL Loader, Log Miner, VERITAS Net Backup, Erwin Data Modeller, Data Stage.

Operating Systems:

HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

Utilities

SQL Plus, SQL Net, PL/SQL, Import/Export, Stored Procedures, Triggers, UNIX Shell Scripting, Oracle Enterprise Manager, ASM, SQL-Navigator, DataPump, TKPROF, STATSPACK, DBMS SCHEDULER, Toad, VMware, Win SCP, Putty, Golden Gate.

Employment History

Confidential

Role: Oracle DBA Developer

Technologies: Sun Solaris 5.10 and Oracle 9i, 10g and 11gR1, 12cR2.

Responsibilities:

  • Backup Recovery using RMAN which includes hot backups and Cold backups.
  • Fail over and switch over between standby and primary databases.
  • Responsible for the installation, configuration of 9i and 10g, 10gR2 and upgraded from 9.2.0.1.0 to 9.2.0.8.0 and 10.2.0.1.0 to 10.2.0.3.0 and 10.2.0.1.0 to 10.2.0.4.0 on Sun Solaris.
  • Migrated from 80 box system to 80 box system with pairs of 2 DEV, UAT, Production, Disaster Recovery .
  • Responsible for Datacenter Migration from old Datacenter to new datacenter and Migrated and upgraded single instance database to multiple instance databases using export/import, data pump.
  • Configure Data Guard on both standby and primary for 45 production databases.
  • Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.
  • Expert in Installation, Configuration and Maintenance of Oracle Standby/Data Guard.
  • Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard Standby Database.
  • Oracle 9i/10g/11g/12c RAC, Standby Database, Clustering and Data Guard Setup, Automatic Storage Management ASM and Configuration and Tuning.
  • Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager OEM 12C cloud Control.
  • Experience in implementing 10g Data guard with one physical database.
  • Experience in configuration and administration of Data Guard Physical/Logical standby Databases .
  • Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
  • Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes.
  • Experience in Implementation of High Availability solutions with Oracle 10g 11g RAC, Physical Standby Databases Data Guard .
  • Experience with supporting the Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster RAC and Data Guard.
  • Experience in upgrading and configuring OEM Grid Control from 11g to 12c.
  • Experience in utilizing 11g, 12c Oracle Enterprise Manager OEM , Grid control to manage users, privileges, profiles, and schemas.
  • Hands-on experience in working with windows virtual machine and Oracle virtual machines.
  • Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
  • Hands on experience of database Backups and Recovery strategies using RMAN, Export Import Utility Classical Data Pump and Transportable Table spaces.
  • Hands-on experience in configuring, creating, processing of Analysis Services SSAS and Reporting Services SSRS .
  • Experience on installing 2012 SQL Server Microsoft Management Studio service pack 2.
  • Experience in installing and configuring APEX 4.2.5 and Listener Services ORDS from two different servers.
  • Experience in Installing and configuring Oracle 11gR2 Forms and Reports on Windows and Linux.
  • Hands-on Experience in installing and configuring 10.3.6 11g Oracle WebLogic server.
  • Installed RAC 11g on 3 node cluster for large production system and migrated the legacy system from Non-RAC environment to RAC 11g cluster database.
  • Installed and configured EM Central Grid control OEM Grid to administer and manage large number of databases and enterprise wide targets.
  • Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
  • Responsible for capacity planning, database security, recovery planning and installing patches
  • Configured Oracle on different Operating Systems for OLTP Data Warehousing environments.
  • Strong experience in configuration of RMAN, Planning and scheduling Backups using CRONTAB.
  • Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
  • Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK perfstat , SQL Trace, TKPROF.
  • Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database Memory Tuning, I/O Tuning .
  • Provided valuable inputs for various performance tuning issues.
  • Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning RAC .
  • Configured and implemented different types of Advanced Replication Models of distributed databases.
  • Implementation of high availability solutions with Oracle 10g RAC, Physical and Logical Standby database Data Guard , Materialized views, VCS, Streams Replication, Golden Gate.
  • RHEL 4.4, HP-UX, Windows 2000/2003/2007/2008r2/2012r2, Oracle 8i, 9i, 10g, 11g, and 12Cr2 Oracle 10g/11g RAC, SAP, Brtools, VM Ware, Data Guard, Oracle Enterprise Manager OEM , RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, ERWIN 7.2, Autosys, Golden Gate, SQL Plus, PL/SQL, SQL Loader.

Confidential

Role: Oracle DBA.

Technologies: Oracle 10g and 11g, Red Hat Linux.

Responsibilities:

  • Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
  • Responsible for capacity planning, database security, recovery planning and installing patches
  • Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
  • Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
  • Implemented and managed optimum physical database design tablespaces, datafiles, extents, redo logs, archive logs and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
  • Experience in Backup Recovery using RMAN which includes hot backups and Cold backups.
  • Monitoring Day-Day Backups, Log's recovering them as per the requirement. Utilized LOG MINER Technology applied Application Database Transactions on other Databases.
  • Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC
  • Worked on different types of storage structures SAN/NAS .
  • Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
  • Extensive experience in RMAN recovery testing and standalone database.
  • Experience in installation OWB and OWF.
  • Hands on experience on installing and upgrading Apex 3.2 to Apex 4.1.
  • Performed Database Refresh from Production to IST, UAT and Development databases.
  • Responsible for the installation, configuration and overall up from 10g/11gr1 to 11gr2 10.2.0.2 to 11.2.0.2 .
  • Experience with supporting the Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster RAC and Data Guard.
  • Experience in Implementation of High Availability solutions with Oracle 10g 11g RAC, Physical Standby Databases Data Guard .
  • Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes.
  • Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
  • Experience in configuration and administration of Data Guard Physical/Logical standby Databases .
  • Implementing 10g Data guard with one physical database.
  • Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager OEM 12C cloud Control.
  • Oracle 9i/10g/11g/12c RAC, Standby Database, Clustering and Data Guard Setup, Automatic Storage Management ASM and Configuration and Tuning.
  • Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard Standby Database.
  • Expert in Installation, Configuration and Maintenance of Oracle Standby/Data Guard.
  • Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.
  • Migrated from a 12 box system to 36 box system with pairs of 2 DEV, IST, UAT, Production, Disaster Recovery .
  • Migrated single instance database to multiple instance databases using export/import, data pump.
  • Installation and configuration of Oracle 11gR2 on Red hat Linux AS 5.
  • Involved in configuring two node RAC on 11gR1, oracle clusterware on Red hat Linux AS 5.
  • Databases migrated to RAC for improved resiliency and performance.
  • Security User Management, Privileges, Role, Auditing, Profiling, Authentication
  • Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
  • Knowledge in Golden Gate installation Configuration setups in both windows/Linux environments.
  • Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning RAC .
  • Provided valuable inputs for various performance tuning issues.
  • Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database Memory Tuning, I/O Tuning .
  • Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK perfstat , SQL Trace, TKPROF.
  • Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
  • Created indexes to facilitate easy user interface implementation and tuning.
  • Involved in construction of DR sites for all the Production and IST environments.
  • Installing and configuring Oracle WebLogic 11g application server.
  • Utilized Oracle Enterprise Manager OEM , Grid control to manage users, privileges, profiles, and schemas.
  • Oracle 11g/10g/11gr2 Oracle 10g/RAC, UNIX, Solaris 10, Apex 4.1, ODI, OWB, OWF TOAD, OEM, SQL, MYSQL PL/SQL, TKPROF, EXPLAIN PLAN, Data Guard.

Confidential

Role: Oracle Database Administrator.

Technologies: Oracle 9i and 10g RAC, Red Hat Linux.

Responsibilities:

  • Monitoring and supporting more than 40 databases.
  • Involved in configuring two node RAC on 11gR1, oracle clusterware on Red hat Linux AS 5.
  • Added node for the existing two nodes RAC.
  • Involved in construction of DR sites for all the Production environments.
  • Performed Database Refresh from Production to QA, UAT and Development databases.
  • Implemented and managed optimum physical database design tablespaces, datafiles, extents, redo logs, archive logs and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Extensive experience in RMAN recovery testing, RAC and stand alone database
  • Recovered huge Database 1 Terabyte when UNDO table space got corrupted in Real Application Cluster RAC .
  • Experience in setting up Oracle ASM storage for Oracle RAC databases.
  • Performed database replication through Golden Gate.
  • Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster RAC Databases
  • Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
  • Responsible for the smooth functioning of all ecommerce activities of the organization.
  • Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC
  • Successfully implemented Backup Recovery using RMAN which includes hot backups and Cold backups.
  • Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
  • Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
  • Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
  • Responsible for capacity planning, database security, recovery planning and installing patches
  • Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

RHEL 4.4, HP-UX, Windows 2000/2003, Oracle 9i, 10g, and 11g, Oracle 10g/11g RAC, ASM, Data Guard, Oracle Enterprise Manager OEM , RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, ERWIN 7.2, Autosys, Golden Gate, SQL Plus, PL/SQL, SQL Loader

Confidential

Role: Database Administrator.

Technologies: Oracle 9i and 10g RAC, HP-UX, Sun Solaris.

Responsibilities:

  • Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor ADDM , Automatic Workload Repository AWR for monitoring database performance.
  • Installed and setup 10g Oracle Enterprise Manager Grid Control 10.2.0.3 and Mass Agent Deployment on several hosts.
  • Created PL/SQL, SQL Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
  • Involved in designing data warehousing boundaries and parameters, Data Transformation, PL/SQL.
  • Experience in setting up Oracle ASM storage for Oracle RAC databases.
  • Data Modeling, Database Design and Creation using ER-Win.
  • Manage multiple MySQL databases used for storing records, payment, and customer relations data.
  • Installed Oracle Dataguard for Oracle Disaster recovery, High Availability and data protection.
  • Working Experience with Latest TOAD 9.6 having new features PLSQL SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents, LogMiner, Segment Advisor, Database Monitor, Server Stat's, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.
  • Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects database backup and recovery, monitoring and optimizing database performance.
  • Performed administrative maintenance, monitoring both Oracle and MS SQL Server database systems in a global 24x7 operational environment.
  • Implemented Oracle database backup recovery solutions using RMAN and Exports/Imports.
  • Performed large batch jobs, and tuning of SQL queries and database systems.
  • Created user accounts, roles and granting access permissions to the database.
  • Extensive Responsible in configuring and backing up database using RMAN for hot backups, cold backups and logical backups
  • Installed and Configured Oracle 10g databases on Linux.
  • Performed automated backups and scheduling using Perl scripting.
  • Involved in designing logical and physical data models using power designer.
  • Implemented Oracle Database 10g two node Real Application Cluster RAC on a Linux system
  • Installed and configured Oracle Enterprise Manager 10g Grid Control.

RHEL 4.4, HP-UX, Windows 2000/2003, Oracle 9i, 10g, and 11g, Oracle 10g/11g , ASM, Data Guard, Oracle Enterprise Manager OEM , RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, ERWIN 7.2, Golden Gate, SQL Plus, PL/SQL,SQL, SQL Loader

Hire Now