Description
Expertise in designing, managing, and optimizing relational and NoSQL databases for performance, scalability, and security. Handled everything from schema design to real-time data syncing for mobile apps and enterprise-grade applications.
Key Responsibilities
- Designed and normalized relational database schemas using MySQL for large-scale applications.
- Managed Firebase Firestore and Realtime Database for Flutter-based apps with real-time syncing.
- Performed indexing, query optimization, and stored procedures to improve performance.
- Implemented data migrations, automated backups, and disaster recovery plans.
- Applied data validation, constraints, and ORM tools for consistent and secure access.
Technologies Used
- Relational DB: MySQL, MariaDB
- NoSQL/Cloud DB: Firebase Firestore, Firebase Realtime DB
- Tools: phpMyAdmin, Sequel Pro, Laravel Eloquent ORM, Firebase Console
- Security: User Roles, Data Encryption, Access Rules, Backup Strategies