Job Description:
ODM SAS Administrator Technical Services:
• Design SAS solutions, such as SAS Viya and EBI, considering infrastructure, file structure, and high availability.
• Advise stakeholders on SAS solution and implementation decisions.
• Implement SAS solutions based on agreed-upon architecture/design.
• Coordinate implementation projects across server, storage, and networking teams.
• Guide and support SAS users in code and report development.
• Prepare and execute deployment plans across Dev, Test, and Prod environments.
• Establish best practices for SAS implementation and support.
• Provide and oversee SAS support including user administration, monitoring, capacity management, and troubleshooting.
• Drive SAS support activities across server, storage, and networking teams.
• Train and coach backup SAS administrator.
• Create automated processing jobs on the SAS Server to meet the business user needs.
• Work with internal provisioning authorization teams to keep SAS access in conformance with agency policy and auditing standards.
• Provide reports, metrics and presentations to various teams, groups, and meetings as required.
• Create and architecture diagrams with process flows when necessary.
• Create and maintain connectivity to disparate data sources (including Oracle, MS SQL, Hadoop, Impala, network shares, etc.)
• Facilitate data sharing and exchanges with both internal and external entities.
• Continuously monitor the production processes, fix any issues, update the tracker document with the issues, and report the performance issues to management.
• Performance tuning on the SAS Server as required.
• Demonstrate strong familiarity with and instruct various SAS users in procedures for using various SAS applications and tools.
• Understand and write SAS programs and diagnose coding errors and performance issues with SAS users.
• Create Service tickets to fix production issues in cooperation with SAS Tech support and other state or external IT entities.
• Provide solutions to eliminate various single point of failure issues.
• Perform system maintenance, patches, upgrades, and data backups, as necessary.
• Work with SAS Institute staff to provide information and requirements for fixing, remediating, enhancing, and planning various SAS server platform and client, changes, upgrades, design requirements and performance issues.
• Research and provide recommendations to management for any issues or concerns regarding the SAS Server, SAS client or SAS user issues or desires.
• Implement and install and configure software as requested and work with the AIX admin to perform these duties as necessary,
• Keep abreast of SAS analytical tools and functionality (Forecast Studio, Enterprise Guide, Enterprise Miner, PC SAS and other tools).
• Monitor SAS Enterprise BI servers and diagnose and troubleshoot any SAS Server performance issues.
• Provision access for users and groups on SAS Servers (and AIX Servers) in accordance with ODM governance procedures and requirements.
• Create and run AIX scripts and jobs as necessary for Server provisioning and administration.
• Perform Server patching and maintenance, as necessary.
• Provide sizing inputs and requirements during architecture/system design to ensure system specifications meet anticipated system workload.
REQUIRED Skill Sets: - 8+ years of experience with SAS Enterprise BI Server administration.
- 2+ years of experience with SAS Viya platform administration
- 8+ years of experience installing SAS BI server from scratch on a multitier platform.
- Design and configure SAS internal folder structures to facilitate user access and provisioning.
- 4+ years of experience in creating and running AIX scripts and jobs as necessary for Server provisioning and administration.
- 4+ years of experience - Perform Server patching and maintenance as necessary.
- 2+ years of experience on SAS VIYA administration and worked in the architect capacity.
- Provide management reports from both the SAS server and the AIX OS upon request.
- Strong knowledge and practice implementing standard security policies and procedures for both SAS Server and SAS clients.
- Regularly provide access for SAS users and accessible resources (data sets and database connections)
- Good experience in working with Visio, Excel, PowerPoint, Word, etc.
- Effective communication, presentation, & organizational skills.
- Familiar with Project Management methodologies.
- Ability to create and execute written project plans
- Ability to establish priorities & follow through on projects, paying close attention to detail with minimal supervision.
- Required Education: BS/BA degree (in computer science or related field) or combination of education & experience
DESIRED Skill Sets: - Demonstrate effective leadership, analytical and problem-solving skills
- Required excellent written and oral communication skills with technical and business teams.
- Ability to work independently, as well as part of a team
- Stay abreast of current technologies in area of IT assigned
- Establish facts and draw valid conclusions
- Recognize patterns and opportunities for improvement throughout the entire organization
- Ability to discern critical from minor problems and innovate new solutions
· Strong documentation skills in readable English · Ability to create reports from both SAS Enterprise Server and AIX Operating system · Strong familiarity with both Windows and AIX/Linux operating systems · Familiarity with SQL programing in both Oracle and MS SQL · Experience Installing an entire SAS BI server on a multitier platform · Experience packaging, installing, and troubleshooting SAS 9.4 client applications on Windows OS. · Strong experience troubleshooting both SAS Server and Client performance issues · Strong knowledge of basic networking (firewalls, switches, routing, etc.) and diagnosing performance bottlenecks. · Ability to recommend improvement changes in SAS Server, SAS client, and SAS user analytic procedures to benefit the entire organization · Exceptional ability to work as part of a team and to interact with other teams both inside and outside of the organization. · Experience setting up SAS AUTH provisioning for accessing external data and database systems. · Experience in using Directory Services (LDAP, AD, other) groups for provisioning access in SAS. · Strong ability to provide technical explanations to SAS Technical support teams, to facilitate troubleshooting issues for both SAS Server and SAS user issues. |