Oracle Database Administrator

Job Responsibilities and Qualifications 5+ years of Oracle PL/SQL development experience in web application development. Expertise in logical and physical data models, maintenance of DDLs. Expertise in Oracle objects, PL/SQL code, and abilities to write complex SQLs. Must collaborate with server side/UI developers, and DBAs to develop end‑to‑end solution. Familiarity with AWS cloud, prepare to migrate applications, services, and data to AWS. Familiarity with ETLs, data migrations. Database Design Skill including normalization theory, STAR Schema Design and Data Modeling tool with proven experience of Process, Data flow and forward/reverse engineering of logical/physical RDBMS layout. Experience with building Database warehouse Solution. Extensive experience with Database compression and purging techniques. Experience with MSSQL, mongoDB and postgres will be an added advantage. Working knowledge of Linux Redhat, File System, Cluster Management(RAC) and Oracle ASM & ACFS. Work in an agile environment following through the best practices of agile Scrum. Analyze the requirements, seek clarifications, contribute to good acceptance criteria, estimate, and be committed. Take pride in designing solutions, developing the code free from defects and vulnerabilities, meeting functional and non‑functional requirements by following modern engineering practices, reducing rework, continuously addressing technical debt. Contribute to overall team performance by helping others, peer reviewing the code diligently. Bring agility to application development through DevOps practices - automated builds, unit/functional tests, static/dynamic scans, regression tests etc. Lookout for providing best possible customer support by troubleshooting, resolving production incidents and by eliminating the problems from the root level. Bring innovative solutions to reduce the operational risks by automating mundane repetitive tasks across SDLC. Learn to become full stack developer to address end‑to‑end delivery of user stories. Make changes to the existing Data Model (Logical & Physical), Implement Changes, build deployment packages using CI/CD pipelines such as LightSpeed and promote them to higher environments (UAT, Production and Cob) following SDLC using Release on Demand. Help in finding current performance bottlenecks and provide solutions to improve performance. Review AWR, ADDM, ASH and other performance reports and provide performance enhancement solutions. Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards. Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint. Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation. Salary Range: $95,000 to $120,000 per year #J-18808-Ljbffr