SUMMARY

• Having 13 years of vast experience across IT in teh field of Oracle DBA, Golden Gate, SharePlex, Cassandra Administrator and MongoDB Administrator
• Having 13 years of experience in Database Administrator in Oracle, RAC, Data Guard including Cassandra Administration and MongoDB
• More TEMPthan 5 years of solid hands - on experiences on Cassandra database administration which involved Data Modeling, Configuration, Administration, Monitoring, Security Management, Performance Tuning, Replication, Backup/Restore and Troubleshooting of issues.
• More TEMPthan 7 years of experiences and solid hands-on experiences in installation, configuration, performance tuning and troubleshooting Oracle GoldenGate in Oracle to Oracle homogeneous environments and heterogeneous environments
• Upgrade experience in an Oracle environment (11g/12c/18c to 19c)
• First-hand experiences in setting up Oracle GoldenGate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions.
• Primary technical resources for GoldenGate configuration and troubleshooting on any GG issue
• Deep understanding Oracle GoldenGate internal mechanism
• Performed database administration like User Management and implement Security using Roles, Privileges, Grants, applied patches, Database upgrades
• Build and maintain Golden Gate Processes for replicating purposes including RAC databases. Troubleshoot with Golden Gate ERRORS.
• Experience performing Data Replication (Oracle GoldenGate ideal, opportunity to work with SharePlex )
• Worked as production DBA in 11g/12c/18c/19c.
• Extensively worked on SharePlex Oracle Replication Tool
• SharePlexforOracle.SharePlexforOracleis a simple, low-cost data replication solution forOracledatabases
• Extensively worked on Install SharePlex binaries, Create teh SharePlex database user splex, Start SharePlex, Create Configuration file, Verify replication is working & Troubleshooting if any issues.
• Tablespace management and capacity planning.
• Administer RAC databases and also STARTING/STOPPING RAC SERVICES.
• Worked on Backups and Recovery policy Hot/Cold Backup using RMAN.
• Implementation and Setup of Data Guard and provide support for Oracle Data guard and streams implementation for DR setup.
• Monitoring and optimizing teh performance of teh database through Tuning Applications, Tuning Memory, and Tuning Disk Usage etc. Performance and tuning using AWR reports, ADDM, 10G Advisors.
• Gathering statistic, analyzing tables and indexes.

TECHNICAL SKILLS:

Apache Cassandra: Cassandra, DataStax, DevCenter and OpsCenter, Node tool, Spark on Cassandra

NoSQL Database: Cassandra, MongoDB

Relational Database: Oracle, MySQL/Maria.

PROFESSIONAL EXPERIENCE

Cassandra Administrator

Confidential

Responsibilities:

• Database Architecture and Administration activities which involved Data Modeling, Configuration, Administration, Monitoring, Security Management, Performance Tuning, Replication, Backup/Restore and Troubleshooting of issues.
• Scheduling Cassandra Monitoring and Backup configuration
• Installation and Configuring Cassandra database as per Client standards
• Creating application keyspaces
• Granting keyspace privileges to application roles
• Configuring scripts to Cassandra db Auto Startup (Setup auto shutdown/startup script)
• Creating error log check script
• Creditable knowledge on Data Modeling like Partitions, Clustering etc. and on Architecture like Node, Ring, Peer-to-Peer, Vnodes, Gossip, Snitch
• Good Command on CQL to run queries on teh data present in Cassandra Cluster with multi DC's in 8 nodes each.
• Analyzed teh performance of Cassandra cluster using Nodetool TP stats and CFstats for thread analysis and latency analysis.
• Modified Cassandra.yaml and Cassandra-env.sh files to set teh configuration properties like node addresses, MemTables size and flush times etc.
• Involved in moving teh SSTables data on to teh live cluster.
• Experienced in installing, configuring and monitoring teh Datastax Cassandra Cluster
• Commendable knowledge on read and write processes, including SSTables, MemTables and Commitlog.
• Experience with querying on data present in Cassandra cluster using CQL (Cassandra Query Language).
• Used JMX, New Relic, Grafana and Nodetool utilities to monitor teh cluster.
• Experience in taking teh data backups through NodeTool snapshots.
• Experience in moving teh SSTables data on to teh live cluster.
• Tested teh application and teh cluster with different consistency levels to check for teh writes and reads performance with respective to Consistency Level.

MongoDB Administrator

Confidential

Responsibilities:

• Keep clear documentation of teh database setup and architecture
• Write procedures for backup and disaster recovery
• Ensure dat teh databases achieve maximum performance and availability
• Design indexing strategies
• Configure, monitor, and deploy replica sets
• Upgrade databases through patches
• Create roles and users and set their permissions
• More TEMPthan 5 years experiences and solid hands-on experiences in installation, configuration, performance tuning and troubleshooting Oracle GoldenGate in Oracle to Oracle homogeneous environments and heterogeneous environments
• First-hand experiences in setting up Oracle GoldenGate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions.
• Extensive skills in upgrading OGG 11gR2 to 12c, configuring OGG in RAC high available environment.
• Primary technical resources for GoldenGate configuration and troubleshooting on any GG issue
• Deep understanding Oracle GoldenGate internal mechanism
• Experience of Oracle Golden Gate (GG) installation, configuration and troubleshooting Golden Gate Extract and Replicate issues
• Worked on databases sizes 2TB and involved in scheduling backups
• Performed database administration like User Management and implement Security using Roles, Privileges, Grants, applied patches, Database upgrades
• Build and maintain Golden Gate Processes for replicating purposes including RAC databases. Troubleshoot with Golden Gate ERRORS.

Confidential, Irving TX

Oracle, Cassandra & Mongo DBA

Responsibilities:

• Create and configure 11g,12c, 18c & 19c RAC databases cluster
• Create and configure 11g,12c, 18c & 19c RAC databases cluster
• DBA's and DB tools like OEM, TOAD, AWR, ASH, ADDM, Scripts etc., can only See/report top SQL and SQL details (timing info, execution plans, data skew, stats etc.,), Migrate on prem Oracle databases to OCI
• Start from teh OS, observe how Resources (CPU, Memory, IO, Network etc.,) are being consumed
• OS tools: top -c, vmstat, iostat, sar
• Vendor (Oracle) provided tools: OSWatcher
• OEM - Oracle Enterprise Manager, TOAD, SQL Developer etc., GUI tools
• AWR & AWR Diff Reports - Global (RAC) and Instance reports, ASH - Active Session History, ADDM
• Make sure to have proper gather stats collection is in place, automatic, manual etc.,
• Application Schema Stats - Start with Auto stats
• System Stats - one time, upgrades, when recommended
• Tracking and Alerting Large tables, archiving and/or purge process, measuring purge/archive process progress, suggesting alternate solutions if needed.
• Table Partition, Reporting offloading, etc.
• Tracking and Alerting Expensive and/or Long running SQL - Based on Elapsed time, tracking teh progress
• Tracking and Alerting Locking/Blocking SQL tracking and alerting
• Interaction with Dev team until issues are fixed/resolved.
• Comparing before and after major change/release with AWR diff, AWR and ASH reports (OEM)
• Working with Oracle through SR if needed.

Cassandra Administrator

Confidential

Responsibilities:

• Database Architecture and Administration activities which involved Data Modeling, Configuration, Administration, Monitoring, Security Management, Performance Tuning, Replication, Backup/Restore and Troubleshooting of issues.
• Scheduling Cassandra Monitoring and Backup configuration
• Installation and Configuring Cassandra database as per Client standards
• Creating application keyspaces
• Granting keyspace privileges to application roles
• Involved in moving teh SSTables data on to teh live cluster.
• Analyzed teh performance of Cassandra cluster using Nodetool TP stats and CFstats for thread analysis and latency analysis.
• Tuning and setting up DB and memory parameters to improve/stable teh performance of Cassandra servers.
• Keyspaces Management.
• Node health checkups.
• Starting/stopping /Bouncing Cassandra server when needed or requested with tickets.
• DBA support during OS Patching for Cassandra Servers.
• Staging and scheduling all needed scripts across all servers to monitor daily health check of database.
• Evaluation of configuration file (Cassandra.yaml) regularly.
• Co-ordination and discussion with application team in case of chronic alerts to ensure app team do not see any error or performance hiccups.
• Monitoring of various file systems related to DB home, Commitlog, data and backup etc.
• Involved in moving teh SSTables data on to teh live cluster.

MongoDB administrator

Confidential

Responsibilities:

• Veridata Configuration: Configured Oracle Golden Gate Veridata, dis will compares one set of data to another and identifies data dat is out-of-sync, and allows us to compare and repair dat data, we configured for couple of major application which is replicating data from 30+ source systems.
• Database Migration: Migrated successfully major production db's from on-prem to OCI cluster AND Standby (DR) built on DR cluster for prod database.
• Database Upgrade: Upgraded databases from 12c to 19c and 18c to 19c (Did upgrade for 6 Major Application db's)
• SharePlex Configuration: Configured SharePlex (Replication tool) from one of teh wireless application to customer profile application, dis will replicate data from source to target on test and prod env
• GG Monitoring Setup: Installed and Configuring Oracle Golden Gate Monitor 12c (12.2.1.2.4), dis is a real-time, Web-based monitoring console dat delivers an Confidential -a-glance, graphical view of all of teh Oracle Golden Gate instances and their associated databases within your enterprise. Instantly, you can view statistics, targeted views, and alerts dat will help you to monitor teh performance of all of teh objects in teh Oracle Golden Gate configuration and detect problems, such as lag or abended processes, teh moment dat they occur.
• GG Replication setup from Cassandra to Oracle: Configured Oracle Golden Gate capture (Extract) to get changes from Apache Cassandra databases to Oracle Database. Apache Cassandra is a NoSQL Database Management System designed to store large amounts of data.
• OGG BIG DATA Configuration from oracle to Cassandra: Installed and Configured Oracle Golden Gate for Big Data 12c streams transactional data into big data systems In real time for one of teh major application db on TEST, PLE and PROD env, which is replicating data from oracle to Kafka and to Cassandra

Confidential

Oracle DBA

Responsibilities:

• Total 5+ years of experience as Database Administrator in Oracle, Cassandra, and MySQL/Maria & Golden Gate.
• Create and configure 12c RAC databases, cluster
• Upgrade all legacy RAC database and cluster to 12c RCA
• Configure Disk and Net backup of databases
• Performance tuning to optimize teh databases
• Capacity planning for databases for future growth
• Oracle GoldenGate implementation, setup and maintenance for ETL operation
• Basic troubleshooting of day to day issues
• Configure and setup disaster recovery for database
• Perform data migration across environment.
• Configure solutions like GoldenGate, dataguard for geo redundancy
• Configure and install new Cassandra servers as per Design Plan.
• Monitoring DB backups and Taken Necessary Action in case of Failure.
• User and password management for SDBA Owned account.
• Tuning and setting DB and memory parameters to improve/stable teh performance of Cassandra servers.
• Keyspaces Management.
• Node health checkups.
• Starting/stopping /Bouncing Cassandra server when needed or requested with tickets.
• SDBA support during OS Patching for Cassandra Servers.
• Staging and scheduling all needed scripts across all servers to monitor daily health check of database.
• Evaluation of configuration file (Cassandra.yaml) regularly.
• Co-ordination and discussion with application team in case of chronic alerts to ensure app team do not see any error or performance hiccups.
• Monitoring of various file systems related to DB home, Commitlog, data and backup etc.
• Raising ticket and coordinating with AAF team (Third Party authentication S/W) in case of AAF authentication issue.
• Password management to be ASPR compliance.
• Involved in moving teh SSTables data on to teh live cluster.

Confidential

Oracle DBA

Responsibility

• Accountable for managing multiple databases with Primary DBA role and responsibilities.
• (Project Specific - Patch / Security / RMAN / AUTOSRM Compliance.)
• Manage teh planning and implementation phase of major activities.
• Special work with sub-project i.e. VPMO (Virtual project management Activities).
• Working with Mission critical applications and respective databases.
• Major Cutover activities for Database migrations.
• Apart from teh above, special intervention needed for Incident / Change management.
• Outage calls management, subsequently execution up to root cause analysis.
• Project specific and customized Shell scripting.
• Setting up and managing Apache Cassandra, Apache Kafka and SQL Server clusters.
• Work with developers to create and deploy models according to their modules
• Implementation of Database mirroring and transaction replication.
• Installing Docker software on Linux env
• Configuring directory structures for cassandra, Kafka software's
• Installing Cassandra database on top of Docker software
• Scheduling Cassandra Monitoring and Backup configuration
• Installation and Configuring Cassandra database as per Confidential &T (Client) standards
• Installation and Configuring Cassandra database using SWM tool
• Creating application keyspaces
• Granting keyspace privileges to application roles
• Configuring scripts to Cassandra db Auto Startup (Setup auto shutdown/startup script)
• Creating error log check script
• Good Command on CQL to run queries on teh data present in Cassandra Cluster with multi DC's in 8 nodes each.
• Analyzed teh performance of Cassandra cluster using Nodetool TP stats and CFstats for thread analysis and latency analysis.
• Used teh DataStax OpsCenter for monitoring teh health of teh cluster with respect to teh keyspaces and teh tables designed.
• Modified Cassandra.yaml and Cassandra-env.sh files to set teh configuration properties like node addresses, MemTables size and flush times etc.
• Experience in creating tables involving collections, TTL's, Counters, UDT's as part of physical data modeling.
• Involved in moving teh SSTables data on to teh live cluster.

Confidential

Oracle DBA

Responsibility -

• Worked with huge DB infrastructure environment, Teh Project support more TEMPthan 1000 Database all over teh world.
• Responsible for administering Oracle Real application Clusters AIX
• Manage teh implementation ofbackup and recovery procedures.Working Tape Libraries ()
• Working with OS clusters / Veritas Environment.
• Troubleshooting teh RAC availability issues
• Install and upgradeOracle and supporting products.
• Major Database upgrade Activities (Single Node and RAC databases)
• Patch Management and version upgrades (PSU/CPU/Bug Patches on Single node / RAC nodes db)
• Major Cutover activities for Database migrations
• Shell scripting
• Flashback database
• Basic performance tuning activities*
• Diagnose and resolve locking conflicts / Sessions Conflicts
• Use data dictionarytables and views.
• Monitor a database instance.
• Collect and analyze relevantdatabase performance information.
• Identify and implement appropriate solutions fordatabase performance problems.
• Know how touse vendor support serviceswhen necessary.

Confidential

Oracle DBA

Responsibility

• Responsible for administering Oracle Application System on Linux RHEL 5 / AIX
• Working with RAC cluster ware.(create and manage RAC databases)
• Maintain daily checklist and Troubleshooting teh problems faced in daily routines.
• Maintain Oracle Operated system files.
• Temporary and Undo Tablespace management.
• Maintaining archive logs And Backups to backup media.
• Checking of alert logs and checking operating systems logs.
• Checking free space of tablespace and Index usage.
• Installation of Oracle 10G on RHEL 5 and working with Standby database managed, manual.
• User management; roles and privilege management.
• Backup Recovery Operations.
• Export-Import and Expdp-Impdp Utilities.
• Backup Contingency.(RMAN Restoration / User managed Restoration)
• RMAN Utilities with RMAN scripting.
• Maintaining various storage structures.
• Identify bottlenecks and Performance Tuning. ( stats packs / AWR / ADDM )
• Worked application servers Oracle / WebSphere Apps Servers.
• Shell scripting (for Automation Project.)

Confidential

Oracle DBA

Responsibility

• Responsible providing 24x7 on-call production/development/testing database support.
• Involved in installation of Oracle on different platforms, loading of user data to reproduced teh problem
• apply new Oracle patches to production/Quality/development instances
• managed database backup using RMAN
• Involved in Weekly Database refresh from production to quality
• Coordinate Knowledge transition sessions for new Hires. Development which supports project needs.