We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Detroit, MI

SUMMARY:

  • Over 7 1/2 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, cloning, migration and documentation.
  • Expertise in Oracle 8i/9i/10g/11g/12c, 11g RAC/ASM, 10g RAC/ASM installation, administration, configuration, production support, upgrades, patches, space management, database security, performance tuning, troubleshooting database design, UNIX shell scripting, Oracle Enterprise Manager (OEM) and documentation.
  • Installed oracle database server on Solaris 8/9/10, HP - UX, Open Suse 11.1, IBM AIX 5.1/5.2/5.3/6.1 ML7, Linux and Windows environment and migration of oracle server from 9i to 10g and 10g to 11g applied oracle patches.
  • Thorough knowledge in high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 10g RAC environment.
  • Proficient in Database System Architecture, Data Modeling, Oracle Streams, Logical/Physical database design (Data Guard implementation for Disaster Recovery).
  • Excellent knowledge in using Oracle Golden Gate including maintenance and performance monitoring.
  • 11g/10g Automated Storage Management (ASM) installation, configuration and maintenance
  • Trouble shooting and performance tuning golden gate replications.
  • Implemented Oracle RAC with ASM and standalone with ASM in different environments such as development, testing, production and standby databases (both Physical and Logical databases).
  • Expert in implementing ORACLE STREAMS (unidirectional, bi-directional and downstream capture) and managed Operational, Historical and reporting databases.
  • Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
  • Managed very large database (VLDB) of maximum size 2TB with 24 servers including 7 Productions, 7 testing, 7 Development and 3 Standby databases.
  • Proficient in Hot/Cold Backup, Recovery and Cloning of databases using RMAN and shell scripts with VERITAS Net Backup, Export and Import database schema.
  • Knowledge of various storage solutions (SAN, NAS).
  • Expertise in RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery.
  • Expertise knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQL Net, V$, DBA views and Data modeling, Logical and Physical databases design using tools like Erwin and rational rose.
  • Monitored database servers using various tools such as Oracle Enterprise Manager (OEM), Oracle Grid Control, DBArtisan and TOAD.
  • Proficient in tuning MySql processes and queries.
  • Actively involved in troubleshooting various database performance issues and used dynamic V$ views to identify the root cause.
  • Data loading and report generation using SAP BI/BO and Oracle data warehousing tools.
  • Expertise in performance tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, and ADDM to collect and maintain performance statistics and improves the database performance.
  • Expertise in planning, implementation and documentation of installation, migration, patching, backup retention policy, recovery, security, auditing, capacity planning, space management and storage allocation (SAN/NAS).
  • Expert in export/import and data pump import to load data in to tables.
  • Availability as On-Call 24x7 Production DBA and application/development DBA and Oracle Support processes for technical requests through Meta link and Help Desk Ticket applications like USD (Universal Service Desk).
  • Expertise working on MyISAM and InnoDB tables .
  • UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
  • Attended various workshops with Oracle-10g Grid Control Workshop, Oracle 10g Data Guard and 11g ASM Workshop.
  • Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment.

TECHNICAL SKILLS:

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

RDBMS: Oracle 11g//11g RAC/10g/10gRAC/9i/8i

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting

DB Management: TOAD 9.5, DB Artisan, SQL Developer and Enterprise Manager grid

Tools: /Utilities: RMAN, OEM, Oracle Management Service (OMS), SQL*Loader, ASM, Export/Import, TOAD, Patch Management, ODBC, DBUA, DBCA, putty, Golden32, ImpExp32, Grid Control, Data pump, Data guard, VERITAS Net Backup, MS Access

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Database Modeling: Erwin 4.1.2, rational rose

Hardware Platforms: Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 6500 / 450, HP XP256 / XP512, IBM C server p5 model 590, and various PC desktop and servers

PROFESSIONAL EXPERIENCE:

Senior Oracle Database Administrator

Confidential, Menomonee Falls, WI

Responsibilities:

  • 24x7 Production database administrations, support and monitoring to ensure a proactive Problem recognition and resolution of database issues.
  • Successfully migrated databases from UNIX running oracle 11g over to Linux boxes 12c.
  • Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
  • Configuration, Administration and tuning of Oracle 10g and 11g RAC.
  • Installed Golden Gate Director to have a web view of all the Golden Gate implemented servers.
  • Expertise on Oracle Golden Gate and can configure Golden Gate and troubleshoot the issues related to Golden Gate independently.
  • Used cross platform transportable table space (TTS) to transport table spaces across platforms.
  • Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
  • Data Refresh in Test and Integration Databases using Transportable Table spaces.
  • Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.
  • Implemented backup strategies using hot/cold, exp/imp used on the business req.
  • Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
  • Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetric.
  • Installed and configured 2 nodes RAC using ASM.
  • Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager.
  • Performed conversion single instance to Real Application Cluster (RAC) database instances.
  • Provided database/application tuning including as reducing lock contention, analyzing objects.
  • Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
  • Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
  • Responsible for Installation, administration and upgrade of Oracle RAC 9i/10g (Using ASM) & Oracle 9i/10g production and development databases.
  • Experienced on Database Security by monitoring User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.
  • Adept in Database Administration activities such as patch installs, cloning, backup and recovery of mission critical databases, performance tuning, script development (UNIX shell scripting/bash/perl) and documentation.
  • Used Oracle Advanced Replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
  • Oracle DBA with primary proficiency in installing, upgrading and configuring of multiple Oracle Enterprise Edition 9i/10g/11g very large, small and medium size databases (single instance & RAC) and Oracle 9i/10gAS Application Servers in UNIX, LINUX Solaris, Windows and IBM AIX
  • Implementing enterprise databases on enterprise storage solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS).
  • Installation configuration and deployment of VMware products such as VMware Workstation, VMware converter, VMware Horizon View, VCB and more in virtual environment.
  • Unix Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.
  • Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
  • Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metal ink).

Environment: Red Hat Linux5, Windows 2000/2003, Oracle 9i/10g/11g/12c, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, ASM, RAC, Golden Gate, Streams, CDC, Data Guard, SQL*Plus, PL/SQL, ASM, ToadV9.7 & SQL, Navigator V6.1.

Senior Oracle Database Administrator

Confidential, Atlanta, GA

Responsibilities:

  • Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0, IBM-AIX 5.3.
  • Successfully migrated Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.7).
  • Involved in Installation and configuration of Oracle 10g &11gRAC using Cluster ware and ASM.
  • Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.
  • 24x7 remote support and on call Database support for Database developers & end-users.
  • Installing and configured 10g agents on various production servers.
  • Configured Golden gate extract and replicate during the database character set conversion.
  • Configured Golden gate data pump extract to move the trail files from source database server to target database server.
  • Installed Golden gate Director to have a web view of all the golden gate implemented servers.
  • Implementing necessary monitoring scripts for Golden gate in Unix/Perl scripting
  • Experienced in implementing Oracle Database advanced security practices.
  • Configuring windows and SQL cluster components.
  • Table Partitioning, creating Index Organized tables, Creating Locally Managed Table spaces.
  • Database Sizing, Table space Management and Rollback Table Space Management, Transaction Management and Security Administration.
  • Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
  • Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM)
  • Experience in cloning RAC databases using RMAN tool .
  • Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
  • Experienced in Design, implementation and generating documentation of Oracle 10g Data Guard on both physical/logical standby databases in high availability mode.
  • Configured Physical Standby database for 2 node RAC database using Data Guard.
  • Having hands on experience in working with SQL Server 2005/2008/2012 databases.
  • SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, AWR, ADDM and monitor the database performance on daily basis.
  • Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
  • Assisted SQL developers to optimize the SQL queries and stored procedures.
  • Creating and Scheduling Oracle Backend Process Jobs in Crontab .
  • Cloning & duplicating databases using scripts as well as RMAN.
  • Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
  • Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication, Audit vault, DB vault.
  • Implemented VERITAS Net Backup using RMAN (Recovery Manager) as a media management layer.
  • Applying security patches both Server side and Client side and Performed testing.
  • Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
  • Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
  • Experience in performance tuning of various aspects of the database like latch contention analysis, disk subsystem tuning, SGA analysis and SQL tuning using utilities like tkprof, explain plan, Stats pack, SQL TRACE, ADDM etc.
  • Installed, configured tested SAN copy procedure to migrate data from Clarion.
  • Generated health reports for the SAN environment.
  • VMware - Extensive knowledge on install and Configure VMware infrastructure handling.
  • Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.
  • Raised SR’s with oracle in case of problems.

Environment: AIX 5.2/5.3 and Red Hat Linux 5.0, Oracle 10g and 11g, TOAD 9.0, Oracle Enterprise Manager (GC), RMAN, RAC, Data Guard, Golden Gate, ASM, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader.

Oracle DBA

Confidential,San Jose,CA

Responsibilities:

  • Managing, troubleshooting and resolving oracle database and applications issues.
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • Configuring database entries and monitoring all the databases using Oracle Enterprise Manager (OEM).
  • Troubleshooting on the databases for Application Server and Oracle database related issues.
  • Developed PL/SQL packages, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts.
  • Extensively used cron for scheduling of the UNIX shell script jobs.
  • Management of schemas, objects partitioning the tables & indexes.
  • Created database objects like tables, indexes, synonyms, views etc. using SQL* Plus, used SQL*Loader control files to load data from external data sources into Oracle database.
  • Developing Hot, cold and logical backup scripts to automate the backup procedures.
  • Worked with the business analysts throughout the development cycle, and provided post-implementation support, for data and report issues identified by customers.
  • Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
  • Installing and configuring Recovery Manager (RMAN).
  • Extensive UNIX Shell scripting in csh, ksh.
  • Extensive familiarity with Tuning Tools like Oracle Enterprise Manager’s (OEM’s), Oracle cost optimizer, SQL analyser, top session, top SQL, Performance Manager, etc., Stats pack, TOAD. For SQL tuning using “Explain plan”, “TKPROF”, “SQL TRACE”, Optimizer modes, using Optimizer hints, Gatherin statistics, Statspack etc.
  • Develop RPDs and Reports (Dashboards, Answers, BI Publisher) following an Agile development process.
  • Used SAP BI/BO and Oracle OWB to load the data in to large data warehouse from OLTP and generate the reports.
  • Administer the reporting environment through Oracle Business Intelligence Administration.
  • Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
  • Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
  • Cloning databases using scripts as well as RMAN.
  • Extensive UNIX Shell scripting in csh, ksh.
  • Data Modelling, Database Design and Creation.
  • Assisting customer setup, tune and maintain Oracle database.
  • Deciding the naming conventions of data file, redo log files, table spaces, and segments.
  • Writing scripts for backup and recovery, Import and export procedure.
  • Experience includes installation, configuration, administration and support of Red Hat Enterprise Linux Server (RHEL) versions 5.x and 6.x and to a lesser degree additional Linux distributions such as SUSE Linux Enterprise Server servers.
  • VMware - Extensive knowledge on install and Configure VMware infrastructure handling
  • Performed upgrade of Siebel eEnergy 6 to 7.5., 7.7. And 8.0 Installed configured and maintained Windows servers for application, web and database servers.
  • Installed, configured and maintained 10 Siebel environments.
  • On call support 24/7.

Environment: Linux and Solaris, UNIX, Oracle 11g and 10g, TOAD 9.7.2, RMAN, SQL*Plus, PL/SQL, SQL*Loader, DBArtisian 8.7, MS Visio 2010, Oracle BI Publisher, SAP BI/BO, RAC and Data Guard, Golden Gate, WINDOWS 2003/2005 and Siebel 8.

Oracle Database Administrator

Confidential, Detroit, MI

Responsibilities:
  • Extensively involved in analyzing the functional requirements for the Database Access Profiles.
  • Provided high degree of coordination between user, technical and application to ensure effective database management.
  • Implemented Index organized tables to improve the performance.
  • Installation, configuration and maintenance of Oracle 10g RAC database.
  • Tuning of INIT parameters to improve the performance during data loading.
  • Performed Operational Data Store (ODS) using third party tool.
  • Co-ordinate with UNIX Administrators for space management on various servers and help in Oracle installation, upgrading per the standards & Quality assurance.
  • Generating the Dataflow Diagrams and ER Diagrams by using Erwin.
  • Synchronize Databases with production for data and testing purpose.
  • Having Strong Oracle PL/SQL Programming Skills.
  • Help Development team for technical issues related to database issues.
  • Involved in running the Access Profile batch jobs.
  • Creating the database schema, converting VIEWS specific to database.
  • Development of backup and recovery procedures and Import and Export of Data (Logical Backup) and RMAN.
  • Creation of the Test database, Table spaces, Tables and Indexes, Index rebuilding.
  • Data migration, loading with SQL Loader.
  • Installation, configuration and monitoring of servers, databases by Oracle Enterprise Manager (OEM) 10g Grid Control.
  • Involved in database migration from single instance to RAC using database upgrade assistant and export/import.
  • SQL*loader and data pump import to load data into tables.
  • Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability.
  • 11g/10g Automated Storage Management (ASM) installation, configuration and maintenance
  • Responsible for performance tuning including latch contention analysis and disk subsystem tuning. Experience with OEM grid control and OEM applications control.
  • Linux instances are installed as VMware vSphere hosted virtual machines or as bare metal installation on Intel based physical hardware.
  • VMware Implementation VMware Policy implementation and Security Review Working with VMware management tools.
  • Developed stored procedures using PL/SQL. Used Hints, Indexes, Explain Plan, Sql Trace and TKProf for effective retrieval and processing of queries used for retrieving current details and history of changes made for a version.

Environment: Oracle 10g/9i, Sun Solaris 9, AIX, Redhat Linux, OEM, SQL, PL/SQL, SQL Plus, Unix, Erwin Data Modeler

Oracle DBA

Confidential

Responsibilities:
  • Oracle Configuration. Oracle Tuning. Oracle Patch Administration.
  • Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.
  • Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.
  • Wrote Stored Procedures per specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
  • Planning, Installation and Configuration of Oracle Database on the Server.
  • Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
  • Creation of Users and Granting them privileges and roles.
  • Performed Database Tuning. Performed Database Security and Integrity.
  • Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
  • Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
  • Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
  • Installation configuration & deployment of VMware products such as VMware Workstation, VMware converter, VMware Horizon View, VCB and more in virtual environment.
  • Writing Pl/Sql procedures and functions. Writing shell scripts to automate the data loading.
  • Monitoring the data loading jobs and tuning the Sql queries.

Environment: Oracle 8i, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator

Oracle Administrator

Confidential

Responsibilities:
  • Involved in Oracle Apps 11i Administration, Maintenance, Patching, Performance Tuning, and Upgradation & Migration of the environments.
  • Involved in creating the Oracle 9i and 10g databases.
  • Working with the application support people to resolve database related issues and running the scripts for the application support people.
  • Performed Import and Export using data pump utilities EXPDP and IMPDP.
  • Applied patches per the Oracle Critical Patch alerts.
  • Working with the application support people to resolve database related issues and running the scripts for the application support people.
  • Monitoring Scheduled jobs of the daily activities for the performance of all the databases. Responsible for creating Users and assigning the responsibilities as a System Administrator.
  • Familiar with AD Utilities and Cloning of Oracle Applications
  • Applied patches (One-off, Mini-patch, Rollup Patch, and CPU) for Oracle Apps and Oracle Databases.
  • Performed capacity planning for the environments and performance tuned the application servers on all.

Hire Now