SQL Database Developer

Washington, Virginia

Employer: Abbtech Professional Resources
Industry: Database Developer
Salary: Competitive
Job type: Full-Time
SQL Database Developer
Location- Washington, DC
Clearance- Top Secret
Salary- 180k/yr
The above salary range represents the range expected for the position; however, final salary offers are based on a number of factors such as the position's responsibilities; the candidate's experience, education, and skills; location; travel required; and current market conditions.

This program requires US Citizenship

Responsibilities

  • Provide SQL Server/Database development and administration support in fast moving, secure, DevOps environment.
  • Provide engineering/operational maintenance and upgrades for SQL Servers, databases and a data warehouse to include: developing custom scripts to automate various database management processes, monitoring and tune the systems to achieve optimum DB/DW performance levels; developing, optimizing, and tuning stored procedures, functions, triggers, views, and queries, in support of the client's business intelligence and analytic applications.
  • Maintain and improve the database schema, database design, and transition development activities.
  • Resolve various database issues, to include problems with data modeling, design, queries, security control, backup/restore, disaster recovery, and import/export data, as well as coordinate with data ingest efforts.
  • Be proficient in T-SQL from development to administration.
  • Use Microsoft Enterprise SQL features such Always On, SSRS, and SSIS (data warehousing).
  • Support SQL development including creating and designing SSRS Reports, SSIS Packages, and Team Foundation Server with Visual Studio.
  • Perform Database Design and Data Cleansing with SSIS and ETL with different data sources.
  • Collaborate with the Application Development team, Testing team, other IT departments, and subject matter experts to improve database/data warehouse performance.
  • Maintain and monitor third party product and custom databases.
  • Conduct hardware and software audits of servers and databases to ensure compliance with established standards, policies, and configuration guidelines.
  • Develop, implement, and promote standard operating procedures and schedules. Research and recommends process improvements and industry best practices.
  • Schedule installations, upgrades, and patches in accordance with IT policies and procedures.
  • Ensure data/media recoverability by supporting scheduled system backups and database archive operations.
  • Ensure systems documentation and configuration management records are current.
  • Be resourceful, a problem solver, and methodical.

Qualifications
  • Minimum of 8 years with BS/BA; Minimum of 6 years with MS/MA; Minimum of 3 years with PhD
  • Active TS clearance, possess SCI eligibility and the ability to obtain a polygraph.
  • Experience with programming and database management including scripting
  • You have three (3) to five (5) years of experience designing, engineering, and administering SQL Server or Oracle databases.
  • You have three (3) to five (5) years of experience creating complex queries, stored procedures, functions, and reports using SQL or Oracle.
  • You have 3 years of experience with Data Modeling.
  • You have 5 years of experience with SSIS.
  • You have 3 years of experience with Microsoft PowerShell and Power-BI
  • Data Modeling, either SQL or Oracle.
  • Data warehouse architecture, implementation, and O&M
  • Microsoft PowerShell and Power-BI
  • High-availability, fail overs, backups, scaling and clustering operational systems
  • Splunk 8.0 or later
  • SharePoint
  • Service Fabric
  • OpenText
  • Leveraging Azure and/or AWS cloud services
  • ElasticSearch

ABBTECH is an EOE/Minorities/Women/Disabled Individuals/Veterans
Created: 2024-09-11
Reference: 26770
Country: United States
State: Virginia
City: Washington

Similar jobs: