Role overview

Qualifications

10 or more years' experience managing PostgreSQL databases in a Linux environment.
In-depth knowledge of Postgres utilities.
Experience managing Amazon RDS implementation, including Postgres migrations and deployments.
Experience crafting shell scripts (Linux, Python).

Responsibilities

Support an enterprise class environment running PostgreSQL database management systems including installation, configuration, monitoring, troubleshooting, performance tuning, and security.
Design and optimize database schemas, tables, indexes, and queries for performance and scalability.
Implement robust backup and recovery strategies including regular backups, point-in-time recovery, and disaster recovery planning.
Monitor and manage database performance, identifying and resolving performance bottlenecks, and conducting routine maintenance tasks.

Key facts

Remote from: Anywhere
Full time
Expert & Leadership (>10 years)
Database Administrator
English

Hard skills

PostgreSQL

About the company

Georgia IT, Inc.

Georgia IT, Inc. provides IT Consulting for a wide range of IT services and custom build turn-key enterprise solutions. GIT specializes in improving business scalability and efficiency through BSM and SBA Solutions. GIT transforms business with service management and service automation solutions. We are BMC & HP partners. GIT Services include custom built enterprise software and customer-centric web portals, network design and implementation, remote and site-to-site VPN, network and server security assessment and setup, server and desktop virtualization, and many others. GIT also provides IT Consulting in many areas such as Disaster Recovery Planning, Enterprise Data Backup Strategy, Long Term Strategic IT Planning and Augmentation Professional Services Solutions. Professional Services Specialties: Business Process Integration, Software Integration & Development, Web portal, Networking, Remote and site-to-site VPN, Virtualization Solutions, Product Development Please contact us Hrus@georgiait.com / uthay@georgiait.com/470-798-5000 x 1010 / (732) 890-2535 direct

Company details

Company size51 - 200

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

PostgreSQL DBA
Location: 100% Remote
Duration: Long-Term Contract
Rate: DOE

US Citizens and Green cards Preferred.

Technical Skills Required:

10 or more years' experience managing PostgreSQL databases in a Linux environment.
In-depth knowledge of Postgres utilities.
Experience managing Amazon RDS implementation, including Postgres migrations and deployments. Familiarity with managing versions and deployment in RDS and on-premise servers.
Experience crafting shell scripts (Linux, Python).
Experience in implementation of various monitoring tools.
Familiarity managing database, deployment, monitoring, and benchmarking statistics. Manage lifecycle support of database systems by applying patches, upgrades, and routine database.

Job Description/High-Level Task Assignment:

Support an enterprise class environment running PostgreSQL database management systems including installation, configuration, monitoring, troubleshooting, performance tuning, and security. Design and optimize database schemas, tables, indexes, and queries for performance and scalability. Implement robust backup and recovery strategies including regular backups, point-in-time recovery, and disaster recovery planning.
Monitor and manage database performance, identifying and resolving performance bottlenecks, and conducting routine maintenance tasks. Configure and run high availability solutions such as replication and ensure continuous database availability.
Implement database security standard methodologies including access control, authentication, and compliance standards.
Use strong analytical skills and problem-solving skills to diagnose and resolve database-related issues.
Perform database capacity planning and trend analysis. Use scripting and automation tools to perform database administration tasks and streamline operations.
Collaborate with multi-functional teams, including developers, system administrators, and L1/L2 support.
Build high quality documentation including database designs, standard operating procedures, and troubleshooting guides.
Perform security log reviews for audit compliance; detect, report, and escalate anomalies.
Deliver training, mentoring, and coaching to other Database Administrators through free flow of information, encouraging and appropriately evaluating feedback, encouraging innovation, and inspiring / motivating others. Provide on-call rotational 24/7 incident response to database alerts escalated by production monitoring.