SAS SPDS Specialist ~ SAS Data Architect / DBA Job in Washington, District Of Columbia US
This is a Federal Govt Opportunity for 6+ Months in Washington, DC.
Only Green Card Holders and US Citizens may apply.
Description:
The SAS SPDS Specialist - Data Architect / DBA needs to have a high level of experience with SAS SPDS (v4.5) from both architectural and usability perspectives. (The Data Integration specialist that will work with you will be highly experienced with SAS Data Integration Studio accessing PCFF data and ultimately loading it into SPDS.)
Specific Technical Requirements:
SAS SPDS ~ Data Architect / DBA:
- Complete understanding of SAS SPDS (v4.5).
- Ability to architect the SPDS data storage structure with an understanding of SPDS indexing and how SPDS utilizes multiple disks, IO channels and disk spindles.
- Ability to administer SPDS, and provide all SPDS development and maintenance.
- Create an SPDS storage structure that will be loaded by the SAS DI Specialist.
- Maintain all corporate data and database policies.
- Create and maintain tables.
- Create, update and integrate physical data models.
- Create and maintain data dictionaries as well as Erwin-type of architectural diagrams.
- Monitor and tune SPDS performance
- Manage data storage requirements and implement multi-value compression as needed.
- Administer SPDS security and User IDs.
- Define an archiving strategy.
- Define a backup restore strategy.
- Performance tuning and troubleshooting.
- Apply SPDS maintenance / management standards.
- Ability to work with SPDS logs to troubleshoot errors and performance.
- Provide SPDS best practices.
- Knowledge of various SPDS options that can be leveraged within SAS to better utilize the multi-threading and speed of SPDS.
- Ability to consult SPDS documentation as needed.
January 1, 2012
• Tags: DBA Job in Washington, District Of Columbia Us, SAS SPDS Specialist ~ SAS Data Architect • Posted in: General