SUMMARY

• Over 7 years of experience in Cassandra Database Administration and Oracle database administration. Expertise in tuning, development, analysis, design, all phases of SDLC, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, data modeling, backup and recovery, cloning, auditing, SQL, PL/SQL, NoSQL, Amazon web services, troubleshooting and documentation.
• Excellent Knowledge of Cassandra Architecture, Cassandra data modelling & Monitoring Cassandra using Opscenter.
• Excellent knowledge on CQL (Cassandra Query Language), for retrieving the data present in Cassandra cluster by running queries in CQL.
• Involved in designing various stages of migrating data from RDBMS to Cassandra.
• Gained Hands on experience in analyzing the Cassandra data from flat files using Spark.
• 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 Datastax OpsCenter and Node tool utilities to monitor the cluster.
• Having working knowledge with multiple Data centers set up.
• Experience in efficiently managing backup and restoring data in live Cassandra Cluster.
• Experience in benchmarking Cassandra Cluster using Cassandra stress tool.
• Tested the application and the cluster with different consistency levels to check for the writes and reads performance with respective to Consistency Level.
• Can handle commissioning and decommissioning nodes along with monitoring of Cassandra Cluster.
• Have Knowledge on Apache Spark with Cassandra.
• Creates Linux Virtual Machines using VMware Virtual Center.
• Experience of doing Casandra upgrades to Major & latest versions.
• Designed framework for doing migration from RDBMS to Cassandra
• Experience in porting existing patches from community to Cassandra nodes.
• Involved in doing fine tuning for HEAP, GC, THP settings in Cassandra nodes.
• Expertise in AWS, experience in implementing new AWS EC2 instances and working with EBS and S3 storage.
• Managed Amazon Web Services like EC2, S3 bucket, RDS, EBS, ELB, Auto - Scaling, AMI, IAM through AWS Console and API Integration with Puppet Code
• Experience in Installation, Configuration and Maintenance of Oracle 12c,11g/10gRAC with ASM and single instance database.
• Oracle Database Administration in a variety of environments like Oracle Linux, HP-UX, IBM-AIX, Sun Solaris, RHEL.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).
• Experience with Toad Data modeler and Generate detailed reports on existing database structure
• Build complex entity relationship models - both logical and physical Database Design
• RMAN procedure for backup and recovery and also cloned database using RMAN Duplicate.
• Managed Oracle server in high availability environments using Failover, Clustering, Mirroring, Data guard and Cloning technologies.
• Preparing cluster, configuring and Installation of Cluster ware and Oracle RAC on RHEL.
• Migrated database from 9i, 10g to 11g by using Scripts and applied patches by Opatch utility.
• Experience in database full Backup (hot and cold), Incomplete Backup, Data Pump Export/Import, SQL Backtrack and Restore procedures.
• Experience in Database creation with RMAN jobs and security implementations in Oracle.
• Load Balancing, Startup, Shutdown of Individual instances on RAC database.
• Installed 12c Grid agent on servers and configure 12c OEM Grid control.
• Data Loading using SQL*Loader and DBVERIFY for corruption checking.
• Used parameters to configure, install and manage ASM instance in 10g RAC.
• Back-end programming, database Triggers, stored procedures and functions using PL/SQL.
• Experience in using Oracle Streams for replication of database.
• Job scheduling using CRON, at and batch utility at the OS level and Shell Scripting for automating DBA tasks.
• Good experience in Database Creation, Partitions, Setting-up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage and hands on experience in network management.
• Experience of Auditing, Oracle Security, OEM, SQL Navigator and TOAD.
• Experience in Very Large Multi-Terabyte Database (VLDB) and also performed migrations in this environment.
• Experienced in Oracle Support processes for technical requests through Metalink and other support procedures.
• Documented all Oracle database installations and database operations
• 24*7 Production Database Support to ensure availability, efficiency and recoverability.

TECHNICAL SKILLS

Datastax Enterprise: Cassandra, Open source Cassandra.

Cluster Management Tools: OpsCenter, Stress tool, Sqoop, Node Tool.

Amazon Web Services: EC2, S3, ELB, Auto scaling, Cloud Front, Cloud Formation, RDS, Cloud watch, Cloud trail, IAM, SNS, Redshift.

Server Automation Tools: Chef using AWS OpsWork.

Databases: Oracle …, SQL Server (2005, 2008), MS Access Security Kerberos.

Languages: CQL, SQL, PL/SQL, Shell Scripting, Python.

Operating Systems: Linux (Red Hat, CentOS, Ubuntu), windows.

Version control Tools: Git, GitHub and SVN.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Cassandra DBA

Responsibilities:

• Involved in capacity planning and requirements gathering for multi datacenter Cassandra cluster
• Involved in the process of designing Cassandra Architecture.
• Involved in NoSQL database design, integration and implementation.
• Installed, Configured, Tested Datastax Enterprise Cassandra multi-node cluster which has 4 Datacenters and 5 nodes each.
• Installed and configured Cassandra cluster and CQL on the cluster.
• Involved in the process of data mover for disaster recovery platforms Backup and recovery.
• Involved in database deployments, capacity planning, monitoring multi datacenters, performance tuning, and troubleshooting.
• Knowledge on set up Cassandra wide monitoring scripts and alerting system.
• Knowledge on bootstrapping, removing, replicating the nodes in Cassandra and Solr clusters.
• Experienced in upgrading the existing Cassandra cluster to latest releases.
• Migrated large amount of data from Oracle to Cassandra
• Migrating oracle data model to Cassandra to achieve and reduce the SLA from 10 minutes to 2 seconds and also improve user experience by using kafka and cassandra.
• Knowledge in Apache Spark with Scala
• Performed regular maintenance activities like Patching, User Maintenance, Database Refresh and Disaster Recovery tasks in Oracle as of when required.
• Bulk-loaded the data into Cassandra using sstableloader tool and read the data using sstable2json tool.
• Experienced in provisioning and managing multi-datacenter Cassandra cluster on public cloud environment Amazon Web Services(AWS) - EC2.
• Imported data from various resources to the Cassandra cluster using Java APIs.
• Strong understanding of internal processes of NoSQL approach.
• Optimized the Cassandra cluster by making changes in Cassandra properties and Linux (Red Hat) OS configurations.
• Working closely with Datastax to resolve issues on cluster using ticketing mechanism.
• Configured Performance Tuning and Monitoring for Cassandra Read and Write processes for fast I/O operations and low latency time.
• Performed Stress and Performance testing to benchmark the cluster
• Administered Cassandra cluster using Datastax OpsCenter and monitored CPU usage, memory usage and health of nodes in the cluster.
• Configured accordingly to achieve maximum throughput and execution time based on the benchmarking results.
• Configured, Documented and Demonstrated inter node communication between Cassandra nodes and client using SSL encryption
• Experienced in storing the analyzed results into the Cassandra cluster.
• Used Github version control for tagging the new versions.
• Involved in the Migration of data from one database to another database.
• Knowledge on applying updates and maintenance patches for the existing clusters
• Scheduled repair and cleanup process in production environment
• Upgraded production and all test databases from Oracle 11.2.0.4 to 12.1.0.2.

Environment: Cassandra 2.1, Oracle 11g,12c, DevCenter, Cqlsh, OpsCenter, Node tool, UNIX, Cassandra-stress, Shell Scripting, GitHub, Maven, Solr, Shell Scripts, Sqoop, Spark and Scala, AWS.

Confidential, Rockville, MD

Cassandra Consultant

Responsibilities:

• Involved in the process of designing Cassandra Architecture.
• Migrated 40 TB of data from one datacenter to another datacenter.
• Integrated AD with Cassandra Authorization.
• Designed, Automated the process of installation and configuration of secure DataStax Enterprise Cassandra cluster using puppet.
• Monitored the cluster with Datastax OpsCenter.
• Configured internode communication between Cassandra nodes and client using SSL encryption.
• Developed shell scripts along with setting up of CRON jobs for monitoring and automated data backup on Cassandra cluster.
• Created azure templates to automate server creation and DSE deployments.
• Installed and configured Cassandra cluster and CQL on the cluster.
• Experience in upgrading the existing Cassandra cluster to latest releases.
• Experience in using opscenter to monitor cluster Metrics and enable the services and alerts.
• Experience in Unix SHELL Scripting.
• Performed Stress and Performance testing, benchmark on the cluster.
• Tuned the cluster to achieve maximum throughput and execution time based on the benchmarking results
• Migrated the data from one datacenter to another datacenter.
• Configured, Documented and Demonstrated inter node communication between Cassandra nodes and client using SSL encryption.
• Encrypted the data at rest using Gazzang.
• Enabled Ldap Authentication on opscenter.
• Experience in upgrading DSE and applying patches for the existing clusters.
• Configured authorization to Cassandra cluster using Password Authenticator.
• Scheduled repair and cleanup process in production environment.
• Added and decommissioned the nodes based on requirement.
• Encrypted the passwords in configuration files.
• Added a new datacenter to existing cluster and migrated the data using rebuild process
• Migrated data from Oracle 11g to Cassandra 2.1 database.
• Monitored the data in Oracle and also done repair works.
• Configured and installed Oracle 12C two node RAC cluster on Linux platform and also performed database upgrade from 11g to 12C.

Environment: Cassandra 2.1, Oracle 11g, 12c RAC, DevCenter, Cqlsh, OpsCenter, Node tool, UNIX, Cassandra-stress, Shell Scripting, GitHub, Maven, Solr, Shell Scripts, Sqoop, Spark, SQL, NoSQL, CQL

Confidential, NY

Oracle Database Administrator

Responsibilities:

• Design, Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure / Cluster ware, Oracle 11g two node RAC for the database tier.
• Implemented Backup and Recovery Strategies using RMAN and used Recovery advisor to repair data block corruptions & data dictionary corruptions
• Patching & upgrades on Oracle 11g database (whilst minimizing or eliminating the impact to Live services, i.e. using rolling node patching)
• Cassandra database physical layout design and capacity planning
• Have involved in the process of upgrading, Adding & removing nodes also, have collected production metrics by using SPLUNK tool
• Worked with logical backup using Data pump and Exports/Imports Utility
• Database Load and Transformation Techniques (SQL Loader, External Tables)
• Upgraded production and all test databases from Oracle 9.2.0.8 to 10.2.0.3 to 11.2.0.4 to 12.1.0.2
• Execute the collection of requirements, product comparisons, product research, and architecture
• Performed data migrations using ETL tools.
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Data guard.
• Support Production, QA, DEV, UAT databases.
• Experience in programming with Perl, Unix/Linux shell scripting, Oracle PL/SQL.
• Configured and Monitored of databases using OEM 12c Grid Control
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration ETL tools
• Replication and Extracting data and applying on production using Golden Gate and Shareplex.
• Identify training needs within support organization and proactively create and deliver training sessions to address these requirements.
• Configuration of Oracle Standby Databases (Active Data Guard) for high availability/Disaster Recovery Solution from Production Server to the DR Server
• Experience on Oracle Shareplex for data replication for enterprise data centers including installation, configuration, administration, performance monitoring.
• Creating documentation during project planning, project execution and project maintenance phases.

Environment: Oracle RAC Database 12c, 11g, 10g, SQL, NoSQL, AIX, Solaris11, RE Linux 6, MYSQL, Windows.

Confidential

Oracle Database Administrator

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database and applications issues.
• Installed, configured and monitored multi node Oracle 11g RAC (Failsafe).
• Experience on SQL Server Database Administration
• Installed and configured Data Guard using physical and logical standby for high availability and reporting purpose.
• Data pump Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.
• Performance Monitoring and tuning using STATSPACK, TKPROF, EXPLAIN PLAN, AWR, and ADDM.
• Up gradation of Database from 9i to 10g, 9i to 11g, 10g to 11g and applying patches whenever required.
• Cross platform Migration of databases.
• Configuration, Modeling, Administration and tuning of Shareplex.
• Oracle Streams Replication setup and Configuration.
• Developed scripts for cloning, monitoring, database backup and recovery.
• Experience in Identifying performance bottlenecks on high volume transaction systems.
• Implemented different Partition methodologies to improve performance and manageability.
• Involved in creating Tables, Indexes, Triggers, Sequences, Procedures and Packages.
• Cloned Oracle Databases and Oracle applications for development and testing.
• Management of security, granting and revoking permissions to users/roles as and when required.
• Writing UNIX shell scripts for backup and recovery, Import and export procedure.
• Writing PL/SQL functions, procedures, packages and triggers.
• Partitioned large tables and created indexes to improve the performance.
• Working with QA and Development teams for the regular database support.
• Daily Health Check Up of the Databases and applications
• Monitoring Growth of tables and undertaking necessary steps for re-organization as and when required.

Environment: Oracle 11g RAC/10g RAC (Failsafe), 9i, Data Guard, Golden Gate 11 & 12, Shareplex, SQL Server 2000/2005/2012 UNIX Shell Scripting, SUN SOLARIS 10, AIX 6.1, 5.1 and RHEL 5, 4.

Confidential 

Junior Oracle Admin

Responsibilities:

• Troubleshooting database performance issues involving problem SQL's through SQL Advisor, AWR and Stats Pack.
• Successfully installed and configured oracle RAC, ASM and non-RAC databases on Linux, Windows and VMware.
• Disaster recovery using Standby database, Database cloning, Replication and Data Guard technology
• Implemented Oracle streams for bi-directional schema level replication.
• Monitored and Administered database using Oracle Enterprise Manage r Grid Control.
• Analyzing Database configurations and adjust to meet the performance requirements.
• Creating and altering users, managed roles and profiles.
• Backup strategies and planning using RMAN, O/S and logical backups, setting up periodic backups using Corn job and shell scripts.
• Maintaining data files, tablespaces, rollback segments.
• Golden Gate set up, tuning, administration on Oracle 10g.
• Troubleshooting database and application errors and work with the application team to resolve problems.
• Planning database installation, patches and/or upgrades.
• Administering multiple database instances from Sandbox to PROD (OLTP and OLAP) while keeping configurations consistent as required;
• Communicating regularly with technical, applications and operational staff to ensure database integrity and security.
• Creating DUPLICATE database for development purposes regularly.
• Creating shell scripts to run as cronjobs based on data modification requirements.
• Working with SQL Loader to move legacy data into current environment by conversion.
• Supported through two whole release cycle from Database build to Production release.
• Utilized Materialized Views and Logs to move data from OLTP to OLAP daily.
• Following Oracle Web Conference (OWC) to update the client with the modern technologies, trends, etc.
• 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.

Environment: Oracle 9i/10g, MS SQL Server 2005, Windows 2003, IDERA Diagnostic Manager, MS Reporting Services, SQL LiteSpeed Backup Software, APEX SQLlog, Quest Spotlite, AIX, ZLinux, Windows Server 2003/2008, OEM, PL/SQL, TOAD9.1, RMAN, Informatica Power Center, RAC, ASM, Grid Control, DataGuard, ODI, Streams, SQL Loader, Shell Scripting.