- Relational Database Administration (Microsoft SQL Server, MySQL, PostgreSQL)
- Database Installation, configuration, hardening, best practices, etc
- Optimizing query performance by reviewing Execution Plans
- Implementation of security measures such as encryption, user management, and access control to protect sensitive data
- Database maintenance activities like Index Rebuilding, Reorganizing and Update Statistics
- Data clean-up, archival & Purging mechanism
- Anticipate and solve performance issues like blocking, deadlocks etc.
- Cluster and AG setup configuration, backups/restorations for disaster recovery, Replication for separate OLAP reporting
- Configuring In-Memory Tables as well as Table partitions
- Enable System Versioning and CDC for capturing changes
Databases: SQL Servers 2019, MySQL 8, PostgreSQL
IDE: SSMS, SQL Yog, PgAdmin, Toad