Database Administrator (PostgreSQL)

What’s the opportunity?

Are you a backend developer looking to fast-track your learning and growth? Have you looked at world-class products like Asana, Notion, or Airtable, and felt “I wish I were part of the early team that built these products”?

We’re a team that has previously built and rolled out globally successful SaaS products used by tens of thousands of customers. We’re laser-focused on delivering a world-class product again, and looking for an ambitious backend engineer to join our existing team of 9 engineers. 

If it excites you to think of a fast-paced start-up environment, building something big from scratch, breaking down new problems, creating new APIs, working on performance issues, getting hands-on with DevOps initiatives, and showcasing demos of your work every Friday with a happy and passionate team, then this is the right opportunity for you.

Some of the tech problems you get to work on as a backend engineer would be to build the backend for a modern spreadsheet experience from scratch, work on infra as code, write robust code that is fault-tolerant, work on performant code that adheres to SLOs set by the organization.

About you:

● 3- 5 years of experience

● Expertise in the following areas ○ Java ○ HTTP Protocol

● You’ve heard of or worked with some of the following tech stacks/products ○ Spring ○ PostgreSQL ○ Redis ○ Docker ○ Message brokers ○ GitHub

● These non-functional areas are familiar to you ○ Performance ○ Debugging ○ Log management

Nice to have:

● Familiarity with AWS

What’s in it for me?

● Great opportunity: We genuinely care about everyone we hire. You’ll learn new things and grow no matter how experienced you are; you will be working with founders who have more than three decades of collective experience in building significant B2B SaaS startups.

● Great team: Work with a world-class, high-velocity team that truly embodies the values of empathy, curiosity, and customer-centricity. Check out the MTT(Meet The Team) videos on our LinkedIn.

● Great culture: An open, fun, and exciting startup culture that empowers its people to champion big problems with the freedom to think and innovate.

● Growth: You could easily and quickly transition into other roles you might like.

● Impact: You get to be part of a global, passionate team in a fast-paced and growth-oriented environment. The team has a work philosophy of being high on ambition, ownership, and a bias for action.

● Monetary rewards and benefits: Competitive stipend, flexible leave policy, and more

Key Responsibility Areas:

• Develop tools and applications by producing clean, efficient code.
• Determine operational feasibility by evaluating analysis, problem definition, requirements, solution development and proposed solutions
• Perform validation and verification testing and debud code.
• Work collaboratively with others to achieve goals
• Experience working in an agile environment

Required Skills:

• Experience in implementing Object-Oriented Python, Django.
• Good understanding on Django
• Experienced in interfacing with *third party API’s using REST
• Worked with varieties of Relational Databases (RDBMS) like SQLite, MySQL, PostgreSQL.
• Experience in Version Control with Git and Bitbucket.
• Experience with JIRA the development progress and tracking deadlines of the project

• Responsible for providing technical leadership, design and development of complex pieces of the service oriented architecture based platform.
• Modelling Database Design for large scale applications.
• Develop for performance engineering.
• Design for the right use of micro services, containerization and observability.

• Drive technology and product innovation through rapid prototyping and iterative development.
• Create reference implementation for our integrations and for backward compatibility.
• Not interested in managerial responsibilities

Requirements, Desired Skills and Experience

• Tech Stack based on Ruby-on-Rails, Python-Django or Node.js frameworks.

• Engineering degree 

   Opportunities for the right candidate

• Build and develop SaaS and PaaS products from scratch
• Build the best-in-class UX based products
• State of Art technologies (Latest trends in the industry)
• Work with a well-knit team, almost like one’s family
• Startup culture and advantages of working in a co-working space
• Performance based career progress and high visibility with management and founders

Founded in 2016, they are one of the leading online scheduling software companies in the world, with over 200,000 customers globally. They are a profitable, high-growth bootstrapped platform-as-a-product company with 50+ team members looking to grow to $50M in revenue in the next 3 years. 

Role: SSE- Backend [Golang]

Location: Remote (India)

CTC: 22-26 LPA

NP: 30 days or less

Note: Other Backend Language /Frameworks like Python, NodeJS and Java Springboot and willingness to learn Golang can also be considered

Skillset Requirements:

- Strong experience with backend programming languages and technologies like

- Golang (minimum 2-year experience)

- Protobuf and gRPC

- RESTful APIs

- Docker and Kubernetes

- Medium-level experience with PostgreSQL and MySQL database concepts.

- Ability to write efficient, secure, well-documented, and clean code.

- Proven ability to work with multiple teams, multitask and prioritize.

- Experience with Git, JIRA, and Agile working methodology.

- Experience with design patterns, Event-Driven architecture, and Domain Driven Designs.

Responsibilities:

- Write code that meets standard and delivery guidelines.

- Mentor fellow engineers in the team to develop high-quality software and perform code

reviews.

- Work with the team to break user stories into tasks and delegate them to the team

members.

- Playing a key role in architectural and design decisions, building toward an efficient

microservices distributed architecture.

- Analyze solutions and help implement engineering best practices.

- Work with Project Managers for timely delivery and forecast.

- Lead and mentor junior engineers on technical issues. Perform blameless RCAs when

issues occur and take ownership to resolve issues.

#remotejobs #bootstrapped #platformasaproduct #highgrowth

Come and Join the future.

This is an opportunity to work directly with Industry experts having 20+ years of experience in Technology and product development.

Roles and Responsibilities 

• Developing front end website architecture.
• Designing user interactions on web pages.
• Developing back end website applications.
• Creating servers and databases for functionality.
• Ensuring cross-platform optimization for mobile phones.
• Ensuring responsiveness of applications.
• Working alongside graphic designers for web design features.
• Seeing through a project from conception to finished product.
• Designing and developing APIs.
• Meeting both technical and consumer needs.
• Staying abreast of developments in web applications

Desired Candidate Profile

• Strong organizational and project management skills.
• Proficiency with fundamental front end languages such as HTML, CSS and JavaScript.
• Familiarity with JavaScript frameworks such as Angular JS, and React JS.
• Proficiency with server-side languages like Nodejs, and Expressjs.
• Familiarity with database technology such as MySQL, Postgresql or MongoDB.
• Excellent verbal communication skills.
• Good problem-solving skills.
• Attention to detail.

This person MUST have:

• B.E Computer Science or equivalent
• 5 years experience with the Django framework
• Experience with building APIs (REST or GraphQL) 
• Strong Troubleshooting and debugging skills
• React.js knowledge would be an added bonus 
• Understanding on how to use a database like Postgres (prefered choice), SQLite, MongoDB, MySQL.
• Sound knowledge of object-oriented design and analysis.
• A strong passion for writing simple, clean and efficient code.
• Proficient understanding of code versioning tools Git.
• Strong communication skills.

Experience:

• Min 5 year experience
• Startup experience is a must. 

Location:

• Remote developer

Timings:

• 40 hours a week but with 4 hours a day overlapping with client timezone.  Typically clients are in California PST Timezone.

Position:

• Full time/Direct
• We have great benefits such as PF, medical insurance, 12 annual company holidays, 12 PTO leaves per year, annual increments, Diwali bonus, spot bonuses and other incentives etc.
• We dont believe in locking in people with large notice periods.  You will stay here because you love the company.  We have only a 15 days notice period.

• 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

• 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

• 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

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

• 7 years of hands-on experience on database development
• Very strong and hands-on in Oracle Database and PL/SQL development
• Hands on experience in designing solutions and developing for data migration projects using Oracle PL/SQL
• Experience with Oracle Argus Safety, ArisG and other Safety/Clinical systems
• Working experience in development of ETL process, DB Design and Data Structures
• Excellent knowledge of Relational Databases, Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) , Object type, Stored Procedures, Functions, Packages and Triggers, Dynamic SQL, Set transaction, pl/sql Cursor variables with Ref Cursor
  Excellent written and verbal communication skills