Job Title : Database Administrator

Location: Austin, TX

Duration: 4 months

Position will be : Telework

Exp: 15+

Must Have State Govt Exp and Locals are highly Applicable

Job Description:

The Worker will apply their expert knowledge of Risk Database Management Systems (RDBMS), SQL Server, Snowflake, Informatica Intelligent Data Management Cloud (IDMC) administrations, Azure architecture and Microsoft technologies at Railroad Commission of Texas to support the needs of the Mainframe Transformation project teams. The DBA will perform advanced analysis and design work involving all technical aspects of supporting, improving, and enhancing RRC’s mainframe modernization project.

This position requires strong experience in DBA, including the design and implementation of scalable solutions, as well as proficiency in Microsoft technologies, Risk Database Management Systems (RDBMS), MS SQL Server, IDMC Administrator, Power BI Administrator, Snowflake Administrator, and Azure DevOps. The ideal candidate will also be skilled in developing custom integrations and managing infrastructure within Azure environments.

We are seeking a proactive team member who will be responsible for enhancing assigned applications, addressing production issues, and ensuring optimal performance of Azure solutions. Work assignments will follow a defined software development life cycle (SDLC) process, utilizing Agile methodologies for effective project delivery. The DBA will collaborate with multiple agency stakeholders to ensure that solutions meet business requirements and are delivered error-free, supporting RRC’s regulatory obligations for the Oil and Gas and Energy Industry of Texas. Prior RRC experience and RRC Infrastructure hands on experience will be an added advantage for this role.

ESSENTIAL FUNCTIONS:

• Architectural Design: Develop and implement scalable Azure solutions tailored to the needs of the Mainframe Transformation project.
• Technical Expertise: Leverage strong knowledge of Microsoft technologies, RDBMS, IDMC Admin, PowerBI Admin, Snowflake Admin, MS SQL Server, Azure DevOps, and SQL Server Integration Services (SSIS).
• Collaboration: Work closely with cross-functional teams to ensure seamless integration of Azure solutions with existing systems and applications.
• DevOps Practices: Design, implement, and maintain CI/CD pipelines using Azure DevOps to automate deployments and streamline development workflows.
• Custom Integrations: Design and manage custom integrations within Azure environments to enhance application functionality (MuleSoft, Go-Anywhere, SFTP etc.)
• Performance Optimization: Enhance assigned applications, address production issues, and ensure optimal performance of Azure solutions.
• ETL Administration: Utilize IDMC ETL Admin to facilitate user access and support IDMC Infrastructure, AD Groups, standardize Users and Roles, Migrations of packages, Creation of connections, Trouble shoot issues
• Infrastructure Management: Maintain Azure infrastructure for both production and nonproduction environments, ensuring optimal performance and availability.
• Risk Management: Construct risk assessments and remediation plans for complex service proposals and advanced technologies.
• Environment Setup: Utilize Azure templates to create and configure new environments efficiently.
• Network Understanding: Understand and manage Azure networking concepts to ensure secure and reliable connectivity between resources.
• Documentation: Prepare and maintain comprehensive technical documentation, including architecture diagrams, process flows, and design specifications.
• Subject Matter Expert: Act as a trusted advisor for technical services, providing insights and guidance to both internal and external stakeholders.