Senior Database Administrator (DBA)
Location: Remote
Type: Full-timeAbout the Role
We are seeking an experienced and proactive Senior Database Administrator to join our growing team. In this role you will manage and optimize our diverse database infrastructure including Amazon RDS (SQL Server and PostgreSQL) Amazon Redshift and related cloud data services. You will also support data replication frameworks (e.g. AWS DMS Debezium) and collaborate with our DevOps and development teams on performance tuning maintenance and high availability strategies.
You should bring a strong track record in enterprise-level database performance management installations upgrades and troubleshooting. Familiarity with modern tools such as GitLab Jira and AWS S3 is expected.
Key Responsibilities
- Administer monitor and maintain our RDS SQL Server PostgreSQL and Redshift databases.
- Implement best practices for database security performance tuning and backup/restore.
- Troubleshoot and resolve database performance and reliability issues.
- Support schema changes database upgrades and patching processes.
- Work with data replication tools including AWS DMS and Debezium to ensure consistent and efficient data movement.
- Automate routine database maintenance tasks using scripting or orchestration tools.
- Collaborate with engineering and DevOps teams to align on CI/CD processes (e.g. GitLab pipelines).
- Provide guidance on capacity planning and resource utilization.
- Contribute to disaster recovery strategies including backups to S3 and recovery testing.
- Participate in incident management and on-call rotations as needed.
Requirements
- 5 years of experience as a Database Administrator ideally in a cloud-focused environment
- Expert-level knowledge of Microsoft SQL Server administration and PostgreSQL
- Proven experience managing Amazon RDS Redshift and cloud-based database solutions
- Strong performance tuning and query optimization skills
- Hands-on experience with database replication tools (AWS DMS Debezium preferred)
- Proficient with infrastructure-as-code and CI/CD practices (GitLab)
- Solid understanding of issue tracking and agile processes (Jira)
- Knowledge of AWS S3 for data storage and backup solutions
- Excellent troubleshooting and problem-solving skills
- Strong communication and teamwork abilities
Nice to Have
- Experience with other relational or NoSQL technologies
- Certifications in AWS or relevant database platforms
- Knowledge of infrastructure automation tools (e.g. Terraform CloudFormation)
- Exposure to data warehousing best practices in Redshift