Postgres DBA

Senior Web Backend Developer

 

 Company Overview:

It is a US based startup founded in 2018 to build an edge data platform for the autonomous world.Rich data in large volumes is getting collected at the edge (outside a data center) in use cases like autonomous vehicles, smart manufacturing, satellite imagery, smart retail, smart agriculture etc.These datasets are characterized by being unstructured (images/videos), large size (Petabytes per month), distributed (across edge, on-prem and cloud) and form the input for training AI models to get to higher degrees of automation. It is engaged with building products that solve these unique challenges and be at the forefront of this edge data revolution.

The company is backed by prominent VCs and has it’s entire software engineering team based out of India and provides ample opportunities for from-scratch design and development.

 

Role:

This role is an individual contributor role with key responsibilities in developing web server backends for Akridata management plane software that provides a ‘single pane of glass’ for users to manage assets, specify and monitor large volume data pipelines at scale involving 10s of petabytes of data.

 

This role involves:

1. Working with tech leads and the rest of the team on the feature design activities and picking appropriate tools and techniques for implementation.
2. Be a hands-on developer able to independently make correct implement choices, follow sound development practices to ensure an enterprise grade application.
3. Guide and mentor junior team members.

 What we are looking for:

1. A Bachelor’s or Master’s degree in computer science with strong CS fundamentals and problem-solving.
2. 5+ years of hands-on experience with software development with 3+ years on web backend development.
3. A good understanding of backend application interactions with relational databases like MySQL, Postgres etc
4. Knowledge of web server development frameworks preferably on Python.
5. Enthusiastic to work in a dynamic, fast paced startup environment.

Good to have:

1. Hands-on experience with designing database schema and implementing and debugging SQL queries for optimal performance for large datasets
2. Experience working with applications deployed on Kubernetes clusters.
3. Experience with working on a product from early stages of it’s development typically in a startup environment.

Looking to hire for a contractual role.
Period: 6 months+
JD:
● 4-7 years of experience building and scaling APIs and web applications.
● Experience building and managing large scale data/analytics systems.
● Have a strong grasp of CS fundamentals and excellent problem solving abilities. Have a good
understanding of software design principles and architectural best practices.
● Be passionate about writing code and have experience coding in multiple languages, including at least
one scripting language, preferably Python.
● Be able to argue convincingly why feature X of language Y rocks/sucks, or why a certain design decision
is right/wrong, and so on.
● Be a self-starter—someone who thrives in fast paced environments with minimal ‘management’.
● Have experience working with multiple storage and indexing technologies such as MySQL, Redis,
MongoDB, Cassandra, Elastic.
● Good knowledge (including internals) of messaging systems such as Kafka and RabbitMQ.
● Use the command line like a pro. Be proficient in Git and other essential software development tools.
● Working knowledge of large-scale computational models such as MapReduce and Spark is a bonus.
● Exposure to one or more centralized logging, monitoring, and instrumentation tools, such as Kibana,
Graylog, StatsD, Datadog etc.

● Working knowledge of building websites and apps. Good understanding of integration complexities and
dependencies.
● Working knowledge linux server administration as well as the AWS ecosystem is desirable.
● It's a huge bonus if you have some personal projects (including open source contributions) that you work
on during your spare time. Show off some of your projects you have hosted on GitHub.

• Design, develop and manage data on various open-source SQL databases
• End-to-end performance tuning of Oracle, MariaDB, MySQL, PostgreSQL, and Aurora against very large data sets
• Database cluster connectivity and security
• Conduct database training
• Software installation and configuration
• Database patching and upgrading
• Using monitoring and management tools
• Troubleshoot various issues with other dba’s/developers
• Point of Contact for Vendor escalation
• Point of Contact for professional service to Customers
• Cross-platform migration from Oracle to MySQL/MariaDB/PostgreSQL/Aurora
• Support the creation, maintenance, and implementation of procedures regarding how problems are identified, received, documented, distributed, and corrected
• Ensures project documentation is complete, current, and stored appropriately
• Manages day-to-day project and scope changes
• Communicate and coordinate database changes, backups, and downtime to users
• Identifies potential security issues and recommend strategies to ensure database security
• Research and evaluate new technologies
• Proactively monitor systems for optimum performance and capacity constraints
• Establish standards and best practices for SQL
• Interact with and coach developers in SQL scripting
• Perform database backup and recovery
• Provides 24x7 support for enterprise database systems

Secondary Functions

• Must provide mentoring and training to other staff members
• Write procedural documentation including requirements for databases
• Develop and coordinate knowledge transfer
• Establishes enterprise-wide uniform infrastructure, including supporting defined departmental content processes and creating guidelines for content deployment
• Interacts with business units to gather, define, and organize the delivery of business solutions Data
• Modeling, design & implementation based on established standards
• Automate manual tasks

Who we have in mind:

• Candidate with a college degree and relevant work experience
• 7+ years of hands-on DBA experience with Oracle, MySQL, MariaDB, and PostgreSQL and supporting tools
• Strong experience with Linux is required, including command-line editors, scripting (shell, Python, Perl, etc.)
• Experience in database performance tuning and strong SQL tuning skills
• Experience in database and cross-platform upgrades required Experience in all aspects of the software development lifecycle including requirements gathering, design, coding, testing and production support
• Must be familiar with RDBMS concepts, practices, and procedures
• Must have knowledge of network connectivity
• Extensive experience with Export/Import, Backup and Recovery
• Extensive experience with Database Replication Master/Slave, Master/Master (BDR)
• Extensive experience with MySQL (MariaDB, Percona) Galera cluster
• Experience with MaxScale
• Proficient in SQL Language
• Knowledge of ServiceNow, or similar Ticket Management Software
• Knowledge of SAN infrastructure including HP and NetApp
• Ability to work on projects at a time
• Knowledge of middle-tier application servers
• Strong troubleshooting and problem resolution skills
• Good knowledge of Data Modeling
• Knowledge of XML and JDBC

It would be great if you had:

• Experience of NoSQL databases (Cassandra, Oracle NoSQL, MongoDB) is a plus
• Certifications on MySQL, PostgreSQL, and Aurora

Back End development of websites and applications using PHP,
AJAX and JS and their frameworks to create and integrate
functional web standard projects. Taking ready HTML/CSS files
from front end developers and executing the project based on the
logic and wireframes provided by designers

Solid knowledge of PHP, MySQL, JSON, and XML
● Proven experience building data-driven web
applications
● Experience working with API development
● Familiarity with design patterns such as MVC
● Experience with Open Source PHP CMS such as
WordPress or Drupal or Magento
● Comfortable with data modeling, stored
procedures, and views
● Ability to work closely with front end developers
● Knowledge of JavaScript / jQuery skills / HTML / CSS
● Experience building large, scalable applications
● Experience building custom
content management
systems
● Awareness of current development trends in the
coding and development like Docker, Micro
services and an understanding of how these
technologies can improve and impact projects
● Knowledge of GIT or any other version control
software.

Experience: 1 to 3 years

What we are looking for:
Speed, passion, attention to details, get it done attitude, long term association and 1st principal thinking and lastly team player with ZERO insecurities. Learning opportunities will surely be huge.

Responsibilities:
1. Build new services to meet critical product and business needs.
2. Design scalable systems to solve problems with modern cloud technology and industry best practices.
3. Articulate a long-term vision for maintaining and scaling our backend systems and the teams running them.
4. Work with engineers, designers, product managers and senior leadership to turn our product and technical vision into a tangible roadmap every quarter.
5. Write high quality, well tested code to meet the needs of your customers.


Requirements & Qualifications
1. 3-7 years of recent hands-on coding and software design.
2. Bachelor degree or more in Computer Science or a related field.
3. A track record of projects completed on time – you are a flawless executor, not a procrastinator.
4. You find satisfaction in a job well done and want to solve head-scratching challenges.
5. Experience with all phases of the software development life cycle, best practices and Agile Software Development.
6. Solid OOP and software design knowledge – you should know how to create software that’s extensible, reusable and meets desired architectural objectives.
7. Establish Back-End Software Engineer best practices.
8. Working experience with NodeJS, PostgreSQL, In memory Database like Redis, Messaging Queues like RabbitMQ/Kafka

Appristine Technologies. We are based in Pune and we are hiring for the following role.

1. PHP Developer – 2+ Years Exp.

Skill:-

• Strong skill level in PHP
• Intermediate skill level in HTML and CSS
• Intermediate skill level in JavaScript or JQuery
• Intermediate skill level in at least one server-side language (i.e. Java, Python, etc)
• Intermediate skill level with relational database systems (i.e. PostgreSQL, MySQL, etc)
• Intermediate skill level with a source control software (i.e. Git, SVN, etc)
• Good understanding of UI/UX design principles
• Strong technical and non-technical communication skills
• Good understanding of object-oriented programming

•  5-10 years of experience in building API services using NodeJS Express and related frameworks
• Expert level understanding of NodeJS asynchronous runtime
• Expert level understanding of Javascript concepts on callbacks and closures
• Experience with Postgres, NoSQL, Redis, and Firebase real-time database
• Experience with AWS services like Elastic Beanstalk, Cloudfront, S3, EC2, Lambda, API Gateway, SQS, etc
• Understanding of patterns and techniques for building scalable back-end infrastructure including caching, rate limiting, authentication, and authorization schemes.
• Experience in building highly scalable and high throughput services with millisecond response times
• Experience working in a collaborative team environment
• Excellent communication & interpersonal skills
• Willingness to learn and pick up new technology along with patience to mentor

Bonus skills – 

• Experience with Elastic Search, Puppeteer
• Experience writing unit test

About the Company: Perfios (www.perfios.com) is a leading product technology company in the FinTech space enabling Financial Institutions in realtime decisioning, analysis and credit underwriting. Perfios helps in banks statement analysis (APIs and portal), e-verification, financial analysis, Fraud check, Form 26AS, ITR, PAN, Aadhar, Personal Finance Management APIs etc. Perfios enables businesses to aggregate structured and unstructured data, curate, analyse and help in decision-making. Perfios' product offerings help companies build vertical applications across various domains using our modules. In over nine years, Perfios has acquired 110+ large clients across various domains of Banks, NBFCs, Digital Lending platforms, Mutual Fund Companies, Insurance companies, Human Resources etc both in India and abroad. Perfios is an ISO certified company. Located @ Koramangala, Bangalore, Perfios has a highly advanced Engineering Product design center lead by experienced Technocrats working on cloud-based SAAS products to support client engagements in all aspects of product development, delivery and customer success. The Company is slated for high growth this year and is planning a 3-fold increase in its current employee strength of 70 Log on to www.perfios.com for more details on the company and its products. A vacancy now exists for a highly motivated and resourceful Lead Software Engineer for the DevOps team to continuous build, release and automated monitoring infrastructure for Linux based products. If you have the required skill and would like to explore opportunities with us, please send your detailed resume immediately The ideal candidate is someone who despises doing a lot of busy manual work and prefers to develop automation for anything that he/she feels can and should be automated. The ideal candidate is also someone who is very comfortable interacting and working with pretty much everyone in the product team as the person will be supporting a growing number of product and test software engineers. As a member of this team, you will: • Develop and maintain code used to manage and provide metrics for build-related results • Automate build and release engineering tasks using tools such as ant, maven and ansible • Manage source repositories and branches using Git. • Manage build and development tools including Jenkins and Jenkins plugins. • Design, set up and enforce standards, conventions, processes and procedures for development as well as build and release engineering-related activities. • Manage and control branching for all types of development. • Troubleshoot build/unit test and build infrastructure issues. • Drive releases and hot fixes through various SDLC milestones to shipping. • Ensure high availability and robustness of build farm and its applications through backup/restore procedures, auto-recovery, and failover. • Manage deployment of build to various internal test system, staging and production environment • Manage and maintain docker environments • Manage the build and deployment of mobile native apps • Manage the build and deployment of HTML5 framework based products • You will help automate and streamline our operations and processes maintaining tools for application build, configuration, release, deployment, monitoring and operations. • You will troubleshoot and resolve issues in our dev, test and production environments which • includes resolving application performance issues. • You will provide software and/or infrastructure recommendations based on production application performance monitoring. • You will actively monitor the production environment on 12x7 basis • Monitoring system, application logs • Monitor application exception and route to respective product team and follow-up on hot fixes • In addition, as a DevOps Engineer you will conduct research and will maintain an understanding of industry trends on existing and emerging technologies to advise how to gain the best value from the technologies we use. Qualifications & Requirements • With 8-10 Years of professional experience • At least 4-6 years’ experience in hands-on production monitoring and management • Experience with one or more of the following interpreted programming/scripting languages: Bash, Python, Perl • Extensive experience and deep knowledge of Unix OS • Good knowledge of automation tool Ansible. • Experience in managing AWS environments and good knowledge of virtualization • Experience with release management process • Appreciation for the Prod Ops culture and values • Must have excellent skills in problem analysis and troubleshooting complex technical issues • Excellent verbal and written communication skills. • BE in Computer Science • Good to Have o Experience in building mobile native application o support/troubleshooting/operations of Mysql database o Experience in security monitoring and various security tools and techniques o Experience with metrics, monitoring and alerting tools such as Nagios, CloudWatch etc., o Experience in support/troubleshooting/operations of Apache, Tomcat and JVM o Managing the deployment of builds to play store o Experience in building flex and HTML5 application o At least one certification in a cloud platform.