Database Expert

Overview

Adesso India specialises in optimization of core business processes for organizations. Our focus is on providing state-of-the-art solutions that streamline operations and elevate productivity to new heights.

Comprised of a team of industry experts and experienced technology professionals, we ensure that our software development and implementations are reliable, robust, and seamlessly integrated with the latest technologies. By leveraging our extensive knowledge and skills, we empower businesses to achieve their objectives efficiently and effectively.

Job Description

We are looking for an experienced Backend Developer with expertise in C#, MS-SQL, and RESTful API development. As a Mid-Senior Backend Developer, you will play a vital role in designing, building, and maintaining robust backend systems to support our applications. This position offers the opportunity to work on complex backend services, collaborating closely with cross-functional teams to drive successful project delivery.

Responsibilities:

Design, develop, and maintain backend services and APIs using C# and MS-SQL.

Create and manage efficient RESTful APIs to enable seamless integration with frontend applications.

Work closely with frontend developers, product managers, and stakeholders to ensure effective communication and alignment on project requirements.

Troubleshoot, debug, and optimize backend applications for maximum performance, reliability, and scalability.

Document code and workflows, adhering to best practices and coding standards.

Requirements:

Minimum of 4-6 years of experience in backend development, with strong expertise in C# and MS-SQL.

Proficient in designing and implementing RESTful APIs for web and mobile applications.

Strong knowledge of database design, querying, and optimization with MS-SQL.

Excellent communication skills to effectively collaborate with team members and stakeholders.

Nice-to-Have:

Experience working with Content Management Systems (CMS), especially Optimizely.

Familiarity with web development concepts and integration with frontend framework

Knowledge of agile methodologies and working in cross-functional, collaborative teams.

Skills & Requirements

C#, MS-SQL, RESTful API development, Backend services, Database design, Querying, Optimization, Debugging, Troubleshooting, Scalability, CMS, Optimizely, Web development, Frontend integration, Agile methodologies, Collaboration.

• Design, develop, test, deploy, maintain, and improve software and new user-facing features across Novo’s products and services.
• Drive technical decisions on a multi-functional, Agile team alongside product management, product design, and engineering.
• Optimize applications for maximum speed and scalability and analyze feedback from customers and internal teams to identify issues and improvement opportunities. 
• Champion a passion for engineering best practices such as code quality, linting, and testing.
• Ensure our software is reliable, extensible, maintainable, debuggable, secure, well-tested and performs well under load.
• Mentor junior engineers in all aspects of planning, development and testing.
• Stay engaged with latest technologies and evaluate strategies to keep the Novo technology stack up to date.

• 5+ years experience in a highly technical role at a hyper-growth startup or fast-paced company.
• Extensive background designing, developing, testing, deploying, maintaining, and improving software.
• Good understanding of Node.js & Javascript.
• Demonstrated ability to translate business goals and initiatives into technical requirements.
• Strong understanding of SQL database.
• Demonstrable experience architecting scalable and cost effective solutions to ensure and support customer growth.
• Experience mentoring junior engineers in all aspects of planning, development and testing.
• Strong understanding of system design and architecture.
• Interest in engaging with latest technologies and evaluating strategies to keep the Novo technology stack up to date.
• Excellent written and verbal communication skills with the ability to collaborate with both technical and non-technical teams effectively.

Job Description for Drools developer -

• Hands on experience in design and development in Drools rule engine (minimum 1.5 years) and Core Java
• Exceptional ability to communicate with both technical and non-technical people
• Expertise in object oriented programming
• Experience in Deploying and supporting core and advanced features
• Good exposure to SQL and/or Oracle/ MySQL,
• Candidate should be well verse with Agile processes
• Strong ability to work collaboratively across diverse groups of business and technical stakeholders is required.

• Key areas of responsibilities:- 
• Maintenance and enhancements of current websites.
• System requirement gathering, development, testing and maintenance for new websites or applications.
• Managing user access to the various components of the company’s IT infrastructure based on an assessment of the user requirement and security.
• Managing the admin section for the company’s websites.
  Creating an environment for Dreamweaver editor for users to develop applications.
• Documentation Designing a database and coordinating the UI design.
• Integrating the MySQL database with the PHP applications.
  Maintaining web-based PHP applications.
• Designing and developing applications and websites.
  Resolving issues related to PHP development in different applications.
  
  
• Experience and skills required:- 
  
  Skills : PHP, Mysql, MVC, JS, JQUERY,HTML,CSS, AJAX , WORDPRESS.
  
  Experience : Min 3 year Qualification: Any technical background (MCA, BE, MSC Computer etc)

We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.

For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.

Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.

We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.

Working as Senior Microsoft SQL Developer at Navtech, you will:

1. Design conceptual and logical data models and flowcharts.
2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
4. Help write and optimize in-application SQL statements.
5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
6. Ensure performance, security, and availability of databases.
7. Use high-speed transaction recovery techniques and backup data.
8. Provide proactive and reactive data management support and training to users.
9. Determine, enforce and document database policies, procedures, and standards.
10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
11. Monitor database performance, implement changes, and apply new patches and versions when required.

1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
4. Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
6. Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
10. Experience in Postgres, No-SQL databases (a plus).
11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
12. Should have excellent logical, analytical, and communication skills with client interaction experience.

Benefits

• Working with industry giants while following your passion for technology.
• Competitive pay package with additional bonus and benefits.
• Performance review and Appraisal Twice a year.
• Family Health Insurance cover for self and family.
• Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
• Work with a culturally diverse team from different geographies