Job DescriptionJOB OBJECTIVE: Under the guidance of the Senior Developer and the Information Technology Director at the Texas Historical Commission, the Programmer/Developer will perform highly complex computer programming work for the Texas Historical Commission (THC). Work involves coordinating complex database design, development, upgrades, maintenance, systems analysis, systems documentation and administration. Works under limited supervision, with considerable latitude for the use of independent judgment.
ESSENTIAL DUTIES:- Create and maintain relational databases in Microsoft SQL Server using Structured Query Language, including familiarity with stored procedures, userdefined functions, and triggers.
- Provide ondemand database reports in various output formats.
- Design and manage webbased applications using Microsoft .NET framework using MVC, and .NET Core architecture using C# programming language.
- Carry out tests and optimize application support services.
- Provide customer and operational support as required.
- Provide support for the production and (as appropriate) development systems to ensure an operational service is maintained.
- Maintain and schedule testing and production environments as required.
- Coordination and evaluation of IT products to ensure a consistent, effective approach
- Carries out tuning and trouble shooting activities (third level support). Implements solutions to prevent problems from reoccurring
- Produce data definitions, technical specifications, and user manuals for automated tools.
- Lead or participate in team projects using Systems Development Life Cycle processes, leading small projects, gathering requested information, writing, testing, and debugging programs and scripts, and testing and installing software upgrades.
- Coordinate and/or oversee special projects as needed.
- May supervise the work of others.
- Adhere to an established work schedule with regular attendance.
- Follow all THC safety guidelines/procedures and ethics requirements.
NONESSENTIAL DUTIES: - Perform other duties as assigned.
QUALIFICATIONS/REQUIREMENTS (The application must specifically state how each of the following qualifications are met): - Graduation from an accredited fouryear college or university with major coursework in computer science, information technology, management information systems, engineering, business administration, communications, or a related field (two years of relevant work experience related to the essential duties may substitute for one year of college);
- Minimum four years experience in database programming in a relational database environment, such as SQL Server or Oracle, TSQL DDL and DML queries, stored procedures;
- Minimum three years¿ programming experience in an ASP.NET environment;
- Experience with HTML 5, JavaScript, and CSS3; familiarity with HTML V technologies, including HMTL, CSS, JavaScript, and jQuery;
- Experience with C# programming language;
- Experience with Full Stack software development including relational database management systems, middleware, and frontend interfaces;
- Experience with data governance, including metatdata management, establishing standards and procedures, and ensuring data security;
- Strong foundation in HTML, CSS JavaScript, and jQuery;
- Experience scripting in Python and/or Perl;
- Ability to maintain the security or integrity of the critical infrastructure;
- Valid driver's license, acceptable driving record, and ability to drive a state vehicle; and
- Required to travel up to 10% of the work period.
PREFER: - IT experience in a Texas state agency environment.
- Experience participating in system development and support activities, including analyzing business process requirements and analyzing structured data flow.
- Experience evaluating and reviewing database performance monitoring, implement efficiency improvements, and modify existing databases and database management systems.
- Experience planning and implementing database upgrades, support, and maintenance activities.
- Experience with the React Javascript library
- Experience with PowerShell scripting
- Experience with project management involving all aspects of the Software Development Life Cycle
- Experience working with clients in order to document business processes and project requirements
- Familiarity with SQL Server Reporting Services (SSRS)
- Experience with managing software security vulnerabilities as enumerated in OWASP top 10 risk areas
- Experience supervising other developers in a team environment
- Experience working with ESRI ArcGIS, including Web GIS.
- Knowledge of git version control and GitHub repository management
KNOWLEDGE, SKILLS, AND ABILITIES: - Effective verbal and written communication, human relations, and organizational skills;
- Effective critical thinking skills;
- Knowledge of scripting languages such as Perl or Python;
- Knowledge and experience with project management tools such as Microsoft Project and Microsoft Visio;
- Skill in systems analysis and documenting systems architecture; converting business requirements into software solutions;
- Ability to analyze problems, evaluate alternatives, and recommend effective solutions;
- Ability to work in a setting requiring selfmotivation/cooperative decisionmaking and to work effectively with diverse groups of people;
- Ability to work effectively under pressure and meet strict deadlines while maintaining extreme attention to detail;
- Ability to adapt successfully and quickly to change and deliver quality results in a timely manner;
- Ability to plan, organize, and work independently, as well as within a team environment;
- Ability to anticipate needs and risks;
- Ability to exercise sound judgment and discretion; and
- Ability to maintain the highest level of confidentiality.
REGISTRATION, CERTIFICATION, OR LICENSURE: Must have or obtain a valid Driver's License and Defensive Driving Course to be able to operate state vehicles.
ENVIRONMENT/PHYSICAL CONDITIONS: Normal office work environment and may have exposure to dust and environmental allergens consistent with normal business activities and human contact. Mostly sedentary in nature but may involve walking, standing, pulling, and pushing; kneeling, stooping, and bending; performing tasks requiring fine motor skills and coordination; and safely lifting and carrying items weighing up to 30 pounds. Must be able to work extended periods at a computer, and may require working extended hours and some evenings, weekends, and overnight, as needed. Involves safely operating a state vehicle and, driving for long distances, and traveling by airplane.
REMARKS (Application procedures, Special requirements): State of Texas application must be submitted through the CAPPS website . Only applicants interviewed will be notified of their selection or nonselection. Resumes will NOT be accepted in place of a completed application.
