SUMMARY

• Overeight yearsof experience in the IT industry involving Production Database Administration.
• Oracle Database Administration experience in variety of different environments likeHP - UX, SUN SOLARIS, AIX, RedHat Linux and Windows.
• Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, Unix shell scripting and documentation.
• Experienced in installing and setting up Oracle 11g, 10g, 9i, 8i databases.
• Planned and implemented high availability solutions usingOracle 10g RAC,Oracle 11g RACStandby Database(Oracle Data Guard).
• Good Knowledge of Installation, configuration, Monitoring and maintenance of Oracle Databases, ASM, CRS cluster ware administration.
• Worked with a team to support 24/7 production environments.
• Demonstrated ability to identify root causes of problems, consider both long and short-term impact of proposed solutions and develop workable solutions. Ability to manage multiple project tasks with changing priorities and tight deadlines.
• Expertisein Oracle performance tuning using STATSPACK, TKPROF, Explain plan.
• Effective troubleshooting of database and performance problems.
• Experience inSQL, PL/SQL.
• Worked with development teams and data administration staff to enhance Database and application performance.
• Monitoring, identifying areas that need to be improved in the application and database.
• Management of schemas, objects and partitioning the tables, indexes.
• Experience in managing Very Large Oracle Databases (VLDB) which includes OLTP as well as DSS. Experience in Data warehousing and ETL
• Excellent experience inPartitioning, which includes List, Range, Hash and Interval partitioning.
• Experience in administration of large Oracle databases running inSANenvironments, setting up databases for bank environment.
• Proficient in Logical Database Design, Physical Database Design and Normalization.
• Experience in Data Migrations using oracle export/import, data pump, sqlldr.
• Performed backups and tested crash recoveries using conventional hot & cold backups andRMAN.
• Proficient in usingOEMandRMAN.
• Excellent experience in OLTP/DSS database systems, implementing and managing Very Large Oracle Databases (VLDB) of size multiple TB.Expertise in data warehousing design and ETL.
• Demonstrated ability to work well with a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit, help team resolve conflicts constructively and ability and willingness to communicate when help is needed.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges. Strong listening, interpersonal and analytical skills.

TECHNICAL SKILLS

Operating Systems: HP-UX 11,11i Sun Solaris 8(5.8),9(5.9),10(5.10) AIX 5.2,5.3,6.1, Red Hat Linux RHEL 4,5,6

RDBMS: Oracle8i, Oracle 9i, Oracle 10g (RAC), Oracle 11g (RAC)

Languages: SQL, PL/SQL, C, PERL, UNIX Shell

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, EXPDP, IMPDP, ERWIN, TOAD

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

Web Tools: HTML,XML

PROFESSIONAL EXPERIENCE

Confidential - Washington DC

Sr. Oracle DBA

Responsibilities:

• 24x7 production support for several mission critical systems which utilize up to 45 Oracle Production Databases running on Linux/Solaris environment.
• Performed databasecloningto setup test and development databases.
• Installation, Configuration and Maintenance of 5 node Oracle 11g RAC databases with ASM
• Upgradeddatabases from Oracle 9i, 10g to Oracle 11gR2.
• Applied patches to Oracle RDBMS in Development, Test and Production environment
• Converted to Oracle RAC 3 node from Single Instance database using rconfig.
• Cloned/Refreshed Oracle Databases for development and testing.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold backup (user managed and RMAN) plans.
• Setup of recovery catalog for RMAN.
• Performed workload balance by configuring services based on application priority.
• Setup backup and recovery procedures using RMAN. Performed hot and cold backups using RMAN and automated RMAN backup using scripts.
• Set upCronjobsto monitor file systems usage, archive logs and cleaning up of these file systems periodically.
• Set up local listeners on each node for high availability solutions.
• Performed block recovery using RMAN. Performed backup validations using RMAN.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management ofschemas, objectspartitioningthe tables & indexes.
• Automation of data load using Korn shell scripting andSQL*Loader.
• Responsible for setting up and managinguser accounts, granting required privileges to users.
• Perform other regular DBA activities including space management and performance monitoring.
• Optimizationand tuning usingTRACE FILE,TKPROF,EXPLAIN PLAN, AWR, ADDM.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Backup & Recovery, Disaster Recovery, DatabasePerformance Tuning, Memory Tuning, Application Tuning, Security Administration, DataWarehousing, Data Guard, Real Application Clusters.

Environment: Oracle Server11g RAC, 10g RAC/9i, SQL, PL/SQL, HP-UX, Sun Solaris, OEM, SQL Plus, SQL Developer

Confidential - Phoenix, AZ

Oracle DBA

Responsibilities:

• As a part of a team of seven DBAs, I am responsible for the support of a life cycle development systems running oracle 10g and 11g on windows and unix based environment.
• 24X7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Install, Configure, monitor, administer, upgrade, troubleshoot and patch 10G/11G Oracle database in Multi Node RAC Unix in a Development/Production Environment.
• Used RMAN to Backup/Recover Production/UAT/Training/Dev databases regularly.
• Proactive database monitoring using 10g grid monitoring tool.
• Assist the application developers in testing and debugging new programs to ensure compatibility with existing server technologies.
• Performed oracle administration for 6 RAC clusters. Duties include checking node health, resizing disks when needed, workload partitioning by creating services with preferred nodes and available nodes, schema creation, mirroring OCR files.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Fix data errors from the urgent tickets created by users/help desk.
• Performed database full, incremental, differential backups using RMAN.
• Implemented Dataguard technology and configured switchover and failover with physical standby database on UNIX environment
• Performed databasecloningto setup test and development database.
• Conductingsizing& capacity planning forOracledatabases.
• Upgradingdevelopment andproductiondatabases to Oracle 10.2.0.4
• Applied patches to Oracle Databases and Oracle Applications.
• Involved in meetings with the users and gathered necessary requirements for creation of databases.
• Implemented password verify function and stored procedure for user profiles and safeguarded database privileges and security
• Identified causes for the slow performance of cluster database and worked proactively to do the necessary changes, created a snapshot of database statistics for future reference.
• Responsible for optimizing the queries and application tuning.
• Resolved database incidents to ensure database stability and availability.
• Created External Tables to access the data in external sources(flat files, LOB data)
• Moved the data (schemas, tables) among the development databases using datapump utility.
• Registered databases to RMAN repository for Linux and Windows servers.
• Code review to ensure that the new customizations were developed to meet requirements.
• Effectively communicate and assisted offshore application developers with various requests.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Responsible for setting and managinguser accounts, profiles, auditing user sessions.
• Generated and analyzed AWR and ADDM report for system performance enhancement.
• Code Promotions to UAT & Production environments

Environment: Oracle Server 11g, 10g RAC /9i, SQL, PL/SQL, AIX, Sun Solaris, Red Hat Linux, SQL Plus, Toad.

Confidential - Atlanta, GA

Oracle DBA

Responsibilities:

• Primary responsibility to support several Production, Test and Development databases (10g, 9i) running on HP-UX platform
• Configured the database for warehouse implementation, cloned schemas and databases using RMAN.
• Applied PSU/CPU security patches to 19+ databases on six Dev, seven Test and six Prod database environments.
• Deployed Profiles, Password Functions and DB hardening/lockdown process to database accounts & environment to comply with enhanced security standards dictated under Baseline Control Standards, audit vendor standards.
• Run Sql tuning set's exercise to identify any index recommendations to be implemented
• Created/rebuilt indexes and computed stats to decrease physical and logical i/o on the sql executions and better execution plan selection (used v$ views and top to identify the problem sessions)
• Assisted developers in troubleshooting sql execution plan/performance using event 10046 setting at the session level during performance tuning exercises.
• Rediscover new components created on the database servers for monitoring
• Co-ordinate tasks with offshoreDBA's for database work (running audit scripts, tasks assigned directly by clients, etc.
• Recovered database on Windows platform due to disk and hardware problems
• Restored production databases for DR (Disaster recovery) exercise on Sungard servers using previous hot backups and RMAN scripts.
• This included planning and execution of recovery with assistance from Sys Admin and Storage administrators.
• Tuned database using statspack reports, creating new indexes, computing stats on tables - to decrease the physical i/o(3k/sec to < 100/sec) and logical i/o (8k down to 3k)per second on sql statement executions .
• Was awarded Geek of the Week award for working with technical teams, vendor and recovering the production database

Environment: Oracle Server 10g/9i, SQL, PL/SQL, SQL Plus, AIX, HP-UX

Confidential

Oracle DBA

Responsibilities:

• Provided support for all the oracle databases as an operational database administrator.
• Installed and configured Oracle 8i databases.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recovery.
• Responsible for optimizing the queries and application tuning.
• Worked with Sys admins, storage and backup admins to setup theoracleenvironment, backup process using RMAN
• Run AWR and statspack reports to identify sql with large buffergets and physical reads per execution.
• Created/rebuilt indexes and computed stats to decrease physical and logical i/o on the sql executions and better execution plan selection
• Upgraded and patched databases (8.0.5, 8.1.6, 8.1.7.0 TO 8.1.7.x, 9.2.0.x) on Production, Test and Development boxes
• Implement Hot, Cold and Logical backup plans.
• Created and maintained RMAN catalog on production environment
• Analyze, design and implementation of the Database for e-commerce system.
• Migrated data using export/import and loaded delimited flat file data using sql loader.
• Proactive database monitoring using automated scripts based on v$ views.
• Frequent Database audits to ensure the SOX standards were not violated.
• Developer Environments setup using database cloning and refresh procedures.

Environment: Oracle Server 8i, 9i, SQL, PL/SQL, SQL plus, Sun Solaris, Windows 2002.