Job Description
Position Title:
Database Administrator I-II
Class/Group:
0211-0212/B20-B22
Military Occupation Specialty Code:
Army – 25B, 255A; Navy – IT, 682X, 782X; Coast Guard – IT, ISM; Marine Corps – 0671, 8846
Fair Labor Standards Act Status:
Exempt
Number of Vacancies:
1
Division/Section:
Chief Technology Office/IT Services/IT Operations
Salary Range:
$4833.33 – $6250.00 / monthly
Duration:
Regular
Hours Worked Weekly:
40
Work Schedule:
This position may be eligible for flexible work hours and/or a hybrid work schedule if certain program guidelines are met; working arrangements may change at any time at the sole discretion of the agency.
Travel:
Limited
Agency Address:
300 West 15th Street, #1300 / Austin, Texas 78701
Web site:
https://dir.texas.gov/
Refer Inquiries to:
People and Culture Office
Telephone:
(512) 475-4957 or (512) 463-5920
How To Apply:
- Select “Apply Online” to apply for the job at https://capps.taleo.net/careersection/ex/jobsearch.ftl?lang=en
- You must create a CAPPS Career Section candidate profile or be logged in to apply.
- Update your profile and apply for the job by navigating through the pages and steps.
- Once ready, select “Submit” on the “Review and Submit” page.
- If you have problems accessing the CAPPS Career Section, please email the CAPPS Recruiting Help Desk at capps.recruiting@cpa.texas.gov
Special Instructions:
- Applicants must provide in-depth information in the EXPERIENCE & CREDENTIALS section to demonstrate how they meet the position qualifications. Incomplete applications may result in disqualification.
- Resumes may be uploaded as an attachment but are not accepted in lieu of the information required in the EXPERIENCE & CREDENTIALS section of the application.
Interview Place/Time:
Candidates will be notified for appointments as determined by the selection committee.
Notice:
Section 651.005 of the Government Code requires males, ages 18 through 25 years, to provide proof of their Selective Service registration or proof of their exemption from the requirement as a condition of state employment.
Equal Opportunity Employer
The Department of Information Resources does not exclude anyone from consideration for recruitment, selection, appointment, training, promotion, retention, or any other personnel action, or deny any benefits or participation in programs or activities, which it sponsors on the grounds of race, color, national origin, sex, religion, age, or disability. Please call 512-463-5920 to request reasonable accommodation.
The Opportunity
The Texas Department of Information Resources is the state agency charged with protecting the state’s data and critical technology infrastructure, managing a multi-million-dollar cooperative contracts program, and providing strategic technology leadership, solutions, and innovation to all levels of Texas government. DIR is a fast-paced and collaborative environment with highly motivated and engaged employees dedicated to achieving the best value for the state.
Database Administrator I
This role performs routine to moderately complex (journey level) database analysis, design, and developmental work. Works under general supervision, with limited latitude for the use of initiative and independent judgment.
Database Administrator II
This role performs complex (journey level) database analysis, design, and developmental work. Works under general supervision, with moderate latitude for the use of initiative and independent judgment.
Work involves coordinating the planning, development, maintenance, and monitoring of integrated database systems; evaluating and reviewing database architecture; and maintaining data integrity. Experience and demonstrated competency with Data Warehousing concepts, tools, and methodologies is required. Designs and implements reliable, reusable, and robust ETL solutions that deliver data integrity, accurate data mapping and cleansing.
What We Do
The ideal candidate will have the ability to highlight their strengths in the following functions:
• Performs analysis and maintenance of data and at times the database structures of Oracle and SQL Server databases.
• Consult and provide professional contributions on acquisition of database software and resources.
• Establishes and implements necessary application and database level security standards and controls.
• Plans, coordinates, and supports maintenance, patching, and upgrades to DIR’s database environment; verifies and performs regression testing as necessary.
• Provide provisioning support to database reporting using Microsoft PowerBI and SAP Business Objects Business Intelligence platforms.
• Monitor daily ETL processes and be able to triage when irregularities are discovered. This can involve investigating and analyzing SSIS packages, batch files, python & .net scripts.
• Performs routine data fixes, database administration and higher-level troubleshooting for some in-house applications, and anything interacting with the agencies databases.
• Performs related work as assigned.
Qualifications:
Education
• Graduation from an accredited four-year college or university with major course work in Computer Science or other related degree.
• Additional work-related experience may be substituted for education on a year-for-year basis.
Experience and Training Required
• Experience with SQL coding language
• Experience in computer systems, data analysis, and database development/maintenance work
Experience and Training Preferred
• ETL Experience: Microsoft SQL Server Integration Services and SAP Business Objects Data Services
• SQL Server and Oracle Database
• Web Services implementations on various platforms
• Reporting Tools: SAP Business Objects Web Intelligence & Data Services, Power BI, Tableau
Knowledge, Skills, and Abilities
• Working knowledge of information resources project management principles, best practices, and tools; ability to effectively manage complex information technology projects; ability to conduct effective, thorough review of project requirements and deliverables; ability to conduct short and long-range project planning studies.
• Thorough and current knowledge of the practices, principles, and techniques of computer operations of information resources technology that includes hardware, packaged software implementation, software development, data communications, local and wide area networks management; knowledge of the security limitations and capabilities of computer systems; includes ability to research, evaluate and interpret material and create effective narratives on IT issues and standards.
• Knowledge of the principles, practices, and techniques of computer databases, programming, and systems design; computer database application systems; data processing flowcharting techniques; database structures and theories; current database technologies; and data analysis, evaluation, and testing techniques.
• Skills in complex problem solving and critical thinking.
• Ability to identify and define users’ functional and technical database needs, to conduct shortrange and long-range project planning studies, to develop reports, and to communicate effectively.
• Skill and ability to work collaboratively in finding solutions for or to deal proactively with work-related problems; ability to identify and implement best practices; ability to recognize potential and existing problems, identify courses of action and apply contingency plans to solve problems as a project manager and in a team environment.
• Should have both strong Database and Business Analytic skills.
• Skill in complex problem solving, and critical thinking in the operation of computers and applicable software.
• Demonstrated ability to work on concurrent tasks while effectively prioritizing and coordinating work assignments.
• Ability to serve internal agency customers, including executive staff, by focusing effort on meeting their needs, understanding their concerns, and effectively resolving issues; ability to identify and define user task needs.
• Ability to process information logically and make critical decisions in the best interest of the agency and its mission and goals, while following agency procedures.
• Orientation toward action and ability to see the overall picture; ability to balance consideration of short and long-term planning goals.
• Ability to focus on a goal and obtain a pre-determined result.
• Ability to look beyond the standard solutions.
• Ability to exercise sound judgment in making critical decisions.
• Ability to exercise courtesy, tact, and diplomacy in all communications; including the ability to exercise discretion when handling confidential information.
• Ability to understand, follow and convey brief oral and/or written instructions.
• Ability to establish and maintain effective and cordial working relationships at all organizational levels, including agency management, direct supervisors, co-workers, internal and external customers.
• Ability to communicate both verbally and in writing, in a clear and concise manner.
• Ability to work independently and as part of a team, and to support and contribute to a cohesive team environment.
• Ability to work a flexible schedule and to schedule workload to meet requirements and deadlines of the position.
• Ability to work under pressure and exacting schedules to complete assigned tasks.
• Ability to comply with all agency policies and applicable laws.
• Ability to comply with all applicable safety rules, regulations, and standards.
Computer Skills
• Proficiency in the use of a computer and applicable software necessary to perform work assignments (e.g., word processing, spreadsheets). Microsoft Office preferred.
Other Requirements
• Regular and punctual attendance at the workplace.
• Criminal background check.
Working Conditions
• Frequent use of computers, copiers, printers, and telephones.
• Frequent standing, walking, sitting, listening, and talking.
• Frequent work under stress, as a team member, and in direct contact with others.
• Occasional bending, stooping, lifting, and climbing.
• Occasional overtime
• Limited travel