
Database Administrator Lead - PostgreSQL
ABOUT Ashnik
Established in 2009, Ashnik is a leading open-source solutions and consulting company in South East Asia and India, headquartered in Singapore. We enable digital transformation for large enterprises through our design, architecting, and solution skills. Over 100 large enterprises in the region have acknowledged our expertise in delivering solutions using key open-source technologies. Our offerings form critical part of Digital transformation, Big Data platform, Cloud and Web acceleration and IT modernization. We represent EDB, Pentaho, Docker, Couchbase, MongoDB, Elastic, NGINX, Sysdig, Redis Labs, Confluent, and HashiCorp as their key partners in the region. Our team members bring decades of experience in delivering confidence to enterprises in adopting open source software and are known for their thought leadership.
THE POSITION
Ashnik is looking for talented and passionate people to be part of the team for an upcoming project at client location.
RESPONSIBILITIES
· Monitoring database performance
· Optimizing Queries and handle escalations
· Analyse and assess the impact and risk of low to medium risk changes on high profile production databases
· Implement security features
· DR implementation and switch over
QUALIFICATION AND EXPERIENCE
· Preferably have a working experience of 4 Years and more , on production PostgreSQL DBs.
· Experience of working in a production support environment
· Engineering or Equivalent degree
· Passion for open-source technologies is desired
ADDITIONAL SKILLS
· Install & Configure PostgreSQL, Enterprise DB
· Technical capabilities PostgreSQL 9.x, 10.x, 11.x
· Server tuning
· Troubleshooting of Database issues
· Linux Shell Scripting
· Install, Configure and maintain Fail Over mechanism
· Backup - Restoration, Point in time database recovery
· A demonstrable ability to articulate and sell the benefits of modern platforms, software and technologies.
· A real passion for being curious and a continuous learner. You are someone that invests in yourself as much as you invest in your professional relationships.
LOCATION: Bangalore & Mumbai
Experience: 7 yrs plus
Package: upto 20 LPA

Similar jobs
Job Description:
Responsibilities:
- Completing all tasks set by the supervisor and assisting wherever possible.
- Observing existing strategies, techniques of coding, debugging, testing and adopting to the same
- Ability to maintain composure under pressure
- Ability to work in a team.
- Good observation skills and a willingness to learn.
Skills:
- Proficiency in data structures and algorithms
- Good problem solving and analytical thinking skills
- Knowledge of Linux systems
- Python coding knowledge
- Knowledge of object-oriented programming
- Good verbal and written communication skills.
Requisition Raised by:
Engineering Director
Aadrila Technologies Pvt Ltd. is the largest data, analytics, automation, and decisioning solution provider to financial intuitions, catering to the entire customer lifecycle from onboarding to diligence. Aadrila Technologies provides solutions that enable systemic fraud prevention, risk management, compliance, and automation through superior data engineering and deep tech (NLP and Deep Learning) applications. In the B2B SaaS market, Aadrila Technologies Pvt. Ltd. is an undisputed leader. Based in Mumbai, Andheri, it has ~90% market share in the motor insurance underwriting data providers market.
Senior Software Engineer 4-6yrs of work exp
As a Senior Software Engineer at AADRILA TECHNOLOGIES PVT LTD, you will be responsible for designing, developing, and deploying high-quality API solutions. You will collaborate with cross-functional teams to build innovative and performant applications.
Responsibilities:
- Write reusable, testable, and efficient code.
- Design and implement low-latency, high-availability, and performant RESTful APIs.
- Implement security and data protection measures.
- Integrate data storage solutions into software systems.
- Develop, test, tune for performance, and deploy web services.
- Collaborate with the product team to build innovative, robust, and user-friendly features
Requirements:
Must-Haves:
- Excellent analytical and problem-solving skills.
- Proven experience in the software development lifecycle.
- Solid coding experience in Python.
- Good understanding of Object-Oriented Concepts and Design Patterns.
- Knowledge of Amazon Web Services (AWS) APIs deployment and management.
- Experience working with Multithreading/Multiprocessing.
- Good working knowledge of programming in a Linux environment.
- Acquaintance with Web Stacks and RESTful APIs.
- Experience in best code deployment practices.
Highly Desired:
- Experience with NoSQL databases like MongoDB.
- Familiarity with AWS Serverless Stack (API Gateway, Lambda, SQS, Cloudwatch etc.)
- Familiarity with infrastructure as code tools (serverless and Terraform).
Experience and Qualification:
- Minimum of 3+ years of relevant experience.
- Bachelor's or Master's degree in Computer Science, Computer Engineering, or Information Technology.
Join our dynamic team and work in a challenging environment where you will have the opportunity to make a significant impact. AADRILA TECHNOLOGIES PVT LTD offers competitive compensation, professional development opportunities, and a collaborative work culture. Apply now and be part of our innovative software engineering team.
- 3 - 5 years of progressive IT experience with a minimum of 1+ years in building Ruby on Rails Web applications and RESTful API endpoints
- Proficient with scripting languages, specifically Python and Bash
- Experience in Object Oriented Java Script.
- Must have Linux command line experience.
- Good experience in developing and integrating reliable REST web services.
- Possess good communication, organizational and creative thinking skills.
- Multi-tasking individual that likes to work both in a team environment and individually
- Excellent technical abilities, leadership, decision making, and adaptability to new technology
- Good knowledge of Agile processes and practice
- Team player
Who are we and what do we do?
The Dice platform, one of the most advanced SaaS fintech organizations, helps businesses convert their spending from many fragmented applications, prepaid cards, offline reimbursement/invoice management, procurement, and payment systems to a single spend platform. There will be no more cash, cards, refunds, or offline invoicing since our entire goal is to provide businesses more knowledge and control over how they spend their money, resulting in significant cost savings and profitability. We are a hyper growth startup collaborating with premium Indian enterprises, startups, and industry leaders across disciplines.
Perks in store for you when you join the team:
- You'll be surrounded by passionate team members.
- Your work will have a visible impact.
- You will be working on interesting technical challenges in a fast-paced environment.
Requirements and skills:
- Hands-on Software Development experience.
- 2-4 years of relevant experience in Java development.
- Hands-on experience in designing and developing applications using Java EE platforms.
- Object-Oriented Analysis and design using common design patterns.
- Profound insight of Java and Java EE (Multithreading, Reactive Programming, etc)
- Excellent knowledge of Relational Databases, SQL, and ORM technologies (MySQL, EBean)
- Excellent knowledge in RESTful API development, event-based processing.
- Experience with test-driven development.
- Knowledge of GIT, Linux, Docker, Redis
Responsibilities:
- Designing, implementing, and maintaining Java applications that are often high-volume and low-latency, required for mission-critical systems
- Delivering high availability and performance
- Contributing in all phases of the development lifecycle
- Writing well-designed, efficient, and testable code
- Conducting software analysis, programming, testing, and debugging
- Managing Java and Java EE application development
- Ensuring designs comply with specifications
- Preparing and producing releases of software components
- Transforming requirements into stipulations
- Support continuous improvement
- Investigating alternatives and technologies
Location:
Pune
Create and maintain database tables, views, indexes, and triggers.
Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.
Develop and maintain high-quality stored procedures.
Write low cost, high-quality database queries and code while maintaining data quality, privacy, and security
Profile databases, measure database performance and troubleshoot complex database issues, and IO bottlenecks.
Optimize database queries and ensure table locking/deadlocks happen in production.
Optimize large, complicated SQL statements & Stored Procedures.
Cost optimization of Amazon instances using databases.
Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels
Knowledge of message queuing, indexing, and high-performance data concept
Knowledge of JSON and PostgreSQL support for JSON.
Good Grasp of ETL concepts
Work with front-end developers to define simple yet powerful APIs
Work with DBAs to ensure the efficiency of database code, integrity of data structures and quality of data content.
Coordinate with product managers and leadership teams to build effective database objects
Excellent verbal and written communication skills
Good attitude towards work and flexibility
Ability and willingness to handle multiple tasks in a fast-paced environment
Ability to evaluate alternative solutions and/or workarounds

ROR :: JD
Immediate Joiner
- Having experience on Ruby on Rails.
- Strong SQL skills with MySQL or PostgreSQL
- Knowledge on MongoDB an advantage.
- Experience with TDD (test driven development) or RSpec.
- Having experience on REST/API.
- JRuby experience is an advantage
- Knowledge on Exilir and functional programming a plus and JRuby is an advantage.
- Experience using Git productively in a team environment.
- Experience into Amazon web services
- Knowledge on Jenkins is an advantage.
- Knowledge on Docker.
- Excellent analytical and problem-solving skills
- Experience in Java and associated technologies Core Java, JSP, Spring, Struts,RESTful Services,SOAP,Tomcat, Hibernate, Maven
- Strong understanding of OOPS concepts
- Proficient understanding of RDBMS Concepts
- Strong understanding of Databases Oracle / MSQL / MySQL etc and PL/SQL Programming
Java Full Stack Developer
Notice Period: 45 days / Immediate Joining
Banyan Data Services (BDS) is a US-based Infrastructure Services Company, headquartered in San Jose, California, USA. It provides the full stack managed services to support the business applications and data infrastructure
We are looking for a Java Full Stack Developer who has the expertise and deep knowledge of frameworks and tools used in java and who works end to end on the application stack, right from developing the front end, the back-end module & the database.
It's a once-in-a-lifetime opportunity to join our start-up run by a world-class executive team. We are looking for candidates that aspire to be a part of the cutting-edge solutions and services we offer that address next-gen data evolution challenges
Key Responsibilities
· Ability to write high-quality code efficiently
· Design and develop new services or micro-services.
· Participate in planning and management of development process.
· Share architectural design vision with both technical and non-technical team members, including fellow engineers.
· Works on improvements in development toolset including testing frameworks, deployment scripts, and monitoring libraries.
· Experience solving complex problems and implementing solutions for performance and scalability.
· Write clean, well-structured and maintainable code with automated test coverage and corresponding documentation.
· Explore new latest relevant technology, techniques, frameworks, tools, methodologies, and processes.
· Comfortable working with all aspects of software development; including DevOps, quality assurance, research, and design.
Key Requirements
· 3+ years of experience working with Core Java, Spring framework & Spring Boot, Hibernate, Spring Data JPA.
· Knowledge of microservices architecture is mandatory.
· Must have worked on Java Multi-threading & Java NIO.
· At least 1-year of experience with front-end technologies like Angular, React, Vue.js applications.
· Exposure to any of relation database technologies MySQL, Postgres, Oracle, or any No-SQL database.
· Strong knowledge of Web APIs.
· Experience with agile application development.
· Having knowledge of O Auth 2.0 JWT is a plus.
· Proficiency in one or more modern programming languages i. e. Java or J2EE, Python, Go, React.
· Experience in Cloud Technologies including AWS, containers, and Kubernetes.
· Demonstrated experience in performing DevOps for platforms.
· Strong Skill sets in Data Structures & Algorithm in using efficient way of code complexity.
· Passion for learning new technologies and the ability to do so quickly
http://www.banyandata.com" target="_blank">www.banyandata.com









