We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Alpharetta, GeorgiA

SUMMARY

  • A talented, accomplished IT professional with over 6 years of IT experience working as an Oracle Database Administrator, specialized in creating database architectures for the most powerful and complex systems.
  • A competent professional with 6+ years of IT experience as a Database Administrator & Data Analyst.
  • Experience in Real Application Clusters (RAC) setup, configuration, and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability
  • Experience in administering application schemas and end users by creating and assigning proper profiles and roles to maintain the security.
  • Planned and implemented DR & high availability solutions using Standby Database and Oracle Data Guard methodology.
  • Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
  • Experienced in using 11g features Data Pump, AWR, ASM, ADDM, Grid monitoring, and Recycle Bin.
  • Hands on experience in SQL, PL/SQL, OLAP, Logical and Physical Database Design.
  • Delivered SQL and Database performance tuning services via V$/GV$ views, AWR reports, ADDM, SQL Tuning Advisor, Oracle Enterprise Manager (OEM) Grid control, analyzed SQL trace dumps for 11g.
  • Experience in Data Compression, Table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive and ASM.
  • Proficient in administration activities like Installation, Configuration, Upgrades, Patches, Cloning, Capacity Planning, script development and documentation.
  • Experience in upgrading the oracle database from10g to 11g.
  • TEMPHas a good exposure of SQL Server, Report Generation.
  • Experience in end - to-end implementation of the SDLC, including finalization of specifications, design, development, implementation, quality of Products.
  • Reviewing the functional specifications and Requirements documents.
  • Experience on high volume databases with sizes varying from 100GB to TBs of data.
  • Experience with Performance Tuning - proactive and reactive for optimal performance to meet Business SLA*s.
  • Experience in high volume transaction environments.
  • Experience in supporting multiple production databases concurrently running different applications.
  • Expertise in creation and implementation of Backup and Recovery methods and disaster recovery methodsusing RMAN, logical, hot backups, Flashback Recovery and Block Media Recovery methods.
  • Strong experience in Hot/Cold Backups and Point-in-time Recovery procedures using RMAN.
  • Experience in handling Log sync issues between primary and standby databases in Data Guard.
  • Created and modified Database objects likeTables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored ProceduresandPackages.
  • Interface with Oracle Corporation for technical support.
  • Efficient at using ASP.NET, C#, Html, JavaScript.
  • Ability to work in a team and as an individual. Possess strong communication and interpersonal skills.
  • Excellent analytical and problem solving skills with understanding of project management.
  • Participated in 24*7 on-call rotation, off-hour production problem resolution activities
  • Enthusiasm in learning new technologies.

TECHNICAL SKILLS:

Languages: C# 2.0, SQL, PL/SQL, SQL*PLUS, MSSQL

Web Technologies: ASP.NET, HTML, JavaScript.

Databases: SQL Server 2005/2008, Oracle 11g

IDE: MS Visual Studio 2005/2008

Operating Systems: AIX 6.1, UNIX, Windows 2005/2003/7/ XP

Packages/Utilities: Export/Import, STATSPACK, 11g RAC, Partitioning, ASMRMAN, EXPDP/IMPDP, DBCA11g Data Pump, Oracle Enterprise Manager (OEM) 11g, AWR / ADDM / ASH

Tools: Oracle Performance Pack OEM, TOAD, Putty, SQL*PLUSOracle Diagnostic Pack, Data pump API, SQL Trace and SQL tuning Advisory

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Confidential, Alpharetta, Georgia

Environment:Oracle 11g databases, 11g Data Guard, RMAN, Export/ImportSQL*Loader, SQL Server, DBCA, TOAD, OEM.

Roles & Responsibilities:

  • Installation of Oracle RDBMS server software and version upgrades.
  • Involved in the analysis, design, build, and testing phase of the life cycle for the project.
  • Installation and configuration of release 11g R2 RAC with ASM and Raw Devices.
  • Installed, configured, administered multiple 4+ node RAC clusters in DEV, QA regions and administered 5 node Production RAC Cluster.
  • Experience in adding/removing nodes to and from the RAC Cluster and reconfiguring the cluster.
  • Monitoring the services in RAC Clusters
  • Applying Patch Set on the RAC Clusters
  • Performing Backup/Recovery of all the Oracle databases using RMAN
  • Preparation of design specifications document.
  • Involved in designing the database, identification of the objects and creating tables.
  • Designed and created database objects such as Tables, Views and Indexes.
  • Writing DDL, DML and complex queries in SQL.
  • Reading Alert Logs and User trace Files and Diagnosing the Problem
  • Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non Production environment, Creation Duplicate Databases using RMAN Backups.
  • Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)
  • Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecksusingSQLTRACE, AWR, and ADDM.
  • Monitoring and optimizing system performance using index tuning, disk optimization, advanced database techniques, and other methods, including the use of automated tools.
  • Importing data from flat files into database using SQL loader and External Tables.
  • Supported production, development and testing databases with database ranging from 2TB to 16TB.

Advisory Services Portal

Confidential, Phoenix

Environment:Oracle 11g databases, 11g Data Guard, 11g RAC, Export/ImportSQL*Loader, SQL Server, OEM, DB2.

Roles & Responsibilities:

  • Configured Data Guard to provide high availability by implementing Physical standby database.
  • Responsible for providing 24x7 supports for prod and non-prod Oracle databases.
  • Managed databases running on 4 node 11g RAC.
  • Designed, configured and maintained backup and recovery policies including RMAN backups.
  • PL/SQL, Performance Tuning and Monitoring.
  • Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
  • Recovered databases using RMAN.
  • Responsible for resolving several complex recovery scenarios (including RMAN) with critical production database.
  • Extensively used AWR, ADDM and SQL Trace for database performance statistics.
  • Proactive performance monitoring, and capacity planning for future database and server growth.
  • Performed Import and Export using Oracle Data pump utilities EXPDP and IMPDP.
  • Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, troubleshooting, back-up and recovery, installations and configurations on an as needed basis.
  • Used external tables and SQL*Loader to import data from flat files.
  • Performed version upgrades and patch installs.
  • Experience in configuring and administering databases with OEM Grid Control.
  • Provided technical resolution to Oracle database related problems.
  • Developed and maintained database standards and conventions; analyze impact of data change.
  • Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance issues.
  • Experience in working with Oracle Architecture, I/O tuning, Memory tuning, Capacity planning, space management, Performance tuning and optimization.
  • Implemented database auditing, data security and Remediate high-risk violation in production environment.
  • Applying RDBMS patches, security patches, proactive monitoring of databases.
  • Strict adherence to policies and procedures - specifically in regard to change management and project management.
  • Perform database administration tasks as part of a scheduled change management task.
  • Proficient in communicating directly with internal resources on a daily basis.

Confidential

Power Plant Engineers

Environment: ECC 6.0 with EHP4, AIX 6.1, Oracle 11g, SQL, PL/SQL, EXPDP/IMPDP, OEM, RMAN, BRTOOLS.

Roles & Responsibilities:

  • Installing the Oracle 11g. Database Performance tuning, including query tuning & optimization.
  • Creation of the Roles & Profiles for all the end users as per Authorization Matrix.
  • Implementedbackupandrecoveryprocedures(Cold/Hot backups, RMAN Incremental backups)
  • ConfiguringData Guardto ensure high availability, data protection anddisaster recoveryfor enterprise data.
  • Create Production Support databases for testing every Week for developers usingData pumpIMPDP from Production Backups.
  • Perform Daily Backup Routine task.
  • Transport of all Customizing & Workbench Requests in Quality & Production Environments.
  • Applying Background Jobs.
  • Supporting SAP Security operations: on-going Security maintenance (jobs, roles& users), security incident management.
  • Expertise in Oracle Database Administration & able to perform database activities like space management, Instance management & SAP Table Reorganization.
  • Performed system Restore & Recovery of online & offline backups via BRTOOLS.
  • Responsible for all kind of support activities.
  • Perform support activities like Daily Health Checks, User administration, Spool administration, Profile Maintenance, Job Scheduling, Backup Management.

Disaster Recovery Server Implementation

Confidential

Environment: ECC 6.0 with EHP4, BI 7.01, XI 7.11, EP 7.01, AIX 6.1, Oracle 11g

Roles & Responsibilities:

  • File System Backup of Primary Servers.
  • Restore of Backup in DR Servers.
  • Configuration changes as per Oracle Data guard.
  • System Check after DR synchronization.
  • Daily Monitoring of DR servers.
  • Manage user accounts and access privileges
  • Conduct regular performance tuning of all SAP Systems.
  • Identify long running jobs & queries causing lot of overhead.
  • Planning & performing Database Backup.
  • Expertise in using profile Generator (PFCG) for creation & maintenance of Roles/Activity groups according to the Business Requirements & using SAP Supplied User Role template.
  • Actively participated in defining, Configuring & maintaining the Transport Management System (TMS) env.
  • Eliminating the Deadlock Situation
  • Security support for integration testing, user acceptance testing & training efforts.
  • Participate in 24*7 “on-call” support rotation for oracle database systems in Production Environment.

Fund Management Implementatio

Confidential

Environment: ECC 6.0 with EHP4, AIX 6.1, Oracle 11g, SQL, PL/SQL, EXPDP/IMPDP, OEM, RMAN

Roles & Responsibilities:

  • Creating a new Client in our ECC Development system for initial Testing as required by the Functional Team.
  • Apply the OSS Notes.
  • Creating the SAP Users & Roles according to Authorization Matrix.
  • Performed the Request transports.
  • Register objects at Service Market Place.
  • Database Performance Tuning.
  • Backup and Recovery of Database.
  • Perform Database Activities like Space management, Instance management & SAP Table Reorganization.
  • Planning & Monitoring the Database Backup during heavy users access (Load Balancing).
  • Involved in all aspects of Client Management -Creating, Deleting & Copying Clients.
  • Participate in various Auditing Activities to ensure dat Governance compliance is as per the company policy.
  • Production Basis Support in 24x7 multi-instance NW Systems: ECC 6.0 with EHP4.

Power grid Co-operation

Confidential

Environment:Asp.net, C#, SQL, SQL*PLUS, Oracle11g, RAC, OLTP, Windows2000, AWR, TOADRoles

Responsibilities:

  • Worked on Windows and Oracle platforms
  • Managed User access
  • Altering, creating the access of the existing and new user.
  • Create and Administrate user accounts.
  • Perform backup and recovery of a database
  • Monitor, Troubleshoot and maintain a database
  • Monitoring & managing Tablespace using segment space management tool.
  • Creating and managing database objects, index, users, roles, privileges, profiles.
  • Monitoring index and rebuild index.
  • Experience in Backup and Recovery used physical backup (hot & cold) and logical backup using Export/Import.
  • Setting up RMAN backups and maintaining catalog schema
  • Performance Monitoring/Tuning and Database Security for Databases.
  • Involved in the installation, configuration and support of Oracle 11g R2 databases.
  • Installed Oracle 10g on Production DB Servers, applied Opatch to fix the non bugs.
  • Involved in System Software development Life Cycle (SDLC) of Data warehousing, Decision Support System.
  • Applied critical patch updates (CPU) released by oracle quarterly.
  • Experienced with Data Guard implementation and Point in time Recovery.
  • Importing data from flat files into database using SQL loader and External Tables.
  • Provide after-hours support during critical activities such as month end closing/opening procedures.

hicle Tracking System

Confidential

Environment:Asp.Net, C#, Google Map API, XML, CSS, JavaScript, Oracle10g/11g, PL/SQLRoles

Responsibilities:

  • Involved in the installation, configuration and support of Oracle 11g R2 databases.
  • Refresh/Cloning of Database for development and testing purpose
  • Standby Database (Data Guard) setup and configuration.
  • Working with programmers at early design stage to choose right data model relationships, creating required indexes and materialized views.
  • Involved in Upgrade/Migration of the oracle databases.
  • MigratedDatabasefrom Oracle 10g to 11g R1 RAC to achieve high availability of production database.
  • Implemented PL/SQL packages to perform Application Security and batch job scheduling.
  • Performing monitoring and performance tuning
  • Defining and Setting backup and recovery procedures.
  • Managing, troubleshooting and resolving oracle database issues.
  • Enabling and analyzing trace files for any errors occurred while database runtime.
  • Performing monitoring and performance tuning using different tools like AWR, SQL trace.
  • Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
  • Responsible for continuous database monitoring and reorganization for ensuring performance.

Account Management System

Confidential

Environment:Asp.Net, C#, CSS, JavaScript, Oracle10g, UNIX, TOAD, SQL*Loader, AWR, ADDM.

Roles & Responsibilities:

  • Developed PL/SQL packages to capture end of day transactions.
  • Implemented UTL HTTP oracle built in package to acquire data from external websites.
  • Preparation of design specifications document.
  • Designed and created database objects such as Tables, Views and Indexes.
  • Involved in designing the database, identification of the objects and creating tables.
  • Tested and corrected errors and refined changes to data base.
  • Implementing Database Security, Management of role-based security.
  • Bug’s resolution, resolution of simple product problems.
  • Development and modification of reports like Order Reports ( Report Designer)
  • Maintain and resolve various database issues.
  • Involved in the analysis, design, build, and testing phase of the life cycle for the project.
  • Management of table space growth, monitoring data files additions, extent growth.
  • Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
  • Established database backup/recovery strategy for different databases.
  • Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure
  • Handling day to day activities along with schema and space management.
  • Creating primary database storage structures (tablespaces, datafiles, tables, indexes etc)
  • Planning for storage spaces requirements and placing them for optimum I/O performance.
  • Cloning databases using scripts as well as HOTBACKUP

Hire Now