Sr. Software Database Engineer - (Remote 24-102)

Spok • Hopkins, MN

434d • Remote

About The Position

The Sr. Software Engineer at Spok, Inc. is responsible for the Care Connect Reporting and Analytics solution, focusing on the future architecture of the Care Connect database. This role requires a results-driven, team-oriented professional with a strong background in database engineering, ETL architecture, and data management principles. The engineer will lead database management efforts, ensuring data integrity and optimizing performance across various systems.

Requirements

• Bachelor degree and 7+ years in IT with a focus on Data Management, ETL/ELT, Data Warehousing, and Data Integration.
• Extensive experience with ETL tools like Informatica PowerCenter and IICS, particularly in data migration and integration between SQL Server and Oracle environments.
• Strong SQL coding skills for data profiling, optimization, and implementation.
• Advanced understanding of relational and dimensional data modeling, data warehousing concepts, and database design.
• Knowledge of master data management, data taxonomies, and data dictionary tools.
• Exposure to DevOps principles for supporting deployment and integration.
• Familiarity with SSRS for building and maintaining reporting solutions.
• Experience in database security and compliance with data governance policies.
• Solid scripting skills in languages like Python, Shell, or PowerShell for database automation.
• Ability to analyze data requirements and communicate complex data solutions effectively with stakeholders.
• Experience managing projects, collaborating across teams, and implementing large-scale data solutions.

Responsibilities

• Design, implement, and maintain complex data models to meet business requirements, ensuring high performance and scalability.
• Develop and optimize complex SQL queries, stored procedures, and functions to support business processes and applications.
• Design and implement ETL processes to move and transform data between SQL Server and Oracle databases, ensuring data integrity and consistency.
• Utilize SQL Query Analyzer, indexing, and partitioning strategies to monitor, troubleshoot, and improve database performance.
• Create and maintain SSRS (SQL Server Reporting Services) reports to deliver accurate, actionable insights.
• Implement and maintain database security measures in compliance with data governance policies and industry regulations (e.g., GDPR, HIPAA if applicable).
• Develop and maintain scripts to automate routine database maintenance, backups, and other processes for data reliability.
• Forecast database growth and recommend scaling solutions to meet future demands.
• Collaborate with data engineers, DevOps, analysts, and business stakeholders to understand data needs and drive efficient, aligned solutions.
• Maintain comprehensive documentation for database structures, ETL processes, performance tuning methods, and security protocols.
• Design and manage data warehouses and data marts, ensuring efficient storage and retrieval of data.
• Apply master data management principles and processes to maintain consistent and reliable data across platforms.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Industry: Telecommunications
• Education Level: Bachelor's degree