Mindlance
Overview
Senior PostgreSQL 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. Is this a remote position? If not, what locations can a resource work and how many days a week will they be required to work onsite? Onsite, preferably MSP. Responsibilities
Install/Configure PostgreSQL Add security Add monitoring Migrate Data from one server to another Configure backup Configure performance optimization Design and implement database schemas, partitioning, and indexing strategies for efficient data management Manage backups, restores, upgrades, and patching to ensure database health and security Design, implement, and manage HA/DR solutions to ensure continuous operation and data recoverability (experience with Repmgr, HA Proxy is preferred) Develop and maintain scripts and tools (e.g., using Python, PowerShell, Ansible) to automate routine tasks and processes Top Skills / Responsibilities Details
Top responsibilities include performance tuning: analyze, tune, and optimize database performance, including query analysis, indexing, and partitioning strategies Maintenance & Operations: regular maintenance, backups/restores, upgrades, and patching HA/DR: design and manage high availability and disaster recovery solutions Database Design: design schemas, partitioning, and indexing strategies Security: monitor and manage database security, respond to security alerts Automation & Scripting: develop and maintain automation scripts/tools Qualifications
PostgreSQL DBA administration, Shell / Bash scripting. Minimum of 5 years or more. Preferred Attributes
Good team player, strong documentation skills Interview Process
Managerial and technical rounds Video, phone, or in-person interviews Technical round will be very technical; highly technical discussion Additional Information
Client/Server Database Administrator: Interpersonal communication skills sufficient to interact with customer staff and other contract personnel. Technical writing skills to document work performed and maintenance instructions. Experience with setup and maintenance of database systems in a client/server environment. Knowledge of monitoring and performance improvements, maintenance procedures, clustering and high availability solutions, and interfaces with programming languages such as Visual Basic. Shift: [] Start: [] EEO: Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.
#J-18808-Ljbffr
Senior PostgreSQL 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. Is this a remote position? If not, what locations can a resource work and how many days a week will they be required to work onsite? Onsite, preferably MSP. Responsibilities
Install/Configure PostgreSQL Add security Add monitoring Migrate Data from one server to another Configure backup Configure performance optimization Design and implement database schemas, partitioning, and indexing strategies for efficient data management Manage backups, restores, upgrades, and patching to ensure database health and security Design, implement, and manage HA/DR solutions to ensure continuous operation and data recoverability (experience with Repmgr, HA Proxy is preferred) Develop and maintain scripts and tools (e.g., using Python, PowerShell, Ansible) to automate routine tasks and processes Top Skills / Responsibilities Details
Top responsibilities include performance tuning: analyze, tune, and optimize database performance, including query analysis, indexing, and partitioning strategies Maintenance & Operations: regular maintenance, backups/restores, upgrades, and patching HA/DR: design and manage high availability and disaster recovery solutions Database Design: design schemas, partitioning, and indexing strategies Security: monitor and manage database security, respond to security alerts Automation & Scripting: develop and maintain automation scripts/tools Qualifications
PostgreSQL DBA administration, Shell / Bash scripting. Minimum of 5 years or more. Preferred Attributes
Good team player, strong documentation skills Interview Process
Managerial and technical rounds Video, phone, or in-person interviews Technical round will be very technical; highly technical discussion Additional Information
Client/Server Database Administrator: Interpersonal communication skills sufficient to interact with customer staff and other contract personnel. Technical writing skills to document work performed and maintenance instructions. Experience with setup and maintenance of database systems in a client/server environment. Knowledge of monitoring and performance improvements, maintenance procedures, clustering and high availability solutions, and interfaces with programming languages such as Visual Basic. Shift: [] Start: [] EEO: Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.
#J-18808-Ljbffr