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

Responsibilities include:  

• Develop and maintain data validation logic in our proprietary Control Framework tool 
• Actively participate in business requirement elaboration and functional design sessions to develop an understanding of our Operational teams’ analytical needs, key data flows and sources 
• Assist Operational teams in the buildout of Checklists and event monitoring workflows within our Enterprise Control Framework platform 
• Build effective working relationships with Operational users, Reporting and IT development teams and business partners across the organization 
• Conduct interviews, generate user stories, develop scenarios and workflow analyses  
• Contribute to the definition of reporting solutions that empower Operational teams to make immediate decisions as to the best course of action 
• Perform some business user acceptance testing 
• Provide production support and troubleshooting for existing operational dashboards  
• Conduct regular demos and training of new features for the stakeholder community 

Qualifications  

• Bachelor’s degree or equivalent in Business, Accounting, Finance, MIS, Information Technology or related field of study 
• Minimum 5 years’ of SQL required 
• Experience querying data on cloud platforms (AWS/ Azure/ Snowflake) required 
• Exceptional problem solving and analytical skills, attention to detail and organization 
• Able to independently troubleshoot and gather supporting evidence  
• Prior experience developing within a BI reporting tool (e.g. Spotfire, Tableau, Looker, Information Builders) a plus  
• Database Management and ETL development experience a plus 
• Self-motivated, self-assured, and self-managed  
• Able to multi-task to meet time-driven goals  
• Asset management experience, including investment operation a plus 

Position Overview:

We are seeking a Node.js Developer with 1-2 years of experience to join our team. The ideal candidate should have hands-on experience in backend development, a solid understanding of JavaScript, Express.js, and familiarity with databases. You will be responsible for developing and maintaining server-side applications, collaborating with front-end teams, and ensuring optimal performance.

Key Responsibilities:

• Backend Development: Build and maintain server-side applications using Node.js and Express.js.
• API Development: Design and implement RESTful APIs to support various functionalities.
• Database Management: Work with both SQL (MySQL, PostgreSQL) and NoSQL (MongoDB) databases.
• Code Quality & Testing: Write clean, reusable, and testable code while following best practices.
• Performance Optimization: Optimize applications for speed and scalability.
• Troubleshooting & Debugging: Identify and resolve application issues to ensure smooth operations.
• Security Implementation: Apply basic security measures to protect applications and data.
• Collaboration: Work closely with front-end developers to integrate UI components with backend logic.

Required Qualifications:

• 1-2 years of experience in Node.js backend development.
• Strong proficiency in JavaScript and ES6+ concepts.
• Hands-on experience with Express.js or similar frameworks.
• Familiarity with front-end technologies (HTML, CSS, React/Angular is a plus).
• Experience working with databases (MySQL, PostgreSQL, MongoDB).
• Basic understanding of asynchronous programming and event-driven architecture.
• Experience with Git for version control.
• Knowledge of basic cloud services (AWS, Azure, or GCP is a plus).
• Understanding of Docker and containerization is an advantage.
• Good problem-solving skills and willingness to learn.

Techolution is looking for a .NET Developer who will play a crucial role in developing and maintaining our applications. You will be responsible for designing, implementing, and optimizing high-performance, scalable applications using the latest .NET technologies. This role requires a strong foundation in software development, a keen eye for detail, and a commitment to delivering high-quality solutions.

Title : .Net Developer

Location: Hyderabad

Timings: 2 PM - 11 PM

Years of Experience: 3-5yrs

Roles & Responsibilities:

• Develop and maintain high-quality software solutions using C# and ASP.NET Core.
• Design and implement scalable and efficient microservices architecture.
• Utilize Azure Services to enhance application performance and scalability.
• Implement CI/CD practices and principles to ensure smooth deployment and continuous integration.
• Work with NoSQL and SQL databases to manage and store data effectively.
• Apply Test-Driven Development (TDD) methodologies to ensure robust and reliable code.
• Troubleshoot and resolve technical issues, ensuring high performance and responsiveness of applications.
• Collaborate with cross-functional teams to define, design, and ship new features.
• Communicate effectively with team members and stakeholders, providing regular updates on project status.

Required Skills:

• Strong experience with C# and ASP.NET Core.
• Proficient in Azure Services and cloud-based application development.
• Solid understanding of microservices architecture.
• Hands-on experience with CI/CD practices and tools.
• Experience with both NoSQL and SQL databases.
• Proficient in implementing TDD practices.
• Excellent problem-solving and troubleshooting skills.
• Strong communication and collaboration skills.

About Techolution:

Techolution is a Product Development firm on track to become one of the most admired brands in the world for "innovation done right". Our purpose is to harness our expertise in novel technologies to deliver more profits for our enterprise clients while helping them deliver a 

better human experience for the communities they serve. With that, we are now fully 

committed to helping our clients build the enterprise of tomorrow by making the leap from Lab Grade AI to Real World AI.

We are honored to have recently received the prestigious Inc 500 Best In Business award, a testament to our commitment to excellence. While we are big enough to be trusted by some of the greatest brands in the world, we are small enough to care about delivering meaningful ROI-generating innovation at a guaranteed price for each client that we serve.

Let’s give you more insights!

One of our amazing products with Artificial Intelligence:

1. https://faceopen.com/ : Our proprietary and powerful AI Powered user identification system which is built on artificial intelligence technologies such as image recognition, deep neural networks, and robotic process automation. (No more touching keys, badges or fingerprint scanners ever again!)

Some videos you wanna watch!

• Life at Techolution
• GoogleNext 2023
• Ai4 - Artificial Intelligence Conferences 2023
• WaWa - Solving Food Wastage 
• Saving lives - Brooklyn Hospital
• Innovation Done Right on Google Cloud
• Techolution featured on Worldwide Business with KathyIreland
• Techolution presented by ION World’s Greatest

Visit us @www.techolution.com : To know more about our revolutionary core practices and getting to know in detail about how we enrich the human experience with technology.

Technical Lead - .NET

Responsibilities:

• Develop and deliver technical systems
• Maintain adherence to architectural standards/principles, global product-specific guidelines, usability design standards, etc.
• Participate in the development and review of documents to comply with SDLC methodologies [e.g., Engineering Work Breakdown Structure (WBS), estimation, Solution Design Document (SDD) and Software Architecture Documents (SAD)]
• Provide support and documentation to assist in sustaining the project during the transition to production where necessary
• Adhere to Application Engineering methodologies, standards, code reviews
• Provide feedback regarding application engineering methodologies, standards, and leading practices when appropriate
• Identify potential points of contention for missed activities and notify project leadership of situation and remediation plan
• Minimize technical exposure and risk on projects
• Provide technical guidance to development team members
• Technical deliverables (i.e., code and documentation) on projects assigned
• Translate detailed Requirements and Design and Solution Architecture deliverables into detailed design specifications
• Maintain effective and consistent communication within the team, with peers, the leadership team, and the peers in other IT groups
• Proactively raise issues to Technical and Group Leads when necessary
• Produce high-quality application engineering deliverables in accordance with the project timeline
• Build and unit test a project to detailed design specifications
• Provide thought leadership and technical guidance to engineering staff
• Review of code completed
• Review performance of developers
• Proactively anticipate project issues before they occur; define the problem; identify possible causes; work with the team to identify solutions; select and implement the most appropriate solution
• Apply judgment in implementing Application Engineering methodologies, processes, and practices to specific requirements of projects/programs which may include product design engineering, information security, code maintainability and reliability

Requirements:

Must Have:

• Bachelor’s OR master’s degree in a technical field and/or equivalent work experience
• At least 3 years acting a senior architecture / technical lead role in a comparable organization
• Significant experience of deploying large, enterprise-wide implementations to significant user volumes
• At least 5 years of hands-on experience leading a team of developers - defining work breakdown structures/tasks, assigning the teamwork items, monitoring, and ensuring quality and adherence to standards etc.
• At least 8 years of relevant hands-on work experience building, integrating, and delivering enterprise-wide web and windows applications using Microsoft and other technologies for large organizations on complex projects
• 8+ years of ASP.Net MVC, ASP.Net experience
• 8+ years of experience of working with applications that have a SQL Server backend
• 5+ years of experience with Object-Relational Mappers such as Entity Framework, ADO.NET, Dapper
• Expert level knowledge of .NET Web API is required. .NET Core knowledge is preferred, but Web API experience with legacy .NET is ok
• 5+ years of experience with GIT
• 3+ years of experience of Azure Devops
• In-depth knowledge of object-oriented analysis and design (OOAD) principles, and familiarity with many design patterns for Software applications.
• Demonstrated expertise in application design and construction, work breakdown structure of items, design and code reviews, unit test and build activities, deployment and performance related activities, documentation, support, and training/mentoring
• Excellent communication skills, verbal and written

Nice to have:

• Ideally experience working with SSRS, SSIS
• Experience with MongoDB or another document database would be a plus
• Knowledge and experience with working on N-Tier applications.
• Demonstrated ability to build strong working relationships
• Experience working on projects following Agile methodologies would be ideal
• Experience working with Azure or other cloud providers would be ideal
• Ability to work within diverse, global, virtual teams.
• Proven ability to thrive under pressure
• Some experience with design and prototyping tools and diagramming is desired

What we are scouting for

• BS/MS in computer science or equivalent work experience in IT
• 2+ years’ experience designing and developing applications using Java EE platforms
• A strong hands-on programming knowledge in Core Java including Java 8. To solve the problem given in optimized way.
• Strong knowledge on the Data structure and algorithm.
• Experience developing and designing API integrations using SOAP/RESTful
• Should be able to understand the time complexity of the existing algorithm. Able to compare different algorithms available.
• Expert understanding of the object-oriented design and programming concepts
• Know the fundamentals of Object-Oriented Programming using Java;
• Used SQL & NoSQL solutions
• Experience in GIT/SVN, build tools such as Ant/Maven/Gradle
• Experience in JUnit, Sonarqube, Mockito, Jacoco, Maven & Jenkins

Technical Competency – Nice to have

• Experience in Dependency Injection, Annotation, Validations, Auto Wiring
• Good knowledge in internal working on Memory Management, Transaction management
• Knowledge on DevOps pipeline tools like Jenkins, tools for Code quality scan, tools for security scan
• Spring boot
• Spring MVC
• Any Java Certification

Behavioural Competency

• Strong interpersonal communication skills
• Ability to lead self and team toward common goals
• Excellent oral and written communication, presentation, and analytical skills
• Excellence in technical communication with peers and non-technical cohorts

What you will be doing

• As a self-motivated and enthusiastic member of our team, you will work with extremely talented peers in a fun environment building performance efficient payment authorization services that are highly scalable, configurable and available
• You’ll work in an Agile environment with a focus on problem solving and engineering excellence.
• Worked independently and as a member of a team, determined to make active contributions to the assigned Team
• Flexible and adaptable approach to the roles assigned to you
• Ability to coordinate and prioritize tasks, and work in a fast paced and challenging environment
• Deliver on time under dynamics with a high level of integrity and flexibility, sense of urgency, attention to detail and quality standards
• Make a large impact on the design, architecture, and implementation of cutting edge products
• Work with other team members to investigate design approaches, prototype new technology

and evaluate technical feasibility

• Work in an Agile/Scrum environment to deliver high quality software
• Establish architectural principles, select design patterns and then mentor team members on their appropriate application

Primary Role

• As an SSRS Report Engineer, the primary job role is to develop a transactional data report using Microsoft SQL Service Reporting Service 2016 or above.
• This includes developing high performing Stored Procedures, Functions, and corresponding reporting formats.
• Required to design the required logics for the queries and collaboratively coordinate with the rest of the team.

Main Duties / Responsibilities

• Design & implement high performing T-SQL queries as per the functional specification.
• Create Technical Specification.
• Effective troubleshooting of technical issues and bugs.
• Package deployment and release management.
• Provides technical support to customers.
• Participate in Requirements discussions.
• Must be able to manage timelines and task priorities.
• Attention to detail and maintaining high-quality standards is a must.

TECHNICAL KNOWLEDGE

• Experience in Microsoft SQL Server 2016 (or above) and Microsoft SQL Service Reporting Service 2016 (or above).
• Knowledge of T-SQL including complex SQL queries, stored procedures, views and functions.
• Experience with usage of indexes and T-SQL performance tuning techniques.

QUALIFICATIONS

• Bachelor’s Degree or an equivalent qualification

Responsibilities

· Excellent knowledge of Core Java and Spring

· Candidate should have a working knowledge of web services

· Should have worked in the distributed agile model and continuous integration

· Should have knowledge of designing and implementation of REST Web services

· Strong experience with REST API and web services

· Should be efficient with Java J2EE and related technologies.

Essential Requirements

· Strong Core Java and spring.

· Strong RESTFUL web service experience

· Strong SQL (preferably Oracle), JQuery, HTML/CSS, Oracle Restful, SOAP web services

· B. Tech/M. Tech from Tier-1 colleges like IIT, NIT, VIT, BIT

Primary Skill: Java, spring & RESTFUL Web services,