SmithRx

SmithRx is a tech-forward PBM committed to changing the way pharmacy benefits are managed.

Senior Database Administrator

Full TimeRemoteTeam 51-200Since 2018H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

8 days ago

Salary

Not specified

Bachelor Degree5 yrs expEnglishAmazon RedshiftAWSBig QueryCassandraCloudDynamo DBETLMongo DBMy SQLNo SQLPostgre SQLPythonRedisSQL

Job 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.

Job 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
  • Paid Company Holidays
  • Wellness Benefits
  • Commuter Benefits
  • Paid Parental Leave benefits
  • Employee Assistance Program (EAP)
  • Well-stocked kitchen in office locations
  • Professional development and training opportunities

Related Categories

Related Job Pages