Nayeem, We have a new DB Developer role in Salem OR
Project Background: The Department of Human Services Self Sufficiency Modernization Program supports automation improvements in several areas, including benefit programs for Oregon citizens and internal systems used by DHS caseworkers and field staff. This is a major effort with both short and long-term deliverables including web-based applications, data warehouse work, and a large data migration / conversion effort. Data Architect Position: This role is will have primary responsibility to support development teams and projects. The role will include work as a data architect (data modeling, database design), database developer (stored procedures, SQL development), and database administrator (data loading, optimization, support, etc). Project support will include: 1) database design for a series of web-based applications that include integration with legacy systems, 2) data conversion from legacy mainframe systems (VSAM) to normalized data in a DB2 environment and 3) planning for a data warehouse effort. This position will be part of the Self Sufficiency Modernization development team but will also work under the direction of the existing DHS DB2 operational team. Technologies Involved: The Department of Human Services legacy applications reside in a mainframe environment. DB2 is the primary relational database platform (AIX) and WebSphere / J2EE is a potential web application environment. Cold Fusion is a supported development platform that will be used for short-term solutions. There is a need to support efforts towards a SOA-based architecture. We plan development work to employ agile methodology where appropriate. Skill Set -Lead data modeling work. -Create and document logical/physical design. -Design and implement proof of concept and development prototype work. -Work with system admins and DRM group to implement database solutions. -Creation of database and various objects. -Write scripts to unload data and automate autoloader scripts. -Create test cases for benchmark testing. -Performance tuning was an ongoing process, tuning queries. -Support SQL tuning / optimization, DB/DBM parameter tuning, different levels of memory allocations -Utilize tools for export, import, load, autoloader and database snapshots. -Creating and Monitoring Users, authorities and responsibilities and password management. -Backup & Recovering Database, Online database backup, archived redo log file and offline database backup. -Tuning the application for the best performance. -Tuning the Database and the system for the best performance. -Day-to-day attending to the developer queries in sorting out database problems. -SQL Programming -- developing database views and stored procedures. Requirements -7+ years of database development experience, including DB2 / UDB ver. 8 and above -5+ years of SQL programming, including stored procedures. -7+ years of data modeling experience. -Experience support DB2 on multiple platforms (AIX, zOS) -Ability to interact with team members including business owners -Familiarity and experience with legacy mainframe data systems (VSAM) helpful. -- Nayeem Amin Decca Consulting Ph: 832 561 0634 [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "jobinusa" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/jobinusa?hl=en -~----------~----~----~----~------~----~------~--~---
