4 days old

Senior SQL Developer - Data Migration

Austin, TX 78701
Responsibilities

Overview

Every day at Perspecta, we enable hundreds of thousands of people to take on our nation's most important work. We're a company founded on a diverse set of capabilities and skills, bound together by a single promise: we never stop solving our nation's most complex challenges. Our team of engineers, analysts, developers, investigators, integrators and architects work tirelessly to create innovative solutions. We continually push ourselves to respond, to adapt, to go further. To look ahead to the changing landscape and develop new and innovative ways to serve our customers.

Perspecta works with U.S. government customers in defense, intelligence, civilian, health care, and state and local markets. Our high-caliber employees are rewarded in many ways not only through competitive salaries and benefits packages, but the opportunity to create a meaningful impact in jobs and on projects that matter.

Senior SQL Developer - Data Migration, Job Description

  • Design, develop and maintain effective solutions to support data migration.
  • Perform reconciliation activity in Microsoft SQL Server T-SQL, Integration Services
  • Creating and analyzing complex queries, procedures, tables, views, triggers, functions, SQL Jobs.
  • Write reusable, robust, and clean code.
  • Design and implementation of SSIS, and ETL based on business requirements.
  • Understanding of Database Design, Integrity, and optimization process.
  • Performance-tuning SQL Server code and environments, and SQL profiling.
  • Ability to function independently with little to no supervision.
  • Perform database administration tasks.
  • Work directly with the clients to understand their needs, identify and resolve data issues.
  • Writing technical design and supporting documentation.
  • Ability to work in an agile environment.

Qualifications

Education and Experience Required

  • Bachelors degree in a technical or business discipline and a minimum of 10 years related experience or a Masters degree with a minimum of 8 years of experience.
  • US Citizenship, or Permanent Resident.

Technology Knowledge Requirements

  • Experience in migrating data from legacy to SQL Server
  • Very strong T-SQL skills and strong knowledge of ETL techniques.
  • SQL Server /SSIS
  • T-SQL Development skills
  • SQL Server Reporting services

Technology Knowledge Preferred Qualifications

  • Experience in Database administration
  • Experience in Public Retirement Systems implementation or Clarety framework solution
  • PowerShell
Email this job to a friendRefer
Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed




As a government contractor, Perspecta abides by the following provision
PAY TRANSPARENCY NONDISCRIMINATION PROVISION
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

Industry

  • Information Technology
Posted: 2020-01-18 Expires: 2020-02-16

With offerings in mission services, digital transformation and enterprise operations, our team of 14,000 engineers, analysts, investigators and architects work tirelessly to create innovative solutions. We have the expertise and experience not only to devise solutions, but to execute on them successfully.

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Senior SQL Developer - Data Migration

Perspecta
Austin, TX 78701

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast