Postgresql Database Administrator

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