Sr Database Administrator

Hi,

Greetings from DIA SOFTWARE SOLUTIONS LLC!

We reaching out about an exciting Direct client opportunity with one of our clients. Please review the requirements and let me know if you are interested in this position?

Direct client Req:: Need Sr Database Administrator ,Remote, TX

PLEASE SEND THE RESUMES TO SKUMAR AT DIASOFTWARESOLUTIONS DOT COM !

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.

SKILLS MATRIX

DIA SOFTWARE SOLUTIONS LLC.

Austin, TX 78727| Direct:

DIA SOFTWARE SOLUTIONS is an Affirmative Action/Equal Opportunity Employer that supports workplace diversity. All employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, marital or family status, sexual orientation, gender identity, or genetic information. All Dia soft staff must be able to demonstrate the legal right to work in the United States. DIA SOFTWARE SOLUTIONS is an E-Verify employer