SQL Developer - Level 2

As a SQL Developer, Tier 2, you’ll be part of a team that provides higher-level technical support, especially in situations where the support needed is deeply technical. In this role, you will be ensuring the performance, integrity, and security of database systems. Your expertise will guide the design, implementation, and maintenance of SQL Server databases, directly impacting our software's functionality and customer satisfaction. This role requires a balance of technical expertise, collaborative skills, and a strong commitment to ensuring the reliability, security, and performance of the organization's database systems. Your contributions will be crucial in driving the success of our software solutions and enhancing customer satisfaction.

Responsibilities

• Database Optimization: Regularly assess and optimize SQL queries and server performance to ensure fast response times and efficient data retrieval. This involves re-indexing, updating statistics, and reorganizing indexes as necessary.

• Development and Implementation: Design and implement robust database solutions based on RDBMS concepts, including the creation and management of Views, Triggers, Stored Procedures, Indexes, and Constraints to support application requirements.

• Agile Collaboration: Actively participate in SQL-based agile development teams, collaborating closely with other stakeholders, Application Developers included, to ensure optimal database design and performance within the agile framework.

• Data Management: Handle SQL script comparisons, data migration, and patch preparation tasks, ensuring data integrity and consistency across environments.

• Troubleshooting and Support: Diagnose and troubleshoot database and application/product bugs, working closely with the customer support team to resolve issues efficiently.

• Technology Integration: Work with Web Servers and source control systems like DevOps and TFS to manage code and database changes securely and efficiently. Leverage DotNet skills for integrated development tasks when necessary.

• Communication and Collaboration: Maintain clear and effective communication with team members and stakeholders, documenting processes and solutions clearly for both technical and non-technical audiences.

• Team Engagement: Be an active, self-motivated team player, willing to take initiative and contribute to team success.