|
|
|
Professional Profiles |
|
IT-CAREERNET
.
|
From: Varinder Sohal - Sr.SQL Server Administrator
Date: Thursday, April 22, 2004
Time: 08:07 AM
Varinder Singh Sohal Kalyan Mansion, 6-3-1100/4,IIIc Floor, Ayypa Swami Temple Street, SomajiGuda, Hyderabad, Landline: 91-040-55473628 (O) Mobile: +91-98480-88748 (R) E-mail: sohal_vs@yahoo.co.uk ---------------------------------------------------------------------------------------- A Highly talented and accomplished IT management professional with extensive skills and experience in Database management, Technical Support, Software development, System and Web Administration. Summary * Proven ability to lead and direct DBA Teams from last 5 years. * Specialization in remotely administrating & Troubleshooting MS-SQL Server 7.0/2000 Problems. * Proven ability to manage more than 25 projects. * Ability to manage IIS and troubleshooting Exchange server problems. * Excellent skills to installing and helping development teams to boost T-SQL performance. * Knowledge in resource management and filling gap between Developer and DBA. * Good experience of YUKON server. * Excellent presentation and communication skills. Ability to resolve windows 2000 problem in odd situations. * Multiple professional certificates. Technical Skills **Operating System Windows NT – XP, Novell Netware, SCO-Unix ,Linux, Windows 2003 **Database Administration SQL Server 7.0, 2000, Oracle 8.1, Erwin, Visio 2003, YUKON Beta 2 **Networking Servers Citrix, MS content management Server, MS Exchange server **Software / Tools IIS 4.0 - 5.0, MS Project, C, C++, COBOL, PASCAL FOXPRO, dBase, Clipper, ASP,ASP.NET ,VB SCRIPT, JAVA SCRIPT, XML, FLASH, HTML, DHTML, What’s up Gold, Acrobat, Flash Currently working on .Net, Web services and source depot,.Net Visual Studio Professional BackGround Accenture Microsoft Engagement (thru SSG),Hyderabad (Full Time) Feb 2004 – Present Consultant, SQL Server Database Server: Yukon * Database Administrator for MS Internal Project Metropolis * Playing Key role in troubleshooting performance problems of production teams using SQL Profiler * Achieved expertise to Benchmark and standardize written stored procedure by different vendor teams like Wipro , Satyam, TCS and Accenture * Achieved expertise to troubleshoot T-SQL performance issues in already written Stored Procedures * Obtained good knowledge of Yukon in short span and got responsibility to write XML based stored procedures. * Implemented techniques to improve T-SQL performance * Helping other teams to setup maintenance plans and jobs on production servers Project Descriptions: Metropolis project internal to Microsoft. Metropolis will replace Microsoft various incident tracking systems with integration of other SSIT legacy systems. It will provide user interfaces that will enable PSS to provide excellent customer service. Metropolis combines two earlier initiatives, Vajra (MSN, Xbox, etc.) and Clarify (CRM) Componentization (PSS), into a single project to build a global incident management platform that will address the needs of all of the Microsoft support services organizations. Worked on sub-modules of Metropolis which are as follows: 1) Team Admin 2) User Profiles 3) User preferences Netcradle India Pvt. Ltd., New Delhi (Full Time) October 2000 – Feb 2004 Senior Database Administrator Database Server: SQL 2000 * Remote server administrator of 3 server in USA, 4 in UK and 2 in Delhi * Implemented Database Security policy in SQL-2000. * Supported development team * Managed Databases and troubleshooting SQL related problems * Provided 24x7 technical supports for remote servers. * Implemented database backup, restore and recovery policies. * Setup Jobs and maintenance plans * Created Physical and logical design of database. * Laid down procedure to Transferring and managing data. * Set up SQL Mail * Expertise in SQL Installation and monitoring and optimizing SQL performance. * Managed system team i.e. DBA, webmaster and system administrator. * Managed Juniors project for 6 months * Liaison with SILVERLINE Tech. And Vsoft to get finalise the business specifications for juniors in 2000-2001. * Managed Royal Hospital of Neurosurgery, UK Project * Managed the team of 25 developers. Also Administrated and managed following sites for Netcradle India Pvt. Ltd.: Juniors URL: www.juniors.net Netcradle URL: www.netcradle.com Content shop URL: www.thecontentshop.com MPP -Site of 5* Hotel, Majestic Park Plaza, Ludhiana URL: www.majesticparkplaza.com Skills international URL: www.skillsinternational.org Life builder URL: www.lifebuilder.org Printshop URL: www.theprintshop.co.uk IRB InfoTech (P) Ltd., Ludhiana (Full Time) April 1999 - September 2000 System Manager Database Server: SQL 2000/Oracle * Installed MS-SQL 7.0 and looked after client problems at their end * Monitored and optimized MS-SQL 7.0 at client end * Installed oracle server and clients on Windows NT network. * Involved in physical and Logical design of database using MS-SQL and Oracle. * Prepared supporting documentation for the team of Software engineers. * Helped System team to setup NT based Networking. * Developed ASSET Management Software for our client CMC Hospital, Ludhiana using Oracle 8.0 and Developer 2000, also provided technical support at client end. Rajeev Industrial Corporation, Ludhiana (Full Time) March 1996 - March 1999 IT Consultant Database Server: Oracle7.0 * Contributed to the design and development of application software of the company. * Provided Technical support * ORACLE Installation and administration * Implemented SQL query optimization techniques * Implemented security and backing up Techniques * Developing “Sales Order Processing”, “Inventory Control” and “General Accounting “ software using Foxpro and Oracle for the company * Prepared project documentation and training staff to use the software. North Computers, Ludhiana (Full Time) Jan 1990 - April 1996 Senior Analyst/Programmer * Contributed to the requirements analysis and high-level design of Inventory Control, Invoicing System, and sales management. * Converted manual work to IT enabled work. * Provided training staff * Analyzed and rectified user problem. Education * Masters in Computer Science (M.Sc),Maharishi Dayanand University, Rohtak (2002) * PG in Computer Scs. and Applications (PGDCA) Kurukshetra University, Kurukshetra(1999) * B.Sc Non-Medical, Arya college , Ludhiana (1988) Trainings and Certifications * ANSI SQL Certification ,Brain Bench (2001) (Scored “MASTER” Grade, placed 2nd in India) * MCDBA , Microsoft Corporation- US(2000) * MCSE , Microsoft Corporation- US(1999) * Unix and “C” Training ,CMC, Asian Village, New Delhi(Oct ‘28 1991 to Nov’9 1991) Permanent Address S/o S. Harbhajan Singh Sohal 496, Anandpuri Colony, Noorwala Road, Ludhiana -8 Other Details Marital Status Married Passport No B2207383 Passport Expiry Date 11/07/10 Projects handled List of some of projects handled: WEB Based 1. Netcradle: www.netcradle.com 2. Majestic Park Plaza: www.majesticparkplaza.com 3. Skills International: www.skillsinternational.org 4. Top Soccer site 5. Juniors: www.juniors.net, www.juniorszone.com 6. ThecontentShop: www.thecontentshop.com 7. RHN: Not hosted for public use 8. Monster: http://www.learnenglish.org.uk/kid_frame.html 9. Poetry game for British counsel, UK: http://www.learnenglish.org.uk/kids/makeapoem/login.asp 10. Machine inventory Management 11. CRM 12. Discussion Form 13. Knowledge Navigator Application Based 14. Inventory control 15. Asset management for CMC Hospital, Ludhiana 16. Sales Order Processing 17. General Accounting 18. Purchase Order
|
|
|
|
|
|
|
|
© 2002-11 IT-Careernet.com
Reproduction, retrieval, copying or
transmission of the content of this site is not permitted without the
publisher's prior consent. Last changed:
January 27, 2012
|
|
-start of code- -end of code- &n bsp; Sponsor: ITC Software
