Job Description

Job SummaryMSSQL DB AdminPostgreSQL DBUbuntu OS SupportResponsibilitiesMSSQLManage SQL Server databasesConfigure and maintain database servers and processesMonitor systems health and performanceEnsure high levels of performance availability sustainability and securityAnalyze solve and correct issues in real timeAble to Write complex T-SQL Stored procedures and functions to automate regular SQL DBA ActivitiesRefine and automate regular processes track issues and document changesAssist developers with query tuning and schema refinementProvide 24x7 support for critical production systemsPerform scheduled maintenance and support release deployment activities after hoursAble to Support SQL Servers in Case sensitive environmentAble to work on issues a raised in Log Shipping Replication Mirroring and Always onPOSTGRESQLBecome an active DBA team member to jointly support day to day database operations (POSTGRESQL & MSSQL)Troubleshoot database incidentsEnsure databases are monitored and remain available and optimalDatabase maintenance - backup & recovery maintaining replication and hot standby clusters using PatroniDatabase optimization - indexing analyzing bloat management and vacuumingDatabase monitoring - actively monitor and react. Add new service checksTicketing - organize prioritize and service DBA related tickets within SLAOptimize existing queries functions and enhance runtime performanceProvide support in and out of working hours as part of a formal on-call support rotationRecommend improvements for existing operations with better tools and methodologiesExperience with Docker and Ansible is MustExperience with PostgreSQL HA backup & recovery and replication methodologies & toolsExperience with Patroni is a plusGood understanding & hands-on experience with Linux OS (Redhat & Ubuntu)Linux Shell scripting - ability to understand & write scripts in support of DBA-related tasksExperience in performance tuning of host hardware & databasesAbility to understand write diagnose

Cognizant