Sr. Oracle Database Administrator

Alpha Omega Integration - Kiln, MS

Full-time - Senior

Remote - Kiln, MS

251-500 employees

Professional, Scientific, and Technical Services

About the position

The Senior Oracle Database Administrator at Alpha Omega Integration is responsible for supporting NOAA's National Centers for Environmental Information (NCEI) by managing and optimizing Oracle database systems. This role involves architecting and implementing database solutions, ensuring compliance with database policies, and performing maintenance and troubleshooting tasks. The position requires effective communication with stakeholders and a strong understanding of both on-premises and cloud database environments.

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 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, 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

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, 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

Benefits

• PTO including paid parental, military, and bereavement leave
• Eleven (11) paid Federal holidays, five of which are floating holidays
• Health and Dental Insurance (including 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 you complete two years of service
• FSA/DFSA/HSA flexible benefit plans
• Annual Tuition & Professional Development Reimbursement benefit