Database Administrator SQL

Job 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 our legal analysts in providing data/analysis to adequately address submitted requests in a manner that is meaningful and relative to the legal questions asked. Format and present in a user-friendly format.
Consults with programmer/system analysts, peers, business users, outside agencies, third parties and vendors on issues related to the database and application software and if needed, presents written and oral solution and analyses. The procedure to resolve will vary based on the issue/question raised.
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 assign reports.
Ensure software and application documentation is prepared and updated this assigned projects, problem reports, work efforts and service requests.
Analyze content and quality of databases, recommend data management procedures, and develops 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.
Preferred skills   : 
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; database management, SQL scripting/programming and operating systems:
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 and 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.