POSITION SUMMARY
The Sr. Database Administrator (DBA)/Software Engineer is responsible for administering, managing, designing, documenting and evaluating systems that would require a database. This position will define and lead as the established resource within the department for assistance, preforming complex technical, analytical and professional services throughout the hospital databases including Web sites, managing and monitoring interfaces and problem resolution as it applies to the functions of this position.
POSITION REQUIREMENTS
- Licensure/Certification/Registrations: None
- Education: A Bachelor of Science required, preferably in computer science or related field. Master’s degree in computer science or related field is desired.
- Experience: Minimum of 5 years’ experience in software development and as a database administrator. Database development and maintenance experience with Microsoft SQL Server (2016-2019) in a Windows environment including ETL processing. Software developer using SQL, SSIS and SSRS. Knowledge of Web development using .NET, ASP, HTML, Bootstrap 4 and MVC methodology required.
- Skills & Abilities: Demonstrated knowledge of complex database management concepts in relevant database environments. Strong understanding of Microsoft and cloud environments. Demonstrated database development, implementation, and maintenance skills. Knowledge of how to model and normalize data structures and writing stored procedures. Sound query and report writing skills. Knowledge and practice of System Development Life Cycle Methodology concepts, including: systems analysis, requirements gathering, design, development, testing, implementation, documentation, training and support. Web development skills for creating web applications attached to databases. Proven analytical, problem-solving, and troubleshooting skills. Commitment to quality and results. Strong customer-oriented people skills. The ability to work independently, organize time effectively, meet project timelines, coordinate and work with others. Able to manage multiple projects efficiently. Communicate well both orally and in writing with internal and external customers (both technical and non-technical audiences). Provide friendly and courteous customer centered support. Maintain good interpersonal relationships.
ESSENTIAL FUNCTIONS
- Established as the resource for troubleshooting issues related to databases including data extracts and interfaces to other systems, as well as, QA support on new system implementations.
- Administer the technical aspects of all hospital databases.
Defines high level standards for database management and software development as it relates to programming, access and data security. - Manage the performance and data integrity of all databases. Promote consistency in scope, meaning, normalizing and handling of data throughout the hospital.
- Manage data security as it applies to databases, reporting and interface to applications.
- Identify, implement and improve database monitoring, capacity planning, and performance monitoring processes and tuning.
- Demonstrate in-depth knowledge of data protection strategies for the implemented database platforms. This includes backup and recovery, replication, high availability, point-in-time restores, etc.
- Work with vendors, internal IT teams and users in the implementation of new applications including database install, upgrade, and configuration. all applications.
- Demonstrate the ability to clearly understand user’s data needs and then identify how to best meet those needs with the database resources available.
- Triages more complex user issues and handle escalations from other staff members.
- Compile with and influence change to all applicable corporate and departmental software policies, standards, and practices including all standards relating to Security and Disaster Recovery.
- Lead and mentor junior database administrators by demonstrating leadership qualities and provide recommendations to management to sustain business growth.
- Act as an escalation point for issues other DBAs can’t solve.
- Decide when major process changes need to be made for database management. Implement process changes, or institute a high level design and delegate the implementation. Develop custom queries and reports using approved tools.
- Assist in the development and maintenance of the hospital’s web sites for internally developed applications.
- Work with other IT staff to accomplish hospital information management goals.
- Ability to drive tasks to completion and take ownership of projects.
- Participate in 7/24 on-call rotation and responsibilities.
** This job description is not intended to be an exhaustive list of all duties. Employee may perform other related duties as assigned
POSITION RESPONSIBILITIES/DUTIES
This section is meant to provide an employee with a summary of major responsibilities and duties that they may be expected to complete in this position. The following duties ARE NOT intended to serve as a comprehensive list of all duties performed by employees in this position. Employees may be required to perform additional duties not listed in this section.
- Demonstrate a clear understanding of the databases in the hospital’s environment, their structure and association with applications and other databases. Maintain adequate documentation of these databases.
- Work with vendors, users, and other IT staff to install, upgrade, and configure all databases, and applications.
- Work with users and other IT staff to design, develop, implement, and maintain custom databases.
- Follow approved change management policies and procedures for database functions. In addition, follow approved support and resolution procedures for database or application issues.
- Attend relevant training and conferences to maintain and improve technical knowledge
- Become familiar with and follow hospital wide and department specific policies and procedures; seeking assistance from management when clarification or assistance is needed.
- Assisting other staff members or IT department team members as needed
Compensation: $55/hr-$65/hr depending on experience!