Lead Database Administrator- PostgreSQL

About Company

Our client is in the business of delivering cutting-edge software solutions, hardware systems, and IT services. It lends the right technological edge to governments and businesses. This enables them to achieve their organizational objectives efficiently and effectively to scale their businesses to newer heights.

Minimum Requirements/Qualifications:

• Bachelor’s/Master’s degree in computer science, Computer Engineering or a related field is preferred.

• Must have at least 5 to 7 years of experience in application development (Java,Spring Framework), Deployment(Apache Tomcat & Nginx)

• Sound knowledge of Object-Oriented Programming (OOP) Patterns and Concepts.

• Knowledge & hands-on experience of Java, Spring Framework, Spring Security, JSP, Apache Tomcat, Nginx is a must.

• Must have experience with Bootstrap CSS, jQuery etc.

• Basic Understanding of PostgreSQL, MVC (Model-View-Controller) Pattern, JDBC (Java Database Connectivity), and RESTful web services.

• Relevant Knowledge of Java GUI frameworks according to project requirements.

• Experience in handling external and embedded databases.

Roles & Responsibilities

• Develop new modules, patches & Updates/upgrades for an existing application (developed in-house by the client)

• Bug fixing, and updating of software.

• Analyze user requirements to define business objectives.

• Maintain Java-based applications that can be high-volume and low-latency.

• Identify and resolve any technical issues arising.

• Write well-designed, testable code.

• Conducting software analysis, programming, testing, and debugging.

• Support continuous improvement, investigating alternatives and technologies, and presenting for architectural review.

Skills:

- Very Strong in WCF, WPF, MVVM, Restful WS, and XML

- Very good in Design/Architecture understanding

- Knowledge in DevExpress, Entity Framework, RDBMS and MS SQL Server would be a BIG 

PLUS. 

- Very Strong knowledge in OOPS and Design Patterns

- Working Knowledge in Design, Code reviews/quality, unit testing with NUnit/ XUnit and 

Continuous integration

- Analytical, a problem solver, with good communication skills.

- Ability to understand the requirements, analyze and articulate into design.

- Ability to find out and work with alternatives, check feasibility and propose solutions.

- Experience in Agile methodology and following best practices

- R&D mindset and thirst for exploring/learning new skills 

Qualifications 

Qualifications - BE/BTech/MCA

Experience: 6+ years 

Required Technologies:

o Excellent understanding of Ruby, Ruby on Rails, CSS3

o Able to communicate well with others on technologies bases

o Working knowledge with Rspec is good to have.

o Have previous experience building features in production applications.

o Good Knowledge of SQL

Good To Have

o Basics of GIT and GIT LAB

o PostgreSQL

Able to understand frontend JS frameworks

ABOUT US.

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.

QUALIFICATION AND EXPERIENCE

• Preferably have a working experience of 2 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.

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

LOCATION: Pune & Bangalore

Experience: 2 yrs plus

Package: upto 10 LPA

Responsibilities :

- Knowledge of Node.js and frameworks available for it {such as NestJS, Express, StrongLoop, etc.}

- Experience in Database, Postgres Preferred.
- Integration of user-facing elements developed by front-end developers with server-side logic
- Writing reusable, testable, and efficient code
- Design and implementation of low-latency, high-availability, and performant applications
- Implementation of security and data protection
- Integration of data storage solutions 
- Strong proficiency with JavaScript

• 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.

• 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

As a Senior Software Engineer you have complete ownership of building out the Docexa product along with product people and the rest of the engineering team. This role will act as a great springboard to accelerate career growth & transition into a Tech Lead level role.

Your daily life

• Architecting of the whole platform
• Development of server-side logic
• Building new services and APIs
• Developing core business logic
• Maintenance of current APIs
• Improving the performance and reliability of our systems as we scale

Must-have skills

• You’ve been building web applications professionally for 4+ years
• You’re proficient in PHP 7, Laravel, and PostgreSQL
• You possess strong OOP and design pattern knowledge
• You are familiar with modern technology systems: AWS, load balancers, Kafka queues, caching, etc.
• You write understandable, testable and easy to maintain code
• You’ve the ability to build RESTful APIs
• Explaining complex technical concepts to designers, support team, and fellow engineers is not a problem for you
• Well versed with the fundamentals of computer science and distributed systems

We are looking for a highly capable Node.js developer to optimize our web-based application performance. You will be collaborating with our front-end application developers, designing back-end components, and integrating data storage and protection solutions.

To ensure success as a Node.js developer, you should possess extensive knowledge of Node.Js based services and experience in a similar role. An accomplished Node.js developer will be someone whose expertise results in the stable, fast, and secure exchange of data between servers and end-users.

Responsibilities

• Developing and maintaining all server-side network components.
• Ensuring optimal performance of the central database and responsiveness to front-end requests.
• Collaborating with front-end developers on the integration of elements.
• Designing customer-facing UI and back-end services for various business processes.
• Developing high-performance applications by writing testable, reusable, and efficient code.
• Implementing effective security protocols, data protection measures, and storage solutions.
• Running diagnostic tests, repairing defects, and providing technical support.
• Documenting Node.js processes, including database schemas, as well as preparing reports.
• Recommending and implementing improvements to processes and technologies.
• Keeping informed of advancements in the field of Node.js development.

Skills

• At least one year of experience as a Node.js developer.
• Extensive knowledge of JavaScript, web stacks, libraries, and frameworks.
• Knowledge of front-end technologies such as HTML5 and CSS3.
• Superb interpersonal, communication, and collaboration skills.
• Exceptional analytical and problem-solving aptitude.
• Great organizational and time management skills.
• Availability to resolve urgent web application issues outside of business hours.