We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

Minneapolis, MN

SUMMARY

  • Over 7 years of experience as an Oracle Database Administrator in providing 24X7 production and development support for 11g/10g/9i/8i/7.3 databases on different platforms like HP - UX, SUN SOLARIS, AIX, Red Hat Linux and Windows
  • Professional with over 7+ years as Oracle Database Administrator (DBA) on Operating System viz. Sun Solaris, HP-UX, IBM AIX, Red Hat Linux and Windows 2000/NT Server in 24x7 Production. Administrations of ORACLE SERVER on Production, Test and DEV Environment.
  • Proficient experience and a track record of delivering quality solutions for enterprise level distributed systems.
  • Expertise in all stages of Software Development Life Cycle (SDLC) including Requirement Analysis, Design, Implementation, Integration, Testing, Deployment and Post Development Maintenance in Agile Methodologies.
  • Experience in creating data flow-diagrams including Class diagrams, Interaction diagrams, State diagrams and Deployment diagrams.
  • Extensive knowledge in Banking, Automotive, Production Control, Insurance and Marketing domains.
  • Expertise in leading the teams for maintenance of 24 X 7 high-availability applications.
  • Expert in Architecture of Oracle Databases 11g, 10g, 9i, 8i with objectives of saving costs and time.
  • Strong knowledge and experience of managing Oracle 9i,10g and 11g RAC environments using the OEM GridControl tools and Oracle GoldenGate.
  • Experienced in using 11g features Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid Monitoring and Recycle Bin.
  • Strong experience in supporting development, unit test, system test, Integration test, certification test, production databases under almost all flavors of UNIX (Sun Solaris, IBM AIX, HP UX Red Hat).
  • Expertise in cloning using RMAN Duplicate DB and hot backups to create Test, QA, DEV Instances.
  • Experienced in features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
  • Expertise in applying Oracle Database patches using OPatch Utility.
  • Experience in Upgrading databases from different platforms.
  • Experience in configuring Oracle BI Discoverer 10.1.2.
  • Experience in Managing/working/converting oracle GoldenGate databases.
  • Created the Scripts for the migration from old system to new system.
  • Oracle Cluster ware installed to provide infrastructure for RAC and configured 3 node Oracle 10g RAC with ASM.
  • Load data from OLTP systems into data warehouse databases.
  • Installed and configured the oracle10g RAC on RED HAT Linux AS4 and have migrated 8 databases in different platforms to same single centralized database server.
  • Expertise in Database Space Management, Memory Tuning and Application Tuning.
  • Expertise in troubleshooting and performance tuning.
  • Experience in implementing 10g Grid monitoring application to monitor the Oracle Applications and Database.
  • Experience in creating and managing Standby database using Data guard.
  • Expertise in Backup and Recovery activities using RMAN utilities.
  • Excellent work experience in developing applications using ORACLE SQL Scripts, PL/SQL, Shell Programming.
  • Expertise in Oracle Data Guard, Cloning of Database.
  • Involved in supporting the SOX teams by providing the necessary data and execute task for SOX compliance.
  • Expert in configuration of 11g RAC, 10g RAC, 9i RAC on Linux and Solaris using ASM, RAW devices and Oracle CRS.
  • Up gradation and Migration of Database from 10g to 11g and applying patches whenever required.
  • Expert in configuration of Hardware Clusters Environment.
  • Proven experience with mission critical databases high availability and disaster recovery environments configuration in 24*7 environments using 9i Data Guard, 10g Data Guard with real time apply.
  • Extensive experience with AWR, ADDM, ASH STATSPACK, ORADEBUG, HANGANALYZE, PSTACK, TRUSS.
  • Extensive experience with DBMS API’S and V$VIEWS, TOAD, Quest Spot Light, BMC Patrol and 10g Grid.
  • Installation, Configuration and deployment of Oracle 10g database with Real Application Clusters (RAC) on multi nodes.
  • Worked extensively with configuring database backups in RMAN environments using TSM, Networker, Netbackup and Commvault backup utilities.
  • Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases.
  • Extensive experience with proactive monitoring the databases using 10g Grid Control Monitoring.
  • Experience in installation and configuration of GoldenGate11g to support data replication in Oracle Database environment.
  • Experience in installing and configuring GoldenGate 9.5.
  • Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems.
  • Experienced in utilizing Goldengate replication technology for ORACLE Upgrades.
  • Expertise in using GoldenGate to support data replication in the Oracle database environment.
  • Exposure to MS SQL Server 2005 Installation, Configuration, Maintenance, Backups & Restores, Security Management, DTS import/export, Performance Tuning.
  • In-depth knowledge of SQL (DDL, DML, and DCL), and PL/SQL and experience in writing stored procedures, packages, functions, and triggers.
  • Expertise in Replication of Oracle Databases using Logical Standby and Streams and Shareplex.
  • Very good experience and sound knowledge with Oracle 10g/9i/8i Installation, Administration, Monitoring, Performance Tuning, Database Backup and Recovery.
  • Experience in major databases such as Oracle 8i, Oracle 9i, Oracle 10g, AS 400, Sybase, SQLServer 2005 and MySQL.
  • Strong Object Oriented Analysis (OOA), Design (OOD) and Programming (OOP) skills.

TECHNICAL SKILLS

Operating Systems: Unix, AIX 4.3, AIX 5.3, Red Hat Linux RHEL 3, RHEL 4, RHEL 5, Fedora, Ubuntu, Solaris10,9,8, HP-UX. Windows (NT 4, 2000/2003 Prof/Adv Server, XP Professional)

Databases: Oracle 11g/10g RAC/9i/8i(ExaData 11g), Microsoft SQL Server 2005, 2008

DB Utilities: SQL Navigator, SQL*Loader, Sql*Plus, Real Application Testing, 10g OEM, Grid Control, RMAN, DBCA, DBUA, 10g Data Pump, Toad, Data guard, Export / Import, TKPROF, Statspack, ASM CMD.

Scripting: Shell Scripting Korn & Bourne, PERL

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR / ADDM / ASH, TOPAS.

Tools: Oracle Enterprise Manager, TOAD 8.5, SQL Developer, Putty, F-Secure Client, Hummingbird, SQL*PLUS, iSQL*Plus, Cute FTP, Smart FTP 1.0, ERWIN 4.14, SQL- Navigator, ERWIN, GoldenGate, MS Visio, Database Replay, LogMiner and Flashback data Archive, Apache Tomcat, Eclipse.

Languages: SQL, T-SQL, PL/SQL, C,C++, XML,HTML, Data modeling, Erwin, core java

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr. Oracle DBA

Responsibilities:

  • 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution for multi-terabyte database issues during Pre & Post GO-LIVE period.
  • Performed day-to-day DBA jobs for managing over 200 Prod/Dev databases.
  • Configured and Administered Oracle 11g RAC high availability on ASM using EMC & NETAPP as storage.
  • Multi-node RAC configurations, database creations & RAC database conversions
  • Experience in installation and configuration of GoldenGate11g to support data replication in Oracle Database environment.
  • Experience in installing and configuring GoldenGate 9.5.
  • Used GoldenGate to move large volumes of data between oracle servers with minimal impact to online systems and performing GoldenGate on process of extract and replication of single instance as well as RAC Databases..
  • Involved in Upgrade/Migration of the oracle databases from Oracle 10g to Oracle 11g and Sun Solaris to OEL (Oracle Enterprise Linux).
  • Upgraded the Databases and clusters from 10.2.0.1.0 to 10.2.0.4.0.
  • Configured DATA GUARD to provide high availability by implementing physical stand-by database and worked with various Oracle 10g features: Streams, 10g Grid Control and Automatic Storage Management (ASM).
  • Performed Roll Forward a Physical Standby database with RMAN incremental backup when Standby is out of Sync.
  • Responsible for installing and configuring Golden Gate 9.5 on Oracle Servers
  • Responsible for upgrading Golden Gate 9.5 to Golden Gate 10.0.
  • Performed Initial load, extract, replica, trial files and exporting data onto Repository Database using Golden Gate tool
  • Built Physical Standby Data Guard for production databases.
  • Designed and implemented Oracle Real Application Clusters (RAC) on Solaris for an OLTP application with Transaction Application Failover and high transaction volume
  • Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand-alone instances.
  • Perform database cloning/exp/imp to setup identical databases in the production and development environments.
  • Creating and managing table spaces with different block-sizes to prevent row chaining and row migration.
  • Performed regular DBA activities including space management and performance monitoring.
  • Implemented Shell scripts to Purge the log, trace, audit files on Prod, Dev servers.
  • Implemented Backup & Recovery procedures using RMAN, Hot/Cold Backups
  • Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, and STATSPACK etc.
  • Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and to see if these queries can be fine-tuned for better performance.
  • Applied various GRID and Database Bug Patches for Oracle 11g R2 GRID/RDBMS.
  • Data loading using Oracle SQL Loader, developing SQL Loader scripts to load global data, and fine-tuned SQL Loader performance using Direct-load mechanism.
  • Performed Security Patches, Proactive monitoring of databases.
  • Provide database support during monthly & quarterly releases.
  • Developed scripts and reports using SQL, PL/SQL and Perl.
  • Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases.
  • Upgraded Prod, Dev and Test instances from 10g (10.2.0.2) to 11g (11.2.0.1/11.2.0.2 ).
  • Maintain and periodically test backup and recovery process for Oracle databases for Disaster Recovery readiness.
  • Designing and implementation of database backup/restore methodologies troubleshooting performance and networking issues. Basic OS system administration.

Environment: Sun STOREDGE 6140, 6130, 3500, Red Hat Linux x86, EMC Storage, VERITAS Net backup, Solaris 10, 9, 8 AIX 5.2, 5.3 BMC Patrol, SUN SPARC, Dell Power edge, 11g OPS center.

Confidential, MA

Sr. Oracle DBA

Responsibilities:

  • Part of a 6 member DBA team which was involved in the maintenance of the Oracle 9i/10g/11g database for the Production as well as the development environments.
  • Implemented Oracle RAC with Data Guard implementation for disaster recovery.
  • Managing, troubleshooting and resolving oracle database, RAC and applications issues.
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • Performed Oracle Database upgrades from 10.2.0.2 to 10.2.0.3 in AIX RAC environment.
  • Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.
  • Implemented Golden Gate for Standby Configuration and developed procedures for Replication.
  • Partitioned of large tables and indexes to improve performance, availability, creating and rebuilding the Indexes, database reorganization to improve performance of the queries and the database.
  • Performed capacity planning, space monitoring like table space growth, ASM disk space.
  • Implemented Shell scripts for purging old partitions on the history tables on different schemas as per the requirement.
  • Developed PLSQL package to implement the Data compression.
  • Restored & recovered production reporting and SIT databases from hot backup using RMAN.
  • Implemented centralized backup (hot) and recovery strategy for all the databases using shell scripts, SQL scripts and cron job.
  • Planning and implementing Backup and Recovery procedures (Hot Backups, and RMAN), scheduling daily backups and performed periodic recovery tests.
  • Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
  • Involved in Capacity Planning, Hardware configuration for Oracle 10g RAC Environment.
  • Installing 10g and 11g databases on SUN SOLARIS/AIX/HP-UX.
  • Automated several scripts to monitor various processes, sessions and taking back up’s using crontab.
  • OS level activities like space monitoring of Mount point and relocating data files for better disk I/O.
  • Data replication between units has been done.
  • Responsible for setting-up and managing Standby database using Data guard for DR sites.
  • Responsible for upgrading Golden Gate 9.5 to Golden Gate 10.0.
  • Logical backups were scheduled for Development, QA and UAT databases using export/import and Data Pump.
  • Interacted with system and storage administrators, data modelers, developers, application owners for gathering the required information and resolving various issues.
  • Monitoring and troubleshooting space related issues.
  • Creating and refreshing materialized views & performing SQL*loader jobs for data loading.
  • Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
  • Perform Space Management & Troubleshooting the database issues

Environment: HP Integrity Superdome Sx2000 chipset, 32 processor, 1TB, Solaris Fire 440,IBM z/OS 1.12, Fire 880, Oracle 9i/10g/11g, HP Integrity rx 8640, RHEL AS 5, SQL * Plus, OEM, Erwin Data Modeler.

Confidential, Miami, FL

Sr. Oracle DBA

Responsibilities:

  • Created scripts to load data from production databases to report data warehouse databases.
  • Providing 24x7 on call support for the business critical production RAC databases.
  • Migration of Database from 9i to 10g and applying patches whenever required.
  • Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose
  • Cleaning the ORACLE HOME files system by cleaning the log files, alert log file and listener.log files.
  • Developed solutions, PL/SQL procedures, scripts dealing with schemas such as tables, indexes, partitions, views, triggers, for daily production and performance.
  • Migrated the table spaces from file system to ASM.
  • Implemented Backup and recovery strategies using export/import, RMAN and online backups.
  • Wrote shell scripts to implement periodic security management on the production databases
  • Developed scripts to proactively monitor the databases and alert the DBA on events such as running out of extents, disk space and actively involved in Shell Scripting for various CRON jobs to be run.
  • Developing programs for automating the execution of Hot, Cold and RMAN backups and recoveries.
  • Database cloning from Production to Test and Development environments
  • Create table spaces, tables, and users for custom applications.
  • Configured the Hardware to install the Sun Solaris and oracle 9i software. Created multiple database instances for HA environment. Applied the updated latest patches to oracle and sun Solaris.
  • Upgraded the database 10gR1 to 10gR2 and applied database patches using opatch utility.
  • Implemented Real Application Clusters (RAC) setup, configuration and cluster interconnection of 5 instances with server side load balancing using Automatic Storage Management (ASM).
  • Tuned the multiple databases for Performance. Involved in security audit of databases and servers.
  • Load data from OLTP systems into data warehouse databases.
  • Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, ISOSTAT and TOP.
  • Implementing oracle securities as per the company standards.
  • Supported migration of a database from Sun Solaris to AIX.

Environment: Oracle 8i, Oracle 9i (9.0.1.2.0 & 9.2.0.4.0) 10g (10.2.0.1), AIX 5.2, 5.3 RS6000, Solaris 3500, Solaris 10k, Dell 5560 with Xeon Processors.

Confidential

Oracle DBA/Developer

Responsibilities:

  • 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
  • Installed and configured Oracle RDBMS on UNIX and Windows environments.
  • Involved in configuration and implementation of hardware and software installations for oracle 8i, 9i.
  • Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
  • Involved in upgrade of Oracle databases from 8.1.7 to 9.2.0.3
  • Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
  • Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
  • Implement Hot, Cold and Logical backup plans.
  • Designed backup and recovery procedures for OLTP system.
  • Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
  • Data loads using SQL loader.
  • Experience in space management
  • Experience in schema management and monitoring alert log of various databases
  • Automation of startup shutdown on all production and development databases.
  • Configured the Hardware to install the Sun Solaris and Oracle 9i software. Created multiple database instances for HA environment. Applied the updated latest patches to oracle and Sun Solaris
  • Partitioning Tables by determining the suitable methodology to improve performance and manageability.\
  • Applied patches, keeping applications software bug free and improving data integrity.
  • Checking Alert logs, Archive logs, and Trace files.
  • Creating and managing users, roles and profiles, auditing and monitoring databases and user access.
  • Activities like applying RDBMS patches, security patches, proactive monitoring of databases.
  • Knowledge of using EXP and IMP utilities.
  • Troubleshooting DB related issues and providing scripts for taking regular backups.
  • Estimated current and future requirements in terms of storage and other resources including capacity planning.

Environment: Oracle 8i/9i OEM, Linux, HP-UX, TOAD, STATSPACK, TKPROF, UTL SMTP, EMC ERWIN, SQL*LOADER

Confidential

Oracle DBA/Developer

Responsibilities:

  • Development of various front-end modules using PowerBuilder 4.0.
  • Developing PL/SQL programs for backend processes.
  • Developing and performing unit and integration tests.
  • Testing and debugging.
  • Involved extensively in development of PL/SQL Packages, Stored procedures, Triggers, and fine-tuning them for performance.
  • Coordinating with DBA in creating and managing tables, indexes, db links and privileges.
  • Using SQL*Plus to query the data to ensure that the data retrieved via the web application matched that of the SQL query.
  • Writing PL/SQL scripts to create new tables and their corresponding database triggers, sequences, synonyms, indexes, and constraints. Also granted appropriate privileges on these tables to other users.
  • Developing backend interfaces using PL/SQL stored packages, procedures, functions, Collections, Object types and Triggers.
  • Utilizing SQL*Loader to load flat files database tables.

Hire Now