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 Software Engineer-Master Data will have the ability to take on smaller projects from start to finish, work on problems of moderate scope where analysis of situations or data requires a review of a variety of factors and trace issues to their source. Arch/Data Master Data (5119270). This will inc...

Talent Sphere Staffing
, Maine, ,

A Data Entry Specialist will compare data with source documents submitted by our members, checking for accuracy and that supporting documentation meets specified requirements. We are looking for a Data Entry Specialist whose main function is providing excellent customer service by quickly and accura...

TD Bank, N.A.
Falmouth, Maine

The Senior Group Risk Analyst provides a broad range of research, analysis, reporting, monitoring and/or operational process support within a defined area of function. The Senior Group Risk Analyst may support and/or provide oversight, commentary, and strategy analysis in connection to team and/or i...

Tyler Technologies
Yarmouth, Maine

Develop and manage IaC scripts and templates using tools such as Terraform and Ansible to provision and manage database automated deployment pipelines for database changes and with DevOps and development teams to integrate IaC practices into the database lifecycle. The ideal candidate will have ha...

Facility MaineHealth
Portland, Maine

In addition to the minimum knowledge, skills and abilities listed above, experience accessing and integrating, analyzing and reporting on health data from multiple sources, such as national, regional and state databases, as well as survey and medical record data is preferred. CHSE turns data into ac...

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
Remote Office,Maine
Remote

Build systems, platforms, data pipelines, and tools for E-2-E data life cycle, including data ingestion, cleaning, processing, enrichment, optimization, and serving by leveraging the Data platform. For these, you will build data quality measurement & monitoring techniques and systems, metadata and d...