Oracle Sql
Resume:
Surya Prashant
abho0v@r.postjobfree.com
SUMMARY:
. Around 8+ years of experience as Oracle Applications DBA / Oracle DBA
and Oracle Developer (4yrs). Worked with Oracle 7.x//8.x/9.x/10g/11g,
and Oracle Applications 11i/R12
. Excellent hands on experience with Oracle Server Installation 9i, 10g.
. Experience in installing Oracle Applications 11i, R12 on linux and
solaris.
. Experience in Cloning 11i and Patching, AD Utilities, Management of
concurrent managers, Upgrades and Configuration various versions of
Apps, Database Tuning, Client/Server Connectivity, Application Tuning,
Query Optimization, Backup/Recovery, Security Management and Post
Installation Troubleshooting.
. Experience in clones using Rapid Clone Including Database refreshes
for Dev, QA and PROD environments.
. Experience in performing Application administration tasks using System
Administrator, Application Developer responsibilities and AD utilities
. Experience in application patching using Autopatch/OAM/patch history
database, and with AD Utilities used to control and maintain the
Application including autoconfig.
. Good experience in giving Oncall Support for PROD Instance.
. Good experience with concurrent managers including scheduled jobs,
monitoring, tuning, troubleshooting, Work flow inbound, outbound
setup, Administration and Troubleshoot.
. Experience in configuring Printers, Reports, Administering Concurrent
Managers and Work Shifts, User Registration, Customization and
Assignment of Responsibilities, Incorporating Custom programs,
Managing Profile Options
. Setup Workflow and configured it with notification mailer
. Expert in application configuration and upgradation with Oracle
Applications 11i, Oracle Server Installations
. Upgradation of databases from Oracle 9i to 10g.
. Good Knowledge in Installation and maintenance of oracle10G RAC
database.
. Database migrations from UNIX to Linux of size more than 4TB.
. Experience working with Export/Import, Data pump.
. Hot and cold Backup and recovery of oracle 10g database using tools
like RMAN
. Experience with Oracle 9i and 10g Partitioned Tables.
. Experience in managing large data warehouse databases.
. Strong Experienced in Oracle Server Installations / Upgrades, Space
Management, Backup & Recovery, Disaster Recovery, Database Performance
Tuning, Memory Tuning, Application Tuning, Security Administration,
Oracle 9i Data Guard, and Oracle Standby Server.
. Excellent experience on third part-parties tools and native tools like
in, TOAD, OEM and OAM
. Excellent experience with SQL and PL/SQL
. Database performance tuning using STATSPACK, TKPROF, SQL Trace,
Explain Plan.
. Good Knowledge in Oracle Financials, Oracle HRMS and Manufacturing
modules
Technical Skills:
Operating Sun Solaris 8, 9, 10, Linux RHEL 4, Windows NT,
Systems Windows 8/NT/2000
Database Oracle 7.x / 8.x/9.x/10g/11g, Oracle 10g (RAC)
Tools RMAN, OEM, OAM, EXP, IMP, datapump (expdp, impdp),
Tunning Tools SQL*Loader, TOAD
TKPROF, EXPLAIN PLAN, STATSPACK
ERP Oracle Applications 11i / R12
GUI Developer 2000 (Forms 4.5, 6i and Reports 2.5, 6i)
Languages SQL, PL/SQL, C and UNIX Shell.
EMPLOYMENT HISTORY
Bank of America, Jacksonville, FL Jun' 09 -
till date
Role: Oracle Applications DBA
Responsibilities:
. Installation of Oracle Applications R12
. Upgradation from 11.5.10.2 to R12
. Installation of Oracle Applications release 11.5.10.2
. Installation and configuration of 10 RAC
. Cloning of applications and databases from production databse to test
and devlopment databases.
. Taking Hot and cold Backup and recovery of oracle 10g database using
tools like RMAN
. Performing 10g Application Server tasks and troubleshooting issues.
. System Administration of 11i ( Report registration, custom programs)
. Applied the patches using ADPATCH
. Setting up Workflow and configured it with notification mailer
. Setting up of printers
. Registered custom modules in Application Environment
. Registered Forms, created Form Functions and Menus
. Registered Executables, created Concurrent Programs and Request Groups
. Created Responsibilities and Application Users
. Created TARs and follow-up with the Oracle
. Performed Application admin tasks using ADADMIN utility
. Maintenance of Concurrent Managers
. To take backups as per the corporate policy and perform restore and
recovery as and when required.
. Applied OS patches
. Verified all instances are up and running
. Verified that all Application Services are on-line
. Resolved Jinitiator issues
. Reviewed the Alert log file entries
Environment:
Oracle 9i and 10g,11g, oracle Application 11.5.10,11.5.10.2, R12, Oracle
10g AS, E Business Suite,, OEM, SQL * plus, imp/exp, rman, SQL, pl/sql,
Linux RHEL4, Solaris.
Commercial Metals Company, Irving, TX Dec'
07 - May' 09
Role: Oracle Applications DBA
Responsibilities:
. Upgrade 11.5.9 apps to 11.5.10 by applying 11.5.10 maintenance pack.
. Applications cloning and applying patches..
. Upgrade the associated third party tools.
. Cloning from production database to development and testing
environments.
. Involved in Managing Concurrent Programs and Requests, Configuring
Printers, User Registration, assining Responsibilities to users.
. Applied patches both applications and database using adpatch utility
. Backup and recovery using RMAN
. Configured the physical standby server at DR sites.
. Complied schemas and generated updated reports and forms using adadmin
utility.
. Creating new concurrent managers, managing and trouble shooting
concurrent managers
. Resolved printing issues.
. Setup Workflow 2.6 and configured it with notification mailer and MS
Exchange server.
. Registered custom application in application environment,
. Created custom concurrent programs, concurrent request sets and form
functions in application environment.
. Installation OEM Grid and configuration and Documenting Setup.
. DBA on call support to offshore team.
.
Environment:
Oracle 8i/9i/10g, Oracle Application 11.5.10, 11.5.10.2, OEM, OAM, SQL*
plus, imp/exp, rman, SQL, pl/sql, SQL* loader, Linux RHEL4, Windows XP.
Herbalife, LA, CA Sep' 06 -
Oct' 07
Role: Oracle Application DBA
Responsibilities:
. Installation and Implementation of Oracle 11i Apps (11.5.10.2) with
10g R2 Database on Linux4.0 environment.
. Perform clones using Rapid Clone Including Database refreshes for Dev,
QA
. Performed Application administration tasks using System Administrator,
Application Developer responsibilities and AD utilities
. Performed application patching using Autopatch/OAM/patch history
database, and with AD Utilities used to control and maintain the
Application including autoconfig.
. Performed Oncall Support for PROD Instance.
. Extensive work with concurrent managers including scheduled jobs,
monitoring, tuning, troubleshooting.
. Work closely with Security Admin team and Assist with
User/Role/Responsibility Administration.
. Performed OWC for SR1 Tars with Oracle to Identify and resolve the
Issues.
. Coordinate with DBA team for Running Database Health Checks.
. Responsible for Installation, Setup 10g R2 Database.
. Installation OEM Grid and configuration and Documenting Setup.
. Performed DBA on-call support rotations.
Environment:
Oracle 8i/9i/10g, Oracle Application 11.5.10.2, OEM, OAM, SQL* plus,
imp/exp, rman, SQL, pl/sql, SQL* loader, Linux 4.
Sprint Nextel, Overland Park, KS Mar' 05
- Jul' 06
Role: Oracle Application DBA
Responsibilities:
. Administering Oracle Application System on Sun Solaris Systems.
. Cloned Multi node system to Multi node system
. Application System Administration and AOL tasks
. Patching using adpatch, admrgpch and adctrl AD utilities
. Performed the Administration tasks using adadmin and adrelink
. Tested the custom concurrent programs, request sets and forms in TEST2
and FINQA instances and then moved these objects to production using
FNDLOAD.
. Integration, QA and gold instances.
. Registered custom application and created responsibilities, menus,
request sets and request groups and assigned responsibilities to the
front-end Application users.
. Registered SQL* Loader control files, reports, forms and HOST scripts
Environment:
Oracle 8i/9i, Oracle Application 11.5.8 E Business Suite, OEM, SQL* plus,
imp/exp, rman, SQL, pl/sql, SQL* loader, tkprof, Sun Solaris 8, Windows
2000.
Iprobe Technologies, Pune, India Jul' 03
- Jan' 05
Role: Oracle Applications DBA
Responsibilities:
. Installation of Oracle Applications release 11.5.8 on Windows 2000
platform
. Cloning of Oracle APPS 11.5.8 Instance on HP-UX 11.0 platform
. System Administration of 11i ( Report registration, custom programs)
. Applied the patches using ADPATCH
. Registered custom modules in Application Environment
. Registered Forms, created Form Functions and Menus
. Registered Executables, created Concurrent Programs and Request Groups
. Created Responsibilities and Application Users
. Created TARs and follow-up with the Oracle
. Performed Application admin tasks using ADADMIN utility
. Maintenance of Concurrent Managers
. To take backups as per the corporate policy and perform recovery as
and when required.
. Applied OS patches using swreg and swinstall utilities on HP Machine
. Verified all instances are up and running
. Verified that all Application Services are on-line
. Resolved Jinitiator issues
Environment:
Oracle 8i/9i, Oracle Application 11.5.8, 11.5.7, E Business Suite, Oracle
Application server 9iAS, OEM, SQL * plus, imp/exp, rman, SQL, pl/sql, SQL*
loader, HP-UX 11.0.
Visaka Industries Ltd, India
Jun'02- May'03
Role: Oracle Applications DBA
Project Description: Visaka Industries was established in 1985 and
diversified into Textiles and asbestos, manufactures yarns using state-of-
the-art Twin Air Jet spinning technology from Murata, Japan with 28 MTS
Machines equivalent to 50,000 Ring Spindles. Produces about 7,000 metric
tunes of yarn per year and exports about 2,000 tones to countries around
the globe. Visaka Implemented GL, AP, AR, FA, CM, PO, OPM and OM on IBM AIX
5L platform.
Responsibilities:
. Installation of Oracle Applications
. Cloning of Application Instance
. Applied the patches using ADPATCH
. Performed Application admin tasks using ADADMIN utility
. Applied India Localization patches
. System Administration of 11i
. Setting up of printers
. Register Executables, created Concurrent Programs and Request Groups
. Created Responsibilities and Application Users
. Creation and Maintenance of concurrent managers
. Upgraded Oracle Database from 8.1.5 to 8.1.7 on Windows 2000 platform
. Migration of Oracle 7.2 Database from Novel Netware to Oracle 8.1.5 on
Windows NT platform
. Security of database by defining roles, views and synonyms
. Created TARs and follow-up with the Oracle
. Resolved Jinitiator issues
. Reviewed the Alert log file entries
Environment:
Oracle 7.x/8.x/9i, Oracle Application 11.5.7/11.5.8, E Business Suite, OEM,
OAM, SQL * plus, imp/exp, rman, SQL, pl/sql, SQL* loader, Net8, tkprof, AIX
UNIX 5L, Windows NT/2000.
Visaka Industries Ltd, India
Jan'98- May'02
Role: Oracle Developer
Project Description: Visaka Industries was established in 1985 and
diversified into Textiles and asbestos, manufactures yarns using state-of-
the-art Twin Air Jet spinning technology from Murata, Japan with 28 MTS
Machines equivalent to 50,000 Ring Spindles. Produces about 7,000 metric
tunes of yarn per year and exports about 2,000 tones to countries around
the globe. Visaka Implemented many independent modules designed to their
working environment. The modules like FA, Despatch, Stores, Sales and
Accounting. I was involved in their development team developed the
applications using Oracle forms developer and reports developer.
Environment: Oracle 7.x/8.x/9i, Windows NT/2000.
Contact this candidate