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

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

• Position: Appian Tech Lead
•  
• Job Description:      
•  
• Extensive experience in Appian BPM application development
• Knowledge of Appian architecture and its objects best practices
• Participate in analysis, design, and new development of Appian based applications
• Mandatory Team leadership and provide technical leadership to Scrum teams Certification Mandatory- L1, L2 or L3
• Must be able to multi-task, work in a fast-paced environment and ability to resolve problems faced by team
• Build applications: interfaces, process flows, expressions, data types, sites, integrations,
• Proficient with SQL queries and with accessing data present in DB tables and views
• Experience in Analysis, Designing process models, Records, Reports, SAIL, forms, gateways, smart services, integration services and web services
• Experience working with different Appian Object types, query rules, constant rules and expression rules

 Qualifications:

• At least 6 years of experience in Implementing BPM solutions using Appian 19.x or higher
• Over 8 years in Implementing IT solutions using BPM or integration technologies
• Experience in Scrum/Agile methodologies with Enterprise level application development projects
• Good understanding of database concepts and strong working knowledge any one of the major databases e g Oracle SQL Server MySQL

Additional Information Skills Required

• Appian BPM application development on version 19.x or higher
• Experience of integrations using web services e g XML REST WSDL SOAP API JDBC JMS
• Good leadership skills and the ability to lead a team of software engineers technically
• Experience working in Agile Scrum teams
• Good Communication skills

1.   7 to 12-14 years of experience as a Software Developer.

2.   Experience in .Net technologies - C#, ASP.net is must.

3.   Experience in developing REST based APIs.

4.   Experience in building web user interface.

5.   Good to have experience in developing single page apps using modern JS framework.

6.   Skills in cross browser development.

7.   Understanding of Agile methodology.

8.   Excellent trouble shooting and communication skills.

9.   Knowledge of Azure will be an added advantage.

JOB DESCRIPTION -

1. Developing and implementing web-based applications using .Net technology and MS-SQL.
2. Developing front end with highly responsive user interface concept using React concept.
3. Identifying web-based user interaction.
4. Participate in requirement analysis.
5. Collaborate with internal teams and positive mindset to help and seek help.
6. Documentation of application development changes and updates.

TECHNICAL SKILLS

1. Expert in C#, ASP.Net, Web API, MS SQL Server.
2. Good to have experience in React and workflows such as Redux or Flux, MongoDB.
3. Knowledge of HTML, CSS and JavaScript.
4. Familiar with source control system (GIT, SVN).

B.Tech./ BE - Computer, IT, Electronics only

Requirements:

• 3+ year of experience in Development in JAVA technology.
• Strong Java Basics
• SpringBoot or Spring MVC
• Hands on experience on Relational Databases (SQL query or Hibernate) + Mongo (JSON parsing)
• Proficient in REST API development
• Messaging Queue (RabitMQ or Kafka)
• Microservices
• Any Caching Mechanism
• Good at problem solving

Skills:

• 3+ years of experience in using Java/J2EE tech stacks
• Good understanding of data structures and algorithms.
• Excellent analytical and problem solving skills.
• Ability to work in a fast paced internet start-up environment.
• Experience in technical mentorship/coaching is highly desirable.
• Understanding of AI/ML algorithms is a plus.
• Java
  Agile and Kafka
  Microservices
  Springboot
  NoSQL/MongoDB
  Scrum

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.