California expected pay range: $114,138 - $171,207
Summary
To analyze, design and implement computer software; maintain assigned subsystems; plan, code, test and document application programs using structured and/or object-oriented methodologies. This position is critical to the success of CenCal Health efforts, in an environment that is driven by data and information.
Duties and Responsibilities
-
Consults with users to finalize application requirements
-
Identifies programming and output needs
-
Verifies preliminary design and output
-
Analyzing, designing, and implementing computer software and maintaining assigned subsystems
-
Planning, coding, testing and documenting application programs using structured and/or object-oriented methodologies
-
Recommending technical and procedural design for new or revised applications including flow charts
-
Producing system specifications
-
Follow programming guidelines and perform code reviews
-
Reviews, modifies and/or writes program code and/or job control language as needed
-
Writes documentation of system procedures and guidelines for application users as well as programs and program modifications
-
Answers questions and provides technical assistance and/or training to application users
-
Resolves problems by reviewing and analyzing software documentation and production outputs to identify causes - troubleshooting
-
May serve as lead developer on a small application or assist the lead on larger applications
-
Assists other employees in resolving certain technical problems
-
Confers with other IT personnel in resolving problems involving procedural and technical matters
-
Provides more advanced technical support for the customer
-
Researches problems and recommends solutions
-
Provides resource estimates and progress reports
-
Serves on committees to develop technical standards and direction
-
Meets with CenCal customers and technical staff to determine information needs and requirements
-
Ensures that all work is accurate and in compliance with departmental or project quality standards
-
Participates in training and professional development sessions
-
Possible support on nights and weekends as needed
-
Provides input for the planning and budget process
-
Other duties as assigned
Skills/Knowledge/Abilities
Required
-
Proficiency in SQL Server and/or Oracle products including (but not limited to): Oracle SQL*Plus, SQL, PL/SQL, , Java, JavaScript, HTML, XML, Linux/UNIX shell scripting; knowledge of Oracle RDBMS database, .Net Core, C#, Internet, and Intranets; experience with personal computers (PCs), MS Windows operating system, and MS Office Suite.
-
Superior problem solving and troubleshooting capabilities
-
Excellent verbal and written communication skills
-
Ability to attend meetings and participate in small teams effectively
-
Must be able to budget time and meet deadlines
Preferred
-
SSRS & Cognos or similar reporting tools.
-
Microsoft SQL Server
Education and Experience
- Bachelor's Degree in Computer Science or Information Technology, or equivalent experience
-
Three to Five years of programming experience in a SQL Server and/or Oracle development environment
-
Three years hands-on Experience on large database development
-
Three years hands-on experience On databases applications
-
Three years hands-on experience with .Net Framework using C#.
-
Development using Packages, Stored Procedure, and Functions 3+ years of SQL and/or PL/SQL development experience
-
Unix Shell Scripting experience