AddressOBJECTIVE
We are seeking a highly skilled and experienced Microsoft SQL Server Database Developer to join our team. As a Database Developer, you will be responsible for designing, developing, and maintaining our SQL Server databases, ensuring their performance, availability, and security.
ESSENTIAL RESPONSIBILITIES & DUTIES
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the Team Member for this job. Duties, responsibilities, and activities may change at any time with or without notice.
- Design, develop, and implement SQL Server databases, tables, views, stored procedures, functions, and triggers.
- Write and maintain complex stored procedures and functions to support various business requirements.
- Optimize database performance by analyzing query execution plans, indexing strategies, and database statistics.
- Troubleshoot and resolve database-related issues, including performance bottlenecks, data integrity, and concurrency problems.
- Collaborate with software developers and system administrators to ensure seamless integration of applications with the database.
- Perform database tuning and optimization to improve overall system performance.
- Implement and maintain database security, including user access control and data encryption.
- Monitor and maintain database backups. Implement and test disaster recovery strategies.
- Monitor database performance and proactively identify and resolve issues.
- Stay up to date with the latest SQL Server features, tools, and best practices and communicate recommendations to management and other team members.
- Day to day work: Tier 3 support, including monitoring alerts, responding to service tickets, preventative maintenance, and supporting other team members by providing industry expertise on difficult and complex issues.
- Responsibilities outside of normal business hours: most maintenance will happen on weekends. On call support will be required.
- Other duties may be assigned.
EDUCATION AND EXPERIENCE
- Bachelor’s degree in computer science, Information Technology, or a related field
- Experience as a Microsoft SQL Server Database Developer, with a minimum of 6 years of experience
QUALIFICATIONS
- Strong knowledge of SQL Server database design principles and best practices
- Expertise in writing complex stored procedures, functions, and triggers
- Proficiency in query optimization and performance tuning
- Experience with SQL Server Reporting Services (SSRS), Power BI, or Qlik is a plus.
COMPETENCIES
- Apply technical / functional expertise
- Foster open communication
- Manage and improve processes
- Champion change and innovation
- Practice self development
WORK RELATIONSHIPS (INTERNAL & EXTERNAL)
External
- Venders
- Customers
INTERNAL
- IT
- Team Members at all levels of the organization
WORK ENVIRONMENT
Strict adherence to Company policies, rules, and regulations in these areas is required. A team member in this position must focus on the customer’s expectations, prevent problems, and strive for continuous improvement resulting in improved results for themselves, customers and other team members.
PHYSICAL DEMANDS
While performing the duties of this job, the team member is regularly required to talk or hear. The team member is frequently required to stand; walk; use hands to finger, handle or feel; and reach with hands and arms. The team member is occasionally required to sit, climb, balance, stoop, kneel, crouch or crawl. The team member must frequently lift and move up to 10 pounds and occasionally lift and move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.
TRAVEL
20% travel is expected for this position.
LOCATION
This position is fully remote but occasional travel to multiple sites may be expected. Relocation assistance is not available for this position.
