Innovations technological

***MUST BE ABLE TO INTERVIEW ONSITE IN PHILADELPHIA, PA***

New Requirement Details

Title: SQL DBA

Client: City of Philadelphia – Water Works

Location: Philadelphia, PA

Interview Process: Phone Interview followed by a face-to-face personal interview at the vendor and/or candidate's expense.

Duration: 1 Year (12 Months)

Additional Information:

Process to submit to Modis for review:

1.       Attach the candidate's resume, as well as the candidate's phone and email contact information.

2.       Include the candidate's current location and ability to have a personal face-to-face interview after the phone interview.

3.       Include the candidate's confirmed rate, if you directly hold the candidate's Visa (or a partner company does), and the end date of the candidate's last contract.

4.       Include the candidate's references.

5.       Please do not call to inform us of the submission, but reach out through email if you have any specific questions.

6.       You will be alerted to feedback if we are pursuing a candidate or not. Thanks!

Job Description:

Modis has an opening for a SQL Database Admin with a client in Philadelphia, PA. The full job description is listed below. If interested, please reply with your updated Microsoft Word version resume attached to apply and your professional references. Please forward this information on to any friends that may be qualified and interested in the position. Thanks.

This position will support the Data Analysis & Planning unit in administering the Stormwater Plan Review Database (SWPRDB) system. Developed in 2009, the SWPRDB runs on a SQL Server 2008 database with an Access 2010 user interface. Primarily used to track internal workflows and permit compliance data, the database represents a core critical function of the Department. Although DA&P is the primary database administer and owner, technical coding support is required. This position will be responsible for ensuring continued SWPRDB functionality through routine maintenance and updates. In addition, the Department is engaged in the development of a data warehouse/business intelligence solution (known as RAMsys) that will extract, load and transform data from the SWPRDB as part of a regulatory obligation with the State and Federal government. In order to ensure continuity of both RAMsys and SWPRDB throughout the coming year, this position will facilitate the implementation of any necessary modifications or upgrades to the database that may be required to guarantee a successful RAMsys launch.

Work activities

• Troubleshooting

• Identifying and packaging fixes

• Developing system modification or upgrades such as:

o Updates to projects, meetings, and status export routines

o Development and integration of expedited review tracking

o Integrate numeric values into Stormwater Management Practices (SMP) summary views

o Development and integration of an enforcement tracking stage

o Update migration routines

o Expand standardized reporting queries

o Establish and implement user groups

• Meeting attendance

• Implementation documentation

• Testing

• General technical support and guidance

Skills/experience REQUIRED of the assigned staff:

• SQL Server 2008

• Extensive Advanced Experience in Microsoft Access 2010

• Microsoft Visual Basic

• ODBC Connections

• Active Directory 

Services and/or Deliverables shall be subject to acceptance testing as approved and accepted by the City. Acceptance testing for the resource(s) covered under this SO will include, but not limited to, the following:

• Updates to projects, meetings, and status export routines

• Development and integration of expedited review tracking

• Integrate numeric values into Stormwater Management Practices (SMP) summary views

• Development and integration of an enforcement tracking stage

• Update migration routines

• Expand standardized reporting queries

• Establish and implement user groups

• Ensure ongoing compatibility with RamSys DW/BI solution

• Monthly progress reports

• Technical documentation

Thanks & Regards

Vaibhav Kumar

Sourceinfotech Inc.
3840, Park Avenue, Suite C-205, Edison, NJ-08820

EMAIL: vaibhav@sourceinfotech.com
Phone: 609-917-3451| Fax: 732-909-2282 | Gtalk: vvyadu23
Certified Minority Business Enterprise - MBE