SUMMARY

• Senior Database Architect & Database Administration (DBA) with 15+ years of comprehensive experience and strong technical understanding in Telecom and Financial industry data management.
• Lead/Manage large global teams with a delivery - focused mindset and collaborative approach. Longstanding experience in strategizing and leading technology transformation projects with Dimond clients.
• Serveing as a Senior Database Architect for the Business Intelligence, Retail, Online, Web, Legal applications hosted on Azure and on-premises. Installing, Creating, Migrating, Upgrading, Patching, Tunning, Capacity Planning, data modelling, schema and table designs for various flavor of Databases running on Linux, AIX, Solaris and Windows Platforms.
• Experience in Relational Databases (SQL) such as OracleDB, SQL ServerDB, MySQL and PosgreSQL Databases.
• Experience in Non-relational Databases (NoSQL) such as CassandraDB and Couchbase Databases.
• Experience in managing, administrating, migrating Databases on-prem, Microsoft Azure, Oracle Database Appliance (ODA), Transperent Data Encryption(TDE), Exadata and ExaCC
• Implementations dealing with IAAS and PAAS infrastructures and documenting the same
• Led/implemented multiple DB upgrades, monitoring enhancements and automation efforts
• Led/Implemented the Organization’s Cloud initiative programs to migrate the Databases for Legacy Web applications from on-premises to the Azure Cloud and Oracle Cloud platforms, participating in the solution strategy, development and maintenance effort.
• Served as Delivery Manager for the Telecom and commercial BI portfolios with more than 100+ applications deployed on k8s clusters as mS based Architecture.
• Managed end-to-end SDLC cycles - Developed project and resource planning and implementation roadmaps. Provided updates to IS leadership and resolved project issues
• Responsible for providing all aspects of Database engineering and supporting multi-terabyte database management systems
• Served as Technical SME in data integration, data warehousing design & implementations
• Experience in Installation, Configurating(uni-direction, bi-directioanal and multi directional) of Golden Gate replications across both on-prem and Cloud.
• Very Good hands on experience in Oracle Applications E-Business Suite (APPS DBA), SSO and OID.
• Experience in managing Oracle RAC, Exadata, ExaCC, Data Guard, OEM Grid and Backup & Recovery using RMAN backup utilities.
• Experience with installing, configuring and monitoring Apache Cassandra cluster
• Experience in implementing multi-datacenter cluster in Cassandra.
• Experience in creating column Family’s: bootstrapping, decommissioning, removing, replacing, and repairing nodes in Cassandra.
• UNIX shell scripting, PLSQL, SQL and PowerShell scripting
• Ensure IT standards, audit and compliance requirements are understood and adhered to and well documented.
• Ensure IT operational documentation, build documents, processes and procedures are completed and maintained to a high standard.
• Make sure that we have a robust and resilient backup solution implemented across all our database technologies.
• Work with third party vendors to understand and bring in new solutions.
• Research and implement new technologies
• Evaluate various tools available in the market related to database monitoring/performance troubleshooting etc.
• Integrating new infrastructure services based on designs, and participating in automation, consolidation, and centralization projects.
• Provide Guidance to DB Operations Team on performance troubleshooting if required.
• Flexible with 24*7 environment including on call support as per the requirement
• Committed, enthusiastic and efficient, leading team or independently

PROFESSIONAL EXPERIENCE

Confidential - Alpharetta, GA

Responsibilities:

• Supporting online sales and agent sales application for Confidential & Confidential as Senior Database Architect for databases Oracle, Apache Cassandra, MySQL, PostgreSQL and Apache Solr etc
• Managing 1000+ enterprise-level Oracle 11g, 12c and 19C database systems, achieving the goal of 99.99% availability Confidential acceptable level of performance.
• Installed and configured oracle Golden Gate DML/DDL between homogenous oracle to oracle rdbms replication on-prem and AZ cloud
• Installed and Migrated Data from standalone to ODA(Oracle Database Applicance), ExaCC Single and 2 node RAC DBs.
• Used Transparent Data Encryption (TDE) using EKM Solutions to encrypt customer sensitive data.
• Oracle to Cassandra data streaming using oracle big data golden gate.
• Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery for PostgresSQL db.
• Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.
• Tunning the Oracle databases through OEM Grid Control, Explain Plan, Tkprof, AWR, ADDM, ASH and SQL Tuning Advisor (sqltrpt) utilities to find and tune the top wait events, top sql’s by elapsed time, CPU and IO Creating index, Sql profile and SPM to improve the query performance.
• Cloning of databases cluster database, Normal database using HOT&RMAN Methodologies
• Upgrading Oracle DB’s from lower version to Higer versions. And applying Quarterly DB patches.
• Regular Refresh of ERP & Oracle databases.
• Performed pre and post refresh steps as a part of ERP cloning.
• Establish and maintain sound backup and recovery policies and procedures
• Managing databases, monitoring, patching, reports for Oracle database from Oracle Enterprise Manager (OEM), Nagios and custom scripts from Crontab.
• Installed, Configured, Administered Apache Cassandra 3.x for muti-datacenter hybrid environment.
• Involved in capacity planning, data modelling, schema and table designs for various applications.
• Involved in various Cassandra db administration tasks like, decommission, expansion of nodes, adding(rebuild), decommission, creating duplication(copy) of datacenters.
• Worked on Cassandra upgrade 3.11.1 to 3.11.8(over 1000+ nodes).
• Involved in yearly SSL certs renewal(one-way) on Cassandra and solr servers
• Worked on fixing various security vulnerability fixes (log4j, tlsv1, logjam etc.).
• Configured, installed presto and zeppelin environment to query Cassandra databases and configured multiple reports for various analytics use cases.
• Upgraded presto (0.261) and zeppelin (0.8.0 to v0.10).
• Experience in setting up the required replication factors for key spaces in Cassandra.
• Troubleshoot read/write latency and timeout issues in Cassandra.
• Extensively used ansible playbooks for automating multiple requirements for Cassandra and SOLR.
• Installed, Configured, Administered large scale SOLR clusters.
• Worked on SOLR administrative tasks like creating collections, add or remove replica from shards, copying schema from one cluster to other.
• Involved in SOLR schema and filed creation for collections.
• Configured Grafana with multiple dashboards(cassandra and solr) -Prometheus storage monitoring tool.
• Setting up alerting mechanisms (email, ms-teams, slack) for various. processes on tools like Grafana and Nagios.
• Hands on experience on creating Shell Scripts especially for DB monitoring, backups, Goldengate Status and replication lag and scheduling jobs.

Confidential

Responsibilities:

• Creating new Database/Application users, custom responsibilities, and Assigning responsibilities for new/existing users based on the ESRs.
• Optim Data cut from prod to non-prod masking prod sensitive data.
• Performed Code Promotions/Deployments from DEV to INT/Testing based on DR requests.
• Applying patches on all environments using adpatch/opatch.
• Writing monitoring scripts and scheduling them on cron tab.
• Supporting Confidential PS&M project which had critical applications and handling team of 10 members and complete DBA support activities from offshore.
• Responsible for deliverables and releases from offshore. >Involved in understanding of various client business applications Cross train the team on functional and technical aspects of the various applications used in Confidential .
• Lead the team from DBA end and supported complex migration from Oracle 9i to 11G in Siebel upgrade project.
• Oracle Apps DBA - Oracle EBS R12 Oracle DB 10G (10.2.0.4), Maintenance/ support for development around 13 environment instances Maintenance/support involved Oracle Incentive Compensation Modules. -
• Copy/Clone of Oracle application Development and testing environment from production backup using Rapid clone
• ORACLE APPS R12, Oracle Solaris 9, ADADMIN, ADPATCH, RAPID CLONE, AUTOCONFIG, SHELL SCRIPTs.
• Worked on setting up and configuring database roles, tablespaces, configuring backups, setting up Data guard or Golden Gate based on architecture new designs for RAC and Standalone databases and migrating databases
• Data refresh from production to development & test Databases.
• Database restore and recovery using RMAN and manual methods.
• Cloning databases with various strategies like Cold, Hot and RMAN.
• Involved in Production Database Upgradations from 9i to 10g.
• Applying CPU/PSU patches on the database.
• Managing the Dataguard and ASM databases.
• Managing OCR, Voting disk and performing restore and recovery operations.
• Administering Oracle Clusterware and the RAC database instances using CRSCTL, SRVCTL, OCRCONFIG, CLUVFY utilities.
• Troubleshooting RAC Instances & Listeners

Confidential

Responsibilities:

• Handling Change management and Release management activities
• Applying patches, CEMLI and Config changes.
• Working on high availability environment like (R12 Apps +10g RAC DB, 11i Apps+10g RAC, R12 shared appltier, 11i shared appltier, PCP Concurrent Manager)
• Handled top 20 Tier1/Tier2 customers Confidential Oracle On Demand team.
• Performed day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs
• Worked on Oracle Enterprise Management OEM 12c/13c to configure databases and its components and generated reports AWR, ASH, ADDM to analyze database performance and identify bottle necks
• Data refresh from production to development & test Databases.
• Database restore and recovery using RMAN and manual methods.
• Cloning databases with various strategies like Cold, Hot and RMAN.
• Involved in Production Database Upgradations from 9i to 10g.
• RMAN backup setup for the newly cloned instances.
• Applying CPU/PSU patches on the database.
• Managing the Dataguard and ASM databases.
• Managing OCR, Voting disk and performing restore and recovery operations.
• Administering Oracle Clusterware and the RAC database instances using CRSCTL, SRVCTL, OCRCONFIG, CLUVFY utilities.
• Troubleshooting RAC Instances & Listeners

Confidential

Responsibilities:

• Creating new Database/Application users, custom responsibilities, and Assigning responsibilities for new/existing users based on the Tickets.
• Performed Oracle Database refresh from production to development and Test DBs on 9.2.0.8 and 10.2.0.3 versions.
• Copy/Clone of Oracle application Development and testing environment from production backup using Rapid clone.
• Implemented India Localization patches in DEV/INT and Production Instances on Oracle EBS 11i (11.5.10.2).
• Applied Oct2008 CPU patches on 9.2.0.8 and 10.2.0.3 DBs, Including oracle apps DBs.
• Performed Code promotions to INT/Testing and Production DBs/Applications by processing CCDs.
• Installed pl/sql version of Taxware installation Development, testing instances.
• Installed Oracle Application server 10G and upgrade to latest patch version, configured forms and reports also written shell script to compile the form.
• Maintain/Administering custom applications of 10iAS with forms like PCS, DOCS, TOS and EEV etc.

Confidential

Responsibilities:

• Copy/Clone of Oracle application environment using Rapid clone
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl etc.
• Created and managed the Database objects and schemas
• Installed ADI (Application Desktop Integrator) tool on Windows XP to integrate the Desktop with oracle application with EBS.
• Installed 10g SOA suite on Windows XP to work on BPEL
• Application user creation / responsibilities assignment.
• Created and maintain custom responsibilities and menus.
• Created table spaces, tables, and users for custom applications.
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
• Move all custom programs and reports to CRP instances. This involves enforcing naming standards, maintaining the custom application top, and setting up concurrent requests.
• Troubleshoot problems with web server, web listener, forms server, concurrent managers, and database.