Please submit resumes to gopal@metasenseusa.com
Position: Database Administrator
Duration: 5 months
Location: Mercer County, Trenton, NJ
Interview Type: In person only
Description:
|
| ANALYSIS & DESIGN
1. Act as the DOBI Oracle DBA, and assume the following responsibilities:
a. Maintain existing backup and recovery policies and procedures, and make recommendations for improvement as needed
b. Manage the design and usage of new and existing database elements, tables, schema, views, etc.
c. Implement and maintain database and application security (create and maintain users and roles, assign privileges, etc.)
d. Assist with the creation and maintenance of documentation and standards
2. Attend meetings with DOBI IT staff to provide insight on Oracle-related matters
3. Attend meetings with DOBI business personnel to assist with feasibility studies
4. Review and analyze user specifications to design new or enhance existing forms and reports
5. Evaluate and revise existing business processes as needed
6. Give demonstrations of products under development to DOBI personnel when necessary
7. Knowledge of WANG Pace-to-Oracle conversion software and the ability to understand and maintain the resulting code is a plus
PROGRAMMING
1. Ability to efficiently code database queries using PL/SQL for Oracle 10g Release 2
2. Ability to create and maintain efficient and user-friendly forms using Forms Builder for Oracle 10g Release 2
3. Ability to create and maintain accurate and comprehensible reports using Reports Builder for Oracle 10g Release 2
4. Modify and maintain all existing Oracle forms and reports
5. Ability to create and maintain efficient and user-friendly forms using Oracle JDeveloper with ADF for Oracle 10g Release 2 is a plus
6. Knowledge of APEX/HTML DB is a plus DEVELOPMENT TOOLS
1. Proficiency in the use of Oracle Enterprise Manager for Oracle 10g Release 2, for both the database server and the application server
2. Proficiency in the use of Oracle SQL Developer for Oracle 10g Release 2
3. Proficiency in the latest releases of Toad or PL/SQL Developer as a substitute for the above, where appropriate
4. Proficiency in the use of Oracle JDeveloper with ADF for Oracle 10g Release 2 and above is a plus
CONSULTING
1. Act as the DOBI Oracle DBA, and assume the following responsibilities:
a. Evaluate new Oracle features and Oracle related products
2. Upon request, provide suggestions on "best practices" regarding Oracle database and application usage
3. Upon request, provide guidance to the DOBI IT staff on "best practices" regarding SQL, stored procedures, functions, queries, views, etc.
4. Upon request, provide guidance to the DOBI staff on alternate methods to solving business problems based on prior experience with Oracle related products
TECHNICAL SUPPORT
1. Act as the DOBI Oracle DBA, and assume the following responsibilities:
a. Install, configure and upgrade Oracle Database server software and related products as needed
b. Install, configure and upgrade Oracle Application server software and related products as needed
c. Monitor and fine-tune database performance, as needed
d. Monitor and fine-tune application performance, as needed
e. Monitor server capacity and plan for growth and changes
f. Perform general technical and application trouble-shooting and provide recommendations for resolution to IT staff as needed
g. Interface with Oracle Corporation for additional technical support.
2. Assist with Windows related upgrades on Oracle servers that may affect Oracle usage or performance
3. Assist with third party software or upgrades on the DOBI network that may affect Oracle usage or performance
4. Assist with maintaining a usable local Oracle test environment for DOBI IT staff
OTHER REQUIREMENTS
1. Must have 12 to 20 years of Oracle development experience
2. Must have a 4 year college degree or equivalent technical study or advanced degree
3. Must have an understanding of New Jersey government business processes and operations
4. Must have the ability to transition business processes into technical requirements
5. Must be able to anticipate and resolve issues and risks that may affect the success of the various DOBI projects
6. Must execute all responsibilities with minimal supervision
7. Must be prepared to provide knowledge and skills transfer to DOBI IT staff as needed
8. Must be prepared to work on-site at the DOBI location at least 3 days per week
9. Normal work day will be an 8 hour day
10. Work schedule must be flexible to allow for emergencies
11. Provide the DOBI IT Director with a monthly progress report, identifying the accomplishments made during the target month, and the plans/goals for the upcoming month. This report should be completed by the end of the last work day closest to the end of the target month
12. Provide the DOBI IT Director with a monthly time usage report, summarizing the hours worked during the target month. This report should be completed along with the monthly progress report, and should be cross-referenced to the vendor's billing system |
| Skill | Required / Desired | Candidate Experience | Last Used |
| Experience in Oracle development | Required – 20 years |
| |
| Knowledge of Oracle 10G database | Required – 3 years |
| |
| PL/SQL for Oracle 10G database | Required – 3 years |
| |
| Forms Builder for Oracle 10G | Required – 3 years |
| |
| Report Builder for Oracle 10G | Required – 3 years |
| |
| Knowledge of Oracle 10G Application Server | Required – 3 years |
| |
| Oracle Enterprise manager for Oracle 10G R2 | Highly desired – 3 years |
| |
| Oracle SQL Developer for Oracle 10G R2 | Highly desired – 3 years |
| |
| XML to Oracle conversion | Highly desired – 1 years |
| |
| Oracle JDeveloper with ADF for Oracle 10G R2 | Highly desired – 1 years |
| |
| Knowledge of DOBI environment | Highly desired - 0 |
| |
Thanks & Regards,
Gopal
MetaSense, Inc.
NJ Minority Certified Company
100 Technology Way, Suite 320
Mt. Laurel, NJ 08054
Fax: (856) 475-0555
gopal@metasenseusa.com
www.metasenseusa.com
MetaSense Inc. is a Professional Services, Staff Augmentation, Web Design, Call Center, BPO Company with offices located in Mt. Laurel, NJ. MetaSense specializes in the delivery of cost effective, high-value Information Technology and Business Solutions since its inception in 1999.
P Go Green! Print this email only when necessary.
--
Introduce business in 3800 cities. How?
=====================================================
Thanks for using group.
Moderator
1) This group is managed by www.BRCIndex.blogspot.com
2) Post your message with your linkedin Profile (Visit linkedin.com) to confirm your identity and refer business.
3) Visit www.BRCIndex.blogspot.com (3800 Business Referral Club)
4) Reply to two message before posting new one.
5) Donot post same message in all 3800 business Referral Club.
You received this message because you are subscribed to the Google Groups "Outsource" group.
To post to this group, send email to Outsource@googlegroups.com
To unsubscribe from this group, send email to Outsource-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Outsource
No comments:
Post a Comment