Current Job Openings

SQL Database Administrator Services: NYC Department of Small Business Services 1 Liberty Plaza, 11th Floor, New York, NY 10006

Due Date:
Monday, September 16, 2019 7:00 PM

Job Title:
SQL Database Administrator Services

Location:
NYC Department of Small Business Services 1 Liberty Plaza, 11th Floor, New York, NY 10006

Scheduled Work Hours:
Full Time - 9 to 5 - 35hrs/wk

Service Scope:
Services Desired
SBS seeks an experienced Consultant to:
1. Design advanced SQL queries, stored procedures, triggers, scripts
2. Create SQL Server databases and database components utilized by Worksource1 and Dynamics CRM
M/WBE INNOVATIVE PURCHASE METHOD REQUEST FOR PROPOSALS
TITLE: SQL DATABASE ADMINISTRATOR SERVICES
PIN: PR-20SBS24285
3. Collaborate with applications developers on data modeling and E-R diagrams
4. Manage database performance, capacity, replication, backup and security
5. Assist business analysts and end-users with reporting needs
6. Develop reports, views, charts and dashboards to assist program staff with monitoring the outcomes of
the initiative.
7. Work with external entities to facilitate data transfers.
The Consultant’s responsibilities are expected to include the following deliverables.
Deliverable Description
A. Design and Develop
Dynamics CRM data
elements for
Application Based
Programs.
Provide services noted in previous section to complete the development
of the Application Based Programs for Business Services in Dynamics
CRM.
Development Completion by September 20th2019
B. Design and Develop
Dynamics CRM data
elements for Sign
Up/Show Up Courses.
Provide services noted in previous section to complete the development
of the Sign Up/Show Up Courses for Business Services in Dynamics
CRM. This will include data integration with a third-party event
management system.
Development Completion by September 27th 2019
C. Design and Develop
Dynamics CRM data
elements for
Navigating
Government Services.
Provide services noted in previous section to complete the development
of the Navigating Government services for Business Services in
Dynamics CRM.
Development Completion by October 11th 2019
D. Design and Develop
Dynamics CRM data
elements for Capacity
Building Programs.
Provide services noted in previous section to complete the development
of the Capacity Building Programs for Division of Economic
&Financial Opportunity (DEFO) in Dynamics CRM.
Development Completion October 2019
E. Design and Develop
Dynamics CRM data
elements for DEFO
Campaign Management
and Activities Process
Design.
Provide services noted in previous section to complete the development
of the Application Based Programs for Business Services in Dynamics
CRM.
Development Completion November 2019
F. Design and Develop
Dynamics CRM data
elements for Vendor
Services.
Provide services noted in previous section to complete the development
of the Vendor Services for DEFO in Dynamics CRM.
Development Completion November 2019
G. Design and Develop
Dynamics CRM data
elements for Buyer
Services and External
Affairs.
Provide services noted in previous section to complete the development
of the Buyer Services and External Affairs for DEFO in Dynamics
CRM.
Development Completion December 2019
M/WBE INNOVATIVE PURCHASE METHOD REQUEST FOR PROPOSALS
TITLE: SQL DATABASE ADMINISTRATOR SERVICES
PIN: PR-20SBS24285
H. Design and Develop
Dynamics CRM data
elements for
Application
Submissions through
Public Portal.
Provide services noted in previous section to complete the development
of the Application Submissions through Public Portal for DEFO and
Business Services in Dynamics CRM.
Development Completion February 2020
I. Design and Develop
Real Time data
connections between
agency business
systems
Provide services noted in previous section to complete the development
of the data connections between Dynamics CRM and other SBS
systems.
Development Completion May 2020
J. Design and Develop
database enhancements
for Worksource1
application
Provide services noted in previous section to complete the development
of database components for Worksource1 related to required system
enhancements.
Development Completion May 2020

Mandatory Skills:
Vendor’s Minimum Requirements. Proposers must be M/WBE certified and shall have a
minimum of five (5) years prior experience providing professional technology staffing services.
b. Preferred Skills/Experience for Consultant Candidates
i. 8 years or more experience installing, designing and managing MS SQL 2008, 2012, 2104,
or 2016.
ii. Experience designing and implementing new MS SQL Server databases
iii. Extensive experience writing advanced SQL queries and reporting services, analyzing and
optimizing queries and stored procedures and SSIS packages
iv. Experience supporting XML APIs
v. Experience loading SQL tables from Text/Excel files by using Import/Export wizard and
SSIS packages.
vi. Broad understanding of software development and web technologies
vii. Familiarity with Business Intelligence technologies (e.g. Microsoft Power BI, Oracle BI)
viii. Highly proficient with report development in Microsoft Office Access, Microsoft Excel,
and Power BI
ix. Perform multiple projects on small teams
x. Excellent communication and presentation skills
Bidders must submit information indicating the above referenced experience as part of their
submission

Apply for this job

« Back to Current Job Openings