Sr. Engineer, IT EIS DATABASE at Micron Technology

Hyderabad, Telangana, India -

Full Time

Start Date

Immediate

Expiry Date

11 Mar, 26

Salary

0.0

Posted On

11 Dec, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

MSSQL, Database Development, Operational Support, AlwaysOn, Database Replication, Disaster Recovery, Automation, Performance Tuning, Troubleshooting, Powershell, Azure Cloud, ITIL, Index Analysis, Query Tuning, Partitioning, Compression

Industry

Semiconductor Manufacturing

Description

Must be willing to work in 24 x 7 Operational support environment with shift rotation and oncall support. Provide database development and deployment support for company projects. Lead the health and the capacity of MSSQL databases. Provide operational database support for a multi-site enterprise environment which includes Very Large databases (VLDB), AlwaysOn and Database Replication Plan and participate in disaster recovery drills Meet government and industry compliance requirements. Automate, innovate, and push database technologies forward. Proactive reviewing of system log files, trend analysis, configuration processes. Recommend and work with the Global team or Solution Architect on system or architectural changes when needed to improve automation, performance, high availability, and scalability. Update operational runbook documentation and other documentation for any changes in the environment. Continually improve operations through routine monitoring of system performance metrics and proactive actions. Required Skills and Experience: Work independently based on the mentorship provided by managers. Ability to work with team members across disciplines under pressure. Strong communication skills (verbal, written, presentation, interpersonal). Solid skills in decision-making, prioritization, and negotiation. Proven ability in troubleshooting and problem solving. Passion and accountability for the environment you will be responsible for. Perform research and testing to understand feature usage and standard methodologies MS SQL - 5 - 8 Years of experience Version support for Microsoft SQL server 2014, 2016, 2017, 2019 and 2022. Experience in implementing and fixing AlwaysOn Experience troubleshooting and tuning Transactional Replication architecture in high transaction volume databases. Experience in query tuning - plan analysis, index analysis and assist developers in refactoring SQL code for better performance Experience with partitioning and compression Experience using extended events, SQL Audit, CDC Experience with Information Technology Infrastructure Library (ITIL) framework Knowledge. Powershell knowledge will be an added advantage Azure cloud knowledge will be an added advantage

Responsibilities

Provide database development and deployment support for company projects while leading the health and capacity of MSSQL databases. Automate and innovate database technologies, ensuring compliance with government and industry standards.