SQL Developer

Job Title: Operations & Maintenance (O&M) / Production Support Analyst – Data & SQL Job Summary: We are seeking a detail-oriented Operations & Maintenance (O&M) / Production Support Analyst with strong SQL and data-handling expertise. The role focuses on supporting production systems, ensuring data quality and integrity, managing XML ingestion pipelines, and resolving operational issues in a fast-paced, regulated environment. Key Responsibilities • Support day-to-day Operations & Maintenance (O&M) activities, including monitoring, troubleshooting, and resolving production issues • Perform SQL development and analysis, including complex queries, data validation, reconciliation, and performance tuning • Manage and support XML ingestion pipelines, including parsing, transformation, validation, and error handling • Investigate and remediate data quality and data integrity issues across multiple systems • Support and execute batch jobs and scheduled processes, including reruns, validations, and post-run analysis • Work with relational databases (Oracle, SQL Server, PostgreSQL, MySQL) to maintain schema integrity and optimize performance • Analyze application logs, database records, and system outputs to identify root causes of defects or failures • Partner with development teams to support releases, hotfixes, and production deployments • Document operational procedures, runbooks, SOPs, and knowledge transfer materials to reduce single points of failure • Participate in on-call or after-hours production support as required Required Skills & Qualifications • Strong hands-on experience with SQL, including: • Complex joins and subqueries • Performance tuning • Data reconciliation and root-cause analysis • Proven experience working with XML: • XML parsing, validation, and transformation • Ingestion and processing of large XML datasets • Solid background in Operations & Maintenance (O&M) or production support environments • Experience with relational databases such as Oracle, SQL Server, PostgreSQL, and MySQL • Strong troubleshooting skills with a data-centric focus • Familiarity with batch processing frameworks and job schedulers • Experience supporting applications in lower and production environments • Scripting experience (Python, Shell, PowerShell, etc.) for automation and operational tasks • Familiarity with logging and monitoring tools (e.g., Splunk) • Understanding of data governance, auditability, and compliance requirements • Experience supporting government or regulated environments (preferred) • Prior experience documenting SOPs and training O&M staff Soft Skills & Attributes • Strong attention to detail and commitment to data accuracy • Clear written and verbal communication skills • Ability to work independently in a fast-paced production environment • Proactive mindset focused on risk reduction and operational stability • Collaborative team player who can effectively partner with technical and non-technical stakeholders