Implements, designs, and provides support for information systems applications using a variety of technologies. Assesses, plans, develops, implements, and maintains assigned systems. Designs, controls and coordinates the architecture of data schemas stored within databases.
Minimum Job Requirements
3 years experience in design, implementation and maintenance of databases and/or data warehouses.
5 years experience in Information Systems development, implementation and support.
BS in Computer Sciences/Information Systems/related major or at least 5 years experience in Information Technology in a technical role.
Data modeling experience.
Experience managing disk storage allocation and usage.
Experience with RDBMS architecture and database setup, configuration and tuning.
Practical experience with project delivery and systems development life cycles.
Solid Oracle or SQL Server skills and data warehouse design, implementation and administration (3 years hands-on experience).
Utilization of reporting tools like Microsoft Reporting Services, Business Objects, Cognos, MicroStrategy.
Essential Duties and Responsibilities
Implements, designs, and provides support for information systems applications using a variety of technologies. Assesses, plans, develops, implements, and maintains assigned systems.
Designs, controls, and coordinates the architecture of data schemas stored within databases.
Completes assignments within project deadlines and completes work according to project schedules.
Determines business and process issues to be addressed via the database, through interaction with clients, and the business/clinical analyst team.
Develops solutions to database systems problems through a specification process to include customization of vendor software, using tools such as reports, screen design & interface definitions.
Ensures database design specification requirements are met. Prepares complete test plans & test methodologies. Ensures all systems are adequately tested to ensure integrity and accuracy of the data.
Evaluates, designs, codes, tests, and implements custom or vendor supplied relational database systems.
Installs, implements, and maintains database management systems (e.g., Oracle, SQL Server).
Monitors and ensures the quality of data accessed throughout the enterprise.
Performs database design, requirements analysis, and benchmarking for clinical, administrative, and financial information systems.
Performs status reporting to IT and user management.
Sets design, test, documentation and implementation standards in accordance with HIPAA and other patient data management policies and ensures clinical system databases adhere to them.
Data architecture and data analysis expertise.
ETL experience in MSIS, Informatica, or similar toolset preferred.
Healthcare experience preferred.
Knowledge of data extraction from databases and other systems.
Knowledge of database and application object management including DDL, table constraints and triggers, clusters, object storage allocation and tuning, indexing options and tradeoffs, partitioning, etc.
Knowledge of performance tuning including methodology, approaches, and facilities (traces, auditing, support scripts, and third party).
Solid UNIX shell programming skills and knowledge of AIX including UNIX commands, shells and shell programming, etc., or solid Windows Server skills and knowledge with versions 2000-2008.
Ability to communicate effectively both verbally and in writing.