No C2C) (Local Candidates Only)

TEKsystems•Jersey City, NJ

2d•Onsite

About The Position

You will maintain, debug, and modernize legacy Unix shell scripts, database triggers, and stored procedures while leveraging AI tools to accelerate analysis, refactoring, and documentation. Your hands-on expertise with Unix/Linux scripting and SQL/PL/SQL/T-SQL is primary; AI is used to work faster and document better. You will collaborate across engineering, data, and product teams to preserve stability, reduce risk, and manage changes clearly and predictably.

Requirements

Proven hands-on experience with legacy Unix/Linux shell scripting (e.g., Bash, Ksh, sh, cron, awk, sed) and database programming constructs (stored procedures, triggers, functions) across one or more major RDBMS (Oracle/PL/SQL, SQL Server/T-SQL, PostgreSQL).
Strong debugging and reverse-engineering skills to trace data flows, uncover business rules, and resolve defects in shell and database logic.
Comfortable leveraging LLMs and code analysis tools to understand unfamiliar code, draft documentation, and suggest refactors; basic prompt-writing for code tasks; no deep AI expertise required.
Proficiency with Git and code review.
Solid SQL fundamentals and performance awareness, including transactions, concurrency, error handling, and basic tuning when modifying or replacing database logic.

Nice To Haves

Experience introducing CI/CD and automated tests around previously unmanaged legacy assets.

Responsibilities

Maintain, debug, and modernize legacy Unix shell scripts, database triggers, and stored procedures.
Leverage AI tools to accelerate analysis, refactoring, and documentation.
Collaborate across engineering, data, and product teams to preserve stability, reduce risk, and manage changes clearly and predictably.
Critically evaluate and safely integrate AI-generated suggestions, validating logic, performance, and side effects before adoption.
Plan and execute AI-assisted code migration from scripts and stored procedures to modern services or SQL-centric patterns, with phased cutovers and rollback strategies.
Introduce CI/CD and automated tests around previously unmanaged legacy assets.