We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume Profile

Chicago-iL

Experience Summary:

Above 7 years of experience as a Database administrator, has hands on experience in database administration in multi RAC environment, RMAN for Backup and recovery, Data guard for Disaster recovery production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, patching, space management, and database security.

  • Excellent experience in Installation and configuration of Oracle 11g, 10g, 9i, on Operating Systems UNIX, Linux and Windows platforms.
  • Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager OEM , TOAD, Oracle SQL Developer in various versions.
  • Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
  • Good experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates CPU's in various environments
  • Experience in Auditing and Capacity Planning, Configuring Managing Hot Standby Databases Data Guard .
  • Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
  • Experience in using 10g/11g DATAPUMP, AWR, ASM, ADDM, Grid Monitoring Oracle Enterprise Manager OEM .
  • Performed In-place and Out-of-place patch set Upgrades
  • Implemented data transfer using Transportable Table Spaces TTS , Data Pumps and Export/Import utilities.
  • Experience of Oracle Golden Gate GG installation, configuration and troubleshooting Golden Gate EXTRACT and REPLICAT issues.
  • Experience in Real Application Cluster RAC environment with Auto Storage Management ASM .
  • Installed and Monitored Oracle 11g/10g RAC software and experienced on Performance Tuning on RAC.
  • Migrated NON-ASM databases to ASM using RMAN
  • Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.
  • Have experience in Oracle Support raising SR processes for technical requests through METALINK.
  • Install and configure Oracle GoldenGate and Veridata
  • Heterogeneous SQL Server and Oracle environments.
  • Architect GoldenGate 10.x and 11.x replication solutions to facilitate data flow between
  • Experience in various tools like OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility.
  • Hands on Experience in Space Management, Capacity Planning.
  • Creating Users, Roles and Profiles, Privilege management with role-based security.
  • Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required
  • Experience in SQL Tuning, Optimization, cost based optimization and Hints.
  • Proficient in Index REBUILDING and Index TUNING.
  • Experience in creating Documentation of Oracle database operations and capacity planning.
  • Expertise in PL/SQL, SQL and UNIX Shell Scripting Implemented UNIX Scripts using CRONJOB for Day-to-Day activities
  • Worked as a team member to provide 24x7 on-call production database support.
  • Have strong analytical, administration and problem-solving skills dedicated to maintain the high quality standards. Good communication skill, ability to work independently.

Technical Skills:

Operating systems

HP UX 11.11,11.31, Sun Solaris10,OEL 5,6 ,Redhat Linux, AIX,

Languages

SQL , PLSQL, Unix shell Programming

Databases

Oracle 12c/11g/10g/9i, Oracle 11g/10g Real Application Cluster RAC , ASM

Hardware/Machines

HP-UX, Intel Xeon, Sun Ultra Sparc, IBM AIX

Tools Utilities

EXP/IMP, OEM, RMAN,TKPROF, STATSPACK, AWR,ADDM, SQL LOADER, SQL NET, TOAD, SRVCTL, DBMS APIS, ORADEBUG, RACDIAG, RDA

Professional Experience:

Confidential

Role: Sr. Oracle DBA

Responsibilities:

  • 24x7 production support for several mission critical systems which utilize multiple Oracle 10g, 11g databases.
  • Administration of a 3 node RAC, configuring and monitoring daily BACKUPs, troubleshooting errors, to improve performance.
  • Upgrade and Migration of Databases from 11.2.0.1 to 11.2.0.3 and applying patches as per requirement.
  • Good experience in managing the databases using the OEM grid control like Scheduling Backups, Performance Monitoring, alerts setting, generating reports in seconds, email notifications, Black out instances during maintenance/down times etc.
  • Physical standby Data Guard configuration, Maintenance and support for DR activities
  • Worked on import/export, export data pump/import data pump and SQL- loader.
  • Cloning the databases for development and testing purposes.
  • Troubleshooting EXPDP/IMPDP errors in a RAC environment, configuring storage accordingly.
  • Managing, Troubleshooting and resolving oracle database, RAC and applications issues.
  • Installed Oracle 11g using OUI on 3 nodes RAC environment with ASM and OCR services.
  • In-place upgrade of a Oracle RAC Database from 11.2.0.2 to 11.2.0.3
  • Database level - Handling Performance Tuning Activity using OEM AWR/ADDM , Database space management, security Patches.
  • Performed the Upgrading of databases from 11.2.0.1 to 11.2.0.3.
  • Experience in taking daily/weekly hot backups and cold backups using RMAN.
  • Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
  • Oracle-to-Oracle replicated environments utilizing Golden Gate.
  • DDL replication using Golden Gate
  • Test initial Data Load option of GoldenGate during environment build
  • Oracle Database Performance Tuning and SQL Tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF etc.
  • Assisting the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
  • Implemented DATA GUARD Standby for high availability/disaster recovery purpose.
  • Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
  • Upgraded the data's from Existing Oracle 9i to Oracle 10g to 11g
  • Configure error handling for restart, logging, production support and status reporting in GG
  • Trouble shooting and performance tuning Golden Gate replications
  • Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues
  • Migrated database from ASM to Non-ASM using RMAN
  • Refresh the test and development databases from the source production databases on a regular basis using export/import utility
  • Configured database entries and Monitoring of all the databases using Oracle Enterprise Manager OEM 10g/11g grid control and TOAD.
  • Focused on separate Partitions like data loads, index creation and rebuilding, backup/recovery.
  • Configured ASM and suggested feasible workarounds for ASM Metadata corruption and Configured user log on load balancing and failover on RAC database.
  • Preparing cluster, configuring and Installation of Clusterware and Oracle RAC.
  • Implemented database auditing, data security and Remediate high-risk violation in production environment and Gathering schema stats and monitoring the index usage.
  • Creating and dropping of users, granting and revoking rights as and when required.
  • Management of table space growth, monitoring data files additions, extent growth.
  • Good experience in SQL, PL/SQL, Shell Scripting.
  • Experience in parameters tuning and setting them to best optimal value for better performance.
  • Researching errors/issues/bugs which were impacting the performance of the database and recommended permanent solution without losing the performance.
  • Installation, configuration and creating new test databases for production and development databases.
  • Applied High priority, security patches downloaded from Metalink.

Environment: Oracle 11gR2/10gR2 HP-Unix 11i 11.31, Oracle Enterprise Linux 5.2/6.4, RAC, ASM, RMAN, OEM, Windows 2008R2 Servers, Dataguard, DataPump, OEM, SQL Loader,Toad and SQL developer

Confidential

Role: Sr. Oracle DBA

Responsibilities:

  • 24 X 7 Production Oracle database support and administration.
  • Involved in the implementation of High Availability solutions with Oracle 11g/10g RAC.
  • Installation of Oracle cluster ware, ASM.
  • Configuring public and private network and VIP.
  • Added a new node to the existing cluster.
  • RMAN duplicate database cloning
  • Asm maintenance using ASMCMD
  • Backup and Recovery using RMAN with external tape backup system.
  • Multi database Recovery Catalog maintenance.
  • Actively involved in validation of the data files using DB Verify Utility. In order to solve block corruption Errors.
  • Golden Gate 11g Installation and configuration
  • Golden Gate troubleshooting using Log miner
  • Usage of Partitions to improve the query performance and manageability.
  • Involved in taking logical backup using Data pump and Exports/Imports Utility
  • Manages allocated disk space usage and memory allocations for Oracle and SQL Server database Management systems.
  • Golden Gate DDL and DML replication across Database
  • Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF etc
  • Good experience in SQL, PL/SQL, Shell Scripting.
  • Partitioning tables by determining the suitable methodology to improve performance and manageability.
  • Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
  • Having knowledge in troubleshoots problems to Oracle and SQL Server database products and interfaces.
  • Cloned/Refreshed Database environments to create patch, test, development and QA environments.
  • Monitored and effectively tuned the 10g database instances by utilizing own scripts, Precise In depth for Oracle and the Statspack utilities.
  • Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
  • Experience in installing Oracle and Sql server database products
  • Cloned environments to create patch test, development and QA environments.
  • Created scripts to monitor and manage the databases.
  • Recreated backup plans and scripts.
  • Performed hot, cold, tablespace level backups.
  • Applied High priority, security patches downloaded from Metalink.
  • Conducted multiple dry runs test runs to gather timings for production upgrades
  • Implemented database auditing, data security and Remediate high-risk violation in production environment.
  • Other activities like applying RDBMS patches, security patches, proactive monitoring of databases.

Environment: ORACLE 10g/11g, Oracle 10g/11g RAC, ASM, RHEL 4.x, SUN SOLARIS 10, HP-UX 11, AIX 5,Toad, SQL, PL/SQL, ERWIN, Dataguard, DataPump, OEM, RMAN, SQL Loader, Streams, Shell Scripting, SQL Server, Data Warehouse, OLTP.

Confidential

Role: Oracle DBA

Responsibilities:

  • 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
  • Performed DATABASE CLONING to setup test and development database.
  • Involved in Design and implementation of oracle 10g Dataguard both physical/logical standby databases
  • Involved in performing migration from Oracle 9i, 10g to Oracle 10g Release2 RAC database
  • Installed Oracle 10g RAC software with ASM OCFS2 file system.
  • Running ADDM reports to analyze top events and SQL statements and follow the recommendations to tune SQL statements.
  • Up gradation and migration from Oracle 9.2.0.8 databases to Oracle10.2.0.3.
  • Performed maintenance tasks on existing test and production environments that included modifying database sizes and migrating changes through various environments.
  • Setting up the PRIMARY and physical STANDBY database in the DATAGUARD setup.
  • Dealing with Performance issues of database objects, implementing CAPACITY PLANNING to ensure growth of the database.
  • Installed and Implemented BACKUP RECOVERY procedures. Implement HOT, COLD and Logical backup plans.
  • Constantly monitoring the performance of the databases and viewing Alert log files Trace files.
  • Managing various database targets using Grid control for efficient monitoring.
  • Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
  • Implementing automated backups with RMAN using crontabs.

Environment: Oracle 11.1.0.7/10.2.0.3/9.2.0.8, PL/SQL, RMAN, Datapump, SQL Loader, Sun Solaris, RedHat Linux, Windows.

Confidential

Oracle DBA

Responsibilities:

  • Review of Database logical and Physical design
  • Install, upgrade and maintain Oracle 10g, 9i on Sun Solaris and Windows 2003, Redhat4
  • Installation, setup and configuration of DATA GUARD
  • Performed Data Migration as a part of enterprise data warehouse project
  • Implementing Database Security, Management of role-based security
  • Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database
  • Extensive Performance Tuning, Memory SGA Tuning, Net backup, EMC Time finder and SRDF , RAID, RAW Devices
  • Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store
  • Write and modify UNIX shell scripts to manage Oracle environment
  • Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc.
  • Cloning databases using scripts as well as RMAN
  • Logical and Physical data modeling using ERwin, Dimensional/ OLAP Data Modeling, Relational/ OLTP modeling
  • Performed scheduling Control-m for scheduling jobs
  • Security User Management, Privileges, Roles, Auditing, Profiling, Authentication

Environment: Oracle 10g/9i/8i, OEM Grid Control , PL/SQL, RMAN, Datapump, SQL Loader, Sun Solaris, RedHat Linux, Windows.

Confidential

Oracle DBA

Responsibilities:

  • 24x7 Oracle Production Database Administrations.
  • Managing, troubleshooting and resolving oracle database and applications issues.
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • Working alongside programmers and contributing to the development process.
  • Planning and recommendations for optimum performance.
  • Extraction of data from flat files into Oracle Database using SQL Loader.
  • Defining and Setting backup and recovery procedures.
  • Responsible for SQL query tuning optimization. Performance tuning using tools such as SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF
  • Developing Hot, cold and logical backup scripts to automate the backup procedures.
  • Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
  • Written SQL, PL/SQL functions, procedures, packages and triggers.
  • Monitoring and managing the Storage Usage by Resizing Older Tablespaces, Creation of New Tablespaces and relocation of data files for better Disk I/O.
  • Writing Shell Scripts for managing day-to-day activities and automation of backup.
  • Optimal Space utilization in table space by avoiding fragmentation.
  • Usage of Partitions to improve the query performance and manageability.
  • Installation of Oracle RDBMS server software and version upgrades.
  • Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption .
  • Monitoring of database objects like rollback segments, temp segments and table spaces.
  • Automated the process of analyzing tables.

Environment: Oracle 10g/9i/8i, OEM Grid Control , PL/SQL, RMAN, Datapump, SQL Loader, Sun Solaris, RedHat Linux, Windows.

Confidential

Role: Oracle DBA

Responsibilities:

  • Installed and configured oracle 9i/10g databases.
  • Involved in PL/SQL Coding, Scripting.
  • Responsible for installing, upgrading and configuring the Oracle server.
  • Creating databases, objects, roles and privileges.
  • Partitioned large tables to increase the Performance.
  • Configured scripts to monitor activity with database.
  • Responsible for optimizing the queries and application tuning.
  • Implement Hot, Cold and Logical backup plans.
  • Creating tables, indexes, views and synonyms depending upon the need
  • Involved in Designing backup and recovery procedures for OLTP systems
  • Testing PL/SQL procedures against the test cases. Involved in creating use cases and test cases
  • Strong and extensive use of DDL and DML tools/ Maintained database schemas and dictionaries.
  • Optimized INIT.ORA parameters like DB block size, block buffers, shared pool.
  • Netca Configuration for Clients Connection.
  • Involved in Performance Tuning of SQL Queries
  • Worked as Support Database Administrator. Responsibilities include creation maintenance of table spaces, data files.

Environment: MS Server 2003R2, VmWare, Oracle 9i/10g, RHEL 4, SQL, PL/SQL,Shell scripting ,SQL Loader

Confidential

Role: Jr. Oracle DBA

Responsibilities:

  • Worked with a team of IT developers and peer-peer meetings in the Initial Database Design/Data Modeling/Data approval.
  • Database upgrade from oracle 9.2.0.8 to 10.2.0.1 using DBUA
  • Loading data from flat files into database tables using SQL loader.
  • Creating and maintaining triggers, packages, functions and procedures.
  • Created users and established the application security by creating roles.
  • Used Indexes and Hints for fixing the performance issues.
  • Troubleshooting the performance issues with the help of Explain plans.
  • Importing/Exporting data from/to different databases using utilities like SQL Loader.
  • Used TOAD for faster application design and developments.
  • Implement Hot, Cold and Logical backup plans using RMAN and Datapump tool
  • Creating tables, indexes, views and synonyms depending upon the need
  • Involved in Designing backup and recovery procedures for OLTP systems
  • Testing PL/SQL procedures against the test cases. Involved in creating use cases and test cases
  • Strong and extensive use of DDL and DML tools/ Maintained database schemas and dictionaries.
  • Optimized spfile parameters like DB block size, block buffers, shared pool.
  • Netca Configuration for Clients Connection.
  • Involved in Performance Tuning of SQL Queries
  • Worked as Support Database Administrator. Responsibilities include creation maintenance of table spaces, data files

Environment: Redhat Linux 4, Oracle 9i/10g, SQL developer ,RMAN,DBCA,DBUA,TKprof,SQLTrace, SQL, PL/SQL, Shell Scripting.

Hire Now