Technical Writer

• Experience in Python
• Experience in any Framework like Django, and Flask.
• Primary and Secondary skills - Python, OOPs and Data Structure
• Good understanding of Rest Api 
• Familiarity with event-driven programming in Python 
• Good analytical and troubleshooting skills

Job Title: Database Administrator (PostgreSQL) 

Experience: 3 to 6 years 

Location: Gurgaon (Hybrid) 

Employment Type: Full-time 

Job Description: 

We are seeking a skilled Database Administrator (DBA) with expertise in PostgreSQL and strong RDBMS concepts. The ideal candidate will be responsible for database performance monitoring, optimization, automation, and interaction with development teams to support business requirements. 

Key Responsibilities: 

1. Database Administration & Management 

• Manage, configure, and maintain PostgreSQL databases ensuring high availability and reliability. 
• Implement Primary-Slave replication architecture and ensure smooth data synchronization. 
• Work with AWS RDS for PostgreSQL database hosting. 
• Automate database backups and manage release versions for database changes. 
• Implement point-in-time recovery (PITR) backups in AWS RDS to ensure data integrity and disaster recovery. 

2. Performance Monitoring & Optimization 

• Regularly monitor database health and performance metrics. 
• Analyze and optimize slow queries to enhance application performance. 
• Fine-tune database performance using configuration parameters, buffers, connections, Disk IOPs, and memory. 

3. SQL Development & Optimization 

• Write, optimize, and maintain stored procedures, SQL functions, and SQL Views. 
• Implement indexing strategies to improve query performance. 

4. Collaboration & Requirement Analysis 

• Work closely with application developers and business analysts to understand new product requirements. 
• Provide recommendations on database design and architecture for scalable solutions. 

5. Database Security & Compliance 

• Implement best practices for database security, access control, and data integrity. 
• Ensure compliance with data governance and security policies. 

6. Automation & Maintenance 

• Automate database maintenance tasks such as backups, indexing, and archiving. 
• Establish monitoring and alerting systems to proactively address database issues. 

Technical Expertise Required: 

• 3 to 6 years of experience as a Database Administrator (DBA). 
• Strong knowledge of PostgreSQL and RDBMS principles. 
• Experience in writing stored procedures, SQL functions, and SQL Views. 
• Hands-on experience in query optimization and performance tuning. 
• Understanding of Primary-Slave architecture and replication setup. 
• Knowledge of database configuration tuning (buffers, connections, Disk IOPs, Memory, etc.). 
• Experience in automating database backups and version control for DB changes. 
• Familiarity with AWS RDS for PostgreSQL and point-in-time backup (PITR). 
• Experience in cloud-based database solutions (AWS RDS, Azure, GCP). 
• Strong problem-solving and analytical skills. 

Preferred Qualifications: 

• Experience in high-availability solutions and disaster recovery strategies. 
• Exposure to NoSQL databases is a plus. 
• Experience with database migrations and upgrades. 

● In-depth knowledge of full-stack development principles and best practices.

● Expertise in building web applications with strong proficiency in languages like Node.js, React, and Go. 

● Experience developing and consuming RESTful and gRPC API Protocols.

● Familiarity with CI/CD workflows and DevOps processes. 

● Solid understanding of cloud platforms and container orchestration technologies.

● Experience with Kubernetes deployment and workflows using tools like Argo.

● Experience applying AI/ML models to optimize workflows or enhance product features, with familiarity in frameworks like TensorFlow, MLflow, Kubeflow, or PyTorch. 

● Experience fine-tuning existing AI/ML models to adapt to specific use cases or datasets, ensuring optimized performance. 

● Experience with Workflow Orchestration tools like Temporal and Windmill.

● Strong background in System Design. 

● Hands-on experience with Queuing Mechanisms such as RabbitMQ, Redis, and Kafka. 

● Experience with designing and building user-friendly interfaces using Tailwind CSS and Radix UI. 

● Excellent understanding of distributed systems, databases, and APIs. ● A passion for writing clean, maintainable, and well-documented code. ● Strong problem-solving skills and the ability to work independently as well as collaboratively. 

● Excellent communication and interpersonal skills. 

Bonus points if you have: 

● Experience with building self-serve platforms or user onboarding experiences.

● Familiarity with Infrastructure as Code (IaC) tools like Terraform.

● A strong understanding of security best practices for Kubernetes deployments.

● Grasp on setting up Network Architecture for distributed systems. 

Detailed Job Description / Essential Duties and Responsibilities:

The role requires deep expertise in delivering modern web application solutions on the Open Source Tech platform, as well as ability to communicate how these solutions drive business value. Detailed responsibilities include -

• Lead Engineering team and ensure customer requirements and needs across the current and future targeted segments are met.
• Work with Product Owner / US counter parts / SME’s to understand the requirements and prioritize development efforts.
• Work in capacity of Scrum Master role and manage development through Agile - Scrum framework. Activities include Sprint planning, Preside Scrum meetings, Sprint Retrospective, Publish reports, etc.
• Responsible for creating User stories, Epics in Project management tool based on the requirements received from various stakeholders including clients.
• Manage all aspects of engineering operations including Product Design, Development, Testing and Deployment.
• Architect the applications / providing recommendations to choose the right technologies for the products to be built.
• Manage Operational efforts for the contracted clients and ensure the SLA’s with required quality are met.
• Manage Product support team and ensure the SLA’s for response and resolutions are provided to client that meets or exceeds the customer’s expectations.
• Build / Guide Developers in building Full-Stack Web applications at Internet scale.
• Code Review and provide feedback to ensure timely delivery with required quality.
• Programming in MEAN stack or similar open source technologies and framework
• Data Modelling using NoSQL and Relational Database management Systems
• UI / UX Design and Implementation
• Web Development with BootStrap, Angular Material, and other libraries
• Develop Data / File parsing programs using Python or other programming languages
• Create methods and algorithms for data analysis and optimization
• Develop curriculum for talent development, Knowledge Sharing, etc.
• Establish and maintain cooperative working relationships with all stakeholders involved.
• Willing, capable and excited to roll up the sleeves to code when needed.
• Having exceptional expertise in one of the following areas –
  • Backend / Front end Web Application Framework
  • Serverless Architecture
  • Micro Services Platforms
  • AWS Services