What are the responsibilities and job description for the Senior Oracle DBA position at Karsun Solutions?
Overview
NA
Responsibilities
- 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
Qualifications and Education
- 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
Compensation
The proposed salary range for this role is $****** to $******* USD. The salary range provided is a good faith estimate representative of all experience levels. Karsun considers several factors when extending an offer, including but not limited to, the role, function and associated responsibilities, a candidate’s work experience, location, education/training, and key skills.
