Address
Form of workUW Continuum College (Continuum) expands the reach of the University of Washington with programs like UW Professional & Continuing Education, International & English Language Programs, Youth & Teen Programs, and the Osher Lifelong Learning Institute at the UW that meet the needs of various learners at all phases of their lives. We're focused on removing obstacles to relevant educational opportunities by addressing geographic, financial, length of commitment and time constraints, increasing access to knowledge for more people. As a diverse community that values inclusivity and collaboration, we foster a respectful, supportive workplace where innovation comes to life. By looking ahead and experimenting with new approaches, we're creating new educational opportunities to help people thrive in a world of change.?
UW Continuum College has an outstanding opportunity for a Senior SQL Server Developer on our Technology and Data Services team!
About the position
The Senior SQL Server Developer will play a major role in the development and maintenance of application systems and technologies that support the educational mission of University of Washington Continuum College.
This position works within a team to provide senior-level systems design, development, programming, implementation, consultation, maintenance, and support for core administrative applications including curriculum management, registration, grading, financial management, budgeting, and payroll, as well as self-service tools for students, instructors, and other non-administrative users in these areas.
The developer plays a key role in designing and developing robust, secure, sustainable and scalable applications, and needs an understanding of university business processes and existing university technology solutions. The developer will also show initiative and flexibility to take on broader responsibilities such as business analysis and project management when necessary, as well as develop technical estimates, manage workload toward agreed upon milestones, and negotiate priorities in a deadline-driven environment. The Senior SQL Server Developer is also able to provide technical oversight on projects appropriate to job skills and to mentor staff less familiar with our tools and environments.
The Senior SQL Server Developer will primarily use Microsoft SQL Server, classic ASP, ASP.NET MVC, and Microsoft middleware technologies, but may also develop integrations with web services, APIs, and other databases, including those connected to Workday, Salesforce, Canvas, and the Kentico CMS platform.
Responsibilities
Implement new features into existing internal- and external-facing applications and implement new applications. To accomplish this, design or modify database tables, stored procedures, functions, views, and triggers in SQL Server, including stored procedures and functions that contain a significant amount of business logic in order to interact with internal- and external-facing applications (usually web-based).
Work with business users and business analysts to gather requirements for the design, creation, and implementation of changes to existing database systems or new systems.
Design SSIS/ETL packages to load and transform data to and from various source and destination systems in specified formats (e.g., SQL Server databases, web services, flat files, and XML).
Communicate with business users to identify, document, and track production issues and work with other developers to solve these issues in a timely manner.
Work with other development team members to determine technical requirements, as well as specifications for projects and features needed to satisfy business requirements.
Design and implement basic web interfaces to allow business users to interact with implemented database solutions.
Perform rigorous quality assurance testing through all phases of software development to ensure delivery of high-quality products.
Create support documentation and cross-train other development team members on implemented processes so that they can support these solutions.
Other responsibilities:
Tune performance of database queries and stored procedures.
Investigate and handle complaints related to application performance.
Work with other developers to determine the amount of effort required for completing projects.
Work with project managers to plan project timelines.
Exercise technical and organizational leadership to initiate, carry out, and complete successful development and maintenance projects.
Document technical specifications.
Exercise and adhere to team coding standards and development/validation practices to ensure high-quality, maintainable technical deliverables.
Adhere and contribute to system configuration and deployment practices and standards.
Back up the other team members or provide support as projects require additional development resources.
Minimum Requirements:
Bachelor's degree in computer science, engineering, or related field or related experience and 4+ years of experience
Equivalent education and/or experience may substitute for minimum requirements.
Additional:
Strong database programming experience, including complex stored procedure, view, and trigger creation, query optimization, data modeling, and performance tuning.
Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
Understanding of SQL Server administrative features, including object-level permissions, security roles, and schemas
Understanding of best practices relating to SQL Server security and exploit prevention
Strong troubleshooting and debugging skills across layers of an application.
Significant experience and knowledge in business and systems analysis, design, project lifecycle methodology, system integration, implementation, and deployment
Extensive experience with requirements gathering and analysis, including direct work with end-users or customers.
Demonstrated oral and written communication skills and ability to work with personnel of various levels of technical background.
Experience with formal software engineering practices (version control, validation, deployment, maintenance)
Familiarity with object-oriented analysis, design, and programming
At the University of Washington, diversity, equity, inclusion, and belonging are central to our efforts to maintain a welcoming campus climate where all can find community. Affinity groups, among other resources, are available as an opportunity for UW Staff and Faculty to build connections across our campuses. To learn more about DEI-related resources, trainings, and policies, please visit our website, https://hr.uw.edu/diversity.
Application Process:
The application process for UW positions may include completion of a variety of online assessments to obtain additional information that will be used in the evaluation process. These assessments may include Work Authorization, Cover Letter and/or others. Any assessments that you need to complete will appear on your screen as soon as you select "Apply to this position". Once you begin an assessment, it must be completed at that time; if you do not complete the assessment you will be prompted to do so the next time you access your "My Jobs" page. If you select to take it later, it will appear on your "My Jobs" page to take when you are ready. Please note that your application will not be reviewed, and you will not be considered for this position until all required assessments have been completed.
Committed to attracting and retaining a diverse staff, the University of Washington will honor your experiences, perspectives and unique identity. Together, our community strives to create and maintain working and learning environments that are inclusive, equitable and welcoming.
The University of Washington is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, age, protected veteran or disabled status, or genetic information.
To request disability accommodation in the application process, contact the Disability Services Office at 206-543-6450 or dso@uw.edu.
Applicants considered for this position will be required to disclose if they are the subject of any substantiated findings or current investigations related to sexual misconduct at their current employment and past employment. Disclosure is required under Washington state law.
UW Continuum College has an outstanding opportunity for a Senior SQL Server Developer on our Technology and Data Services team!
About the position
The Senior SQL Server Developer will play a major role in the development and maintenance of application systems and technologies that support the educational mission of University of Washington Continuum College.
This position works within a team to provide senior-level systems design, development, programming, implementation, consultation, maintenance, and support for core administrative applications including curriculum management, registration, grading, financial management, budgeting, and payroll, as well as self-service tools for students, instructors, and other non-administrative users in these areas.
The developer plays a key role in designing and developing robust, secure, sustainable and scalable applications, and needs an understanding of university business processes and existing university technology solutions. The developer will also show initiative and flexibility to take on broader responsibilities such as business analysis and project management when necessary, as well as develop technical estimates, manage workload toward agreed upon milestones, and negotiate priorities in a deadline-driven environment. The Senior SQL Server Developer is also able to provide technical oversight on projects appropriate to job skills and to mentor staff less familiar with our tools and environments.
The Senior SQL Server Developer will primarily use Microsoft SQL Server, classic ASP, ASP.NET MVC, and Microsoft middleware technologies, but may also develop integrations with web services, APIs, and other databases, including those connected to Workday, Salesforce, Canvas, and the Kentico CMS platform.
Responsibilities
Other responsibilities:
Minimum Requirements:
Equivalent education and/or experience may substitute for minimum requirements.
Additional:
At the University of Washington, diversity, equity, inclusion, and belonging are central to our efforts to maintain a welcoming campus climate where all can find community. Affinity groups, among other resources, are available as an opportunity for UW Staff and Faculty to build connections across our campuses. To learn more about DEI-related resources, trainings, and policies, please visit our website, https://hr.uw.edu/diversity.
Application Process:
The application process for UW positions may include completion of a variety of online assessments to obtain additional information that will be used in the evaluation process. These assessments may include Work Authorization, Cover Letter and/or others. Any assessments that you need to complete will appear on your screen as soon as you select "Apply to this position". Once you begin an assessment, it must be completed at that time; if you do not complete the assessment you will be prompted to do so the next time you access your "My Jobs" page. If you select to take it later, it will appear on your "My Jobs" page to take when you are ready. Please note that your application will not be reviewed, and you will not be considered for this position until all required assessments have been completed.
Committed to attracting and retaining a diverse staff, the University of Washington will honor your experiences, perspectives and unique identity. Together, our community strives to create and maintain working and learning environments that are inclusive, equitable and welcoming.
The University of Washington is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, age, protected veteran or disabled status, or genetic information.
To request disability accommodation in the application process, contact the Disability Services Office at 206-543-6450 or dso@uw.edu.
Applicants considered for this position will be required to disclose if they are the subject of any substantiated findings or current investigations related to sexual misconduct at their current employment and past employment. Disclosure is required under Washington state law.
