Please paste the following URL into a browser to view the entire job posting on the CAPPS Careers page.https://erphcmprd.cpa.texas.gov/psp/candidateportal/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?Page=HRS_APP_JBPST_FLandAction=UandFOCUS=ApplicantandSiteId=1andJobOpeningId=107522andPostingSeq=1Job DescriptionAre 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 TEAMAs 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 DOINGPerform 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 Texas 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 QUALIFICATIONSExpe ience 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 and EXPERIENCESeven years of full-time experience in data administration, database administration, data modeling, repository administration, or management of data or repository related functions.ORA 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. ORCompletion 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 and 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 APPLYTo be considered, please complete a State of Texas Application for Employment and apply online at www.workintexas.com 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 dut