Title : PL/SQL developer
Location: Trenton NJ
Locals only
Please share profile on vaibhavi@pcsionweb.com
Years of Experience: 7 plus years
Education:4 year college degree or equivalent technical study
Role Description:
· Understand government business process and operations, including familiarity with HIPPA and NJAC regulations.
· Prior knowledge of health-related data concerns in order to transition business processes into technical requirements.
· Excellent communication and presentation skills to review, analyze, and evaluate business systems and user needs by facilitating brainstorming sessions with health professionals.
· Highly skilled at database design, installations, conversions
· Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management
· Participates in Database Management System selection and maintains database performance
· Engage in ongoing process improvement
· Experienced in Database Performance, Maintenance and Development to perform the following:
· -Database management including backups, recovery and maintenance
· -Database management for export, import and mass data loads
· -Analyzes and generation of all tables and index statistics using Data Analyzer
· -Monitoring and resolving data lock issues using Lock Manager
· -Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes using Performance Manger
· -On-Line Transaction Processing (OLTP) to capture, validate and store large amounts of transactions
· -Use Explain Plan & TKPROF utility for Sql query to improve response time for all reports
· -Create a gamut of indexes to achieve critical dataset response time for time sensitive reports.
· Experienced in Database Design and Development to perform the following:
· -New projects database design utilizing Erwin 4.x
· -Various objects development such as Packages, Procedures, Functions, Triggers for business logic implementation
· -PL/SQL procedures development, compilation and debugging using Toad 7.x
· -Utilizing JDK for complicated PL Java oracle stored procedures development
Req
| Oracle 11g | Required | 7 | Years | |
| Oracle 12.x | Highly desired | 2 | Years |
|
| PL/SQL | Required | 7 | Years |
|
| |
|
| Writing and modifying Oracle Stored Procedures | Required | 7 | Years |
| |
| Toad 10.x and above | Required | 4 | Years |
|
| |
|
| JDK for complicated PL Java Oracle store procedures | Required | 5 | Years |
| |
| DB Troubleshooting AND performance tuning | Required | 5 | Years |
|
| |||||
| | Excellent written and verbal communication | Highly desired |
|
|
| |||||
| Experience with public health related web enable applications | Desired | 1 | Years |
|
| |||||
|
| Prior NJ DHSS Experience | Nice to have |
|
|
| |||||
Kindly add me to your distribution list : vaibhavi@pcsionweb.com
Thank You
Vaibhavi
Param Consulting Services Inc.
Tel: 732-404-0411/0466 Ext. 5108
Fax: 732-404-0422
Yahoo IM: vaibhaviparam
Gtalk : vaibhaviparam
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at http://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment