USA Jobs, Careers and Recuitements
Job Target Job Search
[x]

Contact Information

Company: ACROSTAFF Jobs
Contact Name: DAVE
Website: http://www.acrostaff.com

Job Details: Sybase DBA Date: Aug 15 2019

Job Reference: 10443
Job Category: IT Jobs [ View All IT Jobs Jobs ]
Company Type Employer
Employment type: Full Time
Degree: Bachelors
Experience: 3 years
Location: Albany, New York, 12202
Job Skills: Sybase DBA
Share Job with Others

Job Tools

Job Description

• At least 60 months experience in database design activities involving consumers and technologists using Erwin data modeler.
• At least 60 months experience in developing fully attributed data models using Erwin data modeler.
• At least 36 months experience deploying and maintaining physical databases by comparing and synchronizing Entity Relationship Models.
• At least 36 months experience in physical database administration of Sybase databases including activities in support of the bulk loading and/or extraction of data.
• At least 36 months experience in performance and tuning Sybase ASE databases.
• At least 12 months experience with Microsoft SQL Server xVelocity maintenance activities
• At least 12 months experience in Dimensional Modeling using Ralph Kimball’s data warehousing approach.

Description:
State of New York: Workers’ Compensation Board

Project- WCB Business Intelligence Phase 2
The NYS Workers’ Compensation Board’s Business Process Reengineering (BPR) project has identified the need to quantify and monitor system performance. New BI components will be required to enable this analysis. This includes expanding the data and subject areas available in the WCB’s data warehouse, summarizing data into logical data marts for improved access and performance, integrating processes and technologies to improve data quality, building new and expanded analytical cubes, creating new dashboards and reports, that will enable expanded information self-service for the WCB.

Two goals of delivering self-service BI and analytics by expanding available data in the WCB’s enterprise data warehouse are (1) to provide management with a single source of all summarized data and (2) to provide the tools that allow self-service access to that data. To meet these goals, future iterations or phases of business intelligence and data warehouse development are required to include:
a) Expansion of available source systems to be included in EDW
b) Additional subject areas leveraging “atomic level” data
c) Data marts to summarize “atomic level” data
d) New and expanded BI analytical schemas (aka “cubes”)
e) New executive dashboards
f) New analytical reports
g) Establishment of Data Quality Management processes
Integration of Data Quality Management tools to Data Warehouse architecture

Responsibilities:
• Conduct walk-throughs of database designs with management, technologists and consumers
• Create Entity Relationship models
• Create Dimensional Relationship models
• Fully document models and supporting materials
• Forward and Reverse engineer DDL from/into Sybase ASE and IQ
• Synchronize models and physical databases
• Apply WCB modeling standards to transactional ERDs and to dimensional models
• Apply Kimball standards and best practices to Dimensional models
• Database performance and tuning activities
• Database table index optimization
• Assist with troubleshooting data warehouse issues
• Assist with determining Extract, Transform, and Load (ETL) feasibility
• Assist with bulk copying of data to data warehouse
• Create physical database objects – tables, views, indexes and security accounts/permissions

Copyright © 2019 Jobxoom All rights reserved. Use of this site is subject to certain Terms and Conditions.