SQL Database Administrator

29 Jun 2024

Vacancy expired!

SQL DBA

St. Louis, MO / Springfield, VA

ship

Seeking a SQL Database Administrator. The SQL DBA will support the Database team in the administration, development, and testing, of database platforms supporting functions such as designing, implementing and maintaining new databases, backup/recovery and configuration management. Install database management systems (DBMS) and provide input for modification of procedures and documentation used for problem resolution and day-to-day maintenance. This role will support efforts to accelerate development of automation scripts for deployment, configuration, security hardening and patch management of standard database and Web Service platforms.

Key Duties include:

  • Working with other teams to consolidate database instances and storage using capacity and performance analysis tools to identify underutilized instances, duplicate copies of data and identify associated server, network and storage resources that can be "right sized"
  • Support the database engineering team in integrating, implementing, and operating OIT Database systems (Datacom/DB, IBM DB2, Microsoft SQL Server, and Oracle) across the entire enterprise and with cloud service providers to support 24x7x365 availability
  • Conduct problem root cause analysis and isolate system problems utilizing diagnostic and system management tools (i.e. system dumps and system/component traces, monitoring tools, vendor problem data bases).
  • Maintain security hardened baseline configurations and deploy security (patches), software maintenance (patches) and new software releases and supporting products infrastructure as directed by the system owner, policy, or the Cybersecurity Directorate.
  • Support the engineering, integration, implementation, and operation of a virtualization strategy to include Database server consolidation, storage consolidation, and automation. Automation includes seamless Database provisioning, and non-disruptive workflow/application/data migrations.
  • Maintain up-to-date documentation of all procedures, infrastructure diagrams, system configuration and baseline standards, implementation plans, system back out plans, system recovery plans, maintenance plans, system upgrades, and all system changes.
  • Support resolution of incidents and execution of approved change requests
  • Design and implement automated responses to system issues (e.g., automatic failover, resource allocation adjustments).
  • Minimum Requirements:

    • 5-10 years of experience and a B.S. degree. Bachelor of Science (BS) can be substituted with an additional 4 years of related experience.
    • 3+ years of experience as SQL Server Database Administrator for 24x7 operations (must include installation & configuration in a production environment)
    • 3+ years of experience with database migrations and monitoring involving SQL Server, Oracle, and/or MySQL
    • 3+ years of experience with ETL processing, data modeling, and SQL scripting
    • 3+ years of experience managing Microsoft SQL servers in VMWare and cloud/virtual environment
    • Hands-on experience installingand configuring SQL Server Reporting Services (SSRS)
    • ship

    Preferred Requirements

    • Certified MCITP (Microsoft Certified IT Professional)
    MCSE -Microsoft Certified Solution Expert: SQL Server

    #cjpost

    • ID: #43687088
    • State: Virginia Springfield 22152 Springfield USA
    • City: Springfield
    • Salary: USD TBD TBD
    • Job type: Permanent
    • Showed: 2022-06-29
    • Deadline: 2022-08-27
    • Category: Et cetera