Relational Database Administration and Performance Optimization Project

Overview

This project demonstrates real-world database administration tasks across PostgreSQL, MySQL, and SQLite (Datasette), including user management, backup and recovery, indexing, and query performance optimization.

Key Skills Demonstrated

• Database setup and configuration
• User and role management
• Backup and recovery
• Query performance optimization using indexing
• Storage engine analysis
• View creation
• Multi-database administration

Technologies Used

• PostgreSQL
• MySQL
• SQLite (Datasette)
• SQL
• pgAdmin
• Linux Bash

Project Structure

• PostgreSQL: User management and backup
• MySQL: Restore, indexing, performance tuning
• Datasette: Data restoration, indexing, view creation

Documentation

Full detailed documentation is available in: docs/full_documentation.md

Author

Ashirbad Routray

Date :- 11.02.2026