RRC - Mainframe Transformation Database Administrator IV - Austin, United States - RAILROAD COMMISSION OF TEXAS

RAILROAD COMMISSION OF TEXAS Austin, United States

1 week ago

Description

RRC - Mainframe Transformation Database Administrator IV

Organization

:RAILROAD COMMISSION OF TEXAS

Primary Location

:Texas-Austin

Work Locations

:RRC Headquarters1701 N Congress AvenueAustin78701

Job

:Computer and Mathematical

Employee Status

:Regular

Schedule

:Full-timeStandard Hours Per Week:40.00

Travel

:Yes, 5 % of the TimeState Job Code:0214Salary Admin Plan:BGrade:27

Salary (Pay Basis)

:6, ,820.00(Monthly)

Number of Openings

Overtime Status

:Exempt

Job Posting

:Jun 7, 2024, 1:10:37 PM Closing Date :Jun 21, 2024, 11:59:00 PM Description

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 .

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

Flexible work schedules

Retirement pension with a 150% agency match – you can watch this YouTube video that describes this amazing benefit

401(k), 457(b) and Roth

Health premiums 100% paid for full-time employees

Tuition Reimbursement

Wellness and Exercise Leave

Career development programs/opportunities for advancement

For a complete list of our total compensation package please visit our website at . To view benefits available to all State of Texas employees visit the Employee Retirement Systems website at

General Description

The Railroad Commission of Texas (RRC) seeks a Microsoft (MS) SQL/SQL Server Database Administrator (DBA) to provide support for critical agency applications on the Commission's open systems environments. This position is approved for 100% Telework from a residence located within the state of Texas and following the RRC Telework Policy. This role provides technical leadership within the Mainframe Transformation Team responsible for the implementation, configuration, maintenance, and performance of critical MS SQL Server systems that have complex data flow between multiple platforms using multiple tools. Included are a MS-based data warehouse, MS SQL-based Azure applications, and Mulesoft services. Also included will be specific assignments in MS SQL Server databases products (SSIS, SSRS), Snowflake, Power BI (Data Analysis Expressions – DAX), and other Microsoft products. Performs complex data analysis and data research work. May plan, assign, and/or supervise the work of others. Work involves planning, and analyzing user requirements, procedures, and problems to automate processing or to improve existing systems. Works under minimal direction with considerable latitude for the use of initiative and independent judgment. This is a "hands-on" position requiring solid technical skills, as well as excellent interpersonal and communication skills.

Essential Job Duties

Manage SQL Server databases (v19.1 or higher) that includes following:

·Database Management including backups, recovery, maintenance; export, import and mass data loads.

·Analyzes and generation of all tables and index statistics.

·Monitoring and resolving all data lock issues

·Check all statistics related to memory, locks, I/O, database response time, wait events, tops sessions and background processes.

·On-Line Transaction Processing to capture, validate and store large amounts of transactions.

·Create indexes to achieve critical dataset response time for time sensitive reports.

Configure and maintain database servers and processes, Monitor system's health and performance.

Ensure high levels of performance, availability, sustainability and security.

Assist developers with query tuning and schema refinement.

Perform scheduled maintenance and support release deployment activities after hours/weekends.

Ability to build and optimize data sets, data pipelines, and architectures.

Ensure data accuracy, promote data quality and transform data into more useful formats.

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 SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner.

Responsible for T-SQL query tuning, database migrations and server upgrades

Responsible for ETL of large data into SQL Server Author and modify SQL Server Reporting Services report.

T-SQL Programming Perform additional tasks as assigned.

Oversees the preparations of reports that include result analysis, recommendations, and instruction for proposed implementations; formulates logical descriptions of problems; and devises and implements optimum solutions.

Analyzes business area rules and/or data sources for the purpose of producing reporting guidance on solutions for agency stakeholders. Completes internal ITS reporting requests using software development lifecycle methods and approved reporting tools.

Collaborate to analyze data for projects that cross functional agency systems and other state entities that require coordinating, planning, and scheduling during development and implementation and post implementation stages.

Preparation of charts, diagrams, and tables that depict the present and proposed systems or results as identified in the requirements.

Identifies process improvements - Implementation of new or enhanced team processes or procedures relating to public information requests, reporting systems and development of reports.

Creates and/or maintains guidance documentation for enterprise reporting application.

Leads in the identification and resolution of system issues resulting from malfunctioning reports or othererrors.

Analyzes and defines agency disaster recovery responsibilities andprocedures.

Develops, analyzes, and revises system design procedures, program code, test procedures, and quality standards.

Formulates logical descriptions of problems and devises optimum solutions.

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.

Good time management skills.

Performs other duties as assigned and required to maintain unit operations.

Knowledge, Skills, and Abilities

Knowledge of Oracle 19 DB, Systems (For example Weblogic, Oracle Forms, OLAP, SOA).

Knowledge of, and professional experience and proficiency with Oracle Business Intelligence.

Knowledge of, and professional experience and proficiency with Microsoft Power BI.

Knowledge, proven skills and ability in designing and developing BI Dashboards, BI reports.

Knowledge, proven skills and ability in T-SQL, SQL and/or PL/SQL.

Knowledge of state of Texas Public Information Request requirements.

Knowledge of current industry standards associated with configuration management technologies and development methodologies.

Experience overseeing projects and development of high-volume scalable environments.

Experience overseeing standardized quality assurance procedures.

Experience with upgrade/migration of older environments to current platforms.

Experience working on Business Intelligence teams in high-volume production environments.

Skills in complex problem solving and critical thinking.

Knowledge of statistics and analyzing data sets; of running queries, report writing, and presenting findings; of data models, database design development, data mining, and segmentation techniques; and of record keeping, including security procedures for handling, protecting, and distributing confidential data.

Skill in the use of a computer and applicable software, in analyzing problems and devising effective solutions, in conducting data searches, in evaluating and translating large amounts of data, and in critical thinking.

Ability to compile, review, and analyze data; to prepare reports; to maintain accuracy and attention to detail; to communicate effectively; and to provide guidance to others.

For Military Crosswalk information please visit:

Qualifications

Minimum Qualifications

Four (4) years of experience performing MS SQL Server Database Administrator functions.

Four (4) years of experience with Complex SQL queries

Four (4) years of experience with the Software Development Lifecycle and Best Practices.

Four (4) years of experience with SQL based reportingtools, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)

Two (2) years of experience in a data related responsibilities including analysis and tuning of tables.

Two (2) years of experience with scripting languages (VBA. Shell Script, RESTful API development and integration, JavaScript, Perl, Ruby, PowerShell, Python, PHP).

Experience with large data sets and Data Visualizations tools like Power BI, Tableau, Qlik, or similar reporting tools

Knowledge of Agile methodologies for software development and management.

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

Experience and education may be substituted for one another.

Experience may have occurred concurrently.

Experience and education may substitute for each other on a year for year basis.

Valid Driver's License and good driving record.

Preferred Qualifications

Eight (8) years of experience performing SQL Server Database Administrator functions.

Eight (8) years of experience with Complex SQL queries.

Eight (8) years of experience with the Software Development Lifecycle and Best Practices.

Eight (8) years of experience in database design, Physical and Logical Database modelling, ER Diagram, Slowly Changing Dimension, snowflakes & star schemas, and Facts & Dimensions tables

Four (4) years of experience in systems analysis and design work W/Development and integration of SQL Database services in an enterprise environment

Four (4) years of experience with hands on experience in data visualization tools including Microsoft Power BI, Tableau, Qlik, or similar reporting tools.

Four (4) years of experience PL/SQL procedures development, compilation and debugging SQL Server, T-SQL, Stored Procedures.

Four (4) years of experience PowerShell scripting.

Two (2) years of experience performing Oracle Database Administrator functions.

Two (2) years of experience with Data Warehouse implementations.

Two (2) years of experience with ETL Informatica Power Exchange Change Data Capture (CDC).

One (1) year of experience working with the Snowflake database platform.

Experience performing Oracle Database 19 Administrator functions.

Experience with Data Warehouse implementations, migrate data across heterogenous databases.

Experience with Informatica Power Exchange Change Data Capture (CDC).

Experience working with the Snowflake database platform.

Experience in working in a clustered Windows environment.

MCTS, MCITP and/or MVP Certifications a plus

Work Hours and Telework: Standard office hours for Commission employees are 8:00 a.m. to 5:00 p.m., Monday through Friday. Our agency offers alternate schedules for employees, as long as it does not adversely affect operations and service levels, and standard hours of operation are maintained. The Commission may also offer telework based on the agency's approved Telework Plan. Alternate work schedules and telework may be discussed with the hiring manager during the interview process.

APPLICATIONS SUBMITTED THROUGH WORK IN TEXAS: Work In Texas (WIT) applicants must complete the CAPPS Recruit Prescreening Questionnaire to be considered for the posting. To complete the Prescreening Questionnaire, go to CAPPS Recruit to register or login:

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.

THE RAILROAD COMMISSION OF TEXAS ONLY ACCEPTS ONLINE APPLICATIONS FOR THIS POSTING.

Due to the high volume of applications we do not accept telephone calls. Only candidates selected for interview will be contacted. Notifications to applicants are sent electronically to the email address you provide.

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.

Database Administrator

2 weeks ago

COGENT DATA SOLUTIONS LLC Austin, United States

Hello Professionals, · Cogent Data Solutions LLC is hiring for a Database Administrator position with one of our direct clients. · Check out the details listed below. I look forward to hearing back from you. Have a great day · Client Name: Texas Health and Human Services Commissi ...
Database Administrator

1 day ago

Twin Oak Advisors Austin, United States

ABOUT TWIN OAK ADVISORS: · At Twin Oak Advisors, we offer holistic financial support that addresses every part of an individual's financial journey—both professionally and personally. We pride ourselves on our innovative approach and commitment to excellence. As we continue to gr ...
Database Administrator

4 weeks ago

IDR Healthcare Austin, United States

IDR is seeking a Database Administrator to join one of our top clients in the public sector industry. If you are looking for an opportunity to join a large organization and work within an ever-growing team-oriented culture, please apply today · Position Overview/Responsibilities ...
Database Administrator

1 week ago

Infojini Austin, United States

Enters codes to create production data base. Selects and enters codes of utility program to monitor database performance, such as distribution of records and amount of available memory. Directs programmers and analysts to make changes to data base management system. Reviews and c ...
Database Administrator

1 week ago

Zilliant Austin, United States

Zilliant powers intelligent B2B commerce with our industry-leading price optimization and sales guidance software. Our data science, cloud-native software, and passion for customer success deliver the highest ROI, fastest time to value, and highest customer satisfaction.? If your ...
Database Administrator

1 week ago

Esolvit Austin, United States

Title: Database Administrator · Location: Austin, TX · Duration: Long Term · You can ApplyHere or click on the link to the Arytic AI Hiring Platform · Job DescriptionThe successful candidate will work with Full-stack Java applications on Client s cloud platform (Azure/AWS) with ...
Vertica Database Administrator

3 weeks ago

Adbakx Austin, United States

Position : Vertica Database Administrator · Location :Austin, TX~Sunnyvale, CA-Onsite · Duration : Long Term · Description : · Minimum 10+ years experience in Vertica and managing several multi-terabyte Vertica databases both on-prem and cloud. · Expert Knowledge of Vertica Archi ...
Database Administrator 3

2 weeks ago

My3Tech Austin, United States

Hello, · Hope you are doing good. · Position: Database Administrator 3 · Location: US Remote · Duration: Long Term · Client: State of Texas · Job ID: HHSC · Job Description: · DESCRIPTION OF SERVICES · Texas Health and Human Services Commission requires the services of 1 Databas ...
Database Administrator II

1 day ago

Texas Department of Aging & Disability Services Austin, United States

Job Description: · The Texas Health and Human Services Commission (HHSC) is looking for highly qualified candidates to fill the role of Database Administrator II in the Access and Eligibility Services (AES), specifically within the 2-1-1 Texas Information and Referral Network (TI ...
Database Administrator III

1 week ago

Texas Department of Aging & Disability Services Austin, United States

Job Description: · Designs, develops, enhances, maintains, and supports the databases underlying IT systems utilized by HHSC program areas. Maintains and monitors integrated database systems. Develops and maintains complex models and logical database designs. Provides expertise i ...
Database Administrator IV

2 days ago

Texas Department of Aging & Disability Services Austin, United States

Job Description: · The Database Administrator IV performs advanced (senior level) database administration and application development functions for the Data Management team within Information and Data Management, Office of Data, Analytics and Performance (DAP). The DBA IV will be ...
Senior Database Administrator

2 weeks ago

Auctane - Stamps Austin, United States

As a Senior Database Administrator (DBA) and member of the Engineering Operations team, this individual is responsible for the research and planning, development, implementation, utilization, monitoring, and administration of databases, primarily MS Database Administrator, Databa ...
Senior Database Administrator

5 days ago

PEOPLECORP AMERICA INC Austin, United States

Senior Database Administrator - 12+ Years Experience Required · Austin, TX, United States . PCTAX9120 · Database Administrator · Austin, TX · 6+ Months · Job Description · Our Direct Client is seeking an experienced, full-time, on-site, dedicated Candidate, with skills and expert ...
IT Database Administrator Senior

1 week ago

City of Austin Austin, United States

Police Headquarters Minimum Qualifications Education and/or Equivalent Experience: Graduation with a Bachelors degree from an accredited college or university with major course work in a field related to the job, plus four (4) years of experience in Database Administrator, Databa ...
Database Administrator 3

2 weeks ago

My3Tech Inc Austin, United States

Hello, · Hope you are doing good. · Position: Database Administrator 3 · Location: US Remote · Duration: Long Term · Client: State of Texas · Job ID: HHSC · Job Description: · DESCRIPTION OF SERVICES · Texas Health and Human Services Commission requires the services of ...
Database Administrator 3

1 week ago

Five Cubes, Inc. Austin, United States

Job Title: Database Administrator · Location: Austin, TX (Remote) · Duration: 6+ months · Direct Client · Out of State candidates will not be considered. · Job Description: · This Database Administrator (DBA) 3 contractor position is part of the Administrative Applications Data ...
Database Administrator

3 weeks ago

Saxon Global Austin, United States

Enters codes to create production data base. · • Selects and enters codes of utility program to monitor database performance, such as distribution of records and amount of available memory. · • Directs programmers and analysts to make changes to data base management system. · ...
Database Administrator 1

1 week ago

IDR Healthcare Austin, United States

IDR is seeking a Database Administrator to join one of our top clients for an Onsite Position in the Austin, TX area If you are looking for an opportunity to join a large organization and work within an ever-growing team-oriented culture, please apply today · Position Overview & ...
Senior Database Administrator

3 weeks ago

pulteGroup Austin, United States Full time

This position can be located in Englewood, Colorado or the state of Texas. · JOB SUMMARY · The Senior Database Administrator (DBA) works with the Agile teams on the design, installation, and maintenance of our database environments for on-premise as well as Cloud system configu ...
Database Administrator II

1 week ago

HEALTH AND HUMAN SERVICES COMMISSION Austin, United States

Job/Position DescriptionThe Texas Health and Human Services Commission (HHSC) seeks highly qualified candidates to fill the Database Administrator II position within the Access and Eligibility Services (AES), 2-1-1 Texas Information and Referral Network TIRN). AES is driven by it ...