OBJECTIVE

• An accomplished Oracle Database administrator (DBA) with expertise in technical skills and knowledge fruitful for the growth of the firm.

SUMMARY

• 12+ years of experience in Installation, Configuration and Monitoring of Oracle Server on UNIX, Linux, AIX and Windows Environments.
• Extensive experience in Oracle Database 12c,11g,10g and 9i.
• Experience in Installation and Configuring of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Performed the 12c Upgrade of RAC cluster ware from 11g.
• Configuring and implementing Oracle ASM on UNIX, Linux.
• Configure high availability systems like Data Guard and RAC environments.
• Installed and Administered Oracle 12c, 11g ASM & 10g RAC with ASM & Oracle Clustureware File System (OCFS2).
• Installation, Configuration and Maintenance of standby databases in Data guard.
• Providing DBA support to multiple Cluster, Non - Cluster and ASM Database in production, development and Testing Servers in UNIX, AIX & Windows Environments.
• Experience in monitoring and managing of Oracle instances using Enterprise Manager Cloud Control (OEM Cloud).
• Experience in Implementing BACKUP and RECOVERY strategies using RMAN.
• Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp).
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, AWR, ADDM, SQL Advisory and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Applying PSU Patches and interim patches whenever required to make the database software up to date.
• Responsible 24x7 production operations (incident break/fix, change, service requests, management) and On-Call rotation.
• I have been awarded Team Award and I-appreciate award from Oracle Financial Services
• I have been awarded for my contribution as a team Player-Team Award and for individual performance-SPOT award in Ciber and Client Delight Award

TECHNICAL SKILLS

Operating Systems: Linux, SOLARIS, AIX, Windows, HP-UX Languages SQL; PL/SQL; Unix Shell Scripting Databases Oracle 12c, 11g, 10g and 9i

DBA Tools: CRSCTL, SRVCTL, EXPDP/IMPDP, DGMGRL, SQLPLUS, OEM, DBVERF, TKPROF, RMAN, DBCA, LSNRCTL, DBUA, ASMCA, ASMCMD

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database

Responsibilities:

• DBA support handling over 100 databases in non-prod, production and disaster recovery(DR) environments
• Worked in Oracle 11g RAC databases running in Linux. This includes setting up new clustering environment, Grid infrastructure setup, Database installation and configuration
• To design the complete database architecture specific to the Application and client requirements
• Database cloning using RMAN
• Disaster Recovery setup
• Oracle 12c OEM cloud control setup
• Worked on NON-ASM to ASM storage migration
• Worked on Single Instance to RAC migration
• Worked on the complete PROD ASM RAC setup.
• Performance tuning of Oracle databases
• Database Patch set update
• Performing database backups through RMAN and through EXPDP
• Implemented scripts to do health checkup of Production databases

Confidential

Oracle Database

Responsibilities:

• L2 DBA support handling around 15 databases (PROD, UAT and DEV)
• Worked in Oracle 11g RAC databases running in AIX
• Performance tuning of Oracle databases
• Database Patch set update
• Performing database backups through RMAN and through expdp
• Implemented scripts to do health checkup of Production databases
• Oracle database export and import to setup new environments
• Oracle Database housekeeping to release needed space in the PROD databases

Confidential

Team Member

Responsibilities:

• Major database side support include backup and restore using Oracle 10g logical backup method using DataPump technology.
• Database backup using expdp and restore using impdp during new environment setup
• Database maintenance and performance monitoring in Development, SIT, UAT and production setups.
• Database performance tuning includes Oracle statistics gathering at table and schema level, Oracle 10g specific database parameter tuning.
• Database table organization and Index rebuild. Fine tuning table level parameters.
• Database performance monitoring includes PL/SQL query execution plan and tuning individual query
• UNIX administration includes server utilization and maintaining server so as to maintain avg Disk, CPU and Memory utilization.

Confidential

Team Member

Responsibilities:

• Responsibilities include internal database, operating system, Application server, MQ and related Flexcube specific environment setup.
• Major database side support include backup and restore using Oracle 10g logical backup method using DataPump technology.
• Database backup using expdp and restore using impdp during new environment setup
• Database maintenance and performance monitoring in Development, SIT, UAT and production setups.
• Database performance tuning includes Oracle statistics gathering at table and schema level, Oracle 10g specific database parameter tuning.
• Database table organization and Index rebuild. Fine tuning table level parameters.
• Database performance monitoring includes PL/SQL query execution plan and tuning individual query
• UNIX administration includes server utilization and maintaining server so as to maintain avg Disk, CPU and Memory utilization.

Confidential

Team Member

Responsibilities:

• Responsibilities include at various level Database, Server level, Network level and also Individual transaction performance
• Understanding Flex branch level setup and diagnosing the root cause of the problem
• Purging all history tables and purging of materialized log tables in all branches
• Reorganizing all materialized log tables and recreating of problematic base tables for all branch level materialized tables
• Rebuilding of Indexes and reorganizing tables in different tablespaces
• Memory parameter changes in all branches to improve the online performance at branch level
• Review of network connectivity from datacenter where the main database setup and to different branches where branch databases are setup
• Have pinned out the network related problems to some remote branches from datacenter and suggested to upgrade bandwidth in those problematic links
• Review of the existing Production hardware setup and suggested to upgrade RAM as memory was not sufficient in the server for the applications running. As the memory is not sufficient to be allocated to the databases, suggested to upgrade the RAM.
• Provided training to the bank DBA’s to monitor database performance and handed over useful scripts to maintain log and history tables. These maintenances was helped to reduce backup timings and hence to meet the SLA in all branches across the country including the head branch.

Confidential

Oracle database

Responsibilities:

• Installing database software 9i in Unix Solaris 9 box
• Creating database and setting up parameters for optimal performance
• Schema setup and granting privileges
• Database schema backup using oracle export utility
• Database restore using oracle import utility
• Primary Database Creation, Control files, Redo-log files, Datafiles.
• Storage parameter management for Tablespace/Data/Index/Rollback Users, Roles, Profiles.
• Maintaining System Security, Password Files.
• Configuration, Monitoring and Tuning of Oracle Databases.
• Management of Database Objects (Table, Index, Partition, Index, Snapshot).
• Tuning SGA size constituents such as buffer cache, dictionary cache, and library cache and optimized the application using TKProf and Plan Table.