Lead Database Administrator- PostgreSQL

Job description

• Database Design & Development:
• Design, implement, and maintain PostgreSQL databases.
• Develop efficient schemas, indexes, and stored procedures to optimize data performance.
• Backend Development:
• Develop RESTful APIs and backend services using Node.js.
• Integrate databases with backend applications for seamless data flow.
• Query Optimization & Performance Tuning:
• Optimize SQL queries for performance and scalability.
• Monitor database health and troubleshoot slow queries or deadlocks.
• Security & Compliance:
• Implement database security best practices, including role-based access control (RBAC) and encryption.
• Ensure compliance with industry standards like GDPR, HIPAA, etc.
• Data Migration & Backup:
• Develop and maintain data migration scripts between different PostgreSQL versions or other databases like mongodb.
• Set up and manage database backup and recovery strategies.
• Write efficient SQL queries and manage database schemas using PostgreSQL.
• Build RESTful APIs and integrate third-party APIs/services.
• Optimize application performance and troubleshoot production issues.
• Ensure data security and protection practices are followed.
• Write clean, maintainable code and participate in code reviews.

Experience in developing applications using .Net Core Ver. 6/7, ASP.Net MVC (C#), .Net Core Web API & Web App, Web Services, OOPS, SOLID principles.

Experience in software development and system architecture with Microsoft technologies.

Able to integrate the database objects with the Microservices.

Expert working knowledge of Multi-threading.

Solid experience in converting .NET Framework multi-threaded services into .NET Core.

Worked as part of a cross-functional team on code reviews, internal infrastructure, and process enhancement.

Understanding of CI/CD pipeline is mandatory.

Strong hands-on experience with C# and solid principles.

Expertise in entity framework core with code first approach.

Expertise in writing RESTful services.

Knowledge of RDBMS concepts.

About Thrillophilia :

At Thrillophilia, we are building multiple digital travel brands leveraging our proficiency in ecommerce, technology, distribution and marketing. We love to start from “Zeroes”. We plan, build and scale travel marvels from scratch and are absolutely obsessed about creating the best travel experiences for our customers. Our goal is to create 100+ sizable travel brands across the globe by 2027.

Thrillophilia is one of the key brands under 53 Takeoffs umbrella. Today, 100 Million+ travelers use our brands to discover and book diverse travel experiences. With multiple tourism and start-up awards as well as global recognition under our belt, we have scaled ten-fold over the past three years. You might know us from early Thrillophilia’s days. The journey of Thrillophilia is rooted in a passion for travel, technology, and people. It began back in 2011 when the global market was still too young for online travel. Ever since we have grown to become India’s largest online platform for booking affordable travel experiences across 55+ countries. Our offerings are diverse and wholesome, with 24,000+ products and services ranging from tours and activities to luxury and culture stays, powered by exclusive deals and extra effort to bring joy to all our travelers.

Awards we won at Thrillophilia -

• YourStory’s best places to work!
• ISB’s BizQuest.
• Singapore Bash’s best startup.
• London Mayor’s IE20.

About our people - Ah, let's talk a bit about the folks over at Thrillophilia, where hard work and ownership run rampant, and problem-solving is the name of the game. The team here doesn't just punch the clock and head home. They're in it to win it, do the best work of their life by taking ownership of their work and striving for excellence in everything they do.

Whether it's finding the best hidden gem in the world or developing tech solutions, there is a deep ownership and accountability and Remarkable is one word to summarize their work!

They're a fun-loving bunch, they party really hard and share a passion for travel, and they're not afraid to let loose and enjoy the journey. From backpacking through Southeast Asia to exploring the hidden corners of their own cities, these adventure seekers somehow always manage to take out time to party and travel the world.

So, if you're looking for some inspiration, just take a look at the people of Thrillophilia. They're living proof that with hard work, ownership, and a vision to solve problems at scale, anything is possible.

We are seeking a highly skilled and passionate Senior Software Developer with expertise in Ruby on Rails and React.js to join our dynamic and innovative tech team. As a Senior Software Developer, you will play a crucial role in designing, developing, and implementing high-quality software solutions that drive the success of our travel platform. You will work closely with cross-functional teams, including product development, UI/UX design, and quality assurance, to ensure seamless integration of features and deliver exceptional user experiences.

Responsibilities:

- Develop and maintain robust, scalable, and efficient web applications using Ruby on Rails and React.js.

- Collaborate with product managers, UI/UX designers, and fellow developers to understand requirements, translate them into technical solutions, and deliver high-quality software products.

- Write clean, maintainable, and well-documented code following industry best practices and coding standards.

- Conduct thorough code reviews, provide constructive feedback, and mentor junior developers to enhance team productivity and code quality.

- Optimize application performance and ensure efficient resource utilization by conducting performance testing, monitoring, and troubleshooting.

- Stay updated with the latest industry trends, tools, and technologies related to Ruby on Rails and React.js, and share knowledge with the team.

- Collaborate with the DevOps team to deploy and maintain applications in cloud-based environments.

- Contribute to the continuous improvement of development processes, tools, and methodologies.

Requirements:

- Bachelor's degree in Computer Science, Software Engineering, or a related field (or equivalent practical experience).

- Proven experience as a Senior Software Developer / Module Lead, preferably with a focus on Ruby on Rails and React.js. (At least 4+ years of experience)

- Strong expertise in Ruby on Rails and React.js, with a solid understanding of their core principles, frameworks, and ecosystem.

- Proficient in front-end development technologies such as HTML, CSS, and JavaScript.

- Experience with database systems, including SQL and NoSQL databases especially PostgresSQL.

- Familiarity with version control systems, such as Git.

- Ability to write efficient, maintainable, and testable code, with a strong emphasis on software quality and best practices.

- Strong problem-solving and analytical skills, with the ability to tackle complex technical challenges and provide innovative solutions.

- Excellent communication and collaboration skills, with the ability to work effectively in a team-oriented environment.

- Self-motivated and detail-oriented, with a passion for continuous learning and staying updated with emerging technologies.

If you are passionate about building revolutionary travel products, thrive in a collaborative and innovative environment, and are ready to take on exciting challenges, we would love to hear from you.

Apply now and embark on a transformative journey to redefine the future of travel!

As a Node.js Developer, you will be responsible for:

Designing, developing, and maintaining server-side applications and systems using Node.js, a JavaScript runtime environment. Your expertise in backend development, JavaScript, TypeScript, and REST APIs will play an essential role in creating efficient and powerful server-side applications.

Responsibilities:

● Design and implement efficient, secure, and maintainable server-side code using Node.js.

● Collaborate with the front-end development team to integrate user-facing elements with server-side logic.

● Develop APIs for seamless data flow between the front-end and back-end.

● Optimize application performance and ensure high availability and scalability.

To succeed in this role – you should have the following:

● Minimum of 3-4 years of experience as a backend developer.

● Must have proven experience as a Back-End Developer, with a focus on Node.js.

● Proficiency in JavaScript, TypeScript, and related frameworks (Express.js, Hapi.js, etc.).

● Experience with RESTful API design principles.

● Experience with agile development methodologies.

● Familiarity with working with at least one of PostgreSQL or MongoDB.

● Familiarity with version control systems (Git)

● Strong communication skills and ability to work collaboratively in a team.

● Strong problem-solving skills and attention to detail.

Added bonus:

● Familiarity with frontend development technologies like HTML and CSS.

● Experience working with Docker, Github Actions, and other common CI/CD pipelines

● Knowledge about AWS components (S3, EC2, Cloudfront, Redis Clusters, etc.)

Education:

Bachelor's degree in Computer Science, Information Technology, or a related field

Golang Developer

Experience: Minimum 4 years

Job Location: Delhi/Pune/Bangalore-Hybrid

Job Description

• Must: Minimum 2.+ years of experience in Golang programming language, paradigms, constructs, and idioms.
• Knowledge of common Goroutine and channel patterns.
• Experience with the full site of Go frameworks and tools.
• Preferred: Minimum 2+ years of experience in aws.
• Must: Cloud environment (e.g. AWS, VMware, etc.).
• Must: Working Knowledge in Mysql.
• Popular Go web frameworks.
• Familiarity with code versioning tools such as Github / Gitlab.

Key Skills

• Golang, , Javascript, MySQL, Postgresql.
• Responsibilities : The job requries Golang experience with MySQL database.
• Ability to work on a small on minimal supervision Troubleshoot, test and maintain the core product software and databases to ensure strong optimization and functionality.

Job Summary: We are looking for a skilled SQL Developer to join our team. The ideal candidate will have a strong understanding of database management systems, experience in writing complex SQL queries, and a solid understanding of data structures and algorithms. The SQL Developer will be responsible for designing, developing, and maintaining SQL databases, ensuring their performance, availability, and security.

Key Responsibilities:

• Design, develop, and optimize SQL databases, tables, views, stored procedures, and triggers.
• Develop efficient and complex SQL queries for data extraction, transformation, and loading (ETL).
• Create and maintain database schema designs, data models, and ER diagrams.
• Analyze and optimize complex SQL queries for better performance.
• Implement indexing strategies, query optimization techniques, and other performance tuning practices.
• Ensure data integrity and security by designing and implementing database constraints, data validation rules, and security policies.
• Work with software developers, data analysts, and system administrators to integrate SQL databases with other applications and systems.
• Collaborate with business stakeholders to understand data requirements and provide solutions.
• Document database designs, stored procedures, and other database-related activities.
• Maintain accurate records of database changes, optimizations, and configurations.

Eligibility Criteria:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 3 to 5 years of experience as an SQL Developer or in a similar role.
• Proven experience in database design, development, and management.
• Experience with SQL Server, MySQL, PostgreSQL, or other relational database management systems.
• Proficiency in writing complex SQL queries, stored procedures, functions, and triggers.
• Strong understanding of indexing, query optimization, and performance tuning.
• Familiarity with database security best practices.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Attention to detail and commitment to quality.
• Ability to work independently and in a team environment.
• Experience with cloud-based databases (e.g., AWS RDS, Azure SQL Database).
• Experience with NoSQL databases.

What We Offer:

·        Competitive salary and performance based incentives.

·        Comprehensive benefits package, including health

·        Opportunities for professional growth and career advancement.

·        A collaborative and innovative work environment.

• Previous working experience as a MySQL Developer for at least 3 years
• Identify opportunities for improved performance in SQL operations and implementations
• Oversee the operations of the production and staging environments databases
• Give design recommendations for database functions that meet business operating standards while improving the efficiency of business processes
• Train and mentor junior personnel on best practices

Candidate Profile:

• Bachelor’s/Master’s degree in Engineering, Computer Science
• At least 5+ years of relevant experience as a database programmer
• Excellent MySQL/PostgreSQL/MS-SQL development skills
• Experience in writing stored views, procedures, triggers etc.
• Excellent knowledge in RDBMS (important features)
• Strong problem-solving skills, technical troubleshooting, and diagnosing
• Solid knowledge of RDBMS and NoSQL technologies
• Experience in developing back-ends for enterprise systems
• Knowledge of debugging, performance and optimization techniques
• Experience in RDBMS technologies like MySQL, PostgreSQL etc.
• Experience in No SQL technologies like MongoDB, Cassandra etc.
• Knowledge of Caching DB like Redis, Memcached etc.
• Knowledge of Search DB like Solr, Elasticsearch etc.
• Demonstrated ability to deliver in a fast-paced environment.

• Work with business analysts to estimate and design effective, scalable and maintainable solutions that meet business initiatives and objectives
• Develop and unit test software that meets business requirements and technical design
• Troubleshoot pre- and post-production implementations
• Propose new ideas when there is strong business value and stay up to date on the latest technology trends and techniques

Critical Skills & Experiences:

• At least 5+ years of experience developing in Java technologies with equivalent experience in systems analysis, OO design, OO programming and debugging skills
• At least 5 years of experience in Java Spring Boot Framework development
• 2 years of experience in any Cloud platform, preferably AWS.
• At least 3 years of web services and relational database experience (preferably Mysql)
• At least a year of Elastic search experience
• Experience developing RESTful web services (preferably micro services)
• Experience with UNIX/Linux command line and shell scripting
• Experience working in cross-functional Agile/Scrum teams
• Any level of experience with JIRA or any other issue tracking technology
• Experience working directly with business stakeholders
• Experience with Java application profiling and profiling tools
• Exceptional written and verbal communication skills.
• Drive performance to accomplish team goals in a fast-paced environment
• Bachelor’s degree or the above equivalent skills and years of experience

Keywords:

Experience: +5 Years

Technical skills: Java, Spring boot and Node JS  

Exceleron Software is looking for a Perl developer to join our development team.

**This is a fully remote position, even after COVID!**

Exceleron Software provides an integrated energy utility customer engagement suite consisting of Online and Cash Payments, Customer Alerts, Prepay Billing, Online Bill Presentment, Usage Monitoring, and a Mobile App (for both iOS and Android) in both the United States and India.

We have passionate, fun-loving, and exciting people at Exceleron in India and the US. We are looking for people who can have fun at work. We are looking for people with strong communication skills (you should be able to talk about Technology with ease) and be someone who works well as part of a team and enjoys sharing ideas and debating technical options.

You will be expected to provide input in the design of systems and can even provide an opinion on front-end design issues.

Core modules used in our systems: Catalyst, DBIx::Class, Template::Toolkit, Plack, Test::More, Moose, PDF::API2 along with many others. Should have experience in writing tests and doing code reviews and participating in test-driven development. You are also likely to have several CPAN modules, and follow the latest technical developments

Desired Candidate Profile

1) 3-8 years experience in Perl Development with a working knowledge of the following web

2) development stack: HTML/XHTML, CSS, JavaScript, Apache/Nginx Extensive experience with OO Perl

3) Proficient with building/managing relational databases

4) Any perl based web frameworks (Mojolicious, Catalyst, Dancer, CGI Application, or anything else)

*Preference will be given to Active contributors to Perl Mongers/ Programming/Hacking Discussions.