Database Administrator 4

$103,000 - $137,000/Yr

WEX - South Portland, ME

posted 3 months ago

Full-time - Mid Level
South Portland, ME
Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services

About the position

The WEX SQL Server Database Administrator will be responsible for the maintenance, performance, monitoring, and recoverability of the SQL database environments. This role is crucial as it ensures the health and stability of the entire SQL Server Database platform. The administrator will provide support for production databases, focusing on performance monitoring and daily management to prevent data loss, unplanned downtime, or performance degradation. This includes installing, administering, and maintaining schema and data to ensure maximum availability. In addition to routine maintenance, the Database Administrator will analyze and resolve problems associated with server hardware and application software. They will also monitor and optimize data lake ingestion processes, requiring a high-level knowledge of SQL Server internals, database design, T-SQL, backup/restore processes, SSIS, security, and performance tuning and troubleshooting. The role includes participation in a 24x7x365 OnCall Rotation and involvement in Disaster Recovery planning and testing exercises, making it essential for the candidate to be proactive and responsive to database needs at all times.

Responsibilities

  • Provide support for production databases including performance monitoring and daily management to prevent data loss, unplanned downtime, or performance degradation.
  • Install, administer, and maintain schema and data to ensure maximum availability.
  • Analyze and resolve problems associated with server hardware and application software.
  • Monitor and optimize data lake ingestion processes.
  • Participate in a 24x7x365 OnCall Rotation.
  • Participate in Disaster Recovery planning and testing exercises.

Requirements

  • 7+ 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.
  • 5+ years of managing SQL Server Database in Azure.
  • 5+ 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).

Nice-to-haves

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

Benefits

  • Health insurance
  • Dental insurance
  • Vision insurance
  • Retirement savings plan
  • Paid time off
  • Health savings account
  • Flexible spending accounts
  • Life insurance
  • Disability insurance
  • Tuition reimbursement
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service