TPWD - Programmer IV (Oracle Database/Forms/Reports Developer)

Job Description:

TPWD - Programmer IV (Oracle Database/Forms/Reports Developer)

Description

TPWD MISSION

To manage and conserve the natural and cultural resources of Texas and to provide hunting, fishing and outdoor recreation opportunities for the use and enjoyment of present and future generations.

PLEASE NOTE:

All applications must contain complete job histories, which includes job title, dates of employment (month/year) and hours worked per week, name of employer, supervisor's name and phone number and a description of duties performed.

Job history and volunteer experience should be listed in the work history section of the application to receive credit towards meeting the minimum requirements. Part-time experience credit is prorated based on the duration and hours worked per week. Please indicate hours worked for part-time/temporary/seasonal experience. If this information is not submitted, your application will be considered incomplete.

Applications with "See attached" or "See resume" will not be accepted in lieu of a completed application. Omission of data can be the basis for disqualification; you may state 'unknown' for any incomplete fields. If education is used to meet the minimum requirements of the job posting, a copy of a college transcript(s) issued from the registrar must be provided if you are selected for an interview.

WATCH OUR VIDEO ON HOW TO APPLY FOR JOBS



APPLICATIONS SUBMITTED THROUGH WORK IN TEXAS: Work In Texas (WIT) applicants must complete the supplemental questions to be considered for the posting. To complete the supplemental questions, go to CAPPS Recruit to register or login. CAPPS Recruit, https://capps.taleo.net/careersection/ex/jobsearch.ftl?lang=en


MILITARY OCCUPATIONAL SPECIALTY CODES:

Job Classification

Service

Military Specialty



Programmer I-VI

Army

25B, 255A, 255S, 26B

Programmer I-VI

Navy

CT, CTR, IT, 181X, 182X, 681X, 682X, 781X, 782X

Programmer I-VI

Coast Guard

IT, CYB10, CYB11, ISM

Programmer I-VI

Marine Corps

0673, 2652, 2653, 8846

Programmer I-VI

Air Force

3D0X4, 8K000, 16KX

*More information on military occupational specialty codes can be found below:

https://www.onetonline.org/crosswalk/MOC/

https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MilitaryCrosswalkGuide.pdf

MILITARY EMPLOYMENT PREFERENCE:

If you choose to claim military employment preference as outlined by the State of Texas, you must attach the required documentation referenced below at the time your application is submitted . If you have questions regarding this requirement, please visit our Military Employment Reference page at https://tpwd.texas.gov/jobs/veterans/ .

Required forms that will need to be attached with application for Military Employment Preference:
Veteran- DD214 showing honorable discharge or Statement of Service (only for transitioning service members who have not reached their date of separation). Surviving spouse of a veteran who has not remarried- Marriage Certificate and DD Form 1300 or appropriate documentation. Orphan of a veteran killed while on active duty- Birth Certificate and DD Form 1300 or appropriate documentation. Spouse of a member of the US Armed Forces/Texas National Guard serving on Active Duty- Marriage Certificate and copy of spouses active-duty military orders. Spouse of a veteran with disability and is the primary income for household- Marriage Certificate, Veterans DD214, and VA Benefits Summary Letter showing disability rating.
Documentation must be attached to the application before military preference can be granted.


BENEFITS:

Texas Parks and Wildlife offers a variety of benefits for employees such as generous paid time off, group insurance, retirement and pension, and frequent training and staff development opportunities. Other benefits include longevity pay, merit pay, deferred compensation, flexible benefit plans, 401K/457 retirement plans, direct deposit, telework, staggered work hours, Employee Assistance Program and a Return to Work Program. For new employees or rehires, health insurance is available the 1st of the following month after a 60-day waiting period. Click HERE to view our Benefits page.

HIRING CONTACT: Mahesh Menon , (512) 389-8705

PHYSICAL WORK ADDRESS: Application Development, 4200 Smith School Road, Austin TX 78744



GENERAL DESCRIPTION :

Under the direction of the Manager, this position performs advanced (senior-level) computer programming work. May serve in a lead role and coordinate or oversee work of others. Work involves interacting closely with project management and customer gathering requirements, design, build and maintain applications. This may include developing multiple aspects of an application like web and mobile user interfaces, middle and database tiers. Assists with architectural direction for web and mobile applications and involves overseeing the planning, scheduling, and assigning of projects. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment. Performs other duties as assigned. Complies with all Agency, Division, and Branch rules, regulations, and procedures.


Qualifications:

MINIMUM QUALIFICATIONS :

Education :

Graduation from an accredited college or university with a Bachelor's degree.

Experience :

Seven years of recent experience designing and developing database for applications including PL/SQL, SSL, entity relationship diagramming, table normalization, performance tuning on relational databases.

Five years of Oracle Forms and Reports experience.



PREFERRED QUALIFICATIONS :

Education :

Bachelor's degree in Computer Science from an accredited college or university.

Experience :

Power BI experience.



KNOWLEDGE, SKILLS AND ABILITIES :

Knowledge of architectural concepts for achieving end-to-end performance, scalability, availability, reliability, integration and security.

Knowledge of current technological trends in software development and hardware architecture.

Knowledge of unit testing frameworks.

Skill in designing and developing database for applications including entity relationship diagramming, table normalization, performance tuning.

Skill in data migration for small to large relational databases.

Skill in developing production business applications using Oracle Forms, Oracle Reports, and PL/SQL.

Skill in using a version control software like SVN or Git.

Skill in using IDE like Visual Studio, Eclipse, Report Builder, Oracle Fusion Middleware, Toad or SQL Developer.

Skill in effective verbal and written communication.

Skill in establishing and maintaining effective work relationships with co-workers and work-related contacts.

Skill in managing several projects simultaneously.

Skill in prioritizing tasks and meeting deadlines.

Skill in participating in Joint Application Development (JAD) sessions for requirement definition, system appraisals and process re-engineering projects.

Skill writing SQL in industry standard relational databases.

Skill in Reporting tools like PowerBI.

Ability to work independently with little or no supervision.

Ability to perform detailed work accurately.

Ability to maintain flexibility and work with frequent interruptions and multiple changing priorities.

Ability to follow standards for software development.

Ability to serve as technical lead on programming projects.

Ability to assign or supervise work of others.

Ability to perform the steps required of the System Development Life Cycle (SDLC).

Ability to integrate newly developed technologies and methodologies into the existing application development environment.

Ability to participate in the interview and selection process for in-house and contracted staff.

Ability to design and review RFI's and RFP's for hardware, software or services.



WORKING CONDITIONS :

Required to work from 8:00 a.m. to 5:00 p.m., Monday through Friday.

Required to work overtime as necessary.

Required to provide after hours support as needed.

This position is suitable to telework two days per week and the candidate may be allowed to telework with supervisor approval.

Required to pass a national fingerprint-based background check to maintain employment.

Must conform to TPWD dress and grooming standards, work rules and safety procedures.

Non-smoking environment in State buildings and vehicles.



TPWD IS AN EQUAL OPPORTUNITY EMPLOYER



WATCH OUR VIDEO ON HOW TO APPLY FOR JOBS


Closing Date: Feb 5, 2025, 11:59:00 PM