Senior Database Administrator - MongoDB

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.

Seeking passionate Software Engineers having 2+ years of experience in Ruby on Rails.

• Excellent verbal & written communication skills. And you enjoy collaborating with others
• 2+ year of experience with Ruby on Rails or other Ruby frameworks
• Sound knowledge of object-oriented programming concepts and design patterns
• Strong knowledge of relational database concepts, PostgreSQL, MySQL, etc.
• Working knowledge of Javascript, DOM, CSS, HTML
• Strong experience with Git versioning systems

• Experience with modern Javascript libraries, frameworks & its ecosystem will be a huge plus. Example: React.js / Ember.js / Angular.js / Vue.js etc.
• Experience with Micro-service Architecture, Service Oriented Architecture (SOA), GraphQL, and REST APIs will be a huge plus
• Working knowledge or understanding of the SaaS ecosystem will be a plus
• Contribution to open source projects, have participated in some technical community or meetups or interest group or have written or spoken in public about their technical ideas
• Inclination to develop your own gems or reusable components or libraries

• We're a remote-friendly and calm company
• We use the latest and powerful hardware for software development
• We are heavy on extreme programming and agile methodology. Our DNA is engineering practices like TDD, CI, CD, Code reviews, Pair programming, etc
• We love to collaborate and contribute to open source projects (check: https://www.github.com/kiprosh">Kiprosh Github)
• We encourage and help you to blog about your development experience with the rest of the world. (check: https://blog.kiprosh.com/">Kiprosh Engineering Blogs)
• Our dedicated CoE (Center of Excellence) group ensures that company-wide we all achieve excellence in the area of our interest, learn the latest and greatest, and keep sharing product & technology topics regularly across the organization
• Company-wide, we conduct monthly events to have fun together as a One Kiprosh team.
• We are big on rewards and recognition. We celebrate spotlight awards every quarter. We have yearly award ceremonies and celebrations. (check: https://www.linkedin.com/company/kiprosh">Kiprosh Linkedin Page)
• We have company-wide outings twice a year (but pause for a year since March 2020 due to Covid19 pandemic)
• We are a passionate group of humble, kind, and fun-loving individuals

Role Responsibilities:

• Development and Maintenance of REST APIs: Lead the creation and management of our RESTful APIs, ensuring top-notch performance and alignment with evolving requirements.
• Proficiency in Coding: We're in search of expertise in Python or equivalent programming languages. Your coding skills will play a pivotal role in delivering high-quality (efficient, reusable, testable, and scalable) solutions.
• Unit and Integration Testing: Apply your expertise to craft unit and integration tests, upholding code quality and reliability.
• Version Control Systems: Proficiency in Distributed Version Control Systems is vital for seamless collaboration during development.
• Elasticsearch Expertise: Having valuable experience with Elasticsearch is a plus, given its critical role in data retrieval and search functionalities.
• NOSQL Database Familiarity: Knowledge of NOSQL databases like Cassandra and MongoDB will be advantageous.
• Message Broker Knowledge: Understanding message brokers, especially RabbitMQ, is beneficial for effective communication within our systems.

Desired Qualifications:

• Experience: 1-2 years of hands-on experience as a Python developer.
• AWS: Proficiency in AWS cloud management and architecting enterprise data solutions.
• Pragmatic Problem-Solving: Recognize when a solution should be streamlined and when creating the right abstraction will lead to long-term efficiency gains.
• Passion for Quality: Demonstrate dedication to producing work of the highest quality and following best practices.
• Agile/Lean Process: Familiarity with Agile/Lean methodologies is a plus, reflecting your adaptability and collaborative spirit.
• Startup Mindset: Embrace the challenges and opportunities of a startup environment, contributing your skills and insights to our growth.
• Debugging and Optimization: Showcase excellent debugging and optimization capabilities to enhance system performance.
• Tech Awareness: Stay updated on emerging technologies and possess a solid understanding of the full product development life cycle.
• UX and Information Architecture: Exhibit excellent knowledge of mobile user experience, information architecture, and industry trends.

Build reusable APIs for our client-facing apps in Node.js

Create and maintain scalable infrastructure leveraging modern cloud platforms Write tests and documentation as you implement features with your team Maintain expertise in current and emerging technologies and tools

4+ years’ Experience with NodeJS

BS degree or higher in Computer Science or Engineering Experience documenting and testing RESTful APIs

Experience working with databases in PostgreSQL, MongoDB or Redis

Experience and enthusiasm for working collaboratively with others in an Agile environment