Database Analyst -Oracle (Remote - 23-22)

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.

Required Duties and Responsibilities

Database Administration:

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

Loading Customer Data:

• 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.
• This also includes developing or installing any customer data interfaces (sqlldr, SQL, PL/SQL).

Maintaining Customer Data:

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

Customer Relations:

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

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.

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

Technical Requirements:

• Strong Knowledge of SQL, PL/SQL, T-SQL
• Strong Knowledge of Oracle 11g, 12c, and 19c
• Strong knowledge in ETL operations and data integrations between various system
• Strong knowledge of SQLLDR
• Knowledge of Data Pump Export & Import
• Knowledge of Functions, Procedures and Triggers
• Knowledge of Backup and Recovery procedures, Database Switchovers (RMAN, Data Guard, Fast Start Failover)
• Knowledge of SQL development tools such as SQL Developer
• Knowledge of using a SSH client o work on Linux servers and transfer files
• Linux Shell Scripting (Bash, and Vi)
• Database Performance Tuning
• Understanding of Oracle Network
• HL7 - ADT Patient feed experience
• Medical Institution experience
• Oracle Certification a plus

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