-
US Citizen
-
Green Card
-
EAD (OPT/CPT/GC/H4)
-
H1B Work Permit
-
Corp-Corp
-
W2-Permanent
-
W2-Contract
-
Contract to Hire
-
UG :- - Not Required
-
PG :- - Not Required
-
No of position :- ( 1 )
-
Post :- 10th Apr 2024
- Install, configure, and upgrade PostgreSQL database software and related tools.
- Design and implement backup and recovery strategies to ensure data integrity and availability.
- Monitor and tune database performance to optimize query execution and improve overall system efficiency.
- Perform database capacity planning and resource management to ensure scalability and high availability.
- Manage database security, including user access control, authentication, and data encryption.
- Collaborate with development teams to design, implement, and optimize database schemas and queries.
- Troubleshoot and resolve database-related issues, including performance bottlenecks, data corruption, and system failures.
- Implement and maintain database replication, clustering, and high-availability solutions.
- Develop and maintain documentation, including database design, installation procedures, and configuration details.
- Stay up-to-date with the latest PostgreSQL features, technologies, and best practices.
- Qualifications and Skills:
- Bachelor's degree in computer science, information technology, or a related field (or equivalent work experience).
- Proven experience as a PostgreSQL DBA, including installation, configuration, and administration of PostgreSQL database systems.
- Strong understanding of relational database concepts and SQL.
- Proficiency in performance tuning, query optimization, and troubleshooting database issues.
- Experience with backup and recovery strategies, including point-in-time recovery and disaster recovery.
- Familiarity with database security principles and best practices.
- Experience with replication, clustering, and high-availability solutions for PostgreSQL (e.g., streaming replication, logical replication, Pgpool-II, Patroni).
- Knowledge of Linux/Unix operating systems and shell scripting.
- Excellent problem-solving and analytical skills.
- Strong communication and collaboration skills.