Sr Developer/DBA
Resume:
Vikram Singh
404-***-**** / Email: ******.*****@*****.***
SUMMARY:
• Over 12 years of experience in the Information Technology industry
• Over 4+ years of experience as Production support DBA
• Installed, Configured and Cloned eBusiness Suite R11 and R12 on Solaris and Linux
• Managed eBusiness Suite 10.7, R11i & R12 Forms, Reports and Concurrent Managers
• Member of upgrading team from 11.5.10.2 to R12.
• Managed and Supported 24X7 Apps Databases provided on-call and day-to-day support.
• Expert in management of 10G RAC using ASM/NFS on Linux/Unix platforms
• Expert in Backup & Recovery and handling corrupt Databases.
• Expert in Performance Monitoring and Tuning of Oracle Databases on Unix/Linux platform
• Installed and Integrated with eBusiness suite OBIEE and SSO in development & production environments
• Experience in Installation, Configuration of various Application software’s like Oracle 7.x/8.x/9.x /10g R1/10gR2 Database, Automatic Storage Management (ASM), Oracle 9i Internet Application Server (9iAS), Oracle Management Server (OMS), Oracle Enterprise Manager (OEM), Enterprise Manager Grid Control (GRID Control), Oracle Real Application Cluster (Oracle RAC) on various platforms.
• Applying patches to Oracle Database, Oracle APPS, and Grid Control.
• Maintaining high availability of database and disaster management using Standby databases, Data Guard, Cloning, Replication and Oracle Real Application Clusters (RAC).
• Good understanding of the Oracle Applications 11i/R12 architecture and the various Application tier and Database tier components: schemas/products, file structure, underlying objects.
• Designed Backup strategies and Tested Recovery procedures
• Installed and Configured Oracle Grid Control system
• Installed and Configured Oracle Standby/Data Guard
• Have excellent written and verbal communication skills
SKILLS PROFILE:
Oracle 7 – 11g DBA
High Availability – Real Application Clusters (RAC)
Disaster Recovery – Data Guard and RMAN
Modeling, Installation, Upgrades, Migration
SQL and PL/SQL
SQL*Loader
Training and Mentoring
Business Intelligence
OBIEE
ERP EBusiness Suite 10.7, R11 & R12
Environment and Hardware Support Unix (Solaris) – E6800, E4500, Unix(HP-Ux), Unix(AIX), Linux (RedHat Enterprise), Windows 2000, Windows 2003, SSO
WEB Applications Netscape Enterprise Server, OAS, Apache, OC4J
Tools OEM, Oracle Diagnostic and Management Packs, Grid Control
PROFESSIONAL TRAINING/CERTIFICATIONS:
• Post Graduate Diploma in Systems from CMC Ltd.
• Completed course in Oracle 10G RAC, Oracle Grid Control from Oracle Education Centre
• Oracle 10gR2 RAC Certified (OCP)
• Oracle 8i and 10g DBA Certification (OCP)
PROJECT DETAIL:
Client: NCR Corporation Duluth, GA Nov 2009 to Till Date
Role: Lead Oracle APPS DBA
Project Details: NCR Corporation is a product based company, building ATM machine and various other activities. It is an internal support team. This supports Test, Development, UAT and Production environments. Coordination with functional team to fix performance issues.
Responsibilities:
• Monitoring and maintaining Production/Development/QA Databases ranging 50GB to 11TB for 24x7 environments in integration with SSO and OBIEE.
• Managed, Supported & Tuned 9i &10G RAC on ASM, Data Guard databases
• Strong management experience on 10G Clusterware & ASM.
• Supporting Forms server / Web Server / Database-Admin server Cloning (Rapid Clone and Manual)
• Oracle apps adadmin utilities: ADADMIN, ADCTRL, ADPATCH, ADIDENT to resolve day to day tickets/ jobs.
• Daily scheduled tasks Different kind of backups / copies / restores, performance activities, Weekly Production Activities, New Environment building, Migration Activities, troubleshooting of (Concurrent Managers / Apache / Forms).
• Administering Concurrent Manager and Concurrent Requests.
• Various Data base administration tasks in Oracle10g, 9i, 8i specific to Apps
• Organize the capacity planning of the production database, Test and Dev databases and provide assistance with the core functions of production database support, including creating and maintaining databases, backup and recovery, security, upgrades, cloning and post cloning activities.
• Consult and guide the programming team in performance-related issues such as design of data structures, SQL coding and maintenance of database objects.
• Implement standby, managed recovery databases using Data Guard and Data Guard Broker
• Support the UNIX and Linux Administration tasks on a day-to-day basis with OS issues.
• Interact with the Project managers for timely delivery of different tasks and follow up with them on a regular basis.
Technical Environment: Solaris 10 (SPARC), Linux, Oracle 11g, Oracle 10g (RAC) , Oracle Grid Control
Client: Royal Bank of Scotland, UK Feb 2006 to Oct 2009
Role: Senior Oracle (APPS DBA)
Project Details: RBS was trying to move data from Mainframe systems to ERP systems. The project deals with supporting Test and Development instance support and maintenance. Functional team was responsible for moving data from Mainframe system to ERP systems. Production will be going live very soon.
Responsibilities:
• Installation of Oracle Application 11.5.9, 11.5.10 & R12
• Leading a Team of APPS DBA’s. Periodically Performance evaluation of Team members. Setting their objectives.
• Part of the 11i to R12 upgrade team.
• Staff training.
• 24x7 monitoring and maintaining Production/Development/QA Databases ranging 50GB to 1TB
• Offshore APPS DBA support for Oracle Financial apps like troubleshooting concurrent request issues, any service down/outage
• Monitoring and support of Forms server / Web Server / Database-Admin server Cloning (Rapid Clone and Manual)
• Patch Management process for Applications and Oracle Database
• Oracle Apps ADADMIN utilities: Adadmin, Adctrl, Adpatch, Adident etc. to resolve day to day tickets/jobs.
• Daily scheduled tasks Different kind of backups / copies / restores, performance activities , Weekly Production Activities, New Environment building, Migration Activities, troubleshooting of (Concurrent Managers / Apache / Forms ).
• Providing on-call production support includes monitoring all Production / Non Production Alerts and takes corrective actions and does necessary escalations.
Technical Environment: Sun Solaris 9 / 10, Linux, OBIEE Suite, Oracle 10G, eBusiness Suite R11, ASM, Grid Control, Legacy Systems, RAC
Client: Oracle Corporation India Pvt. Ltd. Jan 2004 to Jan 2006
Role: Senior Oracle DBA
Project Details: Worked with Workflow Development team, managing their development environments, making sure that everything is up and running 24*7. Helping development team in fixing workflow related issues and resolving customer Bugs.
Responsibilities:
• Installation of Oracle Application 11.5.9, 11.5.10
• Patch Management process for Applications and Oracle Database
• AD-Utilities for various tasks and configuring printer for Apps.
• Administering Concurrent Manager and Concurrent Requests.
• Interact with the Project Managers for timely delivery of different tasks and follow up on a regular basis.
• Available 24 x 7 for problem resolution, including on-call responsibilities.
• Extensive use of Explain Plan and TKPROF.
• Implemented standby databases using Data Guard.
• Provided assistance with the core functions of production database support.
• Assisted in the technical consultation and guidance to programming teams in performance-related areas such as design of data structures, SQL coding and maintenance of database objects.
• Interacted with the management for timely delivery of different tasks and followed up with them on a regular basis.
Technical Environment: Sun Solaris 9/10, Linux, Oracle 9i (R11), eBusiness Suite R11.
Company: HCL Comnet Sep 2003 to Jan 2004
Client: Sun America, USA
Role: Database Administrator
Project Details: Sun America deals with insurance sector. We were supporting their databases in off hours, working closely with onsite team and helping them in resolving performance issues as well creating new instances.
Responsibilities:
• Installed, Configured and Managed ASM storage for RAC system.
• Wrote database monitoring scripts
• Worked as a part of a team and provided 7 x 24 production support
• Motivating team to meet deadlines and Client expectations.
• Identify and resolve database locking and monitor database performance
• Manage database objects, users and maintain security
• Import/Export data to/from PROD and TEST as required
Technical Environment: Sco-Open Server, Windows NT, Oracle 7 / 8i
Client: CMC Ltd. Apr 1999 to Jun 2003
Role: Oracle DBA
Project Details: CMC has many Government clients. They build application for various clients and later on support them as well. I was working in a DBA team, which was looking into maintenance and support of Oracle databases.
Responsibilities:
• Responsible for Maintenance and Support of 24x7 Client Infrastructure
• Supported Oracle and Solaris
• Interacted with Developers, Business users, Management on Issues, Enhancements and Project deadlines.
• Identify and resolve database locking and monitor database performance
• Manage database objects, users and maintain security
• Import/Export data to/from PROD and TEST as required
• Customized performance tuning scripts to gauge system utilization
• Patching OS and Oracle DB per vendor recommendations
• Created backup strategies for client environment for Application, Databases, and OS
Technical Environment: Sco-Open Server, Windows, Oracle 7, 8, 8i
Client: Shakti Computers Apr 1998 to Apr 1999
Role: Oracle Developer
Project Details: Shakti Computers has in house project. Fully automation of their sales record, I was part of development teams, writing PL/SQL, stored procedures etc.
Responsibilities:
• Responsible for Installations and Configurations Oracle on Sun Solaris.
• Coding using Developer 2000 and Forms 6i.
• Performance monitoring and tuning
• Documented the complete process of Installations of Operating Systems, Oracle Database, and Application Servers
EDUCATION:
• Bachelor Degree in Mathematics.
• Post Graduate Diploma in Information Technology and Management.
Contact this candidate