• Spearheaded Data Governance and Compliance initiatives, ensuring adherence to industry standards.

• Enhanced query performance through SQL optimizations and Snowflake warehouse resizing, achieving over $100K in annual savings on various ETL pipelines.

• Developed and optimized ETL processes across PostgreSQL, S3, Kafka, and REST APIs.

• Created automated data pipelines compliant with Data Privacy regulations, improving operational efficiency.

• Managed AtScale cubes for critical Tableau reports, ensuring timely and accurate data insights.

• 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.