Developer jobs in India

KEY RESPONSIBILITIES:
*
Database Design & Management:
o
Collaborate with the product development team to design, implement, and maintain scalable database schemas that meet business and application requirements.
o
Develop and maintain data models, ensuring consistency and optimal performance.
o
Design tables, indexes, and constraints for high data integrity and performance.
*
Performance Tuning & Optimization:
o
Analyse slow-running or poor performing queries and optimize performance through proper indexing, query restructuring, or caching mechanisms.
o
Conduct performance tuning, including tuning the PostgreSQL parameters for optimal database performance.
o
Work on improving database performance, scaling database operations, and addressing bottlenecks.
*
Cloud Database Management (AWS Aurora PostgreSQL):
o
Manage and administer AWS Aurora PostgreSQL clusters, ensuring high availability, backup, recovery, and disaster recovery planning.
o
Optimize the use of cloud-based resources in AWS Aurora to ensure cost-effective and efficient use.
o
Monitor and maintain database systems in cloud environments, ensuring data security and availability.
*
Security & Compliance:
o
Ensure that the database architecture complies with organizational security policies and best practices.
o
Implement database encryption, user management, and access controls.
o
Monitor database security and address any vulnerabilities or compliance concerns.
*
Automation & Maintenance:
o
Automate routine database tasks such as backups, failovers, maintenance windows, etc.
o
Develop and maintain database monitoring and alerting mechanisms to ensure system stability.
*
Documentation & Training:
o
Create and maintain detailed documentation for database designs, performance optimizations, and cloud database configurations.
o
Provide technical guidance and training to developers on best practices for schema design, query development, and database management.
WHAT WE ARE LOOKING FOR
*
Experience:
o
Over 7 to 11 years of technology experience working in a multi-national company.
o
5+ years of experience in PostgreSQL database administration, with a strong focus on query optimization, schema design, and performance tuning.
o
Proven experience managing PostgreSQL on AWS Aurora.
*
Technical Skills:
o
Strong expertise in PostgreSQL database design, including normalization, indexing, partitioning, and data modeling.
o
In-depth knowledge of SQL, PL/pgSQL, and advanced PostgreSQL features like triggers, stored procedures, and replication.
o
Familiarity with AWS services (Aurora, RDS, EC2, S3, etc.) and cloud database management practices.
o
Experience with query tuning tools such as pg_stat_statements and EXPLAIN for query analysis.
o
Experience with database backup, recovery, replication, and failover strategies.
*
Performance Tuning:
o
Expertise in tuning PostgreSQL databases for high performance, including memory usage optimization, connection pooling, and query optimization.
o
Proficiency in analyzing and resolving database performance issues, especially in high-traffic and high-volume production environments.
*
Soft Skills:
o
Excellent problem-solving skills and the ability to work closely with developers, DevOps, and architects.
o
Strong communication skills to convey technical solutions to both technical and non-technical stakeholders.
*
Education:
o
Engineering degree in computer science, Information Technology, or related field.
*
Nice to Have:
o
Experience with containerized databases using Docker or Kubernetes.
o
Familiarity with event-driven architectures using Kafka.
o
Experience with CI/CD pipelines and Flyway Script.

Qualifications
*
Bachelor's or master's degree in computer science, or a comparable field.
*
More than 4 years of experience working in the field of DevOps engineering.
*
Interest in developing and automating CI/CD and data pipelines for Big Data and analytical / AI solutions.
o
Three to five years of experience with DevOps tools and methods (e.g. GitLab, Container services as AWS ECR, CICD)
o
Cloud development skills in AWS services as Lambda, S3, DynamoDB, ECR and Stepfunctions including experience with infrastructure as code with Terraform (at least two years of experience)
*
Experience in working with other cloud services (Azure/Google) advantageous.
o
Programming skills in Python and knowledge about pipeline configuration in scripting languages like bash required (at least one year).
*
Experience with data engineering tools and patterns incl. solid knowledge of SQL.
o
Knowledge about deployment of frontend applications and development skills with JavaScript libraries or frameworks like React beneficial.
*
Analytical skills, team spirit, holistic thinking, and independent work (especially self-learning) required.
*
Customer-orientation and quality-consciousness
*
Good English skills required due to standard communication language in the team.
Job Description:
*
Work in a highly innovative development team dedicated to implementing a new generation of Big-Data Cloud and AI applications supporting the innovation and the digitalization of the company.
*
Evaluate and implement modern techniques and services to support the Big Data, AI, and business automation journey of the Festo companies worldwide.
*
Design, implementation and operation of CICD pipelines based on the requirements of an international team of cross functional developers.
*
Consultant the team and enable the deployment of backend and frontend applications and support their application lifecycle management.
*
Development and operation of data pipelines and platform services including the integration and automation under the strict consideration of data security and governance aspects.