Developer

DataBase Administrator

Must Have Technical/Functional Skills

• 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.

Roles & Responsibilities

• 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.

• Change Control Management using Source Control System

• 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- $100,000-$120,000 a year

#LI-CO1 #LI-SN1