SUMMARY

• Working as Oracle/Cassandra/Hadoop Database Administrator with 8+ years of experience in diversified and very large production and non - production environments in various domains with database implementations in various UNIX, Windows platforms.
• Excellent experience in Installation, configuration, Maintenance of Oracle 12C,11g,10g, 9i RAC/Non RAC databases on Operating Systems UNIX, Solaris, Linux, AIX and Windows platforms.
• Excellent knowledge in Cassandra Architecture and management tools like OpsCenter
• Good Knowledge on read and write processes, including SSTables, MemTables and Commitlogs.
• Experience in designing conceptual, logical and physical data model based on the business requirements gathered.
• Experience in installing, configuring and monitoring Cluster, DevCenter and OpsCenter across various environments
• Worked collaboratively with the team in planning the capacity of multi data center Cassandra cluster based on the system requirements
• Experience in using CQL(Cassandra Query Language) for querying data present in Cassandra cluster
• Worked on data backup using nodetool snapshots and moving SSTables data on the live Cassandra clusters.
• Evaluated, benchmarked and tuned data model by running endurance tests using JMeter, Cassandra Stress Tool and OpsCenter.
• Used collections like lists, sets and maps to create data models highly optimized for reads and writes
• Experience in loading and transforming large sets of structured, semi structured and unstructured data in various formats like text, zip, XML and JSON.
• Experience in importing data on Cassandra tables using Sqoop from different relational databases.
• Implemented distributed messaging queue using Apache Kafka and ZooKeeper.
• Implemented Partitioning, Dynamic Partitions and Buckets for efficient data access using HIVE
• Basic knowledge of Spark and SCALA and Knowledge of using Solr for indexing.
• Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Upgraded the Databases from Oracle 10g/11g to 11g and 12c and applied patches according to the client requirement in RAC and NON RAC environments with ASM and Non ASM storage.
• Involved in application upgrades with Oracle Applications (11.5.8, 11.5.9, 11.5.10, R12.0.6,R12.1.3)/ Oracle E Business Suite.
• Worked on oracle web logic servers 11g and 12c and involved in configurations of web sphere application server version 8.5.
• Worked in Oracle EBS System Administration to manage concurrent managers, application user setup, defining responsibilities, value sets, registering forms & reports, custom application registration & printer setup.
• Implemented Heterogeneous replication and Bi-Directional Replication usingGoldenGate(Oracle to oracle, db2, SQL Server) and troubleshoot issues using Log miner.
• Experience in Auditing and Capacity Planning, Configuring & Managing Hot Standby Databases (Data Guard).
• Worked extensively on Exadata environment.
• Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability
• Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
• Proficient in implementing/configuring and usingOEM10g, 11g and12c Grid control.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experience in DATAPUMP, AWR, ASM, ADDM, Grid Monitoring & Oracle Enterprise Manager (OEM).
• Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.
• Experience in User management, Space Management, Capacity Planning.
• Developed and maintained data models using tools such as CA ERwin Data Modeler and TOAD Data Modeler.
• Experience in various tools like OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility and worked with Oracle Support (raising SR) for technical requests through METALINK.
• Database migration from a datacenter to a datacenter for the whole enterprise, Migration involving cross- platform migration and version upgrade etc.
• Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities)
• Partitioned large tables, indexes, implemented local indexing to improve the performance of ETL file loading and also Configuring high availability services like TAF, load balancing.
• Worked as a team member to provide 24x7 on-call production database support.
• Have strong analytical, administration and problem-solving skills dedicated to maintain the high quality standards. Good communication skills and ability to work independently.

TECHNICAL SKILLS

Databases & reporting Tools: Oracle 12C, 11g, 10g, SQL-Server 2008, Oracle Application Server 11g, Apache Tomcat, Datastage, Abinitio, Informatica, SAP

Tools: and Utilities: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, SQL*Loader, OEM, RMAN, Data pump, TOAD, Log Miner, SRVCTL, Embarcadero

Operating Systems: Linux, SunOS, IBM-AIX, HP-UX, Windows

NoSQL Database: Apache Cassandra 2.1, Hive

ClusterManagement Tools: OpsCenter, nodetool utility, stress tool, JMeter

Data loading tool: Sqoop

Messaging queue: Apache Kafka, ZooKeeper

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr.Oracle/Cassandra/Hadoop DBA

Responsibilities:

• Implemented code changes like DML and DDL by coordinating with Developers and Change Management team.
• Excellent knowledge in Cassandra Architecture and management tools like OpsCenter
• Good Knowledge on read and write processes, including SSTables, MemTables and Commitlogs.
• Experience in designing conceptual, logical and physical data model based on the business requirements gathered.
• Experience in installing, configuring and monitoring Cluster, DevCenter and OpsCenter across various environments
• Worked collaboratively with the team in planning the capacity of multi data center Cassandra cluster based on the system requirements
• Experience in using CQL(Cassandra Query Language) for querying data present in Cassandra cluster
• Worked on data backup using nodetool snapshots and moving SSTables data on the live Cassandra clusters.
• Evaluated, benchmarked and tuned data model by running endurance tests using JMeter, Cassandra Stress Tool and OpsCenter.
• Used collections like lists, sets and maps to create data models highly optimized for reads and writes
• Experience in loading and transforming large sets of structured, semi structured and unstructured data in various formats like text, zip, XML and JSON.
• Experience in importing data on Cassandra tables using Sqoop from different relational databases.
• Implemented distributed messaging queue using Apache Kafka and ZooKeeper.
• Good Knowledge on Hadoop architecture and Implemented Partitioning, Dynamic Partitions and Buckets for efficient data access using HIVE
• Basic knowledge of Spark and SCALA and Knowledge of using Solr for indexingWorked extensively with stored procedures, triggers, functions, packages, UNIX Shell scripting, Partitioning, and Indexes and excellent experience in installations, configurations, administration, and tuning of Oracle 10g, 11g, 12c and ASM for high available databases.
• Knowledge on Connectivity architecture, Replication architecture, Storage architecture, Caching layer architecture and Security architecture of Couchbase.
• Worked on data modelling Logical, Physical and Evolving data models in couchbase
• Implemented Couchbase 4.1 for POC of the data warehouse environment
• Worked on administering 10 Production databases and more than 40 non production databases of size ranging from 10GB to 5 TB on Solaris/AIX/LINUX servers.
• Installed 11g/12c software and created databases in RAC and non RAC environments for new projects by interacting with multiple application teams.
• Installed 5 node 11.2.0.4 RAC databases on NFS file systems and Worked on Multiple RAC clustered environments ranging from 2 nodes to 5 nodes per cluster.
• Involved in application upgrades with Oracle Applications (11.5.8, 11.5.9, 11.5.10, R12.0.6,R12.1.3)/ Oracle E Business Suite.
• Worked on oracle web logic servers 11g and 12c and involved in configurations of web sphere application server version 8.
• Worked in Oracle EBS System Administration to manage concurrent managers, application user setup, defining responsibilities, value sets, registering forms & reports, custom application registration & printer setup.
• Developed and maintained data models using tools such as CA ERwin Data Modeler and TOAD Data Modeler.
• Implemented, and configured 12C cloud control, agents and registered 11g/12c databases on SOLARIS servers.
• Worked on 11g Grid control and 12C Cloud control and intensively used for Diagnostic & tuning activities.
• Implemented Real Application Testing (RAT), RMAN new compression algorithm and tested active standby data guard.
• Responsible for maintaining ORACLE 11gR2 using SRVCTL, OEM, maintaining Oracle Clusterware using CRSCTL
• Migrated 2 TB 5 node RAC database and 5 node physical standby databases from 10.2.0.4 to 11.2.0.2 on NFS storage and, Presented White paper on upgrading 10.2.0.4 databases to 11.2.0.2 to Confidential DBA team.
• Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Upgraded databases from 10.2.0.4 to 11.2.0.4 and 12.1.0.2 on SOLARIS/LINUX/IBM AIX environments.
• Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability, where the standby database was used for disaster recovery as well as to offload the running of huge reports and did switchover and switchback And Troubleshooting archive log gap between primary and standby databases.
• Worked Extensively on DR (Disaster Recovery) process by testing failover and failback of production resources from Primary to standby databases located in Livingston and Fort Worth data centers.
• Installed, configured and supported uni-directional and bi-directional replicatedenvironments utilizing Golden Gate 10.x and 11.x software and created manager, extract, replicate trail files. Tested data is flowing fromheterogeneoussource systems to oracle database.
• Configured/Upgraded/Migrated/Maintained Exadata environment.
• Setting and Monitoring Exadata using 12c
• Excellent experience in maintaining and troubleshooting Exadata Cell/Storage an DB Compute node performance issues.
• Developed and worked extensively on CI (Continuous Integration) and CD(Continuous Delivery) by using Chef tool which is similar functionality as FlyWay.
• As per SECURITY MANAGEMENT Worked in claims database on 11gR2 with 2 node Data guard and Tested Switchover and Failover. Resolved system file corruption
• Familiar with different Backup and Recovery strategies, Cloning (using Recovery Manager - RMAN), creating RMAN scripts, VERITAS Net Backup, Export/Import, Data Pump, TTS, and Hot and Cold back-ups and experience with other oracle features like Flash-Back Recovery, ASM, ASH, AWR, ADDM, ASSM, AMM, ASMM, Automatic Undo management.
• Performed cloning using RMAN to set up development and test databases from Production database and Automated the nightly RMAN backups for the Production and some development Databases in Crontab.
• Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
• Reduced production outages by implementing best practices of patch management, purge/archival, code optimization and applied rolling patches like PSU and CPU on RAC/Non RAC after testing on DEV, QA and UAT.
• Experienced with Oracle Support (raising SR) processes for technical requests through MetaLink Tracked record with documentation of Oracle database operations
• Experienced in BCP (Business continuity process), in identifying Issues and finding out root cause/Analysis/Fix and documenting the procedures for the business units.
• Implemented the resizing the online redo logs in production and in standby database.
• Worked on SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace and tuned long running query’s by creating B-Tree and BITMAP indexes.
• Install Oracle administrative tools like OS Watcher and CHM to assist in administration of the Oracle database and its environment.
• Configured and implemented TDP (Tivoli Data protection) on TSM (Tivoli Storage Manager) platform to configure RMAN backups and recovery.
• Managed and Administrated the SQL Server 2008 production and Non-production servers.
• Configured and worked on SSIS tool to develop data integration and workflow solutions
• Worked on UDB/DB2 databases and worked extensively on creating users, assigning roles, space management and moving code from development to production databases on SOLARIS Servers.
• Worked on (ETL) DATASTAGE and ABINITIO by creating new projects, users, assigning privileges for users on projects, implementing common project settings, moving code by importing and compiling data and worked on unlocking the users and jobs and troubleshooting job design issues.
• Involved in 24x7 production database maintenance and on-call support.

ENVIRONMENT: Oracle 12c/11gR2/10g, SOLARIS, LINUX, AIX, WINDOWS, Datastax 4.7, Cassandra 2.1, DevCenter, Cqlsh, OpsCenter, Shell Scripting, Sqoop, Linux, Hive, Apache Kafka, ZooKeeper.

Confidential, Dallas, TX

Sr. Oracle DBA

Responsibilities:

• Implemented code changes like DML and DDL by coordinating with Developers and Change Management team.
• Installed, Configured Oracle 10g RAC Cluster for a 3 node multi instances hybrid cluster.
• Performed Oracle RAC Clusterware Installation of 10g (10.2.0.4) Cluster Ready Services on 3 nodes Configuration, RAC Database Creation, and Node Administration.
• Installed and Configured Golden Gate for replication of production databases to Reporting Databases and troubleshooted Golden Gate issues.
• Installed, configured and supported uni-directional and bi-directional replicatedenvironments utilizing Golden Gate 10.x and 11.x software and created manager, extract, replicate trail files. Tested data is flowing fromheterogeneoussource systems to oracle database.
• Expert in Golden Gate (10.x and 11.x) replication solutions to facilitate data flow betweenheterogeneous (SQL Server and Oracle) environments.
• Develop custom utilities to automate manually intensive tasks including mass schema changes, recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.
• Implemented ETL process, Oracle Streams replication, MV Replication, Database Security using security compliance auditing, and bulk loading of data from flat files using SQL loader.
• Configured/Upgraded/Migrated/Maintained Exadata environment.
• Setting and Monitoring Exadata using 12c
• Excellent experience in maintaining and troubleshooting Exadata Cell/Storage an DB Compute node performance issues.
• Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
• Cloned databases by using RMAN and Exporting and importing database using Data Pump.
• Involved in implementing Load balancing and testing failover on 3 node RAC Database.
• Wrote scripts to improve the performance of importing indexes.
• Created Materialized views on big tables and enabled the AUDITING on few tables in production.
• Worked on implementing cold/hot/logical backup procedures using shell (LINUX) scripting and also using RMAN. Developing, testing & implementing strong backup and recovery strategy. Also responsible for monitoring backups.
• Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication.
• Extensively worked in various areas of Dataguard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
• Worked Extensively on DR (Disaster Recovery) process by testing failover and failback of production resources from Primary to standby and vice versa.
• Implemented and configured 10g grid control on Production server and 11g grid control on development RHEL servers.
• Involved in checking and writing scripts for managing table space growth, monitoring the data file growth and extents too and Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Developed and worked extensively on CI (Continuous Integration) and CD (Continuous Delivery) by using puppet
• Experienced in BCP (Business continuity process), in identifying Issues and finding out root cause/Analysis/Fix and documenting the procedures for the business units.
• Involved in De fragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.
• Applied patches whenever necessary by downloading them from Metalink.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Used 10g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.
• Managed Oracle SR / tars, research application bugs, apply patches, data-fixes to resolve application, user functional issues
• Worked with Data Warehouse team on problem resolution and implemented change requests. - Performance tuning on DataWarehouse such as Data extraction from production to Data warehouse. Worked with Developers for High frequency data transfer.
• Managed and Administrated the SQL Server 2005 production and Non-production servers.
• Worked on Business Objects, INFORMATICA and SAP databases for Creating and managing Users, Universes, Reports, and Dashboards.
• Worked on SAP database for various modules like ECC, PI, Solman, Insync and BO. Used tools like BRTOOLS to increase table spaces, reorg, scheduling jobs and volume management.
• Provided 24*7 supports with an on call pager.

ENVIRONMENT: Oracle 11g/10g, RHEL 5.3, Windows

Confidential, Austin, TX

Sr. Oracle DBA

Responsibilities:

• Provided Database Administration and support (24*7) for 3TB production oracle 10g OLTP Databases
• Responsible for all database activities such as space management, User management, database security management, rollback segments & creation of DB links.
• Responsible for installation and creation of databases (10g) (RAC) for Development and user acceptance test.
• Responsible for Installation of 10g (10.2.0.1) cluster ready services and 10.2.0.1 database in OCFS and ASM file systems.
• Responsible for Upgrading the Database from 10.2.0.1 to 10.2.0.4 and Upgrading) CRS from 10. .2.0.4.
• Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Involved in administering and maintaining Oracle Application Server 10gR2 (10.1.2).
• Responsible for implementing Load Balancing in RAC Database.
• Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability.
• Responsible for using Flashback query mechanism along with automatic undo management.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• An active member of the backup and recovery team and was responsible for configuration and implementation of backup and recovery using RMAN and Data Guard.
• Tested many backup and crash recovery scenarios on test environment, using RMAN tool.
• Implemented 10g Oracle STREAMS for DATA REPLICATION across databases in a high transactional 10g RAC data environment.
• Responsible for automation of startup and shutdown on all production and development databases.
• Increased availability of development instances by reducing cloning time by implementing clone automation using Grid.
• Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.
• Wrote scripts (Linux Shell, PERL) for database maintenance activities such as monitoring the growth rate of tablespaces and extents. Also wrote UNIX scripts to process batch jobs.
• Install Oracle administrative tools like OS Watcher and CHM to assist in administration of the Oracle database and its environment.
• Provided 24*7 supports with an on call support.

Confidential, Detroit, MI

Jr Oracle DBA

Responsibilities:

• Responsible for Installation, administration and upgrade of Oracle RAC 9i/10g & Oracle 9i/10g production and development databases.
• Performed cloning using RMAN to set up development and test databases from Production database.
• Upgraded the single instance database from 9.2.0.8 to 10.2.0.2.
• Responsible for installation and configuration of Oracle 10g Grid Control and agents and Managed databases using Oracle 10g Grid Control.
• Responsible for installing, configuring and maintaining the Physical standby database.
• Used Data Guard broker to monitor Data Guard configurations on standby database.
• Good working and implementation knowledge on Data Guard and Stand-by databases for fail-over and recovery.
• Responsible for configuring and taking level 0 and level1 incremental RMAN backups and resolving issues arising out of those. Performed daily health check of the databases by implementing above backup and recovery procedures. Also implemented logical, cold and hot backups.
• Responsible for managing both rollback and temporary segments.
• Involved in applying latest patches on the oracle database and also upgrading the database by downloading them from Metalink.
• Responsible for modifying the database structure as required based on information given by the developers.
• Loaded data into staging tables using SQLLDR, automated data loading using shell scripts (Linux Shell)
• Rebuilt indexes for better performance of Oracle database.

Confidential

Database Developer/DBA

Responsibilities:

• Performing database design, analysis and development of the system.
• Providing back-end support for customized Forms like customer and supplier maintenance, bill, receipt, letter of credit, invoice, debit and credit notes.
• Developing PL/SQL Packages to monitor revenue earnings and expenses and to maintain the general ledger of the organization.
• Developing stored procedures and functions using PL/SQL for complex updates and audit trails.
• Testing PL/SQL procedures against the test cases. Involved in creating use cases and test cases
• Performing re-sizing of data files, managed table spaces and data files.
• Implement Hot, Cold and Logical backup plans. Designed backup and recovery procedures for OLTP system
• Use TOAD tool to access the database. Used PL/SQL developer to create PL/SQL Procedures
• The work involves overall Installation, Maintenance, Performance Tuning, Backup, Recovery and other database related activities.
• Performed daily maintenance tasks like space management, user management, managed quotas etc.
• Worked with PL/SQL developers to write limited database code, Packages, Procedure, functions and DB triggers to query bridge data.
• Responsible for regular Physical as well as Logical Backups and maintaining the databases using RMAN and EXPORT & IMPORTS.
• Identifying the poorly performing queries using Tkprof, Statspack reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace.
• Implement Hot, Cold and Logical backup plans. Designed backup and recovery procedures for OLTP system
• Performed on-call technical support to minimize the impact of system disruptions.