Gagan Kumar      

PROFESSIONAL SUMMARY:

• Over 11 +years as Oracle Database Administrator (Proficient in Oracle Database Administration Activities) like developing customized business applications, database design, database administration and building large public domain databases on a variety of UNIX (Solaris, HP-UX, AIX), Windows NT 4.0/2000/2003 with Oracle (7.x, 8.0.5, 8i, 9i, 10g, 11g), Developer 2000/6i, SQL net, SQL*Plus, Pro*C etc.

§   Installed, configured and maintained enterprise environments with 24X7 production databases.

• Performance engineering - Support performance testing, identify tuning and design changes to gain performance with AWR/Statspack. Engineering Large Scale Database Design and Tuning. Involved in optimizing SQL queries. Monitoring and optimizing the Performance of the database, tuning Management, Change Management, capacity planning, and SQL tuning.

§   Involved in capacity planning, developed strategies and maintenance plans and implemented the same for monitoring, security & disaster recovery, load balancing and replication.

• Oracle RAC and ASM expert. RAC experience needs to include working experience in - planning, designing, developing, deploying, maintenance and supporting RAC on IBM AIX, Sun Solaris & Windows NT servers for high availability (HA). Patching/upgrading RAC Nodes with 10g/11g Oracle Versions.
• Hands on Oracle Data Guard (9i/10g) both logical & Physical Standby experience on Unix & Windows NT servers.
• Expertise in 10g Grid Control. Installing / implementing OEM 10g Grid Control  Management Server and Agent  with 10g R1/R3 Repository to manage 1200+ targets( Database include primary and stand-by databases , Grid Control Agents, Server , 9i/10g  application server components  on more then 100+ server )
• Experience with database backup, restore, and disaster recovery procedures. Hands on experience of database backups and Recovery strategies using RMAN (9i/10g), 10g Data pump (expdp, impdp) Export/Import and Transportable Tablespaces.
• Used Oracle 10g streams for Data replication, Data warehouse loading, Event notification as well as business event management.
• Worked on EMC Symetrix DMX, EMC CLARiiON NAS devices, Hitachi, IBM, DMX SAN storage devices.
• Expertise in Implementation of Fine Grain Access Control (FGAC).
• Monitor and manage Oracle database Security by implementing SOX Policies through OEM Grid Control.
• Extensive experience in Data warehouse environments with Star Schema and SnowFlake Architecture.
• Expertise in ASO Implementation.
• Extensive experience with Oracle Database Migration/Upgrade.
• Expertise in VPD & TDE. Expertise in OID, Oracle Audit Vault.
• Expertise in Installation & configuration of 9iAS/10gAS for Single sign on (SSO).
• Strong Knowledge on 11g & 10g Release and New Features.
• Strong experience with Database Modeling, Data Analysis and Conceptual, Logical and Physical modeling for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Experience in Data warehouse environments with both Star Schema and SnowFlake Architecture.
• Knowledgeable of Web applications that includes Installation/Maintenance of 10gAS, & supporting portal development teams.
• Expertise in Oracle Veritas HA Cluster.
• Expertise in Creating/troubleshooting/monitoring script, creation of log files, packages & development of  scripts for SQL*Loader, Export, Import, PL/SQL, Involved in optimizing SQL queries.Monitoring and optimizing the Performance of the database using AWR/ADDM tools, Statspack & tkprof .Strong experience in tuning database performance from system as well as query tuning perspective.
• Expertise in Entity/Relation Data Modeling using ER-Win and Designer. Used and supported Informatica for ETL Transformations, Discoverer for adhoc query, Crystal Reports for reporting.
• Working experience with Very-Large databases (VLDB) up to 20 terabytes, data migration, against Oracle & other databases such as MS Access, SQL Server.

TECHNICAL SKILLS:

Database:             Oracle 11g/10g/9i/8i/8.x/7.x, SQL Server 2005/2000, 

Hardware:           Sun Sparc E series, HP 9000, IBM RS400, DELL PowerEdge, Compaq, EMC

OS:                         Sun Solaris 8.x, 9.x & 10.x, HP-UX 11.x, IBM-AIX 5L 5.x , Digital UNIX 4.x, SCO UNIX 7.x, RedHat Linux ES 2.x, 3.x & 4.x, SUSE Linux Enterprise Server 9.x & 10.x, OpenVMS 1.x Windows NT/2000/2003

GUI:                       Developer 2000(Forms 4.5, Reports 2.5), Developer 6i (Forms 6i, Reports 6i)

DB Tools :            OEM 9i & 10g,OEM 10g Grid Control, RAC, RMAN, Data Pump, Export/Import, SQL Loader, OWB, OID, 9i/10g RAC, Toad,  DBArtisan, Quest Shareplex, Quest Central with Spotlight, foglight, 9i/10g Data Guard, Oracle streams, Advanced replication (Multimaster) &Database Vault.

CASE Tools:        ERWIN, Designer 2000/9i

ERP Appl:            Oracle Applications 11i

Reporting Tools: Discoverer, Cognos

OLAP Tools:       Cognos (Impromptu, PowerPlay), Informatica Powercenter 7

Miscl Tools:         BMC Patrol, Veritas Clusters, Veritas NetBackup, Tivoli Data Protection, Cron Processes, Secure CRT, Remedy, VCS, Hummingbird, Callidus TrueComp

Languages:          SQL*Plus, PL/SQL, C, Pro*C, Unix Shell Scripting, csh, ksh, bash

Education:

BS in Textile Technology, India

Oracle Certified Professional (10g/9i/8i) Database Administration.

Experience Details:

Becton Dickinson, Cincinnati, OH                                                 Oct 09 to TILL DATE

Role: Sr. Oracle DBA

RESPONSIBILITIES:

§  Installed Oracle 11g Enterprise Server (11.1.0.6.0) and upgraded existing Oracle 10.2.0.4    databases to 11.1.0.6 version.

§  Implemented new features of Oracle 11g like Automatic Memory Management, Automatic SQL Tuning, AWR Baseline Enhancements, Case Sensitive Passwords, Data Recovery Advisor, Database Replay, Query Result Cache, Read-Only Tables, Secure Files, SQL Access Advisor, SQL Performance Analyzer, SQL Plan Management. Statistics Collection Enhancements, Table Compression Enhancements, Tablespace Encryption, Tablespace Enhancements to the Dev/TST/PROD environments successfully.

§  Installed and Configured 4 Node RAC on Red Hat Linux AS 4 platform and added 2 Nodes to make it a 6 Node RAC.

§  Added and relocated the OCR Mirror and Voting Disks to existing RAC Setups to prevent Single Point of failure and scheduled & tested their physical and logical backups.

§  Implemented Automatic Storage Manager (ASM).

§  Did Extensive Performance Tuning of RAC Databases.

§  Created RAC Database on Dev Hosts using DBCA Templates and refreshed them with the latest snapshot of data from Prod Environment.

§  Working on Oracle Streams CDC (Change Data Capture) operating from OLTP to Warehouse Databases.

§  Installed & Configured Oracle 10g Grid Control for monitoring over 40 Prod / Non Prod Hosts.

§  Upgraded the Oracle 10.2.0.1 Grid Control Setup Including OMS, Database and Agent to version 10.2.0.4

§  Used Mass Deployment Agent to Install Remote Agents from OMS Side.

§  Installed Intelligent Agent at target hosts using Agent Download Method.

§  Migrated the OMS repository from 10.2.0.3 Grid Control to newly setup 10.2.0.4 Grid Setup Successfully to see the historical reports using new Grid Control.

§  Implemented CRM using Siebel having Oracle 10g as backend database.

§  Used Oracle Datastage and Streams for doing Data Replication.

§  Installed Oracle 10g Application Server and configured & administered the same.

§  Troubleshoot Database Performance Tuning issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.

§   Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS), Tivoli Storage Manager, NetApp SAN Storage and AutoSys Job scheduler.

Environment: Linux (RHEL AS 4), Sun Solaris 9, 10 , AIX 5.3, Windows NT, Sun E5000, EMC, VERITAS, Oracle (11g/ 10g/ 9i), SQL Server 2005/2000 , Remedy , PL/SQL, SQL Scripting, UNIX Shell Scripting, AWR, ADDM, STATSPACK, DBArtisan, TOAD

J & J Vision care, New Brunswick, NJ                                                         Mar 08 to Sep 09

Role: Sr. Oracle DBA

RESPONSIBILITIES:

§  Upgraded Oracle 9i to 10g and 10g to 11g.

§  Implemented the 3 Node Oracle 10g RAC on Sun Cluster and did all the trouble shooting to make the CRS and RAC Setup a stable one.

§  Installed and Configured Oracle 10.2.0.1 Grid Control.

§  Upgraded the 10.2.0.1 Grid Control Setup to 10.2.0.4

§  Implemented the MAA (Maximum Availability Architecture) having 10g Physical Data Guard for 3 Node RAC System.

§  Installed Oracle 10.2.0.3 on Production DB Servers, applied OPatches to fix the known bugs and Upgraded 15 production databases sizing between 700GB and 5 TB from Oracle 9.2.0.7 to 10.2.0.3.

§  Implemented the Oracle 10.2.0.3 Physical Data Guard in Maximum Performance Mode for re hosting of J&J’s data center using Data Guard.

§  Installed Oracle Clusterware CRS, Clustered Install of Oracle 10g, applying opatch in clustered environments, created database / instances using DBCA on a four node cluster, troubleshooted RAC at OS / OCR / CRS / DB Level.

§  Writing Shell scripts for Alerts for ORA- errors, backup and recovery, Import and export procedure, Unix Shell scripting in csh, ksh to be controlled from Crontab.

§  Involved in Streams Configuration for Sharing Information Between Databases & high availability.

§  Participated in Installation & configuration of 10gAS and SSO.

§  Involved in ASO Implementation.

§  Involved in Data Warehousing, Data Modeling, Database Design and Creation

§  Used Oracle Warehouse Builder  for designing, deploying, and managing data warehouse.

§  Member of SOX team in implementing security on DB side.

§  Troubleshoot Database performance (tuning) issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance and tuned the database both at I/O and instance levels.

§   Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN).

§  Worked on various application deployments like setting up a new student’s info for the fees/Course Systems, deploying new database / application level code changes and working closely with the Release Engineering teams to fix the database/application bugs.

§  Involved in upgradation of more than 20 Databases each sizing at least 500GB from 9i to 10g & also involved in Migration from SQL Server2005 to Oracle 10g.

§  Downsizing and defragmenting the Very Large Databases by export / import, Cloning them using RMAN Duplicate features and then upgrading them to Oracle 10g

§  Designed and developed logical and physical data models using CASE tools such as ERWin and Oracle Designer 10g and using manual methods as well.

§  Setup backup and recovery procedures using OEM, RMAN and third party tools like Veritas. Used hot backups and cold backups, incremental and full backups.

§  Used Flashback technology to recover (Point-in-Time-Recovery) accidentally dropped or modified database objects.

§  Responsible for data integrity, user security, daily monitoring for production and non-production systems. Used standard, value-based and FGA auditing.

§  Implemented backup strategies for archiving and non-archiving databases. Involved in planning, implementation and testing of disaster recovery.

§  Refreshed Test / Stage / UAT databases from the production environment using shadow image Technology and applying Archives logs to the clone database thereafter.

§  Created Scripts to test the user connections & generator scripts for automatic generation of SQL.

§  Developed new technique for reducing the downtime in migration of big database.

Environment: Linux (RHEL), Sun Solaris, Open VMS, Windows NT, Dell poweredge 4400, Sun E5000, SAN, Oracle (9i/10g/11g),SQL Server 2005, Erwin 7.1, Pro*C, PL/SQL, SQL Scripting, UNIX Shell Scripting, STATSPACK, AWR, ADDM, DBArtisan, TOAD

Comcast, Colorado Springs, CO                                                                    Oct 06 to Feb 08

Role: Sr. Oracle DBA

RESPONSIBILITIES:

§  Creation and setup of Dev/TEST/QA environment from Production database

§  Installation, Upgrade and Configuration of Oracle 9i, 10g and 10g OEM.

§  Installation, Configure, setup of 10g RAC.

§  Configured 10g R2 RAC with ASM and OCFS cluster file system and also configured workload management (both server side and client side Load Balancing).

§  Setting up and Auditing RMAN Hot and Cold Backups, Exports.

§  Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations. Configuring scripts for backups (hot, cold and incremental).

§  Installation, setup and configuration of logical and physical Standby Database using DataGuard.

§  Assist with the loading and configuration of Oracle software starting from space requirements, kernel parameters setup to the Oracle installation and successful execution of DBCA.

§  Assist with the loading of internal and third-party applications using TOAD, SQL Navigator etc to do various SQL / DBA tasks using GUI Environment.

§  Database migrating Oracle 9i to 10g.

§  Setup of Oracle two way replication using streams.

§  Used Streams to Capture Messages at a Database, Stage Messages in a Queue, Propagate Messages from One Queue to another, work flow implementation.

§  Data Replication , event management &  notification, Data Warehouse Loading ,Data Protection .

§  Involved in streams configuration for sharing Information between DB’s, Configuring Streams for High Availability.

§  Involved in defining Rule Sets and Rule Evaluation of Messages.

§  Writing error handler procedures for, update and delete conflict and writing the cause of error to log files.

§  Daily monitoring and troubleshooting of streams issues.

§  Writing Shell scripts for Alerts for ORA error backup and recovery, Import and export procedure.

§  UNIX shell scripting in csh, ksh to be controlled from Crontab.

§  Security User Management, Privileges, Role, Auditing, Profiling, Authentication.

§  Extensive Performance Tuning, Memory (SGA) Tuning, etc.

§  Assist with database tuning and best practices involving OS level tuning, SGA tuning, SQL Tuning and considering other contention / IO issues.

§  Provided technical support to development team to fine tune SQL and PL/SQL code using SQL Execution Plan, SQL TRACE, ANALYZE DBMS_STATS and evaluating & monitoring database to resolve performance issues including troubleshooting errors, Troubleshoot Database performance (tuning) issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance and tuned the database both at I/O and instance levels, recovering databases and failures as needed.

§  Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance.

§  Database Refreshing / Replication from production to testing using hot backup.

§  Managing Veritas Cluster for HA, I2 Implementation.

§  Rendering 24*7 Oncall Production database support.

§  Provide primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.

Environment: Linux (RHEL), HP-UX 11i, Sun E5000, SAN, HP9000, RS6000, Oracle (9i/10g) SQL Server 2005, VERITAS, PL/SQL, SQL Scripting, UNIX Shell Scripting, STATSPACK, AWR, ADDM, TOAD

CITI Bank, Tampa, FL                                                                                    Nov 05 to Sep 06

Role: Sr. Oracle DBA

RESPONSIBILITIES:

• Provide day-to-day databases support for users & application teams. Implementing database backup and restorations.
• Involved in 24*7 Remote / Onsite DBA support to Production Data Centers of CITI Bank and interacting with offshore team in India and meeting the timelines of various projects.
• Involved in upgradation of more than 40 Databases having sizes varying from 500GB to 3 TB.
• Creation and setup of Dev/TEST/QA environment from Production database
• Installation, Upgrade and Configuration of Oracle 9i, 10g and 10g EM.
• Setting up and Auditing RMAN Hot and Cold Backups, Exports.
• Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations. Configuring scripts for backups (hot, cold and incremental).
• Installed 10g Physical Data Guard in Maximum Performance Mode. Verify the Redo Generation, Redo Transfer and Redo Apply Services between the primary and standby database.  Performed the Switchover, Switchback and Failure tests of the primary and physical standby and verified the successful catching up of standby with the primary DB.
• Installation, Configure, setup of 10g RAC.
• Setting up Two node RAC cluster on Windows and HP environment.
• Configured 10g R2 RAC with ASM on HP servers and OCFS cluster file system and also configured workload management (both server side and client side Load Balancing).
• Database migrating Oracle 9i to 10g.
• Migration of Oracle Databases from HP UX  to Linux
• Plan and Schedule the Online/Offline Backups.
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Automated processes using SQL Server jobs.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• De-fragmentation/Reorganizing of database using Export/Import.
• Used Oracle streams for Data replication.
• Involved in Creating / Renaming the database and implementing SOX policy.
• Implemented Password Administration, User Schema Account Naming by using standard Oracle profiles ,enable password encryption , data encryption in  accordance to the SOX policies of the company
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Extensive Performance Tuning, Memory (SGA) Tuning, etc.
• Provided technical support to development team to fine tune SQL and PL/SQL code using SQL Execution Plan, SQL TRACE, ANALYZE DBMS_STATS and evaluating & monitoring database to resolve performance issues including troubleshooting errors, recovering databases and failures as needed.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance.

Environment: AIX 5L, Sun Solaris 9, HP-UX 11.0, Windows NT, IBM RS/6000,HP9000, Sun E5000, SAN, VERITAS, Oracle (9i/10g), Pro*C, PL/SQL, SQL Scripting, Unix Shell Scripting, Unix CRON jobs, BMC patrol

PacifiCare Health Systems, Cypress, CA                                                                     Mar 04 to Oct 05

Role: Sr. Oracle DBA

RESPONSIBILITIES:

• Creation and setup of Dev/TEST/QA environment from Production database.
• Installation, Configure, setup of 10g RAC.
• Add new nodes to RAC 10g Cluster to distribute the load.
•  Performed several RDBMS upgrades from 8i to 9i, 8i to 10g, 9i to 10g on HP 64 bit platforms.
• Setting up and Auditing RMAN Hot and Cold Backups, Exports.
• Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations. Configuring scripts for backups (hot, cold and incremental).
• Migration of Oracle Databases from Solaris to IBM AIX 5.3.
• Managing Veritas Clusters for HA Implementation.
• Involved in ASO Implementation.
• Configuration of Oracle Enterprise Manager (OEM 9i & 10g) tools for monitoring, performance enhancement and debugging.
• Used Veritas FlashSnap Warehouse, RMAN, DDL and Wizard OEM Management Server for Export backups on schema level hot backups.
• Real Application Clusters monitoring, tuning, load balancing using SRVCTL, OEM (Oracle Enterprise Manager), Statspack,and GV$ dynamic views.
• Automated failover of applications within a data center or to remote data centers.
• Implemented Fine Grained Access Control (FGAC) as per multi Organizational security.
• Involved in Database Design & Data Modeling (ERWIN).

§  Design and create Logical and Physical data Models using ERWIN.

• Created dimensions and extensive use of export/import utilities in Oracle Warehouse Builder.
• Worked with Oracle Warehouse Builder (OWB) and oracle workflow to design and schedule. Installed and upgraded patches from 10.2.0.1 to 10.2.0.2 and also managed OWB repositories, import export MDL files.
• Provided disaster recovery testing without affecting the primary environment.
• Implemented fine grained auditing using dbms_fga of Oracle 9i in order to comply the SOX policy of the Company.
• Installation, setup and configuration of logical and physical Standby Database using DataGuard.
• Installation and Configuration of SQL server 2005 on windows server.
• Involved in Shell script (Shell and SQL) to automate database Backup, monitoring and other DBA functions. Data and schema transfers from oracle to oracle, oracle to flat files vice-versa, SQL server to SQL server, SQL server to text files and vice versa.
• Assist with the loading and configuration of Oracle software starting from space requirements, kernel parameters setup to the Oracle installation and successful execution of DBCA.
• Assist with the loading of internal and third-party applications using DB Artisan, SQL Navigator etc to do various SQL / DBA tasks using GUI Environment.
• Assist with database tuning and best practices involving OS level tuning, SGA tuning, SQL Tuning and considering other contention / IO issues.
• Configured & supported oracle Advanced replication (Multimaster)
• Writing Shell scripts for Alerts for backup and recovery, Import and export procedure.
• Involved in Perl Scripting
• Writing error handler procedures for, update and delete conflict and writing the cause of error to log files.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Security Management, Privileges, Role, Auditing, Profiling, Authentication.
• Extensive Performance Tuning, Memory (SGA) Tuning, etc. using Statspack, ADDM & other advisors.
• Provided technical support to development team to fine tune SQL and PL/SQL code using SQL Execution Plan, SQL TRACE, ANALYZE DBMS_STATS and evaluating & monitoring database to resolve performance issues including troubleshooting errors, recovering databases and failures as needed.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• Database Refreshing / Replication from production to testing using hot backup.
• Provide primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.
• Rendering 24*7 Oncall Production database support.

Environment:  Linux (RHEL), Sun Solaris, HP-UX 11.0, AIX 5.3, Windows NT, Sun E5000, SAN, VERITAS, Oracle (10g/9i), SQL Server 2005/2000, Questa Shareplex,Erwin 7.1,OWB, DataStage 7.5 EE, Pro*C, PL/SQL, SQL Scripting, UNIX Shell Scripting, STATSPACK, DBArtisan, TOAD

Panasonic Electric Works Corp of America, New Providence, NJ    May 03 to Feb 04

Role: Sr. Oracle DBA

RESPONSIBILITIES:

• Provided production support and maintained a 24X7 tracking database.
• Administered in Oracle Parallel Server, in managing a cluster environment (on Veritas CFS) that provides highly available and highly scalable database servers using SRVCTL utility.
• Installation, Upgrade and Configuration of Oracle (8i,9i & 10g).
• Installed and created 10g databases and 10g OEM.
• Configuration, maintenance and tuning of Oracle 9iRAC and 10gRAC.
• Installation, setup, configuration & Implementation of 10g RAC and 10g Dataguard.
• Configured  OID(Oracle Internet Directory)
• Migration of Oracle Databases from IBM AIX 5.1 to Linux.
• Configuring Recovery Manager (RMAN).
• Design and implement of database backup strategy and performed full incremental and Cumulative backup using RMAN. Troubleshooting with RMAN backup problem.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Used Shareplex for replicating databases (multimaster replication)/log based replication.
• Successfully resolved data conflicts (Shareplex)
• Used Shareplex to minimize the downtime for Migration & to meet the high availability requirements
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Expertise in Scheduling Control-m for scheduling jobs.
• Setup, Installation, configuration and UNIX System Administration.  UNIX shell scripting. UNIX CRON jobs.
• Managing Veritas Clusters for HA Implementation.
• Involved in Datawarehousing, Database design & Data modeling.
• Physical and Logical Database Modeling, including ER Diagrams and Normalization.
• Created dimensions and extensive use of export/import utilities in Oracle Warehouse Builder.
• Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.
• Taking Hot and Cold Backups, Exports etc.
• Configuration, tuning and setup of 10gAS portal and single signon.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, password (security).
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication. Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Writing scripts for backup and recovery, Import and export procedure.
• Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc.

Environment: HP-UX 11i, Sun Solaris5.9,Linux Red Hat, Windows NT/2000/2003,Oracle Server 10g/9i,SQL Server 2000,  OEM , SQL*Plus, PL/SQL, Questa Shareplex , Veritas Clusters Failover, Net Backup

Bank of Punjab, India                                                                                       Jun 99 to Apr 03

Role: Oracle DBA/Developer

RESPONSIBILITIES:

• Installation, Upgrade and Configuration of Oracle (7.3.4, 8.0.5).
• Creation of database, tables, users, roles.
• Developed E-R and data flow diagrams, Performed Data Modeling.
• Developed several stored procedures. Setting up Replication using Database Triggers and Stored Procedures.
• Managing the partitioned tables and partitioned indexes.
• Backups and Recovery i.e. exports/imports, hot backups, cold offline backups, etc
• Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints & Memory (SGA) Tuning, etc
• Creating rollback segments, etc. Unix Shell scripting in csh, ksh

Environment: HP-9000, FORMS 2.3, ORACLE 7.3.4, 8.0 ksh, csh, Pro*C,