We provide IT Staff Augmentation Services!

Oracle Dba Resume

Jersey City, NJ

SUMMARY:

  • Over 7 years of hands on experience on Oracle Database Administration.
  • Excellent experience in production support, installation, configuration, upgrades, migrations, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing.
  • Expertise includes Oracle Databases (11g RAC/10g RAC/9i/8i), on UNIX (HP-UX, Sun Solaris, IBM AIX)/LINUX and Windows environments.
  • Upgraded databases from Oracle 9i to 10g, Oracle 10g to 11g.
  • Experienced in maintaining large Production, TEST and DEV environments.
  • Expertise in installing, configuring and maintaining Oracle databases on various platforms.
  • Planned and Implemented DR & High Availability solutions using Oracle 10g RAC, 11g RAC, Standby Databases including Active Data Guard.
  • Experience in Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
  • Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues.
  • Excellent experience in backup and recovery. Cold backups, hot backups, Logical backups, RMAN backups (Full, Incremental Backups, Differential, Cumulative Backups).
  • Implemented data transfer using Export/Import utilities and Data Pump.
  • Automated database periodic maintenance and activities using Korn, Perl Shell Scripts.
  • Extensive Experience writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
  • Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
  • Excellent experience in patching, upgrades and migrations.
  • Configured Oracle on different Operating Systems for OLTP and Data Warehousing environments.
  • Replication using Materialized Views, Oracle Streams and Golden Gate.
  • Experience in Capacity Planning and benchmarking.
  • Experience in Partitioning
  • Experience in migrating databases from Windows to Linux, Sun Solaris to IBM AIX.
  • Experience in Logical Database Design, Physical Database design
  • Excellent communication skills, with strong troubleshooting, and problem solving ability.

Technical Skills:

RDBMS

Oracle 11g RAC, oracle 10g RAC, Oracle 9i, Oracle 8i, SQL Server, MySQL.

Operating Systems

Red Hat Linux 4.x,/5.x/6.x, Sun Solaris 8/9/10, IBM AIX 5.1/5.2/5.3/6.1/7.1, HP-UX10.x/11.x, Windows NT/95/98/2000/XP/2003

Languages

SQL, PL/SQL, Java, C, UNIX shell

Tools

RMAN, SQL*Loader, Data Pump, Exp/Imp, TOAD,
ERWIN

Tuning Tools

Golden Gate, Streams, ODI, OEM/Grid Control, TKPROF, STATSPACK, AWR, ADDM, ASH, TOAD, ASM

Database Modeling

ERWIN, Rational rose

Others

EMC, NetAPP, VERITAS Net Backup, IBM TSM

Web Technologies

HTML,XML

EDUCATION:

  • Bachelor of Technology

Professional Experience:

Confidential, Jersey City, NJ June 2011- Present
Oracle DBA

Responsibilities:

  • 24*7 Production Database Administration Support
  • Installation, configuration and support of Oracle RAC and Standby Databases (Active DataGuard) for High Availability and Disaster Recovery.
  • Cloned/Refreshed Oracle Databases for development and testing
  • Upgraded databases from Oracle 9i to 10g, Oracle 10g to 11g.
  • Performance monitoring and tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
  • Involved in construction of DR sites for all the Production environments.
  • Performed Database Refresh from Production to QA, UAT and Development databases.
  • Implemented and managed optimum physical database design (tablespaces , datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.
  • Provided instance level performance monitoring and tuning, Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Backup and recovery. Cold backups, hot backups, Logical backups, RMAN backups (Full, Incremental Backups, Differential, Cumulative Backups).
  • Implemented Standby Databases with high availability and performance configurations and participated in Switchover and Fail over tests
  • Monitoring Day-Day Backups, Log's.
  • Successfully implemented Backup & Recovery solutions using RMAN (Full, Incremental Backups, Differential, and Cumulative Backups).
  • Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
  • Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
  • Database cloning for development, testing from production
  • Responsible for capacity planning, database security, recovery planning and installing patches
  • Writing StoredProcedure, Functions, Trigger and packages using PL/SQL.
  • Shell Scripting.
  • Installed and configured Golden Gate
  • Replication using Materialized Views, Oracle Streams and Golden Gate.
  • Partitioned large tables for better performance and manageability
  • Migrating databases from Windows to Linux, Sun Solaris to IBM AIX.
  • Experience in Logical Database Design, Physical Database design

Environment: Oracle 11g RAC/10g RAC/Oracle 9i, Data Guard, Sun Solaris, IBM AIX, HP-UX, Red hat Linux, RMAN, ASM, SQL*Loader, Data Pump, Golden Gate, TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROF, EXPLAIN PLAN, AWR, ADDM

Confidential, Palo Alto, CA January 2010 - May 2011
Oracle DBA

Responsibilities:

  • 24*7 Production Database Administration Support
  • Oracle RAC installation, configuration and support for High Availability
  • Involved in developing a Disaster Recovery (DR) plan. Configuration and maintaining Standby Databases (Data Guard) for the production database and tested for Switchover, Fail over.
  • Cloned/Refreshed Oracle Databases for development and testing
  • Upgraded databases from Oracle 9i to 10g, Oracle 10g to 11g.
  • Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
  • Installed Oracle Data guard for Oracle Disaster recovery, High Availability and data protection.
  • Written PL/SQL Stored Procedures, Functions, Packages and Triggers
  • Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL, PL/SQL statements, reorganize database objects and design indexes to improve response of queries.
  • Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
  • Implemented Oracle database backup & recovery solutions using RMAN and Exports/Imports. Performed cold and hot backups.
  • Performed large batch jobs, and tuning of SQL queries and database systems.
  • Created user accounts, roles and granting access permissions to the database.
  • Written shell scripts for backup automation.
  • Involved in designing logical & and physical data models using power designer.

Environment: Oracle 11g RAC/10g RAC/Oracle 9i, Data Guard, Sun Solaris, HP-UX, Red hat Linux, RMAN, ASM, SQL*Loader, Data Pump, Golden Gate, Oracle Streams TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROF, EXPLAIN PLAN, AWR, ADDM

Confidential, San Jose, CA December 2007 - December 2009
Oracle DBA

Responsibilities:

  • 24*7 Production Database Administration Support
  • Installation and configuration of Oracle Server software 9i and 10g
  • Created Oracle 9i and 10g databases, allocated system storage and planned future storage requirements for the database.
  • Writing PL/SQL stored procedures and functions for data operations team and suggesting developers to write proper query to get optimal performance.
  • Written PL/SQL Stored Procedures, Functions, Packages and Triggers
  • Automated hourly, daily, weekly system health reporting using crontab, PL/SQL and shell scripts.
  • Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
  • Designed and developed various UNIX Shell, PL/SQL and SQL scripts to monitor the database. Maintained batch files, shell scripts and PL/SQL Procedures for scheduling backups.
  • Implemented Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN. Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
  • Implemented and maintained Database security. Created / Altered / Dropped Users as and when required and administer their respective quotas.
  • Implemented cloning using RMAN to migrate data from PROD to UAT/QA/SIT and Dev databases.
  • Implemented shell scripts for backup and recovery, Imported and exported procedure, implementing transportable table spaces.
  • Created Database Links and Snapshots (Materialized views).
  • Performed Hot Backups and maintained database availability to support non-stop Business operations.
  • Performance tuning using AWR, TKPROF, EXPLAIN PLAN & STATSPACK, AWR, ADDM
  • As a member of the analyzing and designing team, the responsibilities were to understand the application requirements and build up system specifications.

Environment: Oracle 11g /10g RAC/Oracle 9i, Data Guard, HP-UX, Red hat Linux, RMAN, ASM, SQL*Loader, Data Pump, TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROF, EXPLAIN PLAN, AWR, ADDM

Confidential, Milwaukee, WI October 2006 - November 2007
Oracle DBA

Responsibilities:

  • Installation of Oracle 9i, Oracle 10g and creation of databases.
  • Performed regular Backups and Recovery as per Organization Strategy to support the database for 24 hours uptime while carrying out the activities.
  • Responsible for configuration and implementation of backup strategies using RMAN.
  • Backup/Restoration, Scheduling Backups, taking Logical Backups.
  • Capacity Planning, Storage Allocation and Space Monitoring & Management.
  • Created Users, Roles with suitable Permissions.
  • Responsible for Partitions on tables and Indexes for managing large tables.
  • Maintained Logs/Backups
  • Coordinated with Unix Administrators for Space Management on various servers.
  • Performed SQL tuning by using Explain Plan and TKPROF and Oracle Enterprise Manager.
  • Created Users and Roles with appropriate Privileges.
  • Created Materialized views and database links.
  • Wrote shell scripts for monitoring the database.
  • Designed logical and physical Data Models using ERWIN.

Environment: Oracle 10g RAC/Oracle 9i/Oracle 8i, Data Guard, Sun Solaris, HP-UX, Red hat Linux, RMAN, ASM, SQL*Loader, Data Pump, TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROF, EXPLAIN PLAN, AWR, ADDM

Confidential, Hyderabad, India May 2005 - September 2006
Oracle DBA/Developer

Responsibilities:

  • Installation, configuration, and maintenance of Oracle Databases
  • Load data from flat files files which come from Mainframes systems into Oracle database by using SQL*Loader
  • Managing table spaces, data files, redo logs, tables and its segments
  • Writing SQL, PL/SQL Coding database triggers, packages, stored procedures & functions
  • Managing Users, Privileges, Roles, and takeing cold/hot backup of the databases
  • Monitoring and Reorganizing Table spaces/Tables/Indexes
  • Taking care of performance related issues by tuning memory as well as application tuning
  • Create and Maintain Roles and assign necessary privileges to users according to business rules in development environments
  • Optimization & Analyzing SQL queries for better Performance
  • Load data using SQL*Loader
  • Help users in creating database objects, and enrolling users

Environment: Oracle 10g/Oracle 9i/Oracle 8i, Windows, Sun Solaris, Red hat Linux, RMAN, ASM, SQL*Loader, Data Pump, TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROF, EXPLAIN PLAN

Hire Now