Login

SQL Server Database Administrator

WEX Inc | Portland, ME, United States

Posted Date 11/21/2024
Full job description

About the 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.

How you’ll make an impact

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

  • 3+ years of overall IT experience working with SaaS or web development
  • 3+ years of hands-on SQL Server Database administration
  • 1-3 years experience with SQL Server Extended Events
  • Proficient using Powershell
  • Experience managing SQL Server Databases in Azure
  • 1-3+ years of hands-on experience with a data ingestion tool (ELT or ETL tools)
  • Experience with Azure DevOps
  • Experience with AWS Core Services (Amazon CloudWatch, Amazon Security Hub)
  • Bachelor's degree in Computer Science, IT, Engineering or related field

Desired Additional Qualifications:

  • Experience with 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 of 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
The base pay range represents the anticipated low and high end of the pay range for this position. Actual pay rates will vary and will be based on various factors, such as your qualifications, skills, competencies, and proficiency for the role. Base pay is one component of WEX's total compensation package. Most sales positions are eligible for commission under the terms of an applicable plan. Non-sales roles are typically eligible for a quarterly or annual bonus based on their role and applicable plan. WEX's comprehensive and market competitive benefits are designed to support your personal and professional well-being. 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.Pay Range: $88,000.00 - $117,000.00
Salary88,000.00 - 117,000.00 Annual
Job Type
Regular
Industry
Information Technology

Share this job