Overview:
As a Senior Oracle Database Administrator, you will work as part of a team supporting modernization efforts for the Federal Aviation Administration (FAA).
Responsibilities:
- Perform modifications to and maintenance of operational programs and procedures.
- Provide all activities related to the administration of Oracle databases
- Analyzes business processes and procedures to recommend technical system/software solutions.
- Prepares documentation of program development, modifications to code as needed.
- Applies best practice for tuning SQL and PL/SQL for overall system performance.
- Supports software development and test teams throughout the software development lifecycle. Includes incremental script execution and defect resolution.
- Review proposed database structure changes by development teams and approve or modify based company standards and best practices.
- Provides support for software releases
- Researches interfaces to identify and code required updates to support integration
Qualifications and Education:
Required skills:
- Typically requires a bachelor's degree n Computer Science or other IT degree with engineering, math, and/or science degrees being acceptable substitute degrees
- 8+ years of relevant experience including:
- At least 5 years of recent experience managing a medium to large production RAC installation with strong RAC/clustering, RMAN, and Data Guard experience
- Strong performance tuning skills, identify performance bottlenecks in the application/database and tune accordingly.
- Extensive experience and a solid understanding in administering complex database architectures of Oracle 11g, 12c & all latest releases.
- Experience creating databases from design models and building physical environments.
- Experience with logical and physical data modeling and RDBMS concepts.
- Complete understanding of database partitioning
- Experience designing, developing, testing, documenting, deploying, implementing and tuning Oracle SQL and PL/SQL Languages code.
- Extensive experience with data migration and data loads, often from non-Oracle sources.
- Knowledge of Real Applications Clusters, Data Guard, Flashback technology, Recovery Manager, and Oracle Enterprise Manager.
- Setup & Monitor DB servers proactively to ensure optimized usage of resources using various monitoring tools
- Perform and setup daily environment health checks and generate reports to capture the findings
- Ability to perform PL/SQL coding assignments including stand-alone SQL scripting and database stored code (triggers, packages, procedures, and functions) in compliance with standards and procedures.
- Design, implement, code, test and maintain Oracle PL/SQL including packages, procedures, triggers and functions in compliance with company standards and best practices.
- Experience with logical and physical data modeling and RDBMS concepts.
- Firm understanding of the overall architecture required to support common schema based objects used to store data and implement business logic.
- Experience with software development lifecycle and software development common practices (code reviews, unit testing etc.).
- Ability to provide guidance, oversight, and peer review to more junior database developers and direction to other technical resources as required.
- Working knowledge and ability to support Weblogic administration.
- Actively worked on Oracle Forms and reports
- Good understanding of OID, OAM, LDAP configurations
- Firm understanding of the overall architecture required to support common schema based objects used to store data and implement business logic.
- Experience working in Linux environment.
- Experience with software development lifecycle and software development common practices (code reviews, unit testing etc.).
- Ability to provide guidance, oversight, and peer review to more junior database developers and direction to other technical resources as required.
- Aptitude for debugging problems in complex, unfamiliar code
- Experience working closely with applications implementing full life cycle
- Experience with tools such as TOAD, SQL Developer
- Strong written and oral communication skills
- Solid work ethic, self-driven, can function independently with minimal oversight and direction
- Ability to optimize applications for better performance
- The ability to successfully obtain and maintain a U.S. Suitability/Public Trust Background Clearance
Desired skills:
- Experience with development tools such as Jira, Git and Confluence
- Experience in an Agile/Scrum team environment
- Development work in SQL Server environment
- Experience supporting the FAA
Compensation:
In accordance with pay transparency guidelines, the proposed salary range for this position is $80,500 to $104,000. Final salary will be determined based on various factors such as relevant skills, experience and certifications.