11+ SQL tuning Jobs in Bangalore (Bengaluru) | SQL tuning Job openings in Bangalore (Bengaluru)

Primary Responsibilities

• Architect and drive complex software performance improvement projects that mitigate the performance challenges of the product and establish new guidelines for future product features
• Work with the development team, and database administrators to analyze performance bottlenecks, make recommendations to address performance concerns, and co-design performance into new feature development
• Efficiently working with various profiling and monitoring tools to identify performance and concurrency bottlenecks, propose and implement optimizations to improve cloud product
• Review end-user usage patterns and customer logged performance defects and enhance performance test coverage based on gaps identified.
• Understand database internals, server and storage system design, application interactions with database queries and stored procedures and with other downstream systems
• Troubleshoot issues experienced by users and propose solutions

Basic Qualifications

• 8+ years of experience in implementing and driving software performance engineering projects and solutions. Advanced level experience with concurrency, multithreading, and distributed system architectures
• Experience analyzing performance bottlenecks with application code interfacing with databases using ORM Frameworks, cache layers, data storage, servers, networking, and database query protocols including developing stored procedures, SQL queries, and database applications
• Working knowledge of relational database internals (locking, consistency, replication, serialization, failover, recovery)
• Comfortable with Windows, SQL Server, .NET Framework/Core, GIT, Nuget, SPA, Modern UI Frameworks, ORM Framework NHibernate in terms of both tools and application development
• Passionate about finding software performance bottlenecks and optimizing code to produce a better customer experience
• Experience with APM (Application Performance Monitoring), RUM (Real User Monitoring), and other Dev tools used for Performance monitoring and analysis
• Experience with performance bottleneck analysis, system design for scaling

Sizzle is an exciting new startup that’s changing the world of gaming.  At Sizzle, we’re building AI to automate gaming highlights, directly from Twitch and YouTube streams. We’re looking for a superstar Python expert to help develop and deploy our AI pipeline. The main task will be deploying models and algorithms developed by our AI team, and keeping the daily production pipeline running. Our pipeline is centered around several microservices, all written in Python, that coordinate their actions through a database. We’re looking for developers with deep experience in Python including profiling and improving the performance of production code, multiprocessing / multithreading, and managing a pipeline that is constantly running. AI/ML experience is a plus, but not necessary. AWS / docker / CI/CD practices are also a plus. If you are a gamer or streamer, or enjoy watching video games and streams, that is also definitely a plus :-)

You will be responsible for:

• Building Python scripts to deploy our AI components into pipeline and production
• Developing logic to ensure multiple different AI components work together seamlessly through a microservices architecture
• Managing our daily pipeline on both on-premise servers and AWS
• Working closely with the AI engineering, backend and frontend teams

You should have the following qualities:

• Deep expertise in Python including:
• Multiprocessing / multithreaded applications
• Class-based inheritance and modules
• DB integration including pymongo and sqlalchemy (we have MongoDB and PostgreSQL databases on our backend)
• Understanding Python performance bottlenecks, and how to profile and improve the performance of production code including:
• Optimal multithreading / multiprocessing strategies
• Memory bottlenecks and other bottlenecks encountered with large datasets and use of numpy / opencv / image processing
• Experience in creating soft real-time processing tasks is a plus
• Expertise in Docker-based virtualization including:
• Creating & maintaining custom Docker images
• Deployment of Docker images on cloud and on-premise services
• Experience with maintaining cloud applications in AWS environments
• Experience in deploying machine learning algorithms into production (e.g. PyTorch, tensorflow, opencv, etc) is a plus
• Experience with image processing in python is a plus (e.g. openCV, Pillow, etc)
• Experience with running Nvidia GPU / CUDA-based tasks is a plus (Nvidia Triton, MLFlow)
• Knowledge of video file formats (mp4, mov, avi, etc.), encoding, compression, and using ffmpeg to perform common video processing tasks is a plus.
• Excited about working in a fast-changing startup environment
• Willingness to learn rapidly on the job, try different things, and deliver results
• Ideally a gamer or someone interested in watching gaming content online

Seniority: We are looking for a mid to senior level engineer

Salary: Will be commensurate with experience. 

Who Should Apply:

If you have the right experience, regardless of your seniority, please apply.

Work Experience:  4 years to 8 years

About Sizzle

Sizzle is building AI to automate gaming highlights, directly from Twitch and YouTube videos. Sizzle works with thousands of gaming streamers to automatically create highlights and social content for them. Sizzle is available at www.sizzle.gg. 

·      4+ years of experience as a Python Developer.

·      Good Understanding of Object-Oriented Concepts and Solid principles.

·      Good Understanding in Programming and analytical skills.

·      Should have hands on experience in AWS Cloud Service like S3, Lambda functions Knowledge. (Must Have)

·      Should have experience Working with large datasets (Must Have)

·      Proficient in using NumPy, Pandas. (Must Have)

·      Should have hands on experience on Mysql (Must Have)

·      Should have experience in debugging Python applications (Must have)

·      Knowledge of working on Flask.

·      Knowledge of object-relational mapping (ORM).

·      Able to integrate multiple data sources and databases into one system

·      Proficient understanding of code versioning tools such as Git, SVN

·      Strong at problem-solving and logical abilities

·      Sound knowledge of Front-end technologies like HTML5, CSS3, and JavaScript 

·      Strong commitment and desire to learn and grow.

Required Skills/Qualifications: 

∙         B.Tech/MCA in Comput

Required Skills/Qualifications: 

Any Backend Technology is acceptable

∙         B.Tech/MCA in Computer Science or equivalent with 1-3 years’ experience with server-side web application development.

∙         Extensive development experience using LAMP or MEAN stack, RESTful web services or Node.js, HTML and CSS.

∙         Good understanding of Data structures and Relational Databases like MySQL or NoSQL Databases like MongoDB.

∙         Experience working with services in AWS such as EC2, RDS, and ELBs and have knowledge of VPCs.

∙         Experience with server side and client side MVC frameworks, Kafka Ansilble,Jenkins.

∙         Exposure to Continuous Integration (CI) and Continuous Deployment (CD), automated testing and agile development methods.

∙         Understanding of Version Management Tools like GitHub.

er Science or equivalent with 1-3 years’ experience with server-side web application development.

∙         Extensive development experience using LAMP or MEAN stack, RESTful web services or Node.js, HTML and CSS.

∙         Good understanding of Data structures and Relational Databases like MySQL or NoSQL Databases like MongoDB.

∙         Experience working with services in AWS such as EC2, RDS, and ELBs and have knowledge of VPCs.

∙         Experience with server side and client side MVC frameworks, Kafka Ansilble,Jenkins.

∙         Exposure to Continuous Integration (CI) and Continuous Deployment (CD), automated testing and agile development methods.

∙         Understanding of Version Management Tools like GitHub.

Required Technical Skills: 

• Java (highly capable)
• SQL (highly capable)
• Strong knowledge of software best practices, build processes, IDEs, database tools (e.g. SQL Developer, SQL Management Studio)
• Strong knowledge of source code control systems (GIT)
• Confident with Windows, Linux, Unix operating systems including command line
• Working knowledge of JIRA

Beneficial Technical Skills: 

• .Net
• C 
• Javascript 
• Experience in test management and test execution
• Experience of Agile development methods

Additional Skills and Behaviour Required 

• Experience of full software development lifecycle
• Considers competing solutions and evaluates options to create the best outcome in all aspects of the role.
• Willingness to takes ownership of whole project and engineers assigned.
• Confident to make suggestions and recommendations for improvements.
• Excellent written and verbal communication skills and ability to build good rapport
• Fluency in English, both written and oral
• Collaborates with others to achieve objectives and ensure information flow
• Seeks assistance and feedback as appropriate 

Education 

• Bachelor's degree (or equivalent) in Computer Science or Engineering or other relevant discipline (MCA, MSc in Computer Science etc.)

• 2 - 7 years of experience in building applications using C++ programming language.
• Comfortable with core programming concepts and techniques (e.g. concurrency, memory management).
• Enjoys working with algorithms and data structures (e.g. trees, hash maps, queues).
• Strong in Data structure and good in problem solving.
• Strong debugging skills.
• Certifying the application – White box testing, black box testing.