Experienced PostgreSQL Database Administrator

An innovative tech startup, revolutionizing the world of media and information, is looking for an experienced PostgreSQL Database Administrator

Job Description:

The PostgreSQL Database Administrator is a key role for an individual who is both collaborative and can work hands-on in our large PostgreSQL-based infrastructure. Managing cloud-based PostgreSQL servers, the Database Administrator is responsible for the care, feeding, and uptime of mission-critical infrastructure. With a strong understanding of database performance, query optimization, and operational management, the DBA works closely with engineers across teams on a variety of projects. In this role, you’ll have schema, operational plans, and our database ecosystem to ensure that the right decisions are being made and that our systems are both performant and error-free.


1. Responsible for implementing, managing, and tuning high-availability 24x7 PostgreSQL databases.

2. Establish policies and procedures pertaining to data management, security, maintenance and utilization (high emphasis on data security)

3. Develop, manage, and test database backup & recovery strategies, verifying data integrity.

4. Perform database installations, configurations, upgrades, and migrations.

5. Proactively monitor and tune for performance.

6. Responsible for capacity planning and recommending paths to account for application growth that are in line with industry best practices.

7. Consult with development and architecture teams to help meet continued application growth.

8. Define and implement database schema and configurations working with our development teams.

9. Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.

10. Responsible for the monitoring and uptime of all production databases.

11. Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage

12. Create and maintain documentation of procedures, schemas and guides for troubleshooting database systems

13. Research and evaluate new databases, technologies, and trends to provide innovative ideas and solutions to improve the existing infrastructure and support new projects and requirements.

14. Perform review of schema, stored procedures, and other changes to the database DDL.

15. Audit for data integrity, security and consistency across systems.

16. Work with data-warehousing and Business Intelligence tools.

Required Skills:

1. In-depth understanding of relational and dimensional database theory and concepts.

2. Significant practical hands-on experience with database administration, backup and recovery, performance tuning, security and high-availability solutions.

3. Detailed understanding of Postgres database server architecture, concepts, features, and high-availability technologies.

4. Expert knowledge of PL/PgSQL, triggers, and stored procedure development and optimization in PostgreSQL

5. Experience with database replication, hot standby, clustering, and table partitioning.

6. Linux platform familiarity, system resource monitoring and tuning.

7. High-level of proficiency with PostgreSQL in a Linux environment

8. Working knowledge of shell scripting and writing applications in Python.

9. Previous experience with PostgreSQL in the cloud, including GCP Cloud SQL is a plus.

10. Working knowledge of Configuration Management systems such as Chef, Ansible, or Puppet.

11. Working knowledge for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving)

12. Working knowledge of Docker and previous production experience with PostgreSQL or other databases in a Dockerized environment is a plus.

13. Ability to handle stressful problems and solve complex problems under pressure

14. Ability to communicate effectively with others, both in oral and written communication

15. Excellent planning, problem-solving, organization and project management skills

Навыки: PostgreSQL, PostgreSQL Administration, Google Cloud Platform, Amazon Web Services, Database Design

Показать больше: difference database administrator database developer sql server, resume database administrator sql job jobs, shortest cut database administrator, database administrator nigeria, work home system database administrator philippines, database administrator raci chart example, java load flat file postgresql database, adabas database administrator resume, restoring postgresql database folder, netbeans postgresql database, python postgresql database, database administrator bangladeshi company, database administrator uttarakhand government, record user activity html java database administrator, sybase database administrator password recovery, fixing oscommerce database administrator password, salary database administrator pakistanb, remote oracle database administrator job pakistan, Looking for an experienced computer programmer that is familiar with eBay & Amazon ... Browse Freelancers. Web, ... eBay/Amazon/, how to get an entry level database administrator job

О работодателе:
( 1 отзыв ) Concord, United States

ID проекта: #29416169

9 фрилансеров(-а) готовы выполнить эту работу в среднем за $1021


Dear client. Very nice to meet you! I'm an expert of full stack development and have a great experiences of php, postgresql, database management, AWS, javascript(react, angular, vue...) and etc. If you give me this pro Больше

$1100 USD за 20 дней(-я)
(2 отзывов(-а))

Dear Client After reading your job description carefully, I found that I am good fit for your project. I'm very interested in your project. I have a lot of experience with Postgre SQL and I am sure I can complete this Больше

$800 USD за 3 дней(-я)
(1 отзыв)
(6 отзывов(-а))

Good day! i am a full stack developer with experience in PostgreSQL , database development , I have checked your requirement and I can do this , please check my profile https://www.freelancer.in/u/arjun366333 , we can Больше

$900 USD за 7 дней(-я)
(1 отзыв)

Hi, Dzianis B. I have read your description carefully and understood it. I started to learn programming 16 years ago. I mastered AWS, Postgresql and have over 10 years of experience. I am DB manager. So I can do it and Больше

$1000 USD за 7 дней(-я)
(0 отзывов(-а))

Hello, I would like to help you, I have more than 15 years of experience working with POSTGRESQL, MYSQL SERVER, MARIADB, in many of its versions. It is my specialty en SQL y PL/SQL.

$1500 USD за 7 дней(-я)
(0 отзывов(-а))

Hello, Greetings! Happy to help you with this requirement. As this can be a long term requirement I believe you are looking for an experienced technical partner. Among our offerings, database management to migration i Больше

$1125 USD за 7 дней(-я)
(0 отзывов(-а))

As per details given by you you are looking for dba for short duration I am a 10yrs + experience dba and capable of accomplish this if this bid is success.

$750 USD за 7 дней(-я)
(0 отзывов(-а))

Hi !! As a full-time employee in database administration with over 10 years of experience, I have been expertise in PostgreSQL and DB2 databases. I have handled a couple of projects individually in PostgreSQL and DB2 Больше

$1125 USD за 7 дней(-я)
(0 отзывов(-а))