Oracle Database Administrator - Asheville, United States - Columbus Technologies
Description
Overview:
We are actively seeking a Senior Data Architect to join our current team supporting the National Centers for Environmental Information (NCEI) within the National Oceanic and Atmospheric Administration (NOAA).
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 NOAAs 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.
Location:
On-site in Asheville, NC
Clearance Required:
US Citizen, Public Trust Level 6 (National Agency Check with Inquiries (NACI))
Responsibilities:
Position Description/Scope of Work:
This position requires an experienced Subject Matter Expert (SME) that will require sufficient experience to recommend and implement database solutions derived from requirements provided by NCEI Leadership.
The person in this position must possess the ability to influence NCEI staff and leadership regarding best practices and database administration policies.
Demonstrated Cloud Migration and Cloud Database Management System knowledge is required, as well as experience managing on-prem relational database server systems, in order to be successful in this position.
The primary relational database service supporting the NCEI mission today is based on Oracle Enterprise Edition 19c. Oracle databases have been an integral part of the NCEI mission for decades and require daily maintenance and support. The Senior Data Architect is responsible monitoring, troubleshooting, maintaining, reporting, and upgrading the Enterprise Oracle environment at NCEI. This position works closely with the NCEI DBA and Linux System Administrator teams.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
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
Qualifications:
Required Skills:
8+ years of experience in database administration and development primarily in Oracle, but also familiarity with other databases (PostgreSQL, MariaDB)
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.
Superior analytical and troubleshooting skills
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, python etc.)
Demonstrated problem-solving skills and ability to logically analyze complex processes and systems
Write and debug complex Structured Query Language (SQL)
Proven working experience as a Database Administrator
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
Strong knowledge of the full software development lifecycle, with exposure to Agile or iterative approaches to delivery preferred
Experience with Git, GitLab
Strong bias toward action, delivery, and implementation
Familiarity with cloud-based technologies and processes is an asset
Desired Skills:
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
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, ElasticSearch,key-value databases, vector databases etc.
Required Education:
Bachelors Degree or equivalent in Computer Science or related field; demonstrated relevant experience and skillsets will be considered
Oracle Database Administration 2019 Certified Professional certification is desired
Equal Opportunity/Affirmative Action:
We are committed to hiring and retaining a diverse workforce.
All qualified applicants will receive consideration for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity or expression, marital status, age, national origin, veteran status, disability status, or any other protected class.
EEO/AA/MFDVInformation collected and processed as part of your Columbus Careers profile, and any job applications you choose to submit is subject to Columbus'
Applicant and Candidate Privacy Policy .
#J-18808-Ljbffr