Sr. SQL Server Developer Job Description Template
Our company is looking for a Sr. SQL Server Developer to join our team.
Responsibilities:
- Build custom data imports as required;
- Mentor junior team members as needed;
- Demonstrate SQL best practices in regards to security and privacy as well as design;
- Troubleshoot and problem solve SQL database issues;
- Propose technical solutions, new application design, process flows;
- Stress test and optimize the system for efficiency in a distributed database;
- Propose and implement database architectural changes to make database infrastructure highly scalable and optimized;
- Implement and test software/server upgrades as needed to gain better functionality;
- Identify and understand business needs during requirements gathering to effectively design, develop, test, and deploy reports or applications;
- Develop and foster a team atmosphere that exhibits teamwork within the department and with other departments and clients;
- Be responsive and timely with ad-hoc data requests;
- Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc.);
- Ensure that new database code meets company standards for readability, reliability, and performance;
- Design indexes for existing applications, choosing when to add or remove indexes;
- Provide developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each.
Requirements:
- Strong skills in performance turning especially tuning complex queries, procedure and indexing strategies;
- Bachelor’s Degree in Computer Science, Computer Engineering or a closely related field;
- C#, VB application development experience;
- Motivated to share knowledge in a team environment;
- Ability to multi-task in a fast-paced environment;
- BS/BA in Computer Science, Business, Management Information Systems, Mathematics or relevant degree is highly preferred;
- SSIS: 5+ experience;
- Self-directed and able to prioritize own workload;
- Healthcare industry experience helpful;
- xcellent interpersonal, analytical, and problem solving skills;
- Ability to learn quickly and ‘get things done’
- DR knowledge with Always On, SQL log shipping, DB mirroring, Replication;
- Expert level experience with Microsoft SQL Server 2008/2012 Enterprise Edition;
- EZ-CAP® knowledge a plus;
- Experience with data warehouses highly desirable.