Supports Microsoft SQL Server databases and application integrations. Responsibilities include writing and optimizing T-SQL queries, maintaining SSIS packages, troubleshooting database and integration failures, monitoring scheduled jobs, resolving connectivity issues, assisting with stored procedures and database objects, validating data, documenting processes, recommending improvements, and transferring knowledge to technical and business teams.
Position Overview
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.
Similar Jobs
Machine Learning • Payments • Security • Software • Financial Services
Leads strategy, roadmap, prioritization, development, and financial performance for business technology products supporting Vendor Finance. Coordinates technology, business, risk, compliance, and vendor stakeholders; manages product initiatives, timelines, budgets, customer experience, and regulatory requirements. Evaluates product opportunities, drives innovation using emerging technologies including AI, and leads product development teams, including staffing, performance management, and talent development.
Top Skills:
Agile MethodologyArtificial IntelligenceSoftware Development Life Cycle
Machine Learning • Payments • Security • Software • Financial Services
Leads enterprise software architecture and development across multiple product lines, establishes design standards, reviews solutions, troubleshoots complex issues, and provides technical guidance across teams. Supports modernization of on-premise systems and migration to Azure cloud. Partners with engineering and executive leaders on technology strategy, security adaptability, automation, and solution design using agile methods.
Top Skills:
AgileAzureC#DelphiDevOpsDistributed SystemsJavaJavaScriptTypescript
Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
Supports astrodynamics, orbit, trajectory, and spacecraft maneuver analyses across mission lifecycles. Responsibilities include assessing requirements, optimizing trajectories, evaluating sensors and constellation designs, supporting system analysis, and developing mission operations tools. The role requires modeling and simulation experience, orbital analysis software proficiency, scientific computing skills, and eligibility for a U.S. security clearance. It is 100% onsite and supports national security space missions.
Top Skills:
Cots Mission Planning ToolsGmatMatlabModeling And SimulationOrbital MechanicsPythonStk
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
