MetroSys is seeking a Mid-Level SQL Database & Integration Developer to provide immediate support for a client in Irvine, CA. This is a hands-on role supporting an existing Microsoft SQL Server environment and the applications and integrations that depend on it.
The consultant will be responsible for writing and troubleshooting SQL queries, supporting data integrations between business applications, maintaining existing SSIS packages, and resolving database-related application issues.
This engagement is expected to require approximately 30–40 hours per week and is initially a temporary/contract position with the potential to transition into a permanent role.
The ideal candidate is located in or near Irvine, CA and can work closely with the client's technical and business teams as needed.
Key Responsibilities- Write, execute, troubleshoot, and optimize SQL queries within Microsoft SQL Server environments.
- Investigate and resolve database-related issues impacting business applications.
- Troubleshoot connections and data flows between SQL databases and existing applications.
- Support integrations to and from the client's existing application environment.
- Create, modify, troubleshoot, and maintain SQL Server Integration Services (SSIS) packages.
- Monitor and troubleshoot scheduled data-processing and integration jobs.
- Investigate failed queries, jobs, integrations, and data-transfer processes and determine root causes.
- Assist with stored procedures, views, functions, scripts, and other SQL database objects.
- Work with application owners and technical teams to identify whether issues originate within the database, integration layer, or application.
- Assist with data validation and troubleshooting to maintain accurate and reliable information across integrated systems.
- Review the existing SQL and integration environment and recommend improvements where appropriate.
- Document queries, integrations, SSIS packages, configurations, dependencies, and troubleshooting procedures.
- Provide knowledge transfer and help reduce reliance on undocumented or single-resource database processes.
- 3+ years of hands-on experience with Microsoft SQL Server.
- Strong SQL/T-SQL querying and troubleshooting skills.
- Hands-on experience creating and maintaining SSIS packages.
- Experience supporting application-to-database and database-to-application integrations.
- Experience troubleshooting failed queries, jobs, data feeds, and application/database connectivity.
- Working knowledge of stored procedures, views, functions, joins, and database objects.
- Ability to troubleshoot existing environments and understand applications and integrations that may have limited documentation.
- Strong analytical and problem-solving skills.
- Ability to work independently and communicate effectively with application owners and business users.
- Experience supporting SQL Server environments in a production business environment.
- Experience with SQL Server Agent jobs and scheduled processes.
- Experience with ETL and data integration workflows.
- Familiarity with APIs, flat-file integrations, SFTP, or other application integration methods.
- Basic SQL Server performance troubleshooting and query optimization experience.
- Experience taking ownership of an environment previously managed by another SQL resource.
- Local to Irvine or the surrounding Orange County area.
Skills Required
- 3+ years of hands-on experience with Microsoft SQL Server
- Strong SQL/T-SQL querying and troubleshooting skills
- Hands-on experience creating and maintaining SSIS packages
- Experience supporting application-to-database and database-to-application integrations
- Experience troubleshooting failed queries, jobs, data feeds, and application/database connectivity
- Working knowledge of stored procedures, views, functions, joins, and database objects
- Ability to troubleshoot existing environments and understand applications and integrations with limited documentation
- Strong analytical and problem-solving skills
- Ability to work independently and communicate effectively with application owners and business users
- Experience supporting SQL Server environments in a production business environment
- Experience with SQL Server Agent jobs and scheduled processes
- Experience with ETL and data integration workflows
- Familiarity with APIs, flat-file integrations, SFTP, or other application integration methods
- Basic SQL Server performance troubleshooting and query optimization experience
- Experience taking ownership of an environment previously managed by another SQL resource
- Local to Irvine or the surrounding Orange County area
What We Do
MetroSys is a I.T. Professional Services company based in sunny San Diego, CA. Established in 2006, MetroSys has technical talent supporting the Americas. Our Mission Statement; To simplify our customers’ business solutions while having fun with what we do. Our creative geniuses have been pioneering data solutions for our valued customers and partners in the following areas: Data Mobility: Enterprise Storage, Cloud Migrations, Systems Integration & Installation: Storage, Networking, Virtualization, Database, Messaging Flexible Workforce: Recruiting, Staffing, Direct Placement Assessment Services: Storage, Networking, Performance, Periodic, Get Healthy ingenuity. Agility. Speed. These are key ingredients to our success. Navigating the world of I.T. Professional Services can pose many challenges. We help customers, channel partners, resellers & manufacturers deliver! Our team of highly experienced professionals can help bridge any gap for your I.T. requirements. Whether assistance with pre-sales or post-sales services, recruiting, or assisting with the launch of emerging technologies, We CAN Help! Great people. Great Company. MetroSys has carefully crafted its team of highly skilled talent by not only hiring industry experts, but by selecting people that share our view on company culture. Our core values include teamwork, integrity, accountability, & embracing diversity. Our customer first approach builds strong relationships as a trusted advisor and technology partner. Our team integrates with your business and maximizes efficiency. Simply put, we make it easy.
