SUMMARY:

• Over 7 years of experience as an Oracle Database Administrator including 4 years  of experience as Cassandra Administrator providing 24*7 production database support with Support to developers & end - users on call support & co-ordination with off shore teams.
• Extensive knowledge on database administration for ORACLE 12c/11g/10g and Apache Cassandra with experience on large scale database environments.
• In depth knowledge of Apache Cassandra and Datastax Enterprise Cassandra
• In depth knowledge in Cassandra   read, writes paths and internal architecture . 
• Experience with installing, configuring and monitoring Apache Cassandra cluster
• Experience in implementing multi-datacenter cluster .
• Designing data models in Cassandra and working with Cassandra Query Language (CQL).
• Experience in creating column Family’s ; bootstrapping, decommissioning, removing, replacing, and repairing nodes.
• Experience in creating key spaces, tables and secondary indexes in Cassandra
• Experience in setting up the required replication factors for key spaces
• 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 Cassandra tools including sstableloader,sstable2json and json2sstable, COPY for application data loading and analysis
• Experience in Performance tuning Apache Cassandra  cluster to optimize writes and reads
• Troubleshoot read/write latency and timeout issues in CASSANDRA
• Good knowledge on Datastax Search/ Solar in indexing and managing searches.
• Good knowledge on Hadoop Architecture and Hadoop echo system
• In depth knowledge on integrating Cassandra with Hadoop.
• Good knowledge on Spark SQL, Spark Streaming and Scala.
• 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, AIX, Windows, SunSolaris, UNIX

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

Web Technologies: HTML/ HTML5, CSS3, XML

Relational Databases: Oracle 12c/11g/10g; SQL Server 2008/2012,

NoSQL Databases: Cassandra

Big Data: Hadoop, Spark

PROFESSIONAL EXPERIENCE:

Confidential, Richfield, MN

Cassandra Admin

Responsibilities:

• Installing, configuring, monitoring Apache Cassandra Prod, Dev and Test clusters
• Implementing and maintaining a multi Datacenter Cluster
• Involved in requirements gathering and capacity planning for multi data center Apache Cassandra cluster.
• Involved in the process of adding a new Datacenter to existing Cassandra Cluster
• Involved in upgrading the Cassandra test clusters
• Creating required key spaces 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 Cassandra cluster to optimize writes and reads
• Involved in the process of bootstrapping, decommissioning, replacing, repairing and removing nodes.
• Benchmarked Cassandra cluster 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) & 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.

Confidential, Bothell, WA

Oracle Database Administrator/Cassandra Administrator

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 Cassandra data modelling and building efficient data structures
• Involved in working on Cassandra database 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 Table space Management, Schema management, User Creation and granting Users Access to Applications based on their roles.
• Involved in Table space Management, Schema management, User Creation and granting Users Access to Applications based on their roles.

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

Confidential, MD

Senior Oracle DBA

Responsibilities:

• On call support for Dev/Test and production environments and applications on all business days and 24 x 7 during holidays and weekends
• Installation and patching the database for Dev/Test and production hosts (latest & bug).
• Provided Production & test environment support while coordinating with Unix Team and storage team to configure the OS infrastructure for Oracle Databases.
• Performed Cloning of a Database using RMAN for a test database environment
• Developed recovery Strategy using Oracle RMAN in daily and weekly maintenance
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora
• Monitoring database performance and database operation to prevent downtime and slowness of the services.
• Installed and configured of release 11g R2 RAC with ASM
• Managed multi node (3 nodes) RAC with ASM, and adding instance to existing RAC.
• Created and monitored all database objects, including tables, clusters, indexes, sequences, packages and procedures
• Created table spaces and managed table spaces adding/deleting/ resizing data files
• Managed Undo Segment in order to avoid "Snapshot too old" error
• Extensively involved in Instance creations and maintenance
• Performed logical backup & recovery using export/import utilities and Datapump. Involved in Configuration.
• Design and implement database backup and recovery procedures using RMAN
• Having experience in Migrating data to other databases and Database storage management
• Upgraded database from 10g to 11g on Linux
• Expert in monitoring database using Oracle Enterprise Manager (OEM).
• Automating database daily operations. Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• Support developer by tuning SQL query and PL/SQL codes

Environment: Oracle 10g/11g, PL/SQL, Oracle Standby databases, RMAN, Hot backups, RAC.

Confidential

Oracle Database Administrator

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 Table spaces (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*LOADER, SQL*PLUS