Postgress SQL DBA with a strong focus on PostgreSQLSQL Fundamentals (DDL)Data typesTables and IndexingStored Procedures / FunctionsViewsLocking / Blocking / Deadlocking TSQL Queries (DML)SELECT / INSERT / UPDATE / DELETEJOINS / UNION HA/DRClusteringBackup and restore Install & ConfigurationInstall SQL ServerConfigure instances to best practiceSQL PatchingMaintenance and Capacity PlanningIndex and statistics maintenanceIntegrity checksAnalyse resource use to determine future requirementsMonitoringMonitor Server and Instance resourcesReact to alerts from monitoring toolsProactively review SQL Server healthSQL Profiler / Extended EventsPerfMon CountersPerformance Tuning and OptimisationQuery tuningQuery execution plans analysisSecurityAdminister logins, roles, users and permissionsTroubleshoot login problemsData Extract and ImportTroubleshoot production issues with existing deployed packages
Job Classification
Industry: Recruitment / StaffingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full time