Requirement for Database administrator in Jackson Graham Building, DC with State client‏

Position: Database Administrator
Location: Jackson Graham Building, DC
Duration: Long term
Client: Washington Metropolitan Area Transit Authority’s (WMATA), DC

Job Description

· Experience with developing Safety applications in transportation industry
· Development experience in MS SharePoint version 2007, custom developed SharePoint application upgrade from MS SharePoint version 2007 to 2010
· Solid understanding of Software Development Life Cycle (SDLC)
· Ability to design and size SQL server databases for supporting development, test and production regions
· Ability to install, configure SQL server database in clustered/highly available environment
· Ability to perform database tuning and periodic health check
· Ability to perform periodic database backup
· Ability to perform point in time database recovery
· Hands on experience of using SQL server native ETL tool and non SQL server ETL tool
· Hands on experience in Report design/development in Data Warehousing/Business Intelligence implementations
· Strong knowledge of one or more Business Intelligence toolsets, preferably MOLAP (Microsoft, Cognos, etc.)
· Hands on experience in relational and non-relational data modeling
· Strong knowledge of MS SQL Server: SSAS and SSRS
· Through knowledge of using software code repository such as Team Foundation Suite.