Database Administrator(SAS)

Skills

Description

The Ohio Department of Taxation is seeking an individual with SAS and Tableau skills to help build reports for the DTE project which is a subset of the Sunset Mainframe project. This person wiil be responsible for maintenance, enhancement, designing of data dictionaries, physical and logical database models, performance tuning and providing knowledge transfer to our staff.

Responsibilities

• SAS Programming
• SAS Administration
• Provide knowledge transfer to our staff and SAS programming and administration
• Tableau Programming
• Tableau Administration
• Understand DB2
• Integrate with SQL
• Read and interpret COBOL
• Skilled data dictionary analysis and design and data model analysis design.
• Maintains central data repository.
• Experience and knowledge in supporting application system development lifecycle.
• Responsible for data dictionary backup and recovery.
• Responsible for definition of standards of data dictionaries.
• May program dictionary analysis and maintenance software.
• Perform performance tuning.
• Monitor database performance and space requirements.
• Schedule and monitor end of day data warehousing jobs.
• Assist in coordinating software releases.
• Communicate accurate and useful status updates.
• Manage and report time spent on all work activities.
• Follow quality standards.
• Ability to work in a team environment.
• Complete assigned tasks.
• Documenting designs
• Business systems analysis and design experience.
• Logical data modeling techniques.
• Production environment Tools/Utilities.
• Knowledgeable in data analysis and database management techniques.
• Execution of all responsibilities with little direct supervision of Team Lead.
• Administration and scripting experience in relative platform.
• Supervise performance tuning.
• Author shell scripts to perform back up, restore, and monitoring tasks.
• Anticipate and resolve issues specific to the team.
• Determine time estimates and schedule for own work and resolve issues in a timely
• manner.
• Identify and track issues, risks and action items.
• Highly skilled at database design, installations, conversions.
• Responsible for database backup and recovery procedures, access security and database
• integrity, physical data storage design and data storage management.
• Participates in Database Management System selection and maintains database
• performance.
• Knowledge of various Database Management System products.
• Provide status of work to Project Team Lead.
• Engage in ongoing process improvement