Immediate Hire- PL/SQL Lead

Hi,

Greetings from Diamond Pick,

Hope you are doing great!!!!!

Please find the below immediate hiring Position, if this is of your interest kindly send me resume with contact details

 

Position: PL/SQL Lead

Location: Atlanta, GA

Duration: Contract

 

Responsibilities:

• Create / Modify and optimize database schemas, stored procedures and SQL queries.
• Analyzing, troubleshooting, and resolving data issues.
• Write Complex Stored Procedures
• Understanding of 3rd party software APIs in order to integrate them with your solutions.
• Working closely with business stakeholders and assist with data analysis with regard to SQL.
• Preparing the mapping documents for the existing stored procedures.
• Should be able to perform SQL profiling
• Analyze the performance issues of existing stored procedure and fine tune performance of the system
• Identifies and proposes database system improvements and changes.
• Builds and executes data queries for business partners.
• Implements systems changes, upgrades, and modifications according to business needs.
• Maintain active relationships with stakeholders to understand business requirements, lead requirement gathering meetings and review designs with the stake holders 
• Perform technical design reviews and code reviews

·      Perform peer reviews on source code to ensure reuse, scalability and the use of best practices

·      Participate in collaborative technical discussions that focus on design, architecture, and development

·      Identify opportunities that can improve efficiency of business processes

·      Troubleshoot software application and technical issues - identify modifications needed in existing applications to meet changing user requirements

·      Prior experience on executing offshore model project

 

Requirements:

• 6 to 9 years of experience working with PL/SQL Server, Oracle and ETL
• 5+ years of strong hands on background as a PL/SQL developer
• Excellent knowledge on writing complex SQL stored procedures in an application development environment.
• Design database tables, views, indexes, functions and develop the various reports using SQL and Stored Procedures.
• Work with other front-end developers in completing the database modules end to end (experience in parsing of JSON in Stored Procedures would be an added advantage).
• Query optimization for performance improvement.
• Should be proficient in creating database triggers
• Should maintain data quality and oversee database security
• Must be excellent in writing complex SQL queries
• Working experience in .Net technologies is an added advantage.

 

Thanks & Regards

Preethi MS| IT Recruiter

Email:preethi.ms@diamondpick.com

Phone:917-628-2087

 

 

This e-mail message, including any attachments, is for the sole use of the person to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message along with any attachments.