SQL Server DBATCS Profile - Tata Consultancy Services is an IT services, consulting and business solutions organization that delivers real results to global business, ensuring a level of certainty no other firm can match. TCS offers a consulting-led, integrated portfolio of IT, BPO, infrastructure, engineering and assurance services. This is delivered through its unique Global Network Delivery ModelTM, recognized as the benchmark of excellence in software development. A part of the Tata group, India's largest industrial conglomerate, TCS has over 276,000 of the world's best-trained consultants in 44 countries. The company generated consolidated revenues of US $11.6 billion for year ended March 31, 2013 and is listed on the National Stock Exchange and Bombay Stock Exchange in India. For more information, visit us at Experience & Experience Required (in Yrs) - 4 plus years working on SQL server 2008 and SQL 2012.
Experience in installing SQL Server in both stand alone and cluster configurations.
Experience with High Availability (HA) solutions in both SQL 2008 and 2012. L3 must have expert level knowledge in advanced SQL capabilities such as multi-node cluster implementation, Replication, Always On, etc. Consult with architects, technical specialist, and industry experts to establish organizational and company-wide DB standard. L3 Must have strong leadership and communication skills (with executives, management, and technical team) and have the ability to lead cross-functional and enterprise-wide projects. Needs to be dynamic, self-starter, have the ability to leverage complexity of large corporation to their benefitKey words to search in resume - Disaster Recovery, Cluster, High Availability, Troubleshooting, SQL2012Technical/Functional Skills -MUST HAVE SKILLS - Ability to contribute to the design, creation, and maintenance of company databases that satisfy the functional and operational needs of the customers. Must have extensive operational background in establishing and implementing operational standards for installing and maintaining/patching SQL instances, establishing and implementing DB monitoring, DB backup/recovery, access management, performance troubleshooting, DB upgrades, DB migrations, test, and validation in a large scale enterprise implementation. Have the ability to understand business needs across the enterprise and merge with industry trends to deliver functionally excellent service to TCS client business units. Working knowledge of disaster recover models with experience in implementation and recovery of databases and SQL server instances. Demonstrated ability to trouble shoot cluster and database resource issues Ability to analyze problems and provide root cause analysis and recommend preventive and corrective actions.Roles & Responsibilities - Manage Patch & Hot fix Optimize RDBMS System tuning & Instance Develop and maintain updated documentation for Various tasks carried out by the team Best Practices & guidelines Third party tools being used Manage High-Availability solution Identify re-occurring issues, perform root cause analysis & implement permanent fixes Pro-active monitoring of database and identify potential issues Help L1 & L2 members on critical issues like MIM call, escalated issues Come up with database practices & guidelines Conduct knowledge sharing sessions to team SAN and Tape/TSM storage usage optimizationStart date (dd-mmm-yy) - 1/25/16Duration of assignment (in Months) - PermanentWork Location (State, City ) - Troy, MI