Position: Database administrators (PostgreSQL)
Company: GlobalLogic
Experience required: 3y
Category: SQL
English level: intermediate
Published: 2021-09-01T00:00:00+03:00

**Requirements:**
- You have strong experience with PostgreSQL and it has been your primary database for a minimum of 3 years. 
- Deep understanding of systems performance of PostgreSQL, and advanced knowledge of Postgres internals. 
- Understand automation concepts to speed up the work Using Ansible 
- Experience implementing high availability by setting up either streaming replication or logical replication and decoding. 
- Expertise in implementing Foreign Data Wrappers to sync data across multiple PostgreSQL servers and Advanced query tuning for large data sets.
- Knows how to optimize queries/schemas. 
- Knows backup solutions and strategies. 
- Knows HA solutions and strategies. 
- Knows proxy usage as it relates to Postgres. 
- Ability to troubleshoot methodically, identifying and applying fixes for known errors, and when necessary, capacity to think outside of the box to resolve complex issues. 
- Experience with system performance counters and metrics relevant to the operation of high-concurrency PostgreSQL implementations, and resolve database performance and scalability issues.

**Responsibilities:**
- You will be responsible for implementation, configuration, maintenance, and performance of system health for high-concurrency PostgreSQL database systems ensuring availability and consistent performance, supporting product development teams.
- Build high-scale data pipelines and data infrastructure for migrating SQLServer and Oracle DB to PostgreSQL on AWS RDB.
- Specific experience in complex large data architectures using AWS Aurora PostgreSQL and AWS data lake (S3 and Glue) with IAM roles and KMS key encryption. 
- Resolve database performance and scalability issues and implement Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. 
- Design and implement scalable database schemas and configurations, File system layout, Physical partitioning, Sharding and Replication, incremental backups, Restores, and recovery models. 
- Implement High Availability (HA) and Disaster Recovery (DR) options for PostgreSQL 
- Develop DevOps policies and procedures as it relates to PostgreSQL 
Manage PostgreSQL databases through multiple product lifecycle environments, from development to mission-critical production systems dealing with upgrades. 
- Independently analyzes, solves, and corrects issues in real-time, providing problem resolution end-to-end. 
- Refines and automates regular processes, tracks issues, and documents changes. 
- Assists developers with complex query tuning and schema refinement. 
- Provides on-call support, as part of team rotation, for critical production systems. 
- Performs pre-scheduled maintenance and support release deployment activities after hours. 
- Shares domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. 
- Design and implement a complex system to combine and merge data from multiple database servers into a target database. 
- Create complex queries to produce materialized views collating data from multiple servers based on which server is deemed authoritative for each record. 
- Tune performance of source and target servers to ensure performance is maintained even after replication/merge engine is added.