Database Administrator

Sterling, VA
Nov 23, 2021
Dec 04, 2021
Full Time
DescriptionJob Description:Leidos currently has an opening for a Database Administrator supporting a customized enterprise management application that manages curriculum design, forecasting, student registration, scheduling, instructor management, housing, financial management and comprehensive reporting. The system uses Oracle and Microsoft SQL Server databases. as well as standardized products including Microsoft Windows Server, Red Hat Linux Server, and VMWare operating systems.Primary Responsibilities:Provide analysis, design, development, and deployment support for customer database requirementsManage database auditing, to include daily review of audit reportsContinually investigate methods to improve database reliability and performance for peer review and implementation alongside developers and systems engineersProvide input on capacity planning, high availability solutions and upgrade strategiesProactive database performance monitoring, tuning and best practices implementationProvide support and guidance to application developers with SQL tuning, data modeling and physical database designEnforce and document database policies, procedures and standards, ensuring that storage and archiving procedures are functioning correctlyProvide 24x7 support for critical production systems. Be available for after-hours maintenance activitiesCommunicate with technical, applications and operational staff to ensure database integrity and securityDiagnose and troubleshoot database errors where standard remediation and/or re-engineering and architectural changes may be requiredCreate and manage database reports, visualizations, and dashboardsCreate and manage repeating, automated database tasks.Perform baseline and continuous hardening for Oracle and SQL Server databases according to industry and US Government security controls, and best practicesAdditional Responsibilities:Install, upgrade, and perform regular patch management of database management software componentsMaintain full operational capability of Oracle (12c/18c) and Microsoft SQL Server (>= 2016) backend databases in support of the various business applicationsManage database access, including user, role, profile, and object-level permissionsBasic Qualifications:Bachelors' Degree or equivalent work experience and 4 - 8 years of relevant experience.Strong, hands-on production-level Oracle DBA experience on Unix/LINUX systemsSolid production-level SQL Server DBA experienceThorough database high availability and replication experience using utilities such as Oracle RAC, Data Guard, Data Pump, etc.Excellent experience with database design, creation, upgradeSolid knowledge of Oracle 12c and technical database concepts, such as: logical relational data modeling, physical data modeling, tuning large instances, resource management, data replication and backup/recovery techniques.Knowledge of heterogeneous database gateways, esp. between Oracle and SQL Server databasesExperience in Oracle database tuning and SQL optimization using Enterprise Manager Cloud Control, AWR/ADDM, etc.Ability to develop key performance metricsExcellent problem solving and analytical skills with the ability to effectively troubleshoot, resolve, or escalate problemsExperience with automating database tasks using T/SQL, PL/SQL, Python, ksh, bash, csh, and (Windows) PowerShell scripting, and other automation utilitiesMust have excellent communications and documentation skillsUnderstanding of Change and Incident Management processes, includingSubversion revision controlPreferred Qualifications:Oracle Database Administrator CertificationsRelevant AWS certification preferredPay Range:Pay Range $71,500.00 - $110,000.00 - $148,500.00#Remote