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

 Exp in  product design and support experience
 Required Skills: Angular 11/12, .NET framework, .NET Core, Web APIs, Web Security,
Microservices, Event driven architecture, Clean Code and 12 Factor principles, Azure
PaaS services experience, public facing web application development, web analytics,
Bootstrap v5, Angular Material, jQuery, HTML/CSS, SQL Server, Transact-SQL, Azure
SQL
 Experience working with software design, software development life cycle, and
development methodologies and implementation
 Experience working with product systems design principles
 Experience working with appropriate programming languages, operating systems,
hardware and software
 Experience working with company application development policies and procedures
 Experience working with company software and hardware products and related
business issues that may impact overall business plans

What we are looking for?
● You have good understanding of the fundamentals of data science/algorithms or
software engineering
● Preferably you should have done some project or internship related to the field
● Knowledge of SQL is a plus
● A deep desire to learn new things and be a part of a vibrant start-up. You will
have a lot of freehand and this comes with immense responsibility - so it is
expected that you will be willing to master new things that come along!

What you will get to do?
● Build cloud-based services and/or user interfaces
● Participating in all aspects of software development activities, including design,
coding, code review, unit testing, bug fixing, and code/API documentation
● Be the first few members of a growing technology team

 

Desired Candidate Profile

What you need to have:

Very Good Expereince with Core Java or C#.
Hands on experience with Spring/Hibernate or .Net frame works.
Will have 3 months of training on ALM by the company.

• Expertise in Database Administration on Production Servers with server configuration, performance tuning, and maintenance with outstanding troubleshooting capabilities in Cloud – AWS / Azure.
• Efficient in Architecting, Configuring, Maintaining, Monitoring, Troubleshooting SQL Servers.
• Strong understanding of SQL database structures, principles, and practice
• Strong experience handling Backups, Restores, Corruption, and Disaster Recovery scenarios.
• Experience in installing and configuring SQL Server databases of different versions.
• Experience in Performance Tuning and Optimization, backups, restores, recovery models. Writing & optimizing SQL statements, partitioning, clustering, HA, DR. Experience in DMV & DDL queries.
• Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.
• Skilled in working with large volumes of data and loading data from multiple sources.
• Knowledge of reporting and query tools and practices.
• Knowledge of indexes, index management, and statistics.
• Skilled in deploying database change scripts
• Scheduling database backups, taking full and Transaction log backups.
• Automate SQL server tasks (SQL jobs, Windows scripts, etc.)
• Exposure to MySQL will be an added advantage.

Soft skills:

• Mission led. Someone who buys into the mission of a company and the problem they are solving. The company is growing fast and have a tonne of things they need to achieve; they want people that are bought in for the long term and believe in what they’re doing. 
• Pragmatic thinker. You have a structured approach to situations, if you do not know the answer, you’ll know how to find it out. 
• Open to change. You are able to work in a fast-paced environment where priorities can change instantly, and you are able to adjust. 
• Technologist. Someone that is passionate about what they do and experienced in server operating systems and application deployment, configuration, and maintenance. 
• Communication and Presentations skills.

Backend - Software Development Engineer-III

Responsibilities:-

• Research, design and build highly reliable, available and scalable platforms
• Explore design implications and work towards an appropriate balance between functionality, performance, and maintainability.
• Lead by example, mentor and guide team members on everything from structured problem solving to development of best practices
• Own large technical deliverables and execute in an exemplary way
• Be able to conceptualize and develop prototype quickly
• Working with a cross-discipline team of Design, Product, Data Science and Analytics team.
• Active participation in the hiring process to bring quality engineers in the team.

Requirements:-

• Strong proficiency in Javascript and TypeScript
• Strong proficiency of Node.js and frameworks available for it such as Express
• Strong understanding and experience of creating highly scalable and complex database design
• Good understanding of Data Modeling using RDBMS and NoSQL(Cassandra, MongoDB, ElasticSearch, Redis) data stores
• Strong problem-solving skills with a good understanding of data structures and algorithms
• Strong understanding of front-end technologies, such as HTML5, and CSS3
• User authentication and authorization between multiple systems, servers, and environments
• Experience of creating highly scalable, fault tolerant, resilient distributed systems
• Strong knowledge of creating scalable system design and good understanding of microservice based architectures
• Understanding of caching enabled, PubSub and event driven architectures
• Hands on experience and good knowledge of AWS services
• Understanding automated testing platforms like selenium and unit tests like Chai, Mocha, Jasmine etc
• Proficient understanding of code versioning tools, such as Git
• E/B.Tech/M.E./M.Tech/M.S.
• Curiosity to explore the cutting edge technologies and bake them in the products.
• Zeal and drive to take end to end ownership.
• 5+ years of experience in back end development preferably in microservice environment.

 

Our product is centered around lots of data being processed, ingested and read efficiently. The underlying systems need to provide capabilities update and ingest data on the order of billions of records on a daily basis. Complex analytics queries need to run on 10s of billions of rows where a single query that can potentially touch 100+ million rows needs to finish in interactive SLAs. All of this processing happens on data with several 100s of dimensions and tens of thousands of metrics.

This leads to a very interesting and challenging use case in the emerging field of large scale distributed HTAP, which is still not mature enough to provide a solution out of the box that works for our scale and SLAs. So, we are building a solution that can handle the complexity of our use case and scale to several trillions of rows. As a "Database Engineer", you will evolve, architect, build and scale the core data warehouse that sits at the heart of Clarisights enabling large scale distributed, interactive analytics on near realtime data.

What you'll do

- Understanding and gaining expertise in existing data warehouse.
- Use the above knowledge to identify gaps in the current system and formulate strategies around what can be done to fill them
- Avail KPIs around the data warehouse.
- Find solutions to evolve and scale the data warehouse. This will involve a lot of technical research, benchmarking and testing of existing and candidate replacement systems.
- Bulid from scratch all or parts of the data warehouse to improve the KPIs.
- Ensure the SLAs and SLOs of data warehouse, which will require assuming ownership and being oncall for the same.
- Gain deep understanding into Linux and understand concepts that drive performance characteristics like IO scheduling, paging, processing scheduling, CPU instruction pipelining etc.
- Adopt/build tooling and tune the systems to extract maximum performance out of the underlying hardware.
- Build wrappers/microservices for improving visibility, control, adoption and ease of use for the data warehouse.
- Build tooling and automation for monitoring, debugging and deployment of the warehouse.
- Contribute to open source database technologies that are used at or are potential candidates for use.

What you bring

We are looking for engineers with a strong passion for solving challenging engineering problems and a burning desire to learn and grow in a fast growing startup. This is not an easy gig, it will require strong technical chops and an insatiable curiosity to make things better. We need passionate and mature engineers who can do wonders with some mentoring and don't need to be managed.

- Distributed systems: You have a good understanding of general patterns of scaling and fault-tolerance in large scale distributed systems.
- Databases: You have a good understanding of database concepts like query optimization, indexing, transactions, sharding, replication etc.
- Data pipelines: You have a working knowledge of distributed data processing systems.
- Engineer at heart: You thrive on writing great code and have a strong appreciation for modular, testable and maintainable code, and make sure to document it. You have the ability to take new initiatives and questioning status quo.
- Passion & Drive to learn and excel: You believe in our vision. You drive the product for the better, always looking to improve things, and soon become the go-to person to talk to on something that you mastered along. You love dabbling in your own side-projects and learning new skills that are not necessarily part of your normal day job.
- Inquisitiveness: You are curious to know how different modules on our platform work. You are not afraid to venture into unknown territories of code. You ask questions.
- Ownership: You are your own manager. You have the ability to implement engineering tasks on your own without a need for micro-management and take responsibility for any task that has been assigned to you.
- Teamwork: You should be helpful and work well with teams. You’re probably someone who enjoys sharing knowledge with team-mates, asking for help when they need it.
- Open Source Contribution: Bonus.

We are looking for a Kentico CMS Developer with MVC framework experience. Please share your Profile and also expected CTC