Dieses Jobangebot ist archiviert und steht nicht mehr zur Verfügung.
Vakante Jobangebote finden Sie unter Projekte.

Database Administrator

Eingestellt von Link Technologies

Gesuchte Skills: Sql, Consultants, Client, Consultant

Projektbeschreibung

EXPERIENCE AND SKILLS REQUIRED

The Microsoft SQL Server Consultant must have experience in:

- Determining licensing requirements.
- Determining the necessary virtual resources.
- Upgrading Microsoft SQL Server environments.

The consultants will need to:

- Possess excellent verbal and written communication skills.
- Be proactive and timely in the delivery of products.
- Be able to gather requirements by interviewing customers.
- Be able to present the findings by preparing clear and concise written instructions to audiences with varying levels of understanding.
- Be good in documenting the findings and creating reports.
- Possess the ability to run meetings with varying levels of stakeholders.
- The consultants must be proficient at evaluating systems, reviewing existing systems, programs and operations and providing recommendations.

The consultants must have experience with:

- Defining and documenting functional and non-functional requirements.
- Dissecting high-level information into details and be able to communicate details in a manner understood by relevant audiences.
- Analyzing and evaluating data and information to formulate conclusions and courses of action.
- The consultants must be flexible to adapt to changes in priorities, work assignments and other interactions.
- The consultants will need to collaborate with technical contacts on tasks related to the planning, scheduling and coordination of project activities.
- The consultants must have strong analytical, problem solving skills, business, and system analysis skills.

The Microsoft SQL Server Consultant must have experience in:

- Microsoft SQL Server 2008
- Microsoft SQL Server 2010
- VMWare virtual server infrastructure
- MS Visio and MS Office

PROJECT OVERVIEW

The Client is seeking consultants to upgrade the Bighorn portal from Microsoft SharePoint Server 2007 (MOSS 2007) to SharePoint Server 2013 and upgrade the database environment from Microsoft SQL Server 2008 to SQL Server 2012.

The consultants will need to supply recommendations on product licensing requirements, virtualization environments, server requirements and test environments. Once the recommendations are gathered the consultants will upgrade and migrate the SQL Server databases and SharePoint instances to the agreed upon virtual server environments.

The Client is currently a Microsoft .NET centric environment. This environment consists of three (3) physical Servers that are used to house the Client's Longitudinal Database (SAIN). The SAIN system also consists of a Microsoft SharePoint Front End, which contains several .NET applications delivered through SharePoint portal services. The Back End database is in MSSQL 2008 and is configured in a three (3) server fail-over cluster. The SharePoint environment consists of a production MOSS server and an IIS WEB interface. The Client has implemented a VMWare virtual server infrastructure and has migrated many of the Legacy application Servers over to this environment. The Client's goal is to migrate all of the Legacy Servers into the new virtual infrastructure and retire the stand-alone Servers currently supporting the SAIN system.

Microsoft SQL Server Environments

- Production ODS Environment
- 57 DBs totaling 463 Gb
- Largest database size:  225Gb
- Approximately 850 Stored Procedures
- 180 SSIS Packages

Production RPT Environment

- 54 Databases Totaling 667 Gb
- Largest database size: 331 Gb
- Approximately 8600 Stored Procedures
- 259 SSIS Packages

Test Environment

- 145 Databases totaling 734 GB
- Largest database 235 GB
- Approximately 10,250 Stored Procedures
- 487 SSIS Packages

Development Environment

- A development SQL Server environment will need to be implemented on virtual environment
- This instance can be populated with the newly upgraded SQL Server 2012 Production databases

SCOPE OF WORK

The consultants shall work to upgrade the current Microsoft SQL Server 2008 environment to SQL Server 2012. 

This will include:

Giving recommendations on licensing needed to support the new SQL Server environments.

Upgrading the following instances of SQL Server:

- Production ODS
- Production RPT
- Test
- Development

Migration of SQL Server environments.

Migrate upgraded SQL Server environments to virtual server instances:

- Give recommendations as to the needed virtual server specifications and setup
- Migration must be completed with no interruption to production services

Projektdetails

  • Vertragsart:

    Contract

  • Berufserfahrung:

    Keine Angabe

Geforderte Qualifikationen

Link Technologies