Database Architect

Lead implementation and support of TraCS systems for municipal law enforcement agencies.

Install, configure, and maintain enterprise-level SQL and Oracle databases.

Oversee large-scale database conversions and migrations from legacy or disparate systems.

Manage TraCS build revisions, version testing, and release deployments.

Provide advanced troubleshooting and technical support for TraCS systems.

Conduct classroom and agency-level trainings; develop user guides, manuals, and course content.

Install and support SPIDER clients and TraCS Web Services.

Set up and troubleshoot mobile connectivity solutions for law enforcement use.

Collaborate with municipal IT teams and vendors to ensure system functionality.

Travel extensively across New York State to support police agencies.

7+ years of experience supporting system administrators and end users with hardware/software issues.

7+ years in a second-tier (or higher) service desk environment.

5+ years managing database migrations across different platforms.

5+ years installing and maintaining enterprise-scale Oracle and SQL environments.

7+ years leading TraCS installations and upgrades.

7+ years installing, configuring, and supporting SPIDER clients.

5+ years creating training materials and conducting classroom instruction.

5+ years supporting mobile computing and connectivity in a law enforcement setting.

Bachelor’s degree in IT, Business Administration, or a related field.