Jump to main content.

The Official Careers Website of the City of New York

Search

SQL ARCHITECT

  1. FINANCIAL INFO SVCS AGENCY
Posted on: 08/21/2023
  1. Full-time

Location

MANHATTAN

  1. No exam required

Department

Ops/Tech Syst CityTime

$120,000.00 – $132,000.00

Job Description

This vacancy has now expired.

The Financial Information Services Agency (FISA) has a vacancy for SQL Architect to support the City's Timekeeping (CityTime) system. This individual will be responsible to work in a functional/technical capacity with a good understanding of business processes to assist in the development of data interface programs and conduct appropriate technical reviews of key deliverables and work products associated with coding, and building of data interfaces. The individual must have the ability to evaluate new systems functionality, in addition to determine system requirements from meetings with the business, in addition to the following:

- Assist in identifying set of interface technical requirements to address performance, scalability, maintainability and operability.
- Assist in the design and development of data interface programs.
- Apply data modeling techniques to ensure integration and performance expectations are met.
- Collaborate and work closely with business analyst, application development, infrastructure and database administrator groups.


Minimum Qualifications

1. A baccalaureate degree from an accredited college in computer science, engineering or a related field and four years of satisfactory full-time experience related to datacenter engineering and operations, cloud engineering and operations, complex IT infrastructure engineering; or,

2. A baccalaureate degree from an accredited college and eight years of satisfactory full-time experience related to datacenter engineering and operations, cloud engineering and operations, complex IT infrastructure engineering; or,

3. Education and/or experience which is equivalent to "1" or "2" above.


Preferred Skills

- Proficient in Oracle SQL and PL/SQ with hands-on expertise in creating SQL programs and scripts including designing for optimization, performance and tuning. - Must be experienced in designing and developing Application Data Interfaces. - Prior experience with timekeeping and payroll system is preferred. - Experience working as a hands-on developer and architect for job streams, and process handling. - Knowledge of ETL requirements with strong understanding of ETL methodologies and design patterns. - Working knowledge of development and configuration management tools (Rational Suite preferred). - Understanding of standard SDLC methodologies. - Proficient in relational databases and table structure. - Ability to plan, manage time according to schedules, and provide status updates required. - Excellent communication (oral and written), interpersonal, and organizational skills required. - Experience working on operating system (AIX, Linux) and knowledge of Unix Shell scripting is preferred.
Residency Requirement

New York City Residency is not required for this position.
Additional Information

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.

Job ID

552802

Title code

95714

Civil service title

IT INFRASTRUCTURE ENGINEER

Title classification

Non-Competitive-5

Business title

SQL ARCHITECT

  1. Experienced (non-manager)

Job level

00

Number of positions

1

Work location

5 Manhattan West

  1. Technology, Data & Innovation

SQL ARCHITECT

Search