(If you are a vermont.net member, you are not allowed to apply for this job and move away. :-))
SQL Server 2000 Expert
** Full-time position, Location is Connecticut, Salary is negotiable and highly competitive **
Responsibilities:
β’ Maintain production SQL server environment which supports a substantial base of mostly custom applications
β’ Serve as subject matter expert in working with Database/Software Developers and Data Analysts to define data models, schemas and database application architectures
β’ Implement and Manage best practice based security model and auditing including delegation, Kerberos and encryption
β’ Gain intimate familiarity with normal usage and operations of database applications in order to troubleshoot real-time issues and optimize databases, indexing and data allocations for efficiency and issue avoidance
β’ Design, development and installation of SQL monitoring systems and solutions
β’ Responsible for the implementation and operation of disaster recovery strategy, architecture, and detailed plan for all database applications
β’ Design and implement high availability, clustered, and replicated SQL environments where desirable and feasible
β’ Establish and document coding standards and best practices for schema design and T-SQL queries
β’ Establish and monitor procedures and technologies for creating and maintaining data dictionaries
β’ Establish and monitor procedures and technologies for change management within SQL Server
β’ Research and advance new technologies affecting SQL Server development that may provide value to enterprise applications
β’ Lead SQL Server in-house training efforts through the development of syllabi, course materials, and core knowledge requirements
Experience:
β’ Expert level experience with Microsoft SQL 2000 β including usage, administration, monitoring, optimization, architecture, etc
β’ Substantial experience with large data sets β over 100GB in size
β’ Expert in profiler, real-time analysis, monitoring solutions
β’ Expert in Performance Optimization of queries and SQL code
β’ Significant experience in resolving complex, multi-component failures
β’ Must be able to create all aspects of documentation that follows traditional systems design methodologies
β’ Must have excellent organization, communication, teamwork and leadership skills.
β’ Must have demonstrated, strong attention to detail and quality.
β’ Must provide examples of analyzing and optimizing business processes in past roles
β’ Experience with OLAP services is desired
Near-term Projects in Addition to Ongoing Responsibilities:
β’ Baseline and gap analysis of current SQL environment vs. ideals and best practices
β’ Develop short and long term strategy for SQL environment monitoring and alerting
β’ Design and implement a SQL basic training course for in house developers to ensure a minimum threshold of consistent and appropriate SQL knowledge
β’ Create and begin the preparation process for an eventual migration to the SQL 2005 platform
For immediate consideration, please contact:
Anne Keehan
Partner
Brandywine Technology Partners
Phone: 302.656.6100 x225
Email: akeehan@btpartners.net
http://www.AcehAid.org