IS Analyst/Programmer II
$61,901–$114,774 year
HybridSan Diego, California, United States
San Diego, California, United StatesHybridFull Time$61,901–$114,774 yearLarge
Full TimeLarge
Job Summary
Support, improve, and modernize administrative systems for SDSURF staff and faculty by troubleshooting, gathering requirements, and developing custom applications within Ellucian Banner and Oracle Application Express. Design, prototype, test, and deploy secure programs while integrating data with external systems using Oracle SQL, PL/SQL, and Linux shell scripting. Provide end-user support, investigate software solutions for data challenges, and collaborate on centralized reporting assets. Document code and processes in compliance with security policies. This role occasionally requires work beyond typical business hours, including weekends and holidays.
Required Qualifications
- Bachelor's degree in Information Systems, business or related field or an equivalent combination of education, certifications and relevant experience
- Two-years of related work experience of system design, analysis, programming experience
- Oracle SQL/PL-SQL programming experience
- Ability to gather requirements from a diverse sources, perform data analysis, coding, testing, integration and maintenance of Oracle and other business applications
- Strong customer service skills and strong desire to assist others
- Ability to communicate effectively to instruct or train others through explanation and/or demonstration
- Strong verbal and written communication skills for both technical and non-technical audiences
- Self-motivated, ability to stay on task and work both independently and in team environment
- Highly motivated self-starter, with a strong and dependable work ethic and desire to be a system owner
- Well organized, ability to manage priorities and workload to meet deadlines, detail oriented; possess good judgment and common sense
- Demonstrated ability to handle direct customer interaction professionally
- Ability to quickly and honestly recognize and report mistakes to mitigate their impact on systems and users
- excellent team-working, training skills and a willingness to share knowledge with other team members along with a willingness to learn from other subject experts in order to raise the collective knowledge of our information systems family
- 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 Linux operating system, including Bash shell, user/group permissions and environment variables
- Ability to develop complex Oracle applications, data processes and integration with various systems
- Strong understanding of the software development lifecycle from technical design, unit testing to user testing, to production migration
- Emphasize adherence to standards and controls, and conduct quality assurance over programs before migration to production
- 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 APIs, Web Services or other data integration methods
- Experience with Oracle database design with strong knowledge of Oracle database concepts (including stored procedures, packages, functions, triggers, tables, views, indexes, etc.)
- 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 (Oracle preferred)
- Experience with Linux operating system
- Must be able to work hours beyond typical business hours, including after work hours, weekends, and holidays
- Candidate must reside in California and live within a commutable distance from SDSU at time of hire
- Job offer is contingent upon satisfactory clearance based on background check results (including a criminal record check)
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.