[Hiring] SQL Database Administrator @DMS Vision

Role Description

This position is within the Tools and DBA section of Application Management and will be required to extract data and create reports to address legal questions in conjunction with discovery efforts associated with ongoing legal investigation.

• Work with legal analysts to provide data/analysis to adequately address submitted requests.
• Format and present data in a user-friendly manner.
• Consult with programmer/system analysts, peers, business users, outside agencies, third parties, and vendors on database and application software issues.
• Convert or transfer database files or tables from existing storage locations and formats to replacement locations and formats.
• Develop and test automated means for performing conversion to assigned reports.
• Ensure software and application documentation is prepared and updated for assigned projects, problem reports, work efforts, and service requests.
• Analyze content and quality of databases, recommend data management procedures, and develop extraction processes.
• Identify opportunities for process improvement and automation.
• Work closely with cross-functional teams to understand their data needs and provide support.
• Other duties as assigned.

Qualifications

• At least 3 to 6 years of experience as an SQL Database Administrator in a Windows Server environment (2008, 2012, 2014, 2016, or 2019).
• Education in SQL Database Administration.
• Knowledge and experience with application software tools and application development methodology through complete life cycles (preferred).
• Knowledge and experience with the following system software:
• SQL Database - must have, current knowledge and training
• Windows Server OS, functions/commands - must have
• SQL Management Studio – must have
• SQL – must have
• SQL scripting and modifications of files generated out of the DB – must have
• Extensive knowledge of T-SQL (Stored Procedures, Triggers, Indexing, Agents), Data Tuning and cleansing, Query Tuning, and Database Security – must have
• Visual Studio – preferred
• WebSphere Application Server – optional
• Ability to deal effectively with the information technology needs of IT technicians, development staff, business users, and software vendor and management staff – Strongly preferred.
• Good organization and workload management skills – Strongly preferred.
• Effective written and oral communication skills and ability to establish and maintain good rapport with agency staff for effective and timely problem identification, resolution, and work efforts – Strongly preferred.
• Capability to work independently and effectively in complex environments.
• Access DB experience - optional.

Company Description