Data Operations Engineer
TekFriday Processing Solutions · Gandipet mandal, Telangana, India
Software Development · 201-500 employees
About the role
The Data Operations Engineer will maintain and optimize complex T-SQL queries while ensuring the reliability and integrity of business-critical data. They are responsible for monitoring production loads, troubleshooting performance issues, and automating operational tasks to improve efficiency.
What they look for
Requirements
Candidates must have 1-3 years of experience with Microsoft SQL Server and strong proficiency in T-SQL. The role requires excellent analytical and problem-solving skills, specifically regarding query optimization and performance tuning.
Full description
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
