Mindlance
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.
Can you please provide a summary of the project/initiatives which describes what's being done? - This is for centralization of independently managed Databases. Engineer needs to have core DBA knowledge on open-source postgreSQL.
What are the top 5-10 responsibilities for this position? (Please be detailed as to what the candidate is expected to do or complete on a daily basis) Install/Configure PostgreSQL
dd security
dd monitoring
Migrate Data from one server to another
Configure backup
Configure performance optimization
What skills/technologies are required (please include the number of years of experience required)? PostgreSQL DBA administration, Shell / Bash scripting. Minimum of 5 years or more.
What skills/attributes are preferred (these are a desired, not required)? - Good Team player, well documentation skill.
What does the interview process look like? o How many rounds? : 2. Managerial and technical o Video, phone, or in person? - Video or in-person o How technical will the interviews be? - Technical round will be very technical discussion. Looking for a 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.
Key Responsibilities
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. Experience with Repmgr, HA Proxy is preferred.
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.
DO NOT EDIT BELOW THIS LINE, PLEASE INSERT JOB DESCRIPTION ABOVE Client/Server Database Administrator: Interpersonal communication skills sufficient to effectively interact with customer staff and other contract personnel. Technical writing skills to document work performed and maintenance instructions. Provides performance monitoring and tuning. Skills: 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. 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.
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."
- Onsite, preferably MSP.
Can you please provide a summary of the project/initiatives which describes what's being done? - This is for centralization of independently managed Databases. Engineer needs to have core DBA knowledge on open-source postgreSQL.
What are the top 5-10 responsibilities for this position? (Please be detailed as to what the candidate is expected to do or complete on a daily basis) Install/Configure PostgreSQL
dd security
dd monitoring
Migrate Data from one server to another
Configure backup
Configure performance optimization
What skills/technologies are required (please include the number of years of experience required)? PostgreSQL DBA administration, Shell / Bash scripting. Minimum of 5 years or more.
What skills/attributes are preferred (these are a desired, not required)? - Good Team player, well documentation skill.
What does the interview process look like? o How many rounds? : 2. Managerial and technical o Video, phone, or in person? - Video or in-person o How technical will the interviews be? - Technical round will be very technical discussion. Looking for a 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.
Key Responsibilities
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. Experience with Repmgr, HA Proxy is preferred.
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.
DO NOT EDIT BELOW THIS LINE, PLEASE INSERT JOB DESCRIPTION ABOVE Client/Server Database Administrator: Interpersonal communication skills sufficient to effectively interact with customer staff and other contract personnel. Technical writing skills to document work performed and maintenance instructions. Provides performance monitoring and tuning. Skills: 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. 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.
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."