SAS Administrator
Interview Type : Onsite Interviews
Work Location : In Person Downtown Columbus, Ohio
Onsite Requirement : 5 days per week (5x / week onsite)
Client- State of Ohio- Dept. of Medicaid
Role Overview
This role supports the Ohio Department of Medicaid (ODM) and provides SAS Administrator Technical Services . The position is responsible for the design, implementation, administration, support, and optimization of enterprise SAS environments , including SAS Enterprise BI and SAS Viya , while working closely with infrastructure, security, networking, and storage teams.
Key Responsibilities
- Design SAS solutions such as SAS Viya and SAS Enterprise BI (EBI) , considering :
Infrastructure
File structureHigh availabilityAdvise stakeholders on SAS solution and implementation decisionsImplement SAS solutions based on approved architecture and designCoordinate implementation projects across :Server teams
Storage teamsNetworking teamsGuide and support SAS users in :SAS code development
SAS report developmentPrepare and execute deployment plans across :Development
TestProduction environmentsEstablish best practices for SAS implementation and supportProvide and oversee SAS support, including :User administration
MonitoringCapacity managementTroubleshootingDrive SAS support activities across server, storage, and networking teamsTrain and coach backup SAS administratorsCreate automated processing jobs on the SAS Server to meet business needsWork with internal provisioning and authorization teams to ensure SAS access complies with :Agency policies
Auditing standardsProvide reports, metrics, and presentations to various teams and leadershipCreate architecture diagrams and process-flow diagrams as requiredCreate and maintain connectivity to disparate data sources, including :Oracle
MS SQLHadoopImpalaNetwork sharesFacilitate data sharing and exchanges with internal and external entitiesContinuously monitor production processes, resolve issues, update tracking documents, and report performance issues to managementPerform performance tuning on SAS Servers as requiredDemonstrate strong familiarity with SAS tools and train / instruct SAS usersUnderstand and write SAS programs , diagnose coding errors, and resolve performance issuesCreate service tickets and coordinate fixes with :SAS Technical Support
State IT teamsExternal IT entitiesProvide solutions to eliminate single points of failurePerform :System maintenance
PatchingUpgradesData backupsWork with SAS Institute staff on :Fixes
RemediationEnhancementsPlanning upgrades and performance improvementsResearch and provide recommendations to managementInstall, configure, and implement software as requestedWork with AIX administrators to perform installation and configuration tasksStay current with SAS analytical tools, including :Forecast Studio
Enterprise GuideEnterprise MinerPC SASOther SAS toolsMonitor SAS Enterprise BI servers and diagnose performance issuesProvision user and group access on :SAS Servers
AIX ServersIn accordance with ODM governance proceduresCreate and run AIX scripts and jobs for server provisioning and administrationPerform server patching and maintenanceProvide system sizing inputs during architecture and system design to ensure workloads are metRequired Skill Sets
Education :BS / BA degree in Computer Science or related field or equivalent combination of education and experience
Experience Requirements :8+ years of SAS Enterprise BI Server administration
2+ years of SAS Viya platform administration8+ years installing SAS BI Server from scratch on a multi-tier platform2+ years of SAS Viya administration in an architect capacity4+ years creating and running AIX scripts and jobs for server provisioning4+ years performing server patching and maintenanceStrong experience in :Designing and configuring SAS internal folder structures
Providing management reports from SAS Server and AIX OSImplementing standard security policies for SAS Server and SAS clientsUser provisioning and access to datasets and database connectionsExperience using :Visio
ExcelPowerPointWordEffective communication, presentation, and organizational skillsFamiliarity with Project Management methodologiesAbility to :Create and execute written project plans
Establish priorities and follow through on projectsWork with minimal supervision while paying close attention to detailDesired Skill Sets
Demonstrated leadership, analytical, and problem-solving skillsExcellent written and verbal communication skills with technical and business teamsAbility to work independently and as part of a teamStay current with emerging IT technologiesAbility to establish facts and draw valid conclusionsRecognize patterns and opportunities for organizational improvementAbility to discern critical vs. minor problems and develop innovative solutionsStrong documentation skills in clear, readable EnglishAbility to create reports from :SAS Enterprise Server
AIX Operating SystemStrong familiarity with :Windows OS
AIX / Linux OSFamiliarity with SQL programming :Oracle
MS SQLExperience :Installing a full SAS BI server on a multi-tier platform
Packaging, installing, and troubleshooting SAS 9.4 client applications on WindowsTroubleshooting SAS Server and Client performance issuesStrong knowledge of basic networking :Firewalls
SwitchesRoutingDiagnosing performance bottlenecksAbility to recommend improvements across :SAS Server
SAS ClientSAS User analytic proceduresExceptional collaboration skills across internal and external teamsExperience with SAS AUTH provisioningExperience using Directory Services :LDAP
Active DirectoryAbility to provide detailed technical explanations to SAS Technical SupportSkill
Required / Desired
Amount
of Experience
experience with SAS Enterprise BI Server administration.
Required
Years
experience with SAS Viya platform administration
Required
Years
experience installing SAS BI server from scratch on a multitier platform.
Required
Years
experience in creating and running AIX scripts and jobs as necessary for Server provisioning and administration.
Required
Years
experience in creating and running AIX scripts and jobs as necessary for Server provisioning and administration.
Required
Years
experience on SAS VIYA administration and worked in the architect capacity.
Required
Years
eye