Insight Global
Postgres DBA - INTL Austria
Insight Global, Alpharetta, Georgia, United States, 30239
Job Description
* Our client is looking for a self-motivated, highly experienced Postgres DBA to join their team. This team will be rolling out Postgres DB. This individual will be responsible for tasks such as Installing new systems, planning and executing rolling updates/upgrades with minimum downtime, handling incidents for customers, managing internal test, development, and production systems as well as assisting development with performance optimizations.
Database Administration: Installation, configuration, and maintenance of Postgres databases.
Performance Optimization: SQL tuning, query optimization, and system performance monitoring.
High Availability (HA): Implementation and management of HA solutions (e.g., replication, clustering).
Disaster Recovery (DR): Design, implementation, and testing of DR plans.
Backup and Recovery: Management of backup strategies and restoration procedures.
Security: Ensuring database security through access control, encryption, and vulnerability management.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .
Skills and Requirements
In-depth knowledge of Postgres: Understanding of Postgres internals, architecture, and features.
SQL expertise: Proficiency in SQL query writing, optimization, and performance tuning.
Scripting: Experience with scripting languages (e.g., Bash, Python) for automation tasks.
HA and DR solutions: Familiarity with replication methods (e.g., WAL replication, logical replication), clustering (e.g., Patroni, pgpool-II), and DR strategies.
Performance optimization: Knowledge of query optimization techniques, index creation, and performance monitoring tools.
Backup and recovery: Understanding of backup methods, recovery procedures, and point-in-time recovery.
Security: Awareness of security best practices, encryption methods, and vulnerability assessment. Experience with cloud-based Postgres deployments (e.g., AWS RDS, GCP Cloud SQL)
Knowledge of containerization technologies (e.g., Docker, Kubernetes)
Experience with data migration and ETL processes null
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.
* Our client is looking for a self-motivated, highly experienced Postgres DBA to join their team. This team will be rolling out Postgres DB. This individual will be responsible for tasks such as Installing new systems, planning and executing rolling updates/upgrades with minimum downtime, handling incidents for customers, managing internal test, development, and production systems as well as assisting development with performance optimizations.
Database Administration: Installation, configuration, and maintenance of Postgres databases.
Performance Optimization: SQL tuning, query optimization, and system performance monitoring.
High Availability (HA): Implementation and management of HA solutions (e.g., replication, clustering).
Disaster Recovery (DR): Design, implementation, and testing of DR plans.
Backup and Recovery: Management of backup strategies and restoration procedures.
Security: Ensuring database security through access control, encryption, and vulnerability management.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .
Skills and Requirements
In-depth knowledge of Postgres: Understanding of Postgres internals, architecture, and features.
SQL expertise: Proficiency in SQL query writing, optimization, and performance tuning.
Scripting: Experience with scripting languages (e.g., Bash, Python) for automation tasks.
HA and DR solutions: Familiarity with replication methods (e.g., WAL replication, logical replication), clustering (e.g., Patroni, pgpool-II), and DR strategies.
Performance optimization: Knowledge of query optimization techniques, index creation, and performance monitoring tools.
Backup and recovery: Understanding of backup methods, recovery procedures, and point-in-time recovery.
Security: Awareness of security best practices, encryption methods, and vulnerability assessment. Experience with cloud-based Postgres deployments (e.g., AWS RDS, GCP Cloud SQL)
Knowledge of containerization technologies (e.g., Docker, Kubernetes)
Experience with data migration and ETL processes null
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.