Cloud Database Engineer

$81,688 - $130,000/Yr

Tyler Technologies - Yarmouth, ME

Full-time

Yarmouth, ME

Professional, Scientific, and Technical Services

About the position

We are seeking an experienced Cloud Database Engineer with a strong background in AWS database services, including Amazon DynamoDB, Amazon Aurora, and Amazon RDS, as well as Infrastructure as Code (IaC) practices. The ideal candidate will be responsible for managing, optimizing, and automating our database infrastructure to ensure it is scalable, reliable, and efficient. This role is crucial as it supports various areas of the company, impacting team members, clients, stakeholders, and the public sector. As a Cloud Database Engineer, you will be involved in the administration of Microsoft SQL Server, including installation, configuration, and maintenance. You will also be expected to implement high availability and disaster recovery solutions, manage database backups and restores, and optimize performance through various techniques. Your expertise in SQL Server security features will be essential to ensure compliance with security policies and industry regulations. In addition to database management, you will develop and manage IaC scripts and templates using tools such as Terraform and Ansible. This includes creating automated deployment pipelines for database changes and collaborating with DevOps and development teams to integrate IaC practices into the database lifecycle. You will also be responsible for troubleshooting and resolving database-related issues, ensuring that our database environments are secure and compliant with relevant regulations.

Responsibilities

• 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.
• 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.
• 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.
• Create and maintain scripts for automated database tasks, monitoring, and reporting.
• Develop custom automation solutions to improve database management processes.
• Work closely with product and development teams to understand database requirements and provide solutions.
• Troubleshoot and resolve database-related issues and performance bottlenecks.
• Ensure database environments comply with security policies and industry regulations.
• Implement and enforce database security practices, including access controls and encryption.

Requirements

• 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 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.

Nice-to-haves

• Experience with other database systems such as Oracle, MySQL, PostgreSQL, or MongoDB.
• Microsoft SQL Server certifications (e.g., MCSA, MCSE).
• IaC or DevOps certifications (e.g., Terraform, AWS Developer).

Benefits

• Competitive salary range between $81,688 - $130,000 before adjustment for geographic differences.
• Health and wellness benefits to support team members and their families.