Database Analyst - Internal Medicine Business Office

Washington University in St. Louis - St. Louis, MO (30+ days ago)4.1


Job Type/Schedule

This position is full-time and works approximately 40 hours per week.

Department Name/Job Location

This position is in the Department of Internal Medicine, Business Office. This position is for the Medical School Campus.

Essential Functions

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. Some knowledge of funds accounting common in educational institutions will be helpful.

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, finance and business 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, business management, 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

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.

Preferred Qualifications

Planning and Organizing: Ability to organize and follow complex and/or detailed technical procedures; ability to work independently and performs job with minimal supervision

Project Management: Ability to manage one module of a larger project or responsible for projects of limited complexity

Technical Knowledge: Competent to work on most phases of database systems administration. Focus on but not limitied to Microsoft SQL environment, knowledge of additional database environments a plus; working knowledge of Data Transformation Services (DTS), SQL Server Integration Services (SSIS), and BCP for Extract, Transform and Load (ETL), and SQL Server Reporting Services (SSRS). Proficiency using Microsoft VisualBasic.Net, MDX and C# to support existing applications as well as new development.

Technical Solution Development: 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

Technical Support: Knowledge of technical features to assist in problem determination and resolution

Consultancy Skills: Ability to consult with clients (including finance and business managers) and higher-level technicians and analysts to resolve technical problems and ensure client satisfaction; ability to interact with client to discuss alternative technical solutions

Salary Range

The hiring range for this position is $54,288 - $70,553 annually.

Benefits

  • Retirement Savings Plan
  • 22 vacation days
  • 8 Paid Holidays
  • Sick Time
  • Tuition benefits for employee, spouse and dependent children
  • Free Metro Link/ Bus pass
  • Free Life Insurance
  • Health, Dental, Vision
  • Health Savings Accounts (HSA)
  • Long Term Disability Insurance
  • Flex Spending Plan
  • Other Benefits
Med School HR website (medschoolhr.wustl.edu)

Applicant Special Instructions

Standard computer department working environment with standing, walking, and lifting less than 50 pounds required; a moderate amount of work performed at customer site

EOE Statement

Washington University is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity or expression, national origin, genetic information, disability, or protected veteran status.