Database Administrator IV (Development DBA)

Job Posting:
#00028013

Opened:
10/26/2022

Closes:
Open Until Filled

Position Title:
Database Administrator IV (Development DBA)

Class/Group:
B26/0214

Military Occupation Specialty Code:
Army-25B, 26B; Navy-682X; Marine-0671, 8846; Air Force-3D0X4

FLSA:
Exempt

Number of Vacancies:
1

Division/Section:
Chief Technology Office / Information Technology Services

Salary Range:
$5784.58 - $7500.00

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 W. 15th St., Austin, TX 78701

Web site:
https://dir.texas.gov

Refer Inquiries to:
Human Resources

Telephone:
(512) 463-5920 or (512) 475-4612

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 accommodations.

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. 
This role performs advanced (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.  Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment.

WHAT WE DO

• The ideal candidate will have the ability to highlight their strengths in the following functions:
• Coordinates and/or conducts the design, analysis, and maintenance of database structures of Oracle and SQL Server databases.
• 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.
• Plans, coordinates, and supports maintenance, patching, and upgrades to DIR’s database environment; verifies and performs regression testing as necessary.
• Provide comprehensive database reporting support using Microsoft PowerBI and SAP Business Objects Business Intelligence platforms.
• Leads system integration work between internal and external data systems and applications. This can involve developing and utilizing 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.
• Server configuration and management is required at times. This can involve installing and configuring application software or drivers such as ETL connection managers or reporting software for example.

OTHER DUTIES

• May provide direction, instruction, or guidance to others.
• Performs related work 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 & TRAINING REQUIRED

• Seven (7) years of experience designing, developing, maintaining, and supporting diverse database systems, including ETL functions

EXPERIENCE & TRAINING PREFERRED

• ETL experience with Microsoft SQL Server Integration Services, SSIS/SSRS
• Oracle Database
• Microsoft PowerBI and SAP Business Objects Business Intelligence platforms.
• Remedy ITSM programming, configuration, integration, and enhancement
• Web Services implementations on various platforms
• Business Objects/SAP Data Services
• SalesForce.com

KNOWLEDGE, SKILLS & 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
• Excellent 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 work with limited supervision and to schedule workload to meet requirements and deadlines of the position
• 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 make critical decisions in the best interest of the agency and its mission and goals, while following agency procedures; ability to process information logically
• 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
• Demonstrated ability to work on concurrent tasks in a fast-paced environment while effectively organizing, prioritizing, and coordinating work assignments
• 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 exercise courtesy, tact, and diplomacy in all communications; including the ability to exercise discretion when handling confidential information
• Ability to work independently and as part of a team, and to support and contribute to a cohesive team environment
• Ability to work collaboratively and provide direction, instruction, and guidance to team members
• Ability to work a flexible work schedule to meet required deadlines
• Ability to work under pressure and exacting schedules to complete assigned tasks
• Ability to communicate both verbally and in writing, in a clear and concise manner
• Ability to understand, follow and convey brief written and oral instructions
• 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 personal computer and applicable software necessary to complete work performed.

OTHER REQUIREMENTS

• Regular and punctual attendance at the workplace
• Criminal background check

WORK ENVIRONMENT

• Frequent standing, walking, sitting, listening, and talking
• Frequent use of a personal computer, copiers, printers, and telephones
• Frequent work under stress, as a team member, and in direct contact with others 
• Occasional bending and stooping
• Occasional lifting and climbing
• Occasional overtime
• Limited travel