Skip to content
Senior Postgres DBA
| Company | Mastercard |
|---|
| Location | O’Fallon, MO, USA |
|---|
| Salary | $94000 – $157000 |
|---|
| Type | Full-Time |
|---|
| Degrees | |
|---|
| Experience Level | Senior, Expert or higher |
|---|
Requirements
- Postgres DBA experience in a 24×7 production environment
- Database management and engineering experience
- Exceptional SQL development and performance tuning skills
- Experience architecting a large-scale production database platforms
- Expertise with Postgres system metrics and optimization strategies
- Familiarity with system level metrics and practical use of common Linux utilities
- Mastery of one of the following scripting languages: Python, Perl, Bash
- Understanding of virtualization and clustered environments
Responsibilities
- Proactively monitoring database performance and troubleshooting issues
- Working cross-functionally with our engineers and analytics professionals to optimize queries, fix performance bottlenecks, improve existing schemas and design new ones
- Creating and maintaining change control and testing processes, reviewing and approving database modifications
- Have good knowledge of Replication strategy – BDR, BSR
- Reviewing development and deployment processes related to databases and identifying areas of improvement (such as online schema changes)
- Implement database changes and modifications as per the application release activities
- Can do database patching, database upgrades and implement best practice on databases
- Knowledge of Postgres high availability, Proxy nodes will be must
- Improving database expertise company-wide
Preferred Qualifications
- Additional knowledge of Oracle and Redis will be helpful as there are some critical respective modules resides on those technologies.
