S

SDSU Research Foundation

Nonprofit foundation for university research

IS Analyst/Programmer II

Enterprise ApplicationsConfirmed live in the last 24 hours
Full-timeSan Diego, CA, USA

About the Job

Requirements

  • Experience programming with Oracle SQL and PL/SQL.
  • Ability to gather requirements from diverse sources and perform data analysis, coding, testing, integration, and maintenance of Oracle and other business applications.
  • Strong customer service skills and a desire to assist others.
  • Ability to communicate effectively to instruct or train others through explanation and demonstration.
  • Strong verbal and written communication skills for technical and non-technical audiences, with the ability to work independently and in a team environment.
  • Ability to manage priorities and workload to meet deadlines, with attention to detail and sound judgment.
  • Demonstrated ability to handle direct customer interaction professionally.
  • Ability to write, tune, and validate advanced Oracle SQL queries and reports.
  • Ability to create, test, and debug Linux shell scripts, scheduled jobs, and automated reports.
  • Knowledge of the Linux operating system, including Bash shell, user and group permissions, and environment variables.
  • Ability to develop complex Oracle applications, data processes, and integrations with various systems.
  • Strong understanding of the software development lifecycle, from technical design and unit testing through user testing and production migration, with adherence to standards and controls and quality assurance before production migration.
  • A bachelor's degree in Information Systems, business, or a related field, or an equivalent combination of education, certifications, and relevant experience.
  • Two years of related work experience in system design, analysis, and programming.

Responsibilities

  • Collect functional and technical requirements from users, stakeholders, technical resources, and subject matter experts to design, prototype, test, debug, and deploy secure user-centric programs, custom applications, and reports in Banner, APEX, and other SDSURF systems.
  • Provide courteous and effective end-user support for SDSURF enterprise systems.
  • Investigate and evaluate proposed software, solutions, and approaches to solve ongoing data challenges.
  • Provide departments with necessary data for internal and external reporting.
  • Collaborate and coordinate with colleagues to build and share centralized, certified tables and packages based on defined business rules for accurate and consistent reports and programs.
  • Document code and processes and follow change-management processes for source code, database objects, host programs, and directories, including server programs and permissions.
  • Maintain system, program, and user documentation.
  • Conduct all activities in compliance with the current SDSU Information Security Plan and SDSU Research Foundation Information Systems Policies and Procedures.
  • Occasionally work beyond typical business hours, including after-hours, weekends, and holidays.

Desired Qualifications

  • Two years of related work experience using SQL in a relational database environment, preferably Oracle SQL and PL/SQL.
  • Experience consulting with end users and stakeholders to analyze business processes, understand business requirements, and develop technical specifications.
  • Experience with Oracle Application Express (APEX) and/or Ellucian Banner systems.
  • Experience with application programming interfaces, web services, or other data integration methods.
  • Experience with Oracle database design and strong knowledge of Oracle database concepts, including stored procedures, packages, functions, triggers, tables, views, and indexes.
  • Experience with Linux/Unix shell scripting.
  • Proficiency writing advanced queries using advanced SQL concepts.
  • Experience with TOAD, SQL Developer, Git, and GitHub.
  • Working knowledge of relational databases, preferably Oracle.
  • Experience with the Linux operating system.

About the Company

SDSU Research Foundation

Nonprofit foundation for university research

SDSU Research Foundation supports research, education, and community service at San Diego State University by administering grants and contracts for faculty-led projects. It works with researchers from the search for funding through proposal budgets, award administration, and the final audit. The nonprofit handles payroll and purchasing for sponsored projects and supplies facilities that house research teams. Its staff track spending against sponsor requirements and university rules, while a board of directors oversees the organization. Established in 1943, the foundation is a separate university auxiliary organization headquartered in San Diego, California.

Company size
1,001-5,000
Company stage
Not listed
Total funding
Not listed
Headquarters
Not listed
Founded
1943

Recently Posted Jobs

Explore more opportunities at SDSU Research Foundation

See more jobs