SUMMARY

• 7 years of experience as an Oracle and No - Sql Database Administrator
• Experience with Oracle 10G/11G/12C, Couchbase, Cassandra in Software Installation, Database creation, Storage Allocation, Performance Tuning, Database Backup and Recovery, SQL, PL/SQL in environments on Unix/Linux and Windows.
• Expertise in installation and configuring the No-sql database for hadoop or big data environments.
• Have one plus experience in banking and financial domain knowledge.
• Possess good spirit and team player, helping and motivating others in team to achieve goal and also can excel in the team as an active member.
• Managing the full operational lifecycle of Database including sizing, deployment, monitoring & ongoing tuning and maintaining (e.g, adding and replacing nodes, rebalancing, upgrading to newer version, etc.)
• Experience in designing and implementing NoSQLdatabase stores such as Couchbase, MangoDB, HBase and Cassandra
• Excellent knowledge on MySQL,Oracle, DB2and RDBMS, Couchbase, Cassandra and MangoDB
• Good experience in Designing, implementing, and improving analytic solutions for Cassandra on Kundera and Java frameworks.
• Extensive hands-on experience in Big Data projects with couchbase, Cassandra and related technologies
• Hands-on experience on production environments in couchbase and Cassandra applications such as administration, configuration management, monitoring, debugging, and performance tuning.
• Experience in writing Map Reduce jobs in Java using Eclipse Builder and PIG.
• Comfortable in bringing up and maintaining couchbase and Cassandra cluster, capacity planning, performance tuning and monitoring.
• Experience in performance analysis and capacity planning for growing Cassandra and Hadoop clusters. Created Cassandra Advanced Data Modeling course for DataStax.
• Application performance optimization for Cassandra cluster.
• InstalledCassandra2.0 in Production,Pre-prodenvironmentsas per best practices
• UpgradedCassandra databases from1.xto2.x
• Experience in storage model in Cassandra and implemented variousoptimal configuration to meetstorage requirements
• Experiencein integrating CassandrawithElastic searchandHadoop
• Worked invarious Cassandra Backup-Restoremodels
• Experience in finding the Memory Leaks and adjusting the JVM Heap Sizes and GC Parameters.
• Experience in analyzing the various server logs and thread dumps to perform Root Cause Analysis.
• Involved in the migration of applications from WebLogic 8.1 to WebLogic 10.3.
• Experience in WebLogic Portal & WebLogic Integration on WebLogic 10.x/8.x platforms, Portal and Portlet development and deployment.
• Experience in installing Oracle Golden Gate and configuration of various Golden Gate extracts to replicate data from back-end databases onto L2/L3 systems using Solace VPN backbone.
• Experience in configuring/integrating/troubleshooting loaders, listeners to push data from databases to GRID(cache) servers.
• Experience with Zookeeper tool, to move configuration files from centralized system to various servers to which it is integrated.
• Experience in Real Application Cluster (RAC) environment with Grid Infrastructure and Auto Storage Management (ASM) on Oracle 10g/11g.
• Setup and configured Oracle Data Guard & Standby Database to ensure High Availability and providing critical solutions with Strategic disaster recovery plans with different recovery procedures and methods.
• Good knowledge on Oracle tools like SQL, PL/SQL, SQL * PLUS and used TOAD in many development projects.
• Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Expert in backend programming using PL/SQL and SQL.
• Highly proficient with Oracle applications development tools within a client/server environment.
• Extensive experience in Database Management in managing SQL Server Databases.
• Performed system design with Entities, attributes, logical relationships (identifying, non-identifying) Preliminary database design, obligatory and non-obligatory analysis, and validation of a model using Normalization techniques.
• Experienced in Performance Tuning and Optimization of SQL statements.
• Expertise as On-Call 24x7 production DBA and application/development DBA and oracle support processes for technical requests through Meta link and other support Procedures.

TECHNICAL SKILLS

Operating Systems: RedHat Linux RHEL 4.x/5.x, HP-UX 10.x, 11.x, SUSE 11.x, Windows Server 2003/2008.

RDBMS: Oracle 11g/10g/9i

Languages: SQL*PLUS, PL/SQL, UNIX Shell

Database Tools: Quest TOAD, SQL Developer, RMAN(Recovery Manager), RAC(Real Application Cluster), CRS(Cluster ready service), ASM(Automatic storage management), Data Guard, Streams, Golden Gate, OEM(Oracle Enterprise Manager), Grid control, SQL Developer, Putty, OEM, NetCA and DBCA

Utilities: SQL Loader, Export/Import, Data Pump, Explain Plan, VI Editor, Export/Import, EXPDP/IMPDP

PROFESSIONAL EXPERIENCE

Couchbase & Cassandra Database Administrator

Confidential

Responsibilities:

• Managing the full operational lifecycle of Database including sizing, deployment, monitoring & ongoing tuning and maintaining (e.g, adding and replacing nodes, rebalancing, upgrading to newer version, etc.)
• Work closely with developers to provide help and recommendation on Database configuration, design documents and views
• Installing, configuring and trouble-shooting application servers like Oracle Weblogic Apache Cassandra/ Oracle Coherence / Tomcat and web servers like Apache and on Sun Solaris, Linux,Z/OS platforms.
• Administered Cassandra cluster using DatastaxOpsCenter and monitored CPU usage, memory usage and health of nodes in the couchbase and Cassandra cluster
• Deployed and maintained PROD, TEST and DEV clusters
• Involved in requirements gathering and Capacity planning for multi-datacenter(four) Couchbase and Cassandra cluster
• Migrated around 500 GB of data from one datacenter to another datacenter
• Created and managed the VM’s in OpenStack environment for testing purpose
• Configured internode communication between Cassandra nodes and client using SSL encryption
• Evaluated Data model by running endurance tests using JMeter and OpsCenter.
• Configured authorization to Cassandra cluster using Password Authenticator and Kerberos for Hadoop cluster
• Designed and configured gateway node to the cluster
• Documented and demonstrated on various ways to securely connect to the cluster
• Designed and implemented a strategy to securely move production data to Development for testing purposes using sstable loader
• Designed and implemented a strategy to upgrade the DataStax enterprise cluster
• Worked on major and minor upgrades of Couchbase and Cassandra cluster.
• Used DataStaxOpsCenter and nodetool utility to monitor the cluster
• Involved in Data modelling design for various use cases
• Played responsible role for deciding the hardware configurations for the cluster along with other teams in the project
• Installation and adminstration of Oracle Coherence 3.6.1 / 3.7.1 centerlized system, which handles 60+ applications across companys tier 2 and tier 3 clients.
• Handling differnt range of caches on coherence storage nodes.
• Managed and administered domains, nodes, managed servers, instances in Oracle WebLogic application server.
• Production support and providing 24x7 on-call support.

Oracle DBA & PL/SQL Developer

Confidential, Charlotte, NC

Responsibilities:

• Administration and supporting of Oracle 10g/11g Databases ranging from 100GB to 60TB.
• Performed database upgradation from Oracle 11.2.0.4 to 12.1.0.2
• Installation, upgradation, configuration and troubleshooting Goldengate 11G/12C software.
• Configured Goldengate components for unidirectional and bidirectional replications andmaintain data synchronization.
• Handled application support requests on the issues raised by users with the existing live environment.
• Extensive technical and business experience in Procure-to-pay, Order-to-cash, Quote to Cash and Assets to GL Record to Report.
• Exposure in R12 Financial Modules and SLA, MOAC, TCA, E-BUSINESS TAX.
• Expertise in development tools such as Oracle Forms, Oracle Reports, PL/SQL, SQL*PLUS, UNIX Shell Scripts.
• Experience of setup and configuration of I Expense module.
• Experienced on Project go-live and post-implementation support.
• Proficient in corporate finance/ resource planning, financial systems evaluation, design and implementation.
• Prepared Test cases TE-020,030,040 for Financials modules (AP, AR, and GL).
• Developed SQL Loader scripts, conversion scripts for the conversion of the data to the custom new Schema.
• Administered Cassandra cluster using DatastaxOpsCenter and monitored CPU usage, memory usage and health of nodes in the cluster
• Deployed and maintained PROD, TEST and DEV clusters
• Involved in requirements gathering and Capacity planning for multi datacenter(four) Cassandra cluster
• Migrated around 500 GB of data from one datacenter to another datacenter
• Created and managed the VM’s in OpenStack environment for testing purpose
• Configured internode communication between Cassandra nodes and client using SSL encryption
• Evaluated Data model by running endurance tests using JMeter and OpsCenter.
• Configured authorization to Cassandra cluster using Password Authenticator and Kerberos for Hadoop cluster
• Designed and configured gateway node to the cluster
• Documented and demonstrated on various ways to securely connect to the cluster
• Designed and implemented a strategy to securely move production data to Development for testing purposes using sstable loader
• Designed and implemented a strategy to upgrade the DataStax enterprise cluster
• Worked on major and minor upgrades of cluster
• Used DataStaxOpsCenter and nodetool utility to monitor the cluster
• Involved in Data modelling design for various use cases
• Played responsible role for deciding the hardware configurations for the cluster along with other teams in the project
• Installation and adminstration of Oracle Coherence 3.6.1 / 3.7.1 centerlized system, which handles 60+ applications across companys tier 2 and tier 3 clients.
• Handling differnt range of caches on coherence storage nodes.
• Monitoring and Performance tuning of Goldengate sessions Confidential Database level and GGSCI level.
• Investigate Replication failures using Log Dump utility.
• Involved in Database Migration, performed migration using Goldengate and Datagaurd.
• Performed Backups and Data Migration using Datapump EXPDP/IMPDP.
• Implemented Logical and Physical structural changes to table using DBMS REDEFINITION.
• Configuration and scheduling RMAN backups.
• Performed RMAN Duplications.
• Troubleshoot database performance issues using ASH, AWR, ADDM and OEM.
• Carried out Performance optimization and Query tuning using Explain Plan and Tkprof.
• Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
• Provided database/application tuning including such as reducing lock contention, modifying db parameters, balancing I/O across controllers, analyzing objects, pinning objects, and eliminating chained row.
• Assisted developers in SQL Tuning of offensive queries in several environments. Install, configure and maintain Oracle Single Sign-On with Active Directory and Oracle Internet Directory.
• Experience in implementing WebLogic integration (WLI) for various applications to access external resources.
• Configure Jenkins Continuous Integration server to automatically exercise these scripts anytime a change is checked into Subversion and report via email if changes break the"build"
• Install and configure Jenkins continuous integration server, with Maven and Java
• Expertise in migration and upgradation of WebLogic Server and updating JDK versions and installing service packs for WebLogic server.
• Provided end to end visibility of critical transactions and in complex composite J2EE web applications through Wily Introscope.
• Worked on Tuning the WebLogic Application Server, Applications and Webservers by changing the Heap Size parameters and tuning JVM’s Garbage Collector.
• Involved in collecting and analyzing JVM performance for all WebLogic Servers in environment by writing jython utility scripts and executing them through WLST.
• Installed and worked with SSL certificates on Apache HTTP 2.2.
• Involved in doing a performance benchmark of WebLogic server by using Load runner.
• Resolved complex clustering, session JDBC and JMS problems.
• In depth knowledge of setting up RMAN backups and maintaining catalog schema. Proficient in creating auxiliary and duplicate database using RMAN.
• Wrote several ad hoc scripts for daily DBA activities such as backups, user creations, archiving of alert logs, verifying error entries and checking for space usages/overages.
• Supporting Monthly/Quarterly release cycles.
• Work with Oracle Support on SR’s to resolve customer issues.
• Production support and providing 24x7 on-call support.

Environment: Oracle 10g/11g/12c databases on HP-UX/SUSE/OEL(UK), OEM 11g/12c, Goldengate 11g/12c, MySQL 5.6.

Oracle & Cassandra Database Administrator

Confidential, Dallas, TX

Responsibilities:

• Installed and configured 11g databases on RAC and Non-RAC environments.
• Setup maintenance of Data Guard for disaster Recovery and reporting purpose with various modes.
• Installed, Configured, Administered Oracle Golden Gate Confidential GDDN layer with major components being Golden Gate and Change Processors.
• Implemented the multi datacenter (network-topology) cluster consisting of Cassandra rings
• Worked with developers for choosing the right Compaction Strategies and consistency levels
• Optimized the Cassandra cluster by making changes in Cassandra configuration file and Linux OS configurations
• Involved in Data modeling design for various use cases
• Used Cassandra node tool to manage Cassandra cluster
• Involved in commission and decommission of the nodes in the existing Cassandra cluster
• Evaluated, benchmarked and tuned data model by running endurance tests using JMeter, Cassandra Stress Tool and Obscener
• Worked on tuning Bloom filters and configured compaction strategy based on the use case.
• Performed importing data from various sources to the Cassandra cluster using Java/Python APIs.
• Configured node-to-node and client-to-node encryptions by generating and distributing key store and trust store files to all nodes.
• Designed, automated the process of installation and configuration of secure Data tax Enterprise Cassandra using puppet.
• Performed backup and recovery operations
• Used DataStaxOpsCenter and node tool utility to monitor the cluster.
• Configured Extracts for Golden Gate to replicate data from back-end TLG/Non-TLG Databases through remote-pumps. Configured Change processors to sort the data categorized using mappers.
• Worked extensively on Solace routers, to transmit data in terms of messages to multiple datacenters simultaneously.
• Configured Loaders/Listeners to move data eventually to L2 (Coherence) / L3 (Cassandra) systems where data would be stored as per there cache-names.
• Configured Zookeeper to store all the configuration files, and later to move them onto the corresponding serves to keep systems in sync.
• Worked extensively on J2EE migrations using SVN kit.
• Installed, Configured and maintained ORACLE WebLogic 8.1/9.2/10.3 on Linux and Windows platform and also configured LDAP for user and system authentication.
• Involved in Load balancing, Performance tuning and monitoring using Wily Introscope.
• Responsible in troubleshoot WebLogic Server connection pooling and connection manager with Oracle, DB2, SQL, and Sybase.
• Responsible in Maintaining Remedy system for ticket management. Use of Clear case and CVS for version control. Wrote and maintain shell, ant scripts for simplifying and automating tasks.
• Setting up proxies in Apache, SunOne for redirecting requests to Tomcat or WebLogic.
• Involved in the migration of applications from WebLogic 8.1 to WebLogic 10.3.
• Wrote, build & deployed scripts using ANT, Jython and shell scripts in Red Hat Linux environment.
• Planned, Installed and Configured GoldenGatesetup to achieve unidirectional replication.
• Performed, developed and maintained database backup and recovery using RMAN.
• Refreshing/Cloning databases for the testing/developing purpose.
• Replicated data between two database using materialized view and DB link.
• Performed logical backup of database, schemas, tables using Exp/Imp and Datapump.
• Performed Database and SQL tuning by using various Tools like STATSPACK, EXPLAIN PLAN for Query Optimization and SQL tuning advisor, Database Health Monitor, ADR and Creating tables with Virtual Columns, DDL Lock Timeout, Invisible Indexes and knowledge of Database Resident Connection Pooling.
• Monthly, Weekly and daily report generation using AWR and ADDM.
• Reorganizing and Rebuilding of the Tables/Indexes.
• Performed Cross-platformMigrationusing transportable tablespaces and RMAN.
• Applying Database Patches.
• Monitored the various database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring to ensure proper Capacity and Availability.
• Involved in User Management and Database Security by granting appropriate Roles, Privileges, and Profiles.
• Day to day monitoring like availability of system, listener, database, alter log file, trace file.
• Configured Auditing to audit information about database activity.
• Support users for bugs/issues in Oracle Database.
• Production support and providing 24/7on-call support.

Environment: Oracle 10g/11g databases on RHEL 5.5, OEM 11g and Goldengate 11g

Oracle DBA & PL/SQL Developer

Confidential, Indianapolis, IN

Responsibilities:

• Coordinated with users to define and design needs, developed technical solutions ensuring software integrity.
• Created packages, stored procedures and user-defined functions using PL/SQL and Oracle Procedure Builder for various business operations.
• Wrote complex business logic triggers for validation and updating of data using PL/ SQL.
• Designed and developed primary database objects using referential integrity rules on (tables, views, indexes).
• Wrote SQL*Loader scripts for loading data into the Oracle database.
• Reverse engineered the existing database to add extra functionality utilizing Oracle Designer 2000, Forms 6i and Reports 6i for accounts and payments billing.
• Embedded programming using Pro *C.
• Application performance & Tuning using TKPROF generating report from SQL trace file.
• Recommended improvements to existing application for performance and scalability requirements.
• Wrote the UNIX shell scripts to automate the data load processes. Documented all the scripts used in the project for easier maintenance.

Environment: Oracle 9i, SQL*Plus, Oracle Forms/Report 6i,SQL * Loader, Erwin, UNIX shell scripts, XML, Forms /Reports 6i, Oracle Procedure Builder, HP-UX Windows XP Professional