Current jobs related to Senior SQL Developer - Reston, Virginia - DT Professional Services


  • Reston, Virginia, United States Stelvio Group Full time

    Senior Backend DeveloperStelvio Group is seeking a highly skilled Senior Backend Developer to join our team. As a key member of our development team, you will be responsible for designing and implementing new APIs to integrate with our existing system in support of a new Proof of Concept application for our clients.Key Responsibilities:Develop new APIs using...


  • Reston, Virginia, United States Silo Smashers Full time

    Job Title: Senior Oracle APEX DeveloperWe are seeking a highly skilled and experienced Senior Oracle APEX Developer to join our team at Silo Smashers. The successful candidate will be responsible for leading Oracle APEX development projects, collaborating with various stakeholders, and delivering high-quality applications.Key Responsibilities:Lead a team of...


  • Reston, Virginia, United States PRIMENOTCH Full time

    Job Title: Senior Oracle DeveloperAt PRIMENOTCH, we are seeking a highly skilled Senior Oracle Developer to join our team. As a key member of our development team, you will play a crucial role in designing, developing, and maintaining Oracle Customer Care and Billing (CCB) applications.Key Responsibilities:Design and Development: Design, develop, and...


  • Reston, Virginia, United States Insight Global Full time

    Job Title: Senior Python DeveloperWe are seeking a highly skilled Senior Python Developer to join our Agile engineering team at Insight Global. As a key member of our team, you will be responsible for designing, coding, and testing new systems and features built using our primary technologies – Python, Microsoft Azure functions, Azure SQL Database, and...


  • Reston, Virginia, United States Genesis Consulting Partners, LLC Full time

    Job Title: Senior Full Stack DeveloperThis is a remote position.Job Type:Full-TimeJob Location:Remote / Fairfax, VAJob Summary:Genesis Consulting Partners, LLC has an immediate opportunity for an experienced, forward-thinking Full Stack Developer with a passion for growth and business transformation for a public sector client in Fairfax, VA. The successful...


  • Reston, Virginia, United States Relate Search Full time

    We are seeking a highly skilled Senior Software Development Engineer to join our team at Relate Search. As a key member of our development team, you will be responsible for designing, developing, and maintaining robust, scalable applications using the latest technologies.Key Responsibilities:Design and develop cloud-native solutions using C# and the .NET...


  • Reston, Virginia, United States Microsoft Full time

    About the RoleWe are seeking a highly skilled Senior Software Engineer to join our Cloud and AI Azure SQL team. As a key member of this team, you will be responsible for developing features, improvements, enhancements, and bug fixes within Azure SQL products, which are used by our worldwide customer base.Key ResponsibilitiesDevelop and Implement Software...


  • Reston, Virginia, United States IT Concepts Full time

    Job Title: SQL Database AdministratorWe are seeking an experienced SQL Database Administrator to join our team at IT Concepts. As a key member of our database management team, you will be responsible for the day-to-day management of SQL Servers and databases.Key Responsibilities:Design, setup, installation, configuration, monitoring, maintaining, and...


  • Reston, Virginia, United States Wipro Full time

    Senior Python DeveloperAbout the Role:We are seeking a highly skilled Senior Python Developer to join our team at Wipro. As a key member of our development team, you will be responsible for designing, developing, and maintaining robust and scalable Python-based applications, tools, and frameworks that integrate machine learning models and algorithms.Key...


  • Reston, Virginia, United States Atyeti Inc Full time

    Job Title: Senior Java Developer (ION)A global investment bank is seeking a skilled Senior Java Developer to join their team.Key Responsibilities:Develop and maintain ION core platform using Java technologies.Design and implement robust Java applications with strong object-oriented programming skills.Collaborate with agile teams to deliver high-quality...


  • Reston, Virginia, United States Soft Source, Inc Full time

    Job DescriptionTitle: Senior Python DeveloperLocation: RemoteDuration: 6 months + possible extensionsMust Haves:Expertise in Python developmentAWS – CloudFormation, Glue, lambda functions etc.Advanced knowledge in data warehousing and ETLTerraform, Gitlab experience is highly preferredSome understanding of big dataDay to Day:Develop and maintain scripts...


  • Reston, Virginia, United States INSPYR Solutions Full time

    Job Title: Sr Software EngineerWe are seeking a highly skilled Sr Software Engineer to join our team at INSPYR Solutions.Job Summary:The successful candidate will have a strong background in software development, with a focus on automated testing and framework development. They will be responsible for designing and implementing test automation frameworks, as...


  • Reston, Virginia, United States Novi Recruiting Full time

    Novi Recruiting is seeking an experienced Python Developer to support our client's trading operations in NYC, NY or remotely.Key Responsibilities:Develop, test, and maintain Python applications to support trading operations.Implement and manage ETL processes to ensure accurate and timely data flow.Integrate with APIs to connect various systems and streamline...


  • Reston, Virginia, United States Booz Allen Hamilton Full time

    About the RoleWe are seeking a highly skilled Senior Full Stack Developer to join our team at Booz Allen Hamilton. As a key member of our development team, you will be responsible for designing, developing, and implementing software applications using agile methods.Key ResponsibilitiesDesign and develop software applications using agile methodsCollaborate...


  • Reston, Virginia, United States Innova Solutions Full time

    Job Summary:Innova Solutions is seeking a highly skilled Senior Oracle Essbase Developer to join our team. As a key member of our development team, you will be responsible for designing, developing, and implementing complex Oracle Essbase solutions.Key Responsibilities:Design and develop high-performance Oracle Essbase solutions to meet business...


  • Reston, Virginia, United States Booz Allen Full time

    About the RoleWe are seeking a highly skilled Senior Back-End Developer to join our team at Booz Allen. As a key member of our development team, you will be responsible for designing, developing, and deploying scalable and secure cloud-based systems.Key ResponsibilitiesDesign and develop complex software systems using Java, C#, or PythonDevelop and maintain...


  • Reston, Virginia, United States Dillon Morgan Consulting Inc Full time

    About Dillon Morgan Consulting Inc.Dillon Morgan Consulting Inc. is a management consulting firm that helps companies identify operational efficiencies, reduce their bottom-line costs, and increase profitability. With global experience in driving company-wide transformations across various industries and functions, we have a proven track record of delivering...


  • Reston, Virginia, United States Booz Allen Hamilton Full time

    About the RoleWe are seeking a highly skilled Senior Back-End Developer to join our team at Booz Allen Hamilton. As a key member of our development team, you will be responsible for designing, developing, and deploying scalable and secure cloud-based applications.Key ResponsibilitiesDesign and develop back-end systems using Java, C#, or PythonDevelop and...


  • Reston, Virginia, United States Innova Solutions Full time

    Job Summary:Innova Solutions is seeking a highly skilled Senior Oracle Essbase Developer to join our team. As a key member of our development team, you will be responsible for designing, developing, and implementing Oracle Essbase solutions for our clients.Key Responsibilities:Design and develop Oracle Essbase solutions for clients, including data modeling,...


  • Reston, Virginia, United States INSPYR Solutions Full time

    Job Description**Job Title:** Senior Java Developer and Technical Lead**Job Summary:** We are seeking a highly skilled and experienced Senior Java Developer and Technical Lead to join our team at INSPYR Solutions. As a key member of our technical team, you will be responsible for leading the design, development, and implementation of complex software systems...

Senior SQL Developer

4 months ago


Reston, Virginia, United States DT Professional Services Full time

Job Summary
DT Professional Services is seeking an Enterprise Data Warehouse (EDW) Consultant with SQL Developer and cloud environment experience to support the Office of Information Systems (TC) within the Drug Enforcement Administration
(DEA). The DEA's SQL Server-based EDW is used by a majority of DEA's applications and is a critical component of statistical reporting. An active secret clearance is required. This positions requires 2 to 3 days per week onsite at the Merrifield DEA Office in Fairfax, VA.

As with any position, additional expectations exist. Some of these are, but are not limited to, adhering to normal working hours, meeting deadlines, following company policies as outlined by the Employee Handbook, communicating regularly with assigned supervisor(s), and staying focused on the assigned tasks including company meetings, and completing other tasks as assigned.

Responsibilities:

  • Assist EDW Team and provide data warehouse information and/or systems transitioning to a cloud
    environment
  • Create and maintain database integrity and performance using scripts and/or VS Database Project
  • Create new and maintain/improve any and all data transformation services: Microsoft SSIS and others using VS data tools
  • Create SQL Scripts to deploy / enhance / maintain databases
  • Create and maintain database security, including, but not limited to: DB Roles, Users and Logins
  • May write reports or facilitate data access by other means as needed, to include SSRS, PowerBI, etc.
  • Conducts performance tuning and database design, dimensional analysis and modeling
  • Maintain and add to an extensive set of SQL Server Integration Service (SSIS) packages for Extract, Transform, and Load (ETL) data
  • Supports the review of database systems from non-Concorde applications in other DEA offices
  • Participates in daily Agile stand-up meetings and monthly planning sessions, sprint reviews, and retrospective sessions
  • Maintain, enhance, and create enterprise and application level SQL Server Report Service (SSRS) and other Business Intelligence (BI) tools. If requested, the EDW team will leverage SQL Server Analysis Services (SSAS) for performance purposes.

Basic Qualifications:

  • An active DoD Secret Clearance is required
  • 2+ years of Cloud environment experience (AWS or Microsoft Azure)
  • 8 years of experience in the design, development and implementation of SQL Server databases, including creating and maintaining T-SQL Procedures, functions, packages and triggers
  • 2 years of experience with SSIS packages for data manipulation and loading
  • 2 years of experience with the SQL Server 2012 environment
  • Knowledge of, and experience within, an Agile development environment
  • Knowledge of and prior experience with Git and Python, and PowerShell
  • Knowledge of and ability to use, Azure DevOps Server
  • Ability to write efficient SQL queries as well as demonstrated ability to interpret legacy scripts
  • Knowledge of and prior experience with multi-dimensional data models
  • Ability to create reports with a solid understanding of a variety of BI data tools
  • Knowledge of and prior experience with SSIS
  • Demonstrated ability and desire to learn new technologies
  • Bachelor's Degree in IT, Computer Engineering, or a related discipline
  • Experience with data modeling programming and software development, including Python, R, or other high-level language used in statistical computing
  • Knowledge of Kimball data warehouse methodology highly desired
  • Previous experience with Business Intelligence, Kimball Modeling and/or elastic search is desired

The compensation range for this position: $140k - $170k annually.