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:

• MSSQL Expertise: Strong and extensive expertise with Microsoft SQL Server (MSSQL), including database administration, development, and advanced querying.
• SQL Export Procedures: Proven proficiency in designing, maintaining, and optimizing SQL export procedures.
• Production Support: Experience in managing database production alerts, incident response, and effectively handling customer escalations.
• Query Optimization: Demonstrated ability to analyze, tune, and improve the performance of complex SQL queries, particularly for data export.
• Troubleshooting: Strong troubleshooting and problem-solving skills for database-related issues.

Good to Have:

• Basic Java knowledge, which could be beneficial for integrating with existing applications or tools.