Beschreibung
Senior PostgreS DBA:
Responsibilities:
- Administration of PostgreSQL databases throughout the development and production life cycles
- Day to day administration of community release PostgreSQL databases
- Collaborate with development, architecture, and release teams, providing architectural design recommendations, driving standards for effective PostgreSQL transition to production operations
- In-depth knowledge of the PostgreSQL architecture
- Drive end to end availability, performance monitoring, and capacity planning for PostgreSQL, using different tools
- Manage backup and recovery functions for a PostgreSQL environment
- Plans and manages patch application on all database Servers.
- Creates, distributes, and enforces standards for user accounts, group, and database security and configuration for all production databases and for non-production databases that may contain PHI or other sensitive data protected under HIPAA, Sarbanes Oxley, or other state or federal regulatory requirements.
- Designs, documents, implements, and monitors archive and other essential log file configuration, operation, and location.
- Designs, documents, implements, and monitors backup of critical database files, and other database protection or high availability solutions.
- Monitors performance issues on all production and non-production databases (as applicable) implementing performance monitoring and trending on all production and applicable non-production databases.
- Provides monthly reports to management on performance on production databases including any performance exceptions and all requested performance data in a summarized, easy-to-read format.
- Designs, documents, and implements performance-enhancing hardware, OS, or database configuration changes to improve performance using performance data collected to verify performance improvements.
- Creates, documents and implements standard, secure, high-performance configurations for all database installs.
- Assist development and reporting groups in optimizing SQL statements in applications, batch jobs, and reports and in designing and using databases and database applications and processes for maximum performance, security, reliability, and availability.
- Additional duties as needed.
Desired Skills Experience:
- 8+ years of IT experience
- Expert PostgreSQL Database Administrator/Architect (working with PostgreSQL v9.6 and above)
- In depth knowledge of PostgreSQL Architecture
- Experience with Python is a plus
- 3+ years of experience in any other(Oracle) database administration is a plus
- BS in Computer Science or related field, or equivalent professional experience.
- Strong communication skills
- Strong interaction skills with clients