WashingtonRecruiter Since 2001
the smart solution for Washington DC jobs

Sr. SQL Developer

Company: ActioNet, Inc.
Location: Vienna
Posted on: August 3, 2020

Job Description:

ActioNet has an immediate opportunity for a Senior SQL Developer requiring a Secret Clearance located in Vienna, VA. ActioNet is an IT service provider and solutions integrator headquartered in Vienna, VA that works with the Federal Government and Department of Defense. In this role, you will be responsible for designing, developing, and implementing Microsoft SQL Databases and applying best practices to enable high performance enterprise databases.Job Requirements: Evaluate the effectiveness of existing internal processes and applications and propose solutions and opportunities for automation and audit controls Performs problem resolutions and root cause analysis along with recommending and implementing preventive techniques Ability to multitask in a fast-paced environment Motivated to share knowledge in a team environment Design new database and changes to existing databases. Develop ETL processes to support internal and external client needs. Provide and maintain technical documentation for new system processes or enhancements Take on technical leadership responsibilities of database projects across the organization Write complex queries in TSQL and design and develop ETL processes utilizing SSIS Mentor junior team members as needed Solve issues with ETL processes and SQL queries and assist in system testing new and existing ETL processes Review ETL processes for accuracy, maintainability and performance prior to implementation Provide solutions for data migration and conversion Collaborate with DBA with respect to performance, backup strategies, security and standard methodologies Collaborate with internal groups and vendors to Define requirements, define test plans and implement solutions for data migration for ETL Processes and test plans Work with DBA to implement security standards and audit practices Work with team to develop change control and database object migration processes Work with DBA to audit user access to SQL Server databases based on security standard methodologies Develop and maintain standard methodology policies, procedures, standards and system level documentation related to the Production, Disaster Recovery and Staging environments Qualifications: Active/Current Secret Clearance 8+ years of SQL Server database development 5+ years of SQL Server Integration Services Development SQL Management Studio, SQL Server Analysis Services, SQL Server Reporting Services, and Integration Services Knowledge of reporting and query tools and practices Knowledge of conceptual, logical and physical database design Experience with OLAP and OLTP Ability to modernize table structures and data management in legacy systems Expert level knowledge with Microsoft SQL Server (2008, 2014, 2016) and technologies with SQL Server Expert knowledge of TSQL and developing complex database queries Ability to lead development efforts within a team of software developers Experience working with large databases with high number of transactions Understands and use SQL best practices regarding security and privacy of data Strong skills with developing SQL views, common table expressions (CTEs) and stored procedure to combine/aggregate data needed for reporting purposes Strong skills in a performance tuning especially tuning complex queries, procedures and indexing strategies Expert knowledge of designing and creating new and modifying existing SQL Server Integration Services packages Experience with SQL Server Reporting Services and Power BI Experience with .NET programming languages Experience with third party SSIS Components is a plus Experience running SQL in a virtualized environment Practical experience with the installation, maintenance, and upgrades of SQL Server Practical experience with data migration and data replication tools, technologies, and strategies Experience with designing and developing SQL clusters and data warehouses a plus. Possess current COMPTIA Security+ CE certification Bachelors Degree in Computer Science or similar field by Jobble

Keywords: ActioNet, Inc., Washington DC , Sr. SQL Developer, IT / Software / Systems , Vienna, DC

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Software Developer, Senior
Description: Secure our Nation, Ignite your Future br br Become an integral part of a diverse team while working at an Industry Leading Organization, where our employees come first. At ManTech International Corporation, (more...)
Company: ManTech
Location: Hanover
Posted on: 08/11/2020

Entry Level Recruiter / Technical Recruiter
Description: Full time job opening with a Maryland based Recruiting/Staffing firm. We are hiring for our Sr. Recruiter and Technical Recruiter openings. Position pays a competitive base salary, uncapped commission (more...)
Company: Latitude, Inc.
Location: Baltimore
Posted on: 08/11/2020

Computer Vision and Machine Learning Scientist, Mid
Description: Job Number: R0086729Computer Vision and Machine Learning Scientist, MidThe Challenge:Are you excited at the prospect of unlocking the secrets held by a data set Are you fascinated by the possibilities (more...)
Company: Booz Allen Hamilton
Location: Laurel
Posted on: 08/11/2020


Pr. Software Engineer
Description: THIS POSITION REQUIRES AN ACTIVE TOP SECRET SCI WITH POLYGRAPH CLEARANCE Boeing Intelligence Analytics BI A is seeking a Pr. Software--Engineer to join our Prime contract team.--JOB DESCRIPTION:Provide (more...)
Company: Boeing
Location: Riva
Posted on: 08/11/2020

Software Developer, Senior
Description: Secure our Nation, Ignite your Future br br Become an integral part of a diverse team while working at an Industry Leading Organization, where our employees come first. At ManTech International Corporation, (more...)
Company: ManTech
Location: Hanover
Posted on: 08/11/2020

User Interface Developer
Description: JOB SUMMARY:Visionist Inc. is seeking a passionate Senior UI Developer to join a small team of enthusiastic programmers supporting mission critical tasking in an uncleared
Company: Visionist, Inc
Location: Columbia
Posted on: 08/11/2020

Software Developer I
Description: Software Developer I Company: Ball Aerospace Location: Columbia, MD, US, 21046 Date: Aug 6, 2020 Job Category: Engineering/ Technical Req. ID: 1135 Clearance Requirement: A current, active TS/SCI with (more...)
Company: Ball Corporation
Location: Columbia
Posted on: 08/11/2020

Information Technology Specialist
Description: SummaryThe Goddard Space Flight Center, Solutions Division is seeking to hire an Information Technology IT Manager to plan and implement an IT program to enable Goddard's Management and Operations Directorate (more...)
Company: Goddard Space Flight Center
Location: Greenbelt
Posted on: 08/11/2020

Software Engineer
Description: Secure our Nation, Ignite your Future br br Become an integral part of a diverse team while working at an Industry Leading Organization, where our employees come first. At ManTech International Corporation, (more...)
Company: ManTech
Location: Columbia
Posted on: 08/11/2020

Software Engineer
Description: Secure our Nation, Ignite your Future br br Become an integral part of a diverse team while working at an Industry Leading Organization, where our employees come first. At ManTech International Corporation, (more...)
Company: ManTech
Location: Columbia
Posted on: 08/11/2020

Log In or Create An Account