WEX, Inc.
About the Team & Role
The WEX SQL Server Database Administrator will be responsible for the maintenance, performance, monitoring, and recoverability of the SQL database environments. This role will be part of a team which is responsible for the health and stability of the entire SQL Server Database platform. Responsibilities
Provide support for production databases including performance monitoring, daily management to prevent data loss, unplanned downtime or performance degradation.
Install, administer, and maintain schema and data to ensure maximum availability.
Analyzes and resolves problems associated with server hardware and application software
Monitor and optimize data lake ingestion processes
High level knowledge with SQL Server internals, database design, T-SQL, backup/restore, SSIS, security and understanding of performance tuning and troubleshooting.
Participates in a 24x7x365 OnCall Rotation
Participate in Disaster Recovery planning and testing exercises
Experience you'll bring
5+ years of overall IT experience working with SaaS or web development
5+ years of hands on SQL Server Database administration
3-5 years experience with SQL Server Extended Events
Proficient using Powershell
3+ years of managing SQL Server Database in Azure
3+ years of hands-on experience with a data ingestion tool (ELT or ETL tools)
Experience with Azure DevOps
Bachelor's degree in Computer Science, IT, Engineering or related field
Desired Additional Qualifications
Experience of SQL system DMVs to identify and troubleshoot performance problems
Tuning or refactoring stored procedures to improve performance
Knowledge of supporting SQL Server Availability Groups
Experience with SQL 2019+
Knowledge with ETL tools and management
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
Base pay range: $90,000.00 - $120,000.00. Actual pay rates will vary based on qualifications, skills, competencies, and proficiency for the role. Base pay is one component of the total compensation package. Most non-sales roles are typically eligible for a quarterly or annual bonus based on applicable plan. WEX's benefits include health, dental and vision insurances, retirement savings plan, paid time off, health savings account, flexible spending accounts, life insurance, disability insurance, tuition reimbursement, and more. For more information, check out the About Us section.
#J-18808-Ljbffr
The WEX SQL Server Database Administrator will be responsible for the maintenance, performance, monitoring, and recoverability of the SQL database environments. This role will be part of a team which is responsible for the health and stability of the entire SQL Server Database platform. Responsibilities
Provide support for production databases including performance monitoring, daily management to prevent data loss, unplanned downtime or performance degradation.
Install, administer, and maintain schema and data to ensure maximum availability.
Analyzes and resolves problems associated with server hardware and application software
Monitor and optimize data lake ingestion processes
High level knowledge with SQL Server internals, database design, T-SQL, backup/restore, SSIS, security and understanding of performance tuning and troubleshooting.
Participates in a 24x7x365 OnCall Rotation
Participate in Disaster Recovery planning and testing exercises
Experience you'll bring
5+ years of overall IT experience working with SaaS or web development
5+ years of hands on SQL Server Database administration
3-5 years experience with SQL Server Extended Events
Proficient using Powershell
3+ years of managing SQL Server Database in Azure
3+ years of hands-on experience with a data ingestion tool (ELT or ETL tools)
Experience with Azure DevOps
Bachelor's degree in Computer Science, IT, Engineering or related field
Desired Additional Qualifications
Experience of SQL system DMVs to identify and troubleshoot performance problems
Tuning or refactoring stored procedures to improve performance
Knowledge of supporting SQL Server Availability Groups
Experience with SQL 2019+
Knowledge with ETL tools and management
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
Base pay range: $90,000.00 - $120,000.00. Actual pay rates will vary based on qualifications, skills, competencies, and proficiency for the role. Base pay is one component of the total compensation package. Most non-sales roles are typically eligible for a quarterly or annual bonus based on applicable plan. WEX's benefits include health, dental and vision insurances, retirement savings plan, paid time off, health savings account, flexible spending accounts, life insurance, disability insurance, tuition reimbursement, and more. For more information, check out the About Us section.
#J-18808-Ljbffr