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 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
Privacy Policy
