PostgreSQL NuStar Technologies
NuStar Technologies
Office Location
Full Time
Experience: 5 - 5 years required
Pay:
Salary Information not included
Type: Full Time
Location: Hyderabad
Skills: Database Administration, Backup Recovery, Performance Tuning Optimization, High Availability HA Replication, Security Compliance, Troubleshooting Issue Resolution, Automation Scripting, Database Design Capacity Planning, Patch Management Version Upgrades, Cloud Hybrid Database Management, CrossTeam Collaboration
About NuStar Technologies
Job Description
Role: PostgreSQL DBA Exp: 5-10yrs Location: Mumbai,Pune, Delhi, Kolkata, Hyderabad, Bangalore Notice Period: 0-45days only JD PostgreSQL DBA (L2 & L3) Database Administration Install, configure, and manage PostgreSQL databases (versions 11, 12, 13, 14, 15/All Versions) in production, staging, and development environments. Backup & Recovery Implement and manage backup, WAL archiving, and PITR (Point-In-Time Recovery) for data protection. Performance Tuning & Optimization Use EXPLAIN ANALYZE, tuning, and indexing strategies for query optimization. High Availability (HA) & Replication Configure and manage Streaming Replication, Logical Replication for HA clusters. Security & Compliance Manage roles, Implement SSL/TLS encryption, role-based access control (RBAC), auditing, and GDPR/security compliance. Troubleshooting & Issue Resolution Analyze logs, resolve deadlocks, replication lag, slow queries, and performance bottlenecks. Automation & Scripting Develop automation scripts using for maintenance and monitoring tasks. Database Design & Capacity Planning Support schema normalization, partitioning, and sharding for large-scale deployments. Patch Management & Version Upgrades Apply PostgreSQL minor/major version upgrades and security patches with minimal downtime. Cloud & Hybrid Database Management Manage PostgreSQL databases in on-premises/Cloud. Cross-Team Collaboration Work with developers, DevOps, and system administrators to optimize database performance and reliability.,