Database Administrator

Experion Technologies; United States; Vor Ort; USD 90.000 - 120.000; Vollzeit

Zusammenfassung

Experion Technologies is seeking a PostgreSQL Database Administrator to co-own their PostgreSQL infrastructure, focusing on optimal performance and security. This role involves collaborating with development teams to design scalable database solutions and managing production environments on AWS RDS.

Qualified candidates should have a minimum of 5 years of hands-on PostgreSQL experience and expertise in database design, security management, and recovery strategies.

Qualifikationen

• 5+ years of hands-on PostgreSQL administration in production environments.

Aufgaben

• Design and maintain scalable database architectures.
• Manage and optimize PostgreSQL production environments on AWS RDS.
• Implement and maintain comprehensive backup and disaster recovery strategies.
• Monitor database performance and proactively identify and resolve issues.

Kenntnisse

Database Design & Management

PostgreSQL tuning and performance optimization

Strong knowledge of PostgreSQL security management

Backup strategies and point-in-time recovery (PITR)

Advanced SQL expertise

ETL processes and data migration strategies

Experience with AWS RDS

Troubleshooting skills for production issues

Tools

AWS RDS

Terraform

CloudFormation

Jobbeschreibung

In this role, you will take co‑ownership of PostgreSQL infrastructure, ensuring optimal performance, security, and reliability. You will work closely with development teams to design scalable database solutions and manage production environments in AWS RDS.

Responsibilities

• Design and maintain scalable database architectures
• Manage and optimize PostgreSQL production environments on AWS RDS
• Implement and maintain comprehensive backup and disaster recovery strategies
• Monitor database performance and proactively identify and resolve issues
• Collaborate with development teams on database design and optimization
• Manage database security, access control, and compliance
• Perform capacity planning and cost optimization for database infrastructure

Qualifications

• 5+ years of hands‑on PostgreSQL administration in production environments

Required Skills

• Database Design & Management
• Strong knowledge of data design principles and schema management
• Expertise in database normalization, indexing strategies, and query optimization
• Ability to design and maintain logical and physical database architecture
• Proficiency in creating and maintaining Entity‑Relationship Diagrams (ERDs)
• Proficiency in PostgreSQL tuning and performance optimization
• Expertise in maintaining PostgreSQL on AWS RDS, including parameter groups and configuration
• Strong understanding of query execution plans, indexing, and SQL optimization
• Security & Compliance
• Strong knowledge of PostgreSQL security management (authentication, authorization, encryption)
• Experience with IAM integration and access control policies
• Understanding of audit logging and compliance requirements
• Backup, Recovery & Disaster Recovery
• Expertise in backup strategies and point‑in‑time recovery (PITR)
• Experience designing and testing disaster recovery plans
• Proficiency with AWS RDS backup and snapshot management
• Data Management & Migration
• Ability to understand and document data flow within database systems
• Proficiency with loading, transforming, and moving data between database environments
• Experience with ETL processes and data migration strategies
• SQL & Application Development Knowledge
• Advanced SQL expertise including complex queries and optimization
• Strong understanding of stored procedures, functions, and triggers
• Ability to review and advise on application‑level database interactions
• Experience with CloudWatch and AWS RDS monitoring tools
• Ability to set up proactive monitoring and alerting
• Strong troubleshooting skills for production issues
• Experience with on‑call support and SLA management

Preferred Skills

• Experience with Infrastructure as Code (Terraform, CloudFormation)
• Experience with high availability and streaming replication setups
• Familiarity with PostgreSQL extensions and advanced features