Jagdeep

Freelance Database Expert & Database Designer

1356
Location:Toronto, Ontario, Canada
Profile:https://www.freelanced.com/jagdeep
0
Kudos
3.5
2 Skills
Ask
Rate/Hr
SQL Data Base Administrator/Analyst

HIGHLIGHTS
• 5+ years of experience of administrating Microsoft SQL Server
• Installed, configured and secured SQL Production server
• Dealt with performance problems and monitored the database environment to optimize performance
• Developed high-availability solutions including clustering and mirroring
• Planned database backup strategies and recovery models
• Certified as a Microsoft Certified Technology Specialist Certification in Business Intelligence
• Experienced with SSIS, designing packages
• Created and troubleshot T-SQL queries

TECHNICAL EXPERTISE

Databases: SQL Server 2005/08, SSIS, SSRS
Application Software: MS Word, MS Excel, MS Power Point
Programming Language: SQL, VHDL
Operating Systems: Window 98, XP, Vista, Window 7, Window Server 2003

SUMMARY OF SKILLS
Database Skills
• Developed and tested Data Base objects
• Processed SSIS packages and data importing
• Monitored backup schedules and restore options
• Maintained Server and Database security
• Ensured data availability using non-disrupted administration strategies

Programming Skills
• Identified customer’s problem and filled bugs with SQL server development team
• Created and updated Database tables, views, functions and stored procedures
• Examined database consistency checks
• Improved Database efficiency by 10% using ETL Tools in SSIS

Management Skills
• Planned job schedules, database growth requirements
• Coordinated with the Development Team to design SSIS packages
• Organized Technical meetings with project team and customers
• Supplied advice on design and planning strategies

Interpersonal Skills
• Interacted with the Team Leads and the Project Manager for implementation of SQL Server
• Consulted the development team in concern to project development
• Provided technical support to the development team

Customer Support Skills
• Addressed clients' requirements and coming up with database design and application architecture
• Served as Online troubleshooter in the client environment
• Fulfilled customers needs to ensure good customer service
Skills (2) Rating
Database
Database Design