SUMMARY:

• 10 plus years of strong Oracle RAC DBA experience, administering production and non production databases. Having in - depth knowledge of oracle architecture and oracle internals.
• Configured 10gRAC on HP EXADATA.
• Configured and administered Cassandra databases.
• Configured and administered PostgreSQL databases.
• Configured 11gRAC on ODA (Oracle Database Appliance).
• Configured 11g physical and logical standby databases(DataGuard).
• Has Strong knowledge in Performance Tuning of databases and fixed many complex performance related issues.
• Administered MySQL and SQL SERVER databases.
• Strong knowledge of RMAN Backups and Recoveries.
• Versatile team player with excellent presentation, communication and inter personal skills.
• Configured OEM Grid.
• Created physical and logical data models using DBArtisian and Erwin.
• Proficient in UNIX shell scripting.
• Experience on Golden gate environment.
• Good at writing PL/SQL procedures.
• Knowledge of MongoDB.
• Good at Erwin to design data model.

TECHNICAL EXPERTISE:

Databases: Oracle 8i, 9i, 10g, MySQL 5.0, 11.2.0.3, 12c (12.1.0.2)

RAC: Oracle 10.2.0.3.0 , 11.2.0.3

Operating Systems: UNIX (Sun Solaris 5.0, IBM AIX, HP UNIX 10.x/11.0/11.x, Linux), Windows XP/98/NT/2000

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, Perl Scripting, MS-DOS Batch Scripts, COBOL, C

Applications/Web Servers: Clarify, Oracle 9i AS R1 (V 2.0.2.2.1), Web Sphere, Oracle 10g AS R2 (10.1.2), Apache Web server 2.0, IIS 5.0, Tomcat 5

Packages & Tools: ER/Studio, XML/DB, Erwin, TOAD, DBArtisan, OEM

WORK EXPERIENCE:

Confidential, Rockville, MD

Sr. Oracle DBA

Responsibilities:

• Worked on database refreshes.
• Fixed disk space issues on production servers.
• Monitored production databases.
• Analyzed available databases scripts such as RMAN and datapump scripts.
• Analyzed cron jobs on production databases.
• Worked on fixing dataguard issues on Oracle RAC.
• Worked on designing data models for AWS databases.
• Created physical and logical data models.
• Worked on creating 12c databases on Amazon AWS.
• Scheduled database backups.
• Fixed performance issues on 12c on AWS.
• Worked on creating logical and physical data models using DBArtisian and Erwin.
• Applied latest cpu patches every quarter.
• Worked on designing database model for Cassandra cluster.
• Installed Cassandra and created cluster on Linux and AWS.
• Installed Cassandra and created cluster on windows.
• Worked on CQL.
• Configured backups on keyspaces.
• Fixed performance tuning issues on Cassandra cluster.
• Worked on creating cron or bash scripts.
• Applied network listener patches.
• Worked on DEV/TEST/PROD deployments for many applications.
• Configured scheduler jobs.
• Worked on rebuilding standby databases on RAC environment.
• Worked on Jira tickets on daily basis.
• Worked on revoking database privileges and database encryption as per the GAO findings.
• Worked on Oracle database security and database wallet.
• Rebuilding the indexes at regular intervals for better performance in SQL Server databases.
• Created complex stored procedures, triggers, cursors, tables and other SQL Joins and statements for applications by using T-SQL.
• Handled monthly database refresh in QA-Test environment for testing of new deployments and build.
• Was responsible for SQL DBA jobs like Backups and Restores.
• Worked on Jira tickets on daily basis.
• Worked on weekends to support deployments and production db issues.
• Installed PostgreSQL database and worked on database administration of databases.
• Installed MongoDB.

Confidential, Washington, DC

Senior Oracle DBA

Responsibilities:

• Worked on Migration project, upgrading 8i database to 11g on siebel application.
• Created users and roles.
• Worked on creating Cassandra cluster on CentOS and Linux.
• Worked on Perl scripts.
• Administered and performance tuned Cassandra clusters.
• Has knowledge of Sybase database.
• Worked on refreshing the databases on different environments.
• Fixed performance issue by increasing memory on PGA AGGREGATE TARGET initialization parameter.
• Created databases on Windows servers.
• Has knowledge of Splunk.
• Worked on writing PL/SQL packages and procedures.
• Worked on rebuilding indexes.

Confidential, Tysons Corner, VA

Senior Oracle DBA

Responsibilities:

• Worked as production database support, monitoring and administering production databases.
• Worked on creating 12c databases.
• Worked on setting datawarehouse setup using PL/SQL procedures and triggers.
• Worked on datawarehouse reports.
• Worked on writing SQL reports for in house data reports.
• Worked on creating data encryption functions to encrypt application users password.
• Worked on creation database reports with encrypted data for some of the columns.
• Worked on writing PL/SQL packages and procedures.
• Worked on installing oracle XML db on 11g.
• Worked on performance tuning to fix performance issues on XML database.
• Worked on creating users in XML db.
• Worked on creating procedures and triggers in XML databases.
• Worked on sql reports, sql functions on XML databases.
• Worked on setting AUDIT on databases with respect to FEDRAMP, program.
• Worked on monitoring and configuring Data Guard.
• Worked on refreshing production data to development, QA and staging environments.
• Worked on Performance Tuning to resolve performance issues.
• Worked on 11g Installation and database creation.
• Worked on configuring Oracle 11g two node RAC database on ODA (Oracle Database Appliance)
• Designed and implemented SQL Server database changes.
• Reviewed and tuned SQL queries, stored procedures, views, triggers in SQL Server databases.
• Worked on installation of 2008 SQL Servers.
• Installed and created PostgreSQL databases.
• Created users, roles and granted privileges.
• Managed health of SQL Servers including backups, restores and monitoring.
• Worked on database recovery.
• Worked on database upgrade from 10g to 11g.
• Created materialized views.
• Worked with application team for crating tables and database objects for quarterly production releases.

Environment : Oracle Linux, Sun Solaris, Oracle 10.2.0.3, 11.2.0.3, 12.1.0.2, ODA RAC, PostgreSQL

Confidential

Oracle DBA, Tysons Corner, VA

Responsibilities:

• Working as production database support monitoring production databases.
• Working on deploying tickets on daily basis.
• Worked on refreshing production data to development by making use on rman duplicate command or rman cloning.
• Applied October 2009 CPU patches to databases.
• Provide 24 x 7 supports as an on-call DBA on rotational basis.

Environment : Linux, Sun Solaris, Aix, Oracle 11.1.0.6.0 , 10.2.0.3,postgreSQL

Confidential

Oracle DBA, Manassas, VA

Responsibilities:

• Monitored more than 25 production databases.
• Administered databases of gigabytes in development, QA and production environments.
• Involved in refreshing production data to development and QA environment to keep development data in sync with production data by making use of expdb/impdb & RMAN transportable tablespace.
• Worked on configuring Golden Gate setup.
• Configured 11g RAC with ASM on 2 nodes on HP EXADATA.
• Involved in applying CPU patches.
• Configured or set notification alert in Grid control to send emails with different metrics.
• Involved in upgrading databases from 9i to 10g.
• Installed oracle software on new servers and created databases on them.
• Configured Streams replication.
• Worked on monitoring MySQL databases.
• Involved in rebuilding indexes.
• Involved in solving ORA errors like snap shot too old error, unable to extend temporary tablespace etc.
• Restored and recovered database using RMAN.
• Has a ticketing system and will work on tickets assigned to me.
• Edited some of the already available scripts.
• Provide 24 x 7 support as an on-call DBA on rotational basis.

Environment : Linux, Sun Solaris, Oracle 11.1.0.6.0 , 10.2.0.3, 10.1.0.4.,HP EXADATA.

Confidential

Oracle DBA, Jersey City, NJ

Responsibilities:

• Administered 30+ databases of gigabytes in development, testing and production environments.
• Provide 24 x 7 supports as an on-call DBA on rotational basis.
• Implemented oracle 10g RAC with ocfs2 and oracle 10g RAC on Linux with A.S.M .
• Cloned databases from production environment to other environments.
• Perform regular space management tasks to ensure enough disk space.
• Involved in applying latest CPU patches.
• Involved in administrating MYSQL databases such as creating databases, users, tables, performing backups.
• Involved in migrating some MYSQL tables and oracle tables into oracle database.
• Involved in upgrading databases from earlier version to oracle 9i/10g.
• Monitored and optimized database performance using tools like STATSPACK, SQL tuning advisor, Tkprof , explain plan, auto trace utilities and SQL scripts.
• Set up replication on MYSQL master and slave.
• Involved in administration of MYSQL databases.
• Data warehouse DBA skills related to partitioning and materialized views.
• Involved in designing and implementing backup strategies for production databases.

Confidential

Oracle DBA, Jersey City, NJ

Responsibilities:

• Involved in the i nstallation , configuration and u pgrading of the oracle database to 9i &10g.
• Involved in maintenance of separate production/quality/development/test databases and monitoring health check on daily basis
• Developed PL/SQL procedures , triggers, packages and dynamic SQL scripts
• Involved in implementation of backup and recovery policies and procedures.
• Was involved in cloning of production database to the test environment using recovery manager (RMAN).
• Involved in creating roles and user administration.
• Monitored and optimized database performance using tools like STATSPACK, Tk-prof, explain plan and SQL scripts.
• Involved in writing Perl scripts.
• Assisted the Sr.DBA in database administration and performance tuning.
• Maintaining the space requirements, tablespace management.
• Created and developed UNIX shell scripts for automating backups and weekly cleansing scripts and scheduled them through cronjob.
• Involved in creating users and granting privileges to them.
• Implemented oracle 9i physical standby data guard for the production database running on oracle 9i as a recovery solution.
• Involved in killing the session which were taking much cpu spikes.
• Resolved tickets on priority basis.
• Provided 24x7 on call support on a rotational basis.

Confidential

Oracle DBA

Responsibilities:

• Offline OS backup of Application/Database
• Online logical backup of Entire Database / User Schema
• Generate weekly reports on data integrity
• To ensure utmost accuracy of financial transactions and completeness of data entry.
• Managing users accounts Creating New Roles / Users / Profiles.
• Granting access on tables/views depending on job they do
• Managing tablespaces Dropping / Creating Tablespaces.
• Modifying Storage Parameters for Tablespaces depending on application requirement
• Managing Rollback segments. Dropping/Creating Rollback segments with appropriate storage parameters to reduce waits.
• Designing Data storage for New Applications database Tuning. Identifying and resolving contention with respect to Disk IO, Redo Logs and Rollback

Confidential

Jr.Oracle DBA/Developer

Responsibilities:

• Managing the databases remotely using VPN Client.
• Oracle Installation, Configuration management, Security and Monitoring, Backup and Recovery and Troubleshooting.
• Re-designed for new architecture, developed, customized and implemented the merchant rebate program.
• Allocation of system storage and planning future storage requirements for the database.
• Enrolling users and maintaining system security.
• Developed stored procedures and Database triggers.
• Participated in Tuning SQL queries for better performance, response time using indexes.