Good verbal and written communication skills, able to clearly articulate complex technical issues and relate to development requirements and needs.
Should be able to work across physical boundaries through phone, IM efficiently as rest of the database team is located in New York, NY
Physical modeling experience needed - preferably in Erwin modeling tool Batch Jobs scheduling experience - preferably controlm tool Candidates should have experience in large-scale environments Hands on experience with Microsoft Windows XP or higher version, Office, PowerPoint, Access, Visio and Project
Strong change management experience for implementing database changes Experience promoting database objects from one environment to other and maintaining change logs SQL Server experience Demonstrable experience with SQL Server Database design and development including creating stored procedures and functions using T-SQL
Thorough understanding of relational database design and concepts Demonstrable experience of Installation, migration, upgrade and maintenance of multiple SQL Server Databases Demonstrable experience with backups, recovery, performance tuning and optimization Understanding and some working knowledge of SSIS/ DTS, SSAS, SSRS and common ETL practices.
Understanding execution plans and how to use them to optimize/ improve query costs and create indexes
Good knowledge and understanding of SQL Server database mirroring, replication, and log shipping Extensive experience with Microsoft Windows Server 2003/ 2005/ 2008 operating system.