Summary:

• 10 years of total IT experience 8 years as Oracle DBA Administration and 1 year of Cassandra Administration.
• Oracle Database Administration experience in various platforms like HP-UX, SUN SOLARIS, AIX, Red Hat Linux and Windows.
• Expertise in Installation, Configuration, Upgradation, Patching, Migration, Trouble shooting and Performance tuning of oracle 8i/9i/10g/11g stand alone and RAC databases/Clients on UNIX, LINUX and Windows environments
• Implemented Database replication using Oracle Golden Gate.
• Installed and configured Cassandra DataStax Enterprise addition with OpsCenter monitoring.
• Hands on experience in configuring snapshot and incremental backups on Cassandra databases.
• Expertise in Managing Hadoop clusters administration/Hbase including setup, install, monitor, maintenance and operational support for distribution: Cloudera CDH3, CDH4,CDH5
• Involved in setting up High availability solutions to Hadoop cluster and HBase.
• Support development, testing, and operations teams during new system deployments.
• Experience in using Pig, Hive, Scoop, HBase, ZooKeeper and Cloudera Manager.
• Planned and implemented Disaster Recovery high availability solutions using Oracle 10g and 11gR2 Standby Database using Oracle Data Guard.
• Performed Upgrade/Migration of the oracle databases from Oracle 9i to 10g and 10g to 11gR2.
• Performed yearly Prod and BCP switch over exercise in Standalone and RAC using Data Guard Broker.
• Configured RMAN and Non-Oracle backup methodologies for multi-tera byte databases with full documentation of crash recovery testing's.
• Hands on experience on installing and configuring Data Vault.
• Experience in using 11g new features SQL Plan Base Lines, SQLT, Active Data Guard, RMAN recoveries.
• Intensively used latest 11G/10g Automatic Workload Repository AWR Automatic Database Diagnostic Monitoring ADDM reports for the health check of the databases, and used the notification tool to send the alerts in OEM 12c Grid Control.
• Attended Cassandra trainings and webinars from Datastax

TECHNICAL SKILLS:

Operating Systems Database

HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, Oracle 8i, 9i, 10g RAC, 11gR2 RAC,

8, 9, 10, AIX 5.1, 5.2, Red Hat Linux RHEL MS SQL Server

2.1, 3.x, 4.x and Windows 95/98/ME/NT/

2000/XP.

Tuning Tools Database Tools

SQL Auto Tracing, TKPROF, EXPLAIN SQL PLUS, RMAN, OEM, SQL Loader,

PLAN, STATSPACK, AWR, Tuning advisors, Exp, Imp, Expdp/ Impdp and TOAD,

ADDM, oradebug, OS Watcher and SQL Netezza , SQL Developer, Erwin, dbverify etc.,

Plan stability

Programming

SQL, PL/SQL, Perl, UNIX korn Shell

Scripting,

Professional Experience:

Confidential

Sr. Oracle DBA Administrator

Responsibilities:

• Worked as Oracle POC for 11g upgrade project from stand alone to 11gRAC.
• Involved in installing, configuring and administrating the GoldenGate environment for Smartworks Databases.
• Setting up and supporting Cassandra 1.2 /DataStax 3.2 for POC and prod environments using industry's best practices.
• Installing and configured DataStax OpsCenter 4.0 DevCenter 1.0
• Involved in Capacity planning, Data modeling, Hardware designing and initial configuration of Apache and DataStax Cassandra clusters in 2-multi data center configuration.
• Worked on Performance turning and Cassandra setup standardization process.
• Attended several Cassandra training and webinars before implementation.
• Migrated data from Oracle database to NOSQL using Sqoop.
• Perform data analysis using Hive and Pig.
• Load log data into HDFS using Flume.
• Good knowledge on in Managing Hadoop clusters administration/Hbase including setup, install, monitor, maintenance and operational support for distribution: Cloudera CDH3, CDH4, CDH5
• Involved in setting up High availability solutions to Hadoop cluster and HBase.
• Hadoop Cluster capacity planning, performance tuning, cluster Monitoring, Troubleshooting.
• Adding/removing new nodes to an existing Hadoop cluster.
• Backup configuration and Recovery from a NameNode failure.
• Worked on Oracle Data Vault configuration on critical Financial Databases.
• Worked on 11g upgrade project in both stand alone and 11gRAC
• Involved in Audit Vault migration plan.
• Configured 6 node Active Standby RAC database and implemented FSFO.
• Worked on PSU patching using OEM 12c.

Environment:

Cassandra, Hadoop/MapReduce, Oracle 10g/11g, EM Cloud Control 12c, VM Ware ESX, Net Backup, SPARC M500 systems, 3 Node RAC, Active Data guard configuration, Linux and Solaris, Delphix , Golden Gate.

Confidential

Sr. Oracle DBA

Responsibilities:

• Worked on POC to Designed and develop large-scale, geographically distributed NoSQL database systems as part of Big Data Initiative Project.
• Worked with team on Designing and implementation of distributed Hadoop infrastructure with 8 nodes, including Primary/Secondary NameNodes, DataNodes and ZooKeeper.
• Installed and configured DataStax Enterprise Cassandra on 2 node for Pre-production usage to analyze event log on multiple servers.
• Worked with developers to implement Hive and Pig, with more emphasis on Hive due the fact it had short learning curve for resources who were familiar with SQL .
• Worked on Data center migration project involved 80 applications including Prod, Stage and Development.
• Responsible for re-designing database infrastructure based on the requirement and funds available to improve the overall efficiency using tradition and new features.
• Worked in data center consolidation project designing/implmentetion team that includes moving/reconfiguration of LINUX servers, multi tera byte online banking/Mobile banking/bill payment database systems.
• Migration of billing database from 10g to 11g.R2.
• Installed and Configured RAC databases in 11gR2 with Standby and Active Standby.
• Migrated 10 terabyte database to new data center.
• Working on new projects involved in Data center migration.
• Currently working on database center migration to new datacenters.
• Installed 11.2.0.3 Grid Infrastructure on Linux and configured multiple environments for Prod,BCP UAT, Prod Fix and Dev environment.
• Upgraded ASM and databases from 10g to 11g and configured databases into cluster.
• Installed and configured Golden gate for Oracle databases for replication between primary and standby databases.

Environment:

Oracle 11g/10g, Oracle 11gR2/10gR2 RAC, Linux, Sun Solaris, IBM AIX, Oracle Clusterware, NetApp, ASM, Grid Control, Data Guard, Shareplex Versions 7.0.2 - 7.6.3 Replication, Tivoli , UNIX Shell Scripting.

Confidential

Sr. ORACLE DBA Lead

Responsibilities:

• Responsible for maintaining multiple Oracle database 10gR2/11gR2 .
• Managing my team and assigning roles to my team on daily and weekly basis.
• Responsibilities include application and database tuning
• Involved in Migration of the databases from Oracle 9i to Oracle 10g.
• Configured RMAN for backup and recovery strategy.
• Used Backup Exec for tape backup.
• Installed databases on Virtual machines depending on client requirement.
• Installed security patches and migration of Prod database from 10g to 11g.
• Cloned database using RMAN and automated job.
• Managing physical and logical databases.
• Monitoring all prod jobs and modified according to requirement.
• Attend management meeting to give database recommendations and solutions.
• Monitoring system security, auditing of database objects, system privileges.

Environment:

Oracle 10g and 11g SQL Plus, Oracle Enterprise Manager OEM , RMAN, Linux, Windows Server 2005 and 2008

Confidential

Sr. ORACLE DBA

Responsibilities:

• 24 X 7 On-call Production Oracle database support and Installation, Configuration and Administration of Oracle 11g databases.
• Performed Database up gradation from 10g to 11g.
• Involved in complete production database migration from Bothell to Allen, Texas and built new prod environment for Premier application.
• Configured RMAN backups for new databases.
• Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data and monitored regularly whether primary and standby databases are in sync. Also involved in Disaster Recovery setup.
• Installed 4 node RAC on pre prod environment in Redhat Linux also installed and tested on virtual machines.
• Monitored the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents. Monitoring the excessive fragmentation of table spaces and taking remedial steps.
• Worked on all production release and scheduled full back up before release. Also created restore points using Flashback and able to restore successfully from guarantee restore points.
• Cloned/Refreshed Database environments to keep in sync with latest prod release.
• Worked on various scripts like Archive purge Developed Scripts for Startup and Shutdown, Cold Backups, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Worked on all aspects of oracle database including Security, Administration, Backup Recovery RMAN/USER Managed and performance and Tuning. Partial /Full database refreshes using RMAN DB cloning. Materialized view replication between two prod environments.
• Worked on Oracle Streams for replication.
• Worked on Golden Gate Replication for Production databases.
• Managing database activities like number of users, memory usage, alert log files, trace files, archive log files, system health for optimal performance.

Environment:

Oracle 11g/10g/9i, Oracle 11gR2/10gR2 RAC, IBM AIX, Sun Solaris, HP-UX PA-RISC/Itanium, Oracle Enterprise Linux, SQL Server, Oracle Clusterware, ASM, SFRAC, RMAN, HP Service guard, GoldenGate Replication, Grid Control, Data Guard, Korn Shell scripting, AccuRev

Confidential

Sr. ORACLE DBA

Responsibilities:

• Creation and Configuration of databases, Database sizing, formulating and implementing backup and recovery strategy.
• Responsible for administering and supporting production and development Oracle 10g Databases.
• Installed 2 Node RAC on Linux Environment.
• Routine maintenance, Performance monitoring and tuning.
• Managing database activities like number of users, memory usage, hit ratios, alert log files, trace files, archive log files, system health for optimal performance
• User maintenance and security audits, Creating and managing privileges roles to ensure the application / database security.
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Worked on Golden Gate Replication tool.
• Planning the backup policies and Backup/ Recovery of databases based on the criticality.
• SQL/PLSQL Statement tuning using Tkprof, Explain plan and Performance manager
• Resolve database performance issues and other distributed data issues.
• Worked on Solaris to AIX migration.
• Worked on Grid Control to monitor all the Databases centrally.
• Worked on Oracle Data Extraction and Transformation and loading.

Environment:

Oracle 9i/10g, SQLPlus, RMAN, IBM AIX 5.1, SQLServer2005.Data Guard.

Confidential

Sr. Oracle DBA

Responsibilities:

• Performed Database up gradation from 9i to 10g.
• Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data and monitored regularly whether primary and standby databases are in sync and clearing the backed up archive log files after confirming that they are applied on the standby database.
• Performed Monthly Cold Backup, Weekly Hot Backup and daily incremental backups using exp/imp, cold/hot backup, and RMAN backup technology.
• Involved in database re-architecture like moving to locally managed tablespaces, ASSM, relocating data files for better response time.
• Installed and configured OEM Grid Control to monitor all databases centrally.
• Intensively used latest 10g Automatic Workload Repository AWR Automatic Database Diagnostic Monitoring ADDM reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Developed shell scripts and automated nightly jobs using crone to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB's.
• Creating users, allocation to appropriate tablespace quotas with necessary privileges and roles for all databases.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: Database locking, Database corruption, Low disk spaces and Performance issues.
• Helping to the developing team and data warehousing team.
• Respond quickly and effectively to production development issues and taking responsibility for seeing those issues through resolution.
• Using SQLServer Design implement data models and database designs into physical databases.
• Managed backup and recovery of databases.

Environment:

9i, 10g Toad, SQL Plus, Oracle Enterprise Manager OEM , RMAN, Sun Solaris and Linux, SQL Server 2005

Confidential

Oracle DBA

Responsibilities:

• Installed and configured Oracle RDBMS on HP-UX and Linux environments.
• Responsible for administering and supporting production and development Oracle 9i Databases.
• Supported production and Non-production instances of Oracle Databases.
• Proactive monitoring and supporting development team..
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Managing, troubleshooting and resolving oracle database and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Used RMAN for fast backup strategy and Export and Import utilities for logical backup.
• Developing shell scripts for daily logical backups and batch jobs.
• Partitioned large tables to increase the performance and manageability.
• Evaluate and adjust Oracle database initialized parameters in init.ora file. Monitor and optimize database performance. Resolve all performance issues caused by historical Oracle architecture and application design.
• Created PL/SQL procedures jobs to automate maintenance tasks.

Environment:

IBM AIX, HP-UX, Oracle 10g/9i, Oracle 10g RAC, Oracle Clusterware, HACMP Cluster 5.3, GPFS, RMAN, Veritas NetBackup, Quest SharePlex, Korn Shell scripting, ASM, EMC

Confidential

DBA

Responsibilities:

• Development DBA and Jr. Production DBA
• Working with development team for writing SQL quires.
• Creating users and monitoring roles and level of access.
• Performed heavy data loads using SQL Loader.
• Modified and defined database objects as per requirements.
• Auditing databases using triggers.
• Application tuning using explain plan, Tkprof.
• Wrote procedures triggers and shell scripts.
• Refreshing of databases using Imp/Exp Utilities.
• Worked as PL/SQL Developer.

Environment:

SQL server 2003, Oracle 9i, UNIX, Linux, JAVA, JSP.