Toggle navigation

  • PL Sql Devloper

Industry Insurance
Location Bangalore
Experience Range 8 - 10 Years
Qualification any
Not active

Functional Any Other
Job Description
About Us
“Quess IT Staffing is India’s largest IT staffing company with over 20 years of experience in staffing IT professionals in 300+ companies across levels and skillsets. Our 10,000+ associates deployed in 80+ cities and towns are proficient in over 500 technological skills. Our associates help enable cutting edge solutions some of the biggest names across industried. Quess IT Staffing is a division of Quess Corp Limited, India’s leading business services provider and largest domestic private sector employer. Quess Corp Limited is - ‘A Great Place to Work’ certified – a testament to our excellent culture, people, and processes.”
About Company
www.magna.in
Roles and Responsibility

Job Description:

  • Develop and provide support to all system interfaces and coordinate with all project managers to provide specifications for all core modules.
  • Coordinate with various developers, project managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications
  • Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers
  • Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database
  • Evaluate all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects for various application components
  • Design and implement various structures for all physical objects and recommend changes on applications through efficient statistical structures
  • Monitor and identify specific programming languages and recommend enhancement to all programs and evaluate all software resolution
  • Design and analyze all computer hardware, firmware and embedded systems and prepare and maintain various reports for metrics
  • Collaborate with various departments and perform research on all data processing functions.

 

Roles & Responsibilities:

  • Ability to work with the system analysts to translate business requirements to database structure as well as communicate the design to the front end development staff
  • Responsible for following project management and lifecycle development processes, procedures, and standards to meet extremely high quality assurance goals
  • Knowledge and development experience using Agile methodologies
    Demonstrated knowledge of terminology, usage, and operating characteristics of hardware, software, and operating system components within the client server environment
  • This requisition may be filled at a higher grade based on qualifications listed below

 

Basic Qualifications:

  • Seven years of SQL development experience including but not limited to the creation of packages, procedures, tables views, functions, etc.
  • Seven years of experience in Database Star Schema and or Snow flake schema in First, Second and Third normal form. Must have knowledge on how to build/maintain efficient database tables structure for both transactional and warehouse data
  • Six years of experience in PL/SQL tuning including knowledge of Explain Plans AWR, ASH and TKPROF
  • Knowledge of oracle partitioning practices and data archival structures and processes
  • Knowledge of Oracle 11g and 12c with use of tools such as SQL Developer, TOAD and ERWIN
  • Must have the ability to work with the system analysts to translate business requirements to database structure as well has communicate the design to the front end development staff
  • Experience in the Agile programming framework
  • The ability to work in a dynamic environment
  • The ability to adapt to sudden modification
  • The ability to work independently or with a team
  • Excellent communication skills (written and verbal)
  • Working knowledge of QC JIRA, Spira, or equivalent for defect tracking
  • Working knowledge of Unix and Shell scripting

 

 

A+| A| A-
Job By Location
Job By Function
Jobs By Industry
Jobs By Skills
Jobs by business vertical
Social Network