Oracle Developer - Hybrid in Pittsburgh, PA

 

We currently have a career opportunity for an Oracle Database Developer to join our team located in Pittsburgh, PA.

 

Job Overview:

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

 

Perficient is always looking for the best and brightest talent and we need you! We’re a quickly-growing, global digital consulting leader, and we’re transforming the world’s largest enterprises and biggest brands. You’ll work with the latest technologies, expand your skills, and become a part of our global community of talented, diverse, and knowledgeable colleagues.

 

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

• 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

The salary range for this position takes into consideration a variety of factors, including but not limited to skill sets, level of experience, applicable office location, training, licensure and certifications, and other business and organizational needs. The new hire salary range displays the minimum and maximum salary targets for this position across all US locations, and the range has not been adjusted for any specific state differentials. It is not typical for a candidate to be hired at or near the top of the range for their role, and compensation decisions are dependent on the unique facts and circumstances regarding each candidate. A reasonable estimate of the current salary range for this position is $ 64,974   to $149,880. Please note that the salary range posted reflects the base salary only and does not include benefits or any potential equity or variable bonus programs. Information regarding the benefits available for this position are in our benefits overview.

 

WHO WE ARE

Perficient is a leading global digital consultancy. We imagine, create, engineer, and run digital transformation solutions that help our clients exceed customers’ expectations, outpace competition, and grow their business. With unparalleled strategy, creative, and technology capabilities, our colleagues bring big thinking and innovative ideas, along with a prac