PHP Developer

Who are we :

Trendlyne is a funded, profitable products startup in the financial markets space. We have cutting-edge analytics products built for Indian and US customers, for stock markets and mutual funds.

Our founders are IIT + IIM graduates, with strong tech and marketing experience. We have top finance and management experts on the Board of Directors.

What do we do :

We build powerful analytics in the US and Indian stock market space that are best in class. Organic growth in B2B and B2C products has already made the company profitable. We deliver 1 billion+ APIs every month to B2B customers, and have a B2C website and app.

Tech Stack :

• Python (Django / Flask / FastAPI)
• PostgreSQL / MySQL
• Redis / caching systems
• REST APIs

Job Responsibilities :

• Develop and maintain scalable, robust backend systems using Python frameworks.
• Work closely with product managers and other cross-functional teams to help define, scope, and deliver world-class products and high-quality features addressing key user needs.
• Translate requirements into system architecture and implement code while considering performance issues of dealing with billions of rows of data and serving millions of API requests every hour.
• Ability to take full ownership of the software development lifecycle from requirement to release.
• Writing and maintaining clear technical documentation enabling other engineers to step in and deliver efficiently.
• Embrace design and code reviews to deliver quality code.
• Play a key role in taking Trendlyne to the next level as a world-class engineering team.
• Develop and iterate on best practices for the development team, ensuring adherence through code reviews.
• As part of the core team, you will be working on cutting-edge technologies like AI products, online backtesting, data visualization, and machine learning.
• Proficient understanding of the performance of web and mobile applications.

Job Requirements :

• 1+ years of experience with Python and Django / Flask / FastAPI.
• Good knowledge of APIs, databases, and system performance.
• Strong understanding of relational databases like PostgreSQL or MySQL and Redis.
• Ownership mindset: you build it, ship it, and take responsibility for it in production.
• Strong communication skills: ability to articulate technical decisions clearly to both engineers and non-technical stakeholders.
• Bonus: Familiarity with JavaScript, HTML, or CSS is a plus but not required.

Roles and Responsibilities:

1.Build high-performance applications by writing testable, reusable, and efficient code.
2. Strong knowledge in Nodejs, Javascript & Typescript

3.Develop and maintain all server-side components.

4.Develop high-performance and scalable APIs to serve clients.

5.Collaborate with front-end developers on the integration of well written APIs.

6.Implement effective security protocols, data protection measures, and storage solutions.

7.Investigate issues by reviewing/debugging code, provide fixes and workarounds, and review changes for operability to maintain existing software solutions.

8.Develop and manage well-functioning databases and applications

9.Run diagnostic tests, repairing defects, and provide technical support.

10.Be our NodeJS champion by keeping an eye out for emerging technologies and recommending improvements.

11. You will work within a team, collaborate and add value through participation in peer code reviews, provide comments and suggestions, and work with cross functional teams to achieve goals.

12. Design back end services for various business processes

13. You will assume technical accountability for your specific work products within an application and provide technical support during solution design for new requirements.

14. Design server side architecture

• 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

• 2+ years of experience on Java, Spring Boot, Hibernate in medium to large-scale projects
• Must have experience with at least some flavours of both SQL (MySQL, Postgres) and NoSQL (Kafka, MongoDB, ElasticSearch, NoSQL distributed cache system, DynamoDB etc), datastores in production
• Must have experience with Kafka or similar message queue systems in production
• Stellar problem solving skills
• Hunger to learn new things and ability to grasp new concepts quickly
• Ability to move quickly without breaking things too much (we are dreamers)
• Ability to work under immense pressure which is balanced by a sense of responsibility and ownership
• Should be able to groom juniors and take them to the next level