Senior SQL Database Administrator

Kaimetrix, L.L.C. is seeking a professional Senior SQL Database Administrator.

Responsibilities

• Application programming activities, including estimation of effort based on requirements, mock-up and prototype design performing testing, and the creating of supporting documentation to include commenting code.
• Work with stakeholders during all phases of the development lifecycle to identify problems, fix coding errors, and implement requested changes in a timely fashion.
• Conduct routine, on-going communications with the Customer. This will include participating in regularly scheduled meetings (in person or by telephone) to provide updates on work in progress, discussing and resolving identified issues, and other matters which may arise during the period of performance.

Requirements

• 5+ years of experience using SQL professionally and be up to date on the standards
• A Bachelor's degree from an accredited university in Computer Science, Engineering, or a related field is preferred
• Strong understanding and experience with data flow from corresponding sources to destinations and repositories. This includes data transformations and changes to data across SQL Server data warehouses, SSIS packages, SSRS interfaces, and SSAS cubes.
• Experience with creation and configuration of all SSIS connection managers.
• Experience with creating SSIS Control Flow and Data Flow ETL tasks.
• Experience creating and managing SSRS Reports.
• Experience creating and managing SSAS Cubes.
• Experience using bulk insert tasks to upload large amounts of data from flat files into SQL Server.
• Experience creating and managing SQL Agent Jobs
• Experience working on data migration or SQL Server upgrade projects preferred
• Experience establishing and troubleshooting ETLs
• Must be a US Citizen with the ability to pass a government background check.
• Technical documentation to include data dictionaries, source to target mappings, configuration management artifacts
• Nice to have: Prior knowledge and experience with federal acquisition and contracting systems such as Procurement Request Information System Management (PRISM) and as Federal Procurement Data System (FPDS)