What is your experience with SQL and NoSQL databases?

I have experience working with relational databases such as PostgreSQL and MySQL. I have been involved in their deployment, backup, recovery, performance monitoring, and query optimization. I have also worked with data migration.

-- Example of a simple query in PostgreSQL
SELECT id, name, status
FROM users
WHERE status = 'active';

I also have experience with NoSQL solutions, particularly with MongoDB and Redis. In MongoDB, I participated in setting up replication, sharding, and indexing. I used Redis for caching and session management.

// Example query to MongoDB (using mongo shell)
db.products.find({ category: "electronics" });

My experience includes automating database administration using scripts (Bash, Python) and configuration management tools (Ansible).

Database	Type	Key tasks
PostgreSQL	SQL	Deployment, backup, monitoring
MySQL	SQL	Optimization, migration
MongoDB	NoSQL	Replication, sharding, indexing
Redis	NoSQL	Caching, session management

I understand the fundamental differences between SQL and NoSQL databases and can choose the appropriate solution depending on the application's requirements.