Cloud Database Engineer

$81,688 - $130,000/Yr

Tyler Technologies - Troy, MI

posted 7 days ago

Full-time - Mid Level
Troy, MI
Professional, Scientific, and Technical Services

About the position

The Cloud Database Engineer will manage, optimize, and automate database infrastructure, focusing on AWS database services and Infrastructure as Code (IaC). This role is crucial for ensuring scalable, reliable, and efficient database environments that support various stakeholders within the company. The engineer will work closely with product and development teams to meet database requirements and enhance overall performance.

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

Benefits

  • Competitive salary range between $81,688 - $130,000 based on geographic differences.
  • Health and financial wellness benefits for team members.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service