FUNCTIONAL REQUIREMENTS

• Build stored procedures that include complex queries for large enterprise -level databases, with the bulk of business logic contained within the databases. Ideally, this will include the ability to program dynamic SQL as well

• Build robust T-SQL test scripts to validate stored procedures are working as designed.

• Populate test environments with test data where necessary to enable unit and regression testing
• Work with CI/CD (continuous integration/ continuous deployment) automation software (Azure environments)
• Work alongside executive leadership, project managers, software engineers/architects, application developers (.Net) and end users to develop commercial, 100% cloud-based software
• Develop updates and improvement to existing production software using Agile/DevOps principles and processes
• Create documentation in support of stored procedures, scripts and internal processes

EDUCATION AND CERTIFICATIONS

• B.S. in Computer Engineering or Computer Science from accredited university
• Microsoft Technology Associate (MTA): Database Fundamentals SQL Certification (Optional)
• Microsoft Certified: Azure Database Administrator Associate (Optional)

SKILLS AND EXPERIENCE

• Detail oriented
• Working in a team
• Effective communication
• Database management
• Data analysis
• SQL programming (SQL Server2017)
• CI/CD and code testing
• Performance optimization
• Reporting
• SSMS (SQL Server Management Studio)
• Knowledgeable and ideally full stack experience using .Net v4.5, Bootstrap v3, jQuery v3.3, CSS3, JSON, C#

This is a senior level role for a SQL developer with 5-10 years of relevant and hand-on experience. Salary is commensurate with experience