Summary

• Over 7 years of experience in Oracle Database Administration, supporting large and diverse database application portfolio of 24 7 mission-critical production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, support, Unix shell scripting and documentation.
• Experience in OLTP/DW database systems, managing large Oracle databases VLDB.
• Oracle Database Administration experience in variety of different environments like Red Hat Linux, Window,s HP-UX, SUN SOLARIS and AIX.
• Worked with Oracle Databases ExaData, 12c,11g/10g/9i on Unix/Linux/Windows platforms.
• Planned and implemented DR High Availability solutions using Oracle RAC, Standby Database Oracle Data Guard .
• Worked on database recovery
• Expert in design and implementation of database backup strategy and performed traditional hot cold backups, full, incremental and cumulative backups using RMAN.
• Good experience in replication using Oracle Streams, Golden Gate.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN and manual methods.
• Experienced in using Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring
• Good experience in upgrading and migrating database and applying patches.
• Experience in Performance Tuning by using tools/utilities like Automated Workload Repository AWR , Automatic Database Diagnostics Monitor ADDM , STATSPACK, ExplainPlanand TKPROF.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLTP, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Capacity Planning Benchmarking.
• Experience on Oracle Enterprise Manager Grid Control
• Develop best practice guidelines for Oracle database developers make recommendations on software tools, capacity planning, and infrastructure designs. Develop quality assurance policies and procedures.
• Good experience on Oracle Support processes for technical requests through Metalink and other Support Procedures

TECHINICAL SKILLS:

PROFESSIONAL EXPERIENCE

Confidential

Sr.Database Administrator

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database and applications issues.
• Installed, configured Oracle 12c
• Installed, configured and monitored multi node Oracle 11g RAC, Exadata.
• Converted a single instance database to Oracle RAC.
• Installed and configured Oracle RAC, Data Guard Physical Standby for high availability and Disaster Recovery.
• Data pump Export/Import
• Evaluating the Backup and Recovery Procedures periodically performing backups using RMAN.
• Performance Monitoring and tuning using STATSPACK, TKPROF, EXPLAIN PLAN, AWR, and ADDM.
• Up gradation of Database from 9i to 11g, 10g to 11g and applying patches whenever required.
• Cross platform Migration of databases.
• Configuration, Administration and tuning of Golden Gate.
• Developed scripts for cloning, monitoring, database backup and recovery.
• Experience in identifying performance bottlenecks on high volume transaction systems.
• Implemented different Partition methodologies to improve performance and manageability.
• Involved in creating Tables, Indexes, Triggers, Sequences, Procedures and Packages.
• Cloned Oracle Databases and Oracle applications for development and testing.
• Involved in Data modeling, Logical database design, physical database design, normalization and denormalization.
• Capacity planning and benchmarking.
• Management of security, granting and revoking permissions to users/roles as and when required.
• Writing UNIX shell scripts for backup and recovery, Import and export procedure.
• Writing PL/SQL functions, procedures, packages and triggers.
• Partitioned large tables and created indexes to improve the performance.
• Working with QA and Development teams for the regular database support.
• Daily Health Check Up of the Databases and applications
• Monitoring Growth of tables and undertaking necessary steps for re-organization as and when required.

Environment:Oracle 12c,Exadata,Oracle 11g RAC/10g RAC, 9i, Data Guard, UNIX Shell Scripting, SUN SOLARIS, AIX,RedHat Linux

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Planned, Installed and configuredOracle 11g/10g/9i on Red Hat Enterprise Linux/ HP-UX and Windows.
• Installed 11G R2 RAC on 2 node Linux platform with Grid infrastructure and ASM options
• Migrated databases from 10.2.0.4 to 11.2.0.1.
• Extensively used Oracle Enterprise Manager OEM for maintaining and monitoring databases.
• Applied CPU patches using the GRID control provisioning which minimizes time and cost.
• Refresh/Cloning of Database manually and using RMAN for development and testing purpose.
• Experienced in database tuning by modifying database initialization/memory parameters and queries using TKPROF, Explain Plan and OEM.
• Developed database layout for new storage in such a way that the control files are multiplexed and redo logs and control files are stored on different disks to avoid contention and single point of failure.
• Automated database administration tasks and scheduled jobs using UNIX shell scripts.
• Provided technical services to monitor production and development databases 24 7 and trouble shoot user tickets in production, QA and development environment.
• Good knowledge in writing documentation on backup and recovery and the execution of batch processes for core applications.
• Responsible for CPU patch management for both standalone and RAC instances.
• Performed daily alert log files, trace files, and general data consistency data integrity checks.
• Worked with Oracle MetaLink to troubleshoot problems and issues.
• Installed and Configured SQL Server 2008 R2
• Designed and implemented comprehensive Backup plan and disaster recovery strategies and Scheduled Replication process for updating our parallel servers.
• Involved in Day to day administration activities like Security, DB objects creation,Change Control Promotion across environments, Troubleshooting developer issues, Backups scheduled jobs monitoring.
• Involved in configuration of Raid Levels, Files and File group placements for VLDB's up to 2 TB to achieve maximum performance and uptime.
• Managing the Litespeed backups for very large databases.
• Involved in Patching Servers, Applying hot fixes, schedule downtime, co-ordinate Server/Database related activities.
• Adhere to SOX regulations and followed Change Control procedures and tickets for DB Changes.
• Designed and effectively implemented theDatabase part of the full Data center migration from one city to another with minimal downtime with solid backup plan which involves databases of size greater than 1 TB.

Environment:Oracle 11g/10g/9i, RAC, RMAN, Data Pump, HP-UX, Red Hat Linux, OEM, SQL Trace, TKPROF, Explain Plan, Shell Scripting, MS SQL Server 2008 R2

Confidential

Oracle DBA

Responsibilities:

• Major activities include logical and physical database design, capacity planning, performance tuning, database security, disaster recovery, installation and ongoing maintenance.
• Configured Disaster Recover and Logical standby for Production database in 10G.
• Tune databases performance, Schedule backup, jobs using OEM Grid Control.
• Involved optimizing database schemas, SQL queries, database procedures, and installation.
• Worked with Erwin, ER/Studio, Data Warehousing, Extract Transform and Load ETL , Oracle Warehouse Builder, SQL, PL/SQL.
• Responsible for setting and managing user accounts, Granting required privileges, profiles to users, Auditing Users.
• Written shell scripts for digitization the process and for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
• Worked on Data pump Expdp / Impdp , Import / Export for logical database maintenance.
• Creating tablespaces sizing the system tablespace, allocating default tablespaces for users.
• Creating tables and indexes, sizing their extent, partitioning and so on.
• Creating users with restricted access, with default and temporary tablespaces.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Resolving SQL tuning issues and Tuning Considerations for Different Applications.
• Monitoring the table growth, database growth, current users, and system resource usage and so on.
• Experience in SQL Loader, loading data from text files.
• Performed scheduling of Change Control-activities and scheduling jobs.
• Performed Database Reorganization regularly to remove row migrations and fragmentation using export and import utilities. Write UNIX Shell Scripts to schedule these activities.
• Contact oracle Meta link to resolve database issues and to raise SR's.

Environment:Oracle 11g RAC/10g/9i, ASM, Sun Solaris, Red Hat Enterprise Linux, OEM, Explain Plan, Tkprof, SQL LOADER

Confidential

Jr Oracle DBA

Responsibilities:

• Installing, configuring and administering ORACLE 9i/8i on Linux and Solaris.
• Worked in development support for Oracle based systems and Unix based server environments.
• Perform capacity Planning required to create and maintain database environments
• Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and manageability.
• Planning backup andrecovery strategies for various database environments
• Developed Recovery procedures that are applied for complete and incomplete recoveries depending on the type of failure.
• Created PL/SQL and shell scripts to automate batch jobs through crontab.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Writing scripts for the system and database for the effective functionality and report generation.
• Applied high priority, security patches downloaded for Meta link.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes and monitoring their growth rate.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Upgraded databases from Oracle 8i to 9i.
• Monitoring Database for fragmentation and correcting them
• Experienced with Space Management and Security.
• Management of table space growth, monitoring data files additions, extent growth
• Performed Database, OS and application tuning.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Used Database export/import using exp and imp utilities to take logical backups.
• Performed Data loads using SQL loader utilities.
• Contact to the development team to solve the issues with the new enhancement releases.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.

Environment:Oracle 11g/10g/9i, Linux, Solaris, Windows NT/2000, Toad