Senior Oracle DBA
Neevsys LLC - Rockville, MD
Apply NowJob Description
Over 10 years we helping companies reach their financial and branding goals. Onum is a values-driven SEO agency dedicated. 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. Your work here matters and has real impact. This Lead will develop and lead custom software applications efforts for the client user community consisting of approximately 4,500 intramural employees, contractors, and collaborators. Custom applications have been developed in the following functional areas: Scientific Reporting Services and System Support; Grants Management Systems; Contracts Management 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 practices for tuning SQL and PL/SQL for overall system performance. Support software development and test teams throughout the software development lifecycle, including incremental script execution and defect resolution. Review proposed database structure changes by development teams and approve or modify based on 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: 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. 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. Experience working in a Linux environment. 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. 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. #J-18808-Ljbffr
Created: 2025-01-14