Omkar Gaikar
PostgreSQL Database Administrator
- Role
- Database Administrator at Clover Infotech
- Location
- Navi Mumbai, IN
- LinkedIn followers
- 500 followers
About Omkar Gaikar
Experienced PostgreSQL Database Administrator with a strong background in database…
Experience
Database Administrator
Oct 2023 — Present
Database Installation & Configuration:Install, configure, and upgrade PostgreSQL databases to ensure optimal performance and reliability.Set up database instances in on-premises and cloud environments (AWS RDS, Azure, Google Cloud).2. Performance Optimization:Optimize database performance through proper indexing, query tuning, and monitoring.Utilize tools like pg_stat_statements, EXPLAIN ANALYZE, and auto_vacuum for performance analysis.3. High Availability & Replication:Implement and manage high availability solutions such as Streaming Replication, Patroni, and pgpool-II.Ensure database failover mechanisms are in place for minimal downtime.4. Backup & Disaster Recovery:Design and implement backup and recovery strategies using tools like pgBackRest and WAL archiving.Regularly test database restoration and disaster recovery plans.5. Security & Compliance:Enforce database security best practices, including access control, encryption, and auditing.Manage user roles, privileges, and authentication mechanisms to ensure data protection.6. Automation & Scripting:Automate routine database administration tasks using Shell scripting and Python.Develop scripts for automated monitoring, alerts, and maintenance.7. Troubleshooting & Issue Resolution:Diagnose and resolve database performance issues, slow queries, and connection problems.Analyze logs and system metrics to ensure database stability and reliability.8. Collaboration with Developers:Work closely with developers to optimize SQL queries and database design.Provide best practices for schema design, indexing strategies, and stored procedures.9. Monitoring & Maintenance:Continuously monitor database health using tools like pgAdmin, Prometheus, and Grafana.Schedule routine database maintenance, including vacuuming, reindexing, and log rotation.10. Cloud Database Management:Manage PostgreSQL instances in cloud environments.
Education
Dr Babasaheb Ambedkar Technological University
Bachelor of Technology, Computer Engineering
2015 — 2019
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.