SUMMARY

• 10 plus years of strong Oracle DBA experience, administering production and non production databases. Having in - depth noledge of oracle architecture and oracle internals.
• Oracle 9i oracle certified professional.
• Oracle 10g RAC Certified Professional.
• Experienced on installation, configuration with OracleOEM(10g to 12c).
• Configured 10gRAC on HP EXADATA.
• Involved in different scenarios of OLTP as well as DSS (Data warehouse) databases.
• Configured 11gRAC on ODA (Oracle Database Appliance).
• Configured physical and logical standby databases (DataGuard).
• TEMPHas Strong noledge in Performance Tuning of databases and fixed many performance related issues.
• Installation, configuration and administrating Oracle GoldenGate replication.
• Administered MySQL databases.
• Involved in setting up Replication between Master and slaves.
• Strong noledge of RMAN Backups and Recoveries.
• Versatile team player with excellent presentation, communication and inter personal skills.
• Configured OEM Grid.
• Proficient in UNIX shell scripting.
• Experience on GoldenGate environment.
• Good at writing PL/SQL procedures.
• Good at Erwin to design data model.

TECHNICAL SKILLS

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, DataModler, OEM

PROFESSIONAL EXPERIENCE

Confidential, Rockville, MD

Sr. Oracle DBA

Responsibilities:

• Worked on daily health check of production and pre-production databases.
• Daily verification of dataguard sync and analyzed alert logs.
• Worked on Jira tickets to create database objects.
• Worked on refresh of database from production to non-prod using table exists action datapump parameter to refresh teh schema without dropping and recreating teh schema with REPLACE option.
• Monitored different prod and non-prod databases.
• Monitored MSSQL server databases.

Confidential, Washington, DC

Sr. Oracle DBA

Responsibilities:

• .Worked in refreshing databases from production to non-production databases.
• Worked on SIEBEL application on migration project to migration databases from 8i to 11g.
• Created application procedures and functions.
• Created database links and database objects.
• Worked on fixing performance issue by increasing PGA AGGREGATE TARGET parameter.
• Worked on rebuilding indexes.
• Involved in meetings with data modelers, developers, and dba’s.
• Monitored all teh 11g databases on Red Hat Linux environments by using OEM 11g and 12c.

Environment: Oracle 8i,Oracle 11g, Windows and linux.

Confidential, Vienna, VA

Sr. Oracle DBA

Responsibilities:

• Worked as production database support, monitoring and administering production databases.
• Worked on creating 12c databases.
• Worked on setting Data Warehouse setup using PL/SQL Procedures and triggers.
• Worked on Data Warehouse 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 teh columns.
• Worked on writing PL/SQL packages and procedures.
• Monitored all teh 11g databases on Red Hat Linux environments by using OEM 11g and 12c.
• Worked on setting AUDIT on databases with respect to FEDRAMP, program.
• Worked on monitoring and configuring DataGuard.
• Worked on refreshing production data to development, QA and staging environments.
• Fixed different performance issues on production databases.
• Worked on 11g Installation and database creation.
• Performed extensive data modelling to differentiate between teh OLTP and Data Warehouse data models.
• Worked on configuring Oracle 11g two node RAC database on ODA (Oracle Database Appliance)
• 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.
• Was on call supporting databases on off hours and on weekends.

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

Confidential, Vienna, VA

Sr. Database Administrator

Responsibilities:

• Worked as production database support monitoring production databases.
• Worked on deploying tickets on daily basis.
• Involved in database design using Erwin and Relational/OLTP Modeling.
• 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

Confidential, Manassas, VA

Oracle DBA

Responsibilities:

• Monitored more TEMPthan 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.
• 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.
• 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.
• TEMPHas a ticketing system and will work on tickets assigned to me.
• Edited some of teh already available scripts.
• Provide 24 x 7 supports 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, Jersey City, NJ

Oracle DBA

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, Jersey City, NJ

Oracle DBA

Responsibilities:

• Involved in teh installation, configuration and upgrading of teh 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 teh 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 teh Sr.DBA in database administration and performance tuning.
• Maintaining teh 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 DataGuard for teh production database running on oracle 9i as a recovery solution.
• Involved in killing teh 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 teh 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 teh merchant rebate program.
• Allocation of system storage and planning future storage requirements for teh 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.