MSSQL Professional

Job Responsibilities :

• Data Export Procedure Management : Design, maintain, and optimize MS SQL export procedures, ensuring their efficiency, reliability, and accuracy for various data operations and reporting needs. This includes regular review and enhancement of existing scripts and processes.
• Production Alert & Escalation Management : Proactively monitor and manage database production alerts, responding swiftly to critical incidents. Effectively address and resolve customer escalations related to database performance, data availability, or export failures, ensuring minimal impact on business operations.
• Query Performance Optimization : Focus on significantly improving the performance of complex export queries and other critical SQL statements. This involves identifying performance bottlenecks, analyzing execution plans, and implementing effective optimization strategies such as indexing, query rewriting, and schema adjustments.
• Troubleshooting & Issue Resolution : Conduct in-depth troubleshooting and swiftly resolve any issues that arise within the MSSQL environment, including connectivity problems, data corruption, and system performance degradations, ensuring continuous database availability.
• Database Health & Maintenance : Contribute to the overall health and smooth functioning of data export processes and database systems through routine maintenance, monitoring, and proactive problem prevention.
• Collaboration : Work closely with development teams, data analysts, and other stakeholders to understand data requirements and provide robust database support.

Required Skills :

Good to Have :

Skills Required

Ms Sql, Escalation Management, Sql Queries, Java, Database Managment