SQL Developer (Senior) with skills SQL Development, SQL Development, MongoDB SQL Development, Oracle PL/SQL Development, postgreSQL Development, UX Design for location Any Infogain Base Location (Noida, Gurugram, Bangalore, Mumbai, Pune)
ROLES & RESPONSIBILITIES
Experience
- 10-12 years of experience in database administration and SQL/PL development
- Strong experience with PostgreSQL database administration
- Experience working in cloud-based database environments (AWS preferred)
Core Responsibilities
- Manage and administer PostgreSQL databases in development, testing, and production environments
- Design and develop SQL queries, stored procedures, functions, and database scripts
- Support application teams in database design, performance tuning, and query optimization
- Ensure database availability, reliability, backup, and recovery
- Monitor database performance and resolve performance bottlenecks
- Implement database security, access control, and data protection policies
- Work closely with development teams to support data pipelines and application integrations
Technical Skills
- Strong expertise in PostgreSQL administration
- Experience writing advanced SQL queries, stored procedures, triggers, and functions
- Experience in database performance tuning, indexing, and query optimization
- Knowledge of data modeling and database schema design
- Experience with database migration, upgrade, and patch management
- Experience handling large datasets and high transaction workloads
Cloud & DevOps Exposure
- Experience working with AWS database services (RDS PostgreSQL / Aurora PostgreSQL preferred)
- Exposure to cloud infrastructure, monitoring, and database scaling
- Experience with Docker/Kubernetes based deployments
- Familiarity with CI/CD pipelines and database deployment automation
- Experience with monitoring tools such as CloudWatch, Prometheus, or Grafana
Operational Responsibilities
- Manage database backup, restore, and disaster recovery strategies
- Monitor database health and ensure high availability and replication
- Troubleshoot database incidents and production issues
- Support data migration and environment setup
- Maintain database documentation and operational procedures
EXPERIENCE
- 8-11 Years
SKILLS
- Primary Skill: SQL Development
- Sub Skill(s): SQL Development
- Additional Skill(s): SQL Development, MongoDB SQL Development, Oracle PL/SQL Development, postgreSQL Development, UX Design
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.