All
Urgently Hiring
Easy Apply
Essential Jobs
Industry 0
Part-time
Full-time
Teen

837 Multitasking Jobs in vienna, va

Relevancy

Customer Health Care Concierge

CVS Health

Vienna, VA 22027
2.1 miles Full-time, Part-time
  • Urgently Hiring

13F Fire Support Specialist

Army National Guard

Fort Belvoir, VA 22060
15.3 miles Part-time

Delivery Driver

Lost Dog Cafe

1690 Anderson Rd, Mclean, VA 22102
3.5 miles Full-time, Part-time
  • Urgently Hiring

Prep Cook

Wegmans

101 Crosstrail Blvd Se, Leesburg, VA 20175
19.3 miles Part-time
  • Urgently Hiring

Cook, Line

Wegmans

9001 Mchugh Drive, Hyattsville, MD 20788
17.4 miles Part-time

Customer Health Care Concierge

CVS Health

Annandale, VA 22003
4.9 miles Full-time, Part-time
  • Urgently Hiring

Line Cook

Wegmans

20600 Seneca Meadows Park, Gaithersburg, MD 20884
17.1 miles Part-time

Sr. SQL Developer with Security Clearance

Please Select
Vienna, VA 22027
Full-time, Part-time
Refer friends, get paid!

Job Description

GridIron IT is seeking a Secret Cleared SQL Data WH Developer who will be responsible for designing, administering, implementing, testing, and troubleshooting activities using Kimball data warehouse methodology within a MS SQL Server environment. Roll is currently remote and will be on-site in Vienna, VA post COVID. Minimum of Secret clearance and IAT II certification required. This position will design, build, and deploy data warehouse and analytical applications. You will utilize functional requirements to develop technical specifications and develop a solution to the specifications. The role requires a strong understanding of dimensional modeling, star schemas, data integration, data conversion, SQL, TSQL and ETL. Duties and Responsibilities: Performs problem resolutions and root cause analysis along with recommending and implementing preventive techniques
Applies Kimball Methodology and relevant data warehouse techniques to create new database designs, root cause analysis, and optimization techniques to address client requirements
Ability to multitask in a fast-paced environment
Motivated to share knowledge in a team environment
Design new database and implement 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 DBAs 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
Qualifications: 10+ years of MS SQL Server Database development
8+ years of MS SQL Server Integration Services (SSIS) development or similar enterprise data warehousing experience
Strong understanding of MS SQL Server
Ability to write custom SQL statements
Strong understanding of dimensional fact table modeling / star schemas
Ability to develop technical design specifications
Experience with at least one ETL tool
SQL Management Studio, SQL Server Analysis Services, SQL Server Reporting Services, and Integration Services
Expert Knowledge of reporting and query tools and practices
Expert 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 T-SQL 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
Experience with SQL Server Reporting Services
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.
DOD 8570 IAT Level 2 certification
Bachelor's Degree in Computer Science or similar field
Active/Current Secret Clearance
Posting ID: 602941112Posted: 2021-02-16