Database Analyst II - Cardiothoracic Surgery, Clinical Research

Scheduled Hours

40

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.

Primary

Duties & 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.

Job Location/Working Conditions

• Normal office environment

Physical Effort

• Typically sitting at a desk or table

Equipment

• Office equipment

The above statements are intended to describe the general nature and level of work performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all job duties performed by the personnel so classified. Management reserves the right to revise or amend duties at any time.

Education:

Associate degree or combination of education and experience may substitute for minimum education.

Certifications / Professional Licenses:

No specific certification/professional license is required for this position.

Work Experience:

No specific work experience is required for this position.

Skills:

Not Applicable

Driver's License:

A driver's license is not required for this position.

WashU seeks highly motivated individuals who are able to perform duties in a manner consistent with our core mission and guiding principles.

Education:

No additional education unless stated elsewhere in the job posting.

Certifications / Professional Licenses:

No additional certification/professional licenses unless stated elsewhere in the job posting.

Work Experience:

No additional work experience unless stated elsewhere in the job posting.

Skills:

Client Counseling, Database Administration, Data Transformation Services (DTS), Extract Transform Load (ETL), IT Solution Design, Microsoft SQL Server, Microsoft SQL Server Reporting Services, Organizational Savvy, Project Administration, SQL Server Integration Services (SSIS), SSRS Reporting Services, Technical Support, Working Independently

G12

$58,400.00 - $99,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.

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

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

All qualified individuals must be able to perform the essential functions of the position satisfactorily and, if requested, reasonable…