Sr. MS SQL Database Architect

New!

Ariel Partners Dahlgren , VA 22448

Posted Today

The Senior Database Architect will be part of a team of experts charged with providing support in the areas of cyber analysis and cyber development capabilities in response to Navys and DoDs needs for Cyber Situational Awareness (SA), Cyber Command and Control (C2), Mission Assurance, and Homeland Defense. Program scope includes identifying cyber key terrain by analyzing operational requirements, conducting cyber analyses and assessments, and developing and performing modeling and simulation in support of different cyber threat scenarios. The team will conduct cyber analyses and assessments to identify potential vulnerabilities and risks, determine mission and operational impacts, and make appropriate mitigation recommendations. Additionally, program support includes developing methodology and framework in support of cyber risk assessment life cycle. Our team will provide capabilities to support the customer with rapid design, development, test, deployment, maintenance and operation of specific software and hardware capabilities to meet current Cyber Defensive needs.
The Role
As a Senior Database Architect on this program, you will use your expertise and experience in the following areas and activities to deliver solutions and services to our customer:
  • DB Architect will focus on SQL Server Database performance optimization, tuning, and monitoring services to ensure optimal MS SQL Server performance, reliability and data integrity.
  • Review and assess existing enterprise data-driven applications, to support new features, performance improvements, upgrades, and ongoing sustainment
  • Analyze a large, complex system to determine performance bottlenecks, application bugs, and opportunities to improve efficiency
  • Capture and analyze database activity to identify improvements in indexing, storage, maintenance processes, and query execution performance
  • Plan and conduct database architecture assessments that examine DBMS and database configuration and performance
  • Identify areas of instability and deviations from best practices with database components
  • Participate in performance, load, and stress testing, and remediation of issues identified
  • Participate in security architecture reviews of a large enterprise system
  • Lead efforts to design and implement changes to data models for new and existing applications
  • Participate in all aspects of the application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and sustainment
  • Participate in activities that ensure the successful use of these systems including: developing documentation, test scripts, and training materials as necessary
  • You will have the opportunity to work and grow your expertise with a team of software engineering and cyber security experts working to tackle the cyber defense issues of the modern military with creative and innovative solutions.
Thank you for taking the time to read about our opportunity.. We look forward to talking with you about this position.
Required Skills:
  • Active Top Secret Clearance (Min Interim Top Secret)
  • DoDI 8570.01-M Information Assurance Technology (IAT) Level II certification(s) required to work on government IT systems to include one of the following (or acquire within 60 days): CCNA Security, GICSP, GSEC, CompTIA Security+ CE, SSCP or higher level certification
  • Must hold current (or acquire within 6 months) the appropriate operating system certification for information assurance technical positions as required by DoD 8570.01-M to include any of the following:
    • MCSA: SQL 2012/2016 Business Intelligence Development
    • MCSA: SQL 2012/2016 Database Administration
    • MCSA: SQL 2012/2016 Database Development
    • MCSA: SQL Server 2012/2014
    • MCSA: Machine Learning
    • Microsoft Certified Solutions Expert (MCSE): Data Platform (retired)
  • Experience engineering SQL Server infrastructures on version 2008R2/2016/2017
  • Proficiency with managing and administering SQL Server installations and databases including: developing maintenance plans, configuring server resources, monitoring performance, configuring instances and databases, and administering security
  • Expert level skills engineering redundant and scalable SQL Server infrastructures using technologies including log shipping and Always On Availability Groups
  • Proficiency utilizing the latest methods for monitoring performance using tools such as RedGate SQL Monitor for database tuning and query optimization
  • Experience engineering enterprise scale applications that perform extract/transform/load (ETL) operations with external data sources and SQL Server
  • Seven (7) years of experience in the above listed areas
Desired

Skills:
  • Experience with SQL Server 2017 Graph
  • Bachelors Degree
Ifyou are interested in getting more information about this opportunity, please contact Irina Rozenbergirozenberg@arielpartners.comat your earliest convenience.
At Ariel Partners, we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions, so when they have their biggest challenges were on their short list. Were looking for team members who share our values of:Integrityto do the right thing even when it hurts;Commitmentto the long term success and happiness of our customers, our people, and our partners;Courageto take on difficult challenges, accept new ideas, and accept incremental failure; and the constant pursuit ofExcellence.
Ariel Partners is an Equal Opportunity Employer in accordance with federal, state, and local laws.
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr MS SQL Database Developer
New!

Ariel Partners

Posted Today

VIEW JOBS 11/21/2018 12:00:00 AM 2019-02-19T00:00 The Senior Database Developer will be part of a team of experts charged with providing support in the areas of cyber analysis and cyber development capabilities in response to Navy’s and DoD’s needs for Cyber Situational Awareness (SA), Cyber Command and Control (C2), Mission Assurance, and Homeland Defense. Program scope includes identifying cyber key terrain by analyzing operational requirements, conducting cyber analyses and assessments, and developing and performing modeling and simulation in support of different cyber threat scenarios. The team will conduct cyber analyses and assessments to identify potential vulnerabilities and risks, determine mission and operational impacts, and make appropriate mitigation recommendations. Additionally, program support includes developing methodology and framework in support of cyber risk assessment life cycle. Our team will provide capabilities to support the customer with rapid design, development, test, deployment, maintenance and operation of specific software and hardware capabilities to meet current Cyber Defensive needs.<br />  <br /> The Role<br /> As a Senior Database Developer on this program, you will use your expertise and experience in the following areas and activities to deliver solutions and services to our customer:<br /> DB Developer will focus on SQL Server Database performance optimization, tuning, and T-SQL development to ensure optimal MS SQL Server performance.<br /> Review and assess existing enterprise data-driven applications, to support new features, performance improvements, upgrades, and ongoing sustainment<br /> Analyze a large, complex system to determine performance bottlenecks, application bugs, and opportunities to improve efficiency<br /> Capture and analyze database activity to identify improvements in indexing and query execution performance<br /> Participate in performance, load, and stress testing, and remediation of issues identified<br /> Lead efforts to design and implement changes to data models for new and existing applications<br /> Participate in all aspects of the application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and sustainment<br /> You will have the opportunity to work and grow your expertise with a team of software engineering and cyber security experts working to tackle the cyber defense issues of the modern military with creative and innovative solutions.<br /> Thank you for taking the time to read about our opportunity. We look forward to talking with you about this position.<br />  <br /> <strong>Required Skills:</strong> <ul> <li style="padding: 0; margin: 0;"><strong><em>Active Top Secret Clearance (Min Interim Top Secret)</em></strong></li> <li style="padding: 0; margin: 0;">DoDI 8570.01-M Information Assurance Technology (IAT) Level II certification(s) required to work on government IT systems to include one of the following (or acquire within 60 days): CCNA Security, GICSP, GSEC, CompTIA Security+ CE, SSCP or higher level certification</li> <li style="padding: 0; margin: 0;">Must hold current (or acquire within 6 months) the appropriate operating system certification for information assurance technical positions as required by DoD 8570.01-M to include any of the following: <ul> <li style="padding: 0; margin: 0;">MCSA: SQL 2016 Business Intelligence Development</li> <li style="padding: 0; margin: 0;">MCSA: SQL 2016 Database Administration</li> <li style="padding: 0; margin: 0;">MCSA: SQL 2016 Database Development</li> <li style="padding: 0; margin: 0;">MCSA: SQL Server 2012/2014</li> <li style="padding: 0; margin: 0;">MCSA: Machine Learning</li> </ul> </li> <li style="padding: 0; margin: 0;">Microsoft Certified Solutions Expert (MCSE): Data Platform (retired)</li> <li style="padding: 0; margin: 0;">Proficiency creating and maintaining SQL Server Integration Services packages</li> <li style="padding: 0; margin: 0;">Proficiency creating and maintaining SQL Server Reporting Services reports</li> <li style="padding: 0; margin: 0;">Proficiency utilizing development tools such as the RedGate tool belt (schema compare, source control, etc)</li> <li style="padding: 0; margin: 0;">Experience engineering enterprise scale applications that perform extract/transform/load (ETL) operations with external data sources and SQL Server</li> <li style="padding: 0; margin: 0;">Experience creating stored procedures, T-SQL scripts for applications or data manipulation</li> <li style="padding: 0; margin: 0;">Experience with data modeling and design in SQL Server 2017</li> <li style="padding: 0; margin: 0;">Seven (7) years of experience in the above listed areas</li> </ul> <strong>Desired Skills:</strong> <ul> <li style="padding: 0; margin: 0;">Experience with SQL Server 2017 Graph</li> <li style="padding: 0; margin: 0;">Bachelor’s Degree</li> </ul>  <br /> If you are interested in getting more information about this opportunity, please contact Irina Rozenberg <a href="mailto:irozenberg@arielpartners.com">irozenberg@arielpartners.com</a> at your earliest convenience.<br /> <br /> <em>At Ariel Partners, we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions, so when they have their biggest challenges we’re on their short list. We’re looking for team members who share our values of: </em><strong><em>Integrity</em></strong><em> to do the right thing even when it hurts; </em><strong><em>Commitment</em></strong><em> to the long term success and happiness of our customers, our people, and our partners; </em><strong><em>Courage</em></strong><em> to take on difficult challenges, accept new ideas, and accept incremental failure; and the constant pursuit of </em><strong><em>Excellence</em></strong><em>. </em><br /> <br /> <em><em>Ariel Partners is an Equal Opportunity Employer in accordance with federal, state, and local laws.</em></em> Ariel Partners Dahlgren VA

Sr. MS SQL Database Architect

Ariel Partners