Lead Database Developer

V Group Inc.; City of Albany (NY); On-site; USD 110,000 - 160,000; Full time

Job summary

V Group Inc. in Albany, NY is seeking a Lead Database Developer to support the Wadsworth ELAP program for the NYS Department of Health. Must have PowerBuilder experience of at least 7 years and strong Oracle/PL/SQL skills.

The role involves design reviews, reviewing data sets, building and testing new features, and documenting business rules as the legacy client-server applications migrate to a modern web-based version.

Qualifications

• 84 months of experience with coding client-server relational database applications using PowerBuilder.
• 84 months of experience with Oracle and PL/SQL. Experience should include creating tables, stored procedures, triggers, views, and other objects.
• 48 months experience with writing complex SQL queries and reports such as multiple JOINs, subqueries, conditional logic or windows functions; experience with data manipulation, data migration, and creation of ETL scripts.
• 48 Months as a lead developer on projects that included multiple developers working on the same project/component or had more than four developers on the team.

Responsibilities

• Participate in design review sessions with the program area.
• Review existing data sets and applications.
• Modify and support the applications until they can be replaced with a modern web-based version.
• Implement requirements by designing, coding, and testing new features.
• Document code-based business rules.

Skills

PowerBuilder

Oracle PL/SQL

Complex SQL

Lead Developer

Job description

Must have PowerBuilder Experience of atleast 7 Years.

Direct Client: NYS Department of Health (DOH)

Job Title: Lead Database Developer

Duration: 30 Months

Location: Albany, NY 12242

Interview Type: Webcasting

Ceipal ID: SNY_SQL916_PH

Job Code: HBITS-08-14916

Scope of Project:

Support application and database components of the Wadsworth ELAP program.

Responsibilities:

• Participate in design review sessions with the program area.
• Review existing data sets and applications.
• Modify and support the applications until they can be replaced with a modern web-based version.
• Implement requirements by designing, coding, and testing new features.
• Document code-based business rules.

Required/Preferred Skills:

• 84 months of experience with coding client-server relational database applications using PowerBuilder.
• 84 months of experience with Oracle and PL/SQL. Experience should include creating tables, stored procedures, triggers, views, and other objects.
• 48 months experience with writing complex SQL queries and reports such as multiple JOINs, subqueries, conditional logic or windows functions; experience with data manipulation, data migration, and creation of ETL scripts.
• 48 Months as a lead developer on projects that included multiple developers working on the same project/component or had more than four developers on the team.

V Group Inc. is a NJ-based IT Services and Products Company with its business strategically categorized in various Business Units including Public Sector, Enterprise Solutions, Professional Services, Ecommerce, Projects, and Products. Within Public Sector business unit, we cater IT Professional Services to Federal, State and Local. We have multiple awards/contracts with 30+ states, including but not limited to NY, CA, FL, GA, MD, MI, NC, OH, OR, CO, CT, TN, PA, TX, VA, NM, VT, and WA.