Hotfoot - SQL Developer - Database Design & Maintenance

3 days ago


Chennai, India HOTFOOT TECHNOLOGY SOLUTIONS PRIVATE LIMITED Full time

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)



  • Chennai, India HOTFOOT TECHNOLOGY SOLUTIONS PRIVATE LIMITED Full time

    Profile 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...


  • Chennai, India HOTFOOT TECHNOLOGY SOLUTIONS PRIVATE LIMITED Full time

    Roles 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 time

    Job 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...


  • Chennai, Tamil Nadu, India Infotel UK Full time

    Role: SQL Database Administrator Location: Tata Ramanujan Intellion Park, Chennai. Full-time permanent role. Infotel India is a prominent player in digital transformation and IT Consultancy, specializing in tailor-made software solutions for various industries such as automotive, banking, aerospace, and public sectors. We pride ourselves on our ability to...


  • Chennai, India HOTFOOT TECHNOLOGY SOLUTIONS PRIVATE LIMITED Full time

    Job Title : Python DeveloperWe are looking for a skilled and passionate Python developer to join our development team.The ideal candidate will be responsible for designing, developing, and maintaining robust, scalable, and high-performance applications using Python.You will work closely with cross-functional teams to build backend systems, APIs, automation...


  • Chennai, India HOTFOOT TECHNOLOGY SOLUTIONS PRIVATE LIMITED Full time

    Hands-On | Micro Data Lakes | Enterprise Data Strategy.Are you a hands-on Data Architect who thrives on solving complex data problems across structured and unstructured sources? Do you enjoy designing micro data lakes and driving enterprise-wide data strategy? If so, we want to hear from you.What You Will Do : - Design and build micro data lakes tailored to...


  • Chennai, India HOTFOOT TECHNOLOGY SOLUTIONS PRIVATE LIMITED Full time

    Key Responsibilities :- Design and develop core server-side components for consumer-facing sites as well as back-end logistics.- Define and implement data flow/interactions across various business components.- Prototype new ideas.- Conduct code reviews, ensuring delivery of features/tasks at the highest quality within committed Skills : - Strong hands-on...


  • Chennai, India Infotel UK Full time

    Role: SQL Database Administrator Location: Tata Ramanujan Intellion Park, Chennai. Full-time permanent role. Smurk IT is the Indian branch of Infotel group. Founded more than 40 years ago, the Infotel group is a European key player in digital transformation and IT Consultancy. We are proud to be an innovation leader, specializing in bespoke software...

  • SQL - Dba

    2 weeks ago


    Chennai, India Kanini Software Solutions Full time

    Administer, develop, test, or demonstrate databases. Perform many related database functions across one or more teams or clients, including designing, implementing and maintaining new databases, backup/recovery and configuration management. Install database management systems (DBMS) and provide input for modification of procedures and documentation used for...

  • Servhigh Global

    6 days ago


    Chennai, India Servhigh Global Services Private Limited Full time

    Key Responsibilities :- Design, develop, and maintain complex database objects such as procedures, functions, packages, triggers, and views using PL/SQL.- Optimize SQL queries and database performance through advanced tuning techniques.- Develop and implement data models, ensuring scalability, integrity, and best practices in database design.- Work closely...