Accord Technologies Inc · 1 month ago
PostgreSQL Database Administrator (DBA) Hybrid
O'Fallon, IL
Contract
Hybrid
Mid LevelAccord Technologies Inc is seeking a PostgreSQL Database Administrator (DBA) to manage and maintain PostgreSQL databases within their infrastructure. The role involves installing and configuring database servers, optimizing performance, and collaborating with development teams to ensure efficient database schemas.
Information Technology & Services
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
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)
Recommending 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)
Qualification
Required
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
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)
Recommending 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)
Company
Accord Technologies Inc
We are one of the pioneers in Information technology consulting and staffing industry.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase