PostgreSQL Database Administrator

Location US-CO-Centennial
ID 2024-1486
Position Type
Regular Full-Time
Remote
No
Min Pay Range
USD $100,000.00/Yr.
Max Pay Range
USD $120,000.00/Yr.

Overview

Fast Enterprises is a provider of essential software and services for citizens and government. In 1998, we changed the way government revenue agencies support their business with the introduction of GenTax®. We have expanded beyond Tax and now also perform implementations for Motor Vehicle, Driver License, Unemployment Insurance, and Child Support Engagement agencies.

 

Your FAST career has a meaningful and lasting social impact. FAST offers a collaborative in-office problem-solving environment.

 

This position will join the Centralized Tech Team at the FAST Headquarters and Development Center in Centennial, CO working fully in-office. Travel will be rare, but you should be flexible and able to travel when required.

Responsibilities

As a PostgreSQL Database Administrator, you will contribute to our core products, perform database administration tasks across instances within Fast Hosting Services, and provide support for client installations with Fast Centralized Tech services.

You will manage PostgreSQL databases across multiple product lifecycle environmentsfrom development to mission-critical production systemswhile configuring and maintaining database servers and processes. 

The FAST application is ODBC compliant. Installations include both Microsoft SQL Server and Postgres, with multiple historical installations in Oracle. This position will focus primarily on Postgres, but you will likely have opportunities to work with SQL Server. 

Key responsibilities of this position include: 

  • PostgreSQL installation and maintenance 
  • Install and configure new database servers using best practices.
  • Knowledge of High Availability (HA) and Disaster Recovery (DR).
  • Upgrade and service pack implementation.
  • Backup and recovery 
  • Ensure all database servers are backed up. 
  • Perform restoration testing.
  • Database maintenance 
  • Define and implement maintenance plans for database systems.
  • Standardize maintenance approaches across systems.
  • Index and statistics maintenance.
  • Database monitoring 
  • Proactively identify, troubleshoot, and resolve live database system issues.
  • Capacity planning and forecasting.
  • Creating and reviewing data access audits.
  • Tracking and reporting on Recovery Point Objectives (RPO) metrics. 
  • Performance and tuning 
  • Identification of queries having the largest performance impact.
  • Improvements to indexes and execution plans.
  • Troubleshoot transaction and concurrency issues. 
  • Assist developers with query optimization.
  • Documentation and training 
  • Create documentation on processes and procedures. 
  • Providing training for developers and other technical resources. 
  • Data conversion 
  • Assist with data migrations between DBMS platforms.

Qualifications

The ideal candidate should be enthusiastic about database administration, a quick learner, and a self-starter. The position is part of a database administration team of 4-5 employees within a technical team of roughly 45 employees, contributing to internal development and client projects across the United States and abroad. 

  • Required Experience 
  • Bachelors degree in computer science or a related field 
  • A minimum of 2-5 years of Postgres experience 
  • A minimum of 2-4 years of database administration experience 
  • A minimum of 1 year of experience performing or supporting application development 
     
  • Additional Qualifications: 
  • SQL Server DBMS experience 
  • Linux OS experience 
  • PowerShell experience 
  • C#, VB.Net, or other object-oriented development language experience 
  • Ability to thrive in a fast-paced environment 
  • Strong understanding of database structure and design principles 
  • Familiarity with database security principles 
  • Solid script skills including PSQL scripting and stored procedures 
  • Familiarity with a variety of installation platforms including Linux, Windows, Cloud, and Cloud provider-managed instances 
  • Effective prioritization of tasks 
  • Successful time management 
  • Demonstrated effectiveness within a team environment 
  • Strong communication skills 

FAST Benefits

  • Throughout your career, you will be rewarded through our merit-based pay structure, 401(k) matching program, and performance based bonuses. 
  • Our exceptional benefits package includes coverage for FASTies and their families. Health, dental, and vision insurance are 100% employer-paid, providing the peace of mind of top coverage without financial burden.
  • Sabbatical program, known as the FAST Pause. This program provides you with a month of paid leave to pursue your passions and recharge in any way you would like.
  • We provide paid parental leave.
  • We provide paid holidays, as well as vacation and sick time.
  • Bonus time compensation values your work and efforts.
  • Our gift matching program matches annual volunteer hours or monetary donations.
  • Team-building activities are offered throughout the year.
  • Make a difference by driving meaningful and positive change in government agencies.

Want More Information?

 

FAST is an equal opportunity employer. 
Voluntary Self-Identification Information is requested for U.S. applicants during the application process.  
Salary to be determined by the education, experience, knowledge, skills, abilities, and location of the applicant.

 

Fast Enterprises is committed to the full inclusion of all qualified individuals. As part of this commitment, Fast Enterprises will ensure that persons with disabilities are provided reasonable accommodations for the hiring process. If reasonable accommodation is needed, please contact FastCareers@fastenterprises.com

#LI-GA2  #LI-Onsite

Pay Range

USD $100,000.00 - USD $120,000.00 /Yr.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed