Oracle PL/SQL Developer
Job Title : Oracle PL/SQL Developer Location: Merrimack, NH Job Type: Contract Rate: $70/hr Contract Duration: 1 Year This is an individual contributor role and in addition to analysis, modeling and design, the role is expected to write Informatica loaders, Develop PL/SQL procedures and SQL queries. Strong SQL knowledge is desired. Knowledge of Fixed Income security, Index and Analytics data is highly desirable. Additionally understanding portfolio construction and exposure management processes is desired as well. Position can be upgraded for the right person but will continue to remain an individual contributor role. Primary Responsibilities Database Requirements Analysis Responsible to understanding, articulating, documenting and presenting DB requirements (both business and technical) on the assigned projects Interact with DB, Applications analysts and Business users for requirements gathering and validation Analyze current data to ensure no requirements are missed Work with quality assurance team to build test plans to validate that new systems meet the business requirements Ensure that requirements are understood and handed off to the development teams if required Provide support to DB development teams on requirements if required Database Modeling Prepare DB logical and physical models based on requirements and best practices Review and obtain sign off on data models from architecture and other supporting organization Database Design Apply best practices to come up with DB designs to meet or exceed business needs. Including but not limited to physical databases, schemas, table structures, indices, data marts, program structure, batch processing, performance, que, event driven processing, etc. Review and obtain approvals on designs through database design review boards Document designs and knowledge transfer to development team if required Help optimize designs as production issues arise Apply best practices to come up with DB designs to meet or exceed business needs. Including but not limited to physical databases, schemas, table structures, indices, data marts, program structure, batch processing, performance, que, event driven processing, etc. Database Development Develop, unit test and deploy SQL, PL/SQL, ETL Informatica, JIL code Acquire Q/A signoff for production deployment Document operational procedures and transition system to operations team Make enhancements, bug fixes and performance improvements Project Relationship and Communication Management Communicate with project management Manage status reporting and problem escalation to project and database technology stakeholders where appropriate Identify risks, create risk management / mitigation / transfer plans and implement plans to contain risk Qualifications Education and Experience Bachelor's degree required; MBA or MS preferred 10+ years experience in a large technology organization specialization on Database development Must have played a lead role in large database development projects Cross functional experience with application, batch process and event based system designs Experience in a Asset Management company is highly desirable Skills and Knowledge Strong communication and influencing skills with demonstrated ability to interface with multiple levels as well as building productive working relationship in a matrix organization. Excellent written and verbal communication skills Ability to challenge status quo in a respectful manner Objectively listen, evaluate, and help others to see the way forward Excellent problem solving and decision making skills. Strong technical background in database and some experience with application designs Ability to quickly synthesize ideas, options, and thoughts into solutions to management to aid in decision making Highly motivated and energetic; able to juggle multiple priorities concurrently Strong Data and Requirements analysis skills Strong data modeling and DB normalization skills including OLTP and DW Minimum 5+ ( 10 years desired) years of hand on development experience in the area of Oracle PL/SQL, Informatica, PERL, Unix, Autosys Regards, Alok Mishra VBeyond Corporation (408) 833-6131 (Direct) (866) 614-3884 (Fax) alokm@vbeyond.com http://www.vbeyond.com
|
Merrimack
|
Expired |
Susan Writes Precise
Virtual Assistant
View profile
Bob Kearney
Audio Specialist
View profile
Markéta Lacroix
Graphic Designer
View profile
Related projects
Search for freelance jobscan’t wait for more clients
and advertising. Thank you."