Hello, I'm Soni, an EDB PostgreSQL Certified Professional (highest level of PostgreSQL Certification from the most reputable PostgreSQL Certification provider), 11+ years experience in computer Industry, mostly spend my career as PostgreSQL DBA and SQL Developer.
I have experience in designing database, know database normalization, table and column constraints, primary keys and foreign keys, trigger functions, views, materialized views, indexing strategy, etc. I also have much experience with producing reports on sql databases, know advanced query technique, query execution plan and can fine tune query for performance. I have also ever been involved in data analytics project using Looker and AWS Redshift (based on PostgreSQL 8.0) around 4 months, redesign table structure, and creating queries, including involved in migrating SQL Server database to PostgreSQL. I've been in projects regarding SQL Developer.
I have been working as PostgreSQL DBA on USIC since January 2014, here I have been also helping with query tuning. I have been managing about 6 PostgreSQL DB servers, including production DB (sized around 5 TB, 32 core, 145 GB RAM), slony replica, streaming replica, GIS DB, monitoring DB, and developer DB. Here I have done with performance tuning, production DB migration, and also PostgreSQL datacenter migration (complete migration of all PostgreSQL DB servers), routine maintenance, troubleshooting, and daily DBA task.