Description
SKILLS Certified Database Administrator with over 6 years of hands-on experience in database administration and architecture supporting of database engine such as, PostgreSQL. Skilled at analyzing Pg_stat_activity, pg_stat_statement, pg_views, PEM reports in order to troubleshoot performance issues. Highly detailed, with a drive to continually expand and update knowledge to better service PostgreSQL Databases and assist in solving problems. Looking to apply skills learned through experience in assisting another company as a Database Administrator AREAS OF EXPERTISE PostgreSQL 9.6, 10 and 11 * Installation & Configuration * Migration of Systems * Upgrades & Patches * Backup and Recovery * Development * Testing * QAT * Project & Production Support Performance Tuning * Streaming Replication * Logical replication * Creation of Conceptual, Logical, & Physical Data Models * Explain Analyzed * Optimization of SQL & PgSQL Scripts * Database Security Administration * Pg_views, pg_stat_activity * AWR Report * * Linux OS/CentOS * Fine Grain Auditing * Flashback * SQL-Trace * TKPROF * SHELL Scripts * OEM Database & Grid Control SQL SERVER (2 years) * POSTGRESQL * Pgpool-II3.5 PostgreSQL 9.6, 10 and 11 * Installation & Configuration * Migration of Systems * Upgrades & Patches * Backup and Recovery * Development * Testing * QAT * Project & Production Support Performance Tuning * Streaming Replication * Logical replication * Creation of Conceptual, Logical, & Physical Data Models * Explain Analyzed * Optimization of SQL & PgSQL Scripts * Database Security Administration * Pg_views, pg_stat_activity * AWR Report * * Linux OS/CentOS * Fine Grain Auditing * Flashback * SQL-Trace * TKPROF * SHELL Scripts * OEM Database & Grid Control SQL SERVER (2 years) * POSTGRESQL * Pgpool-II3.5