San Mateo, California, United States
• Provided 24/7 support for PostgreSQL production and development databases, ensuring high availability.
• Managed database administration tasks, including installation, configuration, upgrades, patching, migration, and recovery.
• Enhanced database performance through query analysis and optimization,
significantly reducing execution times.
• Improved database health by tuning Auto Vacuum parameters and managing table statistics.
• Configured and monitored replication between master and slave servers for data consistency.
• Optimized connectivity and load balancing using PgBouncer for seamless
application interactions.
• Ensured database security and compliance by applying critical updates and patches in PCI-compliant environments.
• Hired, trained, and mentored a team of 6 database administrators, fostering continuous learning.
• Collaborated with cross-functional teams to design and implement scalable
PostgreSQL solutions.
• Developed and documented standard operating procedures for database management.
• Implemented monitoring and alerting systems to proactively identify and resolve performance issues.