Senior Postgresql Database Administrator

Detalles de la oferta

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.
We are looking for qualified candidates to join the Centralized Tech Team in-office out of the FAST Headquarters and Development Center in Centennial, CO and work fully in-office .
Travel will be rare, but you should be flexible and able to travel when required.
Responsibilities As a Senior 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, 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 8-12 years of Postgres experience A minimum of 8-12 years of database administration experience A minimum of 4 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.
Work where you live; live where you work Relocation provides the opportunity to explore new communities and cultures.
You are not moving on your own-the FAST Relocation team coordinates and assists you through each stage of your move.
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 FastCareersfastenterprises.com.
LI-Onsite LI-GA1 Pay Range USD $135,000.00 - USD $150,000.00 /Yr.


Salario Nominal: A convenir

Fuente: Appcast_Ppc

Requisitos

Trabajo Desde Casa Ios Architect

Trabajo desde casa iOS ArchitectSistemas y Tecnología Ingeniería de sistemas Computación / Otras Acerca de la compañía: BairesDev es una premiada compañía de...


Bairesdev S.A. - Risaralda

Publicado a month ago

Work From Home Golang Developer

At BairesDev, we've been leading the way in technology projects for over 15 years. We deliver cutting-edge solutions to giants like Google and the most innov...


Bairesdev S.A. - Risaralda

Publicado a month ago

Work From Home React Engineer

At BairesDev, we've been leading the way in technology projects for over 15 years. We deliver cutting-edge solutions to giants like Google and the most innov...


Bairesdev S.A. - Risaralda

Publicado a month ago

Work From Home Android Tech Lead

At BairesDev, we've been leading the way in technology projects for over 15 years. We deliver cutting-edge solutions to giants like Google and the most innov...


Bairesdev S.A. - Risaralda

Publicado a month ago

Built at: 2024-11-21T12:27:12.820Z