This is a job description for a Senior Oracle Database Administrator 

Summary: Alpha Omega is actively seeking a Senior Oracle Database Administrator to join our current team supporting NOAA's National Centers for Environmental Information (NCEI). To meet NOAA and NESDIS mission objectives, NCEI ingests large volumes of data and is engaged in substantial software development to produce authoritative data sets and derived products and services. NCEI ingests, archives, and stewards NOAA's observational data, model outputs and derived information for private and public use, while also generating products and services. Our contract Team supports the NCEI mission by providing system administration support for NCEI infrastructure, data management and software development activities.

Duties & Responsibilities: Determine requirements for new relational and non-relational databases. Develop recommendations and solutions for new database initiatives. Controlling and monitoring user access to the databases. Monitoring and optimizing the performance of the databases. Determine, enforce, and document database policies, procedures. and standards. Troubleshoot Oracle database performance incidents and problems across Dev, Test, and Production environments. Perform database and software lifecycle activities to ensure highest level of system performance and availability and compliance with business requirements

Perform Oracle database and application server administration. Modify database structures, as necessary, from requirements and DDL provided by application developer teams. Perform backup, data integrity validation, and restoration activities related to databases using systems such as Oracle Recovery Manager (RMAN), Tivoli Storage Manager (TSM), and operating system scripts

Use high-speed transaction recovery techniques and recover from database backups. Ensure compliance with the Oracle license agreement. Identifying areas for improvement in the current systems. Ownership of Database tasks and deliverables in Project Plans

Perform requirements gathering, planning and execution of approved migration activities to other database platforms, including "cloud" platforms. Analyze data stored in the database and make recommendations relating to performance and efficiency as it relates to data storage .Develop and maintain documentation related to database technology . 

Requirements and Qualifications: Bachelor's Degree or equivalent in Computer Science or related field; demonstrated relevant experience and skillsets will be considered. 8+ years of experience in database administration and development primarily in Oracle, but also familiarity with other databases (PostgreSQL, MariaDB). Demonstrated problem-solving skills and ability to logically analyze complex processes and systems. Superior analytical and troubleshooting skills. Strong understanding of RDBMS concepts, principles, and security. Oracle experience should include: RMAN, partitioning, parallel query, performance tuning, Enterprise Manager, APEX and demonstrated fluency in SQL and PL/SQL. Strong working knowledge (6+ recent years) of Linux OS System Administration. This includes in-depth knowledge and experience with troubleshooting and resolving incidents and problems through the shell (command line interface). Extensive experience (4+ recent years) with Linux shell scripting (e.g. BASH, KSH, etc.). Write and debug complex Structured Query Language (SQL). Excellent verbal and written communication skills. Hands-on experience with database standards and end user applications. Excellent knowledge of data backup, recovery, security, and integrity. Proven experience with database design, documentation, and coding. Previous experience with database case tools, IDEs and CLIs. Familiarity with programming languages, libraries, and APIs. Problem solving skills and abi ity to think algorithmically. Experience with Git, GitLab

Strong bias toward action, delivery, and implementation. Federal government experience a definite plus. Previous experience providing database system administration support for a scientific community. Working experience with other relational databases, including PostgreSQL and MariaDB. Familiarity with cloud-based technologies and processes, with a focus on AWS. 

AWS RDS experience and migrating relational databases from on-premises to the cloud is desired. Familiarity with non-relational data technologies, for example graph databases, key-value databases (Redis, AWS DynamoDB), search/analytics engines (ElasticSearch), vector databases etc. Strong knowledge of the full software development lifecycle, with exposure to Agile or iterative approaches to delivery. 

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities