Human Resource Executive

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. 

Job Description:

As a WordPress and PHP Developer , you will play a pivotal role in designing, developing, and maintaining high-quality websites and web applications for Texila. You will collaborate with cross-functional teams to ensure projects are delivered on time and exceed expectations. Your expertise in WordPress and PHP will be crucial in implementing robust, scalable, and secure solutions.

PHP and WordPress Developer Responsibilities:

Collaborate with the UI/UX and internal teams to develop custom WordPress themes, plugins, and functionality that align with project requirements.

Write efficient, maintainable, and secure PHP code for both front-end and backend development.

Customize and extend existing WordPress themes and plugins to meet needs.

Integrate third-party APIs and services to enhance website functionality and user experience.

Optimize websites for speed, performance, and SEO, and ensure they are responsive across different devices.

Troubleshoot and resolve issues related to WordPress, PHP, and other web technologies.

Stay up-to-date with the latest industry trends, technologies, and best practices in WordPress and PHP development.

Participate in code reviews, provide constructive feedback, and maintain coding standards within the team.

Collaborate with other developers, designers, and stakeholders to deliver high-quality projects on time.

Requirements:

WordPress developers with strong hold PHP development experience.

Bachelor’s degree in computer science or a similar field.

Proven work experience (6+ YEARS) as a WordPress developer and PHP.

Knowledge of front-end technologies including CSS3, JavaScript, HTML5, and jQuery.

Knowledge of code versioning tools 

Experience working with debugging tools such as Chrome Inspector and Firebug.

Good understanding of website architecture and aesthetics.

Ability to manage projects and meet timelines 

Location: Coimbatore

Experience: 1 to 2 years

Qualification: Degree in Design or Design Certification Course

Job Description: Designing of Catalogue, Marketing Collaterals, Product Design, and Social Media post

Key Skills: Photoshop, illustrator

Responsibilities

• Developing new user-facing features using React.js
• Building reusable components and front-end libraries for future use
• Translating designs and wireframes into high-quality code
• Optimizing components for maximum performance across a vast array of web-capable devices and browsers

Skills:

• Strong proficiency in JavaScript, including DOM manipulation and the JavaScript object model
• Thorough understanding of React.js and its core principles
• Experience with popular React.js workflows (Redux)
• Familiarity with newer specifications of ECMAScript
• Experience with data structure libraries (e.g., Immutable.js)
• Knowledge of isomorphic React is a plus
• Familiarity with RESTful APIs
• Knowledge of modern authorization mechanisms, such as JSON Web Token
• Familiarity with modern front-end build pipelines and tools
• Ability to understand business requirements and translate them into technical requirements
• A knack for benchmarking and optimization
• Familiarity with code versioning tools (such as Git, SVN, and Mercurial)

Responsibilities:

• Work with development teams and product managers to ideate scalable software solutions
• Design client-side and server-side architecture
• Design, develop and manage well-functioning databases and applications
• Develop web applications implementing MVT architecture using Django web application frameworks
• Write effective APIs using industry standard design patterns
• Manage the complete software development process from conception to deployment
• Maintaining and upgrading the software following deployment
• Should be able to visualize a proposed system and be able to build it
• Development of applications leveraging Django/Flask based REST APIs

• Work with server-side technologies including databases and MVC/MVT patterns
• Maintain version control system such as GIT
• Should know all the phases of SDLC from requirement gathering to support and maintenance.

Requirements:

• 3-7 years provable experience as a Back End Developer
• Familiarity with common solution stacks 
• Strong understanding of algorithms, data structures and system design, for scale, performance and security
• Ability to develop back-end website applications
• Knowledge of middleware languages (Python – Flask/Django) and/or JavaScript framework like Node.js
• Familiarity with databases (RDBMS – MySQL/PostgreSQL, optionally NoSQL DBs like MongoDB), web servers (Apache) and UI/UX design
• Great attention to detail
• Organizational skills
• An analytical mind
• Degree in Computer Science or relevant field

• • Key Result Areas
  
  
  1. Develop and lead desktop and mobile web Back end development. 
  2. Work on Node JS platform.
  3. Strong focus on UI Performance: optimize page load, rendering, caching, leveraging CDNs.
•  
  1. Technology Skills:
  
  
  • Advanced Javascript, CSS, HTML 5, D/XHTML, XML, JSON, DOM Concepts
  • Must have worked on a SPA frameworks:Nodejs, AngularJS or InfernoJS
  • Familiarity with common Javascript Libraries such as jQuery.
  • Fluent in responsive design and mobile / tablet UI / UX
  • Knowledge about UI testing automation
  • Web mobile (touch devices: mobiles and tablets) experience is expected
  • UI or API Performance: should have hands-on experience of optimizing page load, rendering,caching.
  • Good understanding of AJAX and its UI implications
  • Sense for appeal & aesthetics from a usability perspective

• Extract and present valuable information from data
• Understand business requirements and generate insights
• Build mathematical models, validate and work with them
• Explain complex topics tailored to the audience
• Validate and follow up on results
• Work with large and complex data sets
• Establish priorities with clear goals and responsibilities to achieve a high level of performance.
• Work in an agile and iterative manner on solving problems
• Evaluate different options proactively and the ability to solve problems in an innovative way. Develop new solutions or combine existing methods to create new approaches.
• Good understanding of Digital & analytics
• Strong communication skills, orally and in writing