Database Administrator

As a PostgreSQL Database Administrator, your role involves the installation, configuration, and maintenance of PostgreSQL databases in various environments. You will be responsible for ensuring database availability, reliability, and scalability. Your key responsibilities include: - Installing, configuring, and maintaining PostgreSQL databases in development, testing, and production environments. - Performing regular database backups, restorations, patching, and version upgrades. - Monitoring database performance, identifying bottlenecks, and implementing tuning strategies. - Optimizing queries, indexing, memory configuration, and storage utilization. - Conducting capacity planning for efficient resource allocation. - Designing and implementing database schemas, tables, views, indexes, and constraints. - Supporting development teams with data modeling, normalization, and SQL best practices. - Diagnosing and resolving database-related issues, including performance problems, replication failures, and data inconsistencies. - Implementing and managing PostgreSQL replication solutions for high availability and disaster recovery. - Enforcing database security policies, user access management, and role-based permissions. - Communicating technical concepts clearly to internal teams. Your qualifications for this role include: - Strong experience of 3+ years in PostgreSQL Database Administration, covering maintenance, backups, and upgrades. - Proficiency in Database Design to support business applications effectively. - Ability to troubleshoot and resolve technical issues with databases. - Knowledge of replication techniques for data synchronization and high availability. - Familiarity with PostgreSQL systems and related tools is highly desirable. - Good analytical and problem-solving skills. - Effective communication and collaboration abilities within a team environment. Preferred qualifications include a degree in Computer Science, Information Technology, or a related field, along with relevant database management certifications. Please note that the Job Description is based on the information provided and additional details about the company were not included in the job description.,