General Clinical Practice
Company Name:
Washington University of St. Louis
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 (General Clinical Practice). 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.
PRINCIPAL 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
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
Proficiency using Microsoft , MDX and C# to support existing applications as well as new development is highly preferred.
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).
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 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 $51,126 - $66,476 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 ( )
EOE Statement
All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, protected veteran, or disability status.
Job Title: Database Analyst - General Clinical Practice - 29304
Job ID: 29304
Location: Medical School
Full/Part Time: Full-Time
Regular/Temporary: RegularEstimated Salary: $20 to $28 per hour based on qualifications.
Washington University of St. Louis
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 (General Clinical Practice). 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.
PRINCIPAL 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
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
Proficiency using Microsoft , MDX and C# to support existing applications as well as new development is highly preferred.
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).
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 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 $51,126 - $66,476 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 ( )
EOE Statement
All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, protected veteran, or disability status.
Job Title: Database Analyst - General Clinical Practice - 29304
Job ID: 29304
Location: Medical School
Full/Part Time: Full-Time
Regular/Temporary: RegularEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
