Senior PostGreSQL Database Engineer
Eliassen Group is searching for a Senior PostgreSQL Database Engineer to assist one of our large government end clients.
This will start off remote but with it being contract to hire the anticipation is that after COVID there will be some onsite work in Baltimore, MD.
This position will require a Public Trust clearance, our client will sponsor someone for this clearance but it can take 3-6 weeks to get adjudicated.
Due to the nature of this project and the end client requiring a clearance only US Citizens and Green Card Holders will be considered and interviewed.
POSITION DESCRIPTION:
We are seeking a PostgreSQL Database Engineer with strong Python skills within our multi-database engineering team.
The Senior PostgreSQL Database Engineer has subject matter expertise and experience as a PostgreSQL database engineer and administrator, supporting our customer by providing design, build, configuration, test, update, documentation, implementation, operational support, and upgrades for PostgreSQL server databases in multiple infrastructure environments.
The candidate shall demonstrate extensive knowledge in PostgreSQL database administration, support, best practices, automation and configuration tools, testing, tools integration, and communication.
The candidate must be self-motivated and show initiative to support and promote solutions that enhance the customers modern development environment.
PRIMARY SKILLS REQUIRED INCLUDE THE FOLLOWING:
Supporting the community edition PostgreSQL databases throughout the development and production lifecycles in an AWS environment.
Design, build, configure, test, update, document, implement, and provide operational support and upgrades for PostgreSQL server databases in multiple infrastructure environments including, but not limited to, Dev, Val, Prod, Sandbox, DR, and cloud environments.
Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues.
Performance tuning, query optimization, using monitoring and troubleshooting tools.
DAY TO DAY
Responsibilities:
Provide database solution reviews, advice, and solution adjustments for application database requirements.
Provide guidance in the creation and modification of standards and procedures.
Participate in technical reviews and walk-throughs of system design documentation with development and design team members.
Collaborate with development, architecture, and release teams, providing architectural design recommendations, driving standards for effective PostgreSQL transition to production operations.
Create, test, and implement scripting for automation support.
Troubleshoot and resolve database integrity issues, blocking and deadlocking issues, indexing issues, replication issues, log shipping issues, connectivity issues, security issues, etc.
Conduct performance tuning, performance monitoring, capacity planning, and other related monitoring and troubleshooting tasks.
Setup alerting mechanism and monitor for both database and supporting hardware to ensure system health and maximum availability.
Identify and resolve incidents and address to user problems/concerns.
Assess, evaluate and provide resolution for database performance problemsDocument procedures for build, test, update, and upgrading database environments.
Provide backup and recovery functions for PostgreSQL environments.
Create, document, and test backup and recovery procedures including Operational and Disaster Recovery scenariosSupport the standing standards, policies and procedures of the customer team.
May be scheduled for after hours on-call support and will be required to apply production packages during non-peak hours.
Create users, establish database security, create resource queue, performance tuning in terms of query execution etc.
Perform capacity monitoring and short and long-term capacity planning in collaboration with development resources, system administrators and system architects.
Generate reports of all processes and jobs currently running on PostgreSQL with details like users, start and end time, CPU Usage and time, Memory usage, IO Time, locking etc.
Accept other duties as directed by management.
REQUIRED SKILLS:
At least 2 years of experience using Python with PostgreSQL.
Knowledge of automated methods and best practices for installation and configuration of PostgreSQL and other SQL product toolsKnowledge of the PostgreSQL architectureKnowledge of how indexes, index management, integrity checks, configuration, patching, how statistics work, how indexes are stored, how they can be created and managed effectively.
Implementing operational automation.
Documentation skills for creating processes and proceduresPostgreSQL database operational support skills for educating application development and testing usersDatabase performance factors, monitoring tools and tuning proceduresDatabase Management skills, including backup and recovery proceduresSkills in productivity factors and ability to understand impact of problem on overall database performanceKnowledge of fault detection and resolution processesSkills in maintenance tools and proceduresOPTIONAL SKILLS:
Additional experience with alternative database products such as NoSQL, Oracle, MongoDB, GreenPlum.
EDUCATION &
Experience:
BS degree and 5 or more years of prior PostgreSQL experience.
.
Estimated Salary: $20 to $28 per hour based on qualifications.
This will start off remote but with it being contract to hire the anticipation is that after COVID there will be some onsite work in Baltimore, MD.
This position will require a Public Trust clearance, our client will sponsor someone for this clearance but it can take 3-6 weeks to get adjudicated.
Due to the nature of this project and the end client requiring a clearance only US Citizens and Green Card Holders will be considered and interviewed.
POSITION DESCRIPTION:
We are seeking a PostgreSQL Database Engineer with strong Python skills within our multi-database engineering team.
The Senior PostgreSQL Database Engineer has subject matter expertise and experience as a PostgreSQL database engineer and administrator, supporting our customer by providing design, build, configuration, test, update, documentation, implementation, operational support, and upgrades for PostgreSQL server databases in multiple infrastructure environments.
The candidate shall demonstrate extensive knowledge in PostgreSQL database administration, support, best practices, automation and configuration tools, testing, tools integration, and communication.
The candidate must be self-motivated and show initiative to support and promote solutions that enhance the customers modern development environment.
PRIMARY SKILLS REQUIRED INCLUDE THE FOLLOWING:
Supporting the community edition PostgreSQL databases throughout the development and production lifecycles in an AWS environment.
Design, build, configure, test, update, document, implement, and provide operational support and upgrades for PostgreSQL server databases in multiple infrastructure environments including, but not limited to, Dev, Val, Prod, Sandbox, DR, and cloud environments.
Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues.
Performance tuning, query optimization, using monitoring and troubleshooting tools.
DAY TO DAY
Responsibilities:
Provide database solution reviews, advice, and solution adjustments for application database requirements.
Provide guidance in the creation and modification of standards and procedures.
Participate in technical reviews and walk-throughs of system design documentation with development and design team members.
Collaborate with development, architecture, and release teams, providing architectural design recommendations, driving standards for effective PostgreSQL transition to production operations.
Create, test, and implement scripting for automation support.
Troubleshoot and resolve database integrity issues, blocking and deadlocking issues, indexing issues, replication issues, log shipping issues, connectivity issues, security issues, etc.
Conduct performance tuning, performance monitoring, capacity planning, and other related monitoring and troubleshooting tasks.
Setup alerting mechanism and monitor for both database and supporting hardware to ensure system health and maximum availability.
Identify and resolve incidents and address to user problems/concerns.
Assess, evaluate and provide resolution for database performance problemsDocument procedures for build, test, update, and upgrading database environments.
Provide backup and recovery functions for PostgreSQL environments.
Create, document, and test backup and recovery procedures including Operational and Disaster Recovery scenariosSupport the standing standards, policies and procedures of the customer team.
May be scheduled for after hours on-call support and will be required to apply production packages during non-peak hours.
Create users, establish database security, create resource queue, performance tuning in terms of query execution etc.
Perform capacity monitoring and short and long-term capacity planning in collaboration with development resources, system administrators and system architects.
Generate reports of all processes and jobs currently running on PostgreSQL with details like users, start and end time, CPU Usage and time, Memory usage, IO Time, locking etc.
Accept other duties as directed by management.
REQUIRED SKILLS:
At least 2 years of experience using Python with PostgreSQL.
Knowledge of automated methods and best practices for installation and configuration of PostgreSQL and other SQL product toolsKnowledge of the PostgreSQL architectureKnowledge of how indexes, index management, integrity checks, configuration, patching, how statistics work, how indexes are stored, how they can be created and managed effectively.
Implementing operational automation.
Documentation skills for creating processes and proceduresPostgreSQL database operational support skills for educating application development and testing usersDatabase performance factors, monitoring tools and tuning proceduresDatabase Management skills, including backup and recovery proceduresSkills in productivity factors and ability to understand impact of problem on overall database performanceKnowledge of fault detection and resolution processesSkills in maintenance tools and proceduresOPTIONAL SKILLS:
Additional experience with alternative database products such as NoSQL, Oracle, MongoDB, GreenPlum.
EDUCATION &
Experience:
BS degree and 5 or more years of prior PostgreSQL experience.
.
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
