11+ Transact-SQL Jobs in Hyderabad | Transact-SQL Job openings in Hyderabad

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

Integration Developer

ROLE TITLE

Integration Developer

ROLE LOCATION(S)

Bangalore/Hyderabad/Chennai/Coimbatore/Noida/Kolkata/Pune/Indore

ROLE SUMMARY

The Integration Developer is a key member of the operations team, responsible for ensuring the smooth integration and functioning of various systems and software within the organization. This role involves technical support, system troubleshooting, performance monitoring, and assisting with the implementation of integration solutions.

ROLE RESPONSIBILITIES

·       Design, develop, and maintain integration solutions using Spring Framework, Apache Camel, and other integration patterns such as RESTful APIs, SOAP services, file-based FTP/SFTP, and OAuth authentication.

·       Collaborate with architects and cross-functional teams to design integration solutions that are scalable, secure, and aligned with business requirements.

·       Resolve complex integration issues, performance bottlenecks, and data discrepancies across multiple systems. Support Production issues and fixes.

·       Document integration processes, technical designs, APIs, and workflows to ensure clarity and ease of use.

·       Participate in on-call rotation to provide 24/7 support for critical production issues.

·       Develop source code / version control management experience in a collaborative work environment.

TECHNICAL QUALIFICATIONS

·       5+ years of experience in Java development with strong expertise in Spring Framework and Apache Camel for building enterprise-grade integrations.

·       Proficient with Azure DevOps (ADO) for version control, CI/CD pipeline implementation, and project management.

·       Hands-on experience with RESTful APIs, SOAP services, and file-based integrations using FTP and SFTP protocols.

·       Strong analytical and troubleshooting skills for resolving complex integration and system issues.

·       Experience in Azure Services, including Azure Service Bus, Azure Kubernetes Service (AKS), Azure Container Apps, and ideally Azure API Management (APIM) is a plus.

·       Good understanding of containerization and cloud-native development, with experience in using Docker, Kubernetes, and Azure AKS.

·       Experience with OAuth for secure authentication and authorization in integration solutions.

·       Strong experience level using GitHub Source Control application.

·       Strong background in SQL databases (e.g., T-SQL, Stored Procedures) and working with data in an integration context.

·       Skilled with Azure DevOps (ADO) for version control, CI/CD pipeline implementation, and project management.

·       Experience in Azure Services, including Azure Service Bus, Azure Kubernetes Service (AKS), Azure Container Apps, and ideally Azure API Management (APIM) is a plus.

GENERAL QUALIFICATIONS

·       Excellent analytical and problem-solving skills, with a keen attention to detail.

·       Effective communication skills, with the ability to collaborate with technical and non-technical stakeholders.

·       Experience working in a fast paced, production support environment with a focus on incident management and resolution.

·       Experience in the insurance domain is considered a plus.

EDUCATION REQUIREMENTS

·       Bachelor’s degree in Computer Science, Information Technology, or related field.

• Familiarity with the ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC)
• 5 years of development experience using C# .NET
• Knowledge of at least one of the .NET languages (e.g. C#, Visual Basic .NET) and HTML5/CSS3
• Familiarity with architecture styles/APIs (REST, RPC)
• Understanding of Agile methodologies
• Strong attention to detail
• Excellent troubleshooting and communication skills
• Knowledge of REST and RPC APIs
• Able to work well in a team setting

Level of skills and experience:

5 years of hands-on experience in using Python, Spark,Sql.

Experienced in AWS Cloud usage and management.

Experience with Databricks (Lakehouse, ML, Unity Catalog, MLflow).

Experience using various ML models and frameworks such as XGBoost, Lightgbm, Torch.

Experience with orchestrators such as Airflow and Kubeflow.

Familiarity with containerization and orchestration technologies (e.g., Docker, Kubernetes).

Fundamental understanding of Parquet, Delta Lake and other data file formats.

Proficiency on an IaC tool such as Terraform, CDK or CloudFormation.

Strong written and verbal English communication skill and proficient in communication with non-technical stakeholderst

Primary Skills:

.Net/.Net Core, C#, OOPS and SQL Server as a key technology, which covers frontend and backend work. Knowledge of DevOps (building and deployment) and the Cloud is nice to have.

Roles & Responsibilities

Participate in requirements analysis.

Collaborate with internal teams to produce software design and architecture.

Write clean, scalable code using .NET programming languages.

Test and deploy applications and systems.

Revise, update, refactor and debug code.

Improve existing software.

Eligibility

3+ years of experience in building web applications. Passion for building and delivering great software with a strong sense of ownership

Advanced proficiency in C#, very clear OOPS concepts, In-depth knowledge of the .NET framework, ASP.NET, MVC, Web API, REST APIs, OAuth 2.0/ Authentication/ Authorization

Strong expertise in SQL programming, with experience of writing & optimizing queries that access/process millions of records

Good to have any scripting(powershell) knowledge, JS based UI Frameworks

Outstanding analytical, problem-solving, and communication skills

Experienced in complex logic designing and implementation

Should have worked in Agile development environment and best practices

Good to have experience in secure development practices

• Experience in designing & developing systems/software for large business environments (Java, J2EE).
• Strong design and coding skills in Enterprise Java, REST & SOAP web services, ORM (JPA/Hibernate), Spring, Maven, JMS (ActiveMQ), Caching, XML, JSON.
• Experience with multiple integration technologies / frameworks.
• Must have good experience in Unix/Oracle/SQL.
• Experience in Agile Development, Scrum, and Iterative approaches.
• Experience and exposure to AWS Cloud Services and DevOps mindset and expertise is a plus Experience with Mule or any ESB (Enterprise Service Bus) is a plus.

Job Requirements-

Strong in programming fundamentals in C#, jQuery, JavaScript and Sql Server.
-Experience in Developing Web-Based App, SDLC & software engineering, Unit Testing.

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

Mandatory Requirement/ Preference:

- 4 years of experience for delivering enterprise solutions or products using full SDLC 

- 4 years of work experience with enterprise solutions for Microsoft platform (SQL Server, stored procedures, WCF, C#.net, Entity Framework) 

- Extensive knowledge and experience with creating and maintaining stored procedure in MS SQL Server.

- Working with WEB API added advantage

Job Role – SDE2

Duration – 12 months

Location – HYD

Key Skills:

• 3- 5 years
• Understanding databases and building reports
• Ideal candidate should have experience in Cosmos, Kusto and powerbi
• Mandatory experience in some Database query language(such as SQL)