| Description: |
THE POSITION
This position performs software application support, software development, Oracle database management and support, systems analysis, problem solving, and data extraction, verification and analysis functions in support of the university's alumni and advancement activities.
DUTIES AND RESPONSIBILITIES
Software development: develop Web-based software applications using tools such as Oracle Application Server, Oracle database, and Oracle Reports; document requirements and develop technical specifications; design new database applications; implement/maintain the system by developing tables, procedures, functions, views in Oracle database using PL/SQL and SQL. Create additional Web forms and pages using Java, Javascript, and HTML. Create test plans/cases to ensure the application addresses all user requirements and that application is tested thoroughly prior to release. Incorporate necessary application security to protect data; maintain and upgrade existing custom software applications; provide user documentation and training. Oracle Database Administration: Oracle database design, creation and maintenance of training, development, test, production environments; implement data constructs for custom applications including design and implementation of Oracle datamarts and extracts; provide version control for modifications, as well as new vendor releases and bug fixes; provide database security including the creation and maintenance of new Oracle accounts, monitoring valid passwords, and encryption of sensitive information; design, implement, maintain disaster recovery plan. Custom programming: perform custom programming for user requests not included in self-service Web applications, often within a two-week turnaround time.
MINIMUM REQUIREMENTS
Equivalent to a bachelor's degree and two years of progressively responsible experience in software development and database administration. (Up to two years of related experience may be substituted for up to two years of the educational requirement on a year-for-year basis.)
REQUIRED SPECIALIZED SKILLS/ABILITIES
Knowledge of databases and their design; ability to work and communicate with users to define technical needs and requirements and provide efficient solutions; ability to design and create complex application software using PL/SQL and SQL; knowledge of Oracle database architecture, security, management, tuning, and disaster recovery; ability to perform system, database, and software maintenance tasks and to troubleshoot problems; ability to develop/provide technical training programs and user documentation; general knowledge of PC operating systems and hardware; excellent oral and written communication skills; demonstrated ability to direct, train, and assist others in completing work assignments; demonstrated ability to meet deadlines. May be required to work overtime on an as-needed basis.
PREFERRED SKILLS
Knowledge of software development processes; knowledge of WWW technology, Oracle Web Application Server, Java, JavaScript, HTML, SSL; general knowledge of Windows NT, Windows 95, IIS, SSL, ODBC, Access, Word, Excel; experience with data processing procedures; strong organizational skills.
SALARY AND BENEFITS
$3547 - $4844/month. Cal Poly offers excellent fringe benefits including health, dental, and vision insurance; retirement (Social Security and Public Employee's Retirement System-PERS); and educational opportunities. |
