RRC - Mainframe Transformation Database Administrator IV

RRC - Mainframe Transformation Database Administrator IV (00042641)

Organization

RAILROAD COMMISSION OF TEXAS

Primary Location

Texas-Austin

Work Locations

RRC Headquarters1701 N Congress AvenueAustin78701

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,681.16-8,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.