Database Architect
Database Architect
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Role: Database Architect
Location: Albany New York
Duration: 24 Months
Description
This project will result in deployment training and support of NYSP Traffic Records Managment Systems to over 528 police agencies across the state of New York. These systems are used for electronic traffic ticketing as well as incident and accident reporting
Duties
- Coordinate and implement municipal law enforcement agency TraCS systems and database architectures.
- Install configure and maintain enterprise-scale SQL and Oracle database environments.
- Coordinate and implement large scale database conversions and migrations from disparate systems.
- Direct build revisions of TraCS releases.
- Perform version testing and release control of TraCS.
- Direct the setup and installation of TraCS implementations.
- Lead conversions of legacy MS Access databases.
- Provide advanced support and troubleshooting of TraCS systems.
- Coordinate and conduct classroom style trainings to local police agencies.
- Develop training materials such as FAQs how to guides manuals and course curriculum.
- Conduct testing of applications.
- Develop test plans for testing applications.
- Lead/Assist with train the trainer and agency level TraCS systems administration.
- Install maintain and troubleshoot the State Police Integrated Data Exchange Router (SPIDER) client.
- Install and configure TraCS Web Services.
- Setup test and troubleshoot mobile platform connectivity solutions.
- Coordinate with municipal IT staff and vendors for the implementation and maintenance of TraCS.
- Engage in extensive travel throughout New York State in supporting police agencies that are implementing and using TraCS.
Mandatory Requirements
- Experience (14 Years)
- Determines database structural requirements by analyzing client operations applications and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities responding to user questions and resolving problems.
Requirements
- This is an 100% Onsite
- 84 months of experience working with systems administrators and end users to troubleshoot both hardware and software issues.
- 84 months of experience working in a second-tier or higher service desk environment.
- 60 months of experience coordinating and implement large scale database conversions and migrations from disparate systems.
- 60 months of experience installing configuring and maintaining enterprise-scale Oracle and SQL database environments.
- 84 months experience leading and directing installations and upgrades of TraCS environments.
- 84 months of experience installing configuring and supporting SPIDER.
- 60 months of experience developing training materials and providing classroom instruction.
- 60 months of experience supporting mobile computing and connectivity solutions in a law enforcement environment.
- Posses a Bachelors Degree in Information Technology Business Administration or related field from an accredited institution.
Employment Type
Full Time
