Description
We are seeking an experienced DBA with a strong background in AWS database services (e.g. Amazon DynamoDB, Amazon Aurora, Amazon RDS) and Infrastructure as Code (IaC) to manage, optimize, and automate our database infrastructure. The ideal candidate will have hands-on experience with database management and a solid understanding of IaC tools and practices to ensure our database environments are scalable, reliable, and efficient.
Responsibilities
- Microsoft SQL Server:
- Proficient in Microsoft SQL Server administration, including installation, configuration, and maintenance.
- Experience with SQL Server high availability and disaster recovery solutions (e.g., AlwaysOn Availability Groups, log shipping, database mirroring).
- Familiarity with SQL Server backup and restore strategies, including native and third-party tools.
- Knowledge of SQL Server performance tuning techniques, such as indexing, query optimization, and database maintenance plans.
- Experience with SQL Server security features, including authentication, auditing, and encryption.
- Database Management:
- Administer, monitor, and maintain databases (SQL Server, NoSQL, etc.) to ensure high availability, performance, and security.
- Perform database backups, restores, and disaster recovery operations.
- Optimize database performance through indexing, query optimization, and other best practices.
- Infrastructure as Code (IaC):
- Develop and manage IaC scripts and templates using tools such as Terraform and Ansible to provision and manage database infrastructure.
- Implement automated deployment pipelines for database changes and configurations.
- Collaborate with DevOps and development teams to integrate IaC practices into the database lifecycle.
- Automation and Scripting:
- Create and maintain scripts for automated database tasks, monitoring, and reporting.
- Develop custom automation solutions to improve database management processes.
- Collaboration and Support:
- Work closely with product and development teams to understand database requirements and provide solutions.
- Troubleshoot and resolve database-related issues and performance bottlenecks.
- Security and Compliance:
- Ensure database environments comply with security policies and industry regulations.
- Implement and enforce database security practices, including access controls and encryption.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
- Proven experience as a Database Administrator, with a focus on database management and performance optimization.
- Hands-on experience with IaC tools such as Terraform and Ansible.
- Proficiency with Microsoft SQL Server and experience with other database systems such as (but not limited to) Oracle, MySQL, PostgreSQL, or MongoDB.
- Microsoft SQL Server certifications (e.g., MCSA, MCSE) are a plus.
- IaC or DevOps certifications (e.g., Terraform, AWS Developer) are a plus.
- Strong understanding of database architectures, indexing strategies, and query optimization.
- Experience with AWS and their database services.
- Knowledge of scripting languages (e.g., Python, Bash, PowerShell) for automation purposes.
