[Remote] Sr. Database Administrator (Postgres/MySQL)
Note: The job is a remote job and is open to candidates in USA. Harrier Information Systems is a fast-growing digital transformation services company focused on providing solutions for the global financial services and healthcare industries. They are seeking a Senior Database Administrator to manage and maintain PostgreSQL and MySQL databases, ensuring high availability and compliance with privacy regulations.
Responsibilities
- 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 a 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
Skills
- 7 to 10 Years of experience in Database Administration
- Experience working and managing SQL and No-SQL databases like PostgreSQL, MySQL, Redis, Redshift, DynamoDB, Big Query, 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 Cloud Watch, Data Dog, 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, and logging
- Strong scripting skills in SQL, Python, Shell etc
- Experience working in and architecting for regulated environments with data privacy regulations like GDPR, HIPAA preferred
Company Overview