Designing reliable database structures, writing efficient queries, and migrating data from legacy systems (including Excel) into proper database environments.
What I can do:
- Database schema design
- Writing and optimizing complex SQL queries
- Normalizing messy or inconsistent data
- Migrating data from spreadsheets/legacy systems into databases
- Performance tuning of slow queries
- Setting up relationships and constraints for data integrity
Technologies: SQL, MySQL, SQL Server, PostgreSQL, Access
Examples of completed projects:
- Migration of a large Excel-based customer database into a proper SQL database
- Query optimization for a slow-running reporting system
- Database schema redesign for a growing internal business tool
- Data deduplication and standardization project
- Multi-table relational database built from scratch for a business tracking system