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

Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Actual
Years
Experience

Years
Experience
Needed

Required/
Preferred

Skills/Experience

7

Required

Experience with Microsoft technologies such as Visual Studio, SQL Server, and ASP.NET MVC

7

Required

Meticulous attention to detail with an ability to produc e high-quality work in a dynamic environment

7

Required

Highly organized and able to manage multiple tasks at once and meet deadlines

7

Required

Extensive skill in effective verbal and written commun ications with stakeholders

7

Required

Ability to troubleshoot and resolve complex technical i ssues

6

Required

Understanding of Azure networking concepts and infra structure maintenance for production and non-producti on environments

6

Required

Ability to create and configure new Azure environmen ts using Azure templates

6

Required

At least six [6] years of hands-on experience in Azure architecture and related technologies

6

Required

At least six [6] years of experience in Azure DevOps, i ncluding writing CI/CD pipelines

6

Required

At six years [6] years of experience in software develo pment using C#

6

Required

At least Six [6] years of experience in .NET Core development, working in a team environment

6

Required

Proven technical leadership skills and ability to effectively communicate technical concepts to nontechnical stakeholders

6

Required

Ability to analyze customer service requirements and d esign service solutions to meet those objectives

4

Required

Stand-up and manage services such as VMs, application containers, appliances, VPNs, Gateways

4

Required

Architect software solution for EDI engine, Creating API services, Creating database and communication api service between Cloud Applications and EDI services

4

Optional

Familiarity with mainframe migration strategies using SSIS as data transformation tool

4

Optional

Knowledge of mainframe technologies and systems is a plus

Optional

Graduation from an accredited four-year college or uni versity with a degree in computer science or a related f ield

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