PostgreSQL Database Administrator

RESPONSIBILITIES:
Kforce has a client looking for a Senior PostgreSQL Administrator in Saint Paul, MN.

Summary:
In this role, the PostgreSQL Database Administrator manages, maintains, and optimizes PostgreSQL databases, ensuring their performance, availability, and security. Key responsibilities include designing and implementing database schemas, managing backups and replication, tuning database performance, supporting developers with complex queries, and implementing disaster recovery and high availability solutions. Senior roles also involve scripting for automation, working, and participating in 24/7 on-call rotations for incident support and troubleshooting.

Duties:
* Performance Tuning: Analyze, tune, and optimize database performance, including query analysis, indexing, and partitioning strategies
* Maintenance & Operations: Perform regular maintenance, such as backups, restores, upgrades, and patching, to ensure database health and security
* High Availability & Disaster Recovery (HA/DR): Design, implement, and manage HA/DR solutions to ensure continuous operation and data recoverability
* Database Design: Design and implement database schemas, partitioning, and indexing strategies for efficient data management
* Security: Monitor and manage database security, responding to security alerts and ensuring data integrity
* Automation & Scripting: Develop and maintain scripts and tools (e.g., using Python, PowerShell, Ansible) to automate routine tasks and processes

REQUIREMENTS:
* 5+ years of experience
* Experience with PostgreSQL DBA administration, Shell/Bash scripting
* Experienced in the set-up and maintenance of one or more of the following database systems in a client/server operating systems environment: UDB, Oracle, Progress, SQL Server, or Access
* Database experience consists of creating table space areas, tables and views, logical and physical database design
* Knowledge about monitoring and performance improvements
* Knowledge of database maintenance procedures
* Knowledge with clustering and high availability technology solutions
* Knowledge of interface with Client/Server and Java programming languages, most commonly Visual Basic
* Experience with Repmgr; HA Proxy is preferred
* Proficient in the internals of a large-scale client/server operating system
* Experienced in the set-up and maintenance of one or more of the following database systems in a client/server operating systems environment: UDB, Oracle, Progress, SQL Server, or Access. Database experience consists of creating table space areas, tables and views, logical and physical database design. Knowledge of interface with Client/Server programming languages, most commonly Visual Basic.

The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.

We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.

Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.

This job is not eligible for bonuses, incentives or commissions.

Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.