Windows Solutions Engineer
Reporting to the Technical Lead for DevOps and Infrastructure in Library IT, the Windows Solutions Engineer will serve as systems and database administrator, with responsibility for local and hosted Microsoft Windows databases and infrastructure, as well as for other critical services and storage in a production environment. The incumbent will design, install, configure, integrate, document, and manage core systems, storage, and applications for the Yale University Library. The Windows Solutions Engineer will work closely with the Library IT Software Engineering group, service owners, and stakeholders. The Windows Solutions Engineer will also be responsible for the following…
- Support the Library’s Microsoft SQL Server databases.
- Support the Library’s Microsoft .Net based applications.
- Advanced technical support for all Windows and .Net based Yale University Library applications.
1. Provides technical expertise in multiple and complex areas of computing; provides technical expertise to assist in the area of systems and storage design and architecture; plans, develops, deploys the design of major, complex systems; provides 24/7/365 support for locally managed production-class systems. 2. Provides assistance with departmental planning and long-range technical development; ensures that system design strategies meet the current and future business needs; creates, conceives, and plans the development of new data sources, and criteria, as well as systems and storage standards 3. Works closely with and supports development teams, agile and waterfall workflows, explores opportunities for continuous improvement and streamlined deployments. 4. Gathers business and technical requirements, assess and analyses technical feasibility, and implements selected system or service; develops and documents best practices, processes, and procedures related to all aspects of systems and storage; creates accurate and reasonable estimates and timelines. 5. Analyzes, troubleshoots, and diagnoses problems and provides ongoing maintenance and support for applications and systems. 6. Investigates new products and technologies; conducts or assists in the evaluation and/or proof of concept work to make recommendations and better understand requirements and solution design. 7. Maintains a deep understanding of functional and domain knowledge pertaining to related technologies and services, as well as keeps abreast of industry trends.
Required Education and Experience
Bachelor's Degree in a related field and a minimum of three years of related work experience or an equivalent combination of education and experience.
Required Skill/Ability 1:
Demonstrated ability with database administration and programming, particularly MS SQL Server (SSIS, SSRS). Skills crafting SQL, stored procedures, automated regular ETL routines, and user defined functions. Demonstrated ability with user administration, access controls, and data protections of MS SQL Servers.
Required Skill/Ability 2:
Demonstrated ability administering and configuring various Windows server operating systems. Ability with scripting languages such as Powershell, VBScript, and .Net.
Required Skill/Ability 3:
Demonstrated ability with Microsoft IIS, including site creation, migration, and access management.
Required Skill/Ability 4:
Demonstrated skill with high availability, load balancing, and failover techniques.
Required Skill/Ability 5:
Excellent oral and written communication skills.
Preferred Education, Experience and Skills:
Familiarity with performance testing, monitoring, and tuning packages, tools, and techniques. Knowledge of authentication mechanisms such as CAS, Active Directory, LDAP, and Shibboleth. Strong analytical and organizational skills. Experience administering Microsoft Sharepoint, including site creation, migration, and user management.
Background Check Requirements
All candidates for employment will be subject to pre-employment background screening for this position, which may include motor vehicle, DOT certification, drug testing and credit checks based on the position description and job requirements. All offers are contingent upon the successful completion of the background check. Please visit www.yale.edu/hronline/careers/screening/faqs.html for additional information on the background check requirements and process.
The intent of this job description is to provide a representative summary of the essential functions that will be required of the position and should not be construed as a declaration of specific duties and responsibilities of the particular position. Employees will be assigned specific job-related duties through their hiring departments.
Affirmative Action Statement:
Yale University considers applicants for employment without regard to, and does not discriminate on the basis of, an individual’s sex, race, color, religion, age, disability, status as a veteran, or national or ethnic origin; nor does Yale discriminate on the basis of sexual orientation or gender identity or expression. Title IX of the Education Amendments of 1972 protects people from sex discrimination in educational programs and activities at institutions that receive federal financial assistance. Questions regarding Title IX may be referred to the University’s Title IX Coordinator, at TitleIX@yale.edu, or to the U.S. Department of Education, Office for Civil Rights, 8th Floor, Five Post Office Square, Boston MA 02109-3921. Telephone: 617.289.0111, Fax: 617.289.0150, TDD: 800.877.8339, or Email: email@example.com.