Company

Nypd Civilian JobsSee more

addressAddressNew York, United States
type Form of workFull-time
salary Salary$120,000 - $132,000 a year
CategoryInformation Technology

Job description

  • FINANCIAL INFO SVCS AGENCY
  • Full-Time
Location
MANHATTAN
  • No Exam Required
Department
Ops/Tech Syst CityTime

Salary Range:
$120,000.00 – $132,000.00

Job Description

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.
  • 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

  • Experience Level:
    Experienced (Non-Manager)
Number of positions
1
Work location
5 Manhattan West
  • Category:
    Technology, Data & Innovation

Refer code: 8287207. Nypd Civilian Jobs - The previous day - 2024-02-21 18:26

Nypd Civilian Jobs

New York, United States
Jobs feed

Overnight Cashier / Front Line server

Villa Restaurant Group

Bethlehem, PA

Licensed Practical Nurse (LPN)

Faithstaff Llc

Pottstown, PA

$30 an hour

LPN Supervisor - 2nd shift

Glen Mills Senior Living

Glen Mills, PA

$27 - $36 an hour

Extrusion Line Operator: Walk-in interviews 3/21/2024

Avient

Bethlehem, PA

$20 - $23 an hour

Speech Language Pathologist

Venture Rehab Group

Jacksonville, NC

$75,000 - $95,000 a year

LPN Admission Team

Penn Medicine

West Chester, PA

Hiring Food Runners

Blue Grillhouse

Bethlehem, PA

$25.3K - $32K a year

LPN (Licensed Practical Nurse)

Twin Pines Health Care Center

West Grove, PA

$30 - $35 an hour

Landscape Supply and Farmers Market Store Help (Immediate Openings)

Rich Tree Service, Inc

Flemington, NJ

$18 - $30 an hour

Auto Sales Associate

Brown-Daub Dealerships

Easton, PA

$50,000 - $100,000 a year

Share jobs with friends

Related jobs

SQL ARCHITECT

SQL Server DBA/Database Architect

Data Engineer - Aptask

Jeffersonville, IN

2 weeks ago - seen

Product Software Architect | Application Architect | Vue.js | SQL

Wolters Kluwer

$132K - $167K a year

Tampa, FL

2 months ago - seen

IT SQL Data Warehouse Architect (VA730461)

Resource Management Associates, Llc

$60.53 - $65.53 an hour

Chesterfield, VA

3 months ago - seen

SQL Server DBA/Database Architect

Aptask

Jeffersonville, IN

3 months ago - seen

Solutions Architect (Python, SQL, AWS)

Britecore

$128K - $162K a year

Orlando, FL

4 months ago - seen

Data Architect- SQL, Oracle, BIgData

Search jobs on OhioMeansJobs

Chicago, IL

4 months ago - seen

SQL Technical Architect

L&T Infotech

Redmond, WA

4 months ago - seen

SQL Server Database Architect

MedPOINT Management

Los Angeles, CA

5 months ago - seen

Senior SQL Database Administrator/Data Architect - Sygma - US

The SYGMA Network

Dublin, OH

5 months ago - seen

Business SQL Architect - $89,960-$112,580/year, DOE, full-time

Breckenridge Grand Vacations

Breckenridge, CO

5 months ago - seen