PostgreSQL Database Administrator

Skills (Must have):Strong understanding of relational database design and development.Proficiency in writing complex SQL queries and stored procedures.Hands-on experience with database utilities and tools for maintenance and performance optimization.Knowledge of database replication, tablespace management, and security best practices.Experience in providing guidance and collaboration with development teams.Ability to automate database management tasks and optimize data loading processes. Responsibilities:Create database objects such as triggers, indexes, and views to support applications.Set up and manage streaming replication between databases.Monitor database performance and make necessary adjustments for optimal performance.Identify and resolve potential database issues proactively.Manage and maintain database backups, and perform restoration as needed.Ensure database security by applying preventive measures and adhering to security guidelines.Schedule regular maintenance activities on database servers.Maintain the database schema and manage database availability.Provide best practice guidance to the development team regarding database usage.Resolve any production data-related issues and manage tablespaces.Manage roles, privileges, and user access permissions by adding or removing users as required.Automate data loading processes to improve efficiency.Develop and maintain relational databases to meet application needs.Ensure data integrity and manage user access through defined permissions.Utilize utilities like pg_ctl and psql for effective database management.Write complex queries, functions, and procedures to retrieve data as required.Analyze query costs and implement optimizations to improve performance. Qualification: M.C.A, B.Sc/MSc Computers, B.E /B.Tech in Computer Science, Engineering, or a related field.