Enterprise Software Integration and SQL Database

Integra Mission Critical; Dallas (TX); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Competitive pay

Comprehensive healthcare

Life and disability insurance

Flexible benefits options

Generous paid time off

Tuition assistance

Job summary

Integra Mission Critical is seeking an Enterprise Software Integration and SQL Database Specialist to design, build, test, monitor, and improve data integrations and database objects across heterogeneous systems. You will work hands-on to ensure secure, scalable data movement for critical operations and reports, while maintaining thorough documentation and governance.

Ideal candidates will have strong SQL skills, practical integration experience, and the ability to translate business needs into

Qualifications

• Bachelor's degree or equivalent experience in IT or related field.
• 5 years of experience in software integration or SQL database development.
• Strong SQL writing, debugging, and optimization skills.
• Experience with APIs, ETL concepts, and data mapping.
• Ability to document data flows, processes, and technical outcomes.

Responsibilities

• Develop, test, monitor, and maintain integrations, SQL queries, views, and stored procedures.
• Build and optimize data flows, data extracts, and database objects for reporting and automation.
• Assist with data mapping, transformation logic, and file-based transfers.
• Collaborate with IT, business users, and vendors to gather requirements and document processes.
• Monitor interfaces, job schedules, logs, and data quality to minimize disruptions.
• Troubleshoot data discrepancies and root causes across systems.

Skills

SQL

Data integration

Troubleshooting

Documentation

Communication

Education

Bachelor's degree in Information Technology/Computer Science or related field

Tools

Microsoft SQL Server

Azure

Power BI

ETL tools

Job description

Location DFW Department DEPADM

The Opportunity

The Enterprise Software Integration and SQL Database role supports Integras enterprise integration data connectivity application interoperability and SQL database needs across business critical systems legacy platforms modern applications reporting environments vendor solutions and cloud based tools This position is a hands on technical contributor responsible for helping design build document test monitor troubleshoot and improve integrations database objects data flows scheduled jobs interfaces and system to system connections that support reliable business processes and informed decision making The successful candidate will bring strong SQL skills practical integration experience sound documentation habits and the ability to translate business needs into dependable technical solutions This role will help establish the technical foundation for a growing digital solutions and enterprise integration function by supporting secure scalable well governed and supportable data movement across Integras technology landscape

What you will do

• Support the delivery of Integras digital solutions and enterprise integration roadmap by developing testing documenting monitoring and maintaining integrations SQL database solutions data flows and application connections
• Build maintain troubleshoot and optimize SQL queries views stored procedures scripts scheduled jobs data extracts and database objects used for integrations reporting reconciliation automation and operational support
• Assist with integration design data mapping source to target documentation transformation logic file based transfers API enabled connections data validation error handling testing deployment and production support
• Partner with IT team members business users vendors and implementation partners to gather requirements clarify data needs document process flows identify system dependencies and support integration related project activities
• Monitor recurring interfaces data loads scheduled jobs system alerts integration logs database performance indicators and data quality issues to support timely issue resolution and minimize business disruption
• Troubleshoot integration and database issues by analyzing data discrepancies job failures query results logs permissions dependencies upstream inputs downstream impacts and root cause conditions
• Maintain integration diagrams data dictionaries data flow maps technical documentation testing evidence support procedures change notes operational playbooks and ownership documentation for supported systems and data processes
• Apply approved standards for integration architecture APIs middleware data exchange workflow automation security access control naming conventions change management monitoring documentation and supportability
• Support system implementations upgrades migrations acquisitions consolidations automation initiatives reporting improvements and modernization efforts by assisting with data conversion interface testing validation cutover activities and post go live support
• Help reduce duplicate data entry manual workarounds inconsistent data flows unsupported point to point processes recurring support issues and technical debt through practical integration and database improvements
• Collaborate with cybersecurity infrastructure applications analytics finance operations HR commercial teams external partners and vendors to ensure integrations and databases are secure compliant governed auditable and aligned with enterprise technology standards
• Support evaluation and implementation activities for integration tools automation solutions Microsoft enterprise technologies cloud services reporting platforms and vendor supported technologies
• Provide clear status updates testing results issue summaries risks dependency notes support metrics and improvement recommendations to IT leadership and project stakeholders
• Promote disciplined technology delivery through strong documentation repeatable support practices accountability collaboration continuous improvement and a service oriented approach to business partnership

Required Qualifications

• Bachelors degree in Information Technology Computer Science Information Systems Data Analytics Engineering Business Systems Business Administration or a related field required
• equivalent experience may be considered
• 5 years of experience in software integration SQL database development application support data integration business systems reporting support enterprise applications or related IT roles
• Strong hands on experience writing troubleshooting validating and optimizing SQL queries and working with relational databases such as Microsoft SQL Server or similar database platforms
• Experience supporting integrations between enterprise applications databases SaaS platforms reporting environments vendor systems cloud based tools or legacy business applications
• Working knowledge of APIs middleware ETLELT concepts file based integrations data mapping data validation scheduled jobs error handling workflow automation and system to system data movement
• Ability to analyze data issues compare source and target data identify root causes test technical changes document outcomes and communicate findings clearly to technical and non technical stakeholders
• Experience creating and maintaining technical documentation process flows data dictionaries integration diagrams test plans support procedures change notes and operational support documentation
• Familiarity with enterprise business systems such as ERP CRM HRIS financial systems operational platforms data warehouses reporting tools business intelligence environments or cloud based business applications
• Understanding of data quality data governance cybersecurity access controls compliance audit expectations change control and technology lifecycle management in an enterprise environment
• Strong analytical troubleshooting problem solving communication organization documentation customer service and continuous improvement skills
• Ability to work effectively in a fast paced growing organization with evolving business needs legacy system complexity competing priorities and a mix of strategic projects and operational support responsibilities

Preferred Qualifications

• Experience with Microsoft enterprise technologies Azure Power Platform Power BI Microsoft Fabric API management tools iPaaS solutions middleware scripting languages cloud services MuleSoft Boomi Workato or similar tools preferred
• Experience supporting mergers acquisitions system consolidations platform modernization data migration or multi system transformation initiatives preferred

How we support you

We believe your best work happens when you feel supported professionally personally and financially Thats why we offer a range of benefits designed to help you thrive stay healthy and plan for the future

• Performance driven rewards
• Competitive pay with incentive opportunities that recognize your results and contributions
• Comprehensive healthcare
• Medical dental and vision coverage that supports you and your familys total well being
• Security and peace of mind
• Life and disability insurance programs that provide protection when it matters most
• Flexible benefits options
• A variety of voluntary benefits so you can personalize coverage to fit your needs
• Time to recharge
• Generous paid time off to relax travel and maintain a healthy work life balance
• Investing in your growth
• Education assistance and tuition support to help you build skills and advance your career
• Planning for the future
• Retirement and savings programs that help you achieve long term financial confidence

Come build with us At Integra were driven by a vision to transform the data center industry We specialize in delivering optimized turnkey solutions that bring together speed quality and reliability helping our clients build and operate the mission critical infrastructure that powers todays digital world Integra is a vertically integrated company owning and managing every phase of the process from site selection and design to manufacturing procurement commissioning and warranty This approach allows us to move faster solve challenges more efficiently and deliver exceptional outcomes for our partners What truly sets Integra apart is our people We are a team of problem solvers engineers builders and operators who thrive on tackling complex challenges and delivering results Our culture values collaboration accountability and continuous improvement because in a rapidly evolving digital landscape excellence and adaptability matter Joining Integra means being part of a company that is shaping the future of data center infrastructure If youre passionate about innovation impact and building systems the world depends on youll find the opportunity to grow and make a difference here

Equal Opportunity Statement

Integra provides equal employment opportunities for all people No employee or applicant for employment will be discriminated against because of race creed origin marital status sexual orientation age otherwise qualified disabled or veteran status or any other characteristic protected by law If you are a qualified applicant who requires reasonable accommodation to complete a job application pre employment testing a job interview or to otherwise participate in the hiring process please contact talentacquisitionintegracom