Database Administrator IV
Job Posting:
00037317
Opened:
10/16/2023
Closes:
10/30/2023
Position Title:
Database Administrator IV
Class/Group:
0214/B27
Military Occupation Specialty Code:
Army 17C, 25B, 25D, 170A; Coast Guard CYB10, CYB11, CYB12; Marine Corps 0605; Air Force 1D7X1, 3D0X2; Space Force 5C0X1D, 5C0X1N
Fair Labor Standards Act Status:
Exempt
Number of Vacancies:
1
Division/Section:
Chief Technology Office/ Information Technology Services
Salary Range:
$6681.17 - $9583.33
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:
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 [email protected]
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.
Selective Service Registration:
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.
H-1B Visa Sponsorship:
We are unable to sponsor or take over sponsorship of an employment Visa at this time.
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.
Position Description
What We Do
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.
Position Summary
This role performs highly complex (senior level) database analysis, design, and developmental work. Should have both strong Database and Business Analytic skills. 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. May supervise the work of others. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.
• Coordinates and/or conducts the design, analysis, and maintenance of database structures.
• Develops efficient and cost-effective database driven application systems; consults and provides professional contributions on acquisition of database software and resources; establishes and implements necessary application and database level security standards and controls.
• Maintains fluency in Relational, Network, and Star Schema database modeling to create and maintain DIR’s logical data models. Utilizes new and existing data models to create sources to target data mapping specifications, solution architecture and ETL detailed design documents and objects.
• Plans, coordinates, and supports maintenance, patching, and upgrades to DIR’s database environment; verifies and performs regression testing as necessary.
• Assists in developing policies and procedures designed to ensure the integrity of the production environment with an emphasis on the databases.
• Designs, implements, and supports a robust, sustainable, and scalable data warehouse architecture that supports requirements and provides for expansion given budgetary constraints and availability of data and skilled resources.
• Identifies appropriate data sourcing and extraction processes and identifies and nominates sources as systems of record for data usage in various applications. Implements corresponding database changes to support new and modified applications, and ensures new designs conform to data standards and guidelines; are consistent, appropriate for their intended use, and perform as required; and are secure from unauthorized access or update.
• Performs other work-related duties as assigned.
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
• Seven (7) years of experience designing, developing, maintaining and supporting diverse database systems, including ETL functions.
• Experience in relational database modeling, Entity Relationship Diagramming, and normalization.
Experience and Training Preferred
• ETL experience with Microsoft SQL Server Integration Services, SSIS/SSRS.
• Oracle or SQL Database development.
• Experience with development and implementation of an enterprise data warehouse.
Knowledge, Skills, and Abilities
• 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
• 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.
• Skills in communicating both verbally and in writing; in a clear and concise manner.
• Skill 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.
• Skill in complex problem solving, and critical thinking in the operation of computers and applicable software.
• 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 understand, follow and convey brief oral and/or written instructions.
• 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 under pressure and exacting schedules to complete assigned tasks.
• Ability to work a flexible schedule to meet required deadlines.
• Ability to comply with all agency policy 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.