Database Administrator (PostgreSQL)

Prestige Staffing; Atlanta (GA); Hybrid; USD 120,000 - 130,000; Full time

Job summary

A staffing firm seeks a Senior PostgreSQL Database Administrator to work closely with development and site reliability teams. The role requires 5+ years of experience in PostgreSQL and Microsoft SQL Server, focusing on performance tuning and security practices. You will ensure database health, assist in development operations, and maintain documentation. The position is hybrid, based in Atlanta, offering a competitive salary range of $120,000 - $130,000 per year.

Qualifications

• 5+ years of experience with PostgreSQL, including performance tuning, query optimization, and administration.
• Strong knowledge of PostgreSQL internals, configuration, and monitoring tools.
• 5+ years of experience with Microsoft SQL Server.

Responsibilities

• Ensure database health, uptime, and performance using robust monitoring tools.
• Assist in development operations through code reviews and best practices.
• Complete daily work such as query optimization and schema change reviews.
• Ensure high security by properly categorizing and storing sensitive information.

Skills

Performance tuning

Query optimization

Security practices

Problem solving

Cross-functional communication

Education

Bachelor’s degree in computing, engineering or related field

Tools

PostgreSQL

Microsoft SQL Server

AWS technologies

Job description

Location: Atlanta, GA (Hybrid)

Type: Full-Time

Pay: $120,000 - $130,000 per year

The Role:

As a Senior PostgreSQL Database Administrator with our team you will work closely with our Development and Site Reliability Teams to build new features, monitor and ensure performance, advise on schema refactoring efforts, provide developers with support, and assist in best practices for database design.

Responsibilities:

• Ensure Database Health, Uptime, and Performance
  • Utilize consistent and robust monitoring tools to ensure high availability
  • Conduct performance baselines and continually audit for schema improvements
  • Troubleshoot any performance anomalies and respond to high priority issues
• Assist in Development Operations
  • Participate in code reviews to ensure new features utilize a robust and scalable schema
  • Train and advise the development team on best practices, indexes, query plans, etc.
  • Take an active role in continuous performance tuning initiatives (queries, indexes, and configuration parameters)
• Perform Tasks and Own Assigned Database Projects
  • Complete daily work such as query optimization, schema change reviews, and writing scripts
  • Ensure daily jobs run on multiple servers across multiple environments
  • Develop and maintain documentation related to database systems and procedures
• Assure High Security
  • Ensure sensitive information is properly categorized, stored, and transferred
  • Review and install the latest security patches

Experience:

• Experience with database High Availability Disaster Recovery (HADR), backup strategies, and disaster recovery approaches
• Knowledge of best practices in database design and performance optimization query plans, T-SQL, and monitoring tools
• Experience with cloud-based SaaS solutions, specifically utilizing AWS technologies
• Understanding of ORM concepts and applying database object changes through code migrations
• Understanding of Agile development processes
• Strong critical thinking and problem solving skills
• Experience communicating cross functionally with software development teams

Required:

• 5+ years of experience with PostgreSQL; including performance tuning, query and index optimization, and administration
• Strong knowledge of PostgreSQL internals, configuration, and monitoring tools
• 5+ years of experience with Microsoft SQL Server, with a combination of administration and development
• Bachelor’s degree specializing in computing, engineering, or related field, or equivalent industry experience