- Design and develop efficient and optimized database solutions using SQL Server, ensuring data integrity and security
- Write complex T-SQL queries, stored procedures, and functions to meet application requirements and optimize database performance
- Perform database design, data modeling, and normalization to ensure an efficient and scalable database structure
- Conduct performance tuning and optimization of SQL queries and database processes for improved system performance
- Provide guidance and mentorship to junior developers and assist in resolving complex database-related issues
- Participate in Agile/Scrum methodologies, including sprint planning, backlog grooming, and retrospective meetings
Qualifications of the Staff Database Engineer
- Bachelors/Masters degree in Computer Science, Software Engineering, or a related field
- Proven experience in SQL Server development, with expertise in writing complex T-SQL queries, stored procedures, and functions
- Experience in ETL (Extract, Transform, Load) processes and data modeling is a plus
Knowledge, Skills, and Abilities of the Staff Database Engineer
- Excellent problem-solving and analytical skills, with the ability to architect and implement scalable and efficient solutions
- Strong communication and leadership skills, with the ability to effectively collaborate with cross-functional teams
- Familiarity with Agile/Scrum methodologies and working in a team-oriented environment
- Strong understanding of database design principles, normalization, and indexing techniques
- Proficiency in performance tuning and optimization of SQL queries and database processes
