Database Developer
- Lion And Elephants
- 1 Positions
- Bengaluru
- 13 days ago
- Email to a friend
- Report this job
Job Description
We are seeking a highly skilled and experienced Database Developer with over 7 years of hands-on experience in developing and managing databases. The ideal candidate will have expertise in both OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) systems, and proficiency with modern database technologies such as PostgreSQL, ClickHouse, and MSSQL. Familiarity with graph databases and Python scripting is a strong plus.
Key Responsibilities:
Design, develop, and maintain OLTP and OLAP databases to ensure high performance and reliability.
Collaborate with application developers and system architects to integrate database solutions seamlessly.
Develop complex SQL queries, stored procedures, triggers, and functions tailored for both transactional and analytical systems.
Implement and optimize data models and database structures to support scalable and high-availability systems.
Monitor database performance, troubleshoot issues, and optimize queries for efficiency.
Develop and manage ETL (Extract, Transform, Load) processes to facilitate data movement and integration between systems.
Design and implement data pipelines for analytics and reporting purposes.
Utilize Debezium and Kafka for change data capture (CDC) and real-time data streaming as required.
Ensure data integrity, security, and availability in compliance with business and regulatory requirements.
Provide database support and troubleshooting assistance to cross-functional teams.
Required Skills and Experience:
Minimum of 7 years of hands-on experience with relational databases such as PostgreSQL and MSSQL, and columnar/analytical databases like ClickHouse or similar.
Proven experience in both OLTP and OLAP environments.
Strong background in database design and architecture, including normalization and denormalization techniques.
Proficient in writing complex SQL queries, stored procedures, and performance optimization.
Experience with Python for database scripting and automation tasks.
Understanding of database security practices, including access controls and encryption.
Knowledge of database replication and data streaming tools such as Debezium and Kafka.
Familiarity with database backup, recovery, and version control best practices.
Indeed
Nice-to-Have:
Experience with modern databases like Supabase.
Knowledge of cloud-based database management systems (e.g., AWS RDS, Azure SQL).
Familiarity with NoSQL databases such as MongoDB or Cassandra.
Employement Category:
Employement Type: Full timeIndustry: IT Services & Consulting
Role Category: DBA / Datawarehousing
Functional Area: Not Specified
Role/Responsibilies: Database Developer
Contact Details:
Company: Lion And ElephantsLocation(s): Bengaluru
Keyskills: postgresql data warehousing oltp olap etl
Similar positions
Lion And Elephants
At Humango, we are a dynamic and rapidly growing startup at the intersection of artificial intelligence and sports coaching. With a distributed development team spanning the USA, Europe, and India, we leverage cutting-edge technology to revolutionize coaching methodologies. Our work not only dr...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in