Professional Summary:

• Oracle Certified Professional with 8 years of experience in Oracle Database Administration includes RAC Installation, Configuration, upgrades, Migration, Production Support, Patch management, Database Backup Recovery, Data guard implementation, Partitioning, Performance Tuning Instance level and SQL level, Cloning, Space Management, Streams, Active Data Guard, Database Security, Auditing, Troubleshooting, Configuring and Managing Oracle 10g/11gR2 RAC databases with ASM features, Worked on various Oracle versions like 9i, 10g, 11gR1 and 11gR2 Databases across various platforms such as Solaris, AIX, UNIX, Linux, HP and Windows.
• Experience in installation and configuration of oracle 9i/10g/11gR2 databases in various environments
• Like Linux RHEL 5 and 6, Solaris 8/9/10, HP-UX, IBM AIX 5.2/5.3/6.1 and Windows environment.
• Experience in Configuring, Installing and Maintaining Real Application Cluster RAC database for high scalability and availability in Oracle 10g/11gR2 UAT and Production databases.
• Installed and Configured RAC on EXADATA and LINUX Servers
• Migrated databases in Linux Environments using RMAN, EXPDP/IMPDP, Cold backup techniques.
• Expert in configuring and monitoring DATAGUARD for physical standby databases with real time apply, data guard broker and active data guard.
• Expert in Created and Managing Schema objects like table spaces, tables, indexes, constraints, views, materialized views, synonyms, DB links, sequences and triggers.
• Hands on experience in performance tuning using EXPLAIN PLAN, TKPROF, STATSPACK, DBMS STATS, Automatic Workload Repository AWR , Active Session History ASH and Automatic Database Diagnostic Monitor ADDM .
• Expertise with replication and migration with oracle utilities including SQL Loader, Export/Import, EXPDP/IMPDP, RMAN, lsnrctl, SRVCTL, CRSCTL, DGMGRL, ASMCMD.
• Experience in monitored OEM alerts, space alerts, alert log errors and performance issues on the production databases. Assisted application team in finding the hot blocks and tuning code so as not hit the hot blocks, monitored blocking users.
• Experience in schema and table designing, stored procedures, Triggers, Views, and Indexes.
• Performed upgrades from 9i/10g to 10g/11gR2 manually as well as using Database Upgrade Assistant DBUA , and also applied Critical Patches by using OPatch utility.
• Experience as On-Call 24x7 production DBA and application/development DBA and Oracle Support processes for technical requests through Metalink and other Support Procedures.
• Expert in Capacity planning, Space management, Storage allocation and different type of storage structure SAN/NAS
• Experience in designing and implementing PL/SQL stored procedures, functions, packages, triggers and SQL for automating daily administration tasks.
• Experience in basic and advanced replication processes including Oracle Streams, Advanced Replication and Materialized views.
• Extensively used Database Administrative tools like Oracle Enterprise manager OEM , SQL PLUS, TOAD 9.5/10.5/11, SQL Developer.
• Experience in automating backup strategy using the UNIX shell script Cron Utility.
• Cloning of production databases using backup based and active database duplication for creation of DEV/UAT environments.
• Experience in supporting multiple large oracle databases, diagnose and resolving performance, client / server network connectivity, security and database corruption issues.
• Expertise in applying RDBMS Patches/Operating Systems and analyzing/Troubleshooting patches. Applied DST Patches, Critical Patches, Security Patches, and end of year Patches and applied Oracle database patches using Opatch utility.
• Experience in monitoring and tuning Operating System using OS utilities NMON, VMSTAT, IOSTAT, SAR,and TOP
• Strong presentation, troubleshooting, analysis, design, code, testing and implementation with excellent interpersonal, logical, analytical and Communication skills.

Technical Skills:

Experience:

Confidential

Oracle Database Administrator

Responsibilities:

• Creation of database objects like Table space, Tables, Indexes, Views, Synonym for different teams as per business requirement in Development, Test and Production environments
• Experience in Configuring, Installing and Maintaining Real Application Cluster RAC database for high scalability and availability in Oracle 10g/11gR2 UAT and Production databases.
• Installed and Configured RAC on EXADATA and LINUX Servers
• Hands on experience in Performance Tuning using EXPLAIN PLAN, TKPROF, STATSPACK, DBMS STATS, Automatic Workload Repository AWR , Active Session History ASH , Automatic Database Diagnostic Monitor ADDM and SQL Tuning
• Extensive production Support was provided for all Oracle instances.
• Handling Primary On call pagers for 24 X 7 Support
• Coordination with the respective THD support groups e.g. System Admin, Application support team, etc. during crisis and system recovery situations
• Creating and working HPSM ticket for issues and follow up on issue resolution
• Monitor and act on emails/alerts generated by monitoring tools like OEM and Nagios
• Work on the backup failure alerts and fix issues
• Validate correctness/health of monitoring scripts at regular frequency and modify as needs
• Resolve tickets which will be generated from 12c OEM
• Work on Apply lag alerts and fix issues
• Work on DB connections alerts and fix issues
• Support DB activity during SAN migration Patching activity
• Providing support for Power path upgrade
• Prepare the change implementation plan and create change request
• Work on the schema/db refresh as per User request
• Experience in ORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN
• Implementing Changes with respect to Oracle Database on Production Environments as and when required by Business, as per the Change Management Process.
• Reorganizing of Tablespaces, rebuilding indexes and gathering statistics Upgrade form Oracle 11gR1 11.1.0.7 Database to 11G R2 Database 11.2.0.1 .
• Performance Tuning, SQL Tuning, Space Trending and Capacity Planning on Oracle 11g, 10g and 9i Databases.
• Database tuning, Application Tuning performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters tracing, troubleshooting with database performance and tuning issues.
• Export/Import Data Pump of oracle databases.
• Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
• Involved in installation, upgrade, configuration and administration of Oracle 9i,10g ,11g and 12c Database in Test, Development and Production environment
• Grid Infrastructure Installation and Administration
• Implementing Changes with respect to Oracle Database on Production Environments as and when required by Business, as per the Change Management Process.

Confidential

Oracle Database Administrator

Responsibilities::

• Creation of database objects like Table space, Tables, Indexes, Views, Synonym for different teams as per business requirement in Development,Test and Production environments
• Extensive production Support was provided for all Oracle instances.
• Installed and Configured RAC on EXADATA and LINUX Servers
• Handling Primary On call pagers for 24 X 7 Support
• Coordination with the respective THD support groups e.g. System Admin, Application support team, etc. during crisis and system recovery situations
• Creating and working HPSM ticket for issues and follow up on issue resolution
• Monitor and act on emails/alerts generated by THD monitoring tools.
• Work on the backup failure alerts and fix issues
• Validate correctness/health of monitoring scripts at regular frequency and modify as needs
• Resolve tickets which will be generated from 12c OEM
• Work on Apply lag alerts and fix issues
• Work on DB connections alerts and fix issues
• Support DB activity during SAN migration Patching activity
• Providing support for Power path upgrade
• Prepare the change implementation plan and create change request
• Work on the schema/db refresh as per User request
• Experience in ORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN
• Implementing and maintaining database security create and maintain users, roles and assign privileges
• Creation of new databases. And OEM Installation, Configuration and Administration
• Oracle Database Migration and Version Up gradation.
• Refreshing of Database and Schemas
• Creation of Standby Database.
• Applying Oracle Patches.
• Database Cloning.
• Schema Management-Users, Privileges, Roles and Profiles
• Stats pack and AWR reports generation and Performance Tuning
• Implementation and Administration of Oracle RAC and DataGuard Environments.
• Managing and resolving tickets related on Oracle Database Incidents.
• Add and removing nodes in RAC Environment.
• Implementing Changes with respect to Oracle Database on Production Environments as and when required by Business, as per the Change Management Process.
• Reorganizing of Tablespaces, rebuilding indexes and gathering statistics Upgrade form Oracle 11gR1 11.1.0.7 Database to 11G R2 Database 11.2.0.1 .
• Performance Tuning, SQL Tuning, Space Trending and Capacity Planning on Oracle 11g, 10g and 9i Databases.
• Database tuning, Application Tuning performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters tracing, troubleshooting with database performance and tuning issues.
• Export/Import Data Pump of oracle databases.
• Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
• Involved in installation, upgrade, configuration and administration of Oracle 9i,10g ,11g and 12c Database in Test, Development and Production environment
• Grid Infrastructure Installation and Administration

Confidential

Oracle Database Administrator

Responsibilities:

• Build support 10g 11g R1/R2 RAC, standalone databases on different OS platforms AIX / Linux/ Sun Solaris servers and different file systems raw, ASM, ocfs2 .
• Installed and Configured 11.2.0.3 RAC on 2-node and applied PSU 4.
• Experience in 24x7 on call production support for mission critical production systems.
• Installed and Configured RAC on EXADATA and LINUX Servers
• Upgrading and Migrating oracle databases from 9i, 10.2.0.4/10.2.0.5 to 11gR2 on Linux/Sun Solaris servers.
• Experience in migrating database from one server to another using RMAN
• Followed HD change management policies
• Configured and managed physical standby database using dgmgrl, active data guard for disaster recovery on a different production databases.
• Performed database tuning using AWR, ADDM, ASH, TKPROF, Oracle Enterprise Manager, TOAD and used OS utilities NMON, VMSTAT to analyze the CPU, RAM, DISK performance.
• Installed and configured oracle database with BBDA
• Expert in query tuning, Explain plan, Tkprof, Wait Events, sql cost, locks and long operations.
• Experience in monitoring Memory/SGA Components, as per the database issues changing the SGA components as per Oracle Standards.
• Implemented Audit Security standards that are required for the banking systems to stay in compliance with federal policies. Implemented Guardium tool to audit the user access.
• Monitored OEM alerts, space alerts, alert log errors and performance issues on the production databases. Assisted application team in finding the hot blocks and tuning code so as not hit the hot blocks, monitored blocking users and dead locks.
• Configured database backups using cronjobs, tested and Scheduled database backups using RMAN and data pump/export backups to disks. Worked closely with the netbackup team to setup the tape backups.
• Installed, configured and migrated OEM Agents on multiple servers to 11g and implemented standard monitoring and alerting procedures.
• Developed UNIX shell scripts SQL scripts to perform the daily Database OS monitoring, Server validation health check.
• Assisted application development team in query tuning optimization, partitioning, explain plan recommendations.
• Participated in major IT/ER releases for code implementation and application deployments.
• Worked with system administrators for various OS level administrative tasks, Modified existing UNIX backup shell scripts as per the environment.
• Documented various implementation procedures for future needs and shared within the team.

Confidential

Oracle Database Administrator

Responsibilities:

• The delivery process involved in this project is a standard process, this includes database administration, developing backup strategies, Installation and configuration of oracle 10g, Real Application Cluster, implementing oracle high availability architecture, database performance monitoring, tuning database parameters.
• Installed and Configured RAC on EXADATA and LINUX Servers
• Migration of Oracle 10g database from AIX to Oracle 10g RAC on Linux.
• Installation and Configuration of Oracle Golden Gate with good experience in up gradation from 9i version to 10g.
• Support Maintenance of Production/Development Databases on various servers with 24x7 on-call support for Production applications.
• Experience in Capacity planning, Space management, Storage allocation and different type of storage structure SAN/NAS
• Performed database recovery using User-Managed, RMAN-Managed Recovery and performed FLASHBACK features to handle efficient database recovery.
• Configuring and Managing Automatic Storage Management ASM for managing data in SAN.
• Implementing the database change and release management by using Remedy.
• Performed database tuning using AWR, ADDM, ASH, TKPROF, Oracle Enterprise Manager and TOAD and used OS utilities NVMSTAT, IOSTAT, SAR to analyze the disk and CPU performance.
• Developed UNIX shell scripts SQL scripts to perform the daily Database OS monitoring, Server validation health check.
• Knowledge in data warehouse designs and concepts and supporting the OLAP databases.
• SQL and PL/SQL Performance Tuning and Identifying SQL and PL/SQL bottlenecks using PL/SQL Profiler package DBMS PROFILER , Explain Plan, Auto trace and TKPROF.
• Followed HD change management policies
• Experience in 24x7 on call production support for mission critical production systems.

Confidential

Database Administration

Responsibilities:

• Installing and Configuring Linux Operating System
• Installation, Configuration and Administration of Oracle 9i/10g Databases
• OEM Installation, Configuration and Administration
• Schema Management-Users, Privileges, Roles and Profiles.
• Reorganizing of Tablespaces, rebuilding indexes and gathering statistics.
• Planning Backup and Recovery Strategy using RMAN.
• Performing Database Refresh using RMAN.
• Oracle Database Migration and Up gradation
• Implementing Changes with respect to Oracle Database on Production Environments as and when required by Business, as per the Change Management Process.
• Performance Tuning, SQL Tuning, Space Trending and Capacity Planning on Oracle 10g and 9i Databases.