Postgresql Database Administrator

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.

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. This position will join the Centralized Tech Team out of the FAST Headquarters and Development Center in Centennial, CO. You will have a hybrid schedule with both work-from-home and in-office days. Travel will be rare, but you should be flexible and able to travel when required.

You will manage PostgreSQL databases across multiple product lifecycle environments-from development to mission-critical production systems-while 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

• Bachelor's 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 annual bonus account.

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

• Every four years, you will be eligible for our 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?

• #YFAST

• Our Clients

• Our Solutions

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.

Pay Range

USD $90,000.00 - USD $103,000.00 /Yr.