Database Analyst - Remote (23-19)

Description

Overview

This role is responsible for migrating data on customer upgrades (Oracle Data Pump), configuring Oracle High Availability (Data Guard – Fast Start Failover), Oracle database administration in a Linux environment, performing ETL operations and loading customer’s data into the Spok database (sqlldr, SQL, PL/SQL), trouble shooting and assisting Support with database issues, HL7 – ADT patient feed installation and troubleshooting, Database Interfaces development and troubleshooting, configuring Linux services that pertain to DBS related activities (knowledge of bash, crontab, vi, mailx, iptables/firewall-cmd, sftp, etc.), and general database duties including knowledge of RMAN in regards to backup, recovery, and restore.

Duties And Responsibilities

Database Administration:

• Researching new SQL/Oracle products and how they integrate with Spok products.
• Assisting Support with database issues and database switchovers/failovers.
• Configurations of SQL/Oracle products (Data Guard, Fast Start Failover).

Loading Customer Data

• This also includes developing or installing any customer data interfaces (sqlldr, SQL, PL/SQL).
• Migration data from old application to new environment (Data Pump).
• During the implementation or upgrade process the DBA will load the customer data in the Spok schema.

Maintaining Customer Data

• Data cleanup, manipulation, removal, and review of current data within the Spok schema
• This also includes troubleshooting any customer data interfaces (sqlldr, SQL, PL/SQL).
• Data extracts for customer/other review

Customer Relations

• Explaining our database functionality and coordinating database and data projects.
• Works with customers when dealing with database and data related issues.

Communication

• Communicates with various Spok departments regarding their roles and performance requirements.
• Directs and performs follow up as necessary to complete projects and elicit customer satisfaction.

Documentation

• Creates and maintains process, standards, upgrade documentation, failover documentation.

Required Skills And Experience

Bachelor’s degree in Computer Science and two to four years’ experience; or equivalent combination of education and experience.

• Understanding of new system implementation and installation processes
• Demonstrated understanding of impact of current, new and proposed product features
• Willing to identify, own, and solve problems independently and as part of a team
• Able to maintain a pleasant manner in stressful situations.
• Able to work in a team
• Customer Service oriented
• Highly developed analytical and problem solving skills
• Well-developed oral and written communication skills
• Strives to become a self-directed, productive team member, serving as a positive agent of change
• 5+ years SQL or Oracle database experience
• Willingness to work after normal working hours (early AM/weekends)
• Demonstrated effective leadership skills
• Prior experience in computer terminology and practices

Technical Requirements

• Knowledge of using a SSH client to work on Linux servers and transfer files
• Knowledge of SQL development tools such as SQL Developer
• Strong Knowledge of Oracle 11g and 12c
• Strong Knowledge of SQL, PL/SQL, T-SQL
• Strong knowledge of SQLLDR
• Strong knowledge in ETL operations and data integrations between various system
• Knowledge of Data Pump Export & Import
• Knowledge of Backup and Recovery procedures, Database Switchovers (RMAN, Data Guard, Fast Start Failover)
• Knowledge of Functions, Procedures and Triggers

Spok, Inc., a wholly owned subsidiary of Spok Holdings, Inc. (NASDAQ: SPOK), headquartered in Alexandria, Virginia, is proud to be a global leader in healthcare communications. We deliver clinical information to care teams when and where it matters most to improve patient outcomes. Top hospitals rely on the Spok Care Connect® platform to enhance workflows for clinicians and support administrative compliance. Our customers send over 100 million messages each month through their Spok® solutions. When seconds count and patients’ lives are at stake, Spok enables smarter, faster clinical communication. Spok is a trademark of Spok Holdings, Inc. Spok Mobile and Spok Care Connect are trademarks of Spok, Inc.

At Spok, Inc., we provide equal opportunity to all employees and applicants without regard to race, color, creed, religion, national origin, gender, sexual orientation, age, gender identity, genetic information, disability, protected veteran status, marital status, membership or activity in a local human rights commission, status with regard to public assistance or any other protected status or characteristic.

• Should you have a disability and need assistance or accommodation in the application process, contact Human Resources at 1-800-852-8935