SUMMARY

• Professionally offering over 8 years of IT experience as Database Administrator, focusing on Administration/Installation, patching and up - gradation, Database cloning, migration, Backup, Recovery, Data security, Data monitoring and performance tuning
• Experienced in working on Oracle, and Cassandra databases.
• Having more than 3 years’ experience in Cassandra database (Certified Professional on Apache Cassandra).
• In depth knowledge of architecture, core concepts and creating Cassandra database systems.
• Experience with data modelling best practices for Cassandra or other NoSQL platforms.
• Worked on Both Apache Cassandra and Datastax Enterprise Cassandra.
• Worked on Installation, configuring and monitoring Cassandra Cluster.
• Worked on large clusters with around 200+ nodes on production, including multi-data center and multi-rack Cassandra cluster.
• In-depth knowledge in Cassandra read, writes paths and internal architecture, which includes SSTables, MemTables and Commit log.
• Upgrading Datastax Enterprise Cassandra versions for stability and performance.
• Experience with data migrating from DSE (Datastax) Cassandra to Apache Cassandra.
• Experience on various services in Amazon Web Services (AWS Certified Solutions Architect-Associate).
• Implementing Cassandra on Amazon Web services (AWS) for EC2 Instance.
• Worked on EC2 service in AWS, building one depending on current production on premise configuration.
• Worked on building VPC in AWS, for production and nonproduction, and also AZ zones to define the cluster’s DC level, to minimise the impact in case of unexpected incidents.
• Worked on Jenkins for automation of building new Ec2 server, with predefined AMI's
• Experience in Cloud formation service in AWS, used to create Security group for different environments.
• Experience on migrating data from Cassandra cluster on premises, to AWS cloud one DC’s at time.
• Worked on AWS Bastion host connectivity, where we connect the server using private address, all our production server can only be login through Bastion host.
• Worked on process in AWS for rehydration, where we do patching for existing EC2 which are already running in production.
• Implemented AWS solutions using EC2, S3, RDS, Elastic Load Balancer, and Auto scaling groups, Optimized volumes and EC2 instances.
• Configured S3 versioning and lifecycle policies to and backup files and archive files in Amazon Glacier.
• Managed storage in AWS using Elastic Block Storage, S3, created Volumes and configured Snapshots.
• Worked on SSL certification for both AWS and on premise
• Encryption of data in Cassandra node at Dc's level, and encryption on both client and server encryption, depending on type of encryption.
• Installation and administration of Oracle 12c/11g/10g/9i on OEL, RHEL, UNIX and Sun Solaris in OLTP environment.
• Involved in Installation, Configuration and deployment of Oracle database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM) and experience in adding and removing nodes.
• Experienced in Performance Tuning, alert log monitoring, and solving problems related to storage, indexing, SQL queries, DML operations, and other anomalies or errors.
• Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN.
• Database and file systems space monitoring. Migrated file systems to ASM (Automatic Storage Management).
• Hands on experience of database Backups and Recovery strategies using RMAN, Export Import Utility (Classical & Data Pump) and Transportable Table spaces.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Up-gradation of databases by applying patches, patch sets and critical patch updates.
• Experience in using various administration tools like TOAD, Putty, and SQL Developer.
• Experience in developing UNIX/Perl Shell Scripts, UNIX system administration.
• Worked on Oracle Exadata including Patching, and upgrading Grid Infrastructure, and Database homes on Exadata machines.
• 24x7 on-call production database support and maintenance including remote database support.
• Have experience in Oracle Support (raising SR) processes for technical requests.
• Experience in creating Documentation of Oracle database operations and capacity planning.
• Ability to adapt to new technologies and situations quickly, hardworking, sincere and leadership.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX, Linux

RDBMS: Oracle 12C/11gRAC/10gRAC/ with RAC and ASM

NOSQL: Cassandra(Dse and Open source ), DSE 5.1.11(till date), Cassandra 3.11.2(till date)

Programming Languages: SQL, PLSQL, Unix Shell Scripting

Tools: SQL*Loader, Data pump Utilities, EXP/IMP,TOADOracle SQL Developer, SQL Navigator

DB Utilities: RMAN, OEM Grid Control 11g/10g, Data Guard 11g/10g

Tuning tools: TKPROF, ADDM, AWR, EXPLAIN PLAN, STATSPACK

Other: Putty, MS Access, MS Office, Excel, Visual Studio, SSL encryption, Data dog monitoring.

AWS utilities: EC2, IAM, Security groups, VPC, cloud formation, cloudwatch, AMI, RDS, DYNAMODB, POSTGRE.

PROFESSIONAL EXPERIENCE

Confidential, Piscataway, NJ

Oracle/ Cassandra/AWS DBA

Responsibilities:

• Installed and configured datastax enterprise Cassandra and Apache Cassandra on multi-datacenter and multi-rack Cassandra cluster (3 DC's with over 270 nodes in clusters).
• Installed Monitoring using OpsCenter (Datastax for Dse nodes) and Datadog for Apache Cassandra.
• Experience in implementing multi-datacenter cluster.
• Worked on creating Keyspace, and tables in Cassandra, which includes in Replication factor, DC's specification, and topology strategy.
• Define users and enable data distribution to the right user, in appropriate format and in a timely manner.
• Designing data models in Cassandra and working with Cassandra Query Language (CQL).
• Worked on Adding nodes to cluster and removing nodes while monitoring cluster.
• Worked on fine tuning for HEAP, and Garbage Collector (GC) setting on nodes.
• Automated Cassandra Builds/installation/monitoring etc.
• Worked on Patches and upgrading to latest versions.
• Worked on performances tuning like to overcome the tombstones, avoid Corruptions and data inconsistency, by scheduling weekly repairs (automated).
• Worked using varies tools like sstableloader for loading data, sstable2json and json2sstable etc.
• Used nodetool utilities for performances tuning like online scrub and offline scrub, and repair with varies options.
• Worked on compaction process for better performance and also to reduce tombstones.
• Also worked on upgrading OpsCenter versions with latest versions.
• Good knowledge on Spark SQL, Spark Streaming and Scala.
• Worked on snapshot for backup and recovery.
• Worked on AWS, to migrate data from on premise to AWS for Cassandra database.
• Worked on creating EC2 instance on AWS, depending on current production on premise configuration.
• Rebuild new DC's in AWS with Ec2 instance, with data replicated from existing cluster's DC's.
• Using cloud formation templet in AWS, to create new security group, defining the port for which use it is needed.
• Worked on creating security groups that allow the connection between different users(like application connection, spark)
• Worked on SSL certification for both AWS and on premise.
• Encryption of data in Cassandra node at Dc's level, and encryption on both client and server encryption.
• Implemented AWS solutions using EC2, S3, RDS, Elastic Load Balancer, and Auto scaling groups, Optimized volumes and EC2 instances.
• Configured S3 versioning and lifecycle policies to and backup files and archive files in Amazon Glacier.
• Managed storage in AWS using Elastic Block Storage, S3, created Volumes and configured Snapshots.
• Create and manage Elastic Block Storage (EBS) volumes and S3 buckets.
• Worked on process in AWS for rehydration, where we do patching for existing EC2 which are already running in production.
• In this process we, do patching for existing instance with no impact, here we take the EBS volumes out of EC2 and spin-up new EC2 and attach the new instance to EBS voulmes.
• Worked on AWS Bastion host connectivity, where we connect the server using private address, all our production server can only be login through Bastion host.
• Worked on creating new Opscenter, and configuring in bastion host.
• Worked on Jenkins for automation of building new Ec2 server, with predefined AMI's.
• Hands on experiences in installing and configuring open source or third party tool for monitoring the Cassandra like Data dog, Kibana.
• Installed, configured and maintained Oracle 12c (12.1.0.2) container and pluggable databases and 11g standalone/RAC databases
• Created and administered ASM instances. Managed ASM disks and disk groups like adding additional luns for ASM storage, adding disks to ASM disk groups.
• Administration of a 4 node RAC, configuring and monitoring daily BACKUPs, troubleshooting errors, to improve performance.
• Applied CPU security patches and PSU in both RAC and standalone systems in ASM environment.
• Using TKPROF, AWR, ADDM, STATSPACK, and EXPLAINPLAN for monitoring database performance.
• Experience in taking daily/weekly hot backups and cold backups using RMAN.
• Restored and recovered the database up to point in time from backups using RMAN.
• Troubleshooting EXPDP/IMPDP errors in a RAC environment, configuring storage accordingly.
• Setting up and configuring Oracle Golden Gate replication on both source and target for zero-downtime migrations
• Creating and refreshing materialized views, views, synonyms, and indexes.
• Used shareplex for replicating the data on to other Datacenter for the copy of the data.
• Rebuilding of Indexes for better performance and generating AWR reports and analyzing them for better performance of databases.
• Researching errors/issues/bugs which were impacting the performance of the database and recommended permanent solution without losing the performance.
• Good experience in managing the databases using the OEM grid control like Scheduling Backups, Performance Monitoring, alerts setting, generating reports in seconds, email notifications etc.
• Table Partitioning, Creating Locally managed Table spaces.
• 24x7 production support for several mission critical systems which utilize multiple Cassandra and Oracle databases.
• Preparing cluster, configuring and Installation of Cluster ware and Oracle RAC.
• Applied High priority, security patches downloaded from Metalink.
• Cloning the databases for development and testing purposes.
• Managing, Troubleshooting and resolving oracle database, RAC and applications issues.
• Granted permissions to end users according to their level of access to database objects.
• Worked with Oracle support to resolve database critical issues.

Environment: Cassandra DSE 5.0.14, DSE 5.1.11, Linux 5.2/6.4, AIX, HP-Unix 11i 11.3, Cassandra 3.11.2, Apache, Cassandra 3.0.14, Devcenter, Opscenter 6.0.4.Oracle Enterprise Linux 5.2/6.4, AIX, HP-Unix 11i 11.31, Oracle 12c/11g, RAC, ASM, RMAN, OEM, Data Pump, OEM, SQL*Loader, Toad, Putty and Shareplex, EC2, IAM, Security groups, VPC, cloud formation, cloud watch.

Confidential, Columbus, OH

Sr Oracle/Cassandra DBA

Responsibilities:

• Responsible for the build out, day-to-day managing and supporting Cassandra clusters.
• Experience in building Cassandra cluster.
• Adding and removing nodes from the cluster.
• Monitor Cassandra system logs, opscenter, and opscenter-agent logs for errors using node tool.
• Knowledge on Cassandra systems backup and recovery, security, maintenance and tuning - both database and server.
• Used Jmeter to measure performance on Cassandra nodes.
• Installed, configured and maintained Oracle 12c (12.1.0.2) container and pluggable databases and 11g standalone/RAC databases.
• Created and administered ASM instances. Managed ASM disks and disk groups like adding additional luns for ASM storage, adding disks to ASM disk groups.
• Administration of a 4 node RAC, configuring and monitoring daily BACKUPs, troubleshooting errors, to improve performance.
• Applied CPU security patches and PSU in both RAC and standalone systems in ASM environment.
• Using TKPROF, AWR, ADDM, STATSPACK, and EXPLAINPLAN for monitoring database performance.
• Experience in taking daily/weekly hot backups and cold backups using RMAN.
• Restored and recovered the database up to point in time from backups using RMAN.
• Troubleshooting EXPDP/IMPDP errors in a RAC environment, configuring storage accordingly.
• Setting up and configuring Oracle Golden Gate replication on both source and target for zero-downtime migrations.
• Creating and refreshing materialized views, views, synonyms, and indexes.
• Working on 11G Data Guard.
• Rebuilding of Indexes for better performance and generating AWR reports and analysing them for better performance of databases.
• Researching errors/issues/bugs which were impacting the performance of the database and recommended permanent solution without losing the performance.
• Good experience in managing the databases using the OEM grid control like Scheduling Backups, Performance Monitoring, alerts setting, generating reports in seconds, email notifications etc.
• Table Partitioning, Creating Locally managed Table spaces.
• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Preparing cluster, configuring and Installation of Clusterware and Oracle RAC.
• Applied High priority, security patches downloaded from Metalink.
• Cloning the databases for development and testing purposes.
• Managing, Troubleshooting and resolving oracle database, RAC and applications issues.
• Granted permissions to end users according to their level of access to database objects.
• Worked with Oracle support to resolve database critical issues.

Environment: Oracle Enterprise Linux 5.2/6.4, AIX, HP-Unix 11i 11.31, Oracle 12c/11gR2/10gR2, RAC, ASM, RMAN, Data Guard 11g, OEM, Data Pump, OEM, SQL*Loader, Toad, Putty and SQL developer, Golden gate

Confidential, Gaithersburg, MD

Sr Oracle DBA

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle 9i, 10g, 11g databases.
• Administration of a 4 node RAC, configuring and monitoring daily BACKUPs, troubleshooting errors, to improve performance.
• Upgrade and Migration of Databases from 11.2.0.1 to 11.2.0.3 and applying patches as per requirement.
• Good experience in managing the databases using the OEM grid control like Scheduling Backups, Performance Monitoring, alerts setting, generating reports in seconds, email notifications, Black out instances during maintenance/down times etc.
• Database level - Handling Performance Tuning Activity using OEM (AWR/ADDM), Database space management, security patches.
• Installation, configuration and creating new test databases for production and development databases.
• Installed Oracle 11g using OUI on 4 nodes RAC environment with ASM and OCR services.
• Performed tuning and optimization with web services base applications.
• Managing, Troubleshooting and resolving oracle database, RAC and applications issues.
• Troubleshooting EXPDP/IMPDP errors in a RAC environment, configuring storage accordingly.
• Cloning the databases for development and testing purposes.
• Worked on import/export, export data pump/import data pump and SQL- loader.
• Developed and deployed scripts for maintenance of Cluster and standalone database servers.
• Worked on the 11gr2 cluster and databases recovery.
• Experience in taking daily/weekly hot backups and cold backups using RMAN.
• Implemented ASM on RAC databases. Managing disks and disk groups with ASM.
• Upgraded the data’s from Existing Oracle 9i to Oracle 10g to 11g
• Performing 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 etc.
• Assisting the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
• Oracle Database Performance tuning and SQL Tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF etc.
• Restored and recovered the database up to point in time from backups using RMAN.
• Refresh the test and development databases from the source production databases on a regular basis using export/import utility
• Configured database entries and Monitoring of all the databases using Oracle Enterprise Manager (OEM) 10g/11g grid control and TOAD.
• Focused on separate Partitions like data loads, index creation and rebuilding, backup/recovery.
• Configured ASM and suggested feasible workarounds for ASM Metadata corruption and Configured user log on load balancing and failover on RAC database.
• Preparing cluster, configuring and Installation of Clusterware and Oracle RAC.
• Implemented database auditing, data security and Remediate high-risk violation in production environment and Gathering schema stats and monitoring the index usage.
• Creating and dropping of users, granting and revoking rights as and when required.
• Good experience in SQL, PL/SQL, Shell Scripting, SQL profiles and SQL baselines.
• Experience in parameters tuning and setting them to best optimal value for better performance.
• Researching errors/issues/bugs which were impacting the performance of the database and recommended permanent solution without losing the performance.
• Applied High priority, security patches downloaded from Metalink.

Environment: Oracle 9i/11gR2/10gR2 HP-Unix 11i 11.31, Oracle Enterprise Linux 5.2/6.4, AIX, RAC, ASM, RMAN, OEM, Windows 2008R2 Servers, Data Pump, OEM, SQL*Loader, Toad, Putty and SQL developer, Ignite

Confidential, Hanover, MD

Oracle Database Consultant

Responsibilities:

• Designed and Configured Oracle Database Real Application Cluster (RAC) with 3-nodes clusters
• Worked on Automatic Storage Management (ASM) for managing data in SAN
• Setup Client side and Server Side Load balancing in RAC environment
• Upgrading Oracle software to latest patch set using silent installation mode
• Applying PSU and bug fix patch for 11GR2 GRID Infrastructure
• Converted/migrated few databases from single instance to two node RAC database
• Performed backups and recoveries using RMAN/conventional hot & cold backups using TSM.
• Support/Fault finding & resolution to the database problems on RAC/Non RAC/Clustered
• Implementing Data Guard with physical Standby server for high availability
• Migrate, upgrade and supported 3 node 11R2 RAC databases
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like VMSTAT, ISOSTAT and TOP
• Monitored databases with GRID Control, and extensively used AWR, ADDM reports to ensure overall health of the databases with focus on 100% uptime
• Extensively used export/import & Data Pump utilities to refresh the databases from Production to Test environments
• Used Stored Outlines, SQL Profiling, SQL Plan Baselines, SQL Trace, ADDM, AWR, ASH and Explain Plan tools to diagnose performance issues
• Performing Logical backup/recovery of schema with Data Pump
• Maintaining active data guard on physical standby systems to ensure high availability
• Using OEM (Oracle Enterprise Manager) for Database monitoring and maintenance activities which include checking space management & performance troubleshooting
• Tuning the scripts & queries for better performance by picking the best available plan, SQL profiling and Hints
• Carried out monthly /weekly maintenance of database such as Defragmentation of Table spaces, Rearrangement of segments in different Disks based on disk I/O
• Monitoring alert logs, trace files, disk space, etc. periodically through scripts and automating reports through mails

Environment: Oracle 9i, 10g, 11gR2, RHEL 4u8, 5U8, OEM, Streams, Dataguard, Netapp NFS, Sql loader, RMAN, DataPump

Confidential, Reno, NV

Oracle DBA

Responsibilities:

• Performed DATABASE CLONING to setup test and development database.
• Involved in performing migration from Oracle 9i, 10g to Oracle 10g Release2 RAC database
• Installed Oracle 10g RAC software with ASM & OCFS2 file system.
• Running ADDM reports to analyze top events and SQL statements and follow the recommendations to tune SQL statements.
• Up gradation and migration from Oracle 9.2.0.8 databases to Oracle10.2.0.3.
• Performed maintenance tasks on existing test and production environments that included modifying database sizes and migrating changes through various environments.
• Dealing with Performance issues of database objects, implementing CAPACITY PLANNING to ensure growth of the database.
• Installed and Implemented BACKUP & RECOVERY procedures. Implement HOT, COLD and Logical backup plans.
• Constantly monitoring the performance of the databases and viewing Alert log files & Trace files.
• Managing various database targets using Grid control for efficient monitoring.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Implementing automated backups with RMAN using crontab.

Environment: Oracle 11.1.0.7/10.2.0.3/9.2.0.8 , PL/SQL, RMAN, Data pump, SQL*Loader, Sun Solaris, Red Hat Linux, Windows.

Confidential

Jr. Oracle DBA

Responsibilities:

• Installed and configured oracle 9i/10g databases. Database upgrade from oracle 9.2.0.8 to 10.2.0.1 using DBUA
• Worked with a team of IT developers and peer-peer meetings in the Initial Database Design/DataModeling/Data approval. Involved in PL/SQL Coding, Scripting.
• Responsible for installing, upgrading and configuring the Oracle server.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the Performance.
• Configured scripts to monitor activity with database.
• Importing/Exporting data from/to different databases using utilities like SQL*Loader
• Responsible for optimizing the queries and application tuning.
• Used TOAD for faster application design and developments.
• Implement Hot, Cold and Logical backup plans using RMAN and Data pump tools.
• Creating tables, indexes, views and synonyms depending upon the need
• Involved in Designing backup and recovery procedures for OLTP systems
• Testing PL/SQL procedures against the test cases. Involved in creating use cases and test cases
• Strong and extensive use of DDL and DML tools/ Maintained database schemas and dictionaries.
• Optimized INIT.ORA parameters like DB block size, block buffers, shared pool.
• Netca Configuration for Clients Connection.
• Involved in Performance Tuning of SQL Queries
• Worked as Support Database Administrator. Responsibilities include creation & maintenance of table spaces, data files.

Environment: MS Server 2003R2, Red hat Linux 4, VMware, Oracle 9i/10g, RHEL 4, SQL, PL/SQL, SQL Loader,, RMAN, DBCA, DBUA, TKPROF, SQL Trace, SQL, Shell Scripting.