*hi all * *Job Title: SQL DBA* *Company: Homesite Insurance* *location : Boston, MA Must Need Local * *Duration: 6 months*
*Interview Process: Phone, then onsite* *Responsibilities* *Provide technical and operational database administration for MS SQL Server test and production databases.* *Apply database knowledge in the areas of physical database design, performance and tuning, backup and recovery procedures and general problem resolution.* *Support multiple servers and multiple databases of high complexity with multiple concurrent users, ensuring control, integrity and accessibility of the data* *Work with DBA team to develop, implement, and monitor standards and procedures to ensure optimum performance, scalability and reliability.* *Review all investigations, analysis, and resolution of database problems; compile and maintain documentation.* *Maintain and improve database deployment and update processes. Ensure compliance in related tasks with company and regulatory policies and procedures.* *Create and maintain maintenance scripts for databases design and implementation, and participate in the disaster recovery process and database backups.* *Perform system optimization and improvement planning including but not limited to SQL Server database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning ensuring maximum performance. Develop and implement security policies.* *Hands-on support of large databases, including, but not limited to, monitoring, re-indexing, general database maintenance, extract- transformation-load, backup/recovery, documentation, and configuration.* *Qualifications* *• Five or more years of experience as a Microsoft SQL Server database administrator with significant SQL Server 2008/2012 production experience, knowledge of SQL server 2008/2012* *• Strong Knowledge of high availability architecture including clustering, data replication to multisite, transaction log shipping, database mirroring, replication, AlwaysOn & hands on knowledge with MS SQL SERVER 2005/2008/2012. Business Intelligence offering products Analysis Services, Reporting Services and Integration Services* *• Experience designing logical and physical databases* *• Solid experience w/Performance Monitor, Profiler and other tools to find areas that need tweaking* *• Experience with SQL database development and working with developers in web environment* *• Intuitive and analytical approach to problem solving* *• Excellent communication skills (written and verbal)* *• A highly self-motivated individual with the ability to work effectively in a collaborative, team-oriented IT environment* *-- * *Thanks & Regards* *Ranjith* *Ph:(925) 973-0000 x 232(Off) * *Email: ranj...@allianceit.com <ranj...@allianceit.com>* -- You received this message because you are subscribed to the Google Groups "MCMS" group. To unsubscribe from this group and stop receiving emails from it, send an email to mcms+unsubscr...@googlegroups.com. To post to this group, send email to mcms@googlegroups.com. Visit this group at https://groups.google.com/group/mcms. For more options, visit https://groups.google.com/d/optout.