Senior Oracle Database Administrator

INFORMATION TECHNOLOGY STRATEGIES INC•Remote, US,

2d•Onsite

About The Position

Information Technology Strategies, Inc. is a government IT solutions provider servicing commercial and government initiative in various parts of the United States. We are currently seeking a Senior Oracle Database Administrator to work for our company. The client agency is the Defense Logistics Agency. The role involves serving as a senior administrator for enterprise application databases and supporting platform services to ensure availability, performance, and reliability. This includes designing, creating, configuring, and maintaining complex databases in client/server environments, and supporting systems design and database programming. Responsibilities also 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 requires managing stakeholder activities and providing input supporting technical requirements, staffing, and cost analysis. It also involves supporting stakeholders through planning and projecting long-range database requirements in coordination with IT leadership and functional stakeholders. Establishing/coordinating backup schedules, executing backups/restores, and validating recovery capability are key duties. Providing data management support, including data cleansing, database modeling assistance, and enforcement of data integrity processes, is also expected. Developing and maintaining database/data governance artifacts such as policies, standards, procedures, dictionaries, schema documentation, file design/storage, and integration design is part of the role. Support for reporting and analytics needs, running queries, developing reports, and assisting with SQL Server Reporting Services configuration/troubleshooting as needed is required. The role also supports platform connectivity and application availability, including advanced application networking concepts like load balancing, tuning, optimization, and fault tolerance. Providing local and remote maintenance support for systems deployed across multiple locations and assisting other system administrators is necessary. Executing database Continuity of Operations (COOP) and Disaster Recovery (DR) responsibilities, including participation in planning, documentation, exercises, and related continuity activities, is crucial. Finally, the position supports daily troubleshooting, system setup, error triage, and configuration for SQL Server and SQL Clusters, with experience in capacity planning and system health monitoring using Idera and SolarWinds.

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
8+ Years of experience (Domain and Expert technical knowledge within the database field)
8+ 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 Oracle, Oracle Grid, Oracle RMAN, 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; and 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.