We invite a Software Engineer with experience in SQL to join our team and become a part of Xenial — a product with over 100,000 software installations and global reach in the quick restaurant industry. You’ll be involved in the development of new features, helping the team to build real-time analytics in a high-loaded environment. What’s in it for you:
• Work with various AWS components (Redshift, ECS, EC2, S3, DynamoDB) and discover its action principles
• Expand your expertise: improve your skills in Python, JS, and CI/CD
• Contribute to the development of a high-volume product that processes a million transactions daily
• At least 4 years’ experience in database development
• Experience with Redshift or MS SQL or PostgreSQL
• Experience with SSRS or other reporting systems (Crystal Reports, Pentaho, Cognos Reports, etc.)
• Basic understanding of MongoDB or other NoSQL databases like DynamoDB or Redis with the ability to write simple queries
• Upper-intermediate English
• Strong capabilities for tuning queries and reports
• Ability to work with developers to build optimal database structure
• Experience in designing, building, installing, configuring, supporting, and maintaining a high-volume, large database system
• Experience with ETL processes and tools (Matillion, Data Stage, Informatica, etc.)
• Basic knowledge of Python or JS
• Experience in communicating with clients
• Implement and manage database objects, tables, materialized views required to support new Business features or internal processes
• Produce performance analysis against database objects using native monitoring and troubleshooting tools to speed up SQL query executions.
• Analyze and remediate bad database security practice related to SQL injections for Reports executions, handling PII data in SQL queries, etc.
• Modify the database structure as necessary based on regular analysis
• Execute performance tuning of database systems
• Diagnose and troubleshoot database errors, create automation for repeating database tasks
• Develop new system functionality and introduce changes to existing functionality
✅ Professional and personal growth: ability to shift your career path, access to English courses, online training programs, webinars, workshops.
✅ Healthcare: healthcare medical insurance and healthcare kit (gym, sports nutrition etc.)
✅ Fun online activities and team-building events
✅
Dev.Pro is a US-based outsource company of people who values high ethical standards and delivers superior software products since 2011. A rapid growth of the company brings more development opportunities for our specialists, which is a key to delivering an exceptional experience to our clients.