Oracle Developer

Oracle Developer
Pittsburgh, PA
12 Months

Job Overview:
The Database Developer will play a crucial role in developing and implementing high-quality software solutions using Oracle technology.

Responsibilities

• Design, develop, and maintain Oracle databases, applications, and systems.
• Write and optimize SQL and PL/SQL code, including functions, procedures, and packages.
• Conduct code reviews and analyze and test code for database performance.
• Provide support and maintenance for in-house applications using Oracle SQL, PL/SQL, and Oracle Forms.
• Collaborate with teams of developers, project managers, and business analysts to create and deploy software solutions.
• Troubleshoot application-related issues and ensure optimal software performance.
• Monitor and optimize database performance to ensure applications run efficiently.

Qualifications

• 8+ years of experience in architecture, design, analysis, development, testing, deployment, and maintenance of highly scalable relational database services and components
• In-Depth knowledge of database concepts with hands-on experience in database programming and design using SQL, PL/SQL, Stored Procedures, Functions, Triggers, and Views, etc. using Oracle 12c or better (5-7 years)
• Full life-cycle development experience working in data centric applications
• Solid understanding of Dimensional Data Modeling
• Proficient in creating and tuning complex SQL, DB performance tuning involving AWR report, partition, etc
• Experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, etc
• Experience in Change Data Capture (CDC), for example Oracle GoldenGate, is strongly preferred
• Experience with information security and access control protocols
• Knowledge of ETL, experience in related programming, Java, Python, etc
• Unix/Linux and Scripting, Bash, Python, etc
• Experience using version control and DevOps tools such as Git, Jenkins, Liquibase for DB change management etc.
• Strong problem resolution skills and Critical thinking
• Excellent analytical skills, written and verbal communication skills
• Master's or Bachelor's degree in Computer Science, with strong fundamentals and problem solving skills