Job Description:
Professional Summary
Experienced SQL Server Developer with expertise in database design, development, administration, performance tuning, data integration, reporting, and business intelligence solutions. Proven ability to develop scalable database solutions, optimize complex queries, automate processes, and support enterprise applications in fast-paced environments.
Core Technical Skills:
Database Platforms
- Microsoft SQL Server 2008/2012/2014/2016/2019/2022
- Azure SQL Database
- SQL Server Management Studio (SSMS)
- SQL Server Data Tools (SSDT)
SQL Development
- T-SQL Programming
- Stored Procedures
- Views
- Functions (Scalar and Table-Valued)
- Triggers
- Common Table Expressions (CTEs)
- Dynamic SQL
- Temporary Tables
- Table Variables
Database Design
- Data Modeling
- Relational Database Design
- Normalization/Denormalization
- Entity Relationship Diagrams (ERD)
- Index Design and Management
- Referential Integrity
Performance Tuning
- Query Optimization
- Execution Plan Analysis
- Index Tuning
- Database Performance Monitoring
- Deadlock Analysis
- Blocking Resolution
- SQL Profiler
- Extended Events
ETL & Data Integration
- SQL Server Integration Services (SSIS)
- Data Migration
- Data Transformation
- Data Import/Export Processes
- Scheduled ETL Jobs
Reporting & Analytics
- SQL Server Reporting Services (SSRS)
- Power BI
- Report Development
- Dashboard Creation
- Data Visualization
- KPI Reporting
Data Warehousing
- Star Schema Design
- Snowflake Schema Design
- Fact and Dimension Tables
- Data Mart Development
- OLAP Concepts
Database Administration
- Backup & Recovery
- Database Maintenance Plans
- Security Management
- User and Role Administration
- Database Monitoring
- Disaster Recovery Planning
Automation & Scheduling
- SQL Agent Jobs
- PowerShell Integration
- Automated Reporting
- Job Scheduling
- Alerting and Notifications
Cloud & Modern Technologies
- Azure Data Factory
- Azure SQL
- Azure Storage
- Azure DevOps
- Git Version Control
Development Methodologies
- Agile / Scrum
- SDLC
- Change Management
- Release Management
- Documentation and Knowledge Transfer
Key Accomplishments
- Developed and optimized complex SQL solutions supporting enterprise business applications.
- Reduced query execution times through advanced indexing and performance tuning.
- Automated data integration and reporting processes, improving operational efficiency.
- Designed and implemented database solutions supporting large-scale transactional systems.
- Created executive dashboards and business intelligence reports for leadership teams.
- Supported critical production systems with high availability and reliability requirements.
Additional Skills
- Microsoft Power BI
- Excel Advanced Analytics
- Data Analysis and Reporting
- ServiceNow Integration
- API Data Integration
- Enterprise Application Support
- Troubleshooting and Root Cause Analysis
