Database Analyst II

Scheduled Hours

40

Position Summary

This position provides technical and analytical work in implementing, supporting, and monitoring departmental and enterprise database management systems for the business, research, and/or instructional functions of clients. Employee will oversee the migration of database structures from development and QA environments into the production environment, monitor and manage all environments, and report capacity and performance results to management. Strong knowledge of scripting, stored procedures, and query skills are required. Duties include gathering client requirements as well as evaluating hardware availability and software requirements. Additionally, employee will be involved in administration of the databases(s) that support the application code. Employee will interact with business and application development staff and should be able to work independently with minimal supervision.

Job Description

Primary Duties and Responsibilities

• Leads design of databases for modules of larger projects, monitoring progress to ensure timely completion of deliverables.
• Helps determine appropriate architecture and other technical solutions and makes relevant recommendations to the project manager or clients.
• Works with clients, project managers and designers in migrations of applications and databases to new environments.
• Communicates to the project manager with efficiency and accuracy any progress and/or delays.
• Coordinates with Information Security Office on assessing the risk of the database environments and appropriate controls to protect the confidentiality, integrity and availability of the information.
• Tests applications to ensure performance and capacity plans meet expectations, including performing index tuning, query writing and optimization.
• Designs and develops application database structure, tables, entity relationships and security privileges.
• Ensures designs make efficient use of network and database resources.
• Coordinates work with other team members for application development, administration, information security and network administration to ensure that architecture, functionality and design are consistent with all information technology strategies.
• Researches and evaluates new technology, products, specialized hardware and tools to optimize development and functionality of websites and applications.
• Performs other duties as assigned.

Preferred Qualifications

• Ability to organize and follow complex and/or detailed technical procedures; ability to work independently and performs job with minimal supervision.
• Ability to manage one module of a larger project or responsible for projects of limited complexity.
• Competent to work on most phases of database systems administration. Focus on but not limited to Microsoft SQL environment, knowledge of additional database environments a plus; working knowledge of Data Transformation Services (DTS), SQL Server Integration Services (SStudent System) and BCP for Extract, Transform and Load (ETL) and SQL Server Reporting Services (SSRS).
• Ability to devise or modify databases to solve moderately complex problems considering computer equipment capacity and limitations; knowledge of system development and/or maintenance technologies to support the infrastructure that assigned databases resides upon and maintains that infrastructure.
• Knowledge of technical features to assist in problem determination and resolution.
• Ability to consult with clients and higher-level technicians and analysts to resolve technical problems and ensure client satisfaction; ability to interact with client to discuss alternative technical solutions.

Required Qualifications

Certification or degree in relevant IT technologies from a technical school or college required; DBA experience related to this position may be substituted on a year-for-year basis for all education.

Grade

G12

Salary Range

$57,300.00 - $97,700.00 / Annually The salary range reflects base salaries paid for positions in a given job grade across the University. Individual rates within the range will be determined by factors including one's qualifications and performance, equity with others in the department, market rates for positions within the same grade and department budget.

Questions

For frequently asked questions about the application process, please refer to our External Applicant FAQ .

Accommodation

If you are unable to use our online application system and would like an accommodation, please email     or call the dedicated accommodation inquiry number at and leave a voicemail with the nature of your request.

Pre-Employment Screening

All external candidates receiving an offer for employment will be required to submit to pre-employment screening for this position. The screenings will include criminal background check and, as applicable for the position, other background checks, drug screen, an employment and education or licensure/certification verification, physical examination, certain vaccinations and/or governmental registry checks. All offers are contingent upon successful completion of required screening.

Benefits Statement

Personal

• Up to 22 days of vacation, 10 recognized holidays, and sick time.

• Competitive health insurance packages with priority appointments and lower copays/coinsurance.

• Want to Live Near Your Work and/or improve your commute? Take advantage of our free Metro transit U-Pass for eligible employees. We also offer a forgivable home loan of up to $12,500 for closing costs and a down payment for homes in eligible neighborhoods.

• WashU provides eligible employees with a defined contribution (403(b)) Retirement Savings Plan, which combines employee contributions and university contributions starting at 7%.

Wellness

• Wellness challenges, annual health screenings, mental health resources, mindfulness programs and courses, employee assistance program (EAP), financial resources, access to dietitians, and more!

Family

• We offer 4 weeks of caregiver leave to bond with your new child. Family care resources are also available for your continued childcare needs. Need adult care? Weâ™ve got you covered.

• WashU covers the cost of tuition for you and your family, including dependent undergraduate-level college tuition up to 100% at WashU and 40% elsewhere after seven years with us.

For policies, detailed benefits, and eligibility, please visit:

EEO/AA Statement

Washington University in St. Louis is committed to the principles and practices of equal employment opportunity and especially encourages applications by those from underrepresented groups. It is the Universityâ™s policy to provide equal opportunity and access to persons in all job titles without regard to race, ethnicity, color, national origin, age, religion, sex, sexual orientation, gender identity or expression, disability, protected veteran status, or genetic information.

Diversity Statement

Washington University is dedicated to building a diverse community of individuals who are committed to contributing to an inclusive environment â“ fostering respect for all and welcoming individuals from diverse backgrounds, experiences and perspectives. Individuals with a commitment to these values are encouraged to apply.

About Washington University in St. Louis

Washington University in St. Louis, a medium-sized, independent university, is dedicated to challenging its faculty and students alike to seek new knowledge and greater understanding of an ever-changing, multicultural world. The University offers more than 90 programs and almost 1,500 courses leading to bachelor's, master's and doctoral degrees in a broad spectrum of traditional and interdisciplinary fields, with additional opportunities for minor concentrations and individualized programs. The faculty is composed of scholars, scientists, artists and members of the learned professions. They serve society by teaching; by adding to the store of human art, creativity, understanding, and wisdom; and by providing direct services, such as health care.

Connections working at Washington University in St. Louis