PROFESSIONAL SUMMARY:

• Over 9+ years of experience in database design, performance tuning and optimization of core Oracle Database 10g and 11g,12c.
• Lead the design, testing, implementation, maintenance, and control of the organization's physical, relational, and object - oriented databases across multiple platforms and computing environments.
• Develop data architectures and database management policies and standards.
• Provide senior-level consulting services in the identification and resolution of database issues.
• Serve as a high-level resource on database management issues, and participate in the planning, design, and usage of data resources.
• Experienced in Oracle 9i, 10g and Physical Hot Standby setup and administration.
• Having hands on experience in Upgrade/Migrate Oracle Database from 10g to11g and 12c.
• Hands on experience in configuration of Oracle Real Application Cluster 10g/11g/12c databases on Linux/Solaris Servers.
• Installation of OEM grid control, configuration and installing agents on all database servers.
• Experienced with 2 Terabyte size database and table partitioning.
• Experienced in Capacity Planning, Configuration, Installation, Upgrades and High Availability (HA) solutions and & Backup & Recovery, performance tuning & Cloning.
• Well documentation of install guide on Solaris 9,10,11 and SAN storage technology and RMAN
• Unix shell scripting and business reporting using sqlldr and sqlplus
• Have strong logical and physical database architecture and design experience, provide day to day DBA support.
• Experience in setup Oracle Data Guard, Logical and Physical database designs, object layout and sizing.
• Setup and configured Oracle 10g and 11g RAC implementations.
• Setup, implemented and supported Disaster Recovery on the production environments.
• Very strong experience in Database Security, data archiving, purging and Data Capacity Planning.
• Complete cycle of database migration from various oracle versions from oracle 9i to 10g, oracle 10g to 11g.
• Strong Perl and Shell scripting abilities and on-call support 24 X 7 Production server support.
• Hands on experience in managing the Linux servers and SAN environment for Oracle.
• Strong communication, leadership, organizational, analytical, interpersonal skills and strong problem solving skills.
• Good knowledge of implementing changes to development, test, and production environments.

TECHNICAL SKILLS:

Database: Oracle 10g, 11g,12c.

Operating Systems: UNIX, SUN Solaris, HP UNIX, Linux, AIX, HP,Windows NT/2000/2003

Tools: TOAD, Oracle Data Guard, ASM,Golden Gate, Oracle Grid Control, SQL Tuning adviser, Oracle Enterprise Manager, ERWIN, RMAN, EXPDP, IMPDP, Oracle Snapshots, IMPPD, EXPDP, SQL*loader, TKPROF, SQL Trace, Oracle Trace, UNIX tools (vmstat, sar)

Backup Tools: RMAN.

Languages: PL/SQL, SQL*Plus, Perl Scripting, UNIX shell scripting, Unix CRON jobs.

EXPERIENCE:

Confidential

Database Administrator

Responsibilities:

• Provides high technical expertise for the planning, analysis, design, development, implementation, maintenance and control of the organization’s server-class databases.
• Identifying performance bottlenecks using AWR and ADDM reports and resolving them.
• Worked on SQL and PL/SQL tuning.
• Worked onOracle 12C Grid Control including monitoring/setup and performance tuning purposes.
• Identifying deadlocks and other lock contention issues during stress tests.
• Upgraded database from 10g to 12c using DATAPUMP utilities
• Extensively involved in fine tuning home mortgage application SQL’s.
• Proactive tuning, suggesting recommendations to avoid performance problems.
• Extensively used EXPLAIN PLAN, Auto Trace and TKPROF for query refining.
• Analysis of Execution plans for each and every query for above application and recommending required Indexes, hints and partitioning to improve SQL query performance.
• Setup, configuration and installation of the RAC environment and ASM.
• Developed multiple automation scripts using shell script
• Used Grid Control and OEM Tool to monitor Stress tests.
• Oracle Advanced features to resolve performance issues.
• Extensively worked on Partitioning to improve performance.
• Extensive knowledge for PL/SQL programming.
• Performed POC for implementation of Oracle 11g new features.
• Architectural design for Golden Gate Implementation.
• Participated in designing and development of software using agile development practices.
• Performed research and development tasks to design and implement new components
• Developed user interface (UI) and data analysis component with integration of duplicate file finder
• Created automated diagnosis, testing and debugging modules
• Lead architect in data retention and data purging strategy.
• RMAN for backup and recovery.
• Dataguard for maintaining physical standby database.
• Exploring 12C database new features on local machine.

Environment: Oracle 10.2.0.4/11.2.0.3/11.2.0.4, 12c Super Clusters RAC, HP/AIX/Sun Solaris 9&10, Veritas Cluster, BCV, SRDF, OEM/OEM Grid Control, and RMAN

Confidential

SrDatabase Administrator

Responsibilities:

• Provides high technical expertise for the planning, analysis, design, development, implementation, maintenance and control of the organization’s server-class databases.
• Identifying performance bottlenecks using AWR and ADDM reports and resolving them.
• Worked on SQL and PL/SQL tuning.
• Worked on systems with high transactions rate.
• Identifying deadlocks and other lock contention issues during stress tests.
• Extensively involved in fine tuning home mortgage application SQL’s.
• Proactive tuning, suggesting recommendations to avoid performance problems.
• Extensively used EXPLAIN PLAN, Auto Trace and TKPROF for query refining.
• Analysis of Execution plans for each and every query for above application and recommending required Indexes, hints and partitioning to improve SQL query performance.
• Setup, configuration and installation of the RAC environment and ASM.
• Participated in designing and development of software using agile development practices
• Developed user interface (UI) and data analysis component with integration of duplicate file finder
• Developed multiple automation scripts using shell script
• Used Grid Control and OEM Tool to monitor Stress tests.
• Oracle Advanced features to resolve performance issues.
• Extensively worked on Partitioning to improve performance.
• Configured Active Data Guard for maintaining physical standby databases.
• Extensive knowledge for PL/SQL programming.
• Performed POC for implementation of Oracle 11g new features.
• Architectural design for Golden Gate Implementation.
• Lead architect in data retention and data purging strategy.
• RMAN for backup and recovery.
• Dataguard for maintaining physical standby database.
• Exploring 12C database new features on local machine.

Environment: s: Oracle 11g, RAC, Oracle Data Guard, Oracle Grid Control, OEM RMAN, Golden Gate

Confidential

Sr Oracle DBA

Responsibilities:

• Responsible for issue resolutions participates in client meetings and presentation.
• Managed performance of team members, career, and development planning.
• Facilitated goal and objective setting, promotions and performance reviews.
• Installation and Configuration of Oracle 11g R2 Real Application Clusters (RAC) databases on OEL 5.5
• Adding nodes to existing RAC environment.
• Cloning the Oracle Databases from Production to Development servers.
• Performing Logical backups using Export and Expdp Utilities.
• Performing daily incremental backups, weekly backups using RMAN.
• Schema, Table, Database refreshes on demand for dev teams
• Cloning the databases from Production to Test environment using Hot/cold/export/RMAN backups.
• User creation and providing necessary Roles, Privileges and quota as per the requirement.
• Monitoring the Table spaces and adding/resizing datafiles.
• Created indexes and rebuild indexes in order to improve query performance.
• Configured physical standby database (DATAGUARD) and tested for failover and switchover.
• Configured the Cloned databases for reporting purpose.
• Generating AWR reports to monitor database health.
• Oracle Database Patching.
• Upgrading the database from 9.2.0.6 version to 10.2.0.3 version
• Doing cross platform migration using Export/Import from Sun Solaris to Linux server.

Environment: Oracle 9i,10g, RAC, SAN, Oracle Data Guard, Oracle Enterprise Manager (OEM), RMAN, Oracle Data Warehouse, TOAD, Windows 2000, 2003, SUN Solaris, Sybase, Linux, AIX and HP-UX.

Confidential

Database Administrator

Responsibilities:

• Provided the Oracle 9i and 10g RDMS environments and performed installation, configuration, upgrade, maintenance and support.
• Configured logical and physical database architecture and design experience, provide day to day DBA support.
• Experience in setup Oracle Data Guard, Logical and Physical database designs, object layout and sizing.
• Involvement in Disaster recovery Level of experience with parallel servers
• Standby Server for Oracle 9i and 10g Databases
• Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.
• Cloning databases.
• Setting up new environments (Development, Production etc)
• Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Setting up Oracle Parallel server, 9i RAC.
• Creating databases, setting privileges, user logins, passwords (security), tablespaces, data objects, tables, indexes.
• Deciding the naming conventions of datafile, redo log files, tablespaces, and segments.
• Provided the support for application development team by doing data refreshes using cold backup cloning and hot backup cloning for various development and test instances.
• Created the duplicate databases and did databases refreshes of Production databases on remote nodes using the NFS mount of production servers to the remote nodes, FTP transfer of data files to remote nodes, and copying the backup data files from the tape.
• Database installation, Configuration and Creation.
• Created and maintained hot standby databases using Oracle Data Guard
• Provided on-call and call back support for 24/7 continuously for the last 2 months for the issues related to RDBMS software and related database components and also for application related issues.
• Implemented database monitoring system using Oracle Enterprise Manager Grid Control
• Installed and configured RMAN for automatic backup and recovery of databases at pre-defined schedules
• Managed projects by developing implementation plans and timelines, providing weekly status reports, preparing technical documentation pertaining to various projects, exchanging relevant information with
• Management and technical teams, and meeting timelines established.