Best Opportunity for Experienced Professionals
Role/Position - SQL DB Dev Analyst
Job Description
Proven work experience of 8+ years as a database developer.
In depth understanding of data management (e.g. permissions, recovery, security and monitoring)
Hands on experience with MS SQL Server.
Developed and maintained various T-SQL stored procedures for different applications, reports and agent jobs.
Worked with DB administrator to provide overall performance tuning of Database System which include applying Indexes and refining stored procedure.
Completed the conversion of various legacy DB applications.
Design, code, test and debug business logic for software applications using T-SQL per defined technical specifications.
Excellent analytical and organization skills.
Knowledge of software development and user interface web applications.
An ability to understand front-end user requirements and problem-solving attitude.
Should have excellent analytical and communication skills.
Qualifications
· B.E. / B.Tech. /MSC in Computer Science or IT.
Additional information Responsibilities:
· Maximize system efficiency by regularly tuning and optimizing stored procedures.
· Able to perform data analysis to clean up data, creating queries and automation routines.
· Translate use cases into functional applications
· Ensure the best possible performance, quality and responsiveness of applications.
· Help maintain code quality
· Able to work well in a team setting.
Notice Period - 15 days
Salary Package - Open

Similar jobs
Responsibilities
- Build reusable code and libraries for future use.
- Writing reusable, testable, and efficient code
- Own & build new modules/features end-to-end independently.
- Collaborate with other team members and stakeholders.
- Work in an agile environment to rapidly build high-quality and robust features.
- Participate in DevOps.
- Implementation of security and data protection.
Required Skills
- Master in Node.js and frameworks available for it. (Nest.js / Loopback / AdonisJS)
- Excellent understanding of ES6 and OOP.
- Good understanding of SQL & No-SQL Databases. (MySQL / PostgreSQL)
- Understanding the nature of asynchronous programming and its quirks and workarounds.
- Open Source and DevOps enthusiast.
- Comfortable with Test Driven Development.
- Can learn and adapt fast, as well as identify and solve problems.
Bonus Skills
- Hands-on with TypeScript
Job Perks
- Get to work with a highly passionate team of engineers.
- Open and embracing culture towards the latest hot technologies.
- A high level of freedom & responsibility.

Location: Chennai, Pune,Banglore,jaipurExp: 5 yrs to 8 yrs
- Implement best practices for the engineering team across code hygiene, overall architecture design, testing, and deployment activities
- Drive technical decisions for building data pipelines, data lakes, and analyst access.
- Act as a leader within the engineering team, providing support and mentorship for teammates across functions
- Bachelor’s Degree in Computer Science or equivalent job experience
- Experienced developer in large data environments
- Experience using Git productively in a team environment
- Experience with Docker
- Experience with Amazon Web Services
- Ability to sit with business or technical SMEs to listen, learn and propose technical solutions to business problems
· Experience using and adapting to new technologies
· Take and understand business requirements and goals
· Work collaboratively with project managers and stakeholders to make sure that all aspects of the project are delivered as planned
· Strong SQL skills with MySQL or PostgreSQL
- Experience with non-relational databases and their role in web architectures desired
Knowledge and Experience:
- Good experience with Elixir and functional programming a plus
- Several years of python experience
- Excellent analytical and problem-solving skills
- Excellent organizational skills
Proven verbal and written cross-department and customer communication skills
Strong fundamentals in OOPS, RDBMS, Data structures, and Design patterns
Experience in any SQL database (Preferably SQL Server)
Ability to write clean code
Ability to write automated unit tests using frameworks such as NUnit, Mock, etc.
Ability to communicate and articulate clearly and work collaboratively in an agile team
Experience with code repositories like git
Ability to communicate and articulate clearly and work collaboratively in an agile team
The key aspects of this role:
- Candidate with exceptional programming skills, problem-solving abilities and strong work ethic.
- The candidate has to work on custom programming and web application development for Drupal.
- Testing, maintenance and troubleshooting of existing company sites and resolving issues if any.
- Contributing ideas and efforts towards internal projects and working as part of a team to find solutions on various problems.
- Communicate technical ideas to business users and other teams (design, QA). • Collaborate with team members and to work independently when needed. • Eager to embrace current and emerging web technologies.
To be the right fit, you'll need:
- Experience of total 4+ years working on PHP and Drupal 7,8 Development (at least 2+ years in Drupal 8)
- Strong knowledge of MySQL, jQuery, HTML5, CSS
- Experience with Drupal architecture, best practices and coding standards
- Knowledge on Views, Services etc.
- Experience in custom module and theme creation
- Familiar with sub version control systems such as Git or SVN
- Basic knowledge of environment setup for Linux distribution
Minimum of 4+ years of experience in Java development
- Experience delivering Services (REST, SOAP) and Web applications in Micro services architecture
- Experience developing and deploying Java solutions to cloud
- Experience in Spring Boot and components of Spring framework
- Experience in a JavaScript framework such as Angular or React
- Experience in TDD using Junit or similar frameworks
· Experience in Design Patterns and service oriented architectural principles, Data structures and Algorithms.
· Individual should be an active participant in the product design and code reviews for self and team and can competently review any aspect of their product or major sub-system.
· Experience in SQL, Unix skills.
· Good communication Skill
Job Responsibilities:
• Design and build efficient, scalable systems that are used by millions of people,
• Own what you build as you create, test, and refine what’s under the hood of our pages and services,
• Investigate production issues pertaining to customer features to determine root cause and implement solutions,
• Investigate existing queries and write new queries with performance optimization in mind,
• Build well-designed software in a way that is generic, reusable, and easily extensible, as well as solves the business needs and requirements,
• Collaborate with product managers, designers, and software engineers to ensure design vision is maintained, the final markup is standards compliant, and UI deliverables are completed on time,
• Work with the real-time feedback from our users (external and internal) to make the products better,
• Discover, design, develop, deploy, debug. Repeat!
Requirements:
• 1-2 years of experience,
• Proficiency in web scripting programming with PHP,
• Experience with MySQL Databases,
• Top-notch programming skills in JavaScript and a strong understanding of web fundamentals,
• Design, build and maintain high performance, scalable and secure code,
• Experience with cloud services like AWS is plus,
• Experience with MVC architecture is a plus,
• Knowledge / experience in building an API,
• Solid understanding of the foundations of security and best practices,
• Good grasp of data structures and algorithms,
• Excellent problem-solving skills,
• Take ownership of the backend services, ensure the best possible performance, quality and responsiveness, as well as maintaining code quality, organisation and testing/deployment,
• Passionate about technology and willing to develop expertise in an emerging field,
• Strong organisational and communication skills, team player.
Perquisites & Benefits:
• A competitive salary,
• Opportunity to be part of a diverse working environment, valuable social sector work experience,
• Fun, casual, relaxed and flexible work environment.
- Experience in Microsoft ASP, C#, SQL server, and github.
- Experience with software design and development in a test-driven environment.
- Experience with databases.
- Ability to learn new languages and technologies.
- Good communication skills.
- 1.5+ Years of experience in .net, asp.net and C#, WCF/API and REST services.
- Hands on experience with CSS, Javascript and JQuery.
- Strong knowledge in OOPS concepts.
- Knowledge of T SQL with Sql server 2008 R2/2012 including Stored Procedures, Triggers & User Defined Functions.
- Good to have CSS3 and HTML5 knowledge.
- Good communication Skills are required.
• Build data pipelines for structured/unstructured, real-time/batch, events/synchronous/asynchronous using MQ, Kafka, Steam processing using Java / Python
• Design the Data stores for Big Data systems with expertise in Cassandra, HBase
• Implementation of Indexing and Search using Elasticsearch
• Setup and Deployment of Cassandra, Elasticsearch clusters
Required Qualifications and Competencies:
• Strong hands-on experience with Cassandra, data modeling, data replication, clustering, indexing for handling for large data sets
• Experience with SQL, NoSQL, relational database design, and methods for efficiently retrieving data for Time Series Analytics
• Strong understanding of CQL, Data Modeling in-order to achieve highly performant data access
• Strong experience in data modeling in Cassandra to design efficient storage model to meet variety of business needs
• Should have Elasticsearch skill with significant experience working with large Elasticsearch clusters, cluster performance optimisation, capacity planning, enhancing monitoring capabilities for early issue detection, driving operational readiness and ongoing maintenance
• Strong hands-on experience of programming with Java / Python
• Ability to troubleshoot and investigate stability, performance issues








