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.