Open San Consulting

The Senior Database Administrator will be responsible for the installation, configuration, maintenance, and optimization of Oracle database systems to ensure high performance, security, and availability. In this role, the Senior Database Administrator will design and implement database schemas, monitors database health, and performs routine backups and recovery operations to safeguard mission-critical data. Additionally, the Senior Database Administrator will troubleshoot database-related issues, manage user access and permissions, and optimize queries to enhance system performance. In this role, the individual will ensure compliance with organizational policies and industry standards while staying current on updates, patches, and advancements in Oracle technologies. The Database Admin will build, support, administer, and sustain a clustered-server database platform hosted in an enterprise IT environment. The Database Administrator will provide technical support for incident response, service degradations, outages, and other service interruptions. Investigate hardware and software problems related to the database-hosting infrastructure and perform corrective actions. Responsibilities: * Architects, designs, engineers, and document Oracle databases and associated infrastructure in clustered, stand-alone, and/or appliance-hosted configurations, which fulfill mission requirements, service specifications, and cyber security mandates * Investigates hardware and software problems related to the database-hosting infrastructure and perform corrective actions * Implements robust backup, restoration, and disaster recovery strategies * Monitors, fine-tune, and optimize database performance for minimal downtime and maximum efficiency * Establishes and enforces stringent database security protocols and access controls * Collaborate closely with application development teams to design and optimize Oracle databases. * Oracle RAC: Grid Infrastructure/ASM administration, installation, patching, configuration, and troubleshooting * Develops, executes and oversees data migration initiatives when required * Performance Tuning: AWR, ASH, statspack analysis, SQL tuning, optimizer statistics, and execution plan analysis * Data replication and migration: Oracle GoldenGate, Data Pump (expdp/impdp), and Data Guard * Spearheads scalability and high availability efforts for Azure SQL, Synapse Analytics, and other cloud-based databases while managing cloud resources and optimizing cost-effectiveness * Maintains comprehensive documentation detailing database configurations, procedures, and best practices * Regularly generates performance and usage reports to support informed decision-making * Drives problem resolution and root cause analysis across the technology stack * Participates in the resolution of database availability, capacity, and performance issues. * Participates in infrastructure and organizational initiatives across multiple IT disciplines. * Sustains fleet of physical and virtual database-hosting servers running a mix of operating systems (Open Systems and Windows Systems) in multiple network environments * Performs daily operations, onsite support, and on-call support for all aspects of database architecture, database platforms, and database management software * Works with original equipment manufacturers and/or third-party vendors to resolve performance degradations and outages * Supports and participates in projects relating to the move of systems and services to modernized hosting environments and Cloud capabilities * Provides expert advice on configuring database systems to meet the environment and boundary requirements and customize services to meet new performance goals. * Works with original equipment manufacturers and/or third-party vendors to resolve performance degradations and outages. * Supports and participates in projects relating to the move of systems and services to modernized hosting environments and Cloud capabilities * Provides expert advice on configuring database systems to meet the environment and boundary requirements and customize services to meet new performance goals. Required Qualifications/Education and Experience: * Must have an active Top Secret Security Clearance with SCI eligibility * Possesses a B.S. in a related field and 10+ years of database administration experience including experience with Oracle databases. * ITIL v4 Certification * Oracle Database Administration (12c-21c): Installation, configuration, patching, and troubleshooting. * A strong understanding of data and databases, Python, the ability to translate customer requirements, collaborating with cross-functional stakeholders * Strong oral and written communication skills. * Multitenant: Installation, configuration, patching, troubleshooting. * RMAN: Backup and recovery and recovery catalog management. * Automation & scripting: Shell (Bash), Ansible, and/or Perl. * Oracle Data Guard: Physical/logical standby implementation and failover/failback procedures. * Monitoring: Oracle Enterprise Manager (OEM) management, patching, and configuration. * Security & Compliance: TDE, auditing, and STIGs. * Oracle Apex: Installation, configuration, patching, and security. * ORDS: Installation, configuration, and patching. * OS: Linux navigation, vi, awk, sed, sudo/ksu, cron, top, sar, and parameter configurations for Oracle implementations. OSC Edge delivers a total rewards package that we know will attract, engage and retain top talent. Key elements of our package include a competitive base pay and a comprehensive benefits package: We offer eligible employees with an opportunity to enroll in a variety of benefits offerings. Here are just some of our benefits for our US based positions: * Medical/ Dental/ Vision * Life insurance and AD&D * Flexible Spending * Accident, Critical Illness and Hospital Indemnity coverage * 401(k) and ROTH retirement options and company match * Pet Insurance * Identify Theft and Fraud Protection coverage About OSC Edge: Founded in 2008, what started as a small business has grown into a diverse and innovative global team owned by Cook Inlet Region, Inc. an Alaska Native Regional Corporation. As a US Federal contractor, we are a dedicated IT Service Provider supporting the Departments of the Army, Navy, Air Force, DoD Educational Institutions, and large corporate entities. Our expertise is in Cloud Computing, Cyber Security, Compliance Management, Enterprise Architecture, IT Support, and CSfC. If you are passionate about making a difference and thrive in a dynamic and collaborative environment, we invite you to apply to join our team. Equal Opportunity Employer/Veterans/Disabled