Application Support Analyst MSSQL

As an Application Support Analyst specializing in MSSQL, you will be a key member of our support team, responsible for ensuring the smooth operation and optimal performance of applications relying on Microsoft SQL Server. Your role will involve troubleshooting, analyzing, and resolving database-related issues, as well as providing support to end-users and collaborating with development teams to enhance system functionality.

Responsibilities:

• Monitor MSSQL databases to ensure performance, availability, and security.
• Perform routine maintenance tasks, such as backups, updates, and optimization.
• Investigate and resolve application issues related to MSSQL databases promptly.
• Collaborate with cross-functional teams to address complex problems and implement effective solutions.
• Provide timely and effective support to end-users experiencing database-related issues.
• Offer guidance on database-related queries and assist in data retrieval.
• Conduct performance analysis and implement tuning strategies to enhance database efficiency.
• Optimize SQL queries and recommend improvements to application developers.
• Maintain comprehensive documentation for database configurations, issues, and resolutions.
• Create and update knowledge base articles for common problem resolution.
• Manage and prioritize support tickets, ensuring timely resolution and effective communication with stakeholders.
• Escalate critical issues to appropriate teams and follow through to resolution.
• Collaborate with development teams to understand database schema, application architecture, and dependencies.
• Participate in cross-functional meetings to enhance application performance and reliability.

Qualifications:

• In-depth knowledge and hands-on experience with Microsoft SQL Server (MSSQL).
• Proficiency in writing and optimizing SQL queries.
• Strong analytical and problem-solving skills to diagnose and resolve database-related issues.
• Excellent communication skills to interact with end-users, developers, and cross-functional teams.
• Ability to convey technical information in a clear and understandable manner.
• Ability to work collaboratively in a team-oriented environment.
• Experience collaborating with developers and other support teams.
• Strong documentation skills for maintaining records and creating knowledge base articles.
• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Relevant certifications in MSSQL or database administration are a plus.