Database Administrator (PostgreSQL)
Prestige Staffing, Atlanta, GA, United States
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
#J-18808-Ljbffr
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
#J-18808-Ljbffr