Senior Database Administrator

Join to apply for the Senior Database Administrator role at Smith Rx
.

Smith Rx is a rapidly growing, venture‑backed Health‑Tech company. Our mission is to disrupt the expensive and inefficient Pharmacy Benefit Management (PBM) sector by building a next‑generation drug acquisition platform driven by cutting‑edge technology, innovative cost‑saving tools, and best‑in‑class customer service. With hundreds of thousands of members onboarded since 2016, Smith Rx has a solution that is resonating with clients all across the country.

We pride ourselves on a mission‑driven and collaborative culture that inspires our employees to do their best work. We believe that the U.S healthcare system is in need of transformation, and we come to work each day dedicated to making that change a reality. At our core, we are guided by our company values:

• Integrity: Our purpose guides our actions and gives us confidence in the path ahead. With unwavering honesty and dependability, we embrace the pressure of challenging the old and exemplify ethical leadership to create the new.
• Courage: We face continuous challenges with grit and resilience. We embrace the discomfort of the unknown by balancing autonomy with empathy, and ownership with vulnerability. We boldly challenge the status quo to keep moving forward—always.
• Together: The success of Smith Rx reflects the strength of our partnerships and the commitment of our team. Our shared values bind us together and make us one. When one falls, we all fall; when one rises, we all rise.

We are looking for an Sr. Database Administrator who has hands‑on experience designing and administering cloud‑based database systems. Additionally, this engineer will be responsible for ensuring the reliability and efficiency of the data infrastructure, including maintenance, upgrades, monitoring, performance tuning, scaling, and query optimization. Our user base is currently doubling annually, and you would share the responsibility of orchestrating a reliable, sustainable, and scalable infrastructure.

• Manage and maintain our Postgre
  
  SQL, Dynamo
  
  DB, 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 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, SOC 2, 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.

• 5+ years of experience in Database Administration.
• BS or advanced degree in computer science or other related field.
• Experience working and managing SQL and No
  
  SQL databases like Postgre
  
  SQL, MySQL, Redis, Redshift, Dynamo
  
  DB, Big Query, Mongo
  
  DB, Cassandra and Snowflake.
• Deep understanding of AWS Database services, especially AWS RDS, Aurora, Redshift, Dynamo
  
  DB, etc.
• Ability to use tools to identify bottlenecks or performance problems enabling query and schema optimization.
• Experience using modern monitoring tools like Cloud Watch, Data Dog, etc., and establishing metrics, monitoring, alarming and dashboards.
• Experience managing change management practices, policies and procedures.
• Experience with infrastructure…