Job Closed
This listing is no longer active.
Senior Database Administrator
Location
United States
Posted
67 days ago
Salary
0
Seniority
Senior
Job Description
Senior Database Administrator
SmithRx
• 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 Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
**What Your Day Might Look Like:** - **Keep systems running**: Monitor, maintain, and support MS SQL Server environments, including high-availability setups (e.g. Availability Groups). - **Solve real issues**: Troubleshoot performance and availability problems, identify root causes, and prevent them from happening again. - **Optimize performance**: Handle tuning, indexing, and automation to keep databases efficient and scalable. - **Ensure resilience**: Manage backup and recovery processes to guarantee data integrity and disaster readiness. - **Maintain security**: Apply patches, manage upgrades, and enforce database security best practices. - **Support operations**: Respond to incidents and support requests, ensuring minimal disruption to business operations. - **Work across technologies**: Contribute to projects involving other database systems (e.g. MongoDB, CockroachDB). - **Operate in the cloud**: Support and optimize cloud-based database environments (primarily Azure).
Are you passionate about AI? 🤖 At Satori Analytics, we aim to change the world one algorithm at a time by bringing clarity to global brands through Data & AI. From cloud-based ecosystems for fintech to predictive models for airlines, our cutting-edge solutions cover the entire data lifecycle—from ingestion to AI applications. As a fast-growing scale-up, our team of 100+ tech specialists—including Data Engineers, Data Scientists, and more—delivers innovative analytics solutions across industries like FMCG, retail, manufacturing and FSI. Join us as we lead the data revolution in South-Eastern Europe and beyond! Ready to work with one of the largest gaming company worldwide? What Your Day Might Look Like: - Keep systems running: Monitor, maintain, and support MS SQL Server environments, including high-availability setups (e.g. Availability Groups). - Solve real issues: Troubleshoot performance and availability problems, identify root causes, and prevent them from happening again. - Optimize performance: Handle tuning, indexing, and automation to keep databases efficient and scalable. - Ensure resilience: Manage backup and recovery processes to guarantee data integrity and disaster readiness. - Maintain security: Apply patches, manage upgrades, and enforce database security best practices. - Support operations: Respond to incidents and support requests, ensuring minimal disruption to business operations. - Work across technologies: Contribute to projects involving other database systems (e.g. MongoDB, CockroachDB). - Operate in the cloud: Support and optimize cloud-based database environments (primarily Azure).
• Manage 19+ MySQL instances across 5 AWS regions • Assist with in-flight project to upgrade MySQL 5.6 to 8.0.43 • Oversee DocumentDB and DynamoDB clusters for high availability and scalability • Implement backup, recovery, and disaster recovery strategies • Ensure PCI DSS compliance and secure encryption of data at rest and in transit • Partner with Development and CloudOps teams to deliver resilient, high-performance database solutions • Maintain and optimize Amazon RDS (MySQL 8.0.x), DocumentDB, and DynamoDB environments
• Install, configure, and upgrade Microsoft SQL Server instances on AWS (EC2, RDS, RDS Custom). • Perform proactive performance tuning, indexing, and query optimization. • Manage database backups, restores, and disaster recovery strategies. • Implement high availability solutions (Always On Availability Groups, replication). • Lead migration efforts from on-premises SQL environments to AWS RDS. • Deploy and manage SQL databases using AWS services such as RDS, Aurora, and EC2. • Utilize AWS tools like CloudWatch, CloudTrail, and IAM for monitoring and security. • Implement Infrastructure as Code using AWS CDK with TypeScript for database provisioning. • Enforce database security policies, encryption, and access controls. • Ensure compliance with industry standards (GDPR, ISO 27001, SOC 2) and internal governance. • Monitor system health and performance metrics. • Troubleshoot database and AWS-related issues promptly. • Maintain detailed documentation of configurations and operational procedures. • Work closely with Cloud Operations and Application teams for migrations and integrations. • Participate in planning and execution of database modernization initiatives. • Participate in a 24/7 on-call rotation to support critical infrastructure, respond to operational incidents, and ensure high availability.
