SYSTEM DATA ASSOCIATE
SYSTEM DATA ASSOCIATE
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
The Office of Accountability Strategies (OAS) is responsible for providing strategic operational analytical and systems support services to the DSSAO (Department of Social Services Accountability Office) across the DSS and to sister agencies outside of DSS ensuring data driven efficiencies are effectively implemented. Within OAS Data Analytics Reporting and Triage (OASDART) is responsible for supporting the integrity of social service programs. DART is responsible for developing technological and analytical advancements that represent an intelligenceled datadriven Agency. DART maintains the data analysis reporting and performance measurement systems of DSSAO utilizing advanced analytics to identify new investigative initiatives refer cases with the highest probabilities of fraud and ensure data quality and reporting.
OASDART is recruiting for one (1) Computer Associate Software II to function as a System Data Associate who will:
Create in a relational database user tables views user functions and stored procedures based on business rules.
Manage the data manipulation of large data files extracted from various databases (SQL Oracle DB2) and export these data sets into output that can be analyzed and used for decision making.
Gather and interpret database statistics to monitor performance. Make database changes as necessary to address performance problems.
Assist systems administrator with installing configuring and maintaining servers that host the database system. Create save restore and test databases for system or user testing. Initiate backup and recovery procedures.
Apply and implement metadata standards for data elements (i.e. naming conventions formats and default values) for system/applications.
Maintain a repository for data element definitions and from that repository produces data reports.
Assist in the preparation and support of data conversion and migration. Load data from different sources into databases.
Analyze table change requests and their impact on other tables. Create programs load and extract on ad hoc basis with minimal supervision and direction
COMPUTER ASSOC (SOFTWARE) 13631
Qualifications :
1. A baccalaureate degree from an accredited college including or supplemented by 24 semester credits in computer science or a related computer field and one year of satisfactory fulltime computer software experience in computer systems development and analysis applications programming database administration maintenance and support systems programming data communications mainframe development mobile development web development and design; or
2. A fouryear high school diploma or its educational equivalent and five years of satisfactory fulltime computer software experience as described in 1 above; or
3. Education and or/or experience equivalent to 1 or 2 above. College education may be substituted for up to two years of the required experience in 2 above on the basis that 60 semester credits from an accredited college is equated to one year of experience. In addition 24 semester credits from an accredited college or graduate school in computer science or a related field or a certificate of at least 625 hours in computer programming from an accredited technical school (post high school) may be substituted for one year of experience. However all candidates must have at least a fouryear high school diploma or its educational equivalent and at least one year of satisfactory fulltime experience as described in 1 above.
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 individuals sex race color ethnicity national origin age religion disability sexual orientation veteran status gender identity or pregnancy.
Remote Work :
No
Employment Type :
Fulltime
Employment Type
Full-time
