Senior Database Administrator

POSITION SUMMARY

Responsible for maintaining and supporting the relational database systems in Linux and Microsoft Windows environments. The Senior Database Administrator is an integral part of the Information Technology Department and is responsible for the efficient and effective management of the corporation’s electronic data. The Senior Database Administrator must maintain highly available, stable, secure and recoverable databases.

ESSENTIAL DUTIES & RESPONSIBILITIES

All duties and responsibilities are to be performed in accordance with VITAS Healthcare Corporation’s policies, procedures, guidelines, contractual commitments and governmental regulations.

• Maintain stable test, training, reporting and production database environments.
• Provide on-call support and for the timely and accurate resolution of problems for all non-development database systems.
• Participate in all phases of projects that interact with the database systems.
• Work with application programmers on the use of database tools, techniques and concepts.
• Assist application developers with writing efficient SQL.
• Plan, install, coordinate and implement programs, interfaces, scripts, products and tools that ease the administration and monitoring of databases.
• Develop and maintain standards to effectively monitor system performance.
• Maintain adequate backups of all critical databases according to disaster recovery procedures.
• Keep current on all new DBMS releases to exploit new functionality.
• Coordinate and perform database upgrades, installs and testing.
• Provide support to the corporation in handling the daily scheduled database production jobs.
• Perform table modifications, database sizing, security and referential integrity administration.
• Devise database reorganization and tuning strategies for optimum performance.
• Make recommendations to senior IT and/or Vitas personnel on the most cost-effective technical solutions specific to the performance and administration of the database during project design and implementation.
• Prepare, execute and document Disaster Recovery procedures for all database systems and co-ordinate recovery activities with the Disaster Recovery team.
• Produce monthly reports of database growth and level of activity for critical databases.
• Performs related duties as required. This position description in no way states or implies that these are the only duties to be performed by the employee occupying this position. Employees will be required to perform any other job-related duties assigned by their supervisor or management.

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

Experience:

• Three to five years’ DBA experience with Sybase and MS SQL server.
• Two to three years’ DBA experience with distributed databases. PostgresSQL, CockroachDB is a plus.
• Working knowledge of SQL Server internals.
• Experience with sql scripting, stored procedures and triggers.
• Ability to develop and maintain Linux and Windows shell scripts and cron jobs used to monitor resource usage and contention.
• Experience deploying and maintaining containerized applications.
• Experience implementing and maintaining Flink/Kafka data pipelines.
• Working knowledge with data flows from on-premises to Cloud. Kingswaysoft experience is a plus.
• Working knowledge of SSIS deployment techniques.
• Working knowledge of network connectivity and interoperability for multi-platform environments.
• Proven production support background of application databases in a 24 X 7 environment.
• Strong problem solving and analytical skills are necessary for this position.
• Database administration certification supplements the position skill base and is considered a plus.
• Ability to express complex technical concepts effectively, both verbally and in writing.
• Excellent time management and organizational skills are necessary for this position.
• Ability to work independently with limited supervision.
• Ability to work well with people from different disciplines with varying degrees of technical experience.
• Ability to work on various assignments simultaneously.
• Ability to communicate tactfully, verbally and in writing with department heads, managers, coworkers and vendors to resolve problems and negotiate resolutions
• Working knowledge of computers, internet access, and the ability to navigate within an automated systems as well as a variety of software packages such as Outlook, Excel and Word.

Education:

• Associate’s degree in computer science or related field from an accredited college or university or the international equivalent required.

Certification & Licensure:

• None required for this position.

Physical Requirements:

• Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job.