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.

Who Are We Looking For Exactly? 

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

Job Description
· Participate in analysis, design, and new development of Appian based applications
· Build applications: interfaces, process flows, expressions, data types, sites, integrations, etc.
· 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
Primary Responsibilities:
· Responsible for systems analysis for a designated set of applications
· Work closely with BA and System Architect & Delivery Manager. Own the accurate translation of
business requirements in the form of high-level design and system requirements specifications.
· Ensure sign-off of SRS and High-Level Design Specification
· Assist the PM in the estimation of effort to deliver the solution based on the SRS and the timelines.
· Liaise with Infra teams in the production of an infrastructure solution design and requirements as
and when the proposed solution involves infrastructure components
· Provide further clarity and detail to feasible options proposed by BA and help in selection of the
right option in consultation with the Design Authority.
· Work closely with the Application Development team (Tech Delivery Lead) and Testing teams (Test
Manager and Test Engineer) to ensure that the Low-level design, test plans and test cases are aligned to
the approved SRS.
· Participate in progress review meetings and review and sign-off deliverables produced by technical
delivery team and testing teams.
Qualifications
- B.Sc. (Computer Science), B.E
· Minimum 5 years of experience in Insurance domain
· At least 4 years of experience in Implementing BPM solutions using Appian 19.x or higher.
· Over 5 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 and System Analysis
· 8-10 years of proven software System Analysis and design experience
· Ability to work on large and complex projects.
· Strong technical knowledge of existing Insurance/F&A application
· Excellent documentation, communication, and presentation skills
· Ability to understand business requirements, analyze and translate them into system
requirements

Job Description

Build and maintain bots on Azure platform.  Integration with Active directory, WEB API based integration with external systems. Training and Integrate bots as per users’ requirements. Work in line with design guidelines, best practices and standards of bot deliverable. Creative approach to the conversation flow design, human aspects in the bot responses and sentiments

Qualifications

1. a) 5 years of experience in software development with clear understanding of the project life cycle
   b) Min 2-3 years of hands-on experience in Microsoft Azure Bot Framework, LUIS and other Cognitive services offered by Azure
   c) Hands on experience with Machine Learning based chat bots
   d) Experience with Azure bot services like Text Analytics etc.
   e)Strong database skills and hands-on experience on databases like SQL Server/Oracle
2. f) Strong experience on Azure Active directory and adaptive cards integration in Chat bot.
3. g) Strong experience designing and working with

with service-oriented architectures (SOA) and WebAPIs.

1. h) A strong experience on Microsoft Azure, ASPNET / MVC and programming languages such as C#/VBNET
2. i) Knowledge of Python and NodeJS is a plus
3. j) Ability to design and optimize SQL Server 2008 stored procedures.
4. k) Experience with JQuery, CSS3, HTML5 or similar technologies.
5. l) Ability to adapt quickly to an existing, complex environment.

 

6-8 years of hands-on development experience using core Python
Hands-on experience with Spark and SQL
Good to have java knowledge

We are on a mission to enable businesses to build agile and accountable technology teams that can deliver results in a secure and scalable way. You will be working in one such technology team for our clients across the world.

• Collaborate with front-end and back-end developers and designers to build website following client requirements

• Create clear, simple, and reusable code

• Develop all server-side logic, including data storage to optimize website performance

• Identify programming bottlenecks and bugs and find fixes

• Test, update and validate web applications to be used on different web browsers

• Execute automated testing platforms and system tests

• BSc/BE/BTech in Computer Science, Engineering or a related field

• At least 2+ years of experience with JavaScript and Node.js

• Hands-on expertise in REST, MySQL/PostgreSQL, WebSocket, MongoDB, Redis, etc.

• Familiarity with Docker and AWS infrastructure

• Understanding of data security principles

• Proficiency in JavaScript, web stacks, libraries, and frameworks

• Strong analytical and problem-solving aptitude skills

Description: YuktaMedia is seeking an experienced MySQL developer to join our team in Pune. This position will collaborate with developers in the design and operations of the database applications. Responsibilities & Requirements: - Should have experience of 1-2 years - Hands on experience of working on stored procedures, functions, cursors etc. - Hands on experience of working on creating indexes, triggers, SQL sub-queries etc. - Client Communication. - Timely delivery of tasks. - Able to Prioritize and plan task and report status to manager - Project Documentation Skills: - Ability to work with team or independently - Excellent written and verbal communication - Strong Problem Solving Skills - Self motivated. YuktaMedia's Yukta One platform enables end-to-end automation of Digital Ad and Revenue Operations across Display, Video and Mobile assets. YuktaMedia’s team is composed of talent from across the globe, cultures and industries inherently forming a very strong foundation of communication based on TRUST. Team YuktaMedia believes in mutual Trust, Hard work and Team work. In short One for All and All for One! If you think you're right fit for this position then join us!

As an engineer, you will help with the implementation, and launch of many key product features. You will get an opportunity to work on a wide range of technologies (including Spring, AWS Elastic Search, Lambda, ECS, Redis, Spark, Kafka etc.) and apply new technologies for solving problems. You will have an influence on defining product features, drive operational excellence, and spearhead the best practices that enable a quality product. You will get to work with skilled and motivated engineers who are already contributing to building high-scale and high-available systems.

If you are looking for an opportunity to work on leading technologies and would like to build product technology that can cater millions of customers inclined towards providing them the best experience, and relish large ownership and diverse technologies, join our team today!

 

What You'll Do:

• Creating detailed design, working on development and performing code reviews.
• Implementing validation and support activities in line with architecture requirements
• Help the team translate the business requirements into R&D tasks and manage the roadmap of the R&D tasks.
• Designing, building, and implementation of the product; participating in requirements elicitation, validation of architecture, creation and review of high and low level design, assigning and reviewing tasks for product implementation.
• Work closely with product managers, UX designers and end users and integrating software components into a fully functional system
• Ownership of product/feature end-to-end for all phases from the development to the production.
• Ensuring the developed features are scalable and highly available with no quality concerns.
• Work closely with senior engineers for refining the and implementation.
• Management and execution against project plans and delivery commitments.
• Assist directly and indirectly in the continual hiring and development of technical talent.
• Create and execute appropriate quality plans, project plans, test strategies and processes for development activities in concert with business and project management efforts.

The ideal candidate is a passionate engineer about delivering experiences that delight customers and creating solutions that are robust. He/she should be able to commit and own the deliveries end-to-end.

 

 

What You'll Need:

 

• A Bachelor's degree in Computer Science or related technical discipline.
• 2-3+ years of Software Development experience with proficiency in Java or equivalent object-oriented languages, coupled with design and SOA
• Fluency with Java, and Spring is good.
• Experience in JEE applications and frameworks like struts, spring, mybatis, maven, gradle
• Strong knowledge of Data Structures, Algorithms and CS fundamentals.
• Experience in at least one shell scripting language, SQL, SQL Server, PostgreSQL and data modeling skills
• Excellent analytical and reasoning skills
• Ability to learn new domains and deliver output
• Hands on Experience with the core AWS services
• Experience working with CI/CD tools (Jenkins, Spinnaker, Nexus, GitLab, TeamCity, GoCD, etc.)

 

• Expertise in at least one of the following:

    - Kafka, ZeroMQ, AWS SNS/SQS, or equivalent streaming technology

    - Distributed cache/in memory data grids like Redis, Hazelcast, Ignite, or Memcached

    - Distributed column store databases like Snowflake, Cassandra, or HBase

    - Spark, Flink, Beam, or equivalent streaming data processing frameworks

• Proficient with writing and reviewing Python and other object-oriented language(s) are a plus
• Experience building automations and CICD pipelines (integration, testing, deployment)
• Experience with Kubernetes would be a plus.
• Good understanding of working with distributed teams using Agile: Scrum, Kanban
• Strong interpersonal skills as well as excellent written and verbal communication skills

• Attention to detail and quality, and the ability to work well in and across teams

Responsibilities:

• Develop new and enhance existing micro-services, libraries, and features that form our B2B KYC platform.
• Create and document APIs, Queue Contracts to be consumed by other services.
• Work closely with the Product and Engineering Leads to implement features following best design principles and patterns.
• Participate in all phases of the development cycle - plan, design, implement, review, test, deploy, document, and training.
• Help junior developers with best practices like TDD etc. and make sure their code meets the standards.
• Educate them continuously to improve overall team performance and work quality.

Requirements:

• Bachelors/Masters in Computer Science or equivalent experience.
• Strong understanding of Computer Science fundamentals, software design principles, algorithms & design patterns.
• Development experience (> 3 to 6 years ) - preferably on languages such as GoLang / NodeJS and scripting skills.
• Interest and ability to quickly learn and ramp-up on new languages and technologies.
• Ability to write understandable, reliable and testable code with minimum supervision.
• Distributed, Highly-available systems running at large scale.
• Distributed platforms which use Kafka, Elasticsearch, Cassandra or similar systems.
• Cloud environments (e. g., Docker, AWS, GCP, Kubernetes etc., ).
• Asynchronous programming patterns (e. g., GO Routines/Channels, NodeJS Async Programming).
• Experience in CI/CD (Continuous Integration & Delivery), AGILE work environments.
• Ability to troubleshoot and solve issues on distributed systems.

MS SQL 2012 Server Administrator, with experience of data migration projects using SSRS, SSIS packages. Needs to have a very strong and credible record as a DBA, experience of handling enterprise Data Base migration projects preferably in a financial or banking arena. Provide hands on support to our internal DBA and development teams. Strong knowledge of database design, query cost and performance measurement, use of stored procedures and performance tuning. Experience in using Integration Services (SSIS) platform for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations. Will provide database functions by designing and coding utilities and scripts Maintains database performance by calculating optimum values for database parameters; implementing new releases and completing maintenance requirements. Provides information by answering questions and making recommendations. Maintains quality service by establishing and enforcing organization standards.

We are Offshore Software Development company, working with Clients across the globe. We believe our technical competency and drive to improve our Client Experience sets us apart from our competitors. We constantly strive to keep our Clients completely satisfied. This attitude and passion flows through each member of our organization and it plays an important role in the way we perform business. A ‘go an extra mile’ attitude drives each one of us to perform better. It is in this environment that our team works in. We started AnAr in early 2013 with a dream to become like Disney to software industry in terms of Customer Focus. We work with our clients to align all our processes and work practices as per Client’s needs and preferences. To achieve this Client Focus, we work with every team member and help him/her understand Client’s business, culture and requirements.

About SphereGen Technologies Pvt Ltd (www.spheregen.com) SphereGen is a new generation, Boutique software development and consulting company which provides high-quality, cost-effective and business critical solutions. Our innovative and client-centric approach helps us to understand our clients' business objectives and creative quality business solutions which provide added value to clients' businesses. ‘Our clients' success is our success’ has been our mantra. SphereGen constantly strives to build a long term and trusted business relationship by adopting a client centric approach. Our clients also benefit from our strategic global model that combines the best of onshore and offshore software development tailored to meet their needs. With a strong understanding of business needs and technology, our solutions have been high in quality standards, timely in delivery and imnbued with cutting edge technologies.