SUMMARY

• Over 5+ years of experience as Database Administrator including 3 years as Cassandra Administrator providing 24*7 production database support with Support to developers & end - users on call support & coordination with offshore teams
• Extensive knowledge on database administration for ORACLE 11g/10g, Apache Cassandra and Scylla DB with experience on large scale database environments.
• In depth knowledge of Apache Cassandra, Datastax Enterprise Cassandra and ScyllaDB
• In depth knowledge on Cassandra internals like Gossip communication, Peer-Peer architecture, Incremental Repairs, Replication & Compaction strategies.
• Experience with installing, configuring and monitoring Apache Cassandra cluster & ScyllaDB
• Experience in implementing multi-datacentercluster.
• Designing data models in Cassandra and working with CassandraQuery Language (CQL).
• Experience in creating column Family’s, bootstrapping, decommissioning, removing, replacing, and repairing nodes.
• Experience in creating keyspaces, tables and secondary indexes in Cassandra
• Experience in setting up the required replication factors for keyspaces
• Implemented Spark solution to generate reports from Cassandra data
• Experience in generating user specific reports based on indexed columns using SPARK
• Experience in fetching and loading data in Cassandra using Spark
• Utilized Cassandratools including sstableloader,sstable2json and json2sstable, COPY for application data loading and analysis
• Experience in Performance tuning Apache Cassandracluster to optimize writes and reads
• Troubleshoot read/write latency and timeout issues in CASSANDRA
• Hands on experience in Installing, Migrating, Upgrading and Maintaining different Oracle versions on UNIX, AIX, Linux, Sun Solaris and Windows Platforms.
• Experienced in setting up/installation and configuration of 11g RAC/10g RAC
• Hands on experience in Oracle 11g/10g databases with RAC cluster and ASM administration.
• Implemented high availability of databases using Data Guard on RAC clusters and Golden Gate setup
• Expertise in Active Data guard configuration, implementing and maintaining physical standby databases.
• Experience in implementing and maintaining Golden Gate replications across multiple Oracle databases.
• Experience in Oracle Enterprise Manager (OEM), SQL*PLUS and Grid Control.
• Good experience in Oracle performance tuning, AWR and Database Security.
• Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN catalog.
• Expertise in development, testing and implementation of Backup and Recovery strategy Using RMAN, Data pump and Export/Import utilities.
• Experience in SQL Performance Tuning using Explain Plan, SQL Trace, ADDM, AWR, Optimizer Hints and TKPROF utility.

TECHNICAL SKILLS

Operating Systems: Redhat Linux, Windows, Sun Solaris, UNIX, Centos, Ubuntu

Languages: SQL, PLSQL, Shell scripting, CQL, C

Web Technologies: HTML/ HTML5, CSS3, XML

Relational Databases: Oracle 11g/10g; SQL Server 2008/2012NoSQL Databases Cassandra, ScyllaDB, Couchbase

PROFESSIONAL EXPERIENCE

Database Analyst/DBA

Confidential - Plano, TX

Responsibilities:

• Installed and configured Apache Cassandra on Prod, Dev, Test, Stage and Performance environments.
• Implementing and maintaining a multi Datacenter Cluster.
• Creating required keyspaces for applications. Determining and setting up the required replication factors for keyspaces
• Data Modeling Cassandra schemas according to requirements
• Configured authorization to Cassandra cluster using Password Authenticator
• Working and helping developers in understanding the Architecture of Cassandra, Datastax Drivers, limitations in Data Modeling and using CQLSH
• Creating and Managing database users and granting/revoking required privileges to the users.
• Installed and Configured DevCenter for developers.
• Installed & configured OpsCenter and Grafana tools to monitor Cassandra cluster.
• Involved in the process of bootstrapping, decommissioning, replacing, repairing and removing nodes.
• Writing shell Scripts for taking Snapshot backup of all the Keyspaces and Scheduling a Cronjob.
• Writing shell Scripts for repairing the Cassandra Cluster and Scheduling a Cronjob
• Installed and configured ScyllaDB on Dev, Test, Stage, and Performance environments.
• POC on Cassandra and Scylla Performance
• Performed Cassandra Stress Dev and Test on Cassandracluster and ScyllaDB cluster to benchmark the performances with minimal system requirements.
• Created Ansible Playbooks for automating the Cassandra Installation on Test Cluster.
• Installed and Configured Couchbase on Test AWS servers

Database Engineer

Confidential - Overland Park, KS

Responsibilities:

• Working with architects for designing the Cassandra Cluster Architecture and to gather requirements, capacity planning for multi data center Apache Cassandra cluster.
• Installed and configured Apache Cassandra on Dev clusters from the scratch.
• Implementing and maintaining a multi Datacenter Cluster.
• Creating required keyspaces for applications. Determining and setting up the required replication factors for keyspaces
• Migrated schemas from MySQL to Cassandra by designing new data model
• Data Modeling Cassandra schemas according to requirements
• Configured authorization to Cassandra cluster using Password Authenticator
• Working and helping developers in understanding the Architecture of Cassandra, Datastax Drivers, limitations in Data Modeling and using CQLSH
• Creating and Managing database users and granting/revoking required privileges to the users.
• Installed and Configured DevCenter for developers
• Installed & configured OpsCenter and Grafana tools to monitor Cassandra cluster.
• Involved in the process of bootstrapping, decommissioning, replacing, repairing and removing nodes.
• Set Cassandra backups using snapshot backups.
• Written Shell Scripts for provisioning data/data flow into the Cassandra Column Family’s
• Troubleshooting the issues occurred in Cassandra Nodes
• Worked with Infrastructure team to get the Cassandra image on OpenStack using ansible scripts and configuring the Cassandra.
• Installed and configured ScyllaDB on Dev Clusters
• Performed Cassandra Stress Test on Cassandracluster and ScyllaDB cluster to benchmark the performances with minimal system requirements.
• Performed 1M writes stress test on Cassandra Cluster using cassandra stress tool.
• Benchmarking the performances of Cassandra on different Disk Types (SSD’s and HDD’s)

Senior Oracle DBA/Cassandra Administrator

Confidential - Overland Park, KS

Responsibilities:

• Installing, configuring, monitoring Apache Cassandra Prod, Dev and Test clusters
• Implementing and maintaining a multi Datacenter Cluster.
• Involved in the process of adding a new Datacenter to existing Cassandra Cluster
• Involved in upgrading the Cassandra test clusters
• Creating required keyspaces for applications in prod, dev, test, and fst clusters.
• Determining and setting up the required replication factors for keyspaces in prod, dev etc. environments in consultations with application teams.
• Creating required tables with appropriate privileges to the users and secondary indexes
• Set Cassandra backups using snapshot backups.
• Used OpsCenter to monitor prod, dev, test, and fst Cassandra clusters.
• Implemented Spark solution to enable real time reports from Cassandra data
• Generated user specific reports based on indexed columns using SPARK
• Performance tuning a Cassandracluster to optimize writes and reads
• Involved in the process of bootstrapping, decommissioning, replacing, repairing and removing nodes.
• BenchmarkedCassandracluster based on the expected traffic for the use case and optimized for low latency
• Troubleshoot read/write latency and timeout issues in CASSANDRA
• Installation, Configuration, Upgrade, patching of Oracle RDBMS
• Implementation of High Availability solutions with Oracle 12c, 11g RAC, 10g RAC, Standby Database (Active Data Guard)
• Replication, extracting data and applying on production database using Golden Gate.
• Implemented unidirectional and Bi-directional replication using Golden Gate 11.1 for High Availability and reporting projects.
• Checking Databases Backup/Restore validity periodically, and Data refreshes from Production to Non-Production environment
• Created Duplicate Databases using RMAN Backups.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Import and Export of Schema using normal export/import and data pump across various stages of the project.
• Work on different versions of Databases with OEM Grid control to maintain the database effectively.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges).
• Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints and Tkprof.
• Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.

Environment: ORACLE 12c/11g/10g, Sun Solaris, UNIX, Golden Gate 11.1, SQL*Plus, Cassandra 2.1, SPARK 1.3.1; GNU/Linux, JDK, Toad

Oracle Database Administrator/Cassandra Administrator

Confidential

Responsibilities:

• Installation, configuration and administration of Apache Cassandra Dev and Test clusters
• Determining and setting up the required replication factors for keyspaces in Dev and Test clusters
• Creating required tables with appropriate privileges to the users.
• Developed and executed scripts for table and keyspace creations
• Involved in the process of Cassandradata modelling and building efficient data structures
• Involved in working on Cassandradatabase to analyze how the data get stored.
• Involved in bootstrapping, removing, replacing, decommissioning the nodes
• Involved in Cassandra Cluster environment administration that includes cluster capacity planning, performance tuning, cluster Monitoring and Troubleshooting
• 24x7 Oracle Production Database Administration including Oracle 11g/10g RAC
• Installation, Configuration and Upgrading of Oracle 11g/10g
• Refresh/Cloning of Database for development and testing purpose.
• Standby Database (Data Guard) setup and configuration.
• Creating databases for Testing and Development servers.
• Support for test and development environments.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Implementing logical backup and recovery using export/ import utility.
• Defining and Setting backup and recovery procedures.
• Backup and Recovery using RMAN
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Involved in Tablespace Management, Schema management, User Creation and granting Users Access to Applications based on their roles.
• Involved in Tablespace Management, Schema management, User Creation and granting Users Access to Applications based on their roles.

Environment: Oracle 11g/10g with RAC, AIX, UNIX, SQL*PLUS, Cassandra 2.1, Linux, JDK

Oracle Database Administrator

Confidential

Responsibilities:

• Administration and troubleshooting 24*7 Production Database Server.
• Responsible for administration and supporting Oracle 11g/10g databases.
• Administration on Oracle 10g/11g Data Guard (Physical & Logical Standby DB)
• Creating new database for Developers and users, roles related to the database.
• Implemented Hot, Cold and Logical backup plans.
• Backup and Recovery using RMAN.
• Index rebuilding, granting roles and privileges, creating partitions and moving tables.
• Troubleshooting Space Management issues.
• Maintaining the database availability and security.
• Maintaining TableSpaces (Adding or resizing Data files).
• Expertise in Oracle Enterprise Manager (OEM).
• Database performance/Statement tuning, Table sizing, and administration.
• Sql Tuning and analyzing statements with Trace Analyzer and Explain plan.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Creating indexes, views, sequences on daily basis in order to enhance the performance of the database.

Environment: Oracle 11g/10g, IBM-AIX, UNIX/Linux, SQL*PLUS

Oracle Consultant

Confidential

Responsibilities:

• Installing & upgrading the OracleDatabase server
• Created and maintained a physical standby for Disaster Recovery (DATA GUARD)
• Creating primary objects (users, tables, views, indexes)
• Handled the Backup and Recovery using RMAN.
• Recovery of Database from Media Failure
• Taking the Cold and Hot backup of the database regularly
• Tablespace creation and space management.
• Recovering tables dropped accidentally using FLASHBACK
• Recovering data files from Block Corruption.
• Monitoring Alert logs to overcome the errors and warnings recorded
• Performed Logical backup using and full, partial export/import and Data Pump.
• Responsible for, database security, recovery planning and installing patches.
• Maintained control files, log file, data files, tablespaces and rollback segments.
• Worked closely with Senior DBAto understand the business and technical requirements.
• Implemented and maintained database security creates and maintains users, roles and assign privileges.
• Created Indexes and Monitored Performance
• Database links were created to access the data from remote databases.

Environment: Oracle 11g/10g, UNIX/LINUX, Windows, SQL*PLUS