Senior SAS Administrator / SAS Viya Administrator in Columbus , Ohio - Onsite Position (In-person Interview)

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.