We provide IT Staff Augmentation Services!

Sr Oracle Database Administrator Resume Profile

Wealth Of, Ky

SUMMARY:

  • Over 7 years of experience as an Oracle DBA working in various versions of Oracle like 11g, 10g, 9i and 8i.
  • Installed and Kept up Oracle RDBMS Software 11g, 10g and 9i on different flavours of UNIX HP-UX, AIX , Linux RHEL, SUSE, and OEL , Sun Solaris5.
  • Experience in Upgrading databases from 9i to 10g to 11g, migration of databases starting with one stage then onto the next windows/Unix to Linux.
  • Efficiently Implemented logical backups using tools like Oracle Data pump Export/Import and classic Export/Import.
  • Used RMAN DUPLICATE to clone/duplicate target database and restore table space past in time.
  • Implemented different Backup and Recovery strategies using Recovery Manager RMAN , Complete and Incomplete Recovery of databases during database crash, disk/media failure, etc.
  • Implemented and configured replication technology using Data Guard and Oracle Golden Gate installation, configuration and troubleshooting on Linux and Unix Platforms.
  • Experience in planning implementation of Backup Recovery strategy, RMAN. Performance Tuning AWR/ Stackpack for as tuning of application, shared pool, buffer cache, I/O distribution, rollback segments, redo mechanisms and SQL code.
  • Experience working with Oracle Advanced Technologies like Oracle Enterprise Manager Grid Control, Oracle Streams, Data Guard and Real Application Clusters.
  • Experience in planning and scheduling the Physical HOT/COLD backups and LOGICAL BACKUPS.
  • Hands on experience with the new oracle FLASHBACK Technology like enabling Flashback feature, configuring FLASH RECOVERY AREA.
  • Performance Monitoring and Tuning of databases using tools like SQL Tuning Advisors, Segment Advisors, STATSPACK, AWR, ASH and ADDM reports.
  • Experience working with SQL Tuning tools like SQL Trace, Explain Plan and SQL profiles.
  • Expertise in Tuning Memory, I/O and CPU Utilization, Disk Usage and Space Utilization.
  • Expertise in writing BASH, KORN and SHELL Scripting for databases and server requirements.
  • 24/7 Production Support for the databases and support to the developers and end-users.
  • Good understanding of System Development Life Cycle, Automatic Undo management, RAID concepts and advanced features of Oracle 11g.
  • Experience in Microsoft SQL Server database administration.
  • A self-motivated, responsible and reliable team player with a set of strong technical skills with excellent analytical, interpersonal and communication skills.

Technical Skills

  • Operating Systems: Windows NT/2000/2003/2005, AIX, Sun Solaris, RHEL, OEL and HP-UX
  • Languages : C, C , SQL, PL/SQL, UNIX Shell Programming
  • Databases : Oracle 12c, 11gR1/R2, 10g,9i and SQL server 2012
  • Case Tools : OEM Grid control, Toad, Quest Spotlight,
  • Tools Utilities : Data Pump Export/Import, SQL loader, ASMLIB, RMAN, AWR ADDM

Project Work Experience

Confidential

Role: Sr Oracle Database Administrator

Responsibilities:

  • Maintenance and Administration of 11g/10g databases on, Red Hat Linux 3 Node Cluster with database sizes ranging from 30GB to 12TB and managed these databases in different Data Centers i.e USA, San Diego, Annapolis and Reporting databases.
  • Performance Monitoring, Troubleshooting and Tuning at Instance level.
  • Maintenance and Administration of the reporting database i.e CGA basically used for reporting to the external customers via daily ETL reports.
  • Implemented High availability using Golden Gate Replication.
  • Frequent interaction with Developers, and working with them in developing the applications using SQL Trace and Explain Plan utilities.
  • Tuning of Oracle database, tuning memory, I/O, Resource contention, Database Operation and performance diagnostic tools like TKPROF, SQL Trace utility, Oracle expert and SQL Analyze.
  • Involvement in the timely Database and Application releases for PeopleSoft application. Interacting with the Development team, Application Team, System Administrators and Release Teams.
  • Experience in Database Administration for very large and complex databases in SQL Server 2008 R2, 2008 and 2005.
  • Maintenance and Administration of 3 node High availability RAC 11g databases with ASM shared storage, failover and Disaster Recovery procedures using a Physical Standby.
  • Implemented Partitioning on huge tables to improve the performance and reduce the maintenance to finite window operations.
  • Monitoring of Databases using Oracle enterprise Manager and Toad. Monitoring at OS Level and Backups using oasis tool.
  • Setup and Maintenance of Oracle Advanced features like Oracle FLASHBACK and Flash Recovery Area, Data Guard Physical Standby and Failover procedures.
  • Knowledge in the architecture design of OEM and Oracle database and application monitoring
  • Day to day activities like, Capacity planning, Table spaces and Segment Space management, Security Administration, database refresh and database copies etc.
  • Rebuilding / monitoring the indexes at regular intervals for better performance.
  • Administration and Verification of Backup procedures and backup failures using RMAN and recovery Catalog. Integration of Backups with Media management layer tools like Symantec NetBackup and backups pointing to Data Domain with Duplication and De-duplication.
  • Experience implementing Restore and Recovery strategies using RMAN Cold/Hot backups and cloning databases using RMAN duplicate and scheduling the backups using Crontab.
  • Good experience in Installation, configuration and maintenance of SQL Server.
  • Setup and maintenance of appropriate database and application monitoring.
  • Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.

Environment Tools: Oracle 11gR1/R2, 10g, RAC, ASM, OEM Grid Control and TOAD.

Confidential

Role: Lead Oracle Database Administrator

Responsibilities:

  • Maintained and Administered 11g/10g databases on Windows 2000/2003, Red Hat Linux and HP-UX servers with database sizes ranging from 30GB to 5TB and managed databases comprising both Spatial and Tabular data for different vendor products and different Applications.
  • Implementing backups using Oracle Advanced features like Flash Recovery Area and Flashback technologies like FLASHBACK DATABASE, FLASHBACK TABLE, FLASHBACK QUERY and FLASHBACK TRANSACTION QUERY.
  • Setup and Maintenance of Oracle Advanced features like Oracle FLASHBACK and Flash Recovery Area, DataGuard and Failover procedures.
  • Applied quarterly CPU patches and one-off patches using OPatch Utility.
  • Maintenance and Administration of 3 node High availability RAC 11g Clusterware databases with ASM shared storage, failover procedures.
  • Experience implementing Restore and Recovery strategies using RMAN cold/Hot backups and cloning databases using RMAN duplicate.
  • Performance Monitoring and Tuning at Instance level, Database level, OS level and Query level using Oracle diagnostic tools like Explain plan, STATSPACK, AWR, Tuning Advisors like SGA/Shared Pool/PGA tuning advisors etc.
  • Daily database monitoring using Oracle Enterprise Manager Grid control and troubleshooting ORA 600 and ORA 7445 errors if any.
  • Experience in scheduling tools like Autosys and Oracle Enterprise Manager.
  • Experience in writing Shell scripts purging and archiving data for partitioned tables and automating day to day maintenance procedures.
  • Experience with classic export/import, Data pump export/import and SQL loader.

Environment Tools : Oracle 11g, 10g, RAC, ASM, OEL, HP-UX, MS Windows, OEM Grid Control, TOAD 10.0 and Oracle workspace Manager.

Confidential

Role: Oracle DATABASE ADMINISTRATOR

Responsibilities:

  • Worked with different applications like Statement Archival and Retrieval STAR , ETA Enterprise Transaction Archive and AIDB All Item Database .
  • Installed, Upgraded 9i to 10g maintained Oracle 10g R2 RAC on Red Hat Linux 4.0.
  • Creating a new change over schema on the production databases. Was involved in the Quality Assurance QA and the Enterprise Change Management CM as well.
  • Implemented Oracle Data Guard for oracle disaster recovery and OEM for database monitoring, performance and diagnostics have been configured
  • Migration of database servers from Non-RAC non-ASM environment on 64 bit UNIX to RAC with ASM environment on HPUX.
  • Monitored and tuning database to optimize the performance. 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, SQL Trace, Tkprof, AWR ADDM.
  • Supported development effort by providing SQL statement tuning and query performance bottlenecks by using tools Explain Plan, SQL Trace, TOAD and Oracle Enterprise Manager.
  • Implemented Oracle Data Change Capture supported by Oracle Streams
  • Successfully implemented Backup Recovery using RMAN which includes database hot backup, archive backup, obsolete backup and crosscheck backups.
  • Performed export and import of different databases using Oracle DATA PUMP Export / Import utilities
  • Upgrading and Migration of a Data warehouse on Solaris Non-RAC environment to 64 bit Linux RAC Clustered environment.
  • Experience in Designing and Creating a Physical/Logical modeling of database, Oracle RDBMS skills which include Implementation, Normalization and Integration in an OLTP environment.
  • Maintenance of Oracle Database. Rebuilding of Indexes, creating and managing Tablespaces and allocation tables to different tablespaces.
  • Performed daily alert log files, trace files check, and general data consistency data integrity check. Developed scripts to monitor the storage usage, object status for daily job .
  • Given 24 7 Production database for supporting developers end-users.
  • Utilized OEM SQL Analyze, OEM performance manager, STATSPACK, SQL Trace, etc

Environment Tools: Oracle 10g, 9i, RAC, RHEL 4.0, Solaris, UNIX, OEM, DB Artisan, TOAD.

Confidential

Role: Production Oracle Database Administrator

  • Installed and Created 11g/10g databases on Red Hat Linux and UNIX servers.
  • Upgraded databases from 9i 9.2.0.8 to 10g 10.2.0.3/4 and 10g 10.2.0.4 to 11g 11.1.0.6 versions using DBUA and manual upgrades. Experience applying quarterly CPU patches one-off patches using OPatch Utility.
  • Experience working with non RAC ASM and RAC with ASM, maximum number of nodes worked are 2 nodes.

Responsibilities:

  • Experience working with Oracle Advanced features like Oracle Streams setup and administration , Data Guard setup and Failover procedures.
  • Setup of Bi-directional and Uni-directional replication, Replication at table level and Schema level.
  • Design and Planning security guidelines for database structures and schema applying the Least Privilege Principle.
  • Administration and Verification of Backup procedures and backup failures using RMAN and recovery Catalog.
  • Experience implementing Restore and Recovery strategies using RMAN cold/Hot backups and cloning databases using RMAN duplicate.
  • Performance Monitoring and Tuning at Instance level, Database level, OS level and Query level using Oracle diagnostic tools like Explain plan, STATSPACK, AWR, Tuning Advisors like SGA/Shared Pool/PGA tuning advisors etc.
  • Implemented different Table partitioning schemes like Range Partitioning, Hash Partitioning, List partitioning etc.
  • Experience in writing Shell scripts purging and archiving data for partitioned tables and automating day to day maintenance procedures.
  • Participated in Database deployments which include code changes and data to Acceptance and Production Environments.
  • Experience with classic export/import, Data pump export/import and SQL loader.
  • Performed 24 7 Production support for databases on a rotation basis.

Environment Tools : Oracle 11g, 10g, RAC, ASM, RHEL 4.0, AIX, Microsoft Windows, OEM, TOAD 9.6.

Confidential

Role: Oracle Database Administrator

Responsibilities:

  • Worked with databases of sizes ranging from 16GB-3TB of data supporting different Applications like Empower
  • Installation and Creation of 11g database and software on an Oracle VM server and database servers on Linux, AIX and Windows 2003 platforms.
  • Installed and setup 10g Oracle Enterprise Manager Grid Control 10.2.0.3 and Mass Agent Deployment on several hosts.
  • Upgraded the database from 9i 9.2.0.1, 9.2.0.4, 9.2.0.6 to 10g 10.2.0.3 10.2.0.4 and 10g 10.2.0.4 to 11g.
  • Tested for database Replication and Integration Oracle streams on Oracle VM machine.
  • Migration of databases on 32 bit UNIX to 64 bit UNIX and 32 bit Windows to 64 bit Linux using Cross Platform Table spaces.
  • Developed RMANLevel-0 Level-1 Backup Recovery Shell Scripts for Development Production Databases which contains 10g Features like Flashback, Block Change Tracking and linking with Tivoli Storage Management.
  • Installed Oracle Data Guard for Oracle Disaster Recovery, High Availability and Data Protection.
  • Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor ADDM , Automatic Workload Repository AWR for monitoring database performance.
  • Handling day-to-day activities and user requests in maintaining and creating databases, managing segment space and storage including table spaces and data files for table space growth, extent growth and monitoring data file additions. Applying the Patches as and when required.
  • Expertise in troubleshooting skills including Diagnostics and Connectivity issues, resolving ORA Errors.
  • Worked with database utilities like Export Import Exp Imp Expdp Impdp , SQL Loader to backup database structures and automation procedures.
  • Created BASH Shell Scripts for Startup Shutdown the Databases, Alert Log notifications through mails, Archive log Flashback Space alert scripts
  • Successfully implemented SQL LOADER Technology for DATA INSERTION into the tables by using their Control Files Bad Files.

Environment Tools: Oracle 11g, 10g, 9i, 8i, RAC, RHEL 4.0, AIX, MS Windows, TOAD 9.6.

Hire Now