Search This Blog

September 26, 2019

Hiring-Oracle PL/SQL lead developer-Inperson interview-NYC

Greetings, 

Hope you are doing great !! 

ASK Inc. is looking for a PL/SQL  lead developer” with our client based in New york .Please let me know if you are interested in this position. 

 

Role: Oracle PL/SQL  lead developer

Work location: New York City

Interview: Face to Face

Experience: 10 years

                                                                             

  • Must have 10+ years hands on RDBMS design and or architecture                                                                                                                                            
  • Strong experience writing stored procedures, functions, triggers, and adhoc queries using PL/SQL                                                                                                                                      
  • Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems;                                                                                                                                 
  • Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.                                      
  • Ability to present the pros and cons of various design and SQL coding techniques                                                                                                                                       
  • Understanding of star-schema data warehousing concepts and implementations                                                                        
  • Ability to interact with both Business and Technology colleagues                                                                                                                    
  • Good knowledge in optimization techniques of application and handling big amount of data                                                                                                                                
  • Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems;                                                                                                                                
  • Coordinates new data development ensuring consistency and integration with existing data warehouse structure
  • Good experience of large-scale data migration projects with multiple data sources and familiar with Extract-Transform-Load patterns and processes
  • Experience writing stored procedures, functions, triggers, and adhoc queries using SQL
  • Experience with performance tuning of complicated queries and procedures                              
  • Familiarity with Oracle execution plans and statistics                                                
  • Experience with Oracle SQL Developer client                                                                                                                                               
  • Should have experience with source code and version control using Git or SVN.
  • Must have worked on Financial applications using RDBMS design and or architecture

 

Thanks & Regards,

Rajnish Bharti

Sr. Technical Recruiter

ASK Staffing, Inc.

Direct: +1-678-345-1886