Info SYS ANL 3 (Data Operations Programmer)

Administrative Innovation and Technology is part of the Finance, Operations & Administration (FOA) organization and manages a diverse end to end portfolio of technology services essential to the entire UC Davis campus including UC Davis Health System

The Data Operations & Integrations Team at FOA leads and manages all aspects of Technology Operations for the FOA division. Campus-wide, business-critical information systems managed by FOA include the following mission-critical campus-wide systems: Oracle Financial System Data Operations, AggieExpense Integrations, Managed File Transfer Systems, Business Intelligence, Data Pipeline Operations, Campus Time Reporting System (TRS), Electronic Document Management (AggieDocs), Faculty Effort Reporting System, Cost Share Integrations, and UC Path Integrations.

Job Summary

Under general direction of the FOA Data Operations and Integrations Manager, provide moderately complex level application and data integrations support in a fast paced environment for a variety of custom in-house, open source, Software as a Service (SaaS) and vendor provided multi-tier products. Configure and performance tune web, SaaS and back-end applications and programs. Analyze, design, build and maintain batch and web-tier applications to support recurring operational tasks and processes. Monitor, troubleshoot, analyze, program, and provide operational support for FOA managed computing systems (campus-wide and internal FOA systems).

Daily responsibilities include job management, scheduling, output review, error analysis, diagnostics, ad-hoc report building, data analysis, code deployment, application configuration, documentation, shell scripting, client support, database and application programming.

Position Information

Apply by Date

4/4/2024

Salary Range

$80,300/yr. - $147,500/yr.

Appointment Type

Career

Number of Positions

1

Percentage of Time

100% Fixed

Shift Hours

Manager will advise

Location

Davis

Union Representation

No

Benefits Eligible

Yes

PHYSICAL DEMANDS

• Position requires extended periods of time at workstation working on a computer.

• Travel to meetings on and off campus.

WORK ENVIRONMENT

• Work on a personal computer for extended periods of time.

• Travel to meetings on an as-needed basis.

• Employee is personally responsible for following health and safety guidelines/instructions.

• Work hours outside standard 8 AM to 5 PM schedule, usually on short notice when required. Work occasional holidays and weekends. Limited vacation during peak workload periods.

• Work in a dynamic, distracting, knowledge-sharing environment.

• Maintain strict confidentiality of files and data to protect privacy and rights of individuals

• Work with constant interruptions and distractions and constant traffic and noise from telephone conversations, visitors, staff, etc.

• Employee is personally responsible for following and adhering to University safety policies and procedures.

• Work flexible schedule including evenings, weekends, and holidays to meet operational and business needs.

• UC Davis is a smoke and tobacco free campus effective January 1, 2014. Smoking, the use of smokeless tobacco products, and the use of unregulated nicotine products (e-cigarettes) will be strictly prohibited on any UC Davis owned or leased property, indoors and outdoors, including parking lots and residential space.

MINIMUM QUALIFICATIONS

Minimum Education/Experience:

• 3+ years of combined experience in software development and/or systems administration.

• Experience in integrating open source and third-party applications into existing systems both on-prem and SaaS.

• Experience in SQL, PL/SQL, data analysis relational databases for complex queries on large databases.

• Experience with managed file transfer, scheduling and staging of batch files and feeds using custom scripts or vendor tools (e.g., GoAnywhere)

• Experience using programmatic API services provided by major cloud providers (S3, EC2, ECS, etc.)

Minimum Knowledge, Skills, and Abilities (KSA):

• Proficiency in Linux shell scripting (bash, ksh, csh, etc) , VI editor, Linux utilities (awk, grep, sed, find, etc).

• Demonstrated strong analytical skills to analyze and evaluate technical requirements, information, or problems in an objective manner and make logical conclusions.

PREFERRED QUALIFICATIONS

Preferred Education/Experience:

• Bachelor's degree in Computer Science, Data Science, MIS, or equivalent combination of education and experience.

• Experience in Mongo DB data analysis for complex queries on large databases.

• Experience maintaining job schedules in two or more of the following: Linux cron, Quartz, SpringBatch, or enterprise schedulers (e.g., Control-M, Autosys, Workload Automation, Red Hat Ansible Automation Platform)

• Demonstrated experience with maintaining user, roles, permissions in central identity management solutions (Grouper, ActiveDirectory)

• Experience supporting web and application servers (e.g., Apache, IIS, Tomcat, ColdFusion, NGINX).

• Experience in testing application updates, database changes, and system migrations in nonproduction and production environments.

• Experience supporting Financial Information Systems.

• Experience with database management tools (SQL Developer, SQLNavigator, Oracle Enterprise Manager, Toad, DataGrip).

• Experience in web design using HTML, CSS, and Content Management Systems.

• Experience working in a project focused environment, working on projects of various sizes, and delivering objects on time, within budget, and with a high degree of quality.

• Experience using issue and problem tracking systems (ServiceNow, JIRA, etc.).

Preferred Knowledge, Skills, and Abilities (KSA):

• Demonstrated Knowledge in one or more of the following languages under a Linux environment: Python, Groovy, Ruby, Java, or Golang.

• Ability to communicate on a technical level with other knowledgeable individuals to solve technical problems.

• Demonstrated knowledge of stream processing and message broker services such as Kafka, NiFi, SNS, ActiveMQ or RabbitMQ

• Demonstrated knowledge with version control tools and practices (e.g., git, svn, GitHub, Bitbucket).

• Demonstrated knowledge with middleware systems including LDAP, CAS, SAML, ADFS or other authorization systems.

• Demonstrated Knowledge with the Linux and Windows operating system, including disk file systems, interprocess communications, TCP/IP networking, file permissions, user account management and security best practices.

• Demonstrated strong analytical skills to analyze and evaluate technical requirements, information, or problems in an objective manner and make logical conclusions.

• Ability to communicate bugs to developers and other stakeholders.

• Knowledge of the Administrative Computing Policy and campus standards for the development of information systems.

• Demonstrated knowledge in supporting and interacting with webservices via use of SOAP and RESTful based services

• Demonstrated Knowledge in analyzing applications written in one more of the following languages: Java, Javascript/Node.js, ReactJS, PHP, ColdFusion, Python.

SPECIAL REQUIREMENTS

Background Check

This position is a critical position and subject to a background check. Employment is contingent upon successful completion of background investigation including criminal history and identity checks.

Diversity, Equity, Inclusion and Belonging

At UC Davis, we're solving life's most urgent challenges to bring a fuller, healthier, and more resilient world within reach. We grow from every challenge we take on and we don't just maintain - we improve. We recognize that creating an inclusive and intellectually vibrant organization means understanding and valuing both our individual differences and our common ground. The most comprehensive solutions come from the most diverse minds, and you belong here. As you consider joining UC Davis, please explore our Principles of Community, our Clinical Strategic Plan and strategic vision for research and education, and our latest efforts to outgrow the expected. The University of California, Davis is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age or protected veteran status.

For the University of California's Affirmative Action Policy please visit: https://policy.ucop.edu/doc/4010393/PPSM-20.

For the University of California's Anti-Discrimination Policy, please visit: https://policy.ucop.edu/doc/1001004/Anti-Discrimination.