Pe39 - Sr. Database Administrator — Austin, TX

Job Description

Are you an experienced Sr. Database Administrator, ready for a unique opportunity to grow with an environmental state agency?

Join TCEQ! We bring passion and drive to carry out our mission of protecting our state's public health and natural resources.

NOTE: To determine qualifications, TCEQ job postings require fully completed applications with a detailed job history. Incomplete applications may lead to disqualification. See below for more details.

YOUR FUTURE TEAM

As part of TCEQ Administrative Services, you would help support the logistical and operational structure for TCEQ statewide -- the business foundation for the whole agency. See details about what we do.

This position is a member of our Information Resources Division.

Here's What You'll Be Doing

• Perform highly advanced database administration activities in support of the Agency's databases and environments. Serve as a technical expert and work with TCEQ staff and external customers in providing high level technical support and consultation services for database-related activities. Lead the design and creation of database standards, guidelines, policies, and procedures. Implement improvements to existing database design standards reuse of data components, data model review and procedures, change procedures for existing databases, and naming conventions. Document new standards by following the change control board approval process.

• Lead the monitoring of existing development, test, and production databases. Analyze and implement performance improvements, evaluate the risks and benefits, and recommend appropriate changes to the environment. Develop backup and recovery best practice guidelines for the team to follow and maintain to meet agency database Backup and Recovery SLAs for frequency, retention, and recovery windows. Communicate with customers, management, consultants, and staff to gather and disseminate complex information, and participate in agency-wide activities related to database technology and architectural guidance to maintain standards in all database environments.

• Lead the creation, modification, and implementation of database objects in development environments. Coordinate with Team for wEA69 in the creation, modification, and implementation of database objects in test and production environments. Assist in the design, maintenance, and inventory of existing database objects used in agency applications.

• Lead the implementation of database security controls as needed to support application security requirements. Monitor and implement database security controls for new and existing database environments. Design and document new database security controls implemented to improve security and to meet audit standards. Communicate with managers and technical staff on database security breach findings. Communicate regularly with technical, applications, and operational staff to ensure database integrity and security.

• Communicate with managers, technical staff, customers, consultants, and colleagues to share and disseminate complex information needed during planning, development, and build phases for project related database technology and architectural guidance to maintain standards in development, test, and production database environments. Assist the team lead and work lead in the creation of system architecture diagrams, and descriptions that represent current and proposed systems, including costs and benefit analysis reports. Lead, mentor, and train junior DBAs as well as teammates, by documenting processes, solutions, procedures to accomplish on call and support job functions by collaborating and sharing organizational knowledge.

Key Qualifications

• Experience administering databases in Oracle Cloud Infrastructure (OCI).

• Experience administering Oracle database(s) in Exadata/RAC environments.

• Experience planning, implementing, and maintaining Oracle and/or Microsoft SQL databases in production, test and/or development environment.

Required Education & Experience

Seven years of full-time experience in data administration, database administration, data modeling, repository administration, or management of data or repository related functions.

OR

A bachelor's degree with 12 semester hours in computer science from an accredited college or university, plus six years of full-time experience in database administration, data administration, data modeling, repository administration, or management of data or repository related functions.

OR

Completion of 30 semester hours (600 clock hours) in computer science from a licensed vocational, technical or business school or accredited college, plus six years of full-time experience in database administration, data administration, data modeling, repository administration, or management of data or repository related functions.

• Employees in this classification series may research, work on, or have access to critical infrastructure, including but not limited to a communication infrastructure system, cybersecurity system, electric grid, hazardous waste treatment system, or water treatment facility. See Tex. Business & Commerce Code Section 117.001(2). Accordingly, the ability to maintain the security or integrity of the infrastructure is a requirement to be hired for and to continue to be employed with TCEQ.

How To Apply

To be considered, please complete a State of 68tky xbRq7Wkgywk for Employment and apply online at •••••••• or in the CAPPS Recruit (TAM).

Applications must be fully completed with a job history, including job title, employment dates (mo./yr.), full-time or part-time and hours per week, employer name, supervisor's name and phone number, and detailed description of duties performed. Incomplete applications may lead to disqualification. Please be aware that resumes will not be accepted in place of a completed application.

We strongly encourage all candidates to apply in the CAPPS Online Application system.

TRANSCRIPT / COLLEGE HOURS or COURSE WORK

See instructions on how to attach documents. A copy of your official college transcript or evaluation of foreign credentials in CAPPS is required if needed to meet the qualifications listed above.

WORK SCHEDULE

Standard business hours are M-F, 8:00 a.m. - 5:00 p.m.

Individual and work group schedule determined by the TCEQ Information Resources Division.

Benefits

• Optional 401(k) and 457 plans

• Insurance: Health, Vision, Dental, and optional FSA

• Paid day(s) off from work on national holidays and holidays that the state observes

• Professional development opportunities

• Longevity pay based on your number of years working for the state

• Wellness Program and Activities

• Onsite Nurse Practitioner in HQ

• Work-Life Balance

CONDITION OF EMPLOYMENT

TCEQ will conduct a criminal history records search, driving history (if required for the job) on candidates offered employment.

In compliance with ADA, if you need accommodation during the employment process, please contact HRSS for assistance at (••••••••

MILITARY OCCUPATIONAL SPECIALTY (MOS) CODES

Military Occupational Specialty (MOS) codes can be found at: •••••••• Please click the hyperlink under `Occupational Category' for the respective Class Title.

wnTCd fmfHNSUb8Z hg u5SdnZVnMvXMn AQMPztq is an Equal Opportunity Employer.