Ref No.: 18-04784
Location: Washington, District of Columbia
Position Type:Direct Placement
Pay Rate : $ 60,000.00 - 100,000.00 /Year
Database & Systems Administrator
The Database & Systems Administrator assists with the design and maintenance of a dependable, secure technical infrastructure. The Administrator will work with IT, Project Managers and outside vendors in order to meet company requirements. Duties include troubleshooting issues, suggesting improvements, SQL administration, SQL development implementing, and helping administer information technology for the department; developing scripts to support automation of department services, creating documentation of department processes and software, and assisting users with the use of department technology.
Duties and Responsibilities:
  • Create and maintain SQL maintenance plans, SQL clusters, SQL disaster recovery plans, and ensure system stability and uptime.
  • Develop custom SQL stored procedures and PowerShell scripts to automate department workflows and reduce manual administration.
  • Coordinate and interact with Vendor support teams to support 3rd party systems and applications.
  • Assist in SQL development of end user applications.
  • Upgrade, install, patch, migrate, load balance, administer and troubleshoot Microsoft SQL servers and databases.
  • Make database capacity, backup strategy, high availability, disaster recovery, performance, and audit recommendations.
  • Administer and archive data storage, as required, using scripting, copy utilities and comparison software.
  • Create SQL Reports and assist with Business Intelligence initiatives.
  • Monitor capacity and load balancing and request new storage volumes for both SQL and flat file storage.
  • Install applications on new servers and prepare them for production usage.
  • Respond to afterhours requests, alerts and emergencies, as needed.
  • Provide escalated application support as necessary for various department software.
  • Install and upgrade department systems after hours, as needed.
  • Act as a liaison with the IT department when managing Litigation and Practice Support operational issues and troubleshooting. 
  • Document IT systems and processes and update existing documentation as changes are made.
  • Other duties as assigned.
Education and/or Experience:
  • Bachelor's degree in a related field or equivalent experience
  • Strong knowledge of and experience with SQL Database Administration
  • Experience documenting and/or automating IT processes and workflows
  • Knowledge of and ability to troubleshoot problems with Windows Servers, Workstations, Databases, Networks, Firewalls, and Applications

  • Experience with PowerShell scripting to automate and standardize administrative tasks
  • Experience administering SQL servers in environments with High Availability and Disaster Recovery
  • Experience with Business Process Management software
  • Data analysis and reporting skills in SQL, Excel, Access, etc.
  • Prior experience with ticketing and task management systems