Sr. Oracle Database Administrator SRORA001843

Alpha Omega Integration - Kiln, MS

Full-time - Senior

Kiln, MS

Professional, Scientific, and Technical Services

About the position

The Senior Oracle Database Administrator is responsible for overseeing the Enterprise Oracle environment at NCEI, focusing on monitoring, troubleshooting, maintaining, reporting, and upgrading database systems. This role requires a deep understanding of database management and the ability to implement solutions for both relational and non-relational databases.

Responsibilities

• Determine requirements for new relational and non-relational databases.
• Develop recommendations and solutions for new database initiatives.
• Control and monitor user access to the databases.
• Monitor and optimize 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 the 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.
• Identify areas for improvement in the current systems.
• Own 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

• 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.
• 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 ability to think algorithmically.
• Experience with Git, GitLab.
• Strong bias toward action, delivery, and implementation.