SmithRx

SmithRx

SmithRx revolutionizes pharmacy benefits with transparent technology, connecting stakeholders for efficient drug delivery and cost savings.

Pharmaceuticals
1K-5K
Founded 2016
$38M raised

Description

  • Manage and maintain PostgreSQL, DynamoDB, and Athena databases on AWS to ensure high availability and reliability.
  • Monitor database performance and health, proactively identifying and resolving issues.
  • Design and implement database growth strategies to support increasing organizational demand.
  • Develop and maintain strong security controls to protect sensitive PHI data.
  • Ensure compliance with database privacy regulations and frameworks such as HIPAA and SOC2.
  • Design and implement business continuity and disaster recovery plans.
  • Build and maintain a pipeline to restore anonymized production data into lower environments.
  • Partner with the security team on risk analysis and response for data infrastructure.
  • Collaborate with development, architecture, and release teams on database architecture and feature support.
  • Work with the Data Engineering team to build, maintain, and troubleshoot ETL jobs for downstream applications.
  • Support software development teams with coding practices, complex queries, and DML tuning.

Requirements

  • 5+ years of experience in database administration.
  • BS or advanced degree in computer science or a related field.
  • Experience managing SQL and NoSQL databases such as PostgreSQL, MySQL, Redis, Redshift, DynamoDB, BigQuery, MongoDB, Cassandra, and Snowflake.
  • Deep understanding of AWS database services, especially AWS RDS, Aurora, Redshift, and DynamoDB.
  • Ability to identify bottlenecks and performance problems to support query and schema optimization.
  • Experience with modern monitoring tools such as CloudWatch and Datadog, including metrics, monitoring, alerting, and dashboards.
  • Experience managing change management practices, policies, and procedures.
  • Experience with infrastructure automation, systems reliability, load balancing, monitoring, and logging.
  • Experience architecting for regulated environments with data privacy regulations such as GDPR and HIPAA preferred.
  • Strong scripting skills in SQL, Python, and Shell.

Benefits

  • Highly competitive wellness benefits including Medical, Pharmacy, Dental, Vision, Life Insurance, and AD&D Insurance.
  • Flexible Spending Benefits.
  • 401(k) Retirement Savings Program.
  • Short-term and long-term disability coverage.
  • Discretionary paid time off and paid company holidays.
  • Wellness benefits and Employee Assistance Program (EAP).
  • Commuter benefits and a well-stocked kitchen in office locations.
  • Paid parental leave and professional development and training opportunities.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

PLM Administrator

Anduril Industries 1K-5K Aerospace & Defense

Anduril Industries is hiring a PLM Administrator in Dublin to support and improve its PTC Windchill-based PLM ecosystem for engineering and operations teams.

Agile ERP Java JavaScript jQuery Linux SQL XML
22 minutes ago

Systems Ops Administrator

Twilio 5K-10K Diversified Telecommunication Services

Twilio is hiring a remote Systems Support & Data Operations Administrator in India to support global sales operations through Salesforce administration, data stewardship, and system process integrity.

ERP Heroku Python Salesforce Salesforce Apex SQL Tableau
1 hour, 22 minutes ago

Data Team Supervisor

A.E. Perkins 201-500 Healthcare payments and benefits technology

The Data Team Supervisor at the company leads a data analysis team supporting data warehouse, reporting, and analytics operations to ensure accurate, efficient data services for the organization.

Power BI SQL SQL Server
2 hours, 22 minutes ago

Data Steward

Dodge Construction Network 251-1K Construction & Engineering

Dodge Construction Network is hiring a remote Data Steward to help maintain the quality, accuracy, and governance of company data used to support construction industry operations and decision-making.

MySQL Oracle PostgreSQL SQL Tableau
2 hours, 22 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers