DOJ: Immediate (15/Jan to 30/Jan)Academics: B.E., B.Tech, MCA
Relevant Exp: 5+yrs in SQL Server, ASP.Net, C#, Classic ASP/VB
Keywords: SQL Server / T-SQL, ER model, BIDS / SSDT, Profiler, Execution Plan, Backup/Restore, Performance, Optimization, Agent Jobs, ASP.Net, C#, VB
B.E, B.Tech, MCA
8+ yrs in Design / build of OLTP applications using SQL Server, C#, ASP.Net, Classic ASP/VB
Predominant work experience should have been in SQL database side
- Passion for TSQL programming and complex algorithms
- Dealt with highly complex OLTP db designs. Lots of tables, views, stored procedures, UDFs
- Very comfortable with DML commands and CTEs, Table Variables, Ranking functions, UDFs/SPs, Outer Joins, Views, Merge statement, Exception Handling, Recursion, Select into statements
- Done bug fixes and enhancements in db layer that is complex
- Done requirement gathering, analysis, estimation
- Designed Logical and Physical Models (Entity Relationship) for OLTP solutions, applied Codd's rules (denormalization included)
- Installed SQL Server, configured security access, restored backups, initialized Server Settings and defaults
- Created / Restored Databases
- Facilitated Integration with business layer and front-end interfaces.
- User Linked Server to integrated with other db instances
- Imported data from other databases and CSV / flat files
- Configured and maintained SQL Agent JOBs
- Studied Query Analyzer Execution plans to tune performance
- Used Profiler to debug or collect inputs for bug fixes
- Coordinated with DBAs to resolve Clustering, Backup/Restore, Performance issues and upgrades to higher versions
- Done programming in Classic ASP / VB or ASP.Net / C#. Aware of Entity Framework, ADO.Net
- Collaborated closely with front-end application teams
Excellent verbal and written communication skills