Maintenance of Microsoft SQL Server 2000, 2005 and 2008 databases. SQL Query authoring and troubleshooting, proactively optimize system performance. Work with project teams to automate reactive procedures where possible, and to promote rapid response to known issues. Work in conjunction with other IT, application development, and business groups to understand functionality, scalability, performance, security, and integration requirements. Review database structures and code to enforce standards and best practices to ensure optimal performance. Experience with advanced features to include data partitioning & data compression. Responsible for investigating potential problems and issues raised by business users. Accountable for maintaining SQL Server and database configurations, in compliance with established best practices. Implementing standard maintenance tasks for SQL server including backup and recovery procedures. Upgrading, and patching SQL Servers to most current versions. Identifying architectural and performance related issues, proposing and implementing solutions.