20-67 Programmer III - IV
We offer a competitive compensation and benefits package including medical, dental, vision, 401(k), flexible spending, and flexible work hours so you can have a work/life balance! For more information about these benefits and more visit:http://www.twdb.texas.gov/jobs/benefits.asp
Only candidates who apply via email to (HR “at” TWDB.texas.gov) with an official State of Texas Application or through the WorkInTexas.com website will be considered for this position. View this position and apply via the external application link on Handshake.
Job Description Summary
Performs highly complex to advance (senior-level) computer programming and software development work. Work involves assisting the project manager in coordinating programming projects and developing and maintaining existing and new internal software and web applications used by TWDB; planning and analyzing user requirements, procedures and problems to automate processes and to improve existing systems; and analyzing and proposing computer applications and providing technical assistance. Demonstrates superior technical ability to create complex SQL queries, views, and stored procedures. Creates informative and aesthetically pleasing reports in Microsoft SQL Server Reporting Services using SQL queries, stored procedures, parameters, grouping, and sub-reports. May train others. Works under minimal to limited supervision; with moderate to considerable latitude for the use of initiative and independent judgment. Reports to the Manager of the Application Development Department.
Essential Job Functions
- Codes, tests, and debugs computer application programs and/or geospatial viewers as outlined by technical and functional requirements.
- Assists in the identification and scheduling of project deliverables, milestones, and required tasks.
- Generates project requirements and provides effort estimates and resource requirements.
- Develops, analyzes, and revises system design procedures, program code, test procedures, and quality standards.
- Codes, tests, and debugs computer application programs as outlined by technical and functional requirements.
- Uses current software design and development methodologies and techniques to ensure quality and maintainability of applications and systems.
- Prepares unit test plans and test data for the applications being modified or created.
- Develops diagrams and flowcharts to represent operations and data flow for applications.
- Works with systems analyst to create technical documentation for applications.
- Prepares and develops instructions or manuals for end users.
- Researches and analyzes project proposals and software and system modifications.
- Analyzes proposed computer applications in terms of equipment requirements and capabilities.
- Analyzes, reviews, and revises code to increase operating efficiency or to adapt to new procedures.
- Confers with staff members to schedule work and coordinate programming projects.
- Assists in developing standards, best practices, and procedures for programming staff.
- Assists in the generation or installation of systems software.
- Develops and implements specialized programs to supplement and enhance systems software.
- May train others.
- Maintains confidential and sensitive information.
- Ensures individual and team files (electronic and hard versions) are appropriately maintained and timely disposed of in accordance with the agency’s records retention procedures and schedule.
- Maintains required certifications and licenses and meets the continuing education needs and requirements of the position to include, attending mandatory training courses.
- May be required to operate a state or personal vehicle for business purposes.
- Performs other duties as assigned.
- Graduation from an accredited four-year college or university with major coursework in Computer Science, Information Science, Management Information Systems, Information Technology, Geography (GIS-related), or related field.
- Relevant education and experience may be substituted on a year-for-year basis.
- Experience with Geographic Information Systems and developing/programming GIS web applications.
- Experience with Azure DevOps, formerly known as Visual Studio Team Services.
- Two to four years of experience designing and developing reports using Microsoft SQL Server Reporting Services, Microsoft SQL Server Management Studio, and Business Intelligence Development Studio.
- Experience developing applications using ASP.NET Model View Controller (MVC) framework.
- Experience working for a State of Texas agency.
Knowledge, Skills, and Abilities (KSAs)
- Knowledge of local, state, and federal laws and regulations relevant to the Application Development department and of the principles and practices of public administration.
- Knowledge of the principles, practices, and techniques of computer programming and systems analysis.
- Knowledge of the Software Development Life Cycle (SDLC).
- Knowledge of relational databases.
- Knowledge of Microsoft SQL Server 2005/2012/2016, including Database Management and Development tools and Reporting Services.
- Knowledge of Microsoft Visual Studio.NET 2008/2010/2012/2015/2017.
- Knowledge of Microsoft Internet Information Services.
- Knowledge of Windows Server 2003/2008/2012/2016.
- Skills in using Microsoft Office programs such as Word, Excel, and Access.
- Skills in use of internet, email, word processing, spreadsheet, presentation, and database software.
- Skills in computer programming.
- Skills in providing excellent customer service both internally and externally.
- Skills in decision making and problem solving.
- Skills in building cooperative partnerships with and providing services and products to internal and external customers.
- Skills in modifying or developing computer applications.
- Ability to use VB Script and access databases.
- Ability to develop, analyze, and design system requirements and processes.
- Ability to adhere to work schedules, follow procedures with respect to leave and submit accurate timesheets by prescribed deadlines.
- Ability to make mature, objective decisions and identify areas of potential problems.
- Ability to perform effectively and willingly when changes occur in scope and nature of the work and work environment.
- Ability to perform routine and non-routine work assignments accurately and on-time with little or no supervision.
- Ability to perform assigned duties and improve work habits and/or output.
- Ability to complete assigned work, on time, neatly and with infrequent errors.
- Ability to interpret policies, procedures, and regulations.
- Ability to provide prompt, courteous and accurate assistance and clear and concise communication to internal and external stakeholders both verbally and in writing.
- Ability to work and cooperate with others in a team environment.
- Ability to manage multiple tasks.
- Ability to stand/sit/move with no physical limitations or aids to perform activities such as retrieve/replace files in a large file system for boxes up to 30 lbs.
- Ability to operate a vehicle (state or personal) for state business and maintain a driver’s license and driving record that complies with state and agency requirements.
- Ability to work days that may exceed 8 hours, including early mornings, nights, and weekends.
- Ability to train others.