SUMMARY

• Around 11 years as Oracle Database Administrator/SME (Proficient in Oracle/PostgreSQL/Couchbase( Database Administration Activities) like day - to-day support, database design database administration and building large OLTP/OLAP databases on a variety of UNIX (Solaris, HP-UX, AIX), with Oracle (8.0.5, 8i, 9i, 10g, 11g), Developer 2000/6i, SQL net, SQL*Plus
• Installed configured Multi Node RAC and Non RAC database’s for enterprise environments and Provided 24X7 support to Mission critical Enterprise databases on Exadata X2-2, Sun M5000, M4000, E2900, HP 9000, IBM POWER5+ Servers
• Implemented Database on Exadata X2-2 by using Siebel Application Best Practices and Migrated Siebel 3T database from six node cluster (RAC) to Exadata half rack and Quarter Rack environment.
• Responsible for providing Technical direction, planning, design, build, operate Tier 0, Tier 1 database infrastructure on Oracle 12c/11g Version.
• Implemented Oracle Data Guard (12c/11g) for Disaster Recovery solution and experience in database switchover (converting standby as primary vice versa) converting physical standby as snapshot database and performing DR exercise.
• Responsible for managing and troubleshoot 11g/12c data guard issues like archive log gaps, missing data file, data guard sync issues.
• Responsible for Design, develop, and implement replication with the golden gate for database high availability solutions, real-time data integration, and Disaster recovery solution.
• Hands on experience in setting up unidirectional replication between datacenter and consolidation replication (many to one) between databases.
• Expert in install, configure, golden gate IR replication, hands on experience in golden gate process and troubleshooting golden gate abended, lag issues.
• Expertise in 10g/12c Grid Control. Installed, configured, maintained OEM 10g/12x Grid Control Management Server and Agent with 10g/12c Repositories to manage 600+ targets( Database include primary and stand-by databases, Grid Control Agents, Server, 9i/10g application server components on more then 100+ server )
• Developed comprehensive backup and recovery policy, designed, tested, implemented backups on Oracle ZFS storage. Minimized backup time up to 80%.
• Experience with database backup, restore, and disaster recovery procedures. Hands on experience of database backups and Recovery strategies using RMAN, Shadow Image, Data pump (expdp, impdp) Export/Import.
• Clone/refresh database by using rman backup set, active database clone features. Schema refresh by using expdp / impdp.
• Monitor and manage Oracle database Security by implementing security Policies as per guidelines and ensure that database are met with compliances.
• Extensive experience with Oracle Database Migration, upgrade, Patching of RAC and Non RAC environment.
• Expertise in Environment using Veritas HA Cluster and Cluster automatic failover configurations. Perform fire drill tests every 3 months and make sure VCS configuration is properly defined.
• Troubleshoot Database Performance issues using sqlt, extract report, 10046 and 10053 Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Fixing execution plan for queries by using sql profile..
• Hands on experience is reading analyzing oswatcher data, generating dash board and analyze server health in terms with CPU/IO/Memory.
• Design, Developed & Sizing of Couchbase cluster based on Application requirements, which includes working dataset, no: of replica’s and total dataset’s sufficing application response time.
• Responsible for installing, configuring, and administering multimode Couchbase cluster activities, which includes adding/removing node, resetting memory quota, rebalance the cluster after adding/removing node from the cluster.
• Performed multiple Couchbase upgrades from versions 3.x to 4.5.1, 5.1, 6.5 in a rolling fashion with ZERO downtime. Hand-on experience on offline Couchbase upgrades when allowed.
• Responsible for working with various vendors (oracle, couchbase) and various internal team to handle planned/ unplanned database events
• Responsible to Installation and configuration of PostgreSQL and define standard guidelines to deploy PostgreSQL on Confidential Infrastructure.
• Performed couple of Oracle to PostgreSQL migration by using Ora2pg and golden gate and worked with PostgreSQL Development team to handle code change during the Migration.
• Review the PostgreSQL bloat report and come up with a plan to perform Auto Vacuum jobs to those objects that are heavily bloated.
• Responsible to Design, Develop, Maintain PostgreSQL Single Node cluster and Multi-node cluster with Various other components such as repmgr, logical replication, pgbouncer.
• Designed and Developed PostgreSQL HA system with physical replication with 2 min outage which Includes auto failover in case of Primary loss.
• Responsible to providing database design for Tier-0, Tier-0.5, Tier-1, Tier-2, Tier-3 which had RTO 10 Min to 24 Hours.
• Responsible for Designing Tier-RT and Tier-NRT which requires Less then 2min RTO by using PostgreSQL Logical replication HA-proxy components.
• Responsible to create backup and recovery procedure of PostgreSQL database by using pgbase backup and barman.
• Hands on experience of Handing Critical PostgreSQL database issues, Physical replication Issues, Logical replication issues and coordinating Various teams during planned, Unplanned events.
• Created several shell scripts for PostgreSQL monitoring, Implemented Grafana for PostgreSQL Monitoring

TECHNICAL SKILLS

Database: Oracle 12c/11g/10g/9i/8i/8.x, PostgreSQL 10.x/11.x/12.x, MySQL 8/5.7/5.6/5.5/5.1

Hardware: Sun Sparc E series, HP ProLiant HP 9000, IBM POWER5+ Servers, IBM RS6000, DELL PowerEdge, Compaq, EMC, Intel Servers, oracle Exadata X2-2

OS: Sun Solaris 8.x, 9.x & 10.x, HP-UX 11.x, IBM-AIX 5L 5.x, Digital UNIX 4.x, SCO UNIX 7.x, RedHat Linux ES 2.x, 3.x & 4.x, SUSE Linux Enterprise Server 9.x & 10.x, OpenVMS 1.x

GUI: Developer 2000(Forms 4.5, Reports 2.5), Developer 6i (Forms 6i, Reports 6i)

DB Tools: OEM 9i & 10g,OEM 10g Grid Control,11g/10g RAC, Golden Gate, RMAN, Data Pump, Export/Import, SQL Loader, OWB, Toad, Quest Shareplex, 9i/10g Data Guard, Oracle streams, Advanced replication (Multimaster).

CASE Tools: ERWIN, Designer 2000/9i

OLAP Tools: Cognos (Impromptu, PowerPlay), Informatica Powercenter 7

Miscl Tools: Veritas Clusters, Veritas NetBackup, Tivoli Data Protection, Cron Processes, Secure CRT, Remedy, VCS, Hummingbird

Languages: SQL*Plus, PL/SQL, T-SQL, C, and Unix Shell Scripting, csh, ksh, bash

PROFESSIONAL EXPERIENCE

Confidential

Sr. Staff Database Engineer

Responsibilities:

• Worked as oracle/couchbase SME for setting up oracle database on New hardware infrastructure to meet the application expectation in terms of TPS and response time.
• Design, develop, build, managed critical enterprise database on 3 node Oracle RAC and with TPS as 1100, 120 concurrent users and response time as 15 ms.
• Designed and build oracle database that provide high availiablity and fault tolerance, tested various scenarios to achieve database availiablity and performance up to the requirements.
• Designed and implemented data replication methodology for achieving database HA/DR and real time data integration for OLTP to OLTP and OLTP to OLAP.
• Implemented Oracle tablespace encryption for protecting data at rest. Hands on experience in Migrating Master key to Key secure appliance and perform reverse key migration.
• Hands on experience on managing oracle local wallet and resolving local/remote wallet issues.
• Responsible for installation, configure, Upgrade, Manage Golden gate.
• Hands on experience in crating golden gate process such as extract, pump and replicat, manage and troubleshooting golden gate issues like abend, lag.
• Responsible for configuration of HA for golden gate on a RAC cluster, ensure that golden gate is working/recovered as expected in case of node failures.
• Design, Developed & Sizing of Couchbase cluster based on Application requirements, which includes working dataset, no: of replica’s and total dataset’s sufficing application response time.
• Designed and implemented High availability & fault tolerance on Couchbase cluster for multi node down complex scenarios
• Installation and configuration of Couchbase cluster based on project requirements as per FICO guidelines while meeting internal enterprise standards.
• Hands on experience on installing, administering multimode Couchbase cluster activities which includes adding/removing node, resetting memory quota, rebalance the cluster after adding/removing node from the cluster
• Performed multiple Couchbase upgrades from versions 3.x to 4.5.1, 5.1 in a rolling fashion with ZERO downtime. Hand-on experience on offline Couchbase upgrades when allowed.
• Proactively monitored Couchbase performance by looking at various statistics and ensure that Couchbase response time is always less than 2 milliseconds for application.
• Configured unidirectional (active/passive) and bi-directional (active/active) replication using XDCR.
• Developed multiple monitoring scripts to capture critical events triggered by Couchbase cluster, Backup, Replication monitoring and checking item counts between the data centers.
• Created Korn shell script to backup Enterprise Couchbase clusters, configured replication from primary cluster to backup cluster to meet RTO and RPO requirements.
• Troubleshoot Couchbase issues, which includes Disk contention, Memory, Hardware failure issues by working with the vendors and multiple internal teams to resolve the issues in timely manner.
• Responsible Installation, configuration and Managing PostgreSQL Single Node cluster and Multi-node cluster by suing Various other components such as repmgr, logical replication, pgbouncer, Haproxy .
• Hands on experience on configuring PostgrSQL Native, Physical replication, logical replication to provide High availably for database.
• Responsible of Installation of repmgr, pgbouncer, haproxy components to Configure PostgreSQL Active-Passive replication Active and Active replication
• Wrote several scripts for PostgreSQL auto failover and PostgreSQL switchover to cover planned and unplanned outage.
• Hands on experience of PostgreSQL database backup and recovery with pgbase backup, barman.
• Hands on experience of Handing Critical PostgreSQL database issues, Physical replication Issues, Logical replication issues and coordinating Various teams during planned, Unplanned events.
• Implementing, documenting, and maintaining database roles and security and data integrity of all instances
• Wrote several shell scripts to Monitor and manage oracle/couchbase/PostgreSQL database system.
• Provided several trainings to the team members on PostgreSQL backup technologies (base backup, barman, repmgr, pgrouncer)

Confidential

Sr. Oracle DBA/SME

Responsibilities:

• Providing database engineering support for new project and worked as Level 3 DBA/SME, handling critical database issues raised by Operations DBA
• Hands on experience on oracle 11g RAC installation, troubleshoot RAC issues, upgrade grid and database from 10g to 11g and 11.2.0.2/11.2.0.3 to 11.2.0.4 and extensive experience on applying patching.
• Install and configuration of 11gR2 on ASM, RAC One Node and Grid Infrastructure for standalone database.
• Hands on experience on Upgrading CRS and database from 10g to 11g, Applying One Off patch/PSU for grid and well as database.
• Primarily worked on Data Center Migration by using SRDF, rman backup, export and imports migrated around 2 Peta Bytes of data to other data center.
• Troubleshoot Database performance / Application performance issues after post migration by using AWR/ASH and sqlt extract by providing greater response time to the end users.
• Migrated around 300 servers, 400 Plus database, both RAC and Non RAC database. Also conversion of database from 32 bit to 64 bit.
• Converting RAC to single instance and single instance to RAC with rconfig as well as manual method.
• Extensive experience with manage, trouble shooting ASM and RAC issues and database issues with the help of various tools like os watcher, CHM(Cluster Health Monitor), ORATOP, EXACHECK For exadata, ASM tool like kfod, kfed, amdu (ASM Metadata Dump ).
• Very good Experience on handling ORA-7445/ORA-600/ORA-04031 as well as ORA-273. Applying workaround, patches, PSU for fixing the bugs.
• Very good experience on handling Planned and Unplanned database Maintenance.
• Implemented Database on Exadata by using Siebel Best Practices and Migrated Siebel 2T database from six node cluster (RAC) to Exadata half rack environment
• Good experience on Exadata architecture, cell offload, smart scan, Pin the objects on Exadata flash cache for optimal performance.
• Very good experience on RAC workload management, creating services for different application and distribute the work load evenly across instances on Exadata database server.
• Trouble shoots database performance by using ASH/AWR reports. Identify long running queries and resolve with Application Team.
• Implemented Database on Exadata by using Siebel Best Practices and Migrated Siebel 3T database from six node cluster (RAC) to Exadata half rack environment.
• Worked with developers and fine-tuned SQL Qualifier SQL to perform 5 times faster in Exadata by adding parallel and FTS hints.
• Installed, configured, managed Physical Data Guard for production database.
• Converting Physical database to Open Mode and deploy the application code for testing new application deployment.
• Have experience in Configuring and make use of Active Data Guard real-time query, Configure and use a snapshot standby database.
• Developed comprehensive backup and recovery policy, designed, tested, implemented backups on Oracle ZFS storage. Minimized backup time up to 80%.
• Very good experience with rman backup, restore, recoveries as well as cloning of database environments from production copy.
• Various environment databases refresh with rman by using active database as well as backup set, regular export/import utilities.
• Migrated Database from Regular file system to ASM and standardized all database to have ASM across the board.
• Identify the hot objects, Move corresponding files from one disk group to another faster disk group
• Installed, configured HA Oracle 12c Cloud control for Monitor and manage various Targets like host, database, listeners, and storage.
• Setting up alerts, notification rules and redirecting alerts to appropriate team.
• Deployed various plugins on cloud control Management server for monitor Siebel, EBS, Exadata, ZFS, EMC storage plugin, active directory, Microsoft Cluster service, oracle virtualization to manage and monitor targets enterprise level.
• Coordinate planned and unplanned events. Raising Service request with Oracle, handling service requests and communicate proper team, Business management in case of Maintenance.
• Experience with Oracle VM, creating VM, managing VM using GUI and integrate VM with Cloud Control as Database cloud infrastructure.
• Good experience on big data technologies like hadoop, installed CDH4 6 node and 12 node clusters. Managing cluster with Cloudera Manager Admin console.
• Good Experience with Managing Multiple Hadoop Clusters, service configuration, service monitoring, activity monitoring, backup and disaster recovery.