Expired job

Just missed a job?

Sign up and never miss an opportunity again!

SQL Infrastructure Architect job

Abile Group, Inc.Springfield, VA
Abile Group, Inc. jobs

Company

Salary

Job Description

Abile Group has an exciting and challenging opportunity for an SQL Infrastructure Architect supporting an Intelligence Community Customer.

The right candidate will possess the below skills and qualifications and be ready to handle all responsibilities independently and professionally.

  • SQL Infrastructure Architect with experience in the design, deployment and support of a SQL based architecture as a foundation for a large data warehouse.

  • Your role as the SQL Infrastructure Architect will be to work with the entire team to collect requirements, perform baseline performance captures, and optimize the future of the platform by designing and deploying a highly available, highly resilient SQL system in Amazons JWICS version of AWS, called Commercial Cloud Service, or C2S.

Clearance Required: TS/SCI

Required Degree and Experience: Bachelor's degree and at least 4 years of experience

Required Skills:

  • Designing, Deploying and Supporting a multi-node SQL Always-On Cluster to include a solid understanding of Distributed Availability Groups (DAGs)

  • Complete understanding of Quorum types within a Windows Failover Cluster environment the ability to choose the right design and provide resiliency

  • Must be able to make recommendations on the design and deployment on various READ-Only topologies including Secondary Read-Only designs, Read-Only Routing, and the creation of Availability Group Names for the use of reporting.

  • Planning and Architecture of the underlying system components to include CPU/MEM/NETWORK & more importantly, the STORAGE type for various SQL databases including (TempDB, MDF Files and LOG Files)

  • Full understanding of Disaster Recovery, Continuity of Operations (COOP) along with Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) as it relates to SQL and its underlying databases.

  • Full understanding of Backup and Restore procedures and expertise in creating plans to include Full Backups, Transaction Log Backups, Differential Backups and in what order those are restored to meet RPO and RTO.

  • Solid understanding of Database MDF file structure including the creation and spanning of data across multiple MDF files, pre-sizing database best practices, and measuring performance attributes for this type of design

  • Expertise in the Design and Deployment of various components as part of SQL to includeSQL Server Integration Services, SSIS - (both Scale-Out and non-Scale-Out)Decent to

  • Solid understanding of SSIS ETL jobs including setting up and monitoring job length and performance.

  • SQL Server Reporting Services (SSRS) High-Availability design and deploymentDecent to Solid understanding of monitoring the SSRS core database tables with regards to report run-time and slow reporting performance

  • In-depth knowledge in monitoring and providing fast resolution for outages which requires a solid understanding of Microsoft Windows Server, Networking, Active Directory, Kerberos, Service Principle Names, Service Account Permissions in a least administrative model, Storage Monitoring to include disk-IO and disk-Delay and the ability to make recommendations to improve performance and prevent future outages

Desired Skills:

  • Datawarehouse Knowledge including the creation of schemas, tables, and deployment packages to support a large SQL Datawarehouse

  • SSIS ETL knowledge including parsing ETL packages and using data-transformation best-practices to standardize and create a cross-agency usable schema

  • T-SQL knowledge to include the creation of scripts, views that can be leveraged in the overall architecture within SSRS, SSIS, or other areas.

Abile Group, Inc. was formed in July 2004 to partner with the Intelligence Community and their Contractors in the areas of Enterprise Analytics & Performance Management, IT & Systems Engineering and Program & Project Management. We have significant experience with the Federal Government and are an EDWOSB dedicated to our employees and clients. We are looking for high performing employees who enjoy providing advice and guidance along with solutions development and implementation support, crafted by combining industry best practices with the clients subject matter experience and Abiles breadth of expertise.

Abile Group, Inc. is an Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, veteran status, disability, or national origin.

ID: 2019-1474

External Company URL: http://www.abilegroup.com

Street: 7500 Geoint Dr

Estimated annual salary
$138,716
average
Minimum
$110,090
Maximum
$154,502

Abile Group, Inc.

Type

Company - Private

Size

Small

Revenue

$5M to $10M

Location

Multiple locations

Industry

Computer/Internet

Founded

2004

Job Filters

FILTER JOBS
Business Continuity PlannerAbile Group, Inc.Springfield, VA
Abile Group has an exciting and challenging opportunity for a Business Continuity Planner supporting an Intelligence Community Customer. The right candidate will possess the below skills and qualifications and be ready to handle all responsibilities...Read more
Senior IdAM DeveloperAbile Group, Inc.Chantilly, VA
Abile Group has an exciting and challenging opportunity for am IdAM Developer supporting an Intelligence Community Customer. The right candidate will possess the below skills and qualifications and be ready to handle all responsibilities independently and...Read more
Overview Abile Group has an exciting and challenging opportunity for a Front-end React Developer supporting an Intelligence Community Customer. The right candidate will possess the below skills and qualifications and be ready to handle all responsibilities...Read more
Overview Abile Group has an exciting and challenging opportunity for a Cyber Security Analyst supporting an Intelligence Community Customer. The right candidate will possess the below skills and qualifications and be ready to handle all responsibilities...Read more
Overview Abile Group has an exciting and challenging opportunity for a Technical Writer supporting an Intelligence Community Customer. The right candidate will possess the below skills and qualifications and be ready to handle all responsibilities...Read more

Closed Job Filters

FILTER JOBS
Senior Linux AdministratorAbile Group, Inc.Herndon, VA
Abile Group has an exciting and challenging opportunity for a Linux Administrator supporting an Intelligence Community Customer. The right candidate will possess the below skills and qualificationsRead more
SQL Infrastructure AdministratorAbile Group, Inc.Springfield, VA
Abile Group has an exciting and challenging opportunity for an SQL Infrastructure Administrator supporting an Intelligence Community Customer. The right candidate will possess the below skills andRead more
SQL Infrastructure ArchitectAbile Group, Inc.Springfield, VA
Abile Group has an exciting and challenging opportunity for an SQL Infrastructure Architect supporting an Intelligence Community Customer. The right candidate will possess the below skills andRead more
Network Cybersecurity EngineerAbile Group, Inc.Chantilly, VA
Abile Group has an exciting and challenging opportunity for a Network Cybersecurity Engineer supporting an Intelligence Community Customer. The right candidate will possess the below skills andRead more
General ManagerAbile Group, Inc.Annapolis, MD
Abile Group has an exciting and challenging opportunity for a General Manager to support the development of our strategic vision, shape the work environment, lead resource and technology management,Read more
Similar jobs in the area
Our History: From our start in 2009, Conexess has established itself in 3 markets, employing nearly 200+ individuals nation-wide. Operating in over 15 states, our client base ranges from Fortune 500/1000 companies, to mid-small range companies. For the...Read more
An Italian sporting goods company is looking to add an experienced Sr. Infrastructure Architect to their already well established infrastructure team This Jobot Job is hosted by Julie Massey Are you a fit? Easy Apply now by clicking the "Apply Now" button...Read more
Description Job Description: The Leidos Defense Group, Enterprise & Cyber Solutions Team currently has an opening for an IT Solutions Architect with 10+ years of experience developing solutions for Cloud Infrastructure and App Migration; Infrastructure and...Read more
Please review the job details below. Maxar is currently seeking a Principal Systems Architect to join our team in Herndon, VA. At Maxar, we are building upon our 60-year legacy of innovation, from designing the high-gain antennas for NASA's Voyager 1 and...Read more
gig jobs
PICKUP delivers big & heavy items of everything from furniture and mattresses to paint and HVAC equipment, for leading retailers and commercial businesses to customers’ homes.Read more
Overview As USAC continues to support universal service impacting health care providers, educators, and consumers, it is critical now more than ever that we hire people equally passionate and committed to helping fulfill our mission. We are currently...Read more
gig jobs
Amazon DSP Driver - Starting at $16.50/hrAmazon DSP DriverSpringfield, VA
Delivery Driver – DDC4 Sterling, VA (Starting Pay $16.50/hr+) - Amazon Delivery Service Partners Shifts: Morning, afternoon, weekday and/or weekend Location: DDC4 - Sterling - 44301 Mercure Circle, Sterling, VA Compensation: Starting pay $16.50/hr...Read more
Job Number 235963 Information Systems Architect Job Details Description PURPOSE of POSITION The Systems Architect, Senior designs, implements, and maintains the organization's application systems andor IT infrastructure. The Systems Architect, Senior...Read more
When you join Verizon Verizon is a leading provider of technology, communications, information and entertainment products, transforming the way we connect across the globe. Were a diverse network of people driven by our ambition and united in our shared...Read more
Position Overview: As a Siemens Government Technologies (SGT) Professional Services Infrastructure Architect, you are the point person for building a strong relationship with customers and helping them realize their vision within their industry. This...Read more
Required Technical and Professional Expertise At least 10+ years of experience in IT Industry At least 5+ years of Architectural experience Experience of Technical Leadership, Leading Architecture and Technical Teams of around 10+ years Experience Leading...Read more
About NFF: Networking For Future, Inc. (NFF) a consultative technology solution firm has an immediate opening for a talentedexpert level Principal Architect. Selected individual will support the NFF Engineering team in identifying, capturing, and...Read more
Show more jobs
500+ more jobs

Similar jobs

Description The Lead Infrastructure Architect QA designs and develops IT infrastructure architecture solutions to business problems in alignment with the enterprise architecture direction and standards. The Infrastructure Architect work assignments involve...Read more
About NFF Networking For Future, Inc. (NFF) a consultative technology solution firm has an immediate opening for a talented expert level Principal Architect. Selected individual will support the NFF Engineering team in identifying, capturing, and...Read more
Cloud Infrastructure Architect, Senior The Challenge: Everyone is trying to "harness the power of the cloud," but not everyone knows how. As a cloud architect, you know how to build a cloud-based technical architecture that meets customer needs and takes...Read more
Verisign enables the security, stability, and resiliency of key internet infrastructure and services, including providing root zone maintainer services, operating two of the 13 global internet root servers, and providing registration services and...Read more
If you are a current Motorola Solutions employee, please click this link to apply through your Workday account. Company Overview At Motorola Solutions, we create technologies our customers refer to as their lifeline. Our technology platforms in...Read more
Recognition Inc. 500 5000 Honoree Company for 2012,2013,2014,2015, 2016, and 2017 AtyetiRanks No. 270 on the 2012 Inc. 500 List 2012,2016 and 2017 NJ 50 Fastest Growing Companies Atyeti is looking for a Principal Cloud Architect in Reston, VA. Please...Read more
Job Title IT SpecialistArchitect Location New Carrollton, MD 20784 (Itrsquos a partially remote job) Duration Full time Clearance Must have current IRS clearance Required Must have current IRS clearance, and in the DMV area Experience to working on ELC...Read more
MetroStar Systems is looking for a Network Architect who is passionate about architecting and designing complex secure networks. You must have strong communication and leadership skills to interact with client business leaders, stakeholders, and other...Read more
MetroStar Systems is looking for a Network Architect who is passionate about architecting and designing complex secure networks. You must have strong communication and leadership skills to interact with client business leaders, stakeholders, and other...Read more
OVERVIEW As a Principal Systems Architect on our Department of Defense Office of Inspector General (DoD OIG) team you will collaborate with DoD OIG personnel to oversee our portfolio of systems - ensuring quality, performance, and efficiencies are realized...Read more