SmithRx
SmithRx is a tech-forward PBM committed to changing the way pharmacy benefits are managed.
Senior Database Administrator
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