Database Administrator (PostgreSQL)

Requirements

• Design and implement a full-stack web application using Python Django framework and ReactJS.
• 1+ years of experience in building and deploying web applications.
• Experience in designing and using RESTful APIs.
• Basic knowledge in front-end technologies such as JavaScript, , ReactJS, HTML5, and CSS3.
• Understanding of fundamental design principles behind a scalable application.
• Understanding of databases, SQL and non-relational, plus the Django ORM.
• Strong proficiency in JavaScript, including DOM manipulation and the JavaScript object model.
• Experience in web mark-up like HTML and CSS.
• Experience with data structure libraries.
• Familiarity with RESTful APIs.
• A knack for bench marking and optimization.
• Knowledge of modern authorization mechanisms, such as JSON Web Token.
• Familiarity with modern front-end build pipelines and tools.
• Experience with common front-end development tools such as NPM etc.
• Strong knowledge of Git version control.
• Experience deploying Python applications into production.
• Amazon Web Services (AWS) knowledge is a plus.
• 
  

Responsibilities

• Writing reusable, testable, and efficient code.
• Design and implementation of low-latency, high-availability, and performance applications using Django framework in Python.
• Create and use the REST APIs for communicating with other apps.
• Assess and prioritize feature requests and work in Agile framework.
• Implementation of security and data protection algorithms.
• Integration of data storage solutions like databases, key-value stores, blob stores, S3 etc.
• Improve the functionality of existing systems and applications.
• High commitment to work and taking ownership of deliverables.
• Help to research and influence our path forward with strategic technology initiatives.

Position: Lead Backend Engineer

Location: Pune, India (Initially Remote Due to COVID 19)

About the Organization:

It is one of the most exciting Bay Area Product Driven Organization in Logistics industry supporting more than 30,0000 customers.

As a software engineer on the Backend team, you will be building and owning backend services and infrastructure that power our core products. We strive for high standard of engineering quality while solving unique hardware as well as software challenges. You will have high impact roles at a relatively small company for our user base. You thrive in fast-paced, unstructured environments that require you to wear many hats and think on your feet.



What we are looking for?

• 4+ years of software engineering experience
• 2+ year of experience in Python/Django or Go
• Familiarity with Node.JS is a plus
• You write high quality and well-tested code to meet the needs of your customers.
• Good intuition for REST API design
• Start-up experience is a plus
• BS/MS/PHD in Computer Science or a related field (ideal)
• Preferably a Pune based candidate who can join at the earliest / Within a month

Should Be a Computer Science Graduate from a Tier-1 Engineering college like IIT/ BHU / NIT / VIT / COEP / PICT / BITS

Why join us?

1. Very high-growth
2. Passionate, collaborative, and awesome co-workers
3. Free lunches
4. Competitive salaries
5.  

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

We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.

For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.

Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.

We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.

Working as Senior Microsoft SQL Developer at Navtech, you will:

1. Design conceptual and logical data models and flowcharts.
2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
4. Help write and optimize in-application SQL statements.
5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
6. Ensure performance, security, and availability of databases.
7. Use high-speed transaction recovery techniques and backup data.
8. Provide proactive and reactive data management support and training to users.
9. Determine, enforce and document database policies, procedures, and standards.
10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
11. Monitor database performance, implement changes, and apply new patches and versions when required.

1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
4. Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
6. Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
10. Experience in Postgres, No-SQL databases (a plus).
11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
12. Should have excellent logical, analytical, and communication skills with client interaction experience.

Benefits

• Working with industry giants while following your passion for technology.
• Competitive pay package with additional bonus and benefits.
• Performance review and Appraisal Twice a year.
• Family Health Insurance cover for self and family.
• Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
• Work with a culturally diverse team from different geographies

• 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

• 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

• 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

1. Resume Screen
2. Phone screen
3. Technical interview and take-home assignment
4. Interview with founders
5. Offer

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

• 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 Description:

• Expert level knowledge of JavaScript
• We use Airbnb style to code
• Should be strong in Problem solving skills, data structure and algorithms
• Strong Proficiency in Node.js with detailed experience in Express, loopback, swagger, PM2
• Should have well understanding on Asynchronous Programming
• Experience with Socket.io, engine.io (Preferred)
• Working knowledge of Promise, Callback hell and ways to avoid it
• Solid experience with RDBMS (PostgreSQL)
• Experience with Redis, MongoDB (Preferred)
• Understanding of the design Principles of a scalable system
• Exposure to GCP/ AWS is must
• Excellence in Programming, Debugging and Maintaining the code
• A strong ability to quickly learn new technologies and to keep yourself updated with the latest in tech
• A go-getter attitude with oceans of optimism, humility, and self-motivation
• Passion for code quality and attention to detail
• Experience with Code versioning tool like Git, SVN is preferred