DEEPAK GUPTA Sr. Oracle DBA (OCP)

wz1q8h@r.postjobfree.com

http://deepakguptadba.blogspot.com/

http://www.linkedin.com/in/deepakguptaoracledba

PROFESSIONAL SUMMARY

Last 10+ years working as Database Administrator for Oracle Database RAC 10g, 11g, 10g, 9i, 8i &7.x with total 15 years’ comprehensive experience in IT. I am OCP Certified for Database RAC, 10g, 9i & 8i. Database administration includes Installation, Upgrades, Migration, Performance Tuning, and Troubleshooting etc.

I have installed and configured 2 nodes RAC on Linux & HP servers. I have created and configured the Data Guard using Flashback on Oracle 10g. I have done a lot of UNIX shell scripting of automate routine tasks. Grid Control DB has been installed and configured to monitor the all the databases and get critical alert message on Cell Phone. I provide recommendations on Database and Application performance tuning and also responsible for Production databases hosting services to our external clients. I Provide 24X7 production supports for all production Oracle databases. Two level of Backup Strategy has been implemented using of RMAN and Data Pump. Extensive hand on experience on recovery of databases using of RMAN.

I am a self-starter and eager to learn new features and technology and very flexible to adjust in new environment. I do and provide support in odd hrs. I take ownership on issues and meet the tough dead lines. I believe in proactive approach on possible or know problems and fix them permanently. Goal to achieve my best. Passionate about what I doing. It is a self commitment on ‘same problem should not occur more than 2 times’.

SUMMARY

• 10+ years of experience in Database Administrator for Oracle Database 11g/10g//9i/8i/7.x

• 15+ years of comprehensive industry knowledge with IT, Pharma/Biotech, Manufacturing, Construction, & Electronics

• 24 by 7 production and test/development support environments experience

ACHIEVEMENTS

• Performed Oracle Database upgrades from 10g to 11g in Red hat Linux 5

• Built:

o Oracle RAC over ASM environment on Oracle 11g & 10g on Linux, Sun Solaris, and HP UX.

o Data Guard environments.

o OEM Grid control to monitor all databases.

CERTIFICATIONS

• Oracle Certified Professional – OCP DBA Certification for Oracle RAC, 10g, 9i, 8i, 8

• Brainbench Certified Oracle 8.0 Administrator.

Skill Set

OS HP-UX, Tru 64 Unix, IBM AIX, Sun Solaris, Red Hat Linux, Oracle Enterprise Linux, Oracle VM Server, VMware and Windows 2003

Languages SQL and PL/SQL, UNIX Shell, SED/AWK and Perl Scripts

Databases Oracle 8,8.x, 9.x ,10.x and 11.x

Schedulers Crontab , AT Scheduler, Oracle Scheduler, OEM

Clusters Oracle Clusterware and OCFS.

High Availability Oracle 9i/10g/11i RAC, Standby Database, Clustering and Data Guard Setup, Automatic Storage Management and Configuration and Tuning and Materialized Views

Replication Oracle Transactional Replication with Golden Gate Replicator, Oracle Streams

Tools & Utilities Toad, SQL Navigator and SQL Tools.

Oracle Tools Oracle EnterpriseManager, 10g OEM Grid, StatsPack, Export/Import, RMAN, Toad, SQL Navigator,Quest Spotlight, BMC Patrol, ,Veritas NetBackup etc.,

Ticketing System BMC Remedy, HP OpenView Service Desk and Siebel Service.

Domain Insurance, healthcare, Manufacturing, Utilities and High Tech Sector.

Office Tools Microsoft Office/Works and Star Office

EXPERIENCE (For details please see page 3-5)

• One shield Inc. MA - Sr. Database Administrator - Nov 2007 – - Till now

• Biogen IDEC Inc. ( Employer Atlas S/w Technologies Inc. ) - Oracle DBA – Sr. Team Member - April 07 – Oct 2007

• Pfizer Inc. (Employer BLC Consulting service ) - Oracle DBA – Team Member (10g/9i/8i) - Jan 16 – Apr 07

• General Motors ( Employer EDS India) - Oracle DBA – Team Member (9i/8i) - Nov 2003 – Jan 2006

• DLF Universal Ltd., India - Oracle DBA 9i / 8i / 7.x - Feb 2000 –Oct 2003

• Samtel Electronic Device (Samtel Group) India – ERP Implementer - Feb 95 to Feb 2000

EDUCATION

Master in Science (Computer Science) Msc 2005

M. D. University, Rohtak (Haryana), India

Masters in Computer Applications (GNIIT 3Years Program) 1995

National Institute of Information Technology (NIIT), New Delhi.

Amongst top scorers (77.4%)

Bachelor of Science (Honors) 1990

Rohilkhand University, Bareilly (U.P.), India

Subjects: Mathematics, Statistics, and Physics

PROFESSIONAL EXPERIENCE

Employer : OneShield Inc. Nov 2007 – Till now

Designation: Oracle DBA – Sr. Database Administrator

OneShield Inc is insurance software and hosting services provider. Their premier product, Dragon (Insurance Policy management) is the most configurable, tools-based policy administration and workflow automation engine available in the market today and provides a robust system with proven ability to run commercial, personal, and specialty lines of business all on a single modern platform.

Responsibilities

• Created and configured: Oracle database using the Dragon application, databases on RAC environment, and database with Data Guard..

• Tested and certified , the critical patch set and new and enhance features of Oracle database for Application Dragon.

• Installed and configured Grid Control.

• Scripted the backup/recovery policy and procedure for Oracle database.

• Coordinated the Client-to-Setup new environment.

• Refreshed the Test or QA environment with Production data.

• Automated routine tasks through shell scripts.

• Performed and tuned using AWR , OEM Grid and tkprof etc Oracle Databases.

• Delivered production support on a 24x7 basis.

• Conducted backup/recovery through RMAN or Export & Import.

• Using of SQL Navigator and Toad 3rd party software.

• Implemented the database access security through triggers.

Client: Biogen IDEC Inc, Cambridge, MA April 2007 – Oct 2007

Designation: Oracle DBA – Sr. Team Member

Biogen IDEC is a 3rd largest biotech company in USA. They have a variety of medical products. They have about 200 databases, size ranging from 200G to 2 TB on different platforms, including HP-UX, Sun Solaris and Windows.

Responsibilities

Platform: HP-UX 11.11, Sun Solaris 5.8 or Solaris 8, Linux Redhat Enterprise 4

• Installed Oracle RDBM Software on a variety of platforms and server patch set.

• Created and upgraded Oracle Databases.

• Configured and managed Oracle standby database on databases 10g.

• Monitored/managed 2 node RAC environments, databases using OEM Grid control, and RMAN database backup and recovery

• Tuned application and individual SQL statements

• Tested and QA’d database refresh/cloning.

• Relocated and reconfigured tablespaces.

• Worked on VMware.

• Foglight Agent installed and configured on new Database Servers.

• Participated in creation/configuration/support of CRM Application databases and Clinical database administration (synchronized and uploaded of RAW Clinical data)

Client: Pfizer Inc. Groton, CT Jan 2006 – Mar 2007

Designation: Oracle DBA – Sr. Team Member

Worked with Pfizer Global Research & Development (PGRD) to provide the support to 1642 Databases on 221 Database Servers for 1077 Applications on different versions and operation system on different location (UK, Japan & US). Most of the databases are either on Oracle 10g or Oracle 9i and a few are still on oracle 8i due to application constraints.

Platform: HP-UX 11.0, Sun Solaris 7 and Window NT

Responsibilities

• Received the Pfizer Certificate of Appreciation to moved 260 databases to new server in record time.

• Served as Primary DBA for 15 Applications and as Oracle Clinical (clinical data management solution) Database Administrator.

• Assigned and coordinated work with Infosys off-shore team.

• Installed Oracle RDBM Software/Client on Sun Solaris, HPUX, & Linux Servers.

• Created/upgraded Oracle Databases.

• Configured/managed Oracle Data Guard for databases 10g/9i.

• Monitored databases for availability, security, and stand by

• Supported/tuned the data warehouse environment, Databases using Quest & Hotsos.

• Refreshed/cloned databases.

• Relocated/reconfigured tablespaces.

• Recovered databases using RMAN backup.

• Scripted Shell, awk for automation of DBA and System monitoring activities.

• Documented common processes.

Client: General Motors Nov 2003 – Jan 2006

Designation: Oracle DBA – Sr. Team Member

MAXIMO is a Planned Maintenance Database software application developed by MRO that helps organize Planned Maintenance jobs, Equipment history and Parts inventory.

Responsibilities

• Ongoing DBA Operations management with DB ranging in size of 20 GB to 80 GB.

• Supported 24*7 Production environments.

• Resolved On–Call issues including Monitoring, Ticket resolution and Work/ Change requests.

• Archived the SLA defied by client.

• Created 32 Oracle instances hosted on 3 Unix servers ( HP Server N Class)

• Monitored databases using home grown scripts.

• Troubleshot and performance tuned databases.

• Migrated & Upgraded databases (8.1.7 to 9.2.0.5).

Employer: DLF Universal Ltd., India New Delhi, India. Feb 2000 –Oct 2003

Designation: Oracle DBA 8i /7.x

DLF Group is engaged in construction of Commercial Buildings & Complex and Housing Apartments and Shopping Complex, Setup and Running of Power Plants and Golf Course Club (18 Holes).

Platform: Oracle 8i on HP-UX and WIN NT 4.0

Project: Support, Maintenance and Tuning of Oracle 8.x Databases of Size 15–20GB for different nature of business for In-house developed ERP Application i.e. Construction Company, Manufacturing and Hotel Industry.

Responsibilities:

• Oracle Installations, Database Designing (Physical/Logical Structure), Database Planning & Creation

• Space Management Planning

• Backup Strategies (Imp/ Exp, Cold/Hot)

• Recovery operations whenever required

• Data Uploading through SQL*Loader/

• Users Maintenance (creation & assigning roles & Privs. & other security features).

• Database Security & Strategy, Monitor & Optimize database performance.

• Monitor, Optimize & Performance tuning of Production Databases using self-made SQL scripts.

• Tuning and performance monitoring of ERP Application ‘DERP’ by using SQL tuning with SQL trace & TKPROF, Reducing I/O, rollback, lock contentions.

• Database instance tuning, Maximizing performance by setting utilization, storage parameter and allocating system resources (Shared pool, Buffer cache, Redo logs, Rollback segments)

Employer: Samtel Electron Devices Ltd. (SAMTEL GROUP), Ghaziabad, India. Feb 95 to Feb 2000

Designation: Oracle DBA 8i /7.x

Samtel Group is one of largest electronic component manufacturer with 90 billion turnover. Samtel Group engage in manufacturing of Picture Tubes for B&W, Color TV, all kinds of Electronic Guns & heaters (TV Tube Components) with 9 factories and a work force of 7500.

ISAP (Integrated Systems Application Package)

This application is made on the line of Enterprise Wide Package (EPS). Analysis of the whole project was done at all the Plants to derive the Union of requirements and in process also improve the work flow processes at Samtel. ISAP has been developed using CASE approach. ISAP has been divided in 4 major Modules as follows. I implemented Material Management System at one of plant Teletube Electronic.

• Material Management System.

• Financial Management system.

• Sales Management system.

• Payroll Systems.

Platform: HP-UX and WIN NT 4.0

Responsibilities:

• DBA of Database FOCUS.

• Helped in Design & Testing of the Modules.

• Implementation of Material Management System.

• Maintenance & Enhancement of all existing Business Applications.

• Provided End user's support & Training.

• Development of new reports as per user demand.

• Active Team player in the upgrade effort from FOCUS to Oracle Database.

• Systems Implemented: Material Management.

• Setup, Installed, configured, managed ORACLE database on HP-UX.

• Planned, Designed, And Created Database.

• Collaborate with vendors and Sys Admin to configure servers for high availability and performance.

• Systems administration of SCO Unix.

• Y2K Tests.

• Migrated data from Oracle 7.x Database into Oracle 8.x Database.

• Played key role in the migration of the whole our business application from FOCUS (HDBMS) to ORACLE 7.X thru ORACLE SQL*LOADER.

• Co-ordinate weekly meeting with customers.

Contact this candidate