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

Job Code:

Candidate Experience:

Having 7-10 years of relevant experience.

Skills and Qualifications:

● Java, HTML, CSS, JavaScript, JSON, XML, AJAX

● ZK, Spring, Spring boot, Hibernate, REST Web Service, JSP

● Good knowledge of any Database management system (SQL Server and

/or Oracle)

● Operating system: Good knowledge of any Unix-based operating system
● Web and Application Server: Good knowledge of web server and

application server configurations. Also, knowledge of hosting a website.

Nice to have skills:

● Good debugging and analysis skills

● CheckMK system’s basic knowledge

● Scripting knowledge (PowerShell, Bash, Batch, JSTL)

● Tools / Plugins: Jira, Maven, Jenkins, Subversion, Swagger

● Soft skills: Effective communication skills (need to interact with German customers), Proactiveness, Quick learner, and Highly motivated.

• 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.

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

Must-Have:

• Core Java (Must be good in Core Java concepts, Java programming practices, Clean coding.)
• Spring Framework(Must have working experience in Spring Core)
• Any SQL framework(hands-on working experience in any of these: Hibernate/JPA/MyBatis/Spring Data/Others)
• Hands-on experience in REST API
• Hands-on experienceSQL Database(any of the databases: Oracle/MySQL/PostgreSQL/SQLServer)
• Must have working experience with basic GIT
• Maven or Gradle (Must have working experience in building Java projects using maven or Gradle.)
• Should be able to work independently under someone's guidance.

Good to have:

• Advanced Java(Threading, Performance optimization)
• Spring Boot
• Other Spring frameworks(Spring Security, Spring Batch, Others)
• Microservices - Any NoSQL database(MongoDB, Cassandra, others)
• Application designing concepts.