Job – Senior Oracle at NeevSys Inc

Job description

• Home • Career • Job – Senior Oracle DBA Department : Engineering Experience: 8+ Years Location: Rockville, Maryland US- Email:talent@neevsys.com Job Description Neevsys is currently seeking a Senior Oracle DBA with good software development and team management skills to join our great team at Rockville, MD. If you want to learn, grow, and help, then this is the job for you. What you do matters and has a significant impact on the medical and scientific communities we serve. Your work here matters and has real impact. This Lead will develop and leads custom software applications efforts for the client user community consisting of approximately 4,500 intramural employees, contractors, and collaborators. However, applications are increasingly being developed for access by the public, and so the scope and visibility of any developed application may be unlimited. Custom applications have been developed in the following functional areas: Scientific Reporting Services and System Support; Grants Management Systems; Contracts Managements Systems; Human Resources Management Systems; Administrative Management Systems; and Other Management Systems. The ideal candidate should have strong software architecture & development experience and be very comfortable in learning an existing product and adjusting product architecture as customer requirements or technology evolves. Key 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

Requirements

Must-haves

Job – Senior Oracle DBA
Department : Engineering
Experience: 8+ Years
Location: Rockville, Maryland US-
Email:talent@neevsys.com
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.
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.

Nice-to-haves

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

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqljiraagilescrum

Platform: careers-html
Effort: medium