3.0 - 7.0 years

0 Lacs

karnataka

On-site

The SQL Server Data Engineer will be responsible for the development and sustainment of the SQL Server Warehouse, ensuring its operational readiness (security, health, and performance), executing data loads, and performing data modeling in support of multiple development teams. The data warehouse supports an enterprise application suite of program management tools. You must be capable of working independently and collaboratively. Responsibilities: - Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. - Troubleshoot issues related to memory-optimized tables in MS SQL Server 2019. - Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. - Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations. - Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end. - Assist developers with complex query tuning and schema refinement. Requirements: The ideal candidates must have: - Minimum 5 years of relevant experience in data modeling, database & data warehouse management, performance tuning on Microsoft SQL Server Databases. - 3+ years of experience with programming and database scripting. - Experience with clustered configurations, redundancy, backup, and recovery. - Good knowledge of SSIS development, T-SQL, Views, Stored Procedures, Functions, and Triggers. - Experience in AWS and Azure Cloud will be an added advantage.,

Posted 6 days ago

Apply

SSIS Developer Zentek Infosoft

12.0 - 14.0 years

10 - 14 Lacs

Chennai, Tamil Nadu, India

On-site

The role involves monitoring , troubleshooting and maintain SSIS packages and ETL (Extract , Transform , Load ) workflows that are critical to business operations . The ideal candidate should have strong debugging skills , a proactive attitude, and the ability to work on incident management under pressure . Key Responsibilities : Monitor production SSIS jobs and ETL pipelines to ensure timely completion . Investigate , troubleshoot, and resolve issues related to SSIS package . Provide L3 support by analyzing logs, debugging SQL queries, and identifying root causes. Proactive approach to resolve all the incidents within SLA On-call support is required for production incident. Perform impact analysis and recovery actions for failed jobs. Coordinate with development and other feature teams for bug fixes and enhancements when required . Maintain and update job schedules , error handling and retry mechanisms. Create and update Knowledge Base (KB) articles for common SSIS issues . Support incident management (Priority ticket handling ) and participate in post-incident reviews . Ensure adherence to SLAs and escalation protocols. Suggest automation opportunities to reduce manual monitoring efforts . Basic knowledge of project management tool . (Jira ) Required Skills : Strong understanding of SSIS architecture and package execution flow. Proficient in SQL server ability to debug queries and stored procedures . Experience in job scheduling Good understanding of ETL error handling and logging best practices .

Posted 1 week ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.