SQL Database Administrator

INFORMATION TECHNOLOGY STRATEGIES INC•Remote, US,

2h•Onsite

About The Position

Information Technology Strategies, Inc. is seeking a Senior SQL Database Administrator to serve as the senior administrator for enterprise application databases and supporting platform services, ensuring availability, performance, and reliability. This role involves designing, creating, configuring, and maintaining complex databases in client/server environments, supporting systems design and database programming. Responsibilities include configuring JCL and access methods, optimizing access times and device allocation, establishing validation controls, data organization, and statistical methods, and applying data protection, security, and documentation requirements. The position also requires managing stakeholder activities, providing input for technical requirements, staffing, and cost analysis, and supporting long-range database requirements planning. Key duties include establishing and coordinating backup schedules, executing backups/restores, and validating recovery capability. The role provides data management support, including data cleansing, database modeling assistance, and enforcement of data integrity processes. Developing and maintaining database/data governance artifacts such as policies, standards, procedures, dictionaries, schema documentation, file design/storage, and integration design is also essential. Support for reporting and analytics needs, running queries, developing reports, and assisting with SQL Server Reporting Services configuration/troubleshooting is expected. The administrator will support platform connectivity and application availability, including advanced application networking concepts like load balancing, tuning, optimization, and fault tolerance. Local and remote maintenance support for systems across multiple locations, assistance to other system administrators, and execution of database Continuity of Operations (COOP) and Disaster Recovery (DR) responsibilities are also part of the role. Daily troubleshooting, system setup, error triage, and configuration for SQL Server and SQL Clusters, along with capacity planning and system health monitoring using Idera and SolarWinds, are required.

Requirements

Eligibility to obtain a U.S. Government PUBLIC TRUST / SECRET / TOP SECRET Clearance. (Basic Federal Clearance requirements are U.S. Citizenship, clear criminal history check, no recent or pending bankruptcies)
BS in Information Systems, or related experience
5+ Years of experience (Domain and Expert technical knowledge within the database field)
5+ Years of experience w/ Interactions involve client negotiations and interfacing with senior management
Minimum of five (8) years of satisfactory experience managing Oracle and SQL Database Administrators for federal or commercial clients.
Proven proficiency in creating and managing standalone SQL and Oracle databases.
Demonstrated ability to identify and triage issues, perform server maintenance, execute software installations and patching, maintain High Availability (HA) systems, and execute Disaster Recovery (DR) protocols.
Demonstrated expertise across SQL, SQL Server, SQL Clustering, SQL Scripting, PL/SQL, PostgreSQL, MySQL, MariaDB, and MS Access
Excellent written and verbal communication skills

Nice To Haves

Previous supervisory experience preferred

Responsibilities

Serve as senior administrator for enterprise application databases and supporting platform services to ensure availability, performance, and reliability.
Design, create, configure, and maintain complex databases in client/server (and other required) environments.
Support systems design and database programming.
Configure JCL and access methods; optimize access times and device allocation; establish validation controls, data organization, and statistical methods.
Apply data protection, security, and documentation requirements.
Manage stakeholder activities and provide input supporting technical requirements, staffing, and cost analysis.
Support stakeholders through Plan and project long-range database requirements in coordination with IT leadership and functional stakeholders.
Establish/coordinate backup schedules; execute backups/restores and validate recovery capability.
Provide data management support: data cleansing, database modeling assistance, and enforcement of data integrity processes.
Develop and maintain database/data governance artifacts: policies, standards, procedures, dictionaries, schema documentation, file design/storage, and integration design.
Support reporting and analytics needs, run queries, develop reports, and assist with SQL Server Reporting Services configuration/troubleshooting as needed.
Support platform connectivity and application availability, including advanced application networking concepts (e.g., load balancing, tuning, optimization, and fault tolerance) as applicable.
Provide local and remote maintenance support for systems deployed across multiple locations; assist other system administrators as required.
Execute database Continuity of Operations (COOP) and Disaster Recovery (DR) responsibilities, including participation in planning, documentation, exercises, and related continuity activities.
Support daily troubleshooting, system setup, error triage, and configuration for SQL Server and SQL Clusters.
Perform capacity planning and system health monitoring using Idera and SolarWinds.