SQL Database Administrator (DBA)

Company: Abaco Strategy
Location: Leesburg
Posted on: March 19, 2023

Job Description:

United States Citizenship Required

Years of Relevant Experience Required: Five (5) years SQL Server Database Administration skills

Education Required: 4-year college degree

Must have a minimum of 3 years of experience successfully using and supporting the following technologies:

• SQL Server releases: 2016, and 2017
• SQL Server Integration Services (SSIS) for Extract, Transformation, and Loading (ETL)
• SQL Server Replication
• SQL Server Availability Groups
• SQL Server Reporting Services (SSRS)
• Idera (for monitoring SQL Server)
• Windows 2016
• Powershell
• XML and XML Schema technology
• XML shredding
• C#.net
• Connect:Direct
• SFTP Minimum of 1-year experience successfully using and supporting SQL Server 2019
  
  Responsibilities:
  • Design and modify model objects (tables, views indexes) daily;
  • Develop ad-hoc queries on databases;
  • Perform various ETL processes;
  • Provide analytical services for system incidents and enhancements;
  • Process defect tickets to correct system errors;
  • Process release tickets to manage user requirements within the timeframe directed by the specific ticket request;
  • Process change tickets to implement system changes;
  • Provide analytical services on systems to implement user-defined requirements;
  • Process defect tickets to correct system errors;
  • Provide analytical services on systems to identify operational efficiencies;
  • Facilitate collecting system requirements with the business program staff;
  • Test application code;
  • Perform testing on system changes to meet user-defined requirements;
  • Facilitate user acceptance testing (UAT) with the business program staff;
  • Produce detailed accounting of hours worked by tasks;
  • Monitor and optimize the performance of the database.

Keywords: Abaco Strategy, Leesburg , SQL Database Administrator (DBA), Other , Leesburg, Virginia