Overview:
MSSQL
Manage SQL Server databases
Configure and maintain database servers and processes
Monitor system’s health and performance
Ensure high levels of performance, availability, sustainability and security
Analyze, solve, and correct issues in real time
Provide suggestions for solutions
Refine and automate regular processes, track issues, and document changes
Assist developers with query tuning and schema refinement
Provide 24×7 support for critical production systems
Perform scheduled maintenance and support release deployment activities after hours
Respond to alerts and incidents promptly to minimize service disruptions.
Collaborate with Level 1 and Level 2 support and other teams to address escalated incidents.
Postgres
Excellent Knowledge on PostgreSQL Installation, configuration and troubleshooting replication tools - -
Troubleshoot issues involving Unix levels commands
Fix issues related to Backup and Recovery with commands.
Good Hands-on on troubleshooting related to any user related problem like access management, space management, generic errors, etc
Database upgrades and migrations on any Cloud Environment
Different type of replication concepts like Group replication, Multi master replication
Excellent performance troubleshooting using pgadmin commands, tools like pgpool, repmgr, oswatcher, etc
Troubleshooting issues related Database upgrades and migrations.
Install, configure and troubleshooting replication tools
Troubleshoot issues involving Unix, storage or network problem
Create and maintain detailed documentation of database configurations, procedures, and troubleshooting steps.
Respond to alerts and incidents promptly to minimize service disruptions.
Collaborate with Level 1 and Level 2 support and other teams to address escalated incidents.
AWS RDS instance administration, Rehydration, engine upgrade and certificate renewal
