TTSTC – Database Administrator V (00029144)

Organization: TREASURY SAFEKEEPING TRUST COMPANY

Primary Location: Texas-Austin

Work Locations: Thomas J Rusk Building 200 East 10th Street Austin 78701

Job: Computer and Mathematical

Employee Status: Regular

Schedule: Full-time

Standard Hours Per Week: 40.00

Travel: Yes, 5 % of the Time

State Job Code: 930U

Grade: 28 B28

Salary (Pay Basis): 8,334.00 – 9,167.00 (Monthly)

Number of Openings: 1

Description

Applications must be filed at

https://capps.taleo.net/careersection/ex/jobdetail.ftl?job=00029144&tz=GMT-06:00&tzname=America/Chicago

About the Comptroller’s Office

Innovation, collaboration, and a commitment to excellence best describes the culture here at the Comptroller’s Office. We take pride in the work we do serving as Texas’ accountant, tax collector, treasurer, and much more!

Culture

Our agency workforce is as diverse as the people of Texas we serve. We value our employees and take very seriously our collective commitment to public service. Personal development opportunities are strongly encouraged through available workshops, teambuilding exercises, and on the job training. We offer flexible scheduling that helps employees maintain a healthy work-life balance.

If you are seeking to gain knowledge, build your career, and network among goal-oriented professionals, this is the place for you!

Click here to see an inside look at the Texas Comptroller’s office! Click here to see a video from the division!

General description

Join the Texas Treasury Safekeeping Trust Company as a Database Administrator V! Work involves database administration work, development and code promotion across multiple environments including development, test, production, and disaster recovery. This work will involve database creation and architecting; daily scheduled maintenance, monitoring, troubleshooting, and tuning; security setup and review; research and recommend database software; develop maintenance scripts; perform senior level data warehouse, query development, ETL, BI and report development. The candidate must have the ability to learn new concepts quickly and apply knowledge appropriately in a highly active environment with ever-changing circumstances.

Qualifications

Minimum Qualifications

Bachelor’s degree.
5 years of responsible MS SQL database administration experience including SQL Server Integration Services and SQL Server Reporting Services. Five years at senior level.
5 years of database development and system design experience; experienced in writing stored procedures, tables, views, management scripts, SSRS, SSIS, creating relational database.
5 years of experience with database backup and restoration.
5 years of experience with DBMS performance monitoring and tuning.

Preferred Qualifications

Major coursework in computer science, management information systems, or a related field is generally preferred.
Current (within the last two years) DBMS administration experience with Microsoft SQL Server 2016 +.
Experience running MS SQL in a virtualized environment.
Experience promoting scripts, SSIS packages, SSRS reports, configurations, and developer code
Preferred data warehouse experience.
Preferred experience developing in DevOps, PowerBI, C#, .Net, JSON, Python, SSIS and SSRS
Preferred Oracle and MySQL DBMS administration experience.

Substitutions

Education requirement may be substituted with up to four (4) years of related experience.

LICENSES / CERTIFICATIONS

Preferred – Microsoft Certified Database Administrator (MCDBA), Microsoft Certified Solutions Associate (MCSA), Microsoft Solutions Expert (MCSE), Microsoft Certified Technology Specialist (MCTS), Network+, Server+, VMware 5.x certification, SQL Server, A+, MCP (Microsoft Certified Professional).

In this role you will:

Designs and develops logical and physical data models, database relationships, data access objects, including tables, views, functions, and stored procedures,
Designs and develops data warehouse, BI tools, ETL processes and reports
Works with application development staff to design and review interfaces, tune database models and database queries in new and existing systems.
Performs database performance monitoring and implements efficiency improvements.
Builds and refines new and existing indexes.
Designs and implements procedures for monitoring, evaluation, and tuning of database hardware and software to maintain an efficient and cost-effective database system.
Performs code migrations between environments, which includes stored procedures, SSIS packages, SSRS reports, accounting system configurations and upgrades to systems as required.
Designs and implements procedures necessary to save, retrieve, and recover databases from hardware and software failure as well as establishing database security standards and controls.

Veterans:

To receive veteran’s preference a copy of your DD214 (Member 4) is required.

Veterans, Reservist or Guardsmen with an MOS or additional duties that fall within the essential duties of the job position or other related fields pertaining to the minimum experience requirements may meet the minimum qualifications. All active duty, reservists, guardsmen, and veterans are encouraged to apply if they meet the qualifications for this position. Please call Human Resources, CPA Veterans Liaison at 512-475-3560/800-531-5441 for more information or assistance.

Go to: http://www.texasskillstowork.com, http://www.onetonline.org, https://hr.sao.texas.gov/CompensationSystem/JobDescriptions/ or www.careeronestop.org for assistance translating your military experience and training courses into civilian job terms, qualifications/requirements and skill sets.

Applications submitted through Work In Texas:

Work In Texas (WIT) applicants must complete the supplemental questions to be considered for the posting. To complete the supplemental questions please go to CAPPS Recruit to register or login and access your profile.

The Comptroller’s Office is proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity.