Senior Database Administrator

Job not on LinkedIn

November 20

Apply Now

Receive Emails with Similar Jobs

SmithRx

WebsiteLinkedInAll Job Openings

Healthcare Insurance • SaaS • B2B

SmithRx is a transparent, pass-through pharmacy benefits manager (PBM) that operates independently from insurance companies and pharmacies to align its incentives with self-insured employers and their members. By leveraging modern technology, SmithRx aims to reduce the cost and complexity of pharmacy benefits, ensuring the delivery of effective and low-cost drugs. The company is dedicated to transforming the pharmacy benefits landscape through its flat-rate, transparent pricing model and innovative cost savings programs, which connect members to the lowest cost drugs without the use of spread pricing, rebates, or other tactics. SmithRx's commitment to transparency and superior customer service results in significant savings for employers and a highly satisfactory experience for its members.

51 - 200 employees

Founded 2018

⚕️ Healthcare Insurance

☁️ SaaS

🤝 B2B

💰 $20M Series B on 2022-03

📋 Description

• Manage and maintain our PostgreSQL, DynamoDB and Athena databases running on AWS Cloud, ensuring high availability and reliability. • Monitor the performance and overall health of our databases, proactively identifying and resolving the issues. • Design and implement growth strategies for our databases, ensuring they can handle the rapidly increasing demands of our organization. • Develop, implement and maintain very high security standards to protect our highly sensitive PHI data from both external and internal threats. • Ensure compliance with various database privacy regulations and frameworks like HIPAA, SOC2 etc. • Design and implement Business Continuity Plan(BCP) and Disaster Recovery(DR) Plan. • Develop and maintain a pipeline to restore anonymized data from production to the lower environments. • Work closely with the security team to develop comprehensive risk analysis and response for data infrastructure. • Collaborate with development, architecture, and release teams providing architectural design recommendations to effectively adapt the database environment to support new platform features and capabilities. • Work closely with the Data Engineering team to build, maintain and troubleshoot ETL jobs for downstream applications. • Support software development teams to drive proper coding practices and assist in the development of complex queries, tuning of DML.

🎯 Requirements

• 5+ years of experience in Database Administration. • BS or advanced degree in computer science or other related field. • Experience working and managing SQL and NoSQL databases like PostgreSQL, MySQL, Redis, Redshift, DynamoDB, BigQuery, MongoDB, Cassandra and Snowflake • Deep understanding of AWS Database services, especially AWS RDS, Aurora, Redshift, DynamoDB etc. • Ability to use tools to identify bottlenecks or performance problems enabling query and schema optimization. • Experience using modern monitoring tools like Cloudwatch, DataDog etc., and establishing metrics, monitoring, alarming and dashboards. • Experience managing change management practices, policies and procedures. • Experience with infrastructure automation, systems reliability, load balancing, monitoring, logging. • Experience working in and architecting for regulated environments with data privacy regulations like GDPR, HIPAA preferred. • Strong scripting skills in SQL, Python, Shell etc.

🏖️ Benefits

• Highly competitive wellness benefits including Medical, Pharmacy, Dental, Vision, and Life Insurance and AD&D Insurance • Flexible Spending Benefits • 401(k) Retirement Savings Program • Short-term and long-term disability • Discretionary Paid Time Off • 12 Paid Holidays • Wellness Benefits • Commuter Benefits • Paid Parental Leave benefits • Employee Assistance Program (EAP) • Well-stocked kitchen in office locations • Professional development and training opportunities