Database Engineer plans, designs, develops, and manages an organization's databases to ensure efficient data storage, access, and security. Collaborates with users to design, code, test, debug, and deploy databases that meet requirements and organizational needs. Being a Database Engineer writes queries, stored procedures and functions for database development. Monitors databases' performance, scalability, and security and modifies procedures to optimize database designs. Additionally, Database Engineer evaluates existing database design to determine necessary updates, performance tuning, and integration requirements. Possesses comprehensive knowledge of database technologies and solid coding and computer system skills. Requires a bachelor's degree. Typically reports to a manager. The Database Engineer work is closely managed. Works on projects/matters of limited complexity in a support role. To be a Database Engineer typically requires 0-2 years of related experience. (Copyright 2024 Salary.com)
About the Team/Role
The WEX DevOps Engineer\ SQL Server Database Administrator will be responsible for all Infrastructure-as-Code for the SQL database environments, as well as automation of tasks to allow for self-service and standardized operations. This role will be part of a team which is responsible for the health and stability of the SQL Server Database platform.
How you'll make an impact
Use of Terraform, YAML, and Powershell to create needed pipelines
Use of Pipelines to create IAAS and PAAS solutions, including SQL Server, Postgres, MySQL
Extensive knowledge of Visual Studio Code and Git
Building of pipelines to accommodate new operations.
Changes to existing pipelines to update or upgrade existing SQL Servers
Work within the Azure environment to improve upon current SQL landscape
Automation of SQL Server patching processes
Mentor the DBA team in DevOps strategies and process
Participate in DBA activities as needed
Experience you'll bring
5 years of overall IT experience working with SaaS or web development
5 years of hands-on DevOps experience
3-5 years experience with SQL Server database experience
Expert in using Terraform, YAML, and Powershell
3 years of IAAS and PAAS experience in Azure
Experience with Azure monitoring and insight services
Experience with Azure DevOps
Desired Additional Qualifications:
Experience in SQL Server Installation and configuration
Experience with Windows Clustering
Experience with SQL Server Always On Availability Groups
Experience with SQL 2016
Knowledge of SSDT projects and experience with Source Control especially TFS and GitHub in Azure DevOps
Knowledge and experience with industry-standard change and incident management procedures
Self-starter capable of working independently or in groups