SUMMARY

• 8+ years of hands on experience in the IT Industry in Database Administration roles
• 5+ Years of experience as Database Admin of NoSQL Cassandra/Datastax Enterprise Package (Cassandra, Solr, Spark).
• 3+ years of experience in Oracle Database Administration.
• Experience in Database Design, Capacity Planning, Configuration, Upgrade, Migration, Patching, Performance Tuning of the NoSQL Cassandra/Datastax Enterprise (Cassandra, Search - Solr, Spark), Relational Oracle Database databases
• Experience in Backup and Recovery in both NoSQL and Relational.
• Strong understanding and implementing of the Cassandra Architecture.
• Experience in Upgrade, migrating, Data loading within instances and Cluster to cluster.
• Experience in Managing Keyspaces, Datafiles, Commit Log and Snapshots, Database objects, USERS, Roles and PRIVILEGES.
• Experience creating and supporting development, testing, staging, production Single/Multiple Instance clusters.
• Experience installation, configuration and testing of 11g/12c Oracle databases on OEL.
• Experience in Maintaining Exadata (X2-8, X2-2 to X6-2, X6-8), Exalogic and Exalytics
• Experience in Cloning RAC as well as Single instance Databases using RMAN Restore and Recover Techniques, RMAN Duplicate and User Managed Backups.
• Extensive Experience in performing Full, Level 0 and Level 1 Incremental Physical Database backups (Hot and Cold) using RMAN, User Managed Backup and Logical Backups using data pump and import/export.
• Experience in Disaster Recovery Planning, Setup and Testing using Oracle Optimal Solutions such as Physical and Logical Standby and Oracle Active Data Guard, switchover and failover.
• Experience diagnose Staging, production system performance problems such as wait events, Tuning Oracle SGA, Reads, Writes latency, I/O Contention.
• Experience SQL/CQL, JVM Tuning and Optimization
• Expertise in PL/SQL, SQL, CQL and Shell Scripting (Used to write bash shell Scripts & implemented by Using CRONJOB for Day - to - Day activities).
• Experience in development of automation scripts to perform on going database tasks using - HTML, DHTML, CSS, XML, UML, JavaScript, Ajax, Spring, Hibernate, J2EE (JSP, JSTL, JMS, JSF, Servlets, JDBC, JNDI, Java Beans, LDAP, Struts, EJB)
• Strong knowledge on Kafka - Maintenance, performance tuning and Troubleshooting.
• Excellent written and verbal communication skills & willing to learn new technologies.

TECHNICAL SKILLS

Operating Systems: OEL 5.x, 6.x, Red Hat Linux RHEL 7.3/8/9, Linux, Unix

RDBMS: Oracle 10g, Oracle 11gR1/11gR2 Clusterware and Real Application Clusters (RAC)

NoSQL: Apache Cassandra/Datastax Enterprise (Cassandra, Solr, Spark)

Languages: CQL, SQL, Bash Shell Scripting, Java, Python

Software and Applications: SVN, GIT, Espresso, OEM, DATAGUARD, RMAN, Data pump, AWR, TKPROF, ADDM, Difftools - Diff Merge, Excel

PROFESSIONAL EXPERIENCE

Sr. Cassandra Consultant

Confidential, Sunnyvale CA

Responsibilities:

• Monitor, Maintain, Review Cassandra/DSE Architecture on 150+ Clusters, 120000+ hosts to address issues and optimize to maximum performance.
• Involve in Capacity Planning discussions with Architects and suggest as per requirement. Recommended production settings, Cluster Sizing - Disk Capacity, SSD, HDD, RAID CARDS, RAM Memory, cores
• Design, deploy, and support scalable distributed Cassandra DB solutions for high volume applications. Perform deployment in Cloud environment (Amazon).
• Configure Cluster sizing based upon data size, record size, reads/sec, writes/sec, total size of data inserted or updated daily,
• Work on routine change requests pertaining to Data loading/refresh, User access creation, Backup - Snapshot, performance tuning, bootstrap, repair nodes, various ongoing Operations, Monitor and debug issues.
• Recommend and perform DSE version upgrades for clusters to stay in compliance with standards and also to avoid bugs.
• Recommend and perform OEL upgrades and patches to server software to stay in compliance with security standards and support Cassandra/DSE performance
• Configure Cassandra.yaml, dse.yaml, Cassandra-env.sh, cassandra-rackdc.properties, Cassandra-topology.properties, Snitch, directories, Security, tokens, listen address/ rpc address, policies, sizes, thresholds, Protocol, hinted handoffs, ports, encryption(including Solr), Authorizations etc, for Cassandra & DSE Package.
• Set up brand new cluster, bootstrap nodes to existing cluster, adding a data center to existing cluster, Decommission node from existing cluster.
• Perform Spark, Solr, OpsCenter Setup, upgrades, operations and monitoring tasks.
• Monitor Cassandra output information and statistics using JMX-compliant tools - The Cassandra nodetool utility, DataStax OpsCenter.
• Monitor availability and performance of development, testing, staging and production and Cassandra databases clusters
• Perform repair operation on tables, keyspace, node, token ranges and cluster levels.
• Perform Data loading/refresh within instances, cluster to cluster.
• Migrate existing database applications from Oracle to Cassandra.
• Create keyspaces, tables, perform alter, insert, select query tables.
• Perform Data Modeling, replication & replication strategy Clusterting, Indexing to handle very large data sets..
• Create Users, grant, revoke permissions on keyspace and table levels using CQL (CQLSH)
• Perform backup, recovery and manage multi-terabyte databases.
• Perform optimization and tuning activities, including capacity planning, tracking historical usage, trending future resource needs, and modifying resource allocations.
• Troubleshoot connection issues/read-write issues, SSTable errors, exception errors, any hanging operations Tune JVM Parameters - Java heap, Heap size, thread priorities, Unresponsive nodes, Load balancing.
• Performance tuning for the write/read operations, I/O Contention, Concurrent reads and writes, Commitlogs, sstables, Flush operation, Row Cache, Key Cache, Compaction
• Monitoring I/O Activities, CPU utilization, Swap activities and Memory usage with vmstat - Report memory usage, swap space, I/O activities, interrupts and CPU utilization
• Perform Nodetool and dsetool operations
• Prepare shell scripts to Automate database administration tasks cluster wide.
• 24X7 on call production support including on Weekends to ensure 100% uptime.

Environment: OEL 5.x, 6.x, Bash Shell Script, Python, Apache Cassandra 2.1, 3.0, DSE 4.8, 5.0, 5.1, CQL shell, Opscenter 6.0, 6.1, Search (Solr), Spark, Java Driver

Cassandra Database Admin

Confidential, San Jose, CA

Responsibilities:

• Install, configure and maintain Apache Cassandra databases on OEL Linux Platforms.
• Work on routine change requests pertaining to Data loading/refresh, User access creation, Backup - Snapshot, performance tuning, bootstrap, repair nodes, various ongoing Operations, Monitor and debug issues.
• Perform Cassandra/DSE version upgrades for clusters to avoid issues and bugs.
• Perform OEL upgrades and patches to server software to stay in compliance with security standards and support Cassandra/DSE performance.
• Configure Cassandra.yaml, dse.yaml, Cassandra-env.sh, cassandra-rackdc.properties, Cassandra-topology.properties, Snitch, directories, Security, tokens, listen address/ rpc address, policies, sizes, thresholds, ports, encryption, Authorizations etc, for Cassandra & DSE Package.
• Set up brand new cluster, bootstrap nodes to existing cluster, adding a data center to existing cluster, Decommission node from existing cluster.
• Monitor Cassandra output information and statistics using JMX-compliant tools - The Cassandra nodetool utility, DataStax OpsCenter.
• Monitor availability and performance of development, testing, staging and production and Cassandra databases clusters
• Perform Data loading/refresh and repair operation on tables, keyspace, node, token ranges and cluster levels.
• Planned and performed daily, weekly and monthly backups.
• Create keyspaces, tables, perform alter, insert, select query tables, change replication factor & replication strategy using.
• Create Users, grant, revoke permissions on keyspace and table levels using CQL (CQLSH)
• Performance tuning for the write/read operations, I/O Contention, Concurrent reads and writes, Commitlogs, sstables, Flush operation, Row Cache, Key Cache, Compaction
• Monitoring I/O Activities, CPU utilization, Swap activities and Memory usage
• Check outputs by perform Nodetool operations
• Prepare shell scripts to Automate database administration tasks cluster wide.
• Configure and monitor numerous MongoDB instances and automate tasks and 24X7 production support and on call rotation.
• Resolved connectivity issues for applications and users.

Environment: OEL 5.x, 6.x, Bash Shell Script, Apache Cassandra 2.x, 3.x, DSE 4.8, CQLshell, Opscenter 6.0, 6.1, Search (Solr), Spark, Java Driver

Oracle/Cassandra DBA

Confidential, Dallas TX

Responsibilities:

• Monitor 11g grid control to error notification adding new targets to grid control Environment
• Create new instances, refreshing databases, and cloning databases using RMAN and User Managed Techniques.
• Create keyspaces, tables, perform alter, insert, select query tables, perform Nodetool and dsetool operations in Apache Cassandra
• Create Users, grant, and revoke permissions on keyspace and table levels using CQL (CQLSH) for Cassandra databases.
• Work on adpatch, adadmin, adctrl, adrelink, adident, admerge, adconfig on EBS R12.
• Keep Oracle environments up-to-date by applying CPU/PSU and one off patches.
• Configured high availability solutions such as ASM, Data Guard and RAC.
• Maintaining user accounts, Profiles and ensuring proper database security.
• Upgrading database from Oracle version 10gR2 to 11gR1and migration of data.
• Applying CPU and interim patches on RAC and Grid Infrastructure binaries.
• Configure and monitor numerous MongoDB instances and automate tasks and support.
• Worked with oracle support 24x7 to expedite the process in resolving an issue.
• Administering production databases as large as 2.5 TB on a 4 node RAC installation.
• Migration of Databases from Non-RAC to RAC.
• Cloning the database using RMAN Duplicate Feature and active Duplication Feature.
• Installation and Database creation on 11gr2.
• Configured SCAN on 11gr2 Cluster.
• Well versed in Rapid Install, AD utilities for Oracle Applications.
• Creating and Maintaining Physical Standby databases and resolving the archive gap.
• Applying Rolling patches for RAC Databases.
• Database and schema Refresh using Data pump utility
• Troubleshooting concurrent manager issues.
• Prepare shell scripts to Automate database administration tasks cluster wide.

Environment: Oracle 11gR1/11gR2, SQL, PL/SQL, EnterpriseLinux5.4, EBS11i, IBM AIX6.1, SUNOS 5.9, Apache Cassandra 2.X, UNIX

Oracle DBA

Confidential

Responsibilities:

• Created and maintained 30+ Oracle 10g/11g databases. Some configurations use Oracle Data Guard for the DR/Standby solution and RAC using SAN Storage. Use RMAN for backup and recovery; use oracle tool AWR/ADDM to diagnose database problems.
• Create and maintain databases required for development, testing, education and production.
• Performing the capacity planning required to create and maintain the databases.
• Write and modify UNIX shell scripts to manage Oracle environment such as archive log and audit log files rotation, and for taking RMAN Full and Incremental Backups.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, RAID, RAW Devices.
• Cloning the database using RMAN Duplicate Feature and active Duplication Feature.
• Work on Database Point in Time Recovery using RMAN Incremental Backup and archive logs.
• Established database backup/recovery strategy for different databases.
• Upgrade of Oracle database from 11.1.0.6 to 11.1.0.7.
• RMAN backup scripting for full, cumulative and incremental levels for tape and disks.
• Migration of Databases from NON-ASM to ASM and Non-RAC to RAC.
• Creation and Maintenance of RMAN catalog database for production Databases.
• Provide technical support to application development teams.
• Control migrations of programs, database changes through the development lifecycle.
• Management of table space growth, monitoring data files additions, extent growth.
• Performed cross platform migration using transportable tablespace feature and RMAN.
• Work in a team of Java Developer to prepare the java scripts to automate tasks.

Environment: Oracle 10g, Sun Solaris, RHEL, OEL 4.x and 5.x, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, STATSPACK, UNIX, AIX