Database Administrator SQL DBA

When Frank Lahey, MD, founded a group practice in 1923, his vision was unique: Every component of a patient's health care would be coordinated under one roof. Today, Lahey Hospital & Medical Center still offers a distinctive patient experience.

See Responsibilities and Ideal Candidates.

* Responsibilities Under the general direction of the Manager, Data Administration, and within established hospital, clinic and department policies and procedures, responsible for all aspects of database administration and support in a multi-vendor, multi-platform computing environment. * As part of the DBA staff, the Database Administrator will be responsible for database software installations, configurations and upgrades, database backups and recoveries, performance tuning and monitoring, and troubleshooting and problem resolution in a mission critical environment. * In addition, the DBA will be responsible for supporting all aspects of application development pertinent to databases, including data modeling, PL/SQL or T-SQL coding, and application tuning. * The DBA will also be expected to serve in an advisory role to the IT organization in the evaluation and selection of DBMS solutions (such as Oracle, SQL Server, Sybase, etc.) if required, as well as oversee the DBA effort in evaluating tools and technologies. * The DBA must expect to play an active role in any future Data Administration pilot project or initiative, and assist any data analyst staff/function with deployment and use of data dictionary/repository modeling software and tools. * The DBA must be highly knowledgeable about industry trends and developments involved in warehousing and data repository concepts, methodologies and solutions. * The DBA may assist the Manager in the selection and appraisal of DBA personnel, staff deployment, and training. Essential Duties & Responsibilities including but not limited to: * Performs DBA activities associated with the design, deployment, use, control, monitoring, support and performance of database management systems to ensure their optimum use within the organization. Institutes administration policies, procedures, techniques and methodologies that enhance database support and provides optimum integrity, performance and availability. * Monitors and measures database performance on multiple platforms. Develops and coordinates backups/recovery features that enhance DBMS operation and availability as needed, without impacting database or application availability. Performs database error log analysis, troubleshoots problems and provides resolutions in a timely manner. Recommends system changes to improve performance, availability and integrity. Evaluates and recommends where appropriate the procurement of tools and third-party solutions that enhance DBMS support, availability and performance. * Assists the application development staff in client/server database design, development, load-testing and validation efforts. Recognizes and identifies areas where DBMS solutions will enhance application performance and user satisfaction. Suggests changes in programming techniques and methodologies to enhance database integrity, performance and availability. Translates application requirements into effective database structures, on-line queries, extracts and reports as needed. Coordinates special data archival needs. Works with applications staff to accommodate special application and database processing requirements. * Assists with the formulation, documentation and publication of organizational standards governing database design, use, control, monitoring, support and performance. Ensures adherence to standards, rules, guidelines and practices involving the same. * Provides expertise to the A/D staff in analyzing the information requirements of new and existing systems, and the migration of legacy systems to client/server or open system solutions. Assists the A/D staff with application software releases as needed. Supports special data archival needs. Coordinates batch executions to accommodate nightly, weekly and monthly application/database processing requirements. * Works with software and third-party vendors to assess DBMS monitoring, reporting, debugging and performance enhancement tools and technologies and their usefulness to the Lahey operational environment. Assists with the evaluation, selection and integration of DBMS tools and technologies. Makes recommendations where appropriate. * Performs system upgrades as needed to maintain currency of vendor releases and does so in a timely manner. Publishes down-time requirements ahead of schedule and at an agreed-upon time so as to lessen impact on development staff. * Assists in the selection of education programs supporting effective use of DBMS technology within the organization. Assists with the training of IS personnel in DBMS programming resources, tools and technologies. * Assists in the administration of enterprise and/or departmental storage as needed. Incorporates storage management strategies into multi-platform, enterprise-wide solutions. Identifies areas where changes in strategy or day-to-day operation will enhance application availability and user satisfaction. Makes recommendations where appropriate. * Informs the IS organization of important industry developments, advances and trends in DBMS-related technologies. Identifies areas where changes in strategy or day-to-day operation will enhance DBMS operation. Makes recommendations where appropriate. * Assists fulfilling administrative reporting requirements pertaining to database availability, performance and use. Informs the Manager of trends, problems or areas of concern requiring attention. * Maintains a positive and cooperative working relationship with all departments to optimize communication and customer satisfaction. * Is required to participate in a rotating on-call schedule supporting 24-hour, 7-day database operations. * May assume duties of a higher level in preparation for increased responsibilities. Performs other related duties as assigned by the Director or the Manager. * Incorporates Lahey Clinic Guiding Principles , Mission Statement and Goals into daily activities. * Complies with all Lahey Clinic Policies. * Complies with behavioral expectations of the department and Lahey Clinic. * Maintains courteous and effective interactions with colleagues and patients. * Demonstrates an understanding of the job description, performance expectations, and competency assessment. * Demonstrates a commitment toward meeting and exceeding the needs of our customers and consistently adheres to Customer Service standards. * Participates in departmental and/or interdepartmental quality improvement activities. * Participates in and successfully completes Mandatory Education. * Performs all other duties as needed or directed to meet the needs of the department. Organizational Requirements: * Maintain strict adherence to the Lahey Hospital and Medical Center Confidentiality policy. * Incorporate Lahey Hospital and Medical Center Standards of Behavior and Guiding Principles into daily activities * Comply with all Lahey Hospital and Medical Center Policies. * Comply with behavioral expectations of the department and Lahey Hospital and Medical Center. * Maintain courteous and effective interactions with colleagues and patients. * Demonstrate an understanding of the job description, performance expectations, and competency assessment. * Demonstrate a commitment toward meeting and exceeding the needs of our customers and consistently adheres to Customer Service standards. * Participate in departmental and/or interdepartmental quality improvement activities. * Participate in and successfully completes Mandatory Education. * Perform all other duties as needed or directed to meet the needs of the department.

* Bachelor's degree in Computer Science. In the absence of a bachelors degree in Computer science, an additional 8 years experience in a production DBMS environment over the experience identified below. * Solid/Expert knowledge of DBA tasks in SQL Server including SQL Server 2005, 2008, and 2012 HA ? must be able to perform installations, tuning and optimization, monitoring, backup/restore, troubleshooting, data replication, D/R & business continuity, clustering, and trend/growth analysis. * Minimum 6 years experience in a production DBMS environment, including experience in the following areas: Database Server Clustering, Mirroring, Replication, performance monitoring and tuning; database error analysis, troubleshooting and problem resolution; DBMS administration tools. * Physical and logical database design * Backup and recovery procedures * Change management procedures, security administration, disaster recovery procedures; scripting, stored procedures, triggers and alerts. * Advanced knowledge of DBMS environments operating in a multi-platform, multi-vendor environment required, as is advanced knowledge of DBMS concepts and support methodologies, including backup and recovery, tuning, monitoring, debugging and trouble-shooting techniques, logical and physical design, stored procedures, triggers and utilities. * Must be detail-oriented, have a professional demeanor, proven analysis and problem-solving abilities, excellent interpersonal and writing skills, on-call skills, and the ability to work with those having wide-ranging levels of expertise.