DPS - IT - Database Administrator

PLEASE NOTE : All applications must contain complete job histories, which includes job title, dates of employment, name of employer, supervisor's name and phone number and a description of duties performed. If this information is not submitted, your application may be rejected because it is incomplete. Resumes do not take the place of this required information. SUBMITTED THROUGH WORK IN TEXAS : Work In Texas (WIT) applicants must complete the supplemental questions to be considered for the posting. In order to complete the supplemental questions please go to CAPPS Recruit to register or login and access your profile. Go to CAPPS Recruit to Sign In .ftl?lang=en GENERAL DESCRIPTION : Perform highly complex (senior-level) database administration work. Work involves coordinating the planning, development, maintenance, and monitoring of integrated database systems; evaluating and reviewing database policies and procedures; and maintaining data integrity. May supervise the work of others. Work under limited supervision, with considerable latitude for the use of initiative and independent judgment. The following Military Occupational Specialty codes are generally applicable to this position. Applicants must fully complete the summary of experience to determine if minimum qualifications are met. .pdf ESSENTIAL DUTIES :

1. Perform Database Administration for relational databases. 2. Perform complex analysis and troubleshooting, using native and third-party tools, to resolve database problems. 3. Implement enterprise-grade database best practice policies and procedures to ensure consistent integrity and security of the database environment. 4. Monitor, append, and/or implement database backups and restores, thoroughly understanding the native recovery models. 5. Implement operational automation using scripts. 6. Implement best practices for indexes, index management, and statistics 7. Perform complex Performance Tuning and Optimization (PTO) activities, implementing efficiency improvements. 8. Perform database development to include data modeling, systems integrations using ETL tools, APIs, and techniques. 9. Implement High Availability (HA), Disaster Recovery (DR), and Reporting options for databases. 10. Respond to various users' needs providing solutions within the capacities of the available hardware and software resources. 11. Responsibly handle sensitive and confidential information and situations. 12. May supervise work assignments of others. 13. Attend work regularly and observe approved work hours in accordance with agency leave and attendance policies. 14. Perform other duties as assigned. GENERAL QUALIFICATIONS and REQUIREMENTS: Education

Graduation from an accredited four-year college or university with a major in Computer Science, Management Information Systems, Data Processing, or a related field is required. Experience

Minimum of three (3) years progressively responsible experience performing all tasks associated with design, implementation, and administration of relational databases is required. Experience in DB2 LUW, and/or Microsoft SQL Server is required. Substitution Note: Additional work experience of the type described or other related education may be substituted for one another on a year-for-year basis. Licensure and/or Certification

Must possess a valid driver license from state of residence. Regulatory knowledge

Working knowledge of, or the ability to rapidly assimilate information related to TXDPS, State and Federal regulations, legislation, guidelines, policies and procedures. Supervisory/Managerial/Leadership skills

Knowledge of management/supervisory methods and principals, performance/productivity standards, and fiscal/budget management. Ability to develop plans, policies, and procedures for efficient workflow and overall effectiveness. Ability to provide clear direction to others, promote teamwork and motivate others to accomplish goals. Technology

(computers/hardware/software/operating systems) Must possess appropriate levels of proficiency with utilized software and systems and be able to learn new software/systems. Advanced experience working with DB2 LUW, and/or Microsoft SQL Server. Intermediate experience of MySQL or PostgreSQL databases preferred. Working experience with multiple platforms including AIX, Linux, and Windows Server including storage management. Knowledge of the system development life cycle. Knowledge of Business Intelligence and Data Warehouse methodologies and design. Knowledge of cloud computing especially related to database infrastructure design and management, and security. Knowledge of CI/CD pipeline best practices and integration. Demonstrated proficiency with Microsoft Office Suite (Word, Excel, PowerPoint, Outlook). Interpersonal Skills

Must demonstrate an ability to exercise poise, tact, diplomacy and an ability to establish and maintain positive, working/professional relationships with internal/external customers. Must demonstrate DPS core values: Integrity, Excellence, Accountability, and Teamwork. Organizational and Prioritization Skills

Must be organized, flexible, and able to effectively prioritize in a multi-demand and constantly changing environment; able to meet multiple and sometimes conflicting deadlines without sacrificing accuracy, timeliness or professionalism. Presentation/Communication Skills

Must be able to construct and deliver clear, concise, and professional presentations and/or communications to a variety of audiences and/or individuals. Research and Comprehension

Must demonstrate ability to quickly and efficiently access relevant information and be able to utilize and/or present research and conclusions in a clear and concise manner. Analytical Reasoning/Attention to Detail

Must demonstrate an ability to examine data/information, discern variations/similarities, and be able to identify trends, relationships and causal factors, as well as grasp issues, draw accurate conclusions, and solve problems. Confidentiality and Protected Information

Must demonstrate an ability to responsibly handle sensitive and confidential information and situations and adhere to applicable laws/statutes/policies related to access, maintenance and dissemination of information. Safety

Must be able to work in safe manner at all times, avoiding shortcuts that have potential adverse results/risks, and must be able to comply with safety standards and best practices. Schedule and/or Remote/Telecommuting work and/or Travel

Availability for after-hours, weekends, and emergency work may be required as needed. This position may have the ability to telecommute based on the needs of the division/agency. Travel (in city and surrounding areas) as needed. PHYSICAL and/or ENVIRONMENTAL DEMANDS: The physical and environmental demands described here are representative of those encountered and/or necessary for the employee to successfully perform the essential functions of this job; reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Environment: Office; Ambulatory skills, e.g. stand, walk, sit; Hand-eye coordination and arm/hand/finger dexterity; Ability to speak, hear, and exercise visual acuity; Ability to transfer weights of twenty (20) pounds anticipated for this position; Driving requirements: Occasional (ten [10%]). State of Texas Benefits and Retirement Information: Current DPS employees who submit applications for posted DPS positions shall notify their immediate supervisor in writing. A DPS employee who is selected for a position in the same salary group and state title as their current position will be transferred with no salary change. A DPS employee who is selected for a position in their current salary group with a new state title may receive an increase of no more than 3.4% over their current salary regardless of posted salary. Salary is contingent upon qualifications and is subject to salary administration and budgetary restrictions. DUE TO THE HIGH VOLUME OF APPLICATIONS WE DO NOT ACCEPT TELEPHONE CALLS. ONLY CANDIDATES SELECTED FOR INTERVIEW WILL BE CONTACTED. State of Texas retirees may be rehired for full-time, non-commissioned positions only under very specific circumstances. #J-18808-Ljbffr