Dec 29, 2021

SQL Developer- Fairfax, VA

$100,000 - $115,000 yearly
  • MKS2 Technologies
  • Fairfax, VA, USA
Contractor Information Technology

Job Description

MKS2 is looking for a SQL developer who will be responsible for designing databases and ensuring their stability, reliability, and performance. You will also work with application developers optimizing in-application SQL statements as necessary and establishing best practices. You will help solve all database usage issues and come up with ideas and advice that can help avoid such problems in the future.  Candidates must also write complex T-SQL queries to support web application and business analytics in addition to ensuring database performance, efficiency, and recovery.  Works directly with the web application development team to design, code, test, debug and document web application data tiers.  

Provides database support by verifying databases associated with network tools and solutions function as required.  Responsible for managing the routine operations and maintenance of databases and ensuring their reliable and efficient performance.  Focuses on establishing the architecture, design, and security of various databases.

Job Responsibilities

  • Performs preventive and corrective maintenance and incident management measures.   
  • A minimum of 5years of experience in extensive T-SQL programming.
  • A minimum of 5 years of experience in data modeling.
  • Experience working with large databases, table partitions etc.
  • Experience developing and documenting processes, procedures, and policies for tool usage and
    integration.
  • Responsible for SQL Script development and creation of SSIS packages for ETL work.
  • Experience working with data migration across databases.
  • Experience with writing complex stored procedures and functions.
  • Proven proficiency in writing complex SQL and T-SQL.
  • Must be able to work independently with minimal assistance and be able to pick up business
    knowledge quickly.
  • Must demonstrate strong verbal and written communication skills.
  • Conducts performance tuning and database design, dimensional analysis and modeling.
  • Maintains and adds to an extensive set of SQL Server Integration Service (SSIS) packages for
    Extract, Transform, and Load (ETL) data manipulation.
  • Experience with database source control and DACPACs desired.
  • Write and optimize in-application SQL statements.
  • Write and maintain ETL jobs.
  • Ensure performance, security, and availability of databases.
  • Prepare documentations and specifications.
  • Handle common database procedures such as upgrade, backup, recovery, migration, etc.
  • Write, review and recommend optimization techniques for SQL queries and stored procedures.
  • Capable of configuring popular database engines and orchestrating clusters as necessary.
  • Profile server resource usage,and optimize and tweak as necessary.
  • Collaborate with other team members and stakeholders.
  • Adhere to all company policies and procedures.

Minimum Qualifications

• Bachelor’s Degree in a related field of study.
• 5-10 years of related work experience.

Other Job Specific Skills

• Excellent attention to detail and analytical skills. 
• Advanced written and verbal communication skills. 
• Ability to multitask and work well under pressure.
• Knowledge of database backup and recovery strategies.
• Experience with DBA productivity and performance tools.
• Experience with DoD and Federal Government is strongly desired.
• Advanced knowledge of security network and infrastructure tools, including access control and/or encryption.
• In depth knowledge of troubleshooting skills and out of the box thinking to overcome data obstacles.

 

Physical Demands

Light office duties which may include sitting for prolonged periods of time, viewing digital screens for prolonged periods of time, lifting up to 10 pounds, use of a desk or mobile phone, typing on a keyboard, writing with a pen, pencil, or stylus, etc. 

Occupations

General-Other: IT-Software Development

States

VA

Security Clearance

Active Secret

Job Requirements

MKS2 is looking for a SQL developer who will be responsible for designing databases and ensuring their stability, reliability, and performance. You will also work with application developers optimizing in-application SQL statements as necessary and establishing best practices. You will help solve all database usage issues and come up with ideas and advice that can help avoid such problems in the future.  Candidates must also write complex T-SQL queries to support web application and business analytics in addition to ensuring database performance, efficiency, and recovery.  Works directly with the web application development team to design, code, test, debug and document web application data tiers.  

Provides database support by verifying databases associated with network tools and solutions function as required.  Responsible for managing the routine operations and maintenance of databases and ensuring their reliable and efficient performance.  Focuses on establishing the architecture, design, and security of various databases.

Job Responsibilities

  • Performs preventive and corrective maintenance and incident management measures.   
  • A minimum of 5years of experience in extensive T-SQL programming.
  • A minimum of 5 years of experience in data modeling.
  • Experience working with large databases, table partitions etc.
  • Experience developing and documenting processes, procedures, and policies for tool usage and
    integration.
  • Responsible for SQL Script development and creation of SSIS packages for ETL work.
  • Experience working with data migration across databases.
  • Experience with writing complex stored procedures and functions.
  • Proven proficiency in writing complex SQL and T-SQL.
  • Must be able to work independently with minimal assistance and be able to pick up business
    knowledge quickly.
  • Must demonstrate strong verbal and written communication skills.
  • Conducts performance tuning and database design, dimensional analysis and modeling.
  • Maintains and adds to an extensive set of SQL Server Integration Service (SSIS) packages for
    Extract, Transform, and Load (ETL) data manipulation.
  • Experience with database source control and DACPACs desired.
  • Write and optimize in-application SQL statements.
  • Write and maintain ETL jobs.
  • Ensure performance, security, and availability of databases.
  • Prepare documentations and specifications.
  • Handle common database procedures such as upgrade, backup, recovery, migration, etc.
  • Write, review and recommend optimization techniques for SQL queries and stored procedures.
  • Capable of configuring popular database engines and orchestrating clusters as necessary.
  • Profile server resource usage,and optimize and tweak as necessary.
  • Collaborate with other team members and stakeholders.
  • Adhere to all company policies and procedures.

Minimum Qualifications

• Bachelor’s Degree in a related field of study.
• 5-10 years of related work experience.

Other Job Specific Skills

• Excellent attention to detail and analytical skills. 
• Advanced written and verbal communication skills. 
• Ability to multitask and work well under pressure.
• Knowledge of database backup and recovery strategies.
• Experience with DBA productivity and performance tools.
• Experience with DoD and Federal Government is strongly desired.
• Advanced knowledge of security network and infrastructure tools, including access control and/or encryption.
• In depth knowledge of troubleshooting skills and out of the box thinking to overcome data obstacles.

 

Physical Demands

Light office duties which may include sitting for prolonged periods of time, viewing digital screens for prolonged periods of time, lifting up to 10 pounds, use of a desk or mobile phone, typing on a keyboard, writing with a pen, pencil, or stylus, etc. 


Apply Now