Sr. Oracle Database Administrator

Alpha Omega Integration - Boulder, CO

Full-time - Senior

Remote - Boulder, CO

251-500 employees

Professional, Scientific, and Technical Services

About the position

The Senior Oracle Database Administrator will support NOAA's National Centers for Environmental Information (NCEI) by managing and optimizing Oracle databases, ensuring data integrity, and implementing database solutions. This role requires hands-on experience in database administration, particularly with Oracle Enterprise Edition 19c, and involves both on-premises and cloud database management. The position is critical for maintaining the performance and availability of NCEI's data infrastructure, which supports various scientific and public data initiatives.

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
• 8+ years of experience in database administration and development primarily in Oracle
• 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
• Experience with RMAN, partitioning, parallel query, performance tuning, Enterprise Manager, APEX, 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)
• Write and debug complex 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

Nice-to-haves

• Federal government experience
• 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
• Familiarity with non-relational data technologies, such as graph databases and search/analytics engines
• Strong knowledge of the full software development lifecycle, with exposure to Agile or iterative approaches to delivery
• Oracle Database Administration 2019 Certified Professional certification

Benefits

• PTO including paid parental, military, and bereavement leave
• Eleven (11) paid Federal holidays, five of which are floating holidays
• Health and Dental Insurance with 100% employer paid premiums for employee coverage under the HDHP health plan
• Life Insurance, STD/LTD term disability coverage, with employer paid premiums
• 401 (k) plan with a match that is 100% vested after two years of service
• FSA/DFSA/HSA flexible benefit plans
• Annual Tuition & Professional Development Reimbursement benefit