Asp.net Developer

Job description

• Database Design & Development:
• Design, implement, and maintain PostgreSQL databases.
• Develop efficient schemas, indexes, and stored procedures to optimize data performance.
• Backend Development:
• Develop RESTful APIs and backend services using Node.js.
• Integrate databases with backend applications for seamless data flow.
• Query Optimization & Performance Tuning:
• Optimize SQL queries for performance and scalability.
• Monitor database health and troubleshoot slow queries or deadlocks.
• Security & Compliance:
• Implement database security best practices, including role-based access control (RBAC) and encryption.
• Ensure compliance with industry standards like GDPR, HIPAA, etc.
• Data Migration & Backup:
• Develop and maintain data migration scripts between different PostgreSQL versions or other databases like mongodb.
• Set up and manage database backup and recovery strategies.
• Write efficient SQL queries and manage database schemas using PostgreSQL.
• Build RESTful APIs and integrate third-party APIs/services.
• Optimize application performance and troubleshoot production issues.
• Ensure data security and protection practices are followed.
• Write clean, maintainable code and participate in code reviews.

Developer Requirements/Expectations:

• Experience: 5+ Years
• Tech Stack: Core PHP, MySQL, Basic JavaScript, Oracle
• 3rd Party Integration: Payment Gateways (Apple Pay Wallet, Google Pay, Stripe)
• Tools: Trello, Slack, Github
• Soft Skills: Team Work, Excellent Client Communication. 

Engagement Type: Full Time, Dedicated

• Work Hours: 8 Hours per day, 160 hours per month
• Shift: 10 AM-7 AM IST (Including Lunch hour)
• Work shifts need to be flexible to accommodate client calls in EST.

Screening Process: 

Round 1: Technical 

Round 2: Managerial 

Location: Ahmedabad (Hybrid)

About this roleWe are seeking an experienced MongoDB Developer/DBA who will be

responsible for maintaining MongoDB databases while optimizing performance, security, and

the availability of MongoDB clusters. As a key member of our team, you’ll play a crucial role in

ensuring our data infrastructure runs smoothly.

You'll have the following responsibilities

 Maintain and Configure MongoDB Instances - Responsible for build, design, deploy,

maintain, and lead the MongoDB Atlas infrastructure. Keep clear documentation of the

database setup and architecture.

 Ownership of governance, defining and enforcing policies in MongoDB Atlas.Provide

consultancy in drawing the design and infrastructure (MongoDB Atlas) for use case.

 Service and Governance wrap will be in place to restrict over provisioning for server size,

number of clusters per project and scaling through MongoDB Atlas

 Gathering and documenting detailed business requirements applicable to the data

layer.Responsible for designing, configuring and managing MongoDB on Atlas.

 Design, develop, test, document, and deploy high-quality technical solutions on the

MongoDB Atlas platform based on industry best practices to solve business needs.

Resolves technical issues raised by the team and/or customer and manages escalations as

required.

 Migrate data from on-premise MongoDB and RDBMS to MongoDB AtlasCommunicate

and collaborate with other technical resources and customers in providing timely updates

on status of deliverables, shedding light on technical issues, and obtaining buy-in on

creative solutions.

 Write procedures for backup and disaster recovery.

You'll have the following skills & experience

 Excellent analytical, diagnostic skills, and problem-solving skills

 Should understand the Database concept and develop expertise in designing and

developing NoSQL databases such as MongoDB

 MongoDB query operation, import and export operation in database

 Experience in ETL methodology for performing Data Migration, Extraction,

Transformation, Data Profiling and Loading

 Migrating database by ETL, migrating database by manual process and designing,

development, implementation

 General networking skills, especially in the context of a public cloud (e.g. AWS – VPC,

subnets, routing tables, nat / internet gateways, dns, security groups)

 Experience using Terraform as an IaC tool for setting up infrastructure on AWS

CloudPerforming database backups and recovery

 Competence in at least one of the following languages (in no particular order): Java, C++,

C#, Python, Node.js (JavaScript), Ruby, Perl, Scala, Go

 Excellent communication skills, often being able to compromise but draw out risks and

constraints associated with solutions. Be able to work independently and collaborate with

other teams

 Proficiency in configuring schema and MongoDB data modeling.

 Strong understanding of SQL and NoSQL databases.

 Comfortable with MongoDB syntax.

 Experience with database security management.

 Performance Optimization - Ensure databases achieve maximum performance and

availability. Design effective indexing strategies.

• Participate in brainstorming and technical ideation for projects with product, growth, and engineering
• You will design Scalable and Fault-Tolerant systems
• You will help Maintain critical and auxiliary systems (databases, cache ...)
• You will build Experiments that help validate hypotheses for the product

Experience:

2+yrs In your first 3 months, you will…

• Successfully onboard and create strong bonds with the current team
• Participate in brainstorming and technical ideation for projects with product, growth, and engineering
• Contribute to existing product features and experimentation

In your first 6 months, you will…

• Develop prototypes of new features or products using rapid iteration and experimentation as we explore new ideas
• Partner across the engineering team to ship features

In your first year, you will...

• Champion best-in-class engineering practices and systems for an emerging engineer team
• Help build a suite of features for the product

Our Ideal Hire:

• Learned best practices and has experienced the challenges and joys working at a startup
• Managed and maintained production code at increasing scales
• Feels strongly motivated by our mission
• Communicates complex problems and proposes solutions, in writing and in conversation

Expertise:

• Proficiency in any one language (ex: NodeJS / Go / Python)
• MySQL (design / indices / optimizing queries)
• Redis (types/ functionality/ use cases)

Hands-on experience:

• Handled scaling issue
• Good at debugging

Good to have:

• Kafka (or other stream-processing software)
• AWS

Do not apply if you are not:

• Ownership driven
• Curious in general
• Able to explain things in simple terms
• Self-motivated
• Use to work in the chaotic environment
• Highly proactive
• Willing to Mentor and humble to ask for collaboration
• Most important, Learn & Grow yourself!
• Hungry to grow anymore