Career Objective

I am seeking a challenging position with a progressive organization which will utilize my technical skills, experience, abilities and education, providing me with an opportunity to learn for continuous professional growth while achieving the goals of the organization.

Professional Synopsis

• An astute Oracle DBA with around 8 years IT experience in Oracle products, both production and development environments spanning several industries: health care, telecom, financials, and high tech.
• Hands on experience in test, production and development databases.
• Worked as a team member to provide 24x7 on-call production database support.
• Extensive knowledge on database administration for Oracle 8i, 9i ,10g and 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• 2 years of RAC (10g and 11g) with proficiency in setting up and administering 11g RAC.
• Extensive knowledge in reporting tools like Business Objects and crystal reports.
• Extensive knowledge and experience on Data Warehouse using ETL tools like informatica, Ab Initio.
• Experience in a variety of hardware platforms including; MS-Windows 2000, 2003, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like ESTAT/BSTAT, Statspack, Tkpfof, Explain plan, Analyze and AWR
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS)
• Expertise in Oracle Enterprise Manager (OEM).
• Experience in Handled Large DB (4 TB)
• Extensive knowledge on database backup/recovery strategy (RMAN),Import/Export & Datapump,Capacity Planning, Replication (Streams) standby databases, Oracle configuration management, Dataguard, database cloning, refresh and patch management
• Extensive knowledge in Korn shell and Perl scripting.

Certifications

• Oracle Certified Professional
• Oracle Certified RAC Administrator

Skill Set

Programming Languages : C, T-SQL, PL/SQL, VB, Shell programming
Reporting tools : Crystal Reports, Business Objects 
Design Tools : Erwin, Oracle Enterprise Manager
Database Systems : ORACLE 8.x/9i/10g,11g, SQL Server 98/2000, MS-Access.
Operating system : UNIX, Sun Solaris 5.6/5.8/5.9, AIX 6.1, Solaris, HP-UX 11.0, Windows NT/95/98/2000/XP/2003 
ETL : Informatica , Datastage
Data Modeling : Erwin, Model mart.

Experience

Client: Confidential,Shelton CT July’11- Till date

Confidential serve individual and institutional customers worldwide and include The Prudential Insurance Company of America, one of the largest life insurance companies in the U.S.
Responsibilities:

• 24x7 production database administration.
• Involved in administration of over 100 Oracle instances.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Involved in team management, team building exercises for the DBA team.
• Converted a single instance database to Oracle RAC 11g.
• Installation, Configuration and Administration of Oracle 11g RAC.
• Configured the Public Network/Private Interconnect for Oracle 11g RAC.
• Creation and configuration of Standby Database (Data Guard).
• Involved in RAC administration including 11g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Wrote several shell scripts for checking Oracle errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application of patches.
• Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Creating tablespaces, sizing the system tablespace, allocating default tablespaces for users.
• Creating tables and indexes, sizing their extent, partitioning and so on.
• Creating users with restricted access, with default and temporary tablespaces.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Monitoring the table growth, database growth, current users, and system resource usage and so on.
• Knowledge in writing shell scripts for automating backups and restoration.

Environment:HP-UX 11, Sun Solaris , Linux,IBM–AIX 6.1 Oracle 10g/11g, Oracle 10g,11g RAC, ASM,Shell Script

Client : Confidential,MI Jan’11- July’11

Role: Oracle Database Administrator

Application loads the millions of transactional data every day. It is using online web application to upload the data to process these many transactions. This process performs around ten steps of validation before loading the data into server. This application also allows user to manipulate the data and make the process of loading automatic or manual.

Responsibilities:

• Involved in administration of over 15 Oracle instances.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Involved in team management, team building exercises for the DBA team.
• Creation and configuration of Standby Database (Data Guard).
• Cloning of application from production environment to test environment and application of patches.
• Worked on Data pump (Expdp / Impdp), Import / Export.
• Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Creating tablespaces, sizing the system tablespace, allocating default tablespaces for users.
• Creating tables and indexes, sizing their extent, partitioning and so on.
• Creating users with restricted access, with default and temporary tablespaces.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Sizing the SGA, db buffers, shared SQL area, log buffer based on the requirements.
• SQL issues and Tuning Considerations for Different Applications.
• Monitoring the table growth, database growth, current users, and system resource usage and so on.
• Experience in SQL*Loader, loading data from text files.
• Knowledge in writing shell scripts for automating backups and restoration.

Environment:HP-UX 11, Sun Solaris , Linux,IBM–AIX 6.1 Oracle 10g/11g, Oracle 10g,11g RAC, ASM,Shell Scripts.

Client: Confidential,Fort lauderdale,FLDec’09- Nov’10 

Role: Oracle Database Administrator

Confidential is a quality & ethical provider of blood components, laboratory services, transfusion medicine and therapeutic blood services across FLORIDA.The goal of the project is to Performance tuning the Oracle Production Database.

• Involved in administration of over 10 Oracle instances.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Involved in team management, team building exercises for the DBA team.
• Installation, Configuration and Administration of Oracle 11g RAC.
• Involved in RAC administration including 11g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
• Worked on Data pump (Expdp / Impdp), Import / Export.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Creating tablespaces, sizing the system tablespace, allocating default tablespaces for users.
• Creating tables and indexes, sizing their extent, partitioning and so on.
• Creating users with restricted access, with default and temporary tablespaces.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• SQL issues and Tuning Considerations for Different Applications.
• Monitoring the table growth, database growth, current users, and system resource usage and so on.
• Experience in SQL*Loader, loading data from text files.
• Knowledge in writing shell scripts for automating backups and restoration.

Environment:HP-UX 11, Sun Solaris , Linux,IBM–AIX 6.1 Oracle 10g/11g, Oracle 10g,11g RAC, 9.2.x, Shell Scripts.

Client: Confidential, NewYork. Mar’08- Nov’09 

Role: Oracle Database Administrator

Trade completion system was involved in enriching the trade information which was received from the “Trade order management system”. The system was responsible for calculating the various costs and brokerages involved with the processing and execution of the trades, interactions with various ECN (Electronic clearing system) and trade settlement systems. The system had various batch and intraday processes for clearing and post trade end of day reconciliations. The system implements the business logic for post trade processing, allocation, clearing and settlement

Responsibilities:

• Review of Database logical and Physical design.
• Install, upgrade and maintain Oracle 9i on, Sun Solaris and Windows 2003, Redhat4
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security
• Have created database on SQLsqrver2005, backup and recovery.
• Database Restore using RMAN, Cold Backup and Export.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Problem analysis involving interactions/dependencies between UNIX and Oracle.
• Performed Data Migration as a part of enterprise data warehouse project.
• Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
• Extensive Performance Tuning, Memory (SGA) Tuning, RAC tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data guard.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Performed scheduling Control-m for scheduling jobs.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Developed tools to migrate the data from legacy systems to oracle database.
• On-Call 24x7 DBA support for very large databases.

Environment: Oracle 10g/9i, Java, SQL, PL/SQL, Toad, Pl/SQL Developer, Erwin, O/S: RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, ASM Packages

Client: Confidential,NJ Jan’06- Feb’08 

Role: Oracle Database Administrator

Confidential is information relating to a customer\'s telecommunications or voice service that only the customer or the customer\'s telecommunications carrier would possess. CPNI includes information typically available from details on a customer\'s monthly telephone bill, including: the type of line, technical characteristics ,class of service, current telephone charges, long distance and local service billing records, directory assistance charges, usage data and calling patterns

Responsibilities:

• Installation and Configurations of Oracle 10g and 9i on Linux Red Hat.
• Responsible for administration and supporting Oracle 9i and 10g databases.
• Upgradation and migration from Oracle 9.2.0.8 databases to Oracle10.2.0.3.
• Experience in OSA (Oracle Sales Analyzer) and OFA (Oracle Financial Analyzer).
• Designed and implemented database schema (logical and physical data models).
• Write scripts for Oracle Database security, creation of users, creation and assignment of roles, analyze space requirements and maintain tablespaces, creation and maintenance of tables and indexes.
• Experience in working Data Guard execution.
• Creating primary database objects (tables, views, indexes) once application developers have designed an application.
• Configuring ODBC, to enabling networking between the Database Server and Clients
• Handling large database environments Dataware Housing, Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and keep running.
• Responsible for online and offline backups and recoveries of the oracle database.
• Creating and rebuilding indexes and optimizing the code to improve the performance after analyzing the trace files.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Statspack, Explain Plans and monitor the database performance on daily basis. Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters.
• Troubleshooting errors that occurs one daily basis and resolving problems quickly and efficiently and giving suggestions to developers when they are required for tuning the code to maximize performance of the database.

Environment: AIX, HP -UX, Windows NT/2000, Oracle 10g/9i, SQL plus, OEM, TOAD, Red Hat Linux, Sun Solaris.

Client: Confidential Aug’04 – Oct’05

Credit Information System 
The system has centralized database to maintain all relevant information regarding Credit Information. The transaction data will be ported to this centralized database from the branches either through data import or through manual entry. The system allows the user to generate various kinds of reports and queries.

• Master Information
• Transaction entry
• Data import
• Report module
• Query module

Responsibilities:

• Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL.
• Used SQL* Loader to load data into different tables.
• Mapping Operational Repository to Business Repository elements and incorporating the build rules.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Extensively used PL/SQL to extract data from different tables with 20 Million records in some of the tables
• Based on the user selection and finally storing the output as a flat file for further processing for the next module.
• Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used.
• Incorporated validation rules for promotion history table and updating tables.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes. 
  Generated PL/SQL reporting and Unix Scripts to notify process failure/success.

Environment: Oracle 8i, PL/SQL, SQL*Plus, Exp, Imp and Windows NT.

Educational Credentials

Bachelor of Engineering from Confidential University .