PostGres Developer/DBA

Description

Job Description AdvisorEngine is looking for a full time Database Developer. This person will work with an existing offshore and domestic development staff that have created the current Postgres database. The position will be responsible for establishing database architecture, design, schema, development and production standards and processes and ensuring all database implementation meets these standards. We currently have applications using Postgres and MS SQL and are determining best the best options for consolidating down to either Postgres, MS SQL, or MySQL. The person will work on the effort to determine the viability each option as we pick our future direction. This transition will likely take 12 years so regardless of the technology path, this person will own the current Postgres DB work going forward. The person must be a quick learner and thrive in a fastpaced environment that requires strong multitasking and communication skills.
Responsibilities will include Owning all Postgres database architecture and design
Establishing all Postgres implementation standards and processes to ensure all development conforms to these standards
Owning all Postgres database production and nonproduction implementation to ensure performance, stability, and scalability. Establishing all Postgres support processes and standards.
Creating appropriate scripts/code for production and nonproduction Postgres DB updates
Owning strategy for backup and recovery within our primary environment and to our disaster recovery environment.
Performing database tuning including index and performance analysis to provide optimal performance
Working with other team members for the security plans for data at rest
Work with other team members to implement database monitoring and reporting for our production environment
Document the existing data model and model updates for new development requirements, and maintain model documentation
Contribute to establishing QA data methodologies to allow repeatable testing on Postgres databases including performance, load, and regression testing
Review the existing Postgres implementation and propose/implement improvements
Work with developers to provide oversight and development on the Postgres code
Assist with improving the application data analytics capabilities.
Participating in an agile development environment including sizing, estimating, collaborative development, and faced paced iterative delivery
Participate in the evaluation of the viability of transitioning to a new DB technology and work in the new DB technology based on the selection.
Ability to generate capacity plans
Adaptably manages competing demands and finds the best approach for the situation.
Synthesizes intricate and varied information, collects and examines data, uses awareness and understanding to complement data, identifies data interactions and dependencies, designs workflows and processes.
Some after hours work will be required for deployments and support
What you have Required
Bachelors degree in Computer Science or equivalent experience demonstrating advanced level of Postgres and DBA knowledge and implementation history
Demonstrated ability to multitask and succeed in a fast paced, dynamic environment
Strong, analytical ability to quickly debug application problems and provide short & long term solutions
High proficiency with Linux and shell scripting.
Ability to develop and generate data models and DDL.
Experience with PostgreSQL Replication technologies, Postgres Plus Advanced Server (EDB)
5+ years of developing and maintaining Postgres databases
Experience upgrading versions of Postgres on live systems
3+ years with database modeling designing tables, relationships, etc.
Experience developing in Java
Demonstrated history dealing with database performance, scalability, and maintainability
Experience establishing DB restoration plans and implementation to achieve RPO/RTO objectives
Strong written and verbal communications, teamwork and problemsolving skills
Ability to interact and communicate successfully with business partners and technology teams
Experience with Agile Development Practices
Selfstarter who can grasp difficult concepts
Ability to think outside the box and come up with creative solutions when tools dont work