SQL Developer (Lead) with skills SQL Development, Oracle PL/SQL Development, postgreSQL Development, Linux Server, AWS-Apps, AWS-Infra for location Any Infogain Base Location (Noida, Gurugram, Bangalore, Mumbai, Pune)
ROLES & RESPONSIBILITIES
Job Description:-Should have Experience- 7-11 years
Must have Solution/architectural Design and Development experienceReady to work as an individual contributor/developer
Must have knowledge and Strong hands on in PL/SQLo Developmento Debuggingo Performance Tuning and Optimization
Must have indepth knowledge of Oracle/PL SQL Packages, Functions, triggers, Collections, Bulk Data loading methods, Data Migration, Materialized Views and Partitioning.
Strong Development experience with Packages, Functions, triggers, Collections, Bulk Data loading methods, Data Migration, Materialized Views and Partitioning.
Must know advance features of 11g/12c Oracle DB Databaseo Oracle RDBMS architecture.
Oracle supplied packageso Data Modeling/Designo Database security models Tools
Having knowlege on MSSQL/PostGres will be a plus
Must have worked ono Oracle OnPrem to AWS migrationso AWS Lambdao AWS RDS
Must have experience with creating and supporting large batch jobs
Must have experience in shell scripting korn/bash and python on Linux
Ability to pick up business concepts very quickly
Must have Query Optimization and Memory Management Experience
Must have worked as individual contributor
Must have handedled big enterprise grade large databases single handedly
Must have Good communication skills.
Must be ready to work in the India Night Shift or Near shore location.
EXPERIENCE
- 8-11 Years
SKILLS
- Primary Skill: SQL Development
- Sub Skill(s): SQL Development
- Additional Skill(s): Oracle PL/SQL Development, postgreSQL Development, Linux Server, AWS-Apps, AWS-Infra
ABOUT THE COMPANY
Infogain 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ów, Noida, Gurgaon, Mumbai, Pune, and Bengaluru.