Hotfoot - Senior Database Developer (5-7 yrs)

About the job :

- Develop and maintain high-quality, enterprise-grade software using Agile methodology.

- Optimize database (DB) performance and scalability by tuning DBs, schemas, and queries.

- Experience as a DB programmer or DBA in product development.

- Ability to design and implement data domains for transactional systems and Data warehouses

- Design and implement creative solutions based on requirements.

- Collaborate with peer teams to ensure that applications are written for optimal system performance.

- Assist with performance tuning and optimization.

- Develop and execute unit tests for product components.

- Perform peer code reviews and provide feedback.

- Promote high quality, scalability, and timely completion of projects.

Required Skills :

- Minimum qualification - Bachelor's degree in Engineering or Computer Applications

- Proven experience in data engineering, warehousing and ETL processes

- Experience in building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexes, and other database components

- Experience in SQL queries troubleshooting, debugging Stored procedures, identifying Blocking sessions in backend, complex joins etc.

- Experience in database security, data residency and data portability concepts

- Should possess sound knowledge on any job scheduling tool, Control M.

- Experience with PL/SQL, DDL, DML, SQL queries

- Experience with Oracle, PostgreSQL, MySQL, MS SQL, Redshift and/or other RDBMS system

- Experience in UNIX shell

- At least one procedural language such as Python, Java etc.

- Demonstrated ability to design, implement and maintain highly scalable and efficient data systems

- Exposure to Fintech domain is preferred(not compulsory)

- At Least 5 years of experience in the above