Database Administrator IV

The Railroad Commission of Texas is a state agency with primary regulatory jurisdiction over the oil and natural gas industry; pipeline transport and pipeline safety; natural gas utilities; the LP-gas industry; and surface mining operations. You can find more details about us on the Railroad Commission of Texas website here: rrc.texas.gov/about-us To support our mission to serve Texas, we need great people to join our team. We provide a great working environment along with outstanding benefits, including: Generous paid time off, including vacation, sick time, and at least 12 paid holidays per year Telework options for eligible positions Retirement pension with a 150% agency match 401(k), 457(b) and Roth Health premiums 100% paid for full-time employees Tuition Reimbursement Wellness and Exercise Leave For a complete list of our total compensation package, please visit our website at rrc.texas.gov/about-us/jobs. To view benefits available to all State of Texas employees, visit the Employee Retirement Systems website at ers.texas.gov/benefits-at-a-glance. Job Description The Railroad Commission of Texas (RRC) seeks an Informatica Intelligence Data Management Cloud (IDMC) ETL Developer to provide support for the critical agency Data Warehouse (DW) that supports LoneStar Oil and Gas applications, and GIS Enterprise cloudification applications. Performs advanced (senior-level) Informatica Intelligence Data Management Cloud (IDMC) ETL work. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment. The IDMC developer is responsible for designing, developing, testing, and maintaining data integration solutions, data pipelines using IDMC API, and related ETL tools. The role involves working closely with data architects, analysts, and project teams to ensure accurate, secure, and high-performance data flows between cloud and on-premises systems. This role provides technical leadership for consuming data as well as configuration, maintenance, and performance of a critical data pipeline that has complex data flow between multiple platforms using multiple tools, technologies, and consuming tools that include MuleSoft, SQL Server Integration Service, MS SQL Server databases products (SSIS), Snowflake, and Power BI (Data Analysis Expressions DAX). The candidate is expected to perform complex ETL task flows development and research work. Candidates must also be capable of planning and assigning work to others and of reviewing and analyzing user requirements, procedures, and problems to automate processes or improve existing systems. The successful person will work with minimal direction, with considerable latitude for initiative and independent judgment. This is a hands-on position requiring solid technical skills as well as excellent interpersonal and communication skills. Coordinate and provide IDMC triage support to troubleshoot and resolve functional and performance issues encountered in production, development, and test environments Design, recommend, and implement procedures necessary for task flows and the pipeline. Develop standards, guidelines, policies, and procedures designed to ensure the integrity of the IDMC environment Run IDMC task flows in production environments to fix data issues Design & Development: Create and enhance ETL task flows, mappings, and transformations in IDMC, ensuring alignment with data architecture and business requirements. Be able to build the Fact & Dimensions table, populate data with Push Down Optimization Integration & Migration: Develop and maintain ETL-based applications for data migration, integration, and transformation between cloud platforms (AWS, Azure, Salesforce, Snowflake, OpenSystems) and on-premises databases Performance & Optimization: Optimize data workflows for speed, scalability, and resource efficiency; monitor and improve ETL performance Data Quality & Governance: Implement and manage data quality rules, governance policies, and metadata management in IDMC Testing & Support: Perform unit and integration testing; troubleshoot and resolve ETL-related issues; provide post-production support Documentation: Document workflows, mappings, and integration processes for clarity and auditability Collaboration: Work with project managers, technical leads, and business users to meet deadlines and deliver high-quality solutions Tooling: Proficient in IDMC, and related ETL tools; experience with Snowflake, Salesforce, SQL Server, Oracle, and Linux environments Partner with internal IT teams (Data Platform, Integration, Security, Infrastructure) Review IDMC Release Readiness, work on Release Types, Preparation, Deployment, and Upgrade tasks, and patches as required Align roadmap, platform improvements, and service standards with the IDMC Service Owner Participate in solution designs and architectural reviews Communicating operational impacts with technical and business stakeholders Performance tuning and ensuring high levels of availability, sustainability, and security. Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions Ability to build processes that support data transformation, workload management, data structures, dependency, and metadata Proactively monitor ETL task flows, troubleshoot failed jobs, and resolve issues in a timely manner Preparation of charts, diagrams, and tables that depict the present and proposed systems or results as identified in the requirements Creates and/or maintains guidance documentation Adheres to and recommends information systems security requirements and processes in use at the agency. Sense of ownership and pride in your performance and its impact on success Critical thinker and problem-solving skills Performs other duties as assigned and required to maintain unit operations. For Military Crosswalk information, please visit: Minimum Qualifications Bachelor's degree from an accredited four-year college or university with major coursework in data science, business analytics, computer science, computer information systems, management information systems, or a related field is generally preferred. Five plus (5+) years of experience in IDMC, Data warehousing concepts, and ETL methodologies Five plus (5+) years of experience in Cloud platforms (AWS, Azure) Five plus (5+) years of experience with ETL Informatica Power Exchange Change Data Capture (CDC) Five plus (5+) years of experience in database design, Physical and Logical Database modeling, ER Diagram, Slowly Changing Dimension, snowflakes & star schemas, and Facts & Dimensions tables Five plus (5+) years of experience with SQL optimization (Pushdown Optimization) and database query tuning Five plus (5+) years of experience in data integration using Informatica IDMC; 8+ years in ETL development, Python, REST APIs, CI/CD, monitoring tools Five plus (5+) years of experience with SQL and database design skills (Oracle, SQL Server, Snowflake, Salesforce) Five plus (5+) yearsof experience in Operational experience with Secure Agent or comparable runtime/application components Five plus (5+) years of experience in supporting data quality and governance tools Five plus (5+) years of experience in on-call support for critical ETL systems Experience and education may be substituted on a year-for-year basis Total years of experience may run concurrently Remarks There is one available position. Official transcripts, DD214 or DD1300, copies of license/certifications, or other minimum requirement validations will be requested at the time of the job offer. Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa. Criminal background checks will be conducted on all final candidates. An applicant who has been convicted of a criminal offense relevant to the position may be disqualified from employment. Standard office hours for Commission employees are 8:00 a.m. to 5:00 p.m., Monday through Friday. Our agency offers alternative schedules for employees, provided they do not adversely affect operations or service levels and standard hours of operation are maintained. The Commission may also offer telework in accordance with the agency's approved Telework Plan. Alternate work schedules may be discussed with the hiring manager during the interview process. The Railroad Commission of Texas is an Equal Opportunity Employer and does not discriminate on the basis of race, color, national origin, sex, religion, age or disability in employment or in the provision of services. The Railroad Commission of Texas is a tobacco-free workplace. #J-18808-Ljbffr