As a UW employee, you have a unique opportunity to change lives on our campuses, in our state and around the world. UW employees offer their boundless energy, creative problem solving skills and dedication to build stronger minds and a healthier world.
UW faculty and staff also enjoy outstanding benefits, professional growth opportunities and unique resources in an environment noted for diversity, intellectual excitement, artistic pursuits and natural beauty. All of which has allowed the UW to be nationally recognized as a “Great College to Work For” for six consecutive years.
The Washington National Primate Center has an outstanding opportunity for a Senior Computer Specialist.
The primary purpose of this position is to provide the appropriate environment to support outstanding biomedical research directed towards significant human health issues and nonhuman primate health and biology. In conjunction with our Mission Statement, these values link this position to our purpose as a Center: •Commitment to Research •Teamwork •Accountability - Productivity •Communication
Under the general direction of the Washington National Primate Research Center (WaNPRC) Associate Director, Finance & Administration, this position is responsible for the performance, integrity, development, and maintenance of the Center's information systems' databases. The successful candidate will be familiar with Oracle database development, automation, documentation, scripting, PL/SQL programming, ETL processing, and backup and recovery. This position requires strong SQL, PL/SQL development and tuning skills with a solid understanding of OLTP systems, perform tasks related to full software development life-cycle, which includes planning, analyzing requirements, designing solutions using Oracle 11g/12c, SQL, PL/SQL packages, stored procedures, functions, SQL Scripts, SQL*Loader.
RESPONSIBILITIES: •Design and document database architecture •Assess malfunctions of hardware and/or software applications for the purpose of determining appropriate actions to maintain computer, network, and database operations •Build database schemas, tables, views, procedures and permissions •Create, test, and execute data management solutions •Develop database utilities and automated reporting •Analyze and sustain capacity and performance requirements •Monitor systems and platforms for availability •Oversee backup, replication and failover •Perform maintenance operations on Oracle servers and databases, and information systems for the purpose of ensuring efficient program operations •Perform database backups and restorations, and recover corrupted databases •Evaluate and recommend new database technologies •Implement and maintain database security and encryption •Develop, manage and test database and information system backup and recovery plans •Develop standards and policies for data entry, and ensure compliance •Prepare written materials for the purpose of documenting activities, providing written reference, and/or conveying information •Prepare and distribute reports •PL/SQL programming must follow Industry coding standards •Other related duties, as assigned
REQUIREMENTS: •Bachelor Degree in Business or Computer Science or related field •Three to four years’ experience •Experience working with Oracle 11g/12c •Development skills must include sound knowledge and experience in Oracle SQL, PL/SQL, RMAN, Data Pump •Proficiency in Microsoft Windows and Microsoft Office applications with an emphasis on database and spreadsheet applications •Intermediate knowledge in hardware and networking •Proven ability to effectively manage multiple priorities and meet deadlines •Ability to adapt to varied roles and job responsibilities and problem-solving skills •Demonstrated ability using a life cycle management process for implementation of changes in technology •Demonstrated ability to excel both independently and as a team member in a lively, collaborative environment •Excellent written and verbal communications skills with a demonstrated ability to make difficult concepts easy to understand
Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration.
DESIRED EXPERIENCE •Experience in Microsoft SQL Server 2008+ •Experience in Microsoft Server administration •Experience in Microsoft Windows System Administration •Advance knowledge in hardware and networking •Experience in an academic environment
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 Workforce 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.
Founded in 1861, the University of Washington is one of the oldest public institutions in the west coast and one of the preeminent research universities in the world. The University of Washington is a multi-campus university comprised of three different campuses: Seattle, Tacoma, and Bothell. The Seattle campus is made up of sixteen schools and colleges that serve students ranging from an undergraduate level to a doctoral level. The university is home to world-class libraries, arts, music, drama, and sports, as well as the highest quality medical care in Washington State and a world-class academic medical center. The teaching and research of the University’s many professional schools provide undergraduate and graduate students the education necessary toward achieving an excellence that will serve the state, the region, and the nation. As part of a large and diverse community, the University of Washington serves more students than any other institution in the Northwest.