PostgreSQL Database Administrator (DBA) Hybrid
Accord Technologies Inc, O'Fallon, Illinois, United States
Title: PostgreSQL Database Administrator (DBA)
Location: O'Fallon, MO (Need Onsite Day 1, hybrid 3 days from office).
Duration: 12 months.
Position type: W2 contract.
Responsibilities
Install and configure PostgreSQL database servers on-premises.
Optimize database configuration settings for performance and reliability.
Monitor database performance and resource usage.
Identify bottlenecks and implement performance tuning measures.
Use tools and scripts to analyze query performance and recommend optimizations.
Develop and implement backup and recovery strategies to ensure data integrity and availability.
Regularly review and update security policies and protocols.
Plan and execute database migrations and upgrades with minimal downtime.
Collaborate with developers and application teams to design efficient database schemas.
Ensure normalization and indexing strategies are applied for optimal data retrieval.
Diagnose and resolve database-related issues and errors.
Provide support to application developers in optimizing database interactions.
Requirements
Maintain detailed documentation of database configurations, procedures, and policies.
Document changes made to the database environment and maintain an inventory of databases.
Develop scripts for automation of routine DBA tasks (e.g., backups, monitoring).
Recommend hardware upgrades or changes as necessary.
Work closely with development, network, and security teams to ensure database systems align with overall IT strategy.
Communicate effectively with stakeholders regarding database status, issues, and plans.
Ensure databases comply with relevant regulations and standards (e.g., GDPR, HIPAA).
Seniority level Mid-Senior level
Employment type Contract
Job function Information Technology
Pay Range Base pay: $50.00/yr - $55.00/yr (actual pay based on skills and experience).
#J-18808-Ljbffr
Duration: 12 months.
Position type: W2 contract.
Responsibilities
Install and configure PostgreSQL database servers on-premises.
Optimize database configuration settings for performance and reliability.
Monitor database performance and resource usage.
Identify bottlenecks and implement performance tuning measures.
Use tools and scripts to analyze query performance and recommend optimizations.
Develop and implement backup and recovery strategies to ensure data integrity and availability.
Regularly review and update security policies and protocols.
Plan and execute database migrations and upgrades with minimal downtime.
Collaborate with developers and application teams to design efficient database schemas.
Ensure normalization and indexing strategies are applied for optimal data retrieval.
Diagnose and resolve database-related issues and errors.
Provide support to application developers in optimizing database interactions.
Requirements
Maintain detailed documentation of database configurations, procedures, and policies.
Document changes made to the database environment and maintain an inventory of databases.
Develop scripts for automation of routine DBA tasks (e.g., backups, monitoring).
Recommend hardware upgrades or changes as necessary.
Work closely with development, network, and security teams to ensure database systems align with overall IT strategy.
Communicate effectively with stakeholders regarding database status, issues, and plans.
Ensure databases comply with relevant regulations and standards (e.g., GDPR, HIPAA).
Seniority level Mid-Senior level
Employment type Contract
Job function Information Technology
Pay Range Base pay: $50.00/yr - $55.00/yr (actual pay based on skills and experience).
#J-18808-Ljbffr