Search jobs > Portland, ME > Database administrator

Principal Database Administrator

WEX Inc
Portland, ME
$119K-$158K a year
Full-time

The Database Services team supports WEX business critical database systems. As a Principal Database Administrator , you will join a team of DBAs currently supporting over 100 servers.

In order to be successful in this role, you need to be able to work in a fast-paced and constantly changing environment.

You must be a self-starter and professional who can successfully bring projects to closure with a minimum of direction, guidance and oversight.

You also need to be able to manage and balance your time between strategic and tactical activities.

About the role :

You will work with a team of peers to build robust, reliable and effective database management solutions for all lines of business.

You will provide technical direction and database expertise for complex data repository challenges. Build and maintain documentation, internal technical white papers, IT proposals, and vendor requests for information.

You will participate in after-hours project or maintenance work (nights & weekends) and share on-call responsibilities with other team members

You will design, build, implement, support and operationalize WEX business critical database systems.

Experience you'll bring

In-depth (10+ years) Microsoft SQL Server experience

Experience with Windows Failover Clustering, Always On Availability Groups, and other related HA techniques

Expert SQL Server performance troubleshooting and tuning skills (sql and stored procedures)

Strong technical expertise in multiple MSSQL related areas (profiling, extended events, replication, performance tuning, monitoring, data purging / migration techniques, advanced T-SQL writing, automation, etc)

Experience managing SQL Server in AWS (EC2 and RDS)

Experience managing SQL Server in Azure (IaaS and SQL MI / Azure SQL)

Experience and comfort using both Linux and Windows

Exceptional problem-solving abilities

No objections to flexible hours and after hours support for on call rotations

Preferred Experience

PowerShell or comparable scripting languages

Terraform or comparable infrastructure as code tooling

Datadog (configuration, YAML, creating dashboards, custom metrics, and ingesting files)

MSSQL monitoring tools such as SentryOne or SQL Diagnostic Manager

Knowledge, Skills & Abilities :

10+ years of related experience working with multiple versions of SQL Server

Requires strong technical expertise in multiple areas (log shipping, replication, performance tuning, monitoring, data purging / migration techniques, automation, etc)

Experience with long term scalability and capacity planning

Experience in technical lead role on projects

Requires analytical ability, strong judgment, problem solving skills, and effective human relations skills to work cross functionally across the Enterprise with staff and all levels of management in various disciplines

Uses professional concepts and company objectives to resolve complex issues in creative and effective ways.

Ability to function in a complex environment thru multi-tasking and establishing and communicating priorities

Strong interpersonal and communications skills; capable of writing proposals or papers, acting as a vendor liaison, making presentations to customers or client audiences or professional peers, and working closely with upper management and outsourced service providers.

Strong listening and collaboration skills; must work effectively with application developers, QA, and Data Architects.

Strong relational database analysis and design skills; ability to translate business requirements into designs that perform appropriately.

Strong knowledge of T-SQL; ability to transfer knowledge to others.

Expert knowledge of SQL Server internals

Strong problem-solving skills.

Solid understanding of backup / recovery technologies; ability to specify requirements to the Provider and ensure the requirements are met.

Be willing to learn new technologies

Experience with Azure IAAS and PAAS

Ability to apply DBMS features / functions to solve a business problem.

Postgraduate coursework in Computer Science or Business Administration a plus

A positive attitude.

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 : $119,000.00 - $158,000.00

9 days ago
Related jobs
WEX Inc
Portland, Maine

Principal Database Administrator. The Database Services team supports WEX business critical database systems. You will work with a team of peers to build robust, reliable and effective database management solutions for all lines of business. You will provide technical direction and database expertis...

Promoted
PMI (Project Management Institute)
Portland, Maine

JobPosting","title":"Data Engineer II","datePosted":"2024-04-15T00:00:00","validThrough":null,"description":"Data Engineer II (Multiple Openings), Project Management Institute, Inc. Data Engineer II (Multiple Openings), Project Management Institute, Inc. The position requires a minimum of a Bachelor...

Promoted
Smith & Wilkinson
South Portland, Maine

The Data Analyst will utilize a generalist data analytics skillset to significantly impact S&W’s internal business reporting, generate quantitative research content, and improve CRM processes & data accuracy. Capture, clean, organize, & integrate open-source data into proprietary data sets for S&W r...

Promoted
DICE
Scarborough, Maine

The Data Engineer will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross-functional teams. They engage through the entire lifecycle of a project from data mapping, data pipelines, data modeling, and finally d...

Gainwell Technologies LLC
Any city, ME, US

Uses SQL, data models, data element dictionary and schema to perform data and business analysis. Experienced Healthcare Data Analyst. ...

Facility MaineHealth
Portland, Maine

The Pharmacy Smart Infusion Pump Systems Administrator designs, implements and manages the software and processes of the Smart Infusion server and related databases. The system administrator is responsible for the development of reports, coordination of upgrades and new implementations, and drug dat...

CDC Foundation
Maine

The Data Engineer will collaborate with data content experts, analysts, data scientists, data modelers, warehouse architects, IT staff and other organization staff to design and implement proposed solutions and architectures that meet the needs of the public health agency. Design and manage data sto...

Red Hat, Inc.
Remote US ME
Remote

The Red Hat Ceph team is looking for experienced, enterprise-level engineers with a background in Ceph, OpenShift Data Foundations and/or software-defined storage (SDS) technologies to join us as a Senior Technical Support Engineer in North America. As a Senior Technical Support Engineer you’ll work...

WEX Inc
Portland, Maine

As a Product Data Analyst, you will serve as a thought leader within the Product team, using data and analytics to guide key product decisions. Work with product and technology teams to develop measurement plans, ensuring that relevant data is collected and integrated to support product analytics. E...

Highmark Health
ME, Working at Home, Maine

Performs modeling of data sources and flows, works with data management staff to define an operational framework that will define, develop and implement policies and security frameworks to ensure precise and secure delivery of knowledge and information. Perform modeling of data sources and flows, wo...