This site uses cookies. To find out more, see our Cookies Policy

Remote PostgreSQL Database Administrator in Atlanta, GA at Vaco

Date Posted: 11/15/2018

Job Snapshot

Job Description


Responsibilities:
  • Managing a mix of both physical and cloud-based PostgreSQL servers, the Database Administrator is responsible for the care, feeding, and uptime of mission-critical infrastructure.
  • Strong understanding of database performance, query optimization, and operational management, the DBA works closely with engineers across teams on a variety of projects.
  • Review 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.

Required Skills:

  • Responsible for implementing, managing, and tuning high-availability 24x7 PostgreSQL databases.
  • Establish policies and procedures pertaining to data management, security, maintenance and utilization.
  • Develop, manage, and test database backup & recovery strategies, verifying data integrity.
  • Perform database installations, configurations, upgrades, and migrations.
  • Proactively monitor and tune for performance.
  • Responsible for capacity planning and recommending paths to account for application growth that are in line with industry best practices.
  • Consult with development and architecture teams to help meet continued application growth.
  • Define and implement database schema and configurations working with our development teams.
  • Create and maintain documentation of procedures, schemas and guides for troubleshooting database systems.
  • 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.
  • Perform review of schema, stored procedures, and other changes to the database DDL.
  • Audit for data integrity and consistency across systems.
  • Work with data-warehousing and Business Intelligence tools.
  • Creation and management of ETL applications and pipelines.
A Little About You:
-------------------

  • BA/BS in Information Technology or Computer Science preferred.
  • 6+ years of experience working in Database Administration
  • In-depth understanding of relational and dimensional database theory and concepts.
  • Significant practical hands-on experience with database administration, backup and recovery, performance tuning and high-availability solutions.
  • Detailed understanding of Postgres database server architecture, concepts, features, and high-availability technologies.
  • Expert knowledge of PL/PgSQL, triggers, and stored procedure development and optimization in PostgreSQL
  • Experience with database replication, hot stand-by, clustering, and table partitioning.
  • Linux platform familiarity, system resource monitoring and tuning.
  • High-level of proficiency with PostgreSQL in a Linux environment
  • Working knowledge of shell scripting and writing applications in Python.
  • Previous experience with MongoDB, DynamoDB, and Redis a plus.
  • Previous experience with PostgreSQL in the cloud, including Amazon RDS is a plus.
  • Working knowledge of Configuration Management systems such as Chef, Ansible, or Puppet.
  • Working knowledge of Docker and previous production experience with PostgreSQL or other databases in a Dockerized environment a plus.
  • Experience with RabbitMQ, stream processing, and other related technologies a plus.
  • Ability to handle stressful problems and solve complex problems under pressure
  • Ability to communicate effectively with others, both in oral and written communication
  • Excellent planning, problem solving, organization and project management skills