Senior DBA/Data Architect - Washington DC Area

Senior DBA/Data Architect - Washington DC Area


Job Description

*****US Citizens Only *****
Provide highly technical expertise and guidance in the design, implementation, operation and maintenance of database management systems (DBMS). This position will design, implement, and maintain complex databases with respect to Microsoft SQL Server, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. Tasks also include evaluating and recommending available DBMS products after matching requirements with system capabilities. Defining required database administration policies, procedures, standards, and guidelines, and preparing and delivering presentations on DBMS concepts will be required.

Job Duties:

Job Duty 1: SQL-Server administration, configuration, maintenance, backup and recovery, database security, performance optimization, tuning, profiler, SQL- Database security, performance optimization, tuning, profiler, and data analysis

Job Duty 2: SSIS Package development, optimization, maintenance, backup and execution

Job Duty 3: Data model, redesign and optimization, including dimensional modeling
Basic Skills, clearances and other elements required, in order of importance, and number of years experience, where applicable, in each skill:

5+ years experience as a SQL Server DBA
At least 2+ years experience working w/ Security Audit for a Federal Client/agency
At least 2+ years experience working in a SOD (Separation of duty) environment
At least 3+ years experience working w/ .Net developers to manage and optimize query, database tuning, etc.
Bachelor/Masters in Computer Science w/ specialization in Database technologies
SQL Server 2008
T-SQL, SSIS Package
SQL Server Reporting Services
Enterprise Data and Dimensional modeling (OLAP)
Star Schema

Other Skills Desired, Years in each skill, where applicable:

Agile Development Methodology - 2+ years

Skills: design, management, administration, analysis, .net, science, agile