Senior PostgreSQL DBA

About This Role

Design and maintain databases and database solutions, ensuring they meet company standards and operate within resource limits. This role involves participating in all phases of systems development, actively monitoring and tuning database and application performance, and providing consultation support.

Responsibilities

• Assist with the design, implementation, and maintenance of databases
• Manage database performance and disk usage
• Provide support in database access methods
• Provide consultation support in database analysis, modeling, coding, and production problem resolution
• Develop maintenance, backup and recovery procedures and documentation
• Participate in Disaster Recovery drills
• Provide Primary On-Call Support for production problems
• Understand and support corporate data standards
• Recommend and assist with new DBMS and operational standards
• Participate in testing and evaluation of new software and software release upgrades

Requirements

• 3+ years’ experience developing and maintaining complex applications that make extensive use of a supported database technology or 3+ years’ experience as an associate DBA
• Well versed in all phases of Systems Analysis and Design
• Experienced in two or more programming languages and two or more scripting languages
• Practiced at Entity/Relationship or Object modeling and translation to physical database designs
• Proficient in DML, DDL, and database utilities for at least two DBMS technologies
• Proficient in all access methods of a DBMS as well as the underlying operating system access methods
• Knowledge of hardware and operating system capabilities within one Environment
• Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment
• 7+ years’ experience with PostgreSQL (preferred EnterpriseDB (EDB) version)
• 3+ years’ Terraform, Ansible, Jenkins & CI/CD skills
• Accepts ownership in assignments, team, and company and takes initiative outside immediate area of responsibility
• Contributes additional effort when necessary to get the job done and to help others meet their objectives
• Seeks additional responsibility, shows initiative to learn every aspect of the job, and strives to become a mentor to others in area of expertise
• Communicates openly and effectively
• Ability to maintain composure under pressure and avoid defensive or irritated or reactions in challenging situations

Qualifications

• Bachelor's degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business
• 3+ years’ experience developing and maintaining complex applications that make extensive use of a supported database technology or 3+ years’ experience as an associate DBA; 7+ years' experience with PostgreSQL

Nice to Have

• 3+ years’ experience with CTE(CipherTrust Transparent Encryption), Barman (EDB Backup and Recovery Manager) and AWS
• 5+ years’ experience with DB2 LUW; preferably on Red Hat Linux
• 1+ years’ experience with SQL Server
• 1+ years’ experience with MySQL/MariaDB
• 1+ years’ experience with DB2 in a z/OS environment
• Related financial industry experiences

Skills

* Required skills