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
About us:
HappyFox is a software-as-a-service (SaaS) support platform. We offer an enterprise-grade help desk ticketing system and intuitively designed live chat software.
We serve over 12,000 companies in 70+ countries. HappyFox is used by companies that span across education, media, e-commerce, retail, information technology, manufacturing, non-profit, government and many other verticals that have an internal or external support function.
To know more, Visit! - https://www.happyfox.com/
We’re looking for an experienced Backend Engineer to join our growing team of engineers to help build and maintain our products. You should have prior experience being responsible for building sufficiently complex features by yourself.
Responsibilities:
- Implement product features by writing clean, robust, reusable code with tests
- Bring new ideas and best practices to improve the team and the codebase
Requirements:
- At least 3 years of relevant professional experience
- Sound knowledge of programming languages like Python
- Experience working with web application frameworks like Django
- Experience in building web services using relational databases like PostgreSQL or NoSQL databases like MongoDB
- Experience developing REST APIs and a good understanding of best practices around building APIs
- Good communication skills
- Passion to solve complex technical problems and troubleshoot the issue
Responsibilities-
- Participate in the entire application lifecycle, focusing on coding and debugging
- Write clean code to develop functional web applications
- Troubleshoot and debug applications
- Collaborate with Front-end developers to integrate user-facing elements with server-side logic
- Gather and address technical and design requirements
- Provide training and support to internal teams
- Build reusable code and libraries for future use
- Liaise with developers, designers to identify new features
- Follow emerging technologies
Requirements-
- Spent at least 3 yrs in a solid back end role
- Experience taking a problem to a product solution (module/product)
- Prior experience working with startups and understand the fast-paced, dynamic nature of work
- Javascript, NodeJS
- Client-server architecture
- OOP concepts, including design patterns
- Understanding of RDBMS (MySQL, Postgresql)
- Understanding of REST API
- Familiarity with frameworks such as ExpressJs
- Knowledge of TDD frameworks mocha, chai, jest, etc
- Knowledge of AWS (Lambda, RDS, EC2, SQS, S3, ECS, etc)
- Basic knowledge of Typescript, NextJs
- Prior experience in fin-tech
- To support and maintain existing Java code base, debug the application
- To analyse user and business requirements and design and implement appropriate solutions
- To design and code programs following in-house standards and good design principles
- To ensure that all programs are documented to the company standards
- To create unit test plans and perform unit testing of the programs
- To provide advice and guidance to other members of the team
- Hands on experience in designing and developing applications using Java EE platforms
- Object Oriented analysis and design using common design patterns
- Good knowledge of Relational Databases, SQL and ORM technologies (JPA2, Hibernate)
- Experience in the Spring Framework
- Experience in developing web applications using at least one popular web framework (JSF, Wicket, GWT, Spring MVC)
- Experience in RESTFul webservices
- Experience with test-driven development
- Exposure to portal/mobility development - Desired
- Exposure to any of middleware solutions like MQ, Oracle fusion middleware(WebLogic), WebSphere, Open Source
The ideal candidate would be a person having a strong technical know-how of Drupal application development & CMS concepts, backed with an equally strong hands-on experience. He / She should be fluent with the design concepts using Drupal 8 and above(Must) as well as be well versed with the best practices in the development, testing & deployment phases.
Experience : 5 – 9 years
Contract duration : 6 months
Major Accountability
• Demonstrate expertise in authoring & customizing Drupal modules as well as have experience in working with views, panels and features.
• Carry-out impact analysis & estimation for given set of requirements.
• Develop code by adhering to the Drupal, security and accessibility standards.
• Act as liaison with the client for troubleshooting: investigate, analyze, and solve software problems.
• Work self-directed and independently.
Essential Skills & Experience
• Have overall 4-8 years of IT experience on Drupal 8 platforms.
• Have expertise in developing complex websites based on Drupal 8 platforms and framework-based web applications.
• Have expertise in LAMP environment.
• Have working knowledge of web servers like Apache, Nginx etc.
• Have strong experience with source/version control systems.
• Have excellent communication, analytical & presentation skills.
Education
• Minimum education: B.E., BTech, MCA
• Languages: English written & spoken
Job Description
- Managing the interchange of data between the server and the users.
- Development of all server-side logic, ensuring high performance and responsiveness to requests from the front-end Integrating the front-end elements built by your co-workers into the application; therefore, a basic understanding of front-end technologies is necessary as well.
- Writing reusable, testable, and efficient code.
- Design and implementation of low-latency, high-availability, and performant applications.
- Integration of user-facing elements developed by front-end developers with server-side logic
- Implementation of security and data protection.
Expected experience with
- Should have worked on the Django REST framework.
- Familiarity with some Pandas, Numpy, text parsing/mining and ORM (Object Relational Mapper) libraries
- Able to integrate multiple data sources and databases into one system
- Understanding of the threading limitations of Python, and multi-process architecture
- Good understanding of server-side templating languages
- Worked on Amazon cloud solutions
- Understanding of accessibility and security compliance
- Knowledge of user authentication and authorization between multiple systems, servers, and environments
- Understanding of fundamental design principles behind a scalable application
- Familiarity with event-driven programming in Python
- Able to create database schemas that represent and support business processes
- Strong unit test and debugging skills
- Proficient understanding of code versioning tool
- Excellent written and verbal communication skills.
- Should know about HDL and LLD.
- Should know about making python packages
- Should have worked on microservice-based Architecture
Job Description:
As a L3 analyst, you will play a key role within the Application Management team, leading services for its customer(s). This service has responsibility for the smooth daily operational running of the Client platform both in the cloud and on-premises. The Client application is business critical and centrally manages data for trading, settlement, risk, client and regulatory reporting systems. As a L3 analyst, you will be responsible for supporting complex infrastructure and application issues raised by L1/L2 support teams, and business analysts. You would also be working on client requests for enhancements, fixes, maintaining custom code, and following the best practices such as Agile, DevOps, etc.
The role is a technical role requiring a good technical knowledge of SQL/PLSQ, Core Java along with good debugging skill while supporting client implementations. You should have basic understanding on Unix system and commands. The ability to troubleshoot issues, assist users and help write specifications is essential. This position also works with product management to improve the software engineering processes and practices associated with continuously building, deploying, and updating software and environments.
- Accountability and primary responsibility/duties:
- A typical day would look like as follows: -
- 40% support issues.
- 40% configuration/development work.
- 20% continuous improvement, automation, CICD, so on.
- Activities would range across the lifecycle from discovery to post-implementation support.
- Understanding client’s requirement, replicate the problem and providing the solution
- Understanding and developing new requirements coming in from BAs (Business Analysts) and customers.
- Update the existing functionality based on client needs.
- Develop changes that cater to enhancing the product and/or fixing production issues
- Prepare product releases of software components. (Java/SQL-PLSQL)
- Contribute in all phases of the development cycle. (development/Deployment/Testing, peer review)
- Create technical document for all changes made.
Required Qualifications/Knowledge/Skills
- Bachelor’s degree in Computer Science or related field
- Strong basics and working experience in following technologies: -
- Core Java.
- SQL / PLSQL coding.
- Object Oriented Programming concepts and data structures.
- Working knowledge on Unix platform
- Working knowledge on XSLT and XML handling
- Basic understanding App & web server working knowledge (JBOSS, WebLogic and WebSphere) and debugging skills.
- Advantageous to have:
- Working understanding on CICD, Dev-ops technologies.
- Queuing technologies including Kafka, MQ, Solace.
- Scripting including Python, Unix, java.
- Hands on knowledge of Dev ops processes and tools Good interpersonal and communication skills.
*Performs analysis of functional and business requirements
*Applies in-depth or broad technical knowledge to maintain data engineering functions performs solution design.
*Applies the company, open source, and 3rd party technologies to highly complex infrastructure and software solutions.
*Introduce new product features and enhance the platform
*Ability to translate business reporting requirements into a production report.
Exposure to Angular would be an added advantage
Should be willing to work in challenging environment for a start up company
- In-depth knowledge of at least one programming language such as Clojure, Go, Python, Java, Javascript (Node), Ruby, Erlang/Elixir
- Thorough understanding of PostgreSQL. Experience working with views, common table expressions (CTE), window functions, joins, different kinds of indexes, etc.
- Practical knowledge of Linux server management
- Understanding of functional programming concepts
- Knowledge of Chef, Puppet, Salt, etc. is a plus
- Experience in distributed systems is a plus
Responsibilities:
- Plan future implementations by working closely with the product team
- Deliver an amazing user experience by working with the front-end developers
- Write test suites and deploy code into production
- Setup monitoring and alerts for in-production services
- Automate deployments
Continue if:
- You want to build a world-class Saas B2B communication product, using the latest tools, from scratch
- You love to code 8+ hours a day and solve hard problems by building software you are proud of
- You enjoy working with directly with amazing entrepreneurs
- You are driven by the desire to learn
- You like the pressure to perform because it makes you a better person
- You are passionate about getting stuff done
- You are passionate about making a tangible difference in the world
- Passionate about writing elegant, functional efficient code
Recruitment stages:
- Resume Screen
- Phone screen
- Technical interview and take-home assignment
- Interview with founders
- Offer
Why Unifize:
- The co-founders have been running companies in at least five countries over the past fifteen years, including deep experience in technology, operations and sales in engineering/manufacturing businesses.
- We are part of Techstars first India batch, and part of Target and Airbus Accelerators
- Attended universities that are consistently ranked in the Top 10 in the world.
- We have a track record of raising capital and strong existing relationships with the finance community in both India, the US and the UK. We have funding for at least the next 24 months.
- We have strong domain expertise in the industry they are trying to disrupt. However, we still followed the discipline of spending six months doing rigorous customer development spanning six countries before defining their product or writing a single line of code. We have already identified and are working with ten customers.
- We have very high expectations from the candidates that we do select, especially in terms of first-principles thinking, communication and accountability. We will not select average candidates, and we want to encourage our employees to see Unifize as a learning ground for possibly starting their own technology businesses in the future.
- We strongly believe in evidence-based decisions, transparency, corporate governance, meritocracy, and an open forum for discussion.
- We explicitly want to build a team from different backgrounds and with a wide range of interests and experiences. We are committed to building a gender-balanced organization.
About Unifize:
- Unifize helps teams that manage repeatable processes reduce wasted time by up to 95% by organizing their emails and other conversations around objectives.
- We build a cloud-based chat application that helps these companies measure and reduce time and errors in their communication processes, so their teams can focus on selling better products to happier customers.
Job Summary:
– We are looking for a kick ass software engineer with exceptional skills in data structures, algorithms, core java, and distributed systems. If you think you have it in you to deliver on aggressive timelines, have the hunger for growth, don’t like giving excuses, contribute to product features, be hands-on and deliver a world-class product, then we want to hear from you.
This is a predominantly back-end engineering role.
– You are a rockstar engineer with proven capabilities working on SaaS product and a passion for writing exception code.
– You are hungry for an opportunity to join a start-up and become a member of core platform team driving the company forward.
– You will be responsible for the delivery of product features as a part of the platform engineering team.
– You will be hands-on working on key features of the product.
– You will be responsible for design of back-end architectural changes and product features.
– You will have plenty of opportunity to learn and implement ideas to build products in efficient and cohesive manner.
– Understand the product mission, goals, and tasks and execute with the team to achieve them.
– Understand the design and architecture and build modules in accordance with it or recommend and make the necessary changes that adds more stability to our product.
Eligibility:
– 4+ years of experience with hands-on experience in Core Java/Kotlin
– 2+ years of experience as a technical architect with responsibility for core features
– 4+ years of working experience in cloud-based systems
– 2+ years of experience working on distributed systems
– 2+ years of experience working on Kafka and Zookeeper
– Experience working on RxJava/ Reactive Programming
– Adept on design patterns and distributed systems
– Excellent verbal and written communication
– Proficient in building REST APIs to interact with relational and non-relational data sources
– Proficient in SQL and RDBMS
– Hands on experience in code and system optimization
– Experience in working with NoSQL databases is a plus