Job Description

Posted on: August 15, 2024ROLES & RESPONSIBILITIESSkill Requirement:Duties and Responsibilities of an SQL developer in the Project would be:a) Performs physical database administration (DBA) tasks in Oracle.b) Designs and builds simple to complex database structures from data models.c) Can handle tasks like, Installation and Maintenance, Data Extraction, Transformation, and Loading,d) Specialized Data Handling, Database Backup and Recovery, Performance Monitoring,e) Troubleshooting Must be an expert on all database object like Synonym, Views, trigger etcf) Provides automation to standard DBA tasks.g) Able to develop scripts on Windows platforms as necessary. Should be perform Installation, configures and patches Oracle.h) Participates in design reviews as required to ensure database design meets application requirements and guide the dev team.i) Designs, maintains, documents and executes database utilities to provide information regarding database activity.j) Proactively performs database monitoring and performance tuning tasks. Identify and provide solutions to performance issues in multiple database environments.k) Reviews and enforces adherence to the company\'s Architecture, as well as database design and usage standards.l) Should be willing to learn aviation domain if required in order to get application knowledge.m) Creating / Updating DB DDL Scripts Gaining knowledge of DB Entity Relationship Design stable, reliable and effective databasesn) Optimize and maintain legacy systems Modify databases according to requests and perform tests Solve database usage issues and malfunctions Liaise with developers to improve applications and establish best practices Gather user requirements and identify new featureso) Develop technical and training manuals Provide data management support to users Ensure all database programs meet company and performance requirementsBehavioral/Good to Have Skills:Understanding of Airline domain is an added advantageShould be able to demonstrate Good Communication and Interpersonal skills.Should be able to take initiatives and proactiveness in leaning new technologiesSkill Requirement:Duties and Responsibilities of an SQL developer in the Project would be:a) Performs physical database administration (DBA) tasks in Oracle.b) Designs and builds simple to complex database structures from data models.c) Can handle tasks like, Installation and Maintenance, Data Extraction, Transformation, and Loading,d) Specialized Data Handling, Database Backup and Recovery, Performance Monitoring,e) Troubleshooting Must be an expert on all database object like Synonym, Views, trigger etcf) Provides automation to standard DBA tasks.g) Able to develop scripts on Windows platforms as necessary. Should be perform Installation, configures and patches Oracle.h) Participates in design reviews as required to ensure database design meets application requirements and guide the dev team.i) Designs, maintains, documents and executes database utilities to provide information regarding database activity.j) Proactively performs database monitoring and performance tuning tasks. Identify and provide solutions to performance issues in multiple database environments.k) Reviews and enforces adherence to the company\'s Architecture, as well as database design and usage standards.l) Should be willing to learn aviation domain if required in order to get application knowledge.m) Creating / Updating DB DDL Scripts Gaining knowledge of DB Entity Relationship Design stable, reliable and effective databasesn) Optimize and maintain legacy systems Modify databases according to requests and perform tests Solve database usage issues and malfunctions Liaise with developers to improve applications and establish best practices Gather user requirements and identify new featureso) Develop technical and training manuals Provide data management support to users Ensure all database programs meet company and performance requirementsBehavioral/Good to Have Skills:Understanding of Airline domain is an added advantageShould be able to demonstrate Good Communication and Interpersonal skills.Should be able to take initiatives and proactiveness in leaning new technologiesEXPERIENCE

• 6-8 Years

SKILLS

• Primary Skill: SQL Development
• Sub Skill(s): SQL Development
• Additional Skill(s): SQL Development

ABOUT THE COMPANYInfogain is a human-centered digital platform and software engineering company based out of Silicon Valley. We engineer business outcomes for Fortune 500 companies and digital natives in the technology, healthcare, insurance, travel, telecom, and retail & CPG industries using technologies such as cloud, microservices, automation, IoT, and artificial intelligence. We accelerate experience-led transformation in the delivery of digital platforms. Infogain is also a Microsoft (NASDAQ: MSFT) Gold Partner and Azure Expert Managed Services Provider (MSP).Infogain, an Apax Funds portfolio company, has offices in California, Washington, Texas, the UK, the UAE, and Singapore, with delivery centers in Seattle, Houston, Austin, Krak\xc3\xb3w, Noida, Gurgaon, Mumbai, Pune, and Bengaluru.

Infogain