Job Description
The Office of Accountability Strategies (OAS) is responsible for providing strategic operational, analytical, and systems support services to the DSS-AO (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 (OAS-DART) is responsible for supporting the integrity of social service programs. DART is responsible for developing technological and analytical advancements that represent an intelligence-led, data-driven Agency. DART maintains the data analysis, reporting and performance measurement systems of DSS-AO, utilizing advanced analytics to identify new investigative initiatives, refer cases with the highest probabilities of fraud, and ensure data quality and reporting. OAS-DART 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
Rise is an AI-powered job search platform revolutionizing the way job seekers find their next career move. Trusted by over 3 million job seekers, our advanced AI technology curates personalized job recommendations and insights, making your job search efficient and effective.
