Alpha Omega Integration, LLC
Sr. Oracle Database Administrator, Database Administrator
Alpha Omega Integration, LLC, Boulder, Colorado, United States, 80301
Description
Job Title: Sr. Oracle Database AdministratorClearance Required: US Citizen, Public Trust Level 6 (National Agency Check with Inquiries (NACI))Work Location: Remote: Asheville, NC; Boulder, CO; Stennis, MS; Silver Spring, MD.
NCEI operates four duty stations: Asheville, NC; Boulder, CO; Stennis, MS; and Silver Spring, MD. NCEI Asheville is the preferred location. However, this contract does support a remote workforce. If the candidate is remote, the candidate must be able to travel up to 4 weeks of the year to Asheville for training purposes. Some travel to CO may be required.Alpha Omega is seeking a qualified
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.Today, NCEI operates two data centers-one in Asheville and one in Boulder. The NCEI IT Support Service contract staff maintain the IT and network infrastructure at both data centers. This position requires an experienced Subject Matter Expert (SME) that will have sufficient hands-on experience to architect, recommend, and implement database solutions derived from requirements provided by NCEI stakeholders, which includes NCEI leadership, science teams, and data stewardship teams. The person in this position must possess the ability to communicate effectively and influence NCEI staff and leadership regarding best practices and database administration policies. Demonstrated experience with the operation, management, and sustainment of on-premises relational database server systems is critical to supporting the NCEI mission. With NCEI's transition to the cloud, demonstrated cloud migration and cloud database service knowledge is desired. 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 Oracle Database Administrator
is responsible for monitoring, troubleshooting, maintaining, reporting, and upgrading the Enterprise Oracle environment at NCEI.Key Responsibilities:Determine requirements for new relational and non-relational databasesDevelop recommendations and solutions for new database initiativesControlling and monitoring user access to the databasesMonitoring and optimizing the performance of the databasesDetermine, enforce, and document database policies, procedures. and standardsTroubleshoot Oracle database performance incidents and problems across Dev, Test, and Production environmentsPerform database and software lifecycle activities to ensure highest level of system performance and availability and compliance with business requirementsPerform Oracle database and application server administrationModify database structures, as necessary, from requirements and DDL provided by application developer teamsPerform 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 scriptsUse high-speed transaction recovery techniques and recover from database backupsEnsure compliance with the Oracle license agreementIdentifying areas for improvement in the current systemsOwnership of Database tasks and deliverables in Project PlansPerform requirements gathering, planning and execution of approved migration activities to other database platforms, including "cloud" platformsAnalyze data stored in the database and make recommendations relating to performance and efficiency as it relates to data storageDevelop and maintain documentation related to database technology
Required Qualifications:Education:Bachelor's Degree or equivalent in Computer Science or related field; demonstrated relevant experience and skillsets will be considered
Experience/Skills:
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 systemsSuperior analytical and troubleshooting skillsStrong understanding of RDBMS concepts, principles, and securityOracle 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 skillsHands-on experience with database standards and end user applicationsExcellent knowledge of data backup, recovery, security, and integrityProven experience with database design, documentation, and codingPrevious experience with database case tools, IDEs and CLIsFamiliarity with programming languages, libraries, and APIsProblem solving skills and ability to think algorithmicallyExperience with Git, GitLabStrong bias toward action, delivery, and implementation
Preferred Qualifications:Federal government experience a definite plusPrevious experience providing database system administration support for a scientific communityWorking experience with other relational databases, including PostgreSQL and MariaDBFamiliarity with cloud-based technologies and processes, with a focus on AWSAWS RDS experience and migrating relational databases from on-premises to the cloud is desiredFamiliarity 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
Preferred Certifications:Oracle Database Administration 2019 Certified Professional certification
Benefit Information:Joining the Alpha Omega team entitles you to participate in all retirement benefits, plans of deferred compensation, health and insurance benefits, and other such benefits as set forth in the company's policy and benefits manuals. See below, to name a few:PTO including paid parental, military, and bereavement leaveEleven (11) paid Federal holidays, five of which are floating holidays (as designated by the company's holiday schedule each year)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 premiums401 (k) plan with a match that is 100% vested after you complete two years of serviceFSA/DFSA/HSA flexible benefit plansAnnual Tuition & Professional Development Reimbursement benefit
We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.Culture and Values:Alpha Omega's Core Values are
(H) harmony, (E) engagement, (A) accountability, (R) resourcefulness, and (T) tenacity
- collectively they are an acrostic reminder of the values that guide the work we do. We have
H.E.A.R.T. !We foster a culture that recognizes and rewards hard work. Our H.E.A.R.T. program invites colleagues and managers from across the organization to recognize each other for living out our core values. Spotlighted employees enjoy a detailed nomination about their core-values-aligned actions which are then shared with their manager.Our Company:Alpha Omega
is an award-winning Federal IT Solutions provider. Since our inception in 2016, we have grown our revenues to $140 million and our employee population to almost 500 people located across the U.S.At the heart of Alpha Omega's mission lies a comprehensive approach to addressing the most critical domains shaping our world today. Through strategic partnerships and cutting-edge technology, the company is committed to delivering mission-enabling solutions that transcend boundaries and propel progress in key areas. We deliver mission-focused solutions in our domain areas of national security, foreign affairs and climate science leveraging our expertise in cybersecurity, data and AI, and digital modernization.Our consistent growth has fostered a series of accolades including Inc. 5000 and WashingtonTechnology's Fast 50 awards for five consecutive years, Virginia Business Best Places to Work seven years in a row, and USA Today and Washington Post Top Workplaces.Alpha Omega places significant emphasis on bolstering national security efforts in collaboration with key government agencies such as the Department of Homeland Security (DHS). Through our
National Security
domain, we provide innovative solutions and strategic partnerships, the company is committed to safeguarding America's safety and prosperity. From implementing advanced cybersecurity protocols to strengthening critical infrastructure resilience, Alpha Omega's contributions are instrumental in defending the nation against evolving threats. Furthermore, our dedication extends to protecting the interests of our service members within the Coast Guard, recognizing their integral role in the broader national security framework. This comprehensive approach underscores Alpha Omega's unwavering commitment to ensuring the safety and security of the United States.Climate science
is integral to our national security strategy, as it provides crucial insights into environmental threats that can destabilize regions, exacerbate conflicts, and compromise vital resources essential for the safety and stability of our nation. Moreover, Alpha Omega recognizes the urgency of addressing climate change and its far-reaching implications. Through initiatives like the integration of advanced climate modeling within National Oceanic and Atmospheric Administration (NOAA) and supporting agricultural production and conservation efforts within the United States Department of Agriculture (USDA), the company actively contributes to the fight against climate crisis. By leveraging technology to drive sustainability and resilience, Alpha Omega underscores its commitment to preserving our planet for future generations.In addition to its domestic endeavors, our
Foreign Affairs
domain is deeply engaged in navigating complex foreign affairs and promoting U.S. diplomacy on the global stage. Through collaboration with the U.S. Department of State and other international partners, the company advances national interests while fostering cooperation and mutual understanding. By leveraging technological innovation, Alpha Omega strengthens America's position as a global leader and promotes stability in an increasingly interconnected world.Alpha Omega Integration, LLC (Alpha Omega) is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class. We are committed to the development of a creative, diverse, and inclusive work environment. Black, Indigenous, and People of Color (BIPOC), LGBTQIA, women, people over 40, and differently abled individuals are strongly encouraged to apply.#LI-Remote#LI-TW1#diceEqual Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
Job Title: Sr. Oracle Database AdministratorClearance Required: US Citizen, Public Trust Level 6 (National Agency Check with Inquiries (NACI))Work Location: Remote: Asheville, NC; Boulder, CO; Stennis, MS; Silver Spring, MD.
NCEI operates four duty stations: Asheville, NC; Boulder, CO; Stennis, MS; and Silver Spring, MD. NCEI Asheville is the preferred location. However, this contract does support a remote workforce. If the candidate is remote, the candidate must be able to travel up to 4 weeks of the year to Asheville for training purposes. Some travel to CO may be required.Alpha Omega is seeking a qualified
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.Today, NCEI operates two data centers-one in Asheville and one in Boulder. The NCEI IT Support Service contract staff maintain the IT and network infrastructure at both data centers. This position requires an experienced Subject Matter Expert (SME) that will have sufficient hands-on experience to architect, recommend, and implement database solutions derived from requirements provided by NCEI stakeholders, which includes NCEI leadership, science teams, and data stewardship teams. The person in this position must possess the ability to communicate effectively and influence NCEI staff and leadership regarding best practices and database administration policies. Demonstrated experience with the operation, management, and sustainment of on-premises relational database server systems is critical to supporting the NCEI mission. With NCEI's transition to the cloud, demonstrated cloud migration and cloud database service knowledge is desired. 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 Oracle Database Administrator
is responsible for monitoring, troubleshooting, maintaining, reporting, and upgrading the Enterprise Oracle environment at NCEI.Key Responsibilities:Determine requirements for new relational and non-relational databasesDevelop recommendations and solutions for new database initiativesControlling and monitoring user access to the databasesMonitoring and optimizing the performance of the databasesDetermine, enforce, and document database policies, procedures. and standardsTroubleshoot Oracle database performance incidents and problems across Dev, Test, and Production environmentsPerform database and software lifecycle activities to ensure highest level of system performance and availability and compliance with business requirementsPerform Oracle database and application server administrationModify database structures, as necessary, from requirements and DDL provided by application developer teamsPerform 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 scriptsUse high-speed transaction recovery techniques and recover from database backupsEnsure compliance with the Oracle license agreementIdentifying areas for improvement in the current systemsOwnership of Database tasks and deliverables in Project PlansPerform requirements gathering, planning and execution of approved migration activities to other database platforms, including "cloud" platformsAnalyze data stored in the database and make recommendations relating to performance and efficiency as it relates to data storageDevelop and maintain documentation related to database technology
Required Qualifications:Education:Bachelor's Degree or equivalent in Computer Science or related field; demonstrated relevant experience and skillsets will be considered
Experience/Skills:
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 systemsSuperior analytical and troubleshooting skillsStrong understanding of RDBMS concepts, principles, and securityOracle 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 skillsHands-on experience with database standards and end user applicationsExcellent knowledge of data backup, recovery, security, and integrityProven experience with database design, documentation, and codingPrevious experience with database case tools, IDEs and CLIsFamiliarity with programming languages, libraries, and APIsProblem solving skills and ability to think algorithmicallyExperience with Git, GitLabStrong bias toward action, delivery, and implementation
Preferred Qualifications:Federal government experience a definite plusPrevious experience providing database system administration support for a scientific communityWorking experience with other relational databases, including PostgreSQL and MariaDBFamiliarity with cloud-based technologies and processes, with a focus on AWSAWS RDS experience and migrating relational databases from on-premises to the cloud is desiredFamiliarity 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
Preferred Certifications:Oracle Database Administration 2019 Certified Professional certification
Benefit Information:Joining the Alpha Omega team entitles you to participate in all retirement benefits, plans of deferred compensation, health and insurance benefits, and other such benefits as set forth in the company's policy and benefits manuals. See below, to name a few:PTO including paid parental, military, and bereavement leaveEleven (11) paid Federal holidays, five of which are floating holidays (as designated by the company's holiday schedule each year)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 premiums401 (k) plan with a match that is 100% vested after you complete two years of serviceFSA/DFSA/HSA flexible benefit plansAnnual Tuition & Professional Development Reimbursement benefit
We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.Culture and Values:Alpha Omega's Core Values are
(H) harmony, (E) engagement, (A) accountability, (R) resourcefulness, and (T) tenacity
- collectively they are an acrostic reminder of the values that guide the work we do. We have
H.E.A.R.T. !We foster a culture that recognizes and rewards hard work. Our H.E.A.R.T. program invites colleagues and managers from across the organization to recognize each other for living out our core values. Spotlighted employees enjoy a detailed nomination about their core-values-aligned actions which are then shared with their manager.Our Company:Alpha Omega
is an award-winning Federal IT Solutions provider. Since our inception in 2016, we have grown our revenues to $140 million and our employee population to almost 500 people located across the U.S.At the heart of Alpha Omega's mission lies a comprehensive approach to addressing the most critical domains shaping our world today. Through strategic partnerships and cutting-edge technology, the company is committed to delivering mission-enabling solutions that transcend boundaries and propel progress in key areas. We deliver mission-focused solutions in our domain areas of national security, foreign affairs and climate science leveraging our expertise in cybersecurity, data and AI, and digital modernization.Our consistent growth has fostered a series of accolades including Inc. 5000 and WashingtonTechnology's Fast 50 awards for five consecutive years, Virginia Business Best Places to Work seven years in a row, and USA Today and Washington Post Top Workplaces.Alpha Omega places significant emphasis on bolstering national security efforts in collaboration with key government agencies such as the Department of Homeland Security (DHS). Through our
National Security
domain, we provide innovative solutions and strategic partnerships, the company is committed to safeguarding America's safety and prosperity. From implementing advanced cybersecurity protocols to strengthening critical infrastructure resilience, Alpha Omega's contributions are instrumental in defending the nation against evolving threats. Furthermore, our dedication extends to protecting the interests of our service members within the Coast Guard, recognizing their integral role in the broader national security framework. This comprehensive approach underscores Alpha Omega's unwavering commitment to ensuring the safety and security of the United States.Climate science
is integral to our national security strategy, as it provides crucial insights into environmental threats that can destabilize regions, exacerbate conflicts, and compromise vital resources essential for the safety and stability of our nation. Moreover, Alpha Omega recognizes the urgency of addressing climate change and its far-reaching implications. Through initiatives like the integration of advanced climate modeling within National Oceanic and Atmospheric Administration (NOAA) and supporting agricultural production and conservation efforts within the United States Department of Agriculture (USDA), the company actively contributes to the fight against climate crisis. By leveraging technology to drive sustainability and resilience, Alpha Omega underscores its commitment to preserving our planet for future generations.In addition to its domestic endeavors, our
Foreign Affairs
domain is deeply engaged in navigating complex foreign affairs and promoting U.S. diplomacy on the global stage. Through collaboration with the U.S. Department of State and other international partners, the company advances national interests while fostering cooperation and mutual understanding. By leveraging technological innovation, Alpha Omega strengthens America's position as a global leader and promotes stability in an increasingly interconnected world.Alpha Omega Integration, LLC (Alpha Omega) is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class. We are committed to the development of a creative, diverse, and inclusive work environment. Black, Indigenous, and People of Color (BIPOC), LGBTQIA, women, people over 40, and differently abled individuals are strongly encouraged to apply.#LI-Remote#LI-TW1#diceEqual Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)