SUMMARY

• 8 years of experience in Oracle DB administration, development, database design, performance tuning capacity planning, Installation, Patching, Upgrading, Migration, Backup & Recovery.
• Experience in providing 24x7 supports with customers in Banking, Insurance, Retail domain.
• Wide exposure on Installation, upgrading databases to higher versions and patch management.
• Enabling database alerting mechanism using OEM Grid Control.
• Worked on performance and capacity assessment and tuning of very large databases. Involved in Performance tuning of OLTP databases.
• Good knowledge on working with logical and physical data models. Worked on enhancement of physical data model changes.
• Handling all daily operational activities related to database management and administration.
• Tuning databases and user queries using AWR/STATSPACK/ADDM reports.
• Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space.
• Worked on performance and capacity assessment and tuning of 15TB large databases
• Good experience in SQL Query Tuning and key Oracle performance related features such as Execution plans, Hints, Indexes and table Partitions.
• Extensive experience with Oracle - Dataguard, RMAN, ASM, AWR, OEM, PL/SQL, performance tuning, migrating databases across databases, Logical design, Unix Scripting.
• Has hands-on experience in Creating, reorganizing the databases, Installing and Upgrading of Oracle with different versions.
• Experience on Oracle 10g and 11g Grid Control, Experience in tools like OEM, SQL*NET, Net Configuration assistant, Oracle Universal Installer.
• Experience on monitoring tools like nmon, perfmon, vmstat and AWR.
• Applied the patch sets released from time to time, performed Application tuning (SQL tuning, Memory Tuning).
• Worked on shared delivery model. Ability to handle multiple projects and meet the project deadlines on time.
• Excellent analytical, problem solving, communication, managerial and interpersonal skills with the ability to interact with individuals at all levels.
• Good interpersonal skills, self-motivated and fast ability to absorb new technology and very good team player.
• Provide on-call support for staging and production deployments. Experience in providing 24x7 supports.

TECHNICAL SKILLS

Databases: Oracle10g & 11g, Teradata12, SQL server2005/ 2008

Operating Systems: AIX/HP-UX/Windows, Mainframe

Languages: PL/SQL, SQL, T-SQL

Tools: Utilities Tidal Scheduler, Facets5.1, Jprofiler, APP Dynamics, PowerCenter9.1, vmstat, nmon, perfmon, AWR, OEM, JIRA, QC, TFS, SVN

Backup/Recovery: Exp/Imp, Datapump, RMAN backup, SQL Loader

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA

Technology: Oracle 11g, Java, Facets5.1, Dataguard, AIX, Powercenter 9.1

Tools: vmstat, nmon, perfmon, OEM, AWR, Tidal Scheduler, JIRA, Toad, Jprofiler

Responsibilities:

• Analyze AWR to provide capacity assessment.
• Actively worked on AIX P6 to P7 processor uplift.
• Analyse vmstat, nmon on prod for CPU, memory, RunQueue utilization for AIX uplift.
• Extensively used Grid Control ( OEM ), and Toad to maintain various database servers.
• Worked on Database Cumulative L0, L1 backup and Differential L1 backup in RMAN.
• Handle high severity issues and problem tickets
• Identifying gaps in database environments and addressing them.
• 24x7 support for Non-Prod, prod databases to keep business running
• Taking logical database backups using datapump.
• SQL Tuning using Explain plan and SQL Tuning Advisor .
• Worked with SR- Oracle Support to resolve different database related issues.
• Complex SQL and PLSQL performance tuning.
• Database and Server tuning and application tuning using Jprofiler and Perfmon.
• Oracle 10g, 11g installation, upgrading databases to higher versions and patch management.
• Data guard - Physical, Logical standby database maintenance.
• Extensively used Grid Control (OEM), and Toad to maintain various database servers
• Set up new DB and provided all database-related support for the DEV and Test databases.
• Gather DB stats, Perform database backups on daily basis and On-Demand during QA testing.
• Review and modify DDL/DML scripts produced by the data modeler as per project requirement.
• Generate DDL/DML scripts for Table and column addition and data-type changes using Visio and implement it in the database.
• Involved in designing, managing of schemas and database design.
• Create/Maintain the users in the Non-Prod, prod server and grant permissions
• Monitor the database during testing and code deployment.
• Disk/Space/File system maintenance and file movement as UNIX level, File/folder clean up/housekeeping.
• Capacity planning of the databases/applications by performing Load testing, Scalability testing and Performance testing of database to identify the system capacity and future load.
• Analyze Workflow log and tune them, Informatica SQL tuning.
• Automation of day-to-day DBA tasks / reports using cron jobs.

Confidential

Oracle DBA

Technology: Oracle11g/10g, UNIX Scripting, Data Stage8.5

Tools: Exp/Imp, SQLLDR, Datapump, vmstat, nmon, perfmon, Toad, SVN, QC, JIRA

Responsibilities:

• Providing 24X7 on-call support to maintain all Databases up and running in Production environment
• Oracle Installation, up-gradation to higher version.
• Physical Standby Database maintenance.
• Worked on Database Cumulative L0, L1 backup in RMAN.
• Expertise in database backup/recovery using RMAN and export-import.
• Extensively involved in Cloning Database from production to development
• SQL Tuning using Explain plan and SQL Tuning Advisor.
• Upgrading databases to higher versions and patch management
• Used Exp/Imp, Datapump and SQLLDR utility for data transfer between staging and development.
• Write PL/SQL procedures, UNIX scripts to handle AS/400 feed file in oracle server.
• Write UNIX scripts for purging activities.
• Implemented Uni-directional replication across the database in golden gate
• Tuning of databases which includes Server side tuning and application tuning.
• Upgrade Oracle database from 9i/10g and 11g.
• Refresh TEST and DEV (Oracle) from production databases as and when required.
• Optimized different SQL queries to insure faster response time.
• Provided on-call support regarding production-related database problems.
• Perform testing of scripts and procedures and Setup test environment.
• Help QA/DEV team in performing unit and system testing.
• Monitor the database during testing and code deployment.
• Provide faster solution for issues coming up on QA testing window.
• Capacity planning of the databases/applications by performing Load testing, Scalability testing and Performance testing of database to identify the system capacity and future load.
• Involved in designing, managing of schemas and database design.
• Create/Maintain the users in the Non-Prod, prod server and grant permissions
• Monitor the database during testing and code deployment.
• Disk/Space/File system maintenance and file movement as UNIX level, File/folder clean up/housekeeping.

Confidential, Bentonville

Oracle Database Analyst

Technology: Oracle 10g, 11g, Teradata, DB2, Datastage 8.5, UNIX, AIX, Solaris

Tools: Oracle Grid control, Dataguard, Toad, AWR, vmstat, nmon

Responsibilities:

• Responsible for installing, upgrading and configuring Oracle11g environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Data guard - Physical, Logical standby database maintenance.
• Evaluated server/instance architecture, hardware, system specifications, and capacity planning.
• Hands on experience on performance tuning, identified and reduced/eliminated non-idle wait events such as scattered file read, sequential file read wait event, log file completion, in queue, and buffer latch waits.
• Set up new DB and provided all database-related support for the production as well as test databases
• Performed performance/memory tuning, server/database monitoring, and configuration.
• Upgraded from Oracle 10g to 11gR1
• Experienced in EM Grid Control. Extensively used for query execution plan, ASH, and AWR.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Experienced with utilities like Data Pump, SQL Loader, Export/Import.
• Worked on database restores at times of critical failures.
• Implemented Oracle database backup &recovery solutions using RMAN.
• Cloned and refreshed production database to testing and development environments.
• Provided all kinds of DBA support to DEV teams & production support to various applications.
• Review and modify DDL/DML scripts produced by the data modeler as per project requirement.
• Generate DDL/DML scripts for Table and column addition and data-type changes using Visio and implement it in the database.
• Perform testing of scripts and procedures and Setup test environment.
• Help QA/DEV team in performing unit and system testing.
• Monitor the database during testing and code deployment.
• Provide faster solution for issues coming up on QA testing window.
• Involved in designing, managing of schemas and database design.
• Create/Maintain the users in the Non-Prod, prod server and grant permissions
• Monitor the database during testing and code deployment.
• Disk/Space/File system maintenance and file movement as UNIX level, File/folder clean up/housekeeping.

Confidential

Oracle Apps DBA

Technology: Oracle 11g/10g, UNIX, Windows, PL/SQL, Datastage 8.5

Tools: SQL developer, OEM, RMAN, Dataguard, Visio, QC, Microsoft TFS

Responsibilities:

• Providing Oracle DBA support for implementing RMAN backup/recovery strategies.
• Maintained Database servers through OEM.
• Analyze existing database system and architecture and improve performance
• Used PL/SQL for various work and tuned as and when required.
• Recorded in the document all the commands and responses in the testing scenarios in order to provide an accurate reference manual for doing recovery when disaster strikes.
• Recovered successfully two production databases from RMAN backups due to an unexpected media failure resulting in data corruption errors.
• Checking alert logs for any database errors and correction
• Execution of user scripts in production environment
• Strong Experience working in ITIL environment
• Review and modify DDL/DML scripts produced by the data modeler as per project requirement.
• Responsible for new entity and attributes addition to the database.
• Physical implementation of data model changes in DB like table, column, Data-type and indexes.
• Provide faster solution for issues coming up on QA testing window.
• Identify, trace and tune SQL queries for better performance
• SQL Tuning using Explain plan and SQL Tuning Advisor.
• Tuning database queries and PL/SQL performance tuning for larger Databases.
• Help QA/DEV team in performing unit and system testing.
• Provide faster solution for issues coming up on QA testing window.
• Identify, trace and tune SQL queries for better performance

Confidential

Oracle DBA

Technology: Oracle 11gR1/10.2, Solaris, AIX/HP-UX/Windows, SQL Server 2005, ITIL

Tools: Toad, SQL Developer, T-SQL, SQL, PL/SQL, OVSC, QC

Responsibilities:

• Involved in designing, managing of schemas. Managing schema objects, such as tables, indexes, and views
• Monitor DB growth and provide DB capacity planning for apps expansion
• SQL and PL/SQL: scripts, triggers, procedures, packages maintenance and tuning.
• Manage users, maintain systems security, control and monitor database access
• Monitor alert log and trace files & Manage disk space and archive location
• Worked on Database Cumulative L0, L1 backup and Differential L1 backup in RMAN.
• Set up new databases and provided all database-related support for the DEV as well as Test databases.
• Gather DB Stats, Perform database backups on daily basis and On-Demand during QA testing.
• Worked with ITIL processes (Incidents, Change, Patch and Problem Managements) & SLA.
• Tune databases and SQLs using tools like EXPLAIN PLAN, TK-Prof and PL/SQL procedure tuning.
• Duplicated, refreshed lower environments using RMAN
• Database and Server tuning and application tuning.
• Oracle 10g, 11g installation, upgrading databases to higher versions and patch management.
• Data guard - Physical, Logical standby database maintenance.
• Design and implement DB security, user management
• Support developers in tuning DB and apps for optimal performance
• Install, configure, upgrade software: server, tools, applications
• Create/Maintain the users in the Non-Prod, prod server and grant permissions
• Monitor the database during testing and code deployment.
• Disk/Space/File system maintenance and file movement as UNIX level, File/folder clean up/housekeeping.
• Automation of day-to-day DBA tasks / reports using cron jobs.