Remote
Description:
DSI is searching for a Database Administrator with SAS and Tableau skills to help
build reports for the DTE project which is a subset of the Sunset Mainframe project.
Responsibilities:
- Maintenance, enhancement, designing of data dictionaries,
- physical and logical database models.
- Performance tuning and providing knowledge transfer to the staff.
- Maintains central data repository.
- 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.
- Complete assigned tasks.
- Documenting designs.
- Execution of all responsibilities with little direct supervision of Team Lead.
- 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.
- 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.
- Provide status of work to Project Team Lead.
- Engage in ongoing process improvement.
Requirements:
- 5 years SAS Administration.
- 5 years SAS Programming.
- 5 years SQL Experience.
- SAS 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.
- Experience and knowledge in supporting application system development lifecycle.
- Follow quality standards.
- Ability to work in a team environment.
- Business systems analysis and design experience.
- Logical data modeling techniques.
- Production environment Tools/Utilities.
- Administration and scripting experience in relative platform.
- Highly skilled at database design, installations, conversions.
- Knowledge of various Database Management System products.
Desired Skills:
- SAS Certification
- 5 years Tableau Administration
- 5 years Tableau Programing
- Ability to read COBOL programming
- Understands DB2
About Diversified Systems
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.
Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.
Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.