| Need || 14+ years PostgreSQL DBA | Fort Worth, TX at Worth, Illinois, USA |
| Email: [email protected] |
| Hi Hope to do well My name is Ankit Kumar, a Lead Technical Recruiter with CBL Solutions. We are looking for a suitable candidate for the position, I came across your resume and found this a perfect fit for this role. I would appreciate it if you can provide the best time and number to reach you to discuss this further Position: PostgreSQL DBA Location: Fort Worth, Texas Experience : 14+ years Rate: $60/hr on CTC In PostgreSQL, a Database Administrator (DBA) is responsible for the installation, configuration, maintenance, and overall management of the PostgreSQL database system. The roles and responsibilities of a PostgreSQL DBA can be categorized into several key areas: 1. **Installation and Configuration**: - Install PostgreSQL on various platforms. - Configure PostgreSQL to meet specific performance and security requirements. - Set up and manage configuration files like `postgresql.conf` and `pg_hba.conf`. 2. **Database Design and Development**: - Design and create databases and schemas. - Create and manage database objects such as tables, indexes, views, and sequences. - Implement data integrity and normalization. 3. **User Management and Security**: - Create and manage database users and roles. - Define and enforce database security policies. - Manage access controls using GRANT and REVOKE statements. - Implement SSL/TLS for secure connections. 4. **Backup and Recovery**: - Develop and implement backup strategies. - Perform regular backups of databases. - Test and execute recovery procedures. - Use tools like `pg_dump`, `pg_restore`, and `pg_basebackup`. 5. **Performance Tuning and Optimization**: - Monitor database performance and resource utilization. - Identify and resolve performance bottlenecks. - Optimize queries and database structures. - Use tools like `EXPLAIN`, `VACUUM`, and `ANALYZE`. 6. **Maintenance and Upgrades**: - Perform routine maintenance tasks such as vacuuming, analyzing, and reindexing. - Plan and execute database upgrades and patching. - Monitor and manage database replication and failover strategies. 7. **Monitoring and Troubleshooting**: - Monitor database health and respond to alerts. - Troubleshoot database issues and errors. - Use logging and monitoring tools like `pg_stat_activity`, `pg_stat_replication`, and third-party monitoring solutions. 8. **Data Migration and Replication**: - Plan and execute data migrations between PostgreSQL instances or from other database systems. - Set up and manage replication (e.g., streaming replication, logical replication). - Ensure data consistency and availability. 9. **Compliance and Documentation**: - Ensure compliance with relevant data protection regulations. - Maintain thorough documentation of database environments, procedures, and configurations. - Keep track of database changes and maintain version control. 10. **Automation and Scripting**: - Automate routine DBA tasks using scripts and tools. - Develop and maintain custom scripts for specific DBA tasks. - Use tools like cron jobs for scheduled tasks. A PostgreSQL DBA needs to have a solid understanding of SQL, database design principles, and system administration skills, as well as familiarity with the specific features and tools provided by PostgreSQL. Ankit Kumar Team Lead [email protected] https://www.linkedin.com/in/ankit-kumar-6300111a1/ Cerebral Technologies, Inc (D.B.A CBLSolutions) | http://cblsolutions.com/ 400 E Royal Lane, Ste 235, Irving, TX -75039 -- Keywords: information technology Texas Need || 14+ years PostgreSQL DBA | Fort Worth, TX [email protected] |
| [email protected] View all |
| Fri May 24 20:44:00 UTC 2024 |