Description
Title : MS SQL Server Database Administrator-DBA
# of Openings : 1
Position Type : Contract
Locations : Carson City, NV
Description:
Note: Candidates must be able to pass a criminal background check.
Project Need:
A MS SQLServer DBA is needed for an upgrade of the Database from MS SQL Server 2008 to SQL Server 2012. (upgrade to our Client's PORTAL from MS SharePoint Server (MOSS 2007) to SharePoint Server 2013
Required Knowledge/Expertise for the Database Administrator (DBA):
* Database Administrator (DBA) in MS SQL Server in an enterprise environment.
- MS SQL Server 2008
- MS SQL Server 2010
- VMWare virtual server infrastructure
- MS Visio
- MS Office
- Experience in Production, test and development environments
- SSIS
- Experience upgrading instances from SQL Server 2008 to 2012
- Experience migrating from SQL Server 2008 to 2012
- Determining licensing requirements
- Determining virtual resources
EXPERIENCE AND SKILLS DESIRED:
- MS SQL Server 2012
- Government work experience a plus, but not required
Work Duties:
- Give recommendcations on licening needed to support the new SQL Server environments.
- Upgrade the following instances of MS SQL Server:
- Production
- Production RPT
- Test
- Development
- Migration of MS SQL Server Environments:
- Migrate the upgraded SQL Server environments to VIRTUAL server instances.
- Give recommendations for virtual server specifications and setup.
MS 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