Sr. SQL Server Database Administrator 9/16/2016

Partners HealthCare(PHS) Charlestown, MA

Company
Partners HealthCare(PHS)
Job Classification
Full Time
Company Ref #
3025078
AJE Ref #
576198533
Location
Charlestown, MA
Experience
Mid-Career (2 - 15 years)
Job Type
Regular
Education
Bachelors Degree

JOB DESCRIPTION

APPLY
As a not-for-profit organization, Partners HealthCare is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Womens Hospital and Massachusetts General Hospital, Partners HealthCare supports a complete continuum of care including community and specialty hospitals, a managed care organization, a physician network, community health centers, home care and other health-related entities. Several of our hospitals are teaching affiliates of Harvard Medical School, and our system is a national leader in biomedical research.

Were focused on a people-first culture for our systems patients and our professional family. Thats why we provide our employees with more ways to achieve their potential. Partners HealthCare is committed to aligning our employees personal aspirations with projects that match their capabilities and creating a culture that empowers our managers to become trusted mentors. We support each member of our team to own their personal developmentand we recognize success at every step.

Our employees use the Partners HealthCare values to govern decisions, actions and behaviors. These values guide how we get our work done: Patients, Affordability, Accountability & Service Commitment, Decisiveness, Innovation & Thoughtful Risk, and how we treat each other: Diversity & Inclusion, Integrity & Respect, Learning, Continuous Improvement & Personal Growth, Teamwork & Collaboration.
GENERAL SUMMARY/OVERVIEW

Top level technical expert responsible for all aspects of SQL database administration including designing, testing, updating, maintaining, patching, and monitoring. Expert in database creation and implementation. Defines standards for database access, structure, functional capabilities, etc. Performs system quality analysis and maintenance of databases. Provides technical consulting on complex issues/projects. Ability to maintain the highest standard of data security and confidentiality. Advises users and colleagues on problems and priorities. Makes recommendations to management on strategy and long-term database needs. Acts independently under general direction.


PRINCIPAL DUTIES AND RESPONSIBILITIES

Database administration, performance monitoring/troubleshooting, and capacity planning
Complex problem analysis and recovery
Technical consultation on complex issues/projects
Complex database design, testing, debugging, and documentation
Technical support and troubleshooting of database servers
Data integrity, backups, restores, and disaster recovery
Database software installation and database configuration
Selection and evaluation of tools/products related to database administration
Instructing, directing, and verifying the work of other DBAs
Collaboration with vendors for problem analysis/resolution
Coordination of activities across multiple teams
Proactive identification/coordination/implementation of opportunities to enhance database support Use the Partners HealthCare values to govern decisions, actions and behaviors. These values guide how we get our work done: Patients, Affordability, Accountability & Service Commitment, Decisiveness, Innovation & Thoughtful Risk, and how we treat each other: Diversity & Inclusion, Integrity & Respect, Learning, Continuous Improvement & Personal Growth, Teamwork & Collaboration.

BS in Computer Science or equivalent experience
5 years database administration experience (2 years with SQL Server 2008/2012/2014) in a networked environment including knowledge of complex SQL commands and structures.

SKILLS/ABILITIES/COMPETENCIES REQUIRED



Strong commitment to customer service
Excellent interpersonal skills to effectively communicate with cross functional teams including staff at all levels of the organization including both technical and non-technical personnel
Ability to successfully negotiate and collaborate with others of different skill sets, backgrounds and levels within and external to the organization
Ability to multitask and prioritize work requirements
Expert knowledge of relational database concepts
Expert knowledge and skill with relational database structures, and structured query language (SQL)
Expert knowledge of referential integrity, triggers, and stored procedures
Expert knowledge of Relational Database Systems: Microsoft SQL Server 2008, 2012, and 2014
Strong project management skills

WORKING CONDITIONS

Office or cubicle
Climate controlled lab
Rotational 7 x 24 on-call (~2 week per month)
Remote access capabilities provided
Epic (vendor) certification will be encouraged. Travel to Wisconsin to acquire the certification training and testing is expected

Partners HealthCare is an Equal Opportunity Employer & by embracing diverse skills, perspectives and ideas, we choose to lead. All qualified applicants will receive consideration for employment without regard to race, color, religious creed, national origin, sex, age, gender identity, disability, sexual orientation, military service, genetic information, and/or other status protected under law.