Hotfoot - SQL Developer - Database Design & Maintenance
3 weeks ago
Our team at Hotfoot Technology Solutions Private Limited is seeking a skilled and detail-oriented SQL Developer to design, develop, and maintain robust database solutions that support enterprise-level applications and reporting systems.The ideal candidate will be responsible for writing optimized SQL queries, developing stored procedures, creating views, and ensuring the security and integrity of data across platforms.Key Responsibilities :- Develop, test, and optimize SQL queries, stored procedures, functions, triggers, and views.- Design and maintain relational databases, ensuring data consistency, security, and performance.- Collaborate with application developers, business analysts, and data engineers to understand data requirements and translate them into scalable database solutions.- Perform database performance tuning and query optimization using indexing, execution plans, and refactoring techniques.- Design and implement data extraction, transformation, and loading (ETL) processes.- Ensure database security, backup, and disaster recovery procedures are in place.- Analyze existing SQL queries for performance improvements and suggest enhancements.- Create and maintain documentation including data dictionaries, ER diagrams, and system workflows.- Conduct unit testing and participate in code reviews and peer programming as needed.- Provide production support for database-related issues, ensuring minimal downtime.Technical Skills Required :- Strong proficiency in T-SQL / PL/SQL with experience in writing complex queries, joins, and procedures.- Hands-on experience with Microsoft SQL Server, MySQL, PostgreSQL, or Oracle databases.- Experience with ETL tools such as SSIS, Informatica, Talend, or custom scripting.- Understanding of data normalization, data modeling, and database architecture principles.- Experience with SQL Profiler, Execution Plans, and other performance monitoring tools.- Familiarity with version control systems (e.g., Git, SVN) and CI/CD processes for database deployments.- Knowledge of BI/reporting tools like Power BI, Tableau, or SSRS is a plus.- Exposure to cloud database platforms such as Azure SQL, Amazon RDS, or Google Cloud SQL is a plus.Skills :- Strong analytical and problem-solving skills with a keen attention to detail.- Ability to communicate clearly with both technical and non-technical stakeholders.- Excellent time management and task prioritization abilities.- Team player with a proactive and collaborative attitude.Educational Qualifications :- Bachelors degree in Computer Science, Information Technology, or a related field.- Certifications in SQL/database technologies (e.g., Microsoft Certified : Azure Data Fundamentals, Oracle Certified SQL Developer) are a plus (ref:hirist.tech)
-
Hotfoot - Java Developer - J2EE/Spring Boot
2 weeks ago
Chennai, India HOTFOOT TECHNOLOGY SOLUTIONS PRIVATE LIMITED Full timeAbout the Company : Hotfoot, a pioneering FinTech (Software Product), specializes in providing end-to-end digital transformation & Automation technology solutions to financial institutions. With a core philosophy that Productivity can be increased by automating predictable activities". Hotfoot leverages its expert team's extensive knowledge in financial...
-
Chennai, India HOTFOOT TECHNOLOGY SOLUTIONS PRIVATE LIMITED Full timeProfile Overview :Our Java Architect will play a key role in our product development by creating state of the art architecture, design and delivering exceptional code. The architect will lead the design and development of our platform and infrastructure, working on projects that will allow wearing many hats and flex both technical development and...
-
Hotfoot - Senior Business Analyst
4 weeks ago
Chennai, India HOTFOOT TECHNOLOGY SOLUTIONS PRIVATE LIMITED Full timeRoles And Responsibilities :- Manage the team for the Delivery and also have individual contribution for complex tasks.- Should be the escalation point for the customer and manage the customer experience.- Play a key role in bringing all stakeholders to same page and bring transparency in the process and highlight Project risks- Possess knowledge and be a...
-
Chennai, India HOTFOOT TECHNOLOGY SOLUTIONS PRIVATE LIMITED Full timeJob description :- The ideal candidate will design and develop a robust automation testing framework from scratch, incorporating architecture, reusable components, and best practices using a codeless automation tool.- They will develop and execute both automated and manual test cases to ensure comprehensive coverage of functional requirements.- Use of...
-
Sql database administrator
2 weeks ago
Chennai, India PayTabs Global Full timeSummaryWe are seeking a highly skilled and experienced DBA to join our expanding Information Technology team. In this role, you will help develop and design technology solutions that are scalable, relevant, and critical to our company’s success. You will join the team working on our new platform being built using MS SQL Server and MYSQL Server. You will...
-
Sql database administrator
2 weeks ago
Chennai, India PayTabs Global Full timeSummaryWe are seeking a highly skilled and experienced DBA to join our expanding Information Technology team. In this role, you will help develop and design technology solutions that are scalable, relevant, and critical to our company’s success. You will join the team working on our new platform being built using MS SQL Server and MYSQL Server. You will...
-
SQL Database Administrator
2 weeks ago
Chennai, India PayTabs Global Full timeSummary We are seeking a highly skilled and experienced DBA to join our expanding Information Technology team. In this role, you will help develop and design technology solutions that are scalable, relevant, and critical to our company’s success. You will join the team working on our new platform being built using MS SQL Server and MYSQL Server. You will...
-
SQL Database Administrator
2 weeks ago
Chennai, India PayTabs Global Full timeSummary We are seeking a highly skilled and experienced DBA to join our expanding Information Technology team. In this role, you will help develop and design technology solutions that are scalable, relevant, and critical to our company’s success. You will join the team working on our new platform being built using MS SQL Server and MYSQL Server. You will...
-
SQL Database Administrator
2 weeks ago
Chennai, India PayTabs Global Full timeSummary We are seeking a highly skilled and experienced DBA to join our expanding Information Technology team. In this role, you will help develop and design technology solutions that are scalable, relevant, and critical to our company’s success. You will join the team working on our new platform being built using MS SQL Server and MYSQL Server. You will...
-
SQL Database Administrator
2 weeks ago
Chennai, India PayTabs Global Full timeSummaryWe are seeking a highly skilled and experienced DBA to join our expanding Information Technology team. In this role, you will help develop and design technology solutions that are scalable, relevant, and critical to our company’s success. You will join the team working on our new platform being built using MS SQL Server and MYSQL Server. You will...
