Operations Engineer

Job Summary

Project Role: Operations Engineer

Project Role Description: Support the operations and/or manage delivery for production systems and services based on operational requirements and service agreement.

Must have skills: Microsoft SQL Server Integration Services (SSIS)

Good to have skills: NA

Minimum Experience: 3 Year(s) Of Experience Is Required

Educational Qualification: 15 years full time education

About the Role

Act as the ongoing interface between the client and the system or application. Responsible for end-to-end administration and development support of Microsoft SQL Server (MS-SQL) database environments, SQL Server Integration Services (SSIS) ETL pipelines, and SQL Server Reporting Services (SSRS) reporting platforms across hybrid on-premises and cloud infrastructure. Applies T-SQL and PL/SQL skills to support database development.

Requirements

Must-Have Skills

• Microsoft SQL Server (2012/2016/2019/2022)
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• T-SQL (Transact-SQL)
• PL/SQL (Oracle Procedural Language)
• ETL Pipeline Development & Administration
• Hybrid Database Operations
• Stored Procedure & Query Optimization

Key Responsibilities

• Administer Microsoft SQL Server (2012, 2016, 2019, 2022, 2025) instances across on-premises and cloud-hosted (Azure SQL / AWS RDS for SQL Server) environments
• Design, develop, deploy, and maintain SSIS packages and ETL pipelines for data ingestion, transformation, and distribution across heterogeneous source systems
• Develop, publish, and administer SSRS reports, paginated reports, data sources, and datasets.
• Write, optimize, and maintain T-SQL queries, stored procedures, functions, triggers, views, and dynamic SQL for application and reporting use cases
• Develop and migrate PL/SQL stored procedures, packages, and functions
• Manage SSIS catalog (SSISDB): package deployments, environment variables, project parameters, execution logging, and error handling frameworks
• Perform SQL Server routine DBA tasks: backup and restore, index maintenance
• Management Views (DMVs), SQL Server Profiler, and Extended Events
• Support ETL pipeline scheduling via SQL Server Agent and coordinate pipeline dependencies
• Implement and maintain SSRS security including role-based access, report subscriptions
• Perform database schema management including DDL scripting, version-controlled migrations
• Conduct data validation, reconciliation, and quality assurance across ETL pipelines
• Implement database security controls including TDE, SQL Server Audit, column-level encryption, and role-based access management
• Maintain ETL pipeline documentation, SSRS report inventories, T-SQL / PL/SQL code

Enterprise Tools & Platforms

• MS-SQL: SQL Server Management Studio (SSMS), SQL Server Agent, SQL Server Profiler, Extended Events, Database Mail, Linked Servers, Always On AG
• SSIS: Visual Studio SSDT, SSIS Catalog (SSISDB), SSIS Scale Out, Control Flow / Data Flow design, error redirection, package configurations, logging providers
• SSRS: SSRS Web Portal / Report Manager, Report Builder, SSDT RDL/RDLC authoring, tablix, matrix, chart, map report items, KPI indicators, subscriptions
• T-SQL: Stored Procedures, Functions (scalar, table-valued, inline), Views, Triggers, CTEs, Window Functions, Dynamic SQL, Temp Tables, Cursors, Merge statements
• PL/SQL: Oracle Packages, Procedures, Functions, Cursors, Exception Handling, Bulk Collect / FORALL, Dynamic SQL, PL/SQL Collections, Oracle DB Links
• Version Control: Git (T-SQL / SSIS / SSRS source control), Redgate SQL Source Control
• Monitoring: SQL Server Agent Alerts, SSRS Execution Log, SSIS catalog reports, Datadog, Dynatrace, SCOM
• Automation: PowerShell (dbatools, SqlServer module), T-SQL scripting, Azure CLI, SSRS REST API
• ITSM: ServiceNow

SLA / KPI Ownership

• Ensure adherence to SLA/KPI commitments across MS-SQL, SSIS ETL pipelines, and SSRS reporting platforms including patching
• Track MTTR (Mean Time to Resolve) and MTTA (Mean Time to Acknowledge) for all database and pipeline incidents
• Publish service performance reports and contribute to monthly service review decks

Client Facing Responsibilities

• Participate in war room calls during major incidents affecting database availability, ETL pipelines, or reporting platforms
• Provide timely status updates during incidents, patching windows, ETL failures, and reporting change events
• Coordinate with Microsoft Premier Support and Azure engineering teams for critical platform issue resolution

Technical Experience

• 3-5 years of experience with focus on MSSQL, SSIS, SSRS, T-SQL, and PL/SQL
• Hands-on production experience developing and administering SSIS ETL packages
• Practical experience publishing and supporting SSRS reports including parameterized reports
• Working knowledge of PL/SQL for Oracle-to-MS-SQL cross-platform integration
• Microsoft Certified: Azure Database Administrator Associate or MCSE: Data Management and Analytics preferred experience with Redgate tooling a plus

Professional Attributes

• Good communication and stakeholder management skills in a client-facing environment
• Ability to handle critical data pipeline or reporting incidents and coordinate escalations under pressure
• Flexible to work in a hybrid on-call or 24/7 rotation model as required
• Detail-oriented with a strong focus on data integrity, query correctness, and ETL pipeline reliability

Educational Qualification

Bachelor's degree in Computer Science, Information Technology, Information Systems, or a related discipline, 15 years full time education