| PostgreSQL Database Administrator || Fort Worth, Texas, USA(day1 onsite) NEED LOCALS at Worth, Illinois, USA |
| Email: [email protected] |
| Greetings from Shrive Technologies LLC!! Shrive Technologies LLC is an IT Development & IT Staffing firm with more than a decade of experience in providing IT Staffing Solutions & Services. Our expertise is in sourcing and deploying highly skilled IT Specialist into mainstream and niche technologies to meet clients Temporary, Permanent & SOW project needs. NOTE:DONT Share the profiles who submitted to HCL in past 3 months Role: - PostgreSQL Database Administrator Location: - Fort Worth, Texas, USA(day1 onsite)NEED LOCALS Responsibilities / JD: 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. Please provide the below details for submission along with Visa copy & Photo ID copy, I94/Passport# Candidate Details Candidate Full Name (As per SSN) Current location (City and State) Open for relocation to work location (Yes/No) Contact/Phone # E-mail Address Visa Type Visa Validity (Month & Year) /Work Authorization Date of Birth (Month & Year Only) Passport Number Bachelors details (University /College & Passing year) Masters details (University/College & Passing year) Total IT experience (Years) Onsite [USA/Canada] Experience (Years) LinkedIn Profile Thanks & Regards, Sr. Recruiter Jeshwini (Jessy) Email: [email protected] linkedin.com/in/jeshwini-u-1ab7311b6 Shrive Technologies LLC 1300 West Walnut Hill Lane 155-H, Irving, Texas 75038, United States www.shrivetechnologies.com -- To post to this group, send email to [email protected]. Keywords: information technology Idaho PostgreSQL Database Administrator || Fort Worth, Texas, USA(day1 onsite) NEED LOCALS [email protected] |
| [email protected] View all |
| Fri May 24 19:11:00 UTC 2024 |