Hello Associates,
Please let me know if you have any candidates for the
following position.
*Kindly send your responses to
**aus...@millenniumsoft.com*<aus...@millenniumsoft.com>
*.** Replies to any other email will not be considered.*
*Lead SQL Server DBA with excellent communication skills required***
* *
*Location: Columbus OH*
*Est. Start Date: 2 weeks or so *
*Est. Term: thru june 2012 *
* *
*2.0* *Statement of Work***
· Altiris Help Desk 6.0 active management and performance tuning.
· Altiris Help Desk 7.0 planning and implementation.
· Proactive monitoring, response, and capacity planning
implementation for the production set of Microsoft SQl Server databases.
· Establish new and review existing best practices related to
Microsoft SQL Server database administration.
*3.0 Project Scope***
The ISD Database unit has been supporting Microsoft SQL Server RDBMS based
applications for the last several years. Best practices are established,
but active technical leadership has been impacted due to the focus provided
to STARS and Tax Discovery initiatives. Applications are supported on 25
production servers and 10 development/test servers.
The Altiris HelpDesk 6.0 application has been in production for the last 2
years and recently has hit some performance limitations due to data growth
and data quality issues. A performance improvement team is actively
working to understand and establish a proactive management framework.
* *
*4.1** *The objective of this task is to provide active performance
management, monitoring, and tuning for a 350 GB Altiris HelpDesk 6.0 SP3
database hosted on a Wintel server using Microsoft SQL Server 2005 SP2
RDBMS. This task also includes: Altiris Help Desk 7.0 planning and
implementation.
* *
· Tasks to be performed:
· Review current implementation for Altiris HelpDesk 6.0.
· Review Altiris best practices.
· Review current Database maintenance plan for the Altiris
application.
· Recommend Altiris specific and general best practices for the
Altiris application.
· Lead junior DBA staff in implementing the recommended changes.
· Altiris HelpDesk 7.0 planning and implementation including IT
Analytics and SSRS implementation.
· Project Web Server support including SSRS and BIDS support.
· Work Products: MS SQL Server 2005 SP3, RedGate Tools
* *
· Deliverables:
· Optimized database performance for the Altiris HelpDesk
solution.
· Participate in a performance improvement team effort to mature
our processes around supporting the Altiris HelpDesk solution.
· Provide direction to junior DBA staff who will be implementing
the DBA tasks providing skill development and technical maturation.
· Plan for and prepare staff for the HelpDesk 7.0 upgrade.
· Implementation of capacity planning meetings with DBA and
application development staff for the set of applications supported on
Microsoft SQL Server.
· Completion Criteria:
· Performance problem issue resolved and successful system
performance over a one month cycle of activity.
· Smooth implementation of the Altiris V7 Upgrade project from the
database support perspective.
· Controlled growth of the Altiris application avoiding future
performance issues.
· Junior DBA staff provided the documentation and knowledge
transfer resulting in the capacity to provide on-going support for the
Altiris application database.
*4.2** *The objective of this task is to provide proactive
monitoring, response, and capacity planning implementation for the
production set of Microsoft SQl Server databases.
· Tasks to be performed:
· Identify the set of events requiring active monitoring.
· Identify the set of events requiring passive monitoring.
· Implement active alerts defined above.
· Implement the passive alerts defined above.
· Work Products: MS SQL Server 2008 SP1, RedGate Tools
* *
· Deliverables:
· Implementation of a proactive monitoring solution using the Red
Gate tool set.
· Completion Criteria:
· Implementation of a proactive monitoring solution including
active and passive alerting.
· Implementation of capacity planning meetings including the DBA
staff and A/D staff.
*4.3** *The objective of this task is to lead the ISD Database Unit
in reviewing existing best practices as well as creating new best
practices. Providing increased automation of database management tasks is
a driving business requirement.
· Tasks to be performed:
· Review current ISD Database Unit SQL Server best practices.
· Review current Microsoft SQL Server best practices.
· Identify new best practices and potential areas of improvement.
· Prioritize new or changed best practices with senior DBA
resources.
· Implement new or changed best practices with the DBA team.
· Propose new task automations and assist staff in the
implementations.
· Work Products: MS SQL Server 2005 SP1, 2008 SP1, RedGate Tools
* *
· Deliverables:
· Updated current set of MS SQL Server best practices.
· Completion Criteria:
· Defined library of MS SQL Server best practices.
*Thank you,*
*Austin Smith*
*MillenniumSoft, Inc.*
*Tel: 703 672 6897*
--
You received this message because you are subscribed to the Google Groups "SAP
BASIS" group.
To post to this group, send email to sap-basis@googlegroups.com.
To unsubscribe from this group, send email to
sap-basis+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sap-basis?hl=en.
