> Markdown version of [/jobs/ext/2524038-sql-developer-production-support-specialist-mid-senior-level](https://www.wearedevelopers.com/jobs/ext/2524038-sql-developer-production-support-specialist-mid-senior-level). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # SQL Developer & Production Support Specialist (Mid/Senior Level) - **Company:** Tria Federal - **Location:** Arlington, VA, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Agile Methodology, Data Analysis, JIRA, Bash Shell, Batch Processing, Business Software, Cloud Database, Information Systems, Crystal Reports (Reporting Software), Data Validation, Extract Transform Load (ETL), Data Transformation, Data Systems, Relational Databases, Database Development, Document-Oriented Databases, Job Scheduling, Python (Programming Language), PostgreSQL, SQL Azure, MySQL, Operational Databases, Scrum Methodology, Power BI, Standard Sql, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, Tableau (Software), Talend, Scripting, Freeform SQL, Informatica Powercenter, Git, Amazon Relational Database Service, Information Technology, Software Version Control, Data Pipelines, Servicenow - **Published:** August 7, 2026 - **Apply:** https://www.clearancejobs.com/jobs/9081950/sql-developer-production-support-specialist-midsenior-level ## About the Role We are seeking a Mid to Senior-Level SQL Developer with strong Production Support and analytical capabilities to support business applications built on MySQL and PostgreSQL. This role bridges business requirements and technical execution - translating business needs into efficient SQL code, reports, and data solutions, while serving as a key escalation point for resolving complex production issues. The ideal candidate combines advanced development skills with strong analytical thinking, works independently, and is comfortable engaging directly with business stakeholders and leading problem resolution efforts., * Bachelor's degree in Computer Science, Information Systems, Business Analytics, or related field (or equivalent experience) * 5+ years of experience as a SQL Developer, Data Analyst, or Production Support Analyst * Advanced, hands-on experience writing complex SQL in MySQL and PostgreSQL * Proven experience gathering and translating business requirements into technical/data solutions with minimal oversight * Strong analytical and problem-solving skills with a track record of resolving complex data/production issues * Demonstrated experience owning production support and incident/root cause analysis end-to-end * Familiarity with job scheduling tools and monitoring production batch jobs * Excellent communication skills, with experience presenting to both technical teams and business stakeholders * Experience working within Agile/Scrum development environments * Ability to mentor junior team members and lead technical initiatives Preferred Qualifications * Experience with reporting/BI tools (Power BI, Tableau, SSRS, Crystal Reports) * Scripting experience (Python, Shell/Bash) for automation and data validation * Familiarity with ETL tools (Informatica, Talend, SSIS, or similar) * Experience with ticketing/ITSM tools (ServiceNow, Jira, Remedy) * Knowledge of data modeling concepts and relational database design * Exposure to cloud database platforms (AWS RDS/Aurora, Azure Database, GCP Cloud SQL) * Experience with version control systems (Git) * Prior experience leading a support team or serving as an on-call lead Key Skills * Advanced SQL Development (MySQL & PostgreSQL) * Business Requirements Analysis * Production Support Leadership & Root Cause Analysis * Data Analysis & Data Quality * ETL / Reporting * Agile/Scrum Collaboration * Mentorship & Stakeholder Communication ## Description Business Requirements & Analysis * Lead discussions with business stakeholders and Product Owners to gather, clarify, and document data and reporting requirements * Translate ambiguous or complex business requirements into clear technical specifications, queries, and data solutions * Perform in-depth data analysis to support business decision-making, identify trends, and validate data accuracy * Actively participate in Agile sprint ceremonies (planning, standups, backlog grooming, retrospectives) as the SQL/data subject matter expert * Partner with business analysts to validate delivered solutions meet requirements (UAT support) * Proactively identify gaps or risks in requirements before development begins SQL Development * Design, write, test, and optimize complex SQL queries, stored procedures, functions, views, and triggers in MySQL and PostgreSQL * Develop and maintain ETL/data transformation scripts to support reporting and integration needs * Build and maintain reports, dashboards, and ad-hoc data extracts for business users * Establish and enforce coding standards, version control practices, and documentation requirements * Lead peer code reviews and mentor junior developers/analysts on SQL best practices * Identify opportunities to optimize existing queries and processes for performance and maintainability Production Support * Serve as a senior escalation point for production database and application issues * Monitor scheduled jobs, batch processes, and data pipelines; lead troubleshooting of failures and reruns * Investigate and resolve complex data discrepancies, failed transactions, and application-reported issues * Drive root cause analysis on recurring issues and implement permanent, long-term fixes * Own incident and problem management documentation and follow-up for assigned issues * Participate in on-call rotation, providing leadership during critical/high-severity incidents * Coordinate across DBAs, developers, and infrastructure teams to resolve complex cross-functional issues * Contribute to building and improving support processes, runbooks, and monitoring practices Analytical & Data Quality * Analyze large, complex datasets to identify data quality issues, anomalies, and inconsistencies * Design and implement validation frameworks/scripts to proactively catch data issues before production impact * Lead data reconciliation efforts between systems/applications * Provide analytical support for audits, compliance requests, and management reporting * Present findings and recommendations to technical and business stakeholders ## Related Videos - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Improving quality with Agentic AI with Rovo Dev and Xray](https://www.wearedevelopers.com/videos/2005-improving-quality-with-agentic-ai-with-rovo-dev-and-xray) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [Coding for Good: Achieving social change with an app](https://www.wearedevelopers.com/videos/1645-coding-for-good-achieving-social-change-with-an-app) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london)