PROFESSIONAL SUMMARY:

• 10+ years of experience as Oracle DBA
• Proven expertise in supporting multi node RAC cluster and data guard implementation
• Sound knowledge in DB Installation and configuration of oracle on unix
• Experience in database backup using RMAN Hot /Cold and Logical Backup
• Oracle Confidential replication expert
• Performing and monitoring database backup using RMAN
• Experienced in RMAN database cloning and refresh
• A team player with strong communication, team leadership, organizational and relationship management skills, with expertise in interfacing with international project teams for successful execution of projects

TECHNICAL SKILLS:

Operating Systems: Solaris 2.5.1/2.6, Windows NT/2000/98, redhat/Ubuntu/OEL 5.8

Hardware: HP - 9000, RS-6000, Sun Sparc M4000, Sun E25K, Exadata

Languages: PL/SQL, T-SQL, Bash/Korn Shell scripting, HTML, Java, Perl

Database: Oracle 8i/9i/10g/11g/12c, SQL Server, Sybase, Teradata

Tools: Oracle Forms9i/6i/6.0/4.5/3.0, Reports 6i/6.0/3.0/2.5,Erwin 3.5, SQL*Loader, SQL*Plus, TOAD, SQL Navigator, BRTOOLS, Grid Control,Goldengatev11.1/11.2, RMAN, Export/ Import, Data pump, BCV, RM (Replication Manager) - emc2 backup tool, SunGard SCT Banner 8.0, Appworx 6, Java, Confidential Manager, SQL server Enterprise Manager, Microsoft Office 365, BMC Remedy

Middleware: IBM WebSphere, WebDynPro, Weblogic 10.3, Apache Tomcat, AutoSys, Veridata, Oracle Grid Control, Hadoop, Pig, Hive, Sqoop

Version Control: Visual SourceSafe, ClearCase, CVS, ODI, Sharepoint

Telnet Tools: PuTTy, Secure Shell, MobaXterm

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle/ Confidential DBA

Responsibilities:

• Resolved replication issues in Confidential
• Automating tasks using cron for GG restart
• Replicated to a disaster recovery site for increased server manageability and availability.
• Executed processes for evaluation of system space, database allocation and storage metrics.
• Configured Confidential for active-active configuration in a multi master replication environment
• Tuned GG to handle large volumes of data for high transaction tables
• Monitored real-time bidirectional data movement
• Configured Veridata Agent/Director
• Created Veridata compare pairs executions implemented re-runs/re-checks and fixes for Out of sync
• Supporting PROD/COB implementation bi-directional active-active configuration
• Supported 11g agent decommissioning - moved to 12c grid control
• Consolidated tables and enabled GG replication by application seggregation
• Used Oracle 11gR2 to resolve complexity of configuring conflict detection and resolution
• Automated Timestamp resolution - most common conflict handling in a active-active scenario
• Setting up Before and After Image captures for Conflict Detection and Resolution
• Active monitoring of Conflict Detection and Stats verified after hourly run

Confidential

Sr. Oracle Consultant

Responsibilities:

• Configuring Confidential 12c on Oracle RAC 12c with ODI 12c for real-time replication
• Setting up ODI 12c for Change Data Capture using Confidential 12c Adapter
• Tuning ODI 12c performance with Confidential 12c on Oracle RAC 12c

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Installing & configuring Oracle clusterware & Database Software
• Troubleshooting using cluvfy & handling common issues that arise during integration
• Resolving bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of clusterware
• Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.
• installed and configured Confidential on Exadata
• migrated databases using GG and RMAN for 2 node RAC
• implemented broadcasting and bi-directional replication
• Performed database management functions such as maintenance, access issues and security
• Conducted designing, assembly and tuning of databases in coordination with development teams.
• Evaluated database performance for investigation of issues and further resolution for efficiency
• Implemented procedures for automation of database management through tables and indexes.
• Worked with on RAC resolutions on hangcheck timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss
• Provided Heterogeneous environment support
• Troubleshoot performance issues for the RAC instances (GC events)
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware)
• Severity I issues resolution with corruption of individual disk data blocks, loss of OS configuration files, net configuration files.
• Resolved/Diagnose Node Eviction.
• Upgrade of 10g R2 RAC to 11g R2 RAC
• Implemented and configured Confidential in 2-node RAC cluster for flow into EDW
• Implemented flatfile load into HBase using Confidential and Flume
• Resolved replication issues in Confidential
• Automating tasks using cron for GG restart
• Implemented oracle source - Teradata target replication
• Supported 30TB Data Warehouse
• Replicated to a disaster recovery site for increased server manageability and availability.
• Executed processes for evaluation of system space, database allocation and storage metrics.
• Maintained all existing databases and new installations at current and stable production levels
• Participated in development of enterprise-wide security standard methodology, and ongoing deployment.
• Configured Confidential for active-active configuration in a multi master replication environment
• Tuned GG to handle large volumes of data for high transaction tables
• Monitored real-time bidirectional data movement
• Conflict detection and resolution
• Provided Heterogeneous environment support
• Consolidated tables and enabled GG replication by application seggregation
• Used Oracle 11gR2 to resolve complexity of configuring conflict detection and resolution
• Automated Timestamp resolution - most common conflict handling in a active-active scenario
• Setting up Before and After Image captures for Conflict Detection and Resolution
• Active monitoring of Conflict Detection and Stats verified after hourly run
• Configure GG delivery
• Building GG Macros to handle custom GG code to handle TimeStamp data
• Scripted Conflict Notification and Tracking Build scripts to identify and provide audit log on actions and verification routines.
• Implemented DDL replication using GG
• Implemented security through GG encryption
• Configured and Implemented PL/SQL packages in conjunction with GG and used to massage data and replicate in real time spanning multiple database objects
• Configured lag using GG scripts and automated the process to email the user every hour in a high volume multi master replication environment

Confidential

Sr. Oracle DBA/EDW Level 3 Support

Responsibilities:

• Installed and configured 3 node cluster with ASM
• Configured and monitored databases using grid control
• Created physical database design provided by design team
• Supported performance load testing
• Controlled user access and regularly monitored space consumption
• Identified and resolved risks involved with replicating large tables into EDW
• Proactively tuned SGA as required
• Installed Confidential software in Test and dev instances
• Configured Confidential on production servers
• Upgraded Oracle Confidential v10 to v11
• Setup classic capture replication mechanism using Confidential
• Configured Confidential to achieve unidirectional and bidirectional replication
• Performed DDL and DML replication from test and dev instances into EDW
• Successfully tested initial Data load during environment build
• Setup Confidential User with necessary privileges
• Cross-Train DBAs on Confidential configuration and replication
• Implemented database auditing and regularly monitored active user sessions
• Used PL/SQL to create stored procedures with the help of tokens to replicate data across multiple databases.
• Troubleshooting and fixing Confidential errors in a 2 node RAC production environment
• Assist in developing purge/archive procedures for historical application data
• Perform Database Software Maintenance
• Applied patches, quarterly patch security updates to existing instances
• Reviewed migration procedures and resolved post migration issues
• Upgraded Oracle Server Software from 11gR1 to 11GR2
• Upgraded oracle 11gR2 to 12c on sand box
• Involved in Capacity Planning for Datawarehouse
• Test impact of multiple Extract and Replicat processes on a Single Node
• Prepare Confidential parameter files for Extraction and Replication
• Investigate, trace fix and report replication failures using LogDump
• Identify risks involved with replicating highly volatile tables with large data volume
• Implement table partitioning technique using virtual Columns
• Create Physical database Design provided by Design Team
• Tune Performance of SQL queries used in reporting real-time statistics
• Control User access and monitor space consumption
• Monitored database for blocking sessions, enqueues and waits
• Involved recovery of database information and maintaining automated schema refresh whose data changes regularly using export/import
• Process, schema and log maintenance
• Maintaining history of backups using documentation
• Proactive monitoring of backups.
• Analyze and troubleshoot failed backups
• Experience of monitoring and rebuilding indexes and analyzing very large tables
• Installation and Monitoring databases using oracle grid control
• Tested shell scripts for database monitoring jobs
• Monitoring standby database in a data guard configuration
• Setup dataguard broker successfully
• Implemented and configured Confidential on a 2-node RAC cluster
• Supported bi-directional replication, broadcasting data from Enterprise Datawarehouse to downstream database at client location
• 24/7 Support production, dev and test instances
• Experience in analyzing v$views and DBA views
• Scheduled database performance tuning reports using Statspack and AWR reports
• Troubleshoot complex SQL using explain plan and TKPROF utility
• Maintaining and monitoring logical and physical structure of database
• Good knowledge on Veritas Netbackup
• Documented cron jobs, replication setup, post migration and post upgrade procedures
• Setup ACFS mount for GG replication for multi node RAC clusters
• Setting up Clusterware registration to handle Confidential automatically

Confidential

Oracle DBA Consultant

Responsibilities:

• Responsible providing 24x7 on-call production/development/testing database support.
• Involved in installation of Oracle on different platforms, loading of user data to reproduced the problem
• apply new Oracle patches to production/Quality/development instances
• managed database backup using RMAN
• Involved in Weekly Database refresh from production to quality
• Supported Oracle DB backups (hot/cold), logical backups and UNIX scripts
• Created clone databases
• Configured standby database.
• Troubleshooting archive log transport failures for standby database
• Creating the database, tablespaces, tables, indexes, settings privileges and user logins.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactive Monitoring
• Troubleshooting archive log transport failures for standby database
• Performed DBA day-to-day activities like monitoring space availability, adding data files, user security
• Provided technical support for Oracle Server to customers for Production Database
• Supported customers to manage their operational data ranging from GB to TB in Oracle database, solving space allocation issues
• Refresh schema using Export/Import
• Mentor / Help team members for resolving various db related issues.
• Support 24x7 operations for Production/Dev/UAT databases in Onsite/Offshore working model and ensure 100% uptime of IT Infrastructure for Clients.
• Installations / upgrades of 11GR2 Grid Infrastructure and RDBMS for Prod and Non Prod environments.
• Production Support for 11Gg/10g RAC & Standalone databases.
• Migration of databases from Non-ASM to ASM Storage including conversion from Standalone to Cluster envs.
• Upgraded DB from 10.2.0.4 to 11.2.0.3 including platform migration from Sun Os 5.10 to RHEL 5.9
• DB cloning using RMAN from RAC to Standalone database.
• Developing shell scripts for RAC & Standalone databases.
• Managing ASM disk groups & tablespaces.
• Change / SR Management using BMC Remedy.
• Alert monitoring using Autosys and BMC Remedy.
• Code Migrations using Standard processes.
• Preparing SOP Documents
• Analyzing and implementing the Disaster Recovery Trials

Confidential

Database/ Project Manager

Responsibilities:

• Developing Oracle Database structure design, installation & maintenance of Oracle Database.
• Modifying object structures to suit functional needs
• Integrating, testing, debugging and implementing application systems.
• Involved in security administration to authenticate users
• Full export/import at Database/schema level
• Analyzing Tables & Schemas
• Collecting system statistics, reorganizing tables and rebuilding indexes
• Monitoring and elimination of Row Migration & Row Chaining
• Documenting Backup/Recovery procedures
• Backing up of Archive Log files and monitoring space in that mount point
• Regular checking of Alert log file
• Taking Export dump daily for Backup purpose
• Responsible for taking full cold database backup
• Data upload using SQL* loader oracle utility
• Maintaining several Database instances running on Windows environments
• simple restore operations to refresh test and development instances
• Using DTS to load/unload data from multiple databases
• Refreshing test instance with prod data using cold/hot backup
• Query optimization using optimizer hints
• Creating clone of the database on the same server using RMAN
• Managed User managed backups
• Troubleshooting issues related to capacity planning
• Established standards and best practices
• Ability to perform both Oracle and also operating system performance monitoring and the necessary adjustments.
• Identifying Oracle Applications running on the legacy System.
• Creating PL/SQL procedures & functions and views in Oracle Database.
• Training terminal users about operating the current installations.
• Designing the application system structure and functional modules. Using the functional document to design application logical and physical structure.
• Resolved network connectivity/listener configuration issues
• Monitored and killed hung user sessions

Confidential

Database Administrator

Responsibilities:

• Execute support tickets (Support Central & HP Open View service desk 4.5 Tools).
• Was in 24 X 7 On Call DBA and the escalation point of contact for any database related critical issues.
• Primary responsible for the support of Oracle databases. This Includes installation, updates/patches, upgrades, tuning, optimization, backups and resource management
• Develop, document and maintain procedures for patching, data backups, restores, performance tuning and configurations
• Administer, maintain, develop, document and implement policies and procedures to ensure the security and integrity of all Oracle and some SQL Server databases.
• Worked with the QC /Operations / Application Teams in standardizing the application management / production deployments.
• Responsible of deploying the application into respective severs (categorized as per business P&L).
• Responsible of migrating databases from one data center to another data center depending upon the business requirement.
• Coordinate Knowledge transition sessions for new Hires.
• SPOC for preparing various kinds of reports in Operations perspective.
• Involved in Logical and Physical Data Model development which supports project needs.
• Designing the internal schema of a databases, depicting the data tables, the data columns of those tables, and the relationships between the tables
• Defined Weekly Database Build Plan in terms of DB export, creating new schemas, uploading latest packages and procedures, Creation of synonyms, Executing Objects, Data Export and New Data Loads.
• Database administration during development.
• Defining and implementing Backup Strategy as required

Confidential

Database Administrator

Responsibilities:

• Maintaining Oracle Database and PL/SQL Code used to enhance features for Billing System.
• Creating database triggers to implement and enforce data integrity and security.
• Developing various backend application programs such as Views, Functions, Triggers, Procedures and Packages combining SQL and PL/SQL
• Creating executable programs running in UNIX operation system.
• High End-Client Interactions for solving UAT issues.
• Performing identification of poor performance SQL and using TKPROF utility for tuning.
• Developing custom workflows for tracking workflow service requests and notifying technicians about the status of the workflow.
• Streamlining the code to improve its performance and providing additional functionality as desired by the client.
• Troubleshooting the failed batch jobs.
• Designing, Coding & Unit testing the application as per requirements.
• Data mapping activities for the business files from Extract Areas. Running end to end batch batches, identifying issues, capturing errors and providing solution to help prevent failure of batch jobs.