Job Description

Required - Install, configure, and maintain PostgreSQL database systems across multiple environments (development, testing, production). - Monitor database performance, troubleshoot issues, and implement optimizations to enhance performance and scalability. - Ensure data integrity, availability, and security through regular backups, replication, and disaster recovery planning. - Develop and implement database partitioning, indexing, and performance tuning strategies. - Create and maintain database documentation, including design specifications, data dictionaries, and operational procedures. - Collaborate with application developers to design and optimize database schemas and queries. - Implement and manage user access controls, roles, and permissions to ensure data security and compliance. - Manage database migrations, upgrades, and patches, ensuring minimal downtime and disruption to operations. - Provide support for troubleshooting and resolving database-related incidents and service requests. - Stay updated on PostgreSQL best practices, features, and available tools, and assess their applicability to our organization. - Participate in on-call rotation and provide support to resolve high-impact database incidents . Roles & Responsibilities Postgres -Expert in below areas Database Performance Tuning SQL Query Rewrite Procedure Rewrite Writing stored procs ,tables, functions, views, joins SQL Query Tuning Scripting-Shell & Python(pyodbc,pymssql,sqllite3,psycopg2,cx_oracle,sqlalchemy