Job Summary
MSSQL DB Admin
PostgreSQL DB
Ubuntu OS Support
Responsibilities
MSSQL
Manage SQL Server databases
Configure and maintain database servers and processes
Monitor systems health and performance
Ensure high levels of performance availability sustainability and security
Analyze solve and correct issues in real time
Able to Write complex T-SQL Stored procedures and functions to automate regular SQL DBA Activities
Refine and automate regular processes track issues and document changes
Assist developers with query tuning and schema refinement
Provide 24x7 support for critical production systems
Perform scheduled maintenance and support release deployment activities after hours
Able to Support SQL Servers in Case sensitive environment
Able to work on issues a raised in Log Shipping Replication Mirroring and Always on
POSTGRESQL
Become an active DBA team member to jointly support day to day database operations (POSTGRESQL & MSSQL)
Troubleshoot database incidents
Ensure databases are monitored and remain available and optimal
Database maintenance - backup & recovery maintaining replication and hot standby clusters using Patroni
Database optimization - indexing analyzing bloat management and vacuuming
Database monitoring - actively monitor and react. Add new service checks
Ticketing - organize prioritize and service DBA related tickets within SLA
Optimize existing queries functions and enhance runtime performance
Provide support in and out of working hours as part of a formal on-call support rotation
Recommend improvements for existing operations with better tools and methodologies
Experience with Docker and Ansible is Must
Experience with PostgreSQL HA backup & recovery and replication methodologies & tools
Experience with Patroni is a plus
Good understanding & hands-on experience with Linux OS (Redhat & Ubuntu)
Linux Shell scripting - ability to understand & write scripts in support of DBA-related tasks
Experience in performance tuning of host hardware & databases
Ability to understand write diagnose