We provide IT Staff Augmentation Services!

Database Administrator Resume

2.00 Rating

Jefferson City, MO

PROFESSIONAL SUMMARY:

  • 8 Years of experience in IT industry experience as an Developer and 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.
  • Extensive knowledge on database administration of Oracle 9i, 10g, 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
  • Excellent experience in installation, setup and configuration of Oracle 9i, 10g and 11g on Windows, RHEL platforms.
  • Extensive hands on experience on building 11gr2 RAC databases on EXADATA X2 - 2 HALF RACK servers.
  • Expertise in building RAC environments on RHEL using ASM block level storage
  • Expert in converting single instance databases to RAC using RCONFIG, MANUAL CONVERSION and RMAN.
  • Extensive knowledge and Hands on experience in creating physical standby databases using Active database.
  • Installed oracle GOLDENGATE 11 version and have good experience in unidirectional replication.
  • Installed and Configured oracle GOLDENGATE classic and Integrated capture modes on OGG version 10.0.0.1 and 11.2.1.0.6.
  • Have hands on experience on Oracle GOLDENGATE utilities i.e. LOGDUMP, DEFGEN utility and improving performance of GOLDENGATE processes
  • Expertise in upgrading the databases from Oracle 10g to Oracle 11g.
  • Installed Oracle 10g RAC software with ASM & OCFS2 File systems.
  • Installation, maintenance and tuning of RAC Applications
  • Created development, testing, staging, production, RAC and standby databases for OLTP systems
  • 24*7 production database support with Support to developers & end-users.
  • Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
  • Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
  • Implemented the secure backup of the data using RMAN.
  • Implemented automated backup strategy using the UNIX shell script CRON UTILITY
  • Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM, ASH and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
  • Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
  • Experience on Installing Application servers like weblogic, Jboss, Tomcat
  • Experience on Installing Web server like apache.
  • Deployed code for the Java based application.
  • Managed Weblogic 10.3, JBoss application server from an admin Point of view.
  • Setup JDBC connections for the Connection of the application server to the Database Server.
  • Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
  • Database replication using snapshots, materialized views and advanced replication methods.
  • Experience in applying security patches to the databases.
  • Effective troubleshooting of database and Performance problems.
  • Good experience in Data Migration using export/import.
  • Management of Objects, Schemas, Partitioning the tables and Indexes.
  • Worked on Developing PL/SQL packages, stored procedures, functions, Cursors, triggers.
  • Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
  • RPM and YUM package installations, patch and other server management.
  • Managing systems routine backup, scheduling jobs like disabling and enabling cron jobs, enabling system logging, network logging of servers for maintenance, performance tuning, testing.
  • Mounting and Unmounting NFS mount points on Linux Servers.
  • Managing Disk File Systems, Server Performance, Users Creation and Granting fileaccess Permissions.
  • Creation of groups, adding User ID to a group as a primary or secondary group, removing User ID from a group.
  • Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN).
  • Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
  • Good Interpersonal communication skills and Documentation Skills.

TECHNICAL SKILLS:

Operating Systems: Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, OEL 5.8 and Windows 98/NT/2000/2003.

RDBMS: Oracle 11gRAC/10gRAC/10g/9i.

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

DB Management: TOAD, OEM 9.2x, Grid Control 11g, Cloud Control 12c

Tools: /Utilities: RAC, OEM Grid Control, ESM, SQL Navigator, SQL* Loader, ASM, Export/Import, RMAN, TOAD, Patch Management, SQLNET, Oracle Streams, Data pump, Weblogic 10.3, Golden Gate, Data Guard, VMware, MS Office.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, ASH, ADR, Cloud Control 12c

PROFESSIONAL EXPERIENCE:

Confidential, Jefferson City, MO

Database Administrator

Responsibilities:

  • Worked as Operation DBA and migrated databases from Windows, AIX to Linux Servers.
  • Migrated Oracle databases on windows standalone server to EXADATA 2 node RAC cluster.
  • Used GOLDENGATE for Cross-platform migration from AIX to LINUX
  • Migrated Oracle databases on windows 2008 to OEL 5.8 using RMAN duplicate
  • Installed, configured and maintained Oracle 11GR2 Real Application Cluster (RAC) databases including a 2 Node RAC on EXADATA X2-2 Quarter Rack and Eighth Rack.
  • Created services in RAC and checking health of cluster ware components using SRVCTL AND CRSCTL
  • Implemented and Installed Level 1 OEM Cloud Control 12c on Linux machine.
  • Installed Web-logic server 10.3 during the Installation of Cloud Control 12C
  • OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM. Monitoring the databases using OEM 12c.
  • Installed GOLDENGATE on Oracle Linux and IBM-AIX and migrated databases from Oracle IBM-AIX 6.1 to OEL 5.8
  • Created new GOLDENGATE processes EXTRACTS, PUMPS AND REPLICATS, used LOGDUMP and DEFGEN utility to resolve issues environment
  • Performed consistent backups using export/import datapump utilities
  • Backup and recovery procedures using RMAN, Created scripts for RMAN incremental backups and also for full database backups.
  • Generated AWR, ASSH, ADDM reports when ever they are required
  • Worked in build stage installed ORACLE 11.2.0.4 database software, databases and created schema’s, table spaces, views, table-spaces
  • Upgraded databases from 11.2.0.3.4 to 11.2.0.4.2 and applied PSU on it
  • Handy in applying patches in RAC and NON-RAC databases
  • Converted single Instance Databases to RAC databases using Manual method.
  • Worked on ACTIVE DATAGUARD, SNAPSHOT standby and Setup physical standby’s (DATAGUARD) for 27 production Databases
  • Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the DATAGUARD status via DGMGRL and GUI.
  • Used SQL tuning by using various Tools like AWR reports, SQL Tuning Advisor, ADDM, Real Time ADDM, Database Replay and EXPLAIN PLAN analysis for query optimization
  • Provided 24*7 production supports as was always on call for maintenance activities

Environment: Migrations Oracle on windows to EXADATA,Oracle EXADATA Quarter and Eighth RACK X2-2, Oracle 11gr2, OEL 5.8, OEM 12c, RAC, DATAGUARD including DGMGRL, RMAN, Performance tuning, OPATCH, Auto, TOAD for oracle 11.

Confidential, Redmond, WA

Database Administrator

Responsibilities:

  • Installed, configured and maintained Oracle 11GR2 Real Application Cluster (RAC) databases including a 4 Node RAC on EXADATA X2-2 Half Rack.
  • Implemented DBFS on Exadata.
  • OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM. Monitoring the databases using OEM 12c.
  • Setting up Hugepages - Calculated the recommended values and setup hugepages on linux severs.
  • Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.
  • Setup the standby via OEM cloud control 12c for several databases.
  • Setup RMAN Cumulative Incremental Backups on new databases using Cloud 12c.
  • Setup physical standby’s (DATAGUARD) for several Databases.
  • Installed, Configured and Monitored STREAMS and GOLDEN GATE unidirectional replication.
  • Setup a one way homogeneous replication on Unix using GOLDEN GATE.
  • Installed VERIDATA tool for comparing data for Goldengate replication databases.
  • Configured HEART BEAT table to find out goldengate lag.
  • Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the dataguard status via DGMGRL and GUI.
  • Tested the Dataguard Switchover and Failover from primary to physical standby through Manual switchover and DGMGRL.
  • Converted physical standby to Snapshot standby and back to physical standby.
  • Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.
  • Implemented PARTITIONING using EXCHANGE PARTITION method.
  • Datapump including database links and network links.
  • Problem diagnosis and Performance tuning by implementing Partitioning, Parallelism, Compression.
  • Performed Database and SQL tuning by using various Tools like AWR reports, SQL Tuning Advisor, ADDM, Real Time ADDM, Database Replay and EXPLAIN PLAN analysis for query optimization.
  • Built databases with different blocksizes and tested the performance with various parameter settings.
  • Capacity planning for the projects owned in the environment.
  • Provided backup/Restore & Recover of the databases using RMAN and FLASHBACK database procedures.
  • Upgrade the binaries by applying patch set and interim patches using OPatch and OPatch Auto.
  • RPM and YUM package installations, patch and other server management.
  • Managing systems routine backup, scheduling jobs like disabling and enabling cron jobs, enabling system logging, network logging of servers for maintenance, performance tuning, testing.
  • Mounting and Unmounting NFS mount points on Linux Servers.
  • Managing Disk File Systems, Server Performance, Users Creation and Granting fileaccess Permissions.
  • Creation of groups, adding User ID to a group as a primary or secondary group, removing User ID from a group.
  • Creation of new PL/SQL procedures and triggers based on the project requirement.
  • UNIX shell scripting as and when required based on the requirement.
  • Provided 24*7 production supports as was always on call for maintenance activities.

Environment: Oracle EXADATA HALF RACK X2-2, Oracle 11gr2, OEL 5.8, OEM 12c, RAC, Dataguard, Golden Gate, RMAN, Partitioning, Compression, DBFS, Performance tuning, OPatch Auto, TOAD for oracle 11, Storage Migrations.

Confidential, Princeton, NJ

Oracle DBA

Responsibilities:

  • Installed and configured 11gR2 RAC databases on RHEL 5 Unix environments.
  • Worked in both Development and Production environment.
  • Involved in building Testing and Development environments for more and intense application testing.
  • Supported Databases which hold data of multiple applications varying from large data to low data.
  • Worked on database Sizes >= 3TB.
  • Installed 11gR2 databases on standalone servers and created RMAN Repositories.
  • Restored Databases to lower environments using Datapump.
  • Expertise in Migration of databases to new servers using Datapump.
  • Provided 24*7 production supports as was always on call for maintenance activities.
  • Communicated well with the client and end users for setting up and working on their requirements in providing support from the database perspective.
  • Worked extensively on Performance tuning involving the tuning of oracle queries by using AWR, ADDM Reports.
  • Configured Oracle Dataguard for Oracle Disaster recovery
  • Involved in configuring, managing and monitoring both Physical standby and Logical standby database using Data Guard.
  • Performed up-gradation databases from 10g to 11g on RHEL.
  • Worked on Exporting and importing the statistics of particular schemas from production to Development for Testing.
  • Used Toad for oracle and SQL Developer for query tuning and testing.
  • Gained knowledge and experience on middleware administration such managing JBoss and Tomcat application servers.
  • Experience on Installing Application servers like Jboss, Tomcat
  • Experience on Installing Web server like apache.
  • Deployed code for the Java based application.
  • Manage JBoss and Tomcat application servers from an admin Point of view.
  • Deployement Java files in the SVN repository for the Application Builds.
  • Involved in setting up database connections with application servers and managing deployable in the deployment folders.
  • Bounced the application servers on various occasions in the lower environment for the clearing hung threads and sessions.
  • Worked on setting up jobs using third party tool such as Job Scheduler for scheduling jobs for end application users.
  • Schemas restore using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins for prod/dev/test databases.
  • Restored and Recovered databases using RMAN for the migration of the Databases from 10g to 11g.
  • Creating Database Monitoring scripts and batch files for schedule jobs.
  • Installed OEM agents for databases to be monitored and administered through 10g Grid Control OEM.

Environment: Oracle 11g RAC, RDBMS, Data Guard, RMAN, RHEL 4.x, 5.x, shell scripting, and 11G OEM Grid control, Toad, SQL Developer, Stored Procedures, Production Support 24*7 JBOSS, Tomcat, Apache, Job Scheduler etc.

Confidential, Boise, ID

Oracle DBA

Responsibilities:

  • Installation, Upgrade and Configuration of Oracle (11gR1 and 11gR2) for the new projects/surveys.
  • Installed 10g RAC (2 Node) on RHEL and converted/added an additional node to the existing RAC for production databases.
  • Worked on database Sizes >= 3TB.
  • Installed CRS, ASM lib on oracle 10g Databases and added nodes to existing RAC Databases.
  • Migration: Duplicated database using RMAN of Oracle 10g database and upgraded it to oracle 11g and applied latest patch set.
  • Efficiently used Data pump in 10g migration from prod to test and test to prod.
  • Applied the bundle and CPU patches to all test, development and production databases.
  • Restore and Recover, Cloning and Duplicating databases using scripts as well as with RMAN.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Implemented and Configured Advanced Queues over streams and set up loading the files from XML to Oracle database tables.
  • Setup Advanced Queues (enqueue/dequeue/propagation/subscriber/agent) on prod databases.
  • Configured, Setup and Implemented oracle Streams (Upward and downward) on 10g Databases.
  • Replicating schema/table level database using Streams. Performed entire database replication using Streams.
  • Implemented Physical Standby 10g databases with and Without RMAN using Data guard.
  • Experience with handling of medium to large Oracle OLTP (Online transaction processing).
  • Performance tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
  • Configured Oracle data guard and Streams.
  • Involved in designing of disaster recovery using Data Guard, High Availability using 10gRAC.
  • Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins for prod/dev/test databases.
  • Worked on Building schemas, cursors, developed stored procedures and database triggers in PL/SQL.
  • Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, OS and java calls.
  • Developed UNIX shell scripts to perform the above tasks efficiently.
  • Creating Database Monitoring scripts and batch files for schedule jobs.
  • Configured Recovery Manager (RMAN) like Advice on data recovery, parallel backup of the same file, and virtual catalogs and Secure backups for security.
  • Extensive Performance Tuning, Memory (SGA) Tuning, RAID, RAW Devices.

Environment: Oracle 10g/11g RAC, RDBMS, RMAN, Data Guard, Streams, RHEL 4.x, 5.x, shell scripting, Oracle 9i, 10G, and 11G OEM Grid control.

Confidential, Lansing, MI

Oracle DBA

Responsibilities:

  • Involved in 24/7 Production Support of Databases.
  • Installation/creation and maintenance of 9i and 10g databases for Testing, Development and Production.
  • Installed and Configured 10g RAC with ASM disks on Linux (Red Hat Enterprise Linux) servers
  • Converted Single instances to RAC
  • Performed 10G RAC switchover and failover configuration, implementation, and testing
  • Monitored the Grid Control components such as OMS and OMR
  • Performed Database and SQL tuning of Multi Terabyte size databases spread at various sites by using various Tools like STATSPACK, AWR, TKPROF, EXPLAIN PLAN, ADDM, ASH and Optimizer Hints
  • Troubleshooted various RAC Performance Tuning Issues
  • Performed RAC Backup/Recovery of Oracle databases using backup tool Upstream
  • Developed and monitored tools such as OEM and Oracle Enterprise Manager 10g Grid Console to administer production, test and development databases.
  • Migrated Databases.
  • Monitored RAC Backup & Recovery
  • Configured Database level Streams Replication and One way schema level Streams Replication
  • Setup Schema level Down Stream Capture
  • Automated the backup jobs using RMAN for all production databases.
  • Used RMAN Duplication to migrate the database to ASM
  • Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
  • Upgrade of Database from 9i to 10g and applying patches whenever required.
  • Simplified data distribution between Data warehouse and Data Mart using Transportable tablespaces
  • Data refresh from production to test and development using RMAN cloning or exp/imp utility.
  • Implemented Oracle Streams 9i (replication) server. Scheduled exporting of entire database to off-site repository
  • Used Materialized Views to replicate data to remote databases
  • Extensively used dynamic performance views (v$ views or internal views) for various performance issues.
  • Scheduling Jobs through Crontab on RHEL.
  • Scheduling jobs through Oracle job Scheduler.
  • SQL Tunings for Performance of Objects
  • Participated in developing backend Oracle batch processes, developed PL/SQL packages and procedures.
  • Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
  • Automation of Startup Shutdown on all Production and Development Database.
  • Scheduled conference calls with Offshore team for status reporting.

Environment: Oracle 9.0.1, 9.2.0.3, 10.2.0.4, RAC, RHEL, Windows 2003, Enterprise Manager, Data Pump, RMAN, Data Guard, Streams, SQL, PL/SQL, shell scripting.

Confidential, Denver, CO

Oracle DBA

Responsibilities:

  • Upgrade of 9i database to 10g release 2.
  • Deployed Management Agents on various hosts
  • Configured Oracle Streams for replication between two databases
  • Cloning the instances for testing, development and integration testing.
  • Responsible for optimizing the queries and application tuning.
  • High-Availability Setup using 10g Data guard.
  • Developed Complex Resource Plans for Optimum utilization of Resources
  • Performed Database Migration from one platform to another using Transportable Tablespaces
  • Used RMAN and Oracle Secure Backup to back up and restore the database
  • Configured fast refresh for Materialized Views
  • Used various internal views for monitoring the database.
  • Developed RMAN scripts for database backup and recovery.
  • Designed and implemented the database servers for two new data centers
  • Supervised, coordinated and controlled a team of junior DBAs performing developer support and end-user support
  • Configuration of Oracle OEM (Oracle Enterprise Manager) to monitor database and report on events as defined by the DBA group.
  • Generated scripts for daily maintenance activity like analyzing the tables/indexes, monitoring their growth rate, monitoring the effective use of SGA etc
  • Perform production system problem analysis and recommend corrective measures in a timely manner.
  • Managed security in a complex and sensitive environments.

Environment: Oracle 9i/10g, streams, data guard, RMAN, HP-UX, Red hat Linux, shell scripting.

Confidential

Oracle Developer

Responsibilities:

  • Analyzed the structures using Analyze command.
  • Involvement in all phases of the project life cycle
  • Developed database Schema, Stored Procedures and Database Triggers for data manipulation.
  • Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system
  • Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
  • Working on Designing Schema / tuning PL*SQL/ SQL code
  • Implemented automated backup strategy using the UNIX shell script, CRON UTILITY.

Environment: Oracle 8i, SQL, PL/SQL, SQL plus, TOAD, Windows 98/NT.

We'd love your feedback!