SUMMARY

• Over 18 years of IT experience and having 12 years Oracle Database experience with 12c/11g/10g/9i on a variety of Linux/Unix(Solaris, HP - UX, AIX), Windows,
• Having over 5 years of DBAexperience 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.
• Build Multi-dimensional Cubes or Tabular Cubes using either STAR schema or SNOW FLAKE schema based on data volume and provide data at Cube level in Facts, which should be easily sliceable by dimensions.
• 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: Cassandra4/5/6.Mongodb,Cosmosdb,Oracle

OS: Aix,SunSolaris,Linux, Windows

DB Tools: Data dog,NewRaleic,Dbeaver,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

Confidential, Deerfield, IL

DBA/Devops Admin

Responsibilities:

• Build new Opscenter 6.7 for QA/Prod and configure alert setup
• Supporting multi-data center Cassandra cluster for Kubernetes applcation
• Build multiple Pipline for Cassandra cluster
• Managing, configurations and monitoring DataStax Enterprise Cassandra cluster through Opscenter
• Setup DSE opscenter 6.7 for backup and recovery
• Setup Ldap for cassandra database
• Involved in Cassandra-Solr database upgrade from 5.1.14. to 5.1.18
• Handle commissioning and decommissioning nodes along with monitoring of Cassandra Cluster.
• Involved in Cassandra database upgrade from 5.1. to 6.7
• Involved in Cassandra Datacenter Migrattion on Azure
• Supporting multiple Cassandra application
• Data structure design, Data modeling in Cassandra
• Refreshing the Production over the Dev, UAT and also keeping the Test Instances in sync with other instances
• Cluster management like add/bootstrap nodes, remove/replace node to clusters
• Migrate Cassandra Snithch Topologies
• Responsible for administration, maintenance, Performance analysis, and Capacity planning for NoSQL clusters
• Involved in designing various stages of migrating data from Cassandra to cosomsdb.

Environment: Chef,Azure, CassandraDSE-Solr,CassandraDSE-Spark, Mongodb,Cosmosdb

Confidential, Seattle, WA

Database Platform Engineer

Responsibilities:

• Build multiple Pipline for Cassandra cluster using Ansible and Jenkins.
• Installations, configurations and monitoring DataStax Enterprise Cassandra clusterthrough 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 CassandraNoSQL
• 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 ofCassandracluster.
• Migrate Cassandra Snithch Topologies
• Expertise in Snowflake and Star Schemas of Modelling.
• Refreshing the Production over the Dev, UAT and also keeping the Test Instances in sync with other instances.

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

Confidential, Seattle, WA

Cassandra Data Engineer

Responsibilities:

• Good experience in Designing, Planning, Administering, Installation, Configuring, Troubleshooting, Performance monitoring ofCassandraCluster.
• Involved in Cassandra database upgrade from 4.8.11. to 5.0.14
• Installations, configurations and monitoring DataStax EnterpriseCassandra clusterthrough 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 CassandraNoSQL
• 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 Opscenterupgrade 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
• ManagingCassandraclusters using Datastax opscenter
• Cluster management like add/bootstrap nodes, remove/replace node to clusters
• Handled commissioning and decommissioning nodes along with monitoring ofCassandracluster.
• Migrate Cassandra Snithch Topologies
• Refreshing the Production over the Dev, UAT and also keeping the Test Instances in sync with other instances.
• Knowledge ofCassandrasystems backup and recovery.
• Good knowledge inCassandracluster topology and virtual nodes
• Knowledge ofCassandrasecurity, maintenance and tuning both database and server
• Having knowledge on Datacenter,CassandraRings and Nodes
• Proficient in compaction strategies inCassandrasystem.
• Hands on experience onCassandraarchitecture with better understanding and write processes including Mem-table, SStable and Commit log.
• Excellent knowledge on CQL (Cassandraquery language), for retrieving the data present inCassandracluster by running queries in CQLImplementer Java driver to connect, load and retrieve data fromCassandradatabase

Environment: Shell scripting,AWS,Chef,CloudFormation,CassandraDSE-Spark and DSE-Solr,Mongodb

Confidential, Raleigh, Nc

Cassandra Dba

Responsibilities:

• Involved in Cassandradatabase upgrade from 4.8. to 5.0.
• Supporting multiple Cassandraapplication
• Data structure design, Data modeling in Cassandra.
• Installations, configurations and monitoring DataStax Enterprise cluster and/or open source Cassandracluster
• 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 CassandraNoSQL
• Involves designing, capacity arrangement, cluster setup, performance fine-tuning, monitoring, structure planning, scaling Cassandraadministration.
• MonitoringCassandracluster for resource utilization.Refreshing the Production over the Dev., UAT and also keeping the Test Instances in sync with other instances.
• Knowledge ofCassandrasystems backup and recovery.
• Good knowledge inCassandracluster topology and virtual nodes
• ManagingCassandraclusters using Datastax opscenter
• Knowledge ofCassandrasecurity, maintenance and tuning both database and server
• Having knowledge on Datacentre,CassandraRings and Nodes
• Experienced in using Kafka for streaming of data.
• Proficient in compaction strategies inCassandrasystem.
• Handled commissioning and decommissioning nodes along with monitoring of Cassandra cluster.
• Implementer Java driver to connect, load and retrieve data fromCassandradatabase.

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

Confidential, Reston, VA

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 effectivesolution and minimized the business impact bybuilding 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: Oracle12c RAC,Oracle11g\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

Confidential, Raleigh, NC

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: Oracle12c RAC,Oracle11g\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

Confidential, Charlotte, NC

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 effectivesolution and minimized the business impact bybuilding 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,Oracle11g\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

Confidential, Raleigh,NC

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 effectivesolution and minimized the business impact bybuilding 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,OracleRAC,Oracle11g\10g\9i,REDHAT LINUX Sun solaris,IBM AIX,RMAN,OEM (Grid Control),Explain Plan, AWR, ADDM, Data Pump,Unix Shell scripting,Datagurd,ContrrolM,OracleStream,Sql

Confidential, Groton, CT

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: Oracle10g\9i HP-UX, REDHAT LINUX, SUN SOLARIS, ASM,OEM (Grid Control), RMAN, Explain Plan, Export/Import, SQL developer,SOXpolicy,veritascluster,Materialized views

Confidential, Champaign, IL

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: Oracle10g\9i HP-UX, REDHAT LINUX, SUN SOLARIS, ASM,OEM (Grid Control), RMAN, Explain Plan, Export/Import, SQL developer,veritascluster,TablePartitioning,Materializedviews,,Hot/cold backup

Confidential, Tampa FL

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: Oracle9i\8i HP-UX, REDHAT LINUX, SUN SOLARIS, ASM,OEM (Grid Control), Explain Plan,Export/Import, SQL developer,veritasclusterTablePartitioning,Materializedviews,,Hot/cold backup

Confidential

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: Oracle9i\8i RAC, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, Export/Import,Hot/cold backup,Defragmentation,Tablespace Management