PROFESSIONAL SUMMARY:

• Around 8 years of experience in all stages of systems development life cycle including business requirements gathering, design, data conversions, Data modeling, programming, system / integration / user acceptance testing, documentation, production support in Oracle Database Management Systems.
• Experience in Database Installations, Configuration, Monitoring, Maintenance, Patches, Data Migration, Database Upgrade, Database Security and supporting Oracle RAC and DB Applications.
• Experience in Performance Tuning, Troubleshooting, SQL Tuning, Query Execution Plans, AWR reports, ADDM, ASH reports, Stats Pack Reports, UNIX base monitoring, STATS gathering and Data retention.
• Proficient use of Oracle Enterprise Manager OEM .
• Wrote Run books for a number of applications for preparing oracle database migration process, procedure and scripts.
• Troubleshoot Database performance issues using Automated Workload Repository AWR and Automatic Database Diagnostics Monitor ADDM .
• Monitored and tuned Rollback segment, temporary tablespace, redo log buffer, sort area size.
• Maintained Users and Roles with Appropriate Privileges and Profile.
• Expert in Backup and Recovery, Performance Tuning, Data Guard, Real Application clusters, Data Architecting, Database Design, Capacity Planning of database administration.
• Proficient in understanding ERD model and translating into table structure and indexes.
• Proficient in Oracle RDBMS including SQL, PL/SQL and all areas of database Administration.
• Performed backups, recoveries, installations, database performance tuning, tuning applications, database monitoring and operating system configurations.
• Laying out database tables and database schema design, startup and shutdown of Databases.
• Experience in writing proactive monitoring scripts like monitoring the disk usage, memory usage of the server and monitoring tablespaces and alert log etc.
• Installing the Oracle software and creating test, pre-prod, DR and production databases including configuring Oracle RAC. Hands on experience in OEM Oracle 11g,12c, RAC, Oracle Security Suite, Dataguard and Flashback technology.
• Experience with using 3rd party tools like SQL DEVELOPER and TOAD to manage the environment.
• Extensively participating in the slotting, planning meetings, working with application engineers and development to collect the requirements for the application upgrades, patch installs, HotFix installs.
• Participating in Oracle software and application upgrades, setting up disaster recovery and participated in DR exercise.
• Experience in Performance Tuning, Scripting, Disaster Recovery Techniques, Backup Recovery for Oracle 10g/11g/12c databases.
• Implemented best practice scripts to monitor the databases health check.
• Provided 24x7 production DBA support along working with the engineering development teams for test and production Oracle Databases on IBM's AIX, OEL 5.9,Linux and Solaris platforms.
• Implemented security protocols for the database.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Role: Sr. Oracle DBA / Developer

Responsibilities:

• Working as principal oracle DBA to provide analysis of customer infrastructure environment and contribute to solution creation, design and deployment.
• Provided services to ensure maintenance and support to the customer requirements with the objective of providing high-quality and value-adding consulting solutions that enable the clients to meet the changing needs of the global landscape.
• Provided services to ensure the enterprise database backup and design, implement and deploy enterprise database backup and recovery strategy.
• Documentation skills for processes and procedures creating runbooks etc.. .
• Provided service for database high availability HA including active DATAGUARD and RAC administrations, configuration and performance tuning, monitoring and troubleshooting.
• Scheduled, troubleshoot, fixed and restarted failed RMAN tape Netbackups: level 0, 1, 2 Incremental, differential and archive log redo log backups .
• Data Modeling Design with ERwin .Used OEM for managing production Oracle databases between 1 - 49 terabytes sizes databases, hosts and other related components.
• Worked on validating constant invalid database objects issues using scripts to generate and re-validate them during or after code releases.
• Gathered statistics on stale tables, indexes partitions and sub-partitions.
• Administered all nightly scheduled weekly monthly production database code releases implementation.
• Involved the Post-migration task Unit-testing for every RAC standalone servers.
• Designed, documented, implemented and maintained all disaster recovery procedures which result in no data loss.
• Created documents and put on SharePoint and updated the Run books in daily basis.
• Perform daily operational duties/security for all users of the databases.
• Setting up the Cron jobs to monitor file systems usage, archive logs, backup logs, periodically clean up these file systems and also monitor Hot Backup Scripts.
• Supported developers for efficient SQL tuning, performance monitoring, Data modeling, created explain plan to troubleshoot database designers SQL and PL/ SQL code issues.
• Performed database refreshes and database copies for development, test and production databases.
• Refreshed schema level and full level production to non-production databases.
• Used OEM SQL Plus, TOAD to monitor and troubleshoot database performance issues such as high CPU utilization, long running queries, batch jobs, blocking locks, create explain plan to tune badly written SQL statements , generate ASH reports etc.
• Worked on Remedy ticketing request and request directed to the DBA email queues.
• Weekly implementation of import/export and data pump backups of key database schemas before jump starting the weekly code release onto production.
• Added ASM storage whenever spaces are used-up in production.
• Provided services to application support teams and client management for purposes of explaining and defining optimal database strategies and operations.
• Provided 24x7 on-call production support.

Environment: Oracle10g,11gr2 12c, DB2 V9.1, RMAN, Data Guard, Data modeling, ETL, Data Warehousing data mart , RAC, Shell Scripting, Informatica, Toad, Windows 7/2003/2008, UNIX SOL, AIX, LNX , ASM, SQL, Putty, WinSCP, SQL Developer, BMC Remedy, PL/SQL.

Confidential

Role: Oracle DBA / Developer

Responsibilities:

• Performed core DBA tasks such as Database Administration on Oracle 10g/11g environments, performance tuning, schema creation, maintenance and troubleshooting..
• Developed ad hoc shell scripts and dynamic SQL codes to automate and schedule maintenance jobs.
• Involved in performing Oracle 10g to Oracle 11g upgrades on Sun and Linux.
• Designed conversion of non-partitioned to partitioning of very large tables for performance improvement.
• Documented database infrastructure guide, operation guide, build books and run books.
• Coordinated with application patches and database upgrade from Oracle 10.2.0.3 to 11g release 2.
• Worked on RAC on RHAS with 4 nodes server side load balancing using Automatic Storage Management.
• Worked with PL/SQL stored procedures, developed SQL scripts and Korn shell scripts to automate tasks.
• Database Cloning Advanced Queuing Concepts.
• Worked on Shell scripts given by Linux Admin for automating various database tasks in UNIX platform.
• Created and maintained standby databases.
• Created new users and managed roles and privileges.
• Managed Rollback Segments, Redo logs, Control files, and Table spaces.
• Developed and fine tuned PL/SQL UNIX that update the data warehouse on their scheduled run.
• Generated reports in Oracle Reports by analyzing the database based on the specific business requirements.
• Involved the Post-migration task Unit-testing for every RAC standalone servers.
• Communicate and coordinate with Oracle using TAR system for major database issues/ problems apply the required patches, test unit test/ system test and roll out and implement the patches into production.
• Involved in disaster recovery planning detailed out the processes and procedures of implementing disaster recovery implemented database backups and disaster recovery.
• Proactively managed the databases set up alarms for managing any exceptions in day to day management of the databases pre-empted and prevented issues disasters from happening.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Successfully configured the databases to switchover, failover and fallback scenarios.
• 24x7 production support DBA working on a primary/ secondary pager rotation and supported on holidays, weekends and beyond regular hours.

Environment: Oracle 10g/11g, RMAN, Data Guard, RAC, Shell Scripting, Data Modeling, ETL, Data Warehousing, Informatica, Toad, Windows 7/2000/2008, UNIX, ASM, SQL, PL/SQL.

Confidential

Role: Oracle Database Admin / Dev

Responsibilities:

• Installation and configuration of the development, test and production Oracle 10g/11gR1 databases.
• Coordinate and communicate with application development teams for database code migration per release.
• Created and managed documentations on processes and technical design.
• Implemented various partitioning strategies for very large tables.
• Monitored growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
• Involved in design and implementation of Oracle Data guard.
• Installed, upgraded and patched Oracle Software and associated application.
• Responsible for Oracle database upgrade 10g to 11g.
• Involved in Backup, Restoration and Recovery strategy.
• Implemented ARCHIVE LOG process and procedures for automatic copying files to development server as they generated.
• Performed I/O tuning, Performance Tuning and benchmarking using TeamQuest
• Worked intensively with Oracle support in identifying and patching the 11gR1 bugs.
• Implemented backup and recovery solutions using Shadow Image technologies and RMAN.
• Maintained tablespaces, Storage management SGA and Undo Management.
• Routine database activities like applying patches, cloning maintenance and performance monitoring.
• Configured RMAN backup to tape and scheduled through Autosys on dev and UAT RAC environment.
• Generated and analyzed STATSPACK reports and monitoring statistics for performance tuning of the database.
• Tuned PL/SQL, SQL with Automatic Workload Repository AWR and Automatic Database Diagnostic Monitoring ADDM .
• Performed Database health checks, and used the notification tool to send the alerts in OEM Grid Control.
• Supported and managed Oracle Real Application Clusters RAC environment on Red Hat Linux.
• Applied Database software fixes/patches.
• Built Physical standby databases using Data guard as part of the BCP disaster recovery strategy.
• Identified database bottlenecks using OEM Grid Control, AWR, ADDM, STATSPACK, UTLBSTAT, UTLESTAT, ESTIMATE, ANALYSE, INDEXES, EXPLAINPLAN, SQLTRACE and TKPROF.
• Created database security strategies by creating database users, user roles, profiles and audits.
• Involved as an architect for Interfaces and extraction routine for electronic transfer of files from/to different company using SQL, PL/SQL, Stored Procedures and Triggers.
• Developed the PL/SQL codes on the basis of the requests for the change.
• Shell scripting for automated batch process. Modified, maintained and developed the SQL codes to develop new enhancements.
• Used data pump import/exposure utility of ORACLE to create other development and test databases.
• Troubleshooting for Production database issues/performance issues based on the tickets assigned Remedy Ticketing Tool .

Environment: Oracle 10g/11g, DB2 V9.1, RMAN, Data Guard, Data modeling, Shell Scripting, Toad, Windows 7/2008, UNIX, ASM, SQL, PL/SQL.

Confidential

Role: Oracle Database Admin / Dev

Responsibilities:

• Created and maintained Oracle databases across multiple platforms.
• Builds included everything from configuring the Solaris, AIX and HP-UX environments, installing Oracle software and patching to desired levels including patches, creating instances, recompiling invalid objects, recalculating statistics.
• Developed, Implemented and administered database policies and procedures.
• Applied patches and migrated databases from one platform to another, along with upgrade from Oracle 10g to 11g and maintained an updated platform matrix.
• Worked with developers and troubleshooted applications issues.
• Enhanced application performance, by providing proactive tuning and setting database maintenance plan for mission critical application running.
• Conducted optimization and performance tuning of database, SGA and space management.
• Managed archived redo files, loading data for users by using SQL Loader.
• Set up Cron jobs to monitor file systems usage, archive logs, backup logs, periodically clean up these file systems and also monitor Hot Backup Scripts.
• Tuned Oracle Initialization Parameters.
• Supported developers in tuning Database and applications for optimal performance.
• Created database physical/logical layout design and procedures for production, development and test servers.
• Performed capacity planning to create and maintain the database environments.
• Gathered Database Instance Statistics generated reports using STATSPACK.
• Design and implement database backup and recovery procedures using RMAN and Data pump.
• Created and maintained table spaces, tables, indexes, users, roles, privileges and security.
• Configured server with OLTP system, runtime connection load balancing.
• Provided 24x7 on-call support.

Environment: Oracle 10g,SQL, PL/SQL, SQL Loader, Oracle,, Windows NT, Sun Solaris and IBM AIX servers, Lotus Notes, Rational change.