Overview
On Site
Depends on Experience
Full Time
Skills
Oracle DBA
Job Details
DUE TO THE COMPLEXITY OF THE JOB WE CURRENTLY ACCEPTING USC
Senior Oracle DBA
Herndon, Virginia
Perform modifications to and maintenance of operational programs and procedures.
- 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
- Requires a Bachelor s Degree in Engineering, Math, or Science and a minimum of 8 years of relevant experience
- The ability to successfully obtain and maintain a U.S. Suitability/Public Trust Background Clearance
- Provide all activities related to the administration of Oracle databases
- Extensive experience and a solid understanding in administering complex database architectures of Oracle 19c & 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, Golden Gate, Recovery Manager, and Oracle Enterprise Manager.
- Setup & Monitor DB servers proactively to ensure optimized usage of resources using various monitoring tools like Shell scripts, Oracle jobs, OEM etc.
- 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.
- Strong shell scripting knowledge is required
- 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 IIS administration.
- 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 & Exadata environment.
- Aptitude for debugging problems in complex, unfamiliar code
- Have worked closely with applications implementing full life cycle
- Experience with tools such as TOAD, SQL Developer
- Strong written and oral communication skills are essential
- Solid work ethic, self-driven, can function independently with minimal oversight and direction
- Have worked in development tools Jira, Git and Confluence
- Worked in Agile/Scrum team environment
- Development work in SQL Server environment
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.