Tune a PostgreSQL in RDS

I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Amazon Web Services, Database Administration, Database Programming, PostgreSQL. Please ping me for more discussion.

I have 8 years of experience in managing complex linux architectures and managing cloud infrastructures. I have worked on many complex projects ( Private cloud setup on AWS, Load balancing clusters, Replication systems and many more). I have versatile experience in setting up and managing server and also optimising them for best usage and fine tuning the security aspects. I have expertise in below fields :- 1 Linux Administration. 2 Windows Administration (Windows 2008 , 2012 & 2016) and Migration. 3 Cloud computing ( AWS, Azure and Google Cloud). 4 Automation ( Ansible,Puppet and Chef). 5 Application's & Web servers ( Apache, nginx, IIS and Tomcat ). 6 Databases ( Mysql, MsSql, MongoDB, postgresql and Apache CouchDB). 7 Security ( Web Security, Server hardening and IPS && IDS configuration) 8 Virtualization( KVM, Xen, OpenVZ & Parallels Virtuozzo). 9 Control Panels ( Cpanel, website panel, zpanel and parallel plesk panel). 10 Shell scripts, python & Perl etc. 11 Mail servers.

Hi, I'm a DB expert from Bulgaria(EU) with strong experience in wide variety of RDBMS: MySQL, PostgreSQL, MS SQL Server, Oracle, Teradata and a few others.. I have a solid knowledge in writing and tuning complex SQL queries, functions, stored procedures, etc... Besides that, I'm well familiar with the internals of the mentioned RDBMS, so I feel comfortable performance tuning and optimizing the database engines and structures (tables, indexes, statistics). Best Regards, Veselin Z.

I have worked on PostgreSQL extensively, both setting up from AWS RDS console, writing queries, reviewing query explain plans, understanding the indexes used by queries, query fine tuning.

1) Aanalyze vmstat/ststat system analysis. 2) Tunung the postgreSql instance parameter. 3) Alocation/limiting resource to the 80% of the system capacity! 4) Followups based on further bids Relevant Skills and Experience 20+ years experice in Database Admin like Build, config, tune, trouble shooting in oracle, Db2, Mssql, Mysql, EDB postgreSql, Netteza, Exadata, MariaDB and Terradata!