NorfolkRecruiter Since 2001
the smart solution for Norfolk jobs

Senior Database Analyst - SQL - Norfolk SDP

Company: General Dynamics Information Technology
Location: Norfolk
Posted on: November 22, 2022

Job Description:

  • Participates in the design, maintenance, enhancement, coding, and administration of relational databases
  • Performs day-to-day SQL administration; maintenance, troubleshooting, repair, ensuring data availability
  • Performs Database Backup and Recovery functions as needed
  • Installs SQL SW, Instances and perform upgrades and patching as needed
  • Writes/maintains SQL scripts and processes as needed
  • Creates indexes to enhance performance
  • Designs/implements data transfer processes needed to support upgrades or movement to from different physical/virtual Machine/OS
  • Authors/maintains System Security Plans, white papers and change management proposals, SOPs
  • Creates, manages and performs troubleshooting Windows Clustering and SQL Server high-availability solutions
  • Creates and monitors SQL Server Policy Objects
  • Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities.
  • Coordinates new data development ensuring consistency and integration with existing data warehouse structure.
  • Monitors Ticketing System queue for DBA assignments
  • Participates in continuous improvement efforts in enhancing performance and providing increased functionality, including performing proactive maintenance such as ensuring continued space availability, monitoring activity, and documenting problems, changes, and solutions.
  • Assignments may include design of data dictionaries, database structure and layout, installing, upgrading, and managing database applications.
  • May provide guidance and work leadership to less-experienced Analysts.
  • Stay current on vendors' best security practices in relation to organizational requirements.
  • Maintains current knowledge of relevant technologies as assigned.
  • Monitors SQL Event Logs and use to identify/troubleshoot issues
  • Creating and managing SQL Server Maintenance Plans for routine tasks and backup solutions as well as ability to create, troubleshoot and monitor SQL Server Agent jobs
  • Reviews database jobs, backup logs, user connections and system memory
  • Reviews performance information for SQL instances
  • Completes STIG Checklists for SQL serversEducation:
    • Bachelor Degree in Computer Science or a related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience required.Required Qualifications:
      • Experience with Microsoft SQL Server in Microsoft clusters.
      • Hands-on STIG/SCAP experience required.
      • Active DOD Secret clearance required; SSBI required.
      • Current Security+ certification required.Preferred Qualifications:
        • Microsoft SQL 2012+ and MySQL administration
        • Microsoft Operating Systems (Windows Server 2008/2012, Windows 10 SHB, etc.) a plus
        • T-SQL scripting knowledge
        • PowerShell a plus
        • Understanding of IT Security best practices to meet DOD STIGsEDUCATION AND EXPERIENCE: BA/BS or equivalent, 5+ years of experience

Keywords: General Dynamics Information Technology, Norfolk , Senior Database Analyst - SQL - Norfolk SDP, IT / Software / Systems , Norfolk, Virginia

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Virginia jobs by following @recnetVA on Twitter!

Norfolk RSS job feeds