Database Administrator

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: o SQL Database - must have, current knowledge and training o Windows Server OS, functions/commands - must have o SQL Management Studio - must have o SQL - must have o SQL scripting and modifications of files generated out of the DB - must have o Extensive knowledge of T-SQL (Stored Procedures, Triggers, Indexing, Agents), Data Tuning and cleansing, Query Tuning, and Database Security - must have o Visual Studio - preferred o 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. Education required: Education in SQL database administration in support of a Mainframe. Provide documentation showing completed courses.