SQL Developer – 4 Years of Experience
Profile Summary:
Skilled SQL Developer with 4 years of hands-on experience in designing, developing, and optimizing SQL queries, stored procedures, and database structures. Proven ability to work across the full development lifecycle, including requirement analysis, database design, data integration, reporting, and performance tuning. Adept at managing complex data sets and ensuring data accuracy, integrity, and security in both OLTP and OLAP systems.
Key Skills:
SQL (T-SQL / PL/SQL)
MySQL, PostgreSQL, SQL Server, Oracle
Stored Procedures, Triggers, Functions
Data Modeling & Normalization
ETL Processes
Indexing & Query Optimization
SSIS, SSRS / Power BI (if applicable)
Backup, Recovery & Security
ER Diagrams, Relational Database Design
Agile / Scrum methodologies
Git / Version Control
Roles & Responsibilities:
Write complex SQL queries, views, functions, and stored procedures for data extraction, transformation, and reporting.
Design and implement normalized and denormalized database schemas.
Collaborate with application developers and analysts to optimize backend performance and ensure efficient data flow.
Perform query tuning and indexing to improve performance for large databases.
Handle database updates, migrations, and deployment scripts in production and staging environments.
Develop and maintain ETL pipelines to support data warehousing and reporting.
Generate regular and ad-hoc reports using SQL queries and BI tools.
Ensure data integrity and compliance with security standards.
Support database backups, restores, and disaster recovery processes.
Participate in code reviews, requirement gathering, and system testing phases.
Achievements:
Reduced query execution time by 60% through optimized indexing and refactored SQL.
Automated report generation process, cutting down manual effort by 80%.
Successfully migrated legacy database to a more scalable and secure schema structure.
Implemented data quality checks resulting in 99.9% data accuracy in reports.