Rajiv Kumar

860-***-****

adgq9k@r.postjobfree.com

SUMMARY

Over 18 years of IT experience as Senior Oracle Database Administration Ver. 12c/11g/10g/9i on a variety of UNIX (Solaris, HP-UX, AIX), Windows 2000/2003/2012

Having over 3 years of DBA experience in Datastax Cassandra Enterprise edition installation, configuration, backup configuration, upgrade, node tool commands, bootstrapping, performance tuning,decommissioning,migration .

Installing oracle server and client software, creating, upgrading and patching databases in UNIX (Solaris, AIX), Linux and Windows environments. Configuring and troubleshooting Oracle clients for client server connectivity.

Refreshing the Production over the Dev., UAT and also keeping the Test Instances in sync with other instances.

Production database fixes.

Designing and Architecture of Databases.

Used Oracle streams for Data replication

Disaster Recovery & Business Continuity Plans: Conducting business Impact Analysis, Identify controls,, Develop recovery strategy, plan testing, training and user awareness, as well as plan review and maintenance for development of business continuity and disaster recovery plans (BCP / DRP).

Working with the Development team to fix the problems in Applications. Performance Tuning of database which includes sql optimization, Oracle INIT.ORA, Oracle SGA, I/O balancing and memory.

Planning, scheduling and taking Oracle backups using RMAN .

Proficiency in SQL and PL/SQL programming. Includes, creating database objects like creating tables, views, indexes, constraints, sequences, functions, procedures, packages, triggers, PL/SQL blocks, partitioned tables, etc.

Extensive Unix Shell scripting in csh, ksh.

Expert in packages like Oracle Enterprise Manager, Oracle Stream, Control-M, Autosys

Skilled in Oracle Server Installations / Upgrades, Space Management, RAC/10g RAC11g, Oracle Data Guard, Backup & Recovery, Replication, Capacity Planning, Disaster Recovery, Database Performance Tuning, Memory Tuning, Patching, Security Administration, Oracle Advanced Replication, Oracle Replication Manager, Oracle Standby Server, Distributed Databases for Oracle 8i/9i/10G/11g Databases, index and cluster partitioning.

Technical Skills

Database: Cassandra 4/5/6. Mongodb,Oracle 12c/11g/10g/9i

OS: Aix,Sun Solaris,Linux, Windows

DB Tools : Data dog,New Raleic,Chef,Cloudformation,Opscenter,OEM, RMAN, Data Pump, Export/Import, SQL Loader,

Data Guard, DB Artisan Toad, SQL Navigator, Oracle stream, Veritas Cluster, Sql Developer

Languages: SQL*Plus, PL/SQL, Unix Shell Scripting, csh, ksh, bash

Professional Experience

Starbucks,Seattle,WA Sept 2019 To Present

Role : Database Platform Engineer

Responsibilities:

Build multiple Pipline for Cassandra cluster using Ansible and Jenkins.

Installations, configurations and monitoring DataStax Enterprise Cassandra cluster through Opscenter

Setup DSE opscenter 6.7 for backup and recovery

Setup TDE on cassandra database

Involved in Cassandra database upgrade from 5.0.14. to 6.0.9

Involved in Cassandra Datacenter Migrate from on Azure

Supporting multiple Cassandra application

Responsible for technology design, integration, problem analysis, data migration to Cassandra NoSQL

Build new Opscenter 6.7 for QA/Prod and configure alert setup

Data structure design, Data modeling in Cassandra

Work with security team ISPS Prisma review and fix open azure issue

Cluster management like add/bootstrap nodes, remove/replace node to clusters

Handled commissioning and decommissioning nodes along with monitoring of Cassandra cluster.

Migrate Cassandra Snithch Topologies

Refreshing the Production over the Dev, UAT and also keeping the Test Instances in sync with other instances.

.

Environment: Linux Shell scripting,Asible,Azure, Cassandra DSE-Spark Teraform,Jenkins

Disney,Seattle,WA Jan 2018 To July 2019

Role : Cassandra Data Engineer

Responsibilities:

Good experience in Designing, Planning, Administering, Installation, Configuring, Troubleshooting, Performance monitoring of Cassandra Cluster.

Involved in Cassandra database upgrade from 4.8.11. to 5.0.14

Installations, configurations and monitoring DataStax Enterprise Cassandra cluster through Opscenter

Involved in Cassandra database upgrade from 5.0.14. to 5.1.10

Involved in Cassandra Datacenter Migrate from on perm to aws

Supporting multiple Cassandra application

Responsible for technology design, integration, problem analysis, data migration to Cassandra NoSQL

Involved in Cassandra database upgrade from 5.0.14. to 6.0.7

Build new Opscenter 6.5.4 for QA/Prod and configure alert setup

Data structure design, Data modeling in Cassandra

Involved in Opscenter upgrade from 5.1 to 6.1.11

Setup/confrigure Vormetric encryption for cassandra/Mongodb node

Responsible for administration, maintenance, Performance analysis, and Capacity planning for Mongodb/Cassandra clusters.

Work with security team ISPS redlock review and fix open AWS issue

Hands-on on setting up DSE-Spark and DSE-Solr clusters

Managing Cassandra clusters using Datastax opscenter

Cluster management like add/bootstrap nodes, remove/replace node to clusters

Handled commissioning and decommissioning nodes along with monitoring of Cassandra cluster.

Migrate Cassandra Snithch Topologies

Refreshing the Production over the Dev, UAT and also keeping the Test Instances in sync with other instances.

Knowledge of Cassandra systems backup and recovery.

Good knowledge in Cassandra cluster topology and virtual nodes

Knowledge of Cassandra security, maintenance and tuning both database and server

Having knowledge on Datacenter, Cassandra Rings and Nodes

Proficient in compaction strategies in Cassandra system.

Hands on experience on Cassandra architecture with better understanding and write processes including Mem-table, SStable and Commit log.

Excellent knowledge on CQL (Cassandra query language), for retrieving the data present in Cassandra cluster by running queries in CQL Implementer Java driver to connect, load and retrieve data from Cassandra database

.

Environment: Unix Shell scripting,Chef,CloudFormation, Cassandra DSE-Spark and DSE-Solr,Mongo db

Usps,Raleigh,Nc Jan 2016 To Dec 2017

Role : Cassandra Dba

Responsibilities:

Involved in Cassandra database upgrade from 4.8. to 5.0.

Supporting multiple Cassandra application

Data structure design, Data modeling in Cassandra.

Installations, configurations and monitoring DataStax Enterprise cluster and/or open source Cassandra cluster

Hands-on on setting up DSE-Spark and DSE-Solr clusters

Cluster management like add/bootstrap nodes, remove/replace node to clusters

Responsible for technology design, integration, problem analysis, data migration to Cassandra NoSQL

Involves designing, capacity arrangement, cluster setup, performance fine-tuning, monitoring, structure planning, scaling Cassandra administration.

Monitoring Cassandra cluster for resource utilization. Refreshing the Production over the Dev., UAT and also keeping the Test Instances in sync with other instances.

Knowledge of Cassandra systems backup and recovery.

Good knowledge in Cassandra cluster topology and virtual nodes

Managing Cassandra clusters using Datastax opscenter

Knowledge of Cassandra security, maintenance and tuning both database and server

Having knowledge on Datacentre, Cassandra Rings and Nodes

Experienced in using Kafka for streaming of data.

Proficient in compaction strategies in Cassandra system.

Handled commissioning and decommissioning nodes along with monitoring of Cassandra cluster.

Implementer Java driver to connect, load and retrieve data from Cassandra database.

Environment: Unix Shell scripting,, Cassandra DSE-Spark and DSE-Solr,

Fanniemae, Reston,VA Dec 2014 To Dec 2015

Role: Sr Oracle DBA

RESPONSIBILITIES:

●Involved in DBA support to Production server and interacting with Application team and meeting the timelines of various projects.

●Migration from Oracle11.2.0.4 databases to Oracle 12c Linux/Aix/Solaris

●Managing RAC database on 12c

●Upgrade 11g Grid control agent

●Database JOB to be controlled from Autosys

●Supporting to many application release

●Working with the Development team to fix the database performance related issue.

●Provided high availability/cost effective solution and minimized the business impact by building the Data Guard that ensured 24x7 database availability.

●Downsizing and defragmenting the Very Large Databases by Data Pump and export / import, Cloning them using RMAN Duplicate features and then upgrading /migration them to Oracle 11g.

●Writing Shell scripts for Alerts for ORA error backup and recovery, Import and export procedure.

●Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

●Writing scripts for backup and recovery, Import and export procedure.

●Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc.

Environment: Oracle 12c RAC,Oracle 11g\10g\9i,REDHAT LINUX Sun solaris,IBM AIX,RMAN,OEM (Grid Control),Explain Plan, AWR, ADDM, Data Pump,Unix Shell scripting,Datagurd,Autosys,GoldenGate,Toad

Fidelity, Raleigh, NC April 2014 To Dec 2014

Role :Sr Oracle Dba\Cassandra Dba

Responsibilities:

Monitor Availability And performance of production and development Cassandra clusters

Install new database releases and related software tools to evaluate in CI environment, eventually promote to production

Apply software patches and upgrades to server software for Cassandra database to stay in compliance with security standards and performance

Perform and automate daily database maintenance, user assistance and troubleshooting

Sound knowledge about hardware (CPU, memory, disk, network, Firewalls etc)

Continually improve operational processes and procedures

Analyze and resolve complex technical problems, including performance tuning, and debugging

Monitor database backups and maintain automated disaster recovery procedures

Involved in 24*7 DBA support to Production and interacting with Onsite/offshore team and meeting the timelines of various projects in Exadata Database

UNIX shell scripting in csh, ksh to be controlled from Crontab.

Writing scripts for backup and recovery, Import and export procedure.

Partitioning tables by determining the suitable methodology to improve performance and manageability.

Unix Shell scripting in ksh for database refresh automating.

Troubleshooting Golden gate issues for Exadata database replication server

Environment: Oracle 12c RAC,Oracle 11g\10g\9i,REDHAT LINUX Sun solaris,IBM AIX,RMAN,OEM (Grid Control),Explain Plan, AWR, ADDM, Data Pump,Unix Shell scripting,Datagurd,Autosys,GoldenGate,Toad,Cassandra

Tiaa Cref,Charlotte,NC July 2012 to April 2014

Role: Sr Oracle DBA

RESPONSIBILITIES:

Involved in Database Engineering Team and interacting with Regional team and meeting the timelines of various projects.

Migration Database from Oracle 11.2.0.1.databases to Oracle 11.2.0.3.6/Linux

Involved in database consolidation project

Involved in oracle Exadata database machine performance testing and provide result to Management

Applying PSU/CPU patches Server side for Oracle Home and CRS Home.

Involved in I/O Calibration testing during San migration.

Upgrade 12c(12.1.0.3) Grid control agent

Involved in applying Oracle Database Compliance/Audit policy to database using OEM 12C.

Database JOB to be controlled from Autosys

Involved in the QMW.QUID, DR activity

Provided high availability/cost effective solution and minimized the business impact by building the Data Guard that ensured 24x7 database availability.

Migration CRS from Oracle 10.2.0.4.databases to Oracle 10.2.0.5

Used Oracle Streams to Capture Messages at a Database, Stage Messages in a Queue, Propagate Messages from One Queue to Another.

Installing and configuring Backup/ Recovery Manager (RMAN).

UNIX shell scripting in csh, ksh to be controlled from Crontab.

Storage Management Managing Space, Tablespace, Segments and Extents, Rollback Segments & Data Dictionary.

Deciding the naming conventions of data file, redo log files, tablespaces, and segments.

Writing scripts for backup and recovery, Import and export procedure.

Unix Shell scripting in ksh for backup automating.

Environment: Oracle RAC,Oracle 11g\10g,REDHAT LINUX, Sun solaris,IBM AIX,RMAN,OEM (Grid Control),Explain Plan, AWR, ADDM, Data Pump,Unix Shell scripting,Datagurd,Autosys,GoldenGate,dbartisan,Oracle Stream

Credit Suisse, Raleigh,NC Nov 2008 to July 2012

Role: Sr Oracle DBA

RESPONSIBILITIES:

Involved in 24*7 Remote / Onsite DBA support to Production server and interacting with Regional team and meeting the timelines of various projects.

Migration from Oracle10.2.0.5.databases to Oracle 11.2.0.2/Linux.

Managing veritas Cluster for HA

Upgrade 10g Grid control agent

Database JOB to be controlled from Control M.

Involved in Fed white paper test

Cloning databases using RMAN

Involved in the QMW.QUID, DR activity

Provided high availability/cost effective solution and minimized the business impact by building the Data Guard that ensured 24x7 database availability.

Used Oracle Streams to Capture Messages at a Database, Stage Messages in a Queue, Propagate Messages from One Queue to Another.

Installing and configuring Backup/ Recovery Manager (RMAN).

Downsizing and defragmenting the Very Large Databases by Data Pump and export / import, Cloning them using RMAN Duplicate features and then upgrading /migration them to Oracle 10g.

Writing Shell scripts for Alerts for ORA error backup and recovery, Import and export procedure.

Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development team. Extensive familiarity with Tuning Tools like Oracle Enterprise Manager’s (OEM’s), Oracle Grid, SQL analyzer, top session, top SQL, Performance Manager, etc., Statspack, AWR report, Db Artisan. For SQL tuning using “Explain plan”, SQL_TRACE”, Optimizer modes, using Optimizer hints, Gathering statistics etc.

Create database maintenance plans, including updating statistics, reindexing, structure modifications, capacity

plans, and index analysis.

Storage Management Managing Space, Tablespace, Segments and Extents, Rollback Segments & Data Dictionary.

Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Deciding the naming conventions of data file, redo log files, tablespaces, and segments.

Writing scripts for backup and recovery, Import and export procedure.

Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc.

Applying patches both Server side and Client side.

Environment:QMW.QUID, DR activity,Oracle RAC,Oracle 11g\10g\9i,REDHAT LINUX Sun solaris,IBM AIX,RMAN,OEM (Grid Control),Explain Plan, AWR, ADDM, Data Pump,Unix Shell scripting,Datagurd,Contrrol M,Oracle Stream,Sql

PFIZER, Groton, CT May 2008 to Nov 2008

Role: Sr Oracle DBA

RESPONSIBILITIES:

Managing 10gRAC with ASM on Sun/Linux.

Managing 10g Grid control

Cloning databases using RMAN.

Installing and configuring Backup/ Recovery Manager (RMAN).

Data Replication,Event Management and Notification

Applying patches both Server side and Client side.

Data Warehouse Loading,Data Protection.

Managing Veritas Cluster for HA

Expertise in interpreting EXPLAIN PLAN.

Refreshing Test database from production schema

Create database maintenance plans, including updating statistics, reindexing, structure modifications, capacity plans, and index analysis.

Security User Management, Privileges, Roles, Auditing, Profiling, Authentication..

Deciding the naming conventions of datafile, redo log files, tablespaces, and segments.

Writing scripts for backup and recovery, Import and export procedure.

Applying patches both Server side and Client side.

Setting up new environments (Development, Production, and UAT).

Environment: Oracle 10g\9i HP-UX, REDHAT LINUX, SUN SOLARIS, ASM,OEM (Grid Control), RMAN, Explain Plan, Export/Import, SQL developer,SOX policy,veritas cluster,Materialized views

AMDOCS, Champaign, IL Nov 2007 to Apr 2008

Role: Sr Oracle DBA

Responsibilities:

Installation, Upgrade and Configuration of Oracle ( 9i, 10g).

Migration from Oracle10.2.0.1.databases to Oracle10.2.0.3.

Installed and created 10g databases and 10g OEM.

Refresh schema using Export/Import and Data Pump. Creating the database, tablespaces, tables, indexes, settings privileges, and user logins

Installation, maintenance and tuning 10gRAC on Linux.

Installing and configuring Backup/ Recovery Manager (RMAN).

Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.

Cloning databases using scripts as well as RMAN.

Data Replication through Quest Shareplex

Involved in Creating / Renaming the database and implementing SOX policy

Security User Management, Privileges, Role, Auditing, Profiling, Authentication.

Extensive Performance Tuning, Memory (SGA) Tuning, etc.

UNIX shell scripting in csh, ksh to be controlled from Crontab.

Create database maintenance plans, including updating statistics, reindexing, structure modifications, capacity plans, and index analysis.

Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.

Deciding the naming conventions of datafile, redo log files, tablespaces, and segments.

Applying patches both Server side and Client side.

Setting up new environments (Development, Production ).

Environment: Oracle 10g\9i HP-UX, REDHAT LINUX, SUN SOLARIS, ASM,OEM (Grid Control), RMAN, Explain Plan, Export/Import, SQL developer,veritas cluster,Table Partitioning,Materialized views,,Hot/cold backup

SUNGUARD, Wayne PA May 2005 to Nov 2007

Role: Sr Oracle DBA

RESPONSIBILITIES:

Installation, setup and configuration of logical and physical Standby Database using Data Guard.

Installation, maintenance and tuning 10gRAC on Linux

Data Warehouse Loading,Data Protection .

Unix Shell scripting in csh, ksh for automating startup/shutdown of databases.

Setting up and Auditing RMAN Hot and Cold Backups, Exports.

Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations. Configuring scripts for backups (hot, cold and incremental).

Database migrating Oracle 9.2.0.8 to 10.2.0.3.

Involved in designing of disaster recovery using Data Guard 10G, High Availability using Veritas.

Data Modeling, Database Design and Creation

Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Plan and Schedule the Online/Offline Backups.

Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.

Refresh schema using Export/Import. Creating the database, tablespaces, tables, indexes, settings privileges, and user logins.

Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).

Database Refreshing / Replication from production to testing using hot backup.

Table Partitioning, creating Index Organized tables, Creating Locally managed Tablespaces.

Working with Blobs and Clobs, Materialized views with Query rewrite, Bitmapped Indexes, etc.

Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration.

Managing Veritas Cluster for HA, I2 Implementation.

Provide primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.

Environment: Oracle 10g\9i HP-UX, REDHAT LINUX, SUN SOLARIS, RMAN, Explain Plan,Export/Import, SQL developer,veritas cluster,Table Partitioning,Materialized views,,Hot/cold backup

CITIBANK, Tampa FL _ June 2004 to May 2005

Role: Sr Oracle DBA

RESPONSIBILITIES:

Involved in 24*7 Remote DBA support to Production and interacting with Onsite/offshore team and meeting the timelines of various projects.

Creation and setup of DEV/TEST/QA environment from Production database.

Installation, Upgrade and Configuration of Oracle 8i, 9i

Setting up Hot and Cold Backups, Exports.

Creating Born / Korn Shell scripts for taking hot backups for 24*7 Operations

Configuring scripts for backups (hot, cold and incremental).

Installation, setup and configuration of logical and physical Standby Database using data Guard.

Data Modeling, Database Design and Creation.

Administering the Oracle Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Plan and Schedule the Online/Offline Backups.

Writing new stored procedures and modifying existing ones and tune them such they perform well.

Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.

Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources using the concept of OLE DB.

Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.

Data Warehouse Loading, Data Protection.

Database Refreshing / Replication from production to testing using hot backup.

Table Partitioning, creating Index Organized tables, Creating Locally managed Tablespaces.

Working with Blobs and

, Materialized views with Query rewrite, Bitmapped Indexes, etc.

Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration.

Provide primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.

Writing Shell scripts for Alerts for ORA errors backup and recovery, Import and export procedure. UNIX Shell scripting in csh, ksh to be controlled from Crontab.

Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Extensive Performance Tuning, Memory (SGA) Tuning, etc.

Creating the database, tablespaces, tables, indexes, setting privileges, user logins.

Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.

Environment: Oracle 9i\8i HP-UX, REDHAT LINUX, SUN SOLARIS, ASM,OEM (Grid Control), Explain Plan,Export/Import, SQL developer,veritas clusterTable Partitioning,Materialized views,,Hot/cold backup

Airtel Ltd _ _ June 2001 to May 2004

Role: Oracle Support Engineer

RESPONSIBILITIES:

Involved in 24*7 Remote / Onsite DBA support to Production Data Centers and interacting with offshore team and meeting the timelines of various projects.

Installation, Upgrade and Configuration of Oracle 9.2.0.1 / 8.1.7 and applying patches both Server side and Client side.

Complete cycle, including development, testing, training and production,

Extensive Performance Tuning, Memory (SGA) Tuning, Tuning Concurrent Managers, etc.

Cloning databases. Setting up advanced replication.

Setting up new environments (Development, Testing, Conference Room Pilot, Production etc).

Taking Hot and Cold Backups, Exports etc. Setting up and Installing Oracle Web Application Server.

Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.

Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).

Data Warehousing. Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.

Managed asynchronous replication using replication manager.

Upgraded Oracle 8 server to Oracle 8i using export/import.

Defragmentation of database using export import. Removing row chaining for better performance.

Data Modeling, Database Design and Creation

Entity Relationship Diagrams / Data Flow Diagrams, Normalization and implying checks for concurrency.

Creating Data Load scripts using SQL Loader to the Onsite Clients for Test Data & Application Testing.

Environment: Oracle 9i\8i RAC, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, Export/Import,Hot/cold backup,Defragmentation,Tablespace Management

EDUCATION: B.E – Computer Science, Rohilkhand University, India, 2001

Contact this candidate