SUMMARY

• Over 8 years of experience as a IT Professional having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, Unix shell scripting and documentation.
• Experienced in working on Oracle, Cassandra and MS SQL Server databases.
• In - depth noledge in Designing, Installation, Administering, Implementation, Configuring, Troubleshooting, Performance and Fine tuning of Oracle Databases.
• Worked with Oracle Databases (12c,11g/10g) on Unix/Linux/Windows platforms.
• Planned and implemented DR & high availability solutions using Oracle 11g RAC & 10g RAC, Standby Database (Oracle Data Guard).
• Experience in trouble shooting RMAN issues in performing the Backup and Recovery process.
• Experienced in using Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Worked on database recovery techniques and implementation of those recovery techniques to ensure business continuity.
• Excellent noledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN and manual methods.
• Performing daily activities and troubleshooting the database issues using OEM Grid control.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, SQL TRACE, custom scripts troubleshooting oracle databases using sqltrace utilities.
• Has good Working noledge of disaster recover models with experience in implementation and recovery of Oracle databases and RAC clusters.
• Good experience on Oracle Support processes for technical requests through Metalink and other Support Procedures
• Experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools.
• Worked on all backup and restore scenarios for SQL Server databases.
• Upgrading Datastax Enterprise Cassandra versions for stability and performance.
• Excellent noledge on CQL (Cassandra Query Language) for obtaining the data present in Cassandra clusters.
• Strong Knowledge in installing multi-data center and multi-rack Cassandra cluster.
• Extensive noledge on Cassandra database architecture with good understanding of read and write processes including SSTable, Mem-table and Commit log.
• Proven ability to adapt to demanding schedules and changing priorities and ability to function successfully in a highly stressful and critical environment.
• Strong analytical and problem solving skills with ability to work within team environment and independently when needed.

TECHNICAL SKILLS

Operating Systems: HP-Unix, Sun Solaris, AIX 5.3. Red Hat Linux RHEL 7.0 and Windows.

RDBMS: Oracle 12c,11gR2, Oracle 10g, Oracle 9i, Oracle Gloden Gate 11.2.1, Oracle 11g (RAC), Oracle 10g (RAC). SQL Server 2008, 2012.

NoSQL Databases: Cassandra.

Cloud Technology: Amazon web Services (AWS), EC2 cloud.

s: DataStax Certified Professional on Apache Cassandra.

AWS Solutions Architect Associate.: Oracle Database 11g Administrator Certified Professional.

Languages: SQL, CQL, UNIX Shell.

Tools: RMAN, OEM, EXP, IMP, EXPDP, IMPDP, TOAD, OPS CENTER

Tools: /Utilities: Putty, Super Putty OEM GRID, SSH, WinSCP, Explain Plan, AWR.

PROFESSIONAL EXPERIENCE

Confidential, Piscataway, NJ

Database Administrator - IV

Responsibilities:

• Provide support for ORACLE, CASSANDRA and SQL SERVER and Databases.
• Designing, Install, configure and maintenance of Oracle Databases.
• Worked on Oracle Tech refresh’s from 11g to 12C databases.
• Working with Development and solution Architect Teams for Data Modelling on Oracle DB’s.
• Participated in designing and building OEM environments.
• Writing UNIX shell scripts for backup and recovery, import and export procedures.
• Provided disaster recovery, performance analysis and tuning, index maintenance, and monitoring of data. Maintain and implement policies for ensuring the security and integrity of the database.
• Troubleshooting issues and tune memory parameters on Oracle DB’ for better performance.
• Develop scripts for Startup and Shutdown and Health Check reports for Oracle Databases.
• Migrating data from oracle database to EC2 instances.
• Involved in the Performance and Load Test for Oracle Databases.
• Created and maintained multiple oracle DB’s on AWS.
• SQL scripts to monitor Table spaces and Extent growth.
• Cloned environments to create patch test, development and QA environments for ORACLE and SQL SERVER databases.
• Providing support for Production and Non-production Sql Server Database’s.
• Provided support for user and space management for SQL Server Database’s.
• Coordinating with System Admin and Middleware Teams for smooth implementation of production Tasks.
• Provide ON-Call support for ORACLE, Cassandra and SQL and Databases.

Environment: Cassandra 4.8.14,Spark,OPSCenter 6.0.9,Oracle 12c,11g R2, RAC/11g, ASM, HP-UX, AIX, Sun Solaris, Red Hat Enterprise Linux, SQL SERVER 2008-R2,2012 OEM, Explain Plan, Tkprof.

Confidential, Charlotte, NC

Senior DBA Analyst

Responsibilities:

• Involved in 24x7 support for Production database and applications with on-call pager.
• Installation and creation of 11g RAC databases for Testing, Development and Production.
• Supported upgrades from oracle 11g to 12c.
• Performed migration from 10g to 11g.
• Supported development, implementation and maintenance of sql server database.
• Supported migration, and performance tuning on sql server database.
• Installed and configured oracle 11g RAC for high availability.
• Data Refresh from Production to Test and Development environments using manual method and RMAN Duplication.
• Participated in designing and building OEM environments.
• Proficient in using OEM and grid control.
• Resolving Performance issues.
• Performed disaster recovery and provided business continuity plan for development and production environments.
• Implemented necessary monitoring scripts for Oracle in unix scripting.
• Performance tuning for optimized results using tools like AWR,SQL TRACE,TOAD.
• Setup of Standby Database(Data Guard). Performing Failover and Switchovers.
• Scripts for Cold Backup, Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Installation and configuration of Oracle Client software and Tools.
• Writing UNIX shell scripts for backup and recovery, import and export procedures.
• Automating the Database Maintenance tasks using PowerShell scripts.

Environment: Oracle 11g R2,Oracle Glodengate 11.2.1, RAC/11g RAC/10g, ASM, HP-UX, AIX, Sun Solaris, Red Hat Enterprise Linux, OEM, Explain Plan, Tkprof.

Confidential, Framingham, MA

Sr. Oracle DBA

Responsibilities:

• Apply patches every quarter released by oracle for stand-alone and RAC Instances.
• Strictly adhere to SLAs defined for Incidents, SRFs and Database refresh from production to Non-production environments.
• Excellent client facing and presentation skills.
• CPU patching (EMPTY HOME and IN PLACE) for stand alone, RAC databases.
• Performance tuning using various tools like OEM, AWR, ADDM .
• Worked on Oracle Binaries Installation.
• Worked on Database Up-gradation.
• Worked on User Management.
• Involved in Space Management and Capacity Planning.
• Roles, Privileges, space management and configuring database listeners.
• Monitoring critical grid alerts and alert log for Critical databases.
• Excellent planning and management of deliverables assigned.
• Identifying and resolving Locks issues.
• Creating service request (SR) with oracle support for critical issues.
• Creating and implementing change requests.
• Providing 24x7 support and On-call Support.

Environment: Oracle RAC, 11G r2,10G,ASM,AIX,Hp-unix,Sun Solaris, Red Hat Enterprise Linux.

Confidential, Wilmington, DE

Sr. Oracle DBA

Responsibilities:

• Installation of Oracle Database servers.
• Oracle 10g, 11g Standalone Installations and configuration on AIX machine.
• Database Migration from source to target using RMAN, EXPDP.
• Data Pump (EXPDP/IMPDP) Usages for schema backup and refresh.
• Troubleshooting the issues while installation.
• Oracle Client Installation on Windows application server.
• Roles, Privileges, space management and configuring database listeners.
• Generating AWR report for performance analysis
• Using OEM console to monitor database.
• Planning and scheduling backups using Crontab (UNIX) and Scheduler (Windows)
• Creation of DB LINKS
• Monitoring and optimizing Performance of the Database
• Creating and designing schemas as a part of development.
• Creating, Handling, Closing of SR’s for several issues
• Creating and maintaining the change record for the migration.

Environment: Oracle 11g/10g,IBM AIX, Sun Solaris, Red Hat Linux, Windows 2003, SQL*Plus, Grid Control, TOAD.

Confidential

Software Engineer Trainee

Responsibilities:

• Installation and Configuration of Oracle 10g RAC.
• Primary point of contact for client for production database support.
• Performed database cloning to setup test and development database.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Proactive database monitoring using 10g grid control.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth.
• Upgraded Oracle 8i, 9i databases to Oracle 10g.
• Applied patches to Oracle Databases.
• Monitoring Growth of tables and undertaking necessary re-organization of database objects as and when required.
• Oracle Database monitoring, troubleshooting and resolved the issues.
• Management of schemas, objects partitioning the tables & indexes.
• SQL tuning using Statspack, AWR, Explain plan, Tkprof.

Environment: Oracle 10g/9i,IBM AIX, Sun Solaris, Red Hat Linux, Windows 2003, SQL*Plus, Grid Control, TOAD

Confidential

Executive Intern

Responsibilities:

• Provided support for all the databases as an operational database administrator.
• Installed and configured Oracle 9i databases.
• Implement Hot, Cold and Logical backup plans.
• Frequent Database audits to ensure the SOX standards were not violated.
• Proactive database monitoring using automated scripts.
• Regular monitoring of batch jobs.
• Creating and maintaining the change record for the changes dat were being made on the Production databases.
• Maintaining the Light Weight Document Management System.
• Strong communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.

Environment: Oracle 9i, SQL,Windows,Red Had Linux.