Kaimetrix · 4 hours ago

Senior SQL Database Administrator

Washington, DC

Full-time

Remote

Senior Level

5+ years exp

Maximize your interview chances

Information ServicesInformation Technology

Growth Opportunities

No H1B

U.S. Citizen Only

Insider Connection @Kaimetrix

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

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

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQLSSISSSRSSSASETLData MigrationSQL ServerData FlowBulk InsertSQL Agent JobsPRISMFPDSTechnical Documentation

Required

5+ years of experience using SQL professionally and be up to date on the standards

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

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

Preferred

A Bachelor's degree from an accredited university in Computer Science, Engineering, or a related field is preferred

Experience working on data migration or SQL Server upgrade projects preferred

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)