PROFESSIONAL SUMMARY:

• Around 8 years of specialized experience as an oracle Database Administrator on different environments like Oracle and Windows platforms.
• Experience in tuning, development, analysis, design, all phases of Software Development Life Cycle, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, data modeling, backup and recovery, cloning, auditing, SQL, PL/SQL, troubleshooting.
• Experience in accomplishing DBA daily activities such as Schema, user and space management.
• Performed tuning and performance monitoring, Real Application Clusters RAC , Data Guard, Grid Control and Automatic Storage management ASM .
• Expertise in Shell scripting and documentation in high-availability environments such as Online Marketplace, Healthcare and Information technology.
• Performed tuning of the database with SQL tuning, STATSPACK, EXPLAINPLAN, AWR, ADDM and also tuning of SGA System Global Area .
• Provided DBA support to multiple cluster, non-cluster and ASM Database in production, development and testing servers on UNIX, Linux and Solaris environments.
• Handful of experience in Installation, administration and troubleshooting of different environments ranging from 9i/10g/11g/12c.
• Performed database migration from 9i to 10g, 10g to 11g and 11g to 12c and also from RAC to Non-RAC using RMAN Recovery Manager .
• Experience in daily batch and report monitoring, space management, index rebuilds, statistics collection and other oracle housekeeping tasks.
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager OEM , TOAD, Oracle SQL developer in various versions.
• Expertise in Setup, implementation and maintenance of Real Application Cluster RAC on 10g/11g.
• Implemented RMAN Backup recovery, Incomplete and disaster recovery using Data Guard.
• Experience in different Database backups such as User managed backups, RMAN backups, Operating System backups, Hot and Cold backups, full backup, incremental and cumulative backup and also FLASHBACK recovery features.
• Strong skills in applying security patches Patch Set, Critical Path Updates CPU , Patch Set Updates PSU , One-off patch using 'run installer' and database upgrades.
• Performed various recovery methods like point in time recovery, media recovery, full or partial recovery and data pump export/import.
• Experience in SQL tuning, optimization and PL/SQL procedures, triggers, cursors and functions.
• Skilled in reducing the SQL query time by monitoring queries on TOAD and removing deadlocks.

TECHNICAL SKILLS:

• Operating system Red Hat Linux, UNIX, Windows NT/2003/XP/7/8
• RDBMS Oracle 9i, Oracle10g, Oracle11g, Oracle 12c, SQL Server
• Languages SQL, PL/SQL, JAVA, C, HTML, UNIX, XML
• Oracle Tools Utilities RAC, Import/export, Data Pump, SQL Loader, SQL Trace, OEM, AWR, ADDM, RMAN, FTTP, TKPROF, EXPALINPLAN, STATSPACK
• Other Tools SQL Developer, OEM, VM Ware, Putty, TOAD, Data Pump, Data Guard

PROFESSIONAL EXPERIENCE:

Confidential

Role: Oracle DBA

Responsibilities:

• Installed Oracle DB 11g RDBMS, RAC on ASM, Applying Oracle Critical Patch updates, Implementing and manage Data Guard, Replication, Backup and Recovery support and performance tuning etc.
• Administered and maintained multi-terabyte Oracle 10g/11g RAC production database in an LINUX and Windows environment.
• Designed and implemented database infrastructure, including performance monitoring, capacity planning and automation of database related processes.
• Developed oracle scripts, DBMS jobs, stored procedures and functions to replicate data to the backup databases.
• Performed migration of databases from 10g to 11g using export/import and data pump utilities.
• Responsible for performance, tuning, design, security and refactoring all SQL and PL/SQL queries.
• Performed complete data analysis of several system issues, tracked the data back to the root cause and provided analysis to the customer.
• Performed bulk data imports and created stored procedures, functions, views and queries.
• Provided quality assurance procedures including troubleshooting and debugging production SQL code.
• Responsible for propagation of all DB changes by SQL scripts.
• Responsible for maintenance and backup of several databases for development, quality analysis and testing instances.
• Provided extensive SQL re-writes on poorly performing scripts and recommended changes to database index structure that improved extraordinary performance.
• Implemented Data Guard by creating dual Standby Databases on production environment.
• Involved in Migration of 2-4 TB Database schema level from non-exadata to exadata environment.
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.
• Well experienced in taking Cold Backup for a very huge 64-Tb Database.
• Experienced in managing Daily online backups from Level 0 to 4 and archived backups using RMAN.

Environment: Linux, Solaris 10, Oracle 9i, 10g, 11g, OEM 11g/12C, SQL Plus, ASM, Data Guard, Enterprise Change Management Systems ECMS , UNIX HP, SQL Optimizer, SQL, PL/SQL, SQL Tuning.

Confidential

Role: Oracle DBA

Responsibilities:

• Provided 24 7 supports for Production environment for Extraction, Loading and transformation of data by remote monitoring and tuning of Database processes in the client environment.
• Design Evaluation and Analysis of physical and logical model.
• Involved in Installation and customization of Databases 9i 10g in Windows and Linux environments.
• Involved in Schema Management, Table space Management, User creation.
• Monitoring the Extraction and loading processes of data.
• Upgraded and applied patches as and when required. Database refreshes from production to development.
• Troubleshooting Day-to-Day User issues in various modules.
• Responsible for Oracle implemented backups like Logical Physical i.e. Export Import and also having experience with EXPDP IMPDP.
• Evaluated the hardware requirements before upgrading/migrating the database.
• Good experience with Recovery Managed RMAN Backups.
• Documented the complete project including all pre installation, post installation and database configuration steps.
• Involved in writing UNIX shell scripting for automating the jobs.
• Experience in using automatic monitoring and management processes like batch processing using Crontab for processes like import, export databases.
• Actively involved in validation of data files using DB Verify utility. In order to solve Block Corruption Errors.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Experience with SGA tuning and histograms understanding and sound knowledge in SQL execution plan.
• Tuning Oracle 9i database servers using tools Dynamic, Dictionary views, STATSPACK, ADDM, AWR diagnostic and tuning packages.

Environment: Oracle 9i/10g, Windows NT/03, Linux, AIX5.1, HP-UX, Sun Solaris, SQL, PL/SQL, Shell Scripting.

Confidential

Role: Oracle DBA

Responsibilities:

• Responsible for administration and supporting oracle 11g, 10g and 9i databases.
• Worked on DR project and cloning databases.
• Trouble shouted node hand issues.
• Worked closely with different teams during migrations and managed materialize views servers.
• Applied CPU/PSU patches.
• Worked on windows database servers and performed various tasks using grid control.
• Worked on offshore team for writing scripts to automate various tasks.
• Performance tuning of applications and the databases Oracle 11g/10g/9i
• Database tuning by generating EXPLAINPLAN for long running queries, creating indexes on columns to improve performance.
• Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.
• Intensively used 10g Automatic Workload Repository AWR Automatic Database Diagnostic Monitoring ADDM reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid control.
• Remove unnecessary histograms in highly volatile schemas.
• Worked in Tuning OS, Shared Pool, Buffer Cache and Redo log buffer.
• Database dot release upgrades using oracle universal installer and cat patch, SQL.
• Applied various recovery scenarios for complete and incomplete recovery in case of failure.
• Performed security administration tasks, setup user accounts, passwords, roles, profiles and quota.

Environment: Oracle 9i, 10g and 11g, TOAD, SQL Plus, Oracle Enterprise Manager OEM , RMAN, UNIX, ASM, Solaris 10, Oracle Streams, RAC, Shell Scripting.

Confidential

Role: PL/SQL Developer, Jr. Oracle DBA

Responsibilities:

• Installed and Configured Oracle 9i software.
• Worked on Oracle 9i OEM for regular database management.
• Wrote PL/SQL procedures and triggers to carry out database maintenance tasks.
• Created different views as per the business needs.
• Created Materialized views and snapshots for high end application usage.
• Worked on different types of indexes and sequences.
• Planning, installation and configuration of Oracle 9i on Sun Solaris and Windows 2000 server.
• Performance tuning of database using Stats pack reports.
• Backup and recovery operations over all databases, ensuring 100 recoverability using RMAN.
• Wrote control files for input to SQL Loader utilities for loading data from external files into the Oracle database.
• Created Table space, Data files, Indexes and monitoring them.
• Designed and created schema objects like Database tables, indexes, views, synonyms and all objects in Oracle.
• Prepared documents and loaded on to knowledge base portal of the company.

Environment: Oracle 9i, Windows NT/2000 , Sun Solaris, TOAD, PL/SQL, SQL PLUS, EXPLAIN PLAN, STATSPACK, etc.

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• Various features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated.
• Developed SQL Applications for extracting the data from the Oracle tables.
• Extensively testing was done on the programs for achieving accuracy, timely processing OSF data.
• Wrote triggers and packages by using PL/SQL for giving security privileges.
• Used Oracle SQL Plus tool for running SQL scripts containing statements and queries.
• Oracle Report 3.0 was used to create reports.
• Created Reports like Ledger, Profit and Loss statement, Balance Sheet and Trial Balance.
• Used forms 4.5 to create Group, Ledgers, Vouchers and Bank Reconciliation statements.
• Created front-end procedures and functions with forms 5.0 to calculate reorder level and reorder quantity.

Environment: Oracle 9i, SQL, PL/SQL and SQL Plus, Windows.