PostgreSQL Database Administrator - Fast Enterprises
Centennial, CO
About the Job
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 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, butyou will likely haveopportunities 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.
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 withina technical team of roughly 45employees, contributing to internal development and client projects across the United States and abroad.
- RequiredExperience
- 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
- 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.
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.