Postgresql

JD

• DBA with a strong focus on PostgreSQLSQL Fundamentals (DDL) Data types Tables and Indexing Stored Procedures / Functions Views Locking / Blocking / Deadlocking
• TSQL Queries (DML) SELECT / INSERT / UPDATE / DELETE JOINS / UNION
• HA / DR Clustering Backup and restore
• Install & Configuration Install SQL Server Configure instances to best practice SQL PatchingMaintenance and Capacity Planning Index and statistics maintenance Integrity checks Analyse resource use to determine future requirementsMonitoring Monitor Server and Instance resources React to alerts from monitoring tools Proactively review SQL Server health SQL Profiler / Extended Events PerfMon CountersPerformance Tuning and Optimisation Query tuning Query execution plans analysisSecurity Administer logins, roles, users and permissions Troubleshoot login problemsData Extract and Import Troubleshoot production issues with existing deployed packages

Skills Required

Postgresql, Data Extraction, Sql