Database Administrator

The Database Engineer is responsible for supporting and maintaining cloud-based database systems to ensure reliable data storage and retrieval. This individual will work closely with application teams, infrastructure teams, and other stakeholders to implement and support scalable and secure database solutions in the cloud environment.

Essential Job Responsibilities Include:

Database Design and Implementation: Design, develop, and implement cloud-based database solutions in collaboration with development teams. Create database schemas, tables, and indexes to support efficient data storage and retrieval.

Cloud Database Administration: Manage, monitor, and optimize cloud database instances to ensure high availability, performance, and data integrity. Configure and maintain database backups, replication, and disaster recovery strategies.

Performance Tuning and Optimization: Identify and resolve database performance issues, including query optimization, index tuning, and resource utilization. Monitor database performance metrics and implement improvements to optimize performance.

Data Security and Compliance: Implement and maintain appropriate security measures and access controls to protect sensitive data stored in the cloud database. Ensure compliance with data protection regulations and industry best practices.

Database Monitoring and Troubleshooting: Monitor database activity and performance using database monitoring tools. Diagnose and resolve database-related issues and incidents, working closely with cross-functional teams to ensure timely resolution.

Database Capacity Planning: Estimate future database storage and performance requirements based on data growth projections. Plan and implement database capacity upgrades or scaling activities to accommodate evolving business needs.

Database Automation and Scripting: Develop and maintain database automation scripts, workflows, and configurations using scripting languages (e.g., SQL, Python) and infrastructure-as-code tools (e.g., Ansible). Implement CI/CD practices for database deployment and management.

Collaboration and Communication: Collaborate with DevOps, QA, and product development teams to understand database requirements, provide technical guidance, and ensure effective integration with other systems. Communicate database-related updates, issues, and recommendations to relevant stakeholders.

Continuous Learning and Adaptation: Continuously enhance technical skills and knowledge to adapt to evolving cloud environments and emerging database technologies.

Required Skills / Experience:

• 3-5 years of Database Administration experience with Postgres.
• Have knowledge of cloud computing concepts, virtualization, and infrastructure-as-a-service (IaaS) platforms

Ability to use Data Observability tools (DataDog, etc)

• Knowledge of infrastructure automation technologies and how it interacts with CI/CD processes overall.
• Familiarity with automation scripting languages and tools (Terraform, Ansible, Python, Powershell, etc.)
• Inquisitive personality and willingness to learn and adapt to business processes and new technologies
• Team player with strong interpersonal skills, can report business impact to the lay person, and is persuasive in recommending solutions to a technical audience
• Some nights and weekends (roughly monthly) required