Database Architect (1021)

A Career That Matters With a Company That Makes a DifferenceWhether you are a professional seeking greater challenge or a student embarking on an exciting new career, Picis, Inc. has opportunities for you. We'll provide all the best tools, from ample training to a comfortable and state-of-the art workplace. If you're ready to make a difference, we would like to hear from you. We invite you to explore the many career opportunities available. Picis, Inc. offers competitive salaries and benefits, including medical insurance plans, retirement savings programs, training, and much more. Description



The Database Architect is responsible for architecting and managing a team of Database Administrators to implement and maintain the product's databases and also, performing problem diagnoses and determining resolutions for application and systems software. The Database Architect will be a key person for all ongoing product development efforts from a database design perspective.

RESPONSIBILITIES:Data modeling, design and optimization for new and existing functionality.Defining migration/conversion strategies from existing data modeling to new structure.Ensure adequate database performance through tuning and optimization within the context of the core transaction engine and enterprise data model.Provide day to day supervision and mentoring of other database developers on the team.Managing SQL code (stored procedures, triggers, database scripts) to implement business logic and database maintenance as well as developing database coding standards and naming conventions.Database performance tuning and troubleshooting.Participation in the design and implementation of a data access layer.Required Experience



QUALIFICATIONS & SKILLS7+ years experience with MS SQL ServerDatabase Architect/Developer with relevant experience in enterprise-class development including all aspects of database design for data warehousing and OLTP information centric-applications.Experience in Design, Implementation, Troubleshoot and Administration ofHigh availability, Failover Clustering solutions.Backup, Disaster Recovery, Replication solutionsHave experience working in data design and development preferably in a healthcare setting.7+ years experience as data modeler/data architect with expertise in data warehousing projects.7+ years of back end application development using Oracle, SQL, Stored Procedures and XML.Experience producing technical design documentation.Bachelor's degree in Computer Science, Engineering, Mathematics or a related field;5-10 years experience leading database design and implementing database applications (transactional and/or data warehouse);Experience with database administration in a development environment;High attention to detail and the ability to thrive in a fast paced, dynamic environment.Healthcare, HL7 experience a strong plus. Submitting a resume online at a job site could cause valuable screening information to be missed.Please apply directly at: http://hostedjobs.openhire.com/epostings/jobs/submit.cfm?fuseaction=dspjob&jobid=241077&company_id=15804&jobboardid=24Picis is an established provider of innovative healthcare information technology solutions designed to transform the delivery of patient care information in the high-acuity areas of the hospital, including the emergency department, operating and recovery rooms and intensive care units. Picis offers the most advanced suite of integrated products focused on these life-critical areas of the hospital where the patients are the most vulnerable, the care process is the most complex and an increasing majority of hospital costs are incurred. Headquartered in Wakefield, Massachusetts, Picis has licensed systems for use in more than 1,000 hospitals in 22 countries. More information is available at http://www.picis.comWe are an Equal Opportunity Employer