*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 "Powerbuilder Assignments" group. To unsubscribe from this group and stop receiving emails from it, send an email to powerbuilder-assignments+unsubscr...@googlegroups.com. To post to this group, send email to powerbuilder-assignments@googlegroups.com. Visit this group at https://groups.google.com/group/powerbuilder-assignments. For more options, visit https://groups.google.com/d/optout.