SUMMARY

• Nearly 11+ years of combined experience in the IT industry as Oracle DBA (8i, 9i, 10g, 11g, 11gR2, 12c).
• Experience in multiplatform UNIX, AIX, Linux, SOLARIS, Windows environments
• Strong experience of working in fast - paced, time constraint, deadline-oriented environments
• Excellent with very large data analytical skills.
• Strong experience of database physical and logical designing.
• Vast experience of installation, configuration of Oracle products on variety of platforms.
• High level designing of data migration and upgrade of databases.
• Vast experience of working in the production environment for large Organizations.
• Understand the need of high data availability and enhanced system I/O performance.
• Possess strong SQL performance tuning, database tuning skills.
• Strong diagnostic skills, AWR, ASH. Explain plan, sql query tracing
• Excellent SQL, PL/SQL Skills
• Strong Oracle RAC experience that includes the HLD of multi nodes in Linux environment.
• Strong Data Guard experience. Bothe physical and logical
• Excellent RMAN skills. Designing and implement back up and Replication strategy for large Databases.
• Excellent with Oracle Golden Gate.
• Strong replication experience using Materialized views.
• Excellent understanding of the Networking concepts
• Proficient in shell scripting, Perl programming, Vi editor and awk.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. Oracle DBA

Responsibilities:

• Responsible of providing Oracle DBA support to make sure the databases in the enterprise environment run Confidential the optimal level.
• Perform variety of tasks on daily bases that includes manage/monitor multiple database environments. We have RAC databases, Databases configured with Golden Gate, MVs, DataGuard.
• Several database monitoring/alert scripts are running that needed to be addressed if they send an alert. Diagnose/resolve issues/oras that ranges from user account issues, gather stats failed, node eviction in the RAC, out of sync data in GG to sever performance tuning issues. Work with app. ETL, SA teams proactively to avoid unplanned down time in the enterprise environments
• Create deployment plan to run in the production databases after successfully testing in the UAT.
• Provide support to junior DBA’s in running the deployment Plan
• Also provide support to diagnose/resolve day to day Database issues in the prod/dev/test env.
• Write pl/sql procedure, functions, triggers, packages to help resolve the issue that may impact the overall environment.
• Also set up, edit, manage, and monitor cron jobs.
• Make sure that the stats are gathered Confidential the schema level and table levels regularly to minimize the SQL performance issues
• Approach to use on performance tuning issues: Tune SQL and application code to reduce the logical demand eliminate contention points and bottlenecks, configure Memory to avoid I/O as much as possible, reduce waits for I/O.
• Use explain plan, tracing, AWR, SGA tuning, Server Memory, load, network traffic etc to help resolve performance issues.
• Perform replication, refresh databases and resolve issues related to data integrity.
• Data Replication using oracle Materialized views technology, and Oracle Golden Gate.
• Make sure that the weekly, monthly maintenance jobs are running.
• Also make sure that RMAN is backing up and valid copies of data is being archived
• Write triggers, sql procedures/packages to enhance the database integrity.
• Data pump, Import/export, to move data from prod/dev/test and vice versa
• Install configure Oracle 12c in the Linux environment.
• Use Toad, OEM, SQL Developer to manage the environment as well.
• Participate in daily chats and meetings; always keep in loop all the related team members to communication to inform and be informed about the hot issues.

Confidential, NJ

Oracle DBA

Responsibilities:

• Responsible of Plan of records, Special Orders for in Lab certification of custom deals.
• Responsible of Databases integrity in the enterprise environment.
• Responsible for database reliability, performance tuning and configurations. Data modeling, data transfer. Maintenance and upgrade of database.
• Physical and logical designing of Databases using Ervin, Toad’s Data modeling features.
• Setup Oracle environments on Linux, Windows, and Solaris platforms.
• Upgrade databases from 9i to 11g and 11gR2.
• Apply Cumulative Patch Update (CPU) and Critical Patch Update
• Lead a project to Install/configure the Oracle CRM SIEBEL 8.2.2 on Windows server 2008 (64) and also on the RHEL5 with Oracle version 11gR2
• Migrated Oracle Database running on 9i to Oracle version 11.1.2.
• Extensively provide support to junior DBAs handing the daily DBA’s tasks that can include minor oras such as ORA-01115 snapshot too old to more critical ones, also help in setting up user accounts, provide privileges by creating user profile, managing data security, apply patches and to issues related to more advance like out of sync data issues in case of GG replications.

Confidential, Oklahoma City, OK

ORACLE DBA

Responsibilities:

• Responsible of Oracle databases integrity and security/ Worked in the production environment to Install, upgrade, migrate, maintain, manage and monitor the critical databases running on AIX, Solaris, Windows and RHEL. As in the production environment the prime duty of any DBA is to ensure the availability, safety and reliability of business critical databases. Responsible to make sure that the Backups are running as per the agreement with the end client that is daily, weekly and monthly RMAN backups. Made sure that the maintenance jobs are running and if needed, modify the scripts to get the desired results. Extensively used OEM to manage the databases. Migrated databases running on Hp machine with OS: Windows, Oracle 9i to Dell,OS:RHEL5 to Oracle 11g,
• Accomplished several important tasks including the 2Nodes RAC implementation on Linux with ASM as shared storage, Data guard implantation. Migration of a database running oracle 9i to
• Install/configure Confidential DB2 databases,
• 11g in the AIX and Windows platforms.
• Upgrading, patching and refreshing of several databases running on variety of platforms.
• Worked on on call as primary POC as required by the Project manager.
• Resolved mission critical issues of severity 1/2/3.

Confidential, Dover, NJ

Oracle DBA

Responsibilities:

• 24/7 level 2/ Level 3 Production Database support for Critical Systems
• Worked as an Oracle SQL/PLSQL developer to help support the aplications
• Resolving Severity 1/ Severity 2 issues in production which can be of cluster issues, Performance related issues and explaining end users in simple terms
• Managing ASM, RAC, Data guard, Oracle Fail Safe Databases, worked on 8i, 9i, 10g on RedHat Linux Sun Solaris and Windows Configured private and public networks for the nodes. Used SAN technology for shared storage access in RAC on RHEL 4.
• Installations, upgrades and patching of Oracle Databases
• Cloning of Databases, Refresh of Databases
• Proactive monitoring and Performance Tuning of Databases
• Tuning queries effecting database performance, identifying indexes, partition of objects as part of tuning
• Managed Terra Byte Databases, Tablespace/Datafile management
• Reorganizing of Objects
• Resolving Backup and Recovery issues
• Installed Informatica 8.6.1 on Windows, Configured the repository and integration services.
• Change Ticket and Trouble Ticket Management
• Root Cause analysis Database failures and Oracle Internal Errors caused
• SR/TAR follow ups with Oracle
• Leading and Mentoring the Team
• Used Oracle stream to propagate events from one queue to another.
• Exploring new Oracle technologies
• Automating DBA and System Admin Tasks to simply management using Shell Scripts

Confidential, Edison, NJ

Sr. Oracle DBA

Responsibilities:

• Administration and configuration of RAC system.
• Automated alert management using Big Brother tool of Confidential .
• Rollback segment management for specific data-load jobs.
• Installation and configuration of database as per the application requirements.
• Handling the Application Emergency change management request for production database.
• Provide data using oracle Import and export utility to development team.
• Database Availability management handled with the auto alert messaging system.
• Deployment of data replication related backend scripts on the database and operating system.
• Creation of database indexes on certain tables to improve application performance.
• Performance tune oracle processes and objects
• Create and implement proactive performance tuning strategy using StatsPack Report and AWR.
• Extensive tuning of SQL using Explain Plan and Tkprof.

Confidential, Mclean, VA

DB Administrator

Responsibilities:

• Work as typical Oracle DBA. Creating, managing monitoring and perform maintenance jobs to mission critical Databases. Make sure that the daily operations relating to databases running in the production are running Confidential the optimum level. Managing user profiles and make sure that any level the database security is not compromised.
• Help diagnose, resolve performance related issues.
• Apply patches to the Database. Doing backups. Resolving the performance tuning issues.
• Continuous monitoring of alert log file
• Backups using RMAN recovery catalog database.
• Bench Marking of Performance Tuning using Statspack.
• Creation of database indexes on certain tables to improve query performance.
• Extensively involved in maintaining and updating the database documentation.
• Reorganizing the data using Export/Import
• Auditing the database for collecting statistics on database usage.
• Managing Rollback segments.
• Writing PL/SQL stored procedures and functions to meet new features to be incorporated in the system to implement business rules.
• Creating users and assignment of profiles
• Work as part of a team and provide 24 x 7 supports.
• Excellent Oracle 8i,9i,10g and 11g skills
• Excellent work experience of RAC.
• Excellent with Data guard.
• Excellent Oracle Streams skills
• Strong RMAN skills
• Proficient with Export/import and data pump Export/Import
• Strong oracle stream and AQ experience
• Responsible for Installation, configure and trouble shoot of oracle databases and evaluation of the hardware for the OLTP and DSS database servers on HPUX/UNIX/SOLARIS/NT.
• Planning and designing databases including designing local structures and forecasting further expansions (CAPACITY PLANNING). Experience in administering the production database
• Excellent with TOAD.
• Monitoring & Tuning database performance using Statspack and OEM for optimization of resource utilization on server.
• Extensive working knowledge of TKPROF, and AWR required for application tuning.
• Manage Tablespaces, Rollback Segments, Redo Logs and other database objects.
• Use Import, Export, SQL*Loader and other tools to load data.
• Database Recovery (both complete and incomplete) from media failure.
• Apply patches and upgrades for Oracle databases
• Created and maintained Standby database for minimum downtime.
• User management and work as part of a team and provide 24 x 7 support of type on-call and operations
• Configuring and Use of health monitoring and alerting tools like Bmc patrol, Magic, Fog Light etc
• Implemented Security administration by creating of roles, views and granting the necessary object/system privileges for users
• Implemented Replication using UNIX scripts and SQL*Loader to populate the Oracle Database Tables from DB2 Data.