What are the responsibilities and job description for the Sr Database Engineer/DBA position at ProgenyHealth LLC?
Job Description
Job Description
Description : Job Role
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). The role requires a deep understanding of SQL, data modeling, and optimization to ensure the efficiency, scalability, and reliability of our data infrastructure.
Responsibilities Include :
- 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 :
Company Benefits
Some of the benefits we offer our team are :
ProgenyHealth positively recruits people from diverse backgrounds, including individuals with disabilities - if you need an accommodation to interview, please contact us by email : careers@progenyhealth.com
Equal Opportunity Employer, including individuals with disabilities and veterans.