Senior Database Engineer - DBA

19 hours ago

Apply Now

Receive Emails with Similar Jobs

ProgenyHealth, LLC

WebsiteLinkedInAll Job Openings

neonatal care • utilization review • case management • managed care • low birth weight

201 - 500

Description

• We are seeking a skilled and experienced Sr. Database Engineer to join our team. • The ideal candidate will play a critical role in designing, developing, and maintaining our Enterprise Data Warehouse (EDW) as well as our in-house applications (OLTP/TSQL/DBA). • Manage database security, alerting, backup, and recovery strategies to ensure data integrity and availability. • Design, develop, and maintain the Enterprise Data Warehouse (EDW) to ensure high performance, scalability, and reliability. • Write efficient SQL queries and scripts to support data extraction, transformation, and loading (ETL) processes as well as writing/troubleshooting TSQL for OLTP applications. • Optimize database performance by analyzing, monitoring, and fine-tuning SQL queries and database structures. • Collaborate with Enterprise Analytics Sr Director and team to design and implement data models and database structures that support business requirements. • Collaborate with Software Engineering team to design databases optimized for transaction SQL and document the schemas using tools such as Schema Spy. • Develop and maintain data pipelines to ensure seamless data flow between various source systems and the EDW. • Perform regular data quality checks and troubleshooting to ensure the accuracy and consistency of data in the EDW. • Monitor and maintain the performance of databases, addressing any issues related to performance, latency, and storage. • Work with development teams to integrate databases with applications and ensure seamless interaction between data services and business systems. • Keep up to date with emerging trends and best practices in database engineering, data warehousing, and SQL optimization.

Requirements

• Bachelor’s degree in Computer Science, Information Technology, or a related field. • Proven experience as a Database Engineer with 10 or more years of experience in a healthcare environment, with a focus on SQL, OLTP and Enterprise Data Warehousing. • Proficiency in SQL including query writing, optimization, and troubleshooting. • Strong knowledge of data modeling and database design principles. • Experience with ETL processes and data integration tools (e.g., SSIS, Azure Data Factory, Informatica, Talend, etc.). • Understanding of data security, backup, and recovery procedures. • Strong problem-solving skills and attention to detail. • Knowledge of Agile methodologies and experience working in Agile environments. • Strong communication skills working across business functions (Software Development, Clinical, IT, Client Services, etc.). • Manage multiple projects, issues, and deliverables in a fast-paced environment. • Able to multi-task and prioritize work to meet deadlines. • Excellent listening, critical thinking, written and verbal skills. • Works independently and within a team environment. • Experience working in a professional environment with clinical managed care concepts, practices and procedures preferred. • Able to travel to company Headquarters in Plymouth Meeting 2 - 4x annually.

Benefits

• Paid Time Off • Paid Parental Leave • Medical, dental, vision benefits • 401K with company match • Short- and Long-Term Disability • Group Life Insurance • Tuition reimbursement • Professional development opportunities • Business Casual work environment