This job ad has been posted over 40 days ago...



Senior PostgreSQL Database Administrator Full-time

at Omnitracs in United States Of America (Published at 23-05-2018)

This position is part of a DBA team that provides administration for PostgreSQL databases across the entire enterprise and supports heterogeneous PostgreSQL environments like Development, Test and Production. This individual creates and maintains backups, restores and facilitates disaster recovery in all production environments. Responsible for ensuring maximum up-time with maximum throughput to meet established service-level agreements (SLAs), ensuring backup integrity, and providing support to development and application support groups as needed. The DBA responsibility includes working with architecture, application development and operations to contribute to achieving a state-of-the-art environment that meets current and future business objectives both in on-premises and hybrid cloud infrastructure environments. This person will contribute to the training and development of additional technical support staff and enhance knowledge of the software development staff to better utilize Omnitracs database environments. This role will also provide and designs tools to assist in the management of the database and transaction processing environment; works to provide a working model of our transaction processing environment for capacity assessment and planning.


• Develops proactive methodology for ongoing assessment of database performance and the identification of problem areas
• Assist with computing environments both on-premises infrastructure and hybrid cloud (private cloud and public cloud like AWS)
• Work with development teams to troubleshoot and optimize queries and performance bottlenecks
• Develops security scheme(s) for the database environment; plan and test disaster recovery processes and procedures to meet business’s recovery point objective (RPO).
• Install and configure new PostgreSQL both adhoc and via automation where needed.
• Designing and implementation of PostgreSQL replication using Master-Master, Master-Slave to support distributed loads (slony, bucardo, PGCluster, pgpool)
• Troubleshoot PostgreSQL service outages as they occur, including after-hours and weekends
• Performance tuning, Query Optimization and Performance monitoring using tool such as but not limited to PGAdmin, PGBagger.
• Identify and configure PostgreSQL monitoring utilities/tools.
• Provides leadership during the development and enhancement of production applications including working with applications development; technical support and operations during the design, development and implementation of applications
• Work with transaction processing to develop both physical and logical database administration functions
• Work closely with middleware application administrators to identify the database resource requirements and to improve operational processes.
• Deployment of database change scripts provided by in-house development team or third-party vendors
• When performance issues arise, determine the most effective way to increase performance including server resources, configuration changes, index and query changes etc.
• Work with members of Engineering and IT to build logical database documentation and provide technical guidance during all phases of the development process
• Work with vendors in evaluating and implementing new technologies
• Train, mentor and develop Jr level DBAs, technical support staff and applications staff
• Maintain and expand document the company’s database environments


• EDUCATION: Bachelor’s degree in Computer Science, Information Technology or related field
o 4-5 years of work experience as a PostgreSQL DBA, providing 24/7 support to mission-critical applications and databases
o Solid and proven skills in managing database lifecycles - builds, patching, backups, recoveries, tuning
o Experience working in a team-oriented, collaborative IT environment.
o Experience in other RDBMS, including open source database technologies such as SQL Server, MySQL, Oracle
o Working knowledge of none relational database technologies like MongoDB, Hadoop, Cassandra
o Working knowledge of common cloud platforms to host PostgreSQL, AWS, Azure.


• Working knowledge of prevalent cloud based databases solutions
• Working knowledge of reporting and query tools and practices
• Knowledge of data management and data processing flowcharting techniques
• Knowledge in designing and managing high availability environments
• Technical documentation skills
• PostgreSQL DBA experience in a 24x7 production environment
• 6 - 8 years of database management and engineering experience
• Demonstrated experience in architecting a large-scale production database platforms including warehouse solutions
• Experience with schema design and data normalization
• Understanding of caching techniques both inside and outside of databases
• Understanding of common replication strategies
• Expertise with Postgres system metrics and optimization strategies
• Familiarity with system level metrics and practical use of common Linux utilities
• Mastery of one or more of: Python, Perl, Bash or other scripting language
• Experience with merging large sets of data for imports and exports
• Solid verbal and written communication skills
• Excellent organizational, project management and time management skills
• Presentation skills
• Ability to break down complex concepts and data and make them accessible to others
• Ability to produce consistent results with minimal direction and supervision
• Ability to prioritize and execute in a fast-paced environment with varying requirements and deadlines

Reference : Senior PostgreSQL Database Administrator jobs

Recent jobs at Omnitracs

Viewed: 30 times
« Go back to category
Is this job ad fake? Report it!   
Recommend to a friend