Cloud Database Engineer

Tyler Technologies - Park, KS

Full-time

Park, KS

Professional, Scientific, and Technical Services

About the position

We are seeking an experienced Database Administrator (DBA) 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 requires hands-on experience with database management and a solid understanding of IaC tools and practices. The DBA will play a critical role in maintaining the performance and security of our database environments, ensuring high availability and compliance with industry regulations. In this position, the DBA will be proficient in Microsoft SQL Server administration, which includes installation, configuration, and maintenance. The candidate should have experience with SQL Server high availability and disaster recovery solutions, such as AlwaysOn Availability Groups, log shipping, and database mirroring. Familiarity with SQL Server backup and restore strategies, performance tuning techniques, and security features is essential. The DBA will also administer, monitor, and maintain various databases, including SQL Server and NoSQL databases, to ensure optimal performance and security. The role will involve developing and managing IaC scripts and templates using tools like Terraform and Ansible to provision and manage database infrastructure. The DBA will implement automated deployment pipelines for database changes and configurations, collaborating closely with DevOps and development teams to integrate IaC practices into the database lifecycle. Additionally, the DBA will create and maintain scripts for automated database tasks, monitoring, and reporting, and develop custom automation solutions to enhance database management processes. Collaboration with product and development teams is crucial to understand database requirements and provide effective solutions. The DBA will troubleshoot and resolve database-related issues and performance bottlenecks while ensuring that database environments comply with security policies and industry regulations. This includes implementing and enforcing database security practices, such as access controls and encryption.

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

• Microsoft SQL Server certifications (e.g., MCSA, MCSE) are a plus.
• IaC or DevOps certifications (e.g., Terraform, AWS Developer) are a plus.