Data Operations Engineer
We are looking for a highly analytical and detail-oriented Data Operations Engineer to join our growing technology team. In this role, you will be responsible for ensuring the reliability, accuracy, and availability of business-critical data across our applications.
What you will do:
- Develop, optimize, and maintain complex T-SQL queries, stored procedures, views, and functions.
- Troubleshoot SQL Server performance issues and optimize slow-running queries.
- Perform data validation, reconciliation, and integrity checks.
- Execute controlled production data fixes and corrections.
- Support database deployments and data migrations.
- Monitor daily production data loads and scheduled jobs.
- Investigate and resolve data discrepancies across systems.
- Perform root cause analysis for production data issues.
- Ensure business-critical data is accurate, complete, and available.
- Monitor operational dashboards and proactively identify anomalies.
- Validate data between source and target systems.
- Identify duplicate, inconsistent, or missing records.
- Implement data quality checks and exception reporting.
- Ensure compliance with internal data standards.
- Support production incidents related to SQL Server databases.
- Troubleshoot application data issues within defined SLAs.
- Coordinate with development teams to resolve defects.
- Maintain incident documentation and post-resolution reports.
- Automate repetitive SQL and operational tasks.
- Build scripts using SQL Server Agent, PowerShell, or Python where applicable.
- Improve operational efficiency by reducing manual intervention.
- Develop reusable scripts for health checks and monitoring.
Requirements
What we are looking for you:
- 1- 3 years of experience working with Microsoft SQL Server or as SQL Developer
- Strong knowledge of T-SQL
- Experience in SQL query optimization and performance tuning
- Excellent analytical and problem-solving abilities