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/2003Languages:SQL, PL/SQL, Java, C, UNIX shellTools:RMAN, SQL*Loader, Data Pump, Exp/Imp, TOAD, ERWINTuning Tools:Golden Gate, Streams, ODI, OEM/Grid Control, TKPROF, STATSPACK, AWR, ADDM, ASH, TOAD, ASMDatabase Modeling:ERWIN, Rational roseOthers:EMC, NetAPP, VERITAS Net Backup, IBM TSMWeb 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 Stored Procedure, 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