AddThis Social Bookmark Button
Nitin Sharma ( Available )
Richmond, Virginia - 23228 USA
Expertise :Expertise in Database Installation , Configuration on Database designing, setting up the complete Database with Security Implementation
Job Type :
Contract - W2
Position :Management Occupations, Installation, Maintenance, and Repair, Production

Resume
 
Objective




A position as Oracle Database Administrator where my Technical, Database management and performance Tuning skill is giving value to improve IT process, architect, design and setup ERP landscapes and provide superior customer services. Over 9 9 years of experience in the Information Technology field as Oracle database administration. experience in Database Installation, Configuration on Oracle. Good experience in Database designing, setting up the complete Database with Security Implementation, troubleshooting Oracle Technologies as Oracle DBA, Successfully performed the role as Database Administrator, Team player with good presentation and communication skills to provide support to the customer. Expert in Administering 7X24 OLTP.
Experience for, both manage and support all Production, Development and Staging instances of Oracle Version 7x, 8x, 8i, 9i, 10gR2 Oracle 11g on SQL Server and Oracle Server.
Hand on with implementation and configuration of RAC, Data Guard, EMC S SRDF and Time Finder, Advanced Queuing, Oracle Streams, Quest Softwares, MV Replication, OEM Grid Control 10g, SQL*Plus, Data pump Export/import, Transportable table space and SQL*Loader and traditional UNIX utilities.
Administrating Database in various platforms like WINDOWS XP/NT 4.0 or 2000, SUN SOLARIS, UNIX, IBM AIX and Red hat LINUX.
Experience with Oracle10g Stream Replication, Oracle Replication Advance and Basic Replication
Upgrading of Database from lower version to higher version.
Having experience in Migrating Database versions 8i to 9i, 9i/9x to 10g/11g
Also, Serving as Linux Administrator and Oracle Application Server 4.2.8 Administrator
Experienced in Tuning : Used Explain plan and TKPROF, DBMS_Profiler, AWR, ADDM, TOAD for SQL/PLSQL Tuning ; Performance tuning ie tuning SGA, I/O distribution using STATSPACK. Troubleshoots locks, network connection etc and documents database problems as they arise.
Database Management - Backup and Recovery, Performance Tuning, Configuration of Database, Table
Space administration, User management, Index management and managing Data dictionary objects.
Maintaining data integrity and tune database for optimum performance and availability. Excellent in troubleshooting Oracle Network issues.
Implementation of Database Security as Oracle Advance security OAS, Rman Duplication.
Ensuring successful and periodical Backup, Restoration and Tuning.
Hot Backup and recovery using RMAN, change management, Data Modelling, scripts for various database activities, troubleshooting etc.
Install and configure Database as of Oracle s Optimal Flexible Architecture OFA.
Mentored and provided oversight and backup for the production Databases.
Write scripts to automate database functions.
Writing scripts for informing the DBA s regarding the status, performance and Space Management of the Database.
Install new versions of database software and perform maintenance functions of the database.
Monitor usage of the databases and perform database tuning.
Plan for system growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management.
Work with software developers to develop and enhance applications. Exceptional ability to work under high pressure, demanding and delivering excellence in meeting project objectives and exceeding expectations and brings an unmatched commitment to the achievement of organizational goals and objectives.
Successful definition and design of Databases, to ensure secure and reliable transport of configuration and data between various countries.
Excellent Team player to work in conjunction with developers and team members in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects.


Employment

January, 2009 -  Present

CSC Advance Med , VA

Oracle DBA

AdvanceMed is a wholly owned subsidiary of Computer Sciences Corporation CSC specializing in helping healthcare organizations evaluate and assess the integrity of their health and pharmacy benefit programs. DBA Responsible for Govt. data include analyze data, medical record, fraud investigating data and statistician s data.

Responsibilities :
Design the Oracle replication Architecture environment for Govt remote sites.
Creation of the Dev, QA and Prod Oracle11g 11.1.0.6.0 or 10g 10.2.0.4.0 databases on Windows.
Created from scrap for Oracle11g Real Application Clusters RAC on Windows server.

Installation and Configuration ASM, OCFS in RAC environment
Installation and Configured Oracle10g Grid Control OMS, OAS, OMR
Implemented Data replication on Linux suse for remote sites.
Migration from Oracle 9i .x, 10 .x. to 11 .x on Windows server.
Upgrade Oracle 10.2.0.3.0 to Oracle 11.1.0.6.0 on Window server.
Monitored advanced replication Database on remote sites
Implemented Oracle Stream for database replication.
Implemented Oracle Data guard for failover of Data center and remote sites.
Replicate data on Database level, Schema level and object level.
Setup Backup plan for Govt. Production Databases using Rman, Symantec tape backup 12.5
Creation of Tables, Indexes, Views, sequences, constraints

Performance Tuning of all the queries using Explain Plan, Tkprof and SQL_Trace, tuning of other objects in the database, tuning of database, tune the memory structure.
Configuring TNSNAMES. ORA and LISTENER. ORA for Client-Server connection
Back end Programming/scripting using SQL and PL or SQL, Perl scripting
Created and re-compile Databases Packages like PL/SQL Packages
Created table partition and index partition.
Configured Flashback Recovery Area FRA for recovery damage Data files and disaster recovery.
Monitored the Data warehouse databases by tools like Ervin, ETL, Case, Toad
Created PL/SQL stored procedure, functions, triggers.
Created High level documentation for Oracle Replication for various Remote sites.
Implemented Space allocation planning tablespace, object etc in the replication environment.

Setup Network VIPS, Target database, IP, Load sharing.
Fix up the Production environment issues and data warehouse.
Troubleshooting for Production database issues/Performance issues Based on Call Rotation.

Environment : Oracle9i/10g/11g, Window Server 2003, SQL, PL/SQL, Oracle Export/Import, Oracle11g streams, Explain Plan, Toad, Symantec Exec backup 12.5 ETL Informatica, Toad, Erwin


February, 2008 -  December, 2008


Senior Oracle DBA/Database Architect

Plymouth State University with an enrollment of approximately 4200 undergraduate and 2600

graduate students. Responsible as a Consultant - Oracle DBA for installation, administration, Maintenance

and tuning of Oracle databases in Development or Production environment. Setup and monitored, Oracle

backups using export/import, cold/hot backups and RMAN.

Responsibilities :
Creation of the Development, Test and Production Oracle 11g/10g databases.
Created from scrap for Oracle Real Application Clusters RAC on Redhat Linux AS 4.6 EMT 64bits.
Installation and Configuration ASM, OCFS in RAC environment.
Designed Database Replication Architecture Hub and spoke for Distributed systems.
Configured Oracle Stream Replication for 25 databases.
Upgrade Oracle10g 10.2.0.3.0 to Oracle11g 11.1.0.2.0 on Redhat Linux.
Implemented Oracle 10g Application Server on Redhat Linux 4.2.6
Installation Oracle11g/10g on Sun OS 5.8 and Linux 4.2.6 on Oracle server.
Implementation of Oracle10g Dataguard on Linux.
Configured and implemented HP-Unix Service Guard for Oracle Database.
Installation and Configuration ASM, OCFS in RAC environment

Migration from Oracle 9.x to on Sun OS 5.8, Red hat Linux Rel 4
To upgrade Oracle 8.0.6 on Solaris8 - 32 bit server to Oracle 9.0.2 on SPARC/Solaris 8 - 64 bit server.
Implementation of Database Security as Oracle Advance Security OAS.
Used Oracle partition for the table and Data Refresh.
Installation and Configured Oracle10g Grid Control OMS, OAS, OMR
For cloning database used utility like Transportable table space, Rman Duplication.
Used Oracle Patches for Upgrade the various Oracle versions.
Configured EMC San Storage for create Logical Volumes and installed and configured devices.
Created and configured hot backup and cold backup by Rman.
Implementing Unix Shell scripting, Sql scripting and PL/sql scripting, Perl Scripting
Implemented Flashback recovery area FRA for recover and restore operations.
Installed and Configured Oracle Enterprise Manager 10g or 11g Databases.
Monitored Replication databases.
Configuring TNSNAMES. ORA and LISTENER. ORA for Client-Server connections.
Database data refresh from production database on SQL SERVER
Performance tuning explain plan and statpack, tkprof, log miner, utlestat and utlbstat, third party tools, AWR, ASH, ADDM reports, Oracle11g optimizer, DBMS packages
Created Physical standby databases and logical standby database with Oracle Data guard.
Created P/L SQL functions, package, stored procedure and triggers.
Compile and re-compile P/L SQL Objects.
Developed customized data extraction routines using SQL*Loader, Export/Import/data pump
Remotely supporting oracle database through VPN Connectivity
Administered and Monitored UNIX I/O, CPU, Cron jobs, SSH, SCP, Space requirement for the Oracle Databases.
Troubleshooting ad hoc queries for Production database issues/Performance issues based on Remedial tickets.
Documentation of RAC Data Base Setup, Stream Replication and administration of Server Environment
Management of database users, granting/revoking of system/object privileges, management of roles and resources and setting of init. ora parameter

Environment : Redhat Linux 5.1/AS 4.6, Linux Suse 10, SunOS 5.8, Windows XP/2000/2003/ NT, Oracle 9i/10g/11g/8i, PL/SQL, OEM, RMAN, SQL*Loader, Import/Export, Logminer, Data Pump, HP-UNIX, Stored Procedures, ETL Data stage, Toad, Erwin.


March, 2007 -  January, 2008

Lexmark International Inc , KY

Senior Oracle DBA or Lead Database Architect

Lexmark has become a leading developer, manufacturer and supplier of printing and imaging solutions for offices and homes. Lexmark's products include laser printers, inkjet printers, multifunction devices and associated supplies, services and solutions. Worked as DBA in the SDLC environment Software Development Life Cycle

Responsibilities :
Hand on experience of Oracle Real Application Clusters RAC on Redhat Linux 5.1/Linux AS 4.6 EMT 64bits/Windows-64bits
Installation Oracle10g/9i/11g on Linux 5.1/ AS 4.6/Windows-64bits.
Installation And Configuration ASM, OCFS in RAC environment
Configure EMC Storage SAN for ASM and OCFS File system.
Implemented Oracle Advanced Replication Multi master databases on redhat Linux 5.1
Installation and Configured Oracle10g/Oracle11g Grid Control OMS, OAS, OMR
Implemented Oracle10g agent for OMS Server.
Used Oracle partition for the tables.
Created and registered databases on hot backup and cold backup
Configuring TNSNAMES. ORA and LISTENER. ORA for Client-Server connections for RAC.
Racking and Stacking Dell 2950/Dell R900 Servers.
For cloning database used utility like Transportable tablespace, Rman Duplication.
Add new nodes to RAC 10g Cluster to distribute the load
Involved in installing and maintaining Sql Server 2005.
Involved in job scheduling using Sql server Agent.
Implemented and configured Linux AS 4.6/5.1 for oracle10g in Rac Environment.
Patch Installation for various Versions of Oracle Database 9i/10g
Installed Packages like RPMs for Linux AS 4.6 And Oracle 10g/9i
Implemented shell Scripts ksh/bash for Rman Backup.
Administer Advanced Replication Solution by tool like OEM, Replication Catalog
Implementation and Configuration Standby database by Oracle10g Data guard for disaster Recovery.
Maintenance and Monitor Standby database by such tools as OEM, DGMGRL
Plan, implement and troubleshooting Oracle hot backup RMAN, restore and recovery.
Oracle Database Creation and Maintenance in Dev, QA and Prod Environment.
Configured Flash Back Recovery Area FRA with Rman.

Using Materialized views, synonyms, views, procedures, functions, indexes, constraints and other objects for the databases.
Implemented and design Physical design and logical design of databases used ETL, Ervin, Informatica 7.x
Troubleshooting for Production database issues/Performance issues based on Remedial tickets.
Implementing UNIX Shell scripting, Sql scripting and PL/sql scripting, Perl Scripting and Java scripting.
P/L SQL objects compiled and recompiled during Upgradation of Databases.
Applying Job Scheduling package for Rman Backup.

Performance Tuning of all the queries using Explain Plan, tuning of other objects in the database, tuning of database with AWR, ASH, ADDM, tune the memory structure.
Used Oracle partition for the tables.
Configured Oracle10g Application Server.
Documentation of Servers, Processes and Oracle Architecture.
Remotely supporting oracle database through VPN Connectivity
Configuring TNSNAMES. ORA and LISTENER. ORA for Client-Server connections.
Used Database monitoring tools and Utility like OEM, SQL*Plus, DBMS_xxx, Toad, PL/SQL.
Worked closely with the Web Application, oracle application 11i, java/JDE code based application teams to support both new development and ongoing maintenance with our products.
24x7 Production Database Support.

Environment : Linux 5.1/AS 4.6, Sun OS 5.8, IBM-AIX 5, Windows XP/2000/2003, Oracle 9i/10g/8i, PL/SQL, OEM, RMAN, SQL*Loader, Import/Export, shareplex, LDAPv3, SQL SERVER 2005, HP-UNIX, Sql Server Reporting Service 2000


September, 2006 -  February, 2007
Senior Oracle DBA

People United Bank , CT

People's United Bank provides consumer, commercial, insurance, retail investment and wealth management and trust services to personal and business customers Worked as DBA involved in supporting 24/7 PROD/DEV/TST databases for more than 300 branches. Involved in transitioning the new tasks for both regions New York, Maine and Vermont covering knowledge sharing, transition and technical discussions with client.

Responsibilities

Working on Database setup containing around 1600+ Oracle Instances having versions 8i, 9i, 10g on various platforms Solaris 5.8 and 5.9, redhat Linux, HP-Unix 11.11 and Windows-64bit.
Implementation of Oracle 10g Grid/ 9i RAC on Windows 2000/XP and server 2000/2003 and Configuration for High Performance and High Availability with latest Cluster Technology.
Administration and managing the Oracle Instance using custom scripts and 10g Enterprise Manager database control.
Installation And Configuration ASM, OCFS in RAC environment
Monitored and Maintained Oracle10g Application Server.
Installed and Created Sql Server 2005.
Worked with all kinds of transformation, Conditional Split, Multicast, Union-All, Sort, Fuzzy Grouping, Aggregation, Pivot and Unpivot on SQL Server 2005
Binaries installation, patching and upgrading databases.
Migrated Oracle 9.2.0.5 database to Oracle 10.2.0.1.
Manage Multi- cluster Management and Reporting on multiple local and remote cluster servers.
Created, maintained and tuned SQL database on Window-64bit Platform.
Working with the team of 3 Database A's

Experience on large Oracle databases sizing > 2TB
Used JDBC for Java Code base application with Oracle.
Performing Backups Hot backup and cold backups and Recovery Procedures on all of DEV/TST/PRD Database using RMAN
Setup Flashback Recovery Area FRA for VLDB.
Excellent hands-on on UNIX platform with nearly all flavors Linux and Solaris, AIX

Installation of standard backup scripts Database Backup designed specifically for Database databases. Installation of other utility and health checks scripts. Tuning of slow performing queries. Tuning memory allocation.

Performance Tuning of all the queries using Explain Plan, Tkprof, Awr, ash, addm and SQL_Trace tuning of other objects in the database, tuning of database, tune the memory structure
Used Shell scripts ksh/bash for Rman backup.
Back end Programming/scripting using SQL and PL or SQL, Perl scripting
Implemented database replication for high availability by Oracle Stream.
Taking care of space management on Standby databases when the space is added on production.
Monitoring Alert Logs and V$Views checking for daily performance Tuning of database.
Remedy based ticketing system, Problem management tickets raised by failure on Database servers
Co-ordinate between Client and Development Team on critical fix s and Configuration Issues
Configuring TNSNAMES. ORA and LISTENER. ORA for Client-Server connection
Configure and Manage Replication Environment.
Co-ordination with Primary DBA s and System Administrator people in London and New York
Co-ordination with application users/database owners all over the globe
Implemented OLTP tool for large databases. VLDB.
Managed OLTP and OLAP for Database Modeling tools used like Ervin, Case
Implemented Oracle10g Dataguard for disaster recovery and Data guard Vault Implementation for On line Backups.

Environment : Oracle 8i/ 9i/10g/11g, HP-UNIX, Sun Solaris, redhat Linux/linux suse, Windows Servers. SQL Server 2005, IBM-AIX 5L, ETL informatica, Toad, Erwin, Data stage.


July, 2003 -  August, 2006

Network Program Noida India

Oracle DBA/Oracle developer

Responsibilities :
Design the Oracle replication Architecture environment.
Installation and Creation of Oracle Databases on Linux SUSE.
Implemented Data replication on Linux suse for remote sites.
Migration from Oracle on Hp-Unix 11.11 to Oracle on Linux Suse.
Upgrade Oracle 8.1.2 to Oracle 9i on Linux Suse.
Installation and Creation of Oracle9i AS Application Server
Monitored advanced replication Database on remote sites.
Replicate data on Database level, Schema level and object level.
Setup Backup plan for replicate Databases.
Used Export/Import for Oracle Database from Hp-Unix 11.11 to Linux suse.
Implemented hot backup/cold backup scripts.
Creation of Tables, Indexes, Views, sequences, constraints

Performance Tuning of all the queries using Explain Plan, Tkprof and SQL_Trace, tuning of other objects in the database, tuning of database, tune the memory structure.
Configuring TNSNAMES. ORA and LISTENER. ORA for Client-Server connection
Back end Programming/scripting using SQL and PL or SQL, Perl scripting
Created and re-compile Databases Packages like PL/SQL Packages
Created table partition and index partition.
Configured Flashback Recovery Area FRA for recovery damage Datafiles.
Monitored the Datawarehouse databases by tools like Ervin, ETL, Case, Toad
Created PL/SQL stored procedure, functions, triggers.
Created High level documentation for Oracle Replication for various Remote sites.
Used Shell scripts ksh/bash for Rman backup.
Implemented Space allocation planning tablespace, object etc

Setup Network VIPS, Target database, IP, Load sharing
Fix up the Production environment issues.
Troubleshooting for Production database issues/Performance issues Based on Call Rotation.
Supported for 24x7 call rotation.

Environment : Oracle 8i/ 9i, HP-UNIX, Linux suse, SQL, PL/SQL, Export/Import, Oracle Replication

Explain Plan, Toad.


May', 1999 -  June', 2003

New Delhi India




Education

Bachelors of Information Technology from Mahe , India



Training

Oracle certified professional OCP Oracle 9i DBA From Oracle Corporation
1 Introduction to Oracle 9i : SQL
2 Oracle 9i Database : Fundamental I
3 Oracle 9i Database : Fundamental II
Oracle 9i Database : Performance Tuning
Oracle Database 10g : New Features for Administrators from Oracle Corporation
Database Administration
Backup and Recovery
Network Administration
Sun Certified System Administer for the Solaris 10 OS
Cisco Certified Network Associate Training from Info Park
CCNA
Training from Info Park Delhi , India


Skills


RDBMS : Oracle 8i/9i/10g/11g Database Administration : Oracle 8i, Oracle 9i, Oracle10gR2 Sql 2005, Microsoft Access Oracle Tools and Utilities : OEM, SQL*Plus, Pl/SQL, SQL*Loader, RMAN, Toad 8.5, Log Miner TKPROF, Putty, WINSCP, Bash/ksh/csh, Quest shareplex, Expdp/Impdp Operating Systems : Linux AS 4.6/5.1, Win 95/98 or 2000/XP, SUN OS 5.8, AIX 5 Programming Languages : C, C++, Java, VB, PL/SQL, Html, Xml Storage : EMC Storage Database Connectivity : SQL* Net, TCP/IP Adapter, Ethernet, SSH Hardware : Dell 2950, Dell R900 Sun E4500/E6500



Miscellaneous

Oracle DBA
APCS
is the Software Development Company provides Hardware and software services for there various major clients like Indian Railways,, Financial - Banking Sector, Large Hospitals, BSNL and MTNL telecoms. Worked as Database Administrator coordinated and managed tasks and worked with developers to identify database requirements needed to build instances interfaces or customized code
Responsibilities : Installation and Configuration Oracle 8i and 9.2 on Win NT/00 or Linux
Migrated And Upgraded Various database versions for various clients.
Creating Database objects and managing the resources
Exporting and importing data using Export/Import utilities
Using Explain Plan and oracle optimizer hints to enhance performance of SQL statements.
Implementation of a backup strategy.
Performance Tuning of all the queries using Explain Plan, Tkprof and SQL_Trace tuning of other
Objects in the database, tuning of database, tune the memory structure
Creation and maintenance of user accounts and system and user level database objects
Creating and maintaining user accounts and system level and user level database objects
Creation of the required objects for the application
Back end Programming/scripting using SQL and PL or SQL, Perl scripting
Conversant with logical and physical design, configuring and layout of database
Understood the application architecture and suggested steps for improved performance
Package and Oracle Software installation and configuration.
Implemented and administrated daily hot backup and cold backup by Rman
Responsible for porting data from the existing billing using data migration tools along with SQL
Loader and Import/Export and consistency checking.
Built interface with existing Legacy system.
Carried out weekly reviews, technical reviews, made weekly progress reports.
Acted as primary point of contact between customer and core development team.
Acting as configuration controller.
Configuring TNSNAMES. ORA and LISTENER. ORA for Client Server Connections.
Environment : Win NT/00, Oracle 8.1/8i/9 .x, SQL, PL/SQL, Oracle Developer 2000 Forms and Reports, Linux, Sun solaris, HP-UNIX 11.11
Bachelor from Delhi University, India