Description
PROFESSIONAL SUMMARY * Experience in Installation, Configuration and Monitoring of Oracle Server on UNIX, Linux, AIX and Windows Environments. * Experience in Configuring and tuning of Oracle Real Application Cluster (RAC), CRS & ASM for high availability database. * Development and implementation of Enterprise database services standards, guidelines, processes & procedures, and best practices. * Good Experience in upgrading cluster to 12c and databases from 11g to 12c. * Configuring and implementing Oracle ASM on UNIX, Linux, and Windows platforms. * Configure high availability systems like Data Guard and RAC environments. * Installation, Configuration and Maintenance of Logical/Physical standby databases in Data guard. * Installed and maintained Oracle 12c/11gR2/10g/9i, RAC with ASM & Oracle Cluster File system. * 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 Grid Control (OEM Grid) and Experience with Real Application Testing (RAT). * Experience in Implementing BACKUP and RECOVERY strategies using RMAN. * Responsible for data loading, security, capacity planning and backup and recovery. * Installation and configuration of Recovery Catalog for multiple Databases. * Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp). * Experience in Oracle Patching for 9i, 10G, 11G and 12C using opatch and opatch auto. * Implementing user level security, object level security, data encryption, data masking, fine Grained auditing using DBMS_FGA package. * Upgraded and migrated Oracle databases from 10g to 11g and 11G to 12C. * Hands on experience in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACTS, PUMPS and REPLICAT issues and migrated databases with ZERO downtime. * Having good experience working on EXADATA X 4-2 Half Rack smart flash cache, storage indexes, storage management and migration. * Worked on calculating celloffload efficiency for sql statements running on Exadata databases. * Implemented OLTP COMPRESSION, PARTITIONING, Hybrid Columnar Compression for databases on EXADATA and the basic, low, high compression methodologies. * Experience working with IBM-TIVOLI. * Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, UTLESTAT, AWR, ADDM 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. * Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment. * Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports. * Managed testing, assisted Developers, and created backups by Exporting and importing tables when needed. * Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics. * Experience in handling Oracle features such as table partitioning-sub partitioning, Oracle Streams (Replication) Transportable Tablespace (TTS) feature allows users to quickly move a user Tablespace across Oracle databases. * Experience in maintaining Extraction Transformation and Loading (ETL) tools for Reporting Solutions. * Developing Unix shell scripts (cron and Perl) to extract data from ETL database environment as reports and importable delimited data sets. * Applying PSU Patches and interim patches whenever required to make the database software up to date. * Proficient in SQL, PL/SQL, Perl Scripting, Shell Scripting, ERwin Data modeling, OLAP, Oracle Data Dictionary - meta data, Logical and Physical Database Design. * Written shell scripts to monitor Oracle services, Golden Gate processes, to upgrade databases from 10g to 11g, to automate startup/shutdown of Oracle database, to migrate database from one server to another. * Expertise in developing various Database objects like Triggers, Stored procedures, Functions, Sequences, Views etc. * Extensively used BMC Remedy, HP Quality Center ticketing systems & HP Java ITO (OVO) Console for monitoring. * Responsible 24x7 production operations (incident break/fix, change, service requests, management) and On-Call rotation
Accomplishments
Highlights:
Keywords
