Empowering DBA Knowledge Master PostgreSQL, Oracle, SQL Server, MongoDB, Linux, Kubernetes, Azure, AWS, Performance Tuning, High Availability, Backup & Recovery, and Enterprise Database Administration through practical, production-ready guides.
PostgreSQL
Master PostgreSQL Administration, Performance Tuning, Replication, Backup & Recovery, and High Availability.
Oracle Database
Oracle RAC, ASM, Data Guard, RMAN, Performance Tuning, Migration and Enterprise Database Administration.
SQL Server
SQL Server Performance Tuning, Query Store, Always On, Deadlocks, Indexing and Enterprise Administration.
MongoDB
MongoDB Replica Sets, Sharding, Atlas, Backup, Monitoring and Performance Optimization.
Recent posts
Show more
Security
Oracle VPD in Practice: Read-Only Support Access Without Exposing Restricted Customers
Tested on: Oracle Database 19c Enterprise Edition 19.27 | Level: Intermediate …
Read more
Performance Tuning
Oracle Exadata Write-Back Flash Cache Explained
Oracle Exadata Write-Back Flash Cache Explained …
Read more
Oracle
Oracle Clusterware and RAC Startup Sequence
Oracle Clusterware and RAC Startup Sequence Oracle Clusterware and RAC Star…
Read more
PostgreSQL
Setting Up Logical Replication in PostgreSQL: A Step-by-Step Guide
Setting Up Logical Replication in PostgreSQL: A Step-by-Step Guide March 26, 20…
Read more
Troubleshooting
Fixing RMAN DBMS_BACKUP_RESTORE Version Errors After an Oracle Upgrade
Recently, I undertook the task of upgrading an Oracle database from version 1…
Read more
- Tamilselvan Perumal
- I'm Tamilselvan Perumal, an Oracle ACE Apprentice and Senior DBA with 12+ years running Oracle, PostgreSQL, SQL Server, MongoDB and CockroachDB for Tier-1 global banks. On TechStarAdmin I share hands-on, production-tested guides on performance tuning, high availability, security and migrations.