Senior Oracle DBA
Remote (EST / CST candidates need to apply)
Federal Client
Citizen / Green Card / H4 EAD (Only)
over all 12+ years of experience candidates need to apply & 3 years in the USA.
JD
Responsibilities:
Perform modifications to and maintenance of operational programs and procedures.
Analyze business processes and procedures to recommend technical system/software solutions.
Prepare documentation of program development, modifications to code as needed.
Apply best practice for tuning SQL and PL/SQL for overall system performance.
Support 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.
Provide support for software releases.
Research interfaces to identify and code required updates to support integration.
Provide all activities related to the administration of Oracle databases.
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.
Design, implement, code, test and maintain Oracle PL/SQL including packages, procedures, triggers and functions in compliance with company standards and best practices.
Qualifications:
Required:
Typically requires a bachelor's degree in Engineering, math, and/or science degrees and 8+ years of relevant experience.
Strong shell scripting knowledge.
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.
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.
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 environment.
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:
Highly prefer candidates in the DC Metro area
Experience with development tools such as Jira, Git and Confluence
Having worked in Agile/Scrum team environment
Development work in SQL Server environment
Having worked at FAA in the past (not Mandatory )
Please send your resumes to:
vikas.k@eagleiitech.com
...Only Natural Pet - Assistant Store Leader Only Natural Pet is a leading supplier in the natural pet supplies marketplace. Founded in 2004 in Boulder, Colorado, as an e-commerce business we now make 200 of our own highly popular Only Natural Pet branded products, including...
...Your Job Georgia-Pacific, LLC is seeking an entry-level Process Safety Engineer to join our team at the Toledo, OR containerboard mill. The selected... ...and risk assessment tools Develop expertise with the Chemical Reactivity Hazard Management electronic tool Lead by...
...buyers requirements quickly and guides him or her through the cars on the lot with optimal efficiency. This role must learn and have... ...The work is normally conducted in a showroom of a company or a dealership. REQUIREMENTS AND QUALIFICATIONS: * 2 years of sales...
...CRD Careers is a boutique recruitment agency specializing in Sales and HR placements. We connect growth-minded companies with high... ...45,000$55,000 base + monthly bonuses + commission ~ Medical, dental, vision, PTO, 401(k)~ Paid training, employee referral bonus...
...This position acts as a liaison between the Business Practices Office and Houston Methodist entities system-wide. Requirements:... ...Information Administrator (AHIMA) OR CPMA - Certified Professional Medical Auditor (AAPC) KNOWLEDGE, SKILLS, AND ABILITIES ~...