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 = Java Developer

We are looking forward to hire a committed Java Developer with experience in building high performing, scalable, enterprise-grade applications. You will be part of our Engineering team that works on mission-critical applications. You will be managing Java/Java EE application development while providing expertise in the full software development lifecycle, from concept and design to testing.

You are required to:

Contributing in all phases of the development lifecycle.

Write well designed, testable & efficient code.

Ensure designs are in compliance with specifications.

Prepare and produce releases of software components.

Support continuous improvement by investigating alternatives and technologies and presenting these for architectural review.

Technical Skills required

Java, Springboot, Microservices, Data structures & Algorithms, MySQL, NoSQL, Mongodb and Hibernate.

OUR CURRENT STACK

Backend: Spring (JAVA), Laravel (PHP), MySQL, NoSQL, NGINX Plus.

Frontend: Angular 5+ Ngrx/store 5

Infrastructure: Google cloud platform (App engine, CloudSQL, BigQuery, PubSub, Firebase Hosting), Scrapy Cloud, Pusher.io (websockets), Getstream.io, Filestack, Postmark app, AS2 Gateway, Google Cloud Endpoints Framework, MongoDB, Algolia, Memcache

Tools: Gitlab, Postman app, JIRA. Wondering what your Responsibilities would be? Technical Skills required O

You are where our search ends, if you hold:

B. Tech/ M. Tech or corresponding degree

Experience in the same role of almost 1-6 years

Experience with connecting backend and frontend services.

Exposure to consuming data through different interfaces (Web API's/Socket/ REST/ RESTFUL/ JSON/ XML).

Proficiency in Data Structures and Algorithms.

Understanding of web markup, including HTML 5 CSS.

Understanding of client-side scripting and JavaScript frameworks.

Ability to write clean, reusable and well documented code.

Proficient understanding of code versioning tools, such as Git.

Knowledge of API authentication techniques (Token, JWT, OAuth2) - desirable but not mandatory. (Experience with API Design will be a plus)

Fair spoken and written English Flexibility - Things change around here. FAST!

Other Inter-personal skills like self-motivation, persistency, patience and eagerness to learn and work independently.

Job Description: Core Java Developer

Company: Mobile Programming LLC

Location: Pune (Remote work available)

Salary: Up to 16 LPA

Position: Core Java Developer

Responsibilities:

• Design, develop, and maintain Java-based applications using Core Java and Spring Boot frameworks.
• Collaborate with cross-functional teams to deliver high-quality software solutions.
• Conduct code reviews and troubleshoot/debug complex issues.
• Optimize application performance and stay updated with industry trends.

Requirements:

• Minimum 6 years of hands-on Core Java development experience.
• Strong proficiency in Spring Boot framework.
• Solid understanding of OOP principles, web development (HTML/CSS/JavaScript), RESTful web services, and SQL.
• Experience with Git and problem-solving skills.
• Excellent communication skills and ability to work independently and as part of a team.
• Bachelor's or Master's degree in Computer Science or a related field.

Note: Immediate joiners required. Please include your resume and relevant code samples/projects when applying.

Microsoft Azure Data Integration Engineer

Job Description: 

Microsoft Azure Data Integration Developer who will design and build cutting-edge user experiences for our client’s consumer-facing desktop application. The Senior Software Developer will work closely with product owners, UX designers, front-end, and back-end developers to help build the next-generation platform. 

Key Skills:

• 3+ years of experience in an enterprise or consumer software development environment using C# and designing and supporting Azure environments
• Expert level programming skills in creating MVC and Microservices architecture
• Experience with modern frameworks and design patterns like .Net core
• Strong knowledge of C# language
• Hands-on experience using the Azure administration portal and iPaaS
• Demonstrable experience deploying enterprise workloads to Azure
• Hands-on experience in Azure function apps, app service, logic apps and storage, Azure Key vault integration, and Azure Sql database.
• Solid understanding of object-oriented programming.
• Experience developing user interfaces and customizing UI controls/components

·      Microsoft Azure Certification, Business Continuity, or Disaster Recovery planning experience is a plus

Responsibilities:

• Architect, design & build a modern web application for consumers
• Explore configuring hybrid connectivity between on-premises environments and Azure, and how to monitor network performance to comply with service-level agreements.
• Collaborate with UI/UX teams to deliver high-performing and easy-to-use applications
• Participate in code reviews with staff as necessary to ensure a high-quality, performant product
• Develop a deep understanding of client goals and objectives, and articulate how your solutions address their needs
• Unit testing/test-driven development
• Integration testing
• Deploying Azure VMs (Windows Server) in a highly available environment
• Regularly reviewing existing systems and making recommendations for improvements.
• Maintenance
• Post-deployment production support and troubleshooting

Technical Expertise and Familiarity:

• Cloud Technologies: Azure, iPaaS
• Microsoft: .NET Core, ASP.NET, MVC, C#
• Frameworks/Technologies: MVC, Microservices, Web Services, REST API, Java Script, JQuery, CSS, Testing Frameworks
• IDEs: Visual Studio, VS Code
• Databases: MS SQL Server, Azure SQL
• Familiarity with Agile software development methodologies.
• Advanced knowledge of using Git source control system.
• Azure, AWS, and GCP certifications preferred.

Position: Sybase Developer

Location: Bangalore /Pune

Exp.Level: 8+ Yrs

Proven experience as a. Sybase Developer

Familiarity with Oracle, Sybase, Performance tuning and Optimization

Required Skills: Sybase, Performance tuning and Optimization

• To support and maintain existing Java code base, debug the application 
• To analyse user and business requirements and design and implement appropriate solutions 
• To design and code programs following in-house standards and good design principles 
• To ensure that all programs are documented to the company standards 
• To create unit test plans and perform unit testing of the programs
• To provide advice and guidance to other members of the team

• Hands on experience in designing and developing applications using Java EE platforms 
• Object Oriented analysis and design using common design patterns 
• Good knowledge of Relational Databases, SQL and ORM technologies (JPA2, Hibernate) 
• Experience in the Spring Framework 
• Experience in developing web applications using at least one popular web framework (JSF, Wicket, GWT, Spring MVC) 
• Experience in RESTFul webservices
• Experience with test-driven development 
• Exposure to portal/mobility development - Desired
• Exposure to any of middleware solutions like MQ, Oracle fusion middleware(WebLogic), WebSphere, Open Source

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.

• Implement best practices for the engineering team across code hygiene, overall architecture design, testing, and deployment activities
• Drive technical decisions for building data pipelines, data lakes, and analyst access.
• Act as a leader within the engineering team, providing support and mentorship for teammates across functions
• Bachelor’s Degree in Computer Science or equivalent job experience
• Experienced developer in large data environments
• Experience using Git productively in a team environment
• Experience with Docker
• Experience with Amazon Web Services
• Ability to sit with business or technical SMEs to listen, learn and propose technical solutions to business problems

·       Experience using and adapting to new technologies

·       Take and understand business requirements and goals

·       Work collaboratively with project managers and stakeholders to make sure that all aspects of the project are delivered as planned

·       Strong SQL skills with MySQL or PostgreSQL

• Experience with non-relational databases and their role in web architectures desired

 Knowledge and Experience:

• Good experience with Elixir and functional programming a plus

• Several years of python experience
• Excellent analytical and problem-solving skills
• Excellent organizational skills

Proven verbal and written cross-department and customer communication skills

About us:
Aeons ago (2015 :)), in the humble abode of Abhishek’s bachelor pad, our co-founders, Abhishek Ballabh & Sushil Mundada, set out to bring innovation into the world of admissions. Today, we are trusted with the admissions of over 300 educational institutions. Our team of 60 + team members (and growing!) are on a mission to help ExtraaEdge become the globally preferred Education Marketing Technology.

 The primary requirement for this role is:

• Sharp .NET & MVC framework knowledge & programming hands-on.

• Attention to Detail.

• Razor-sharp analytical & problem-solving skills.

• Experience in Agile methods & Test-Driven design.

Job Profile: 

• To be a part of the development initiatives at ExtraaEdge and work in a high-performance team.
• Minimum 0 to 2 years of development experience.
• Manage the backend services and controller changes when a new module is implemented.
• Manage the development roadmap in sync with the product roadmap.
• Suggest architectural changes & optimizations while fine-tuning the application.
• Being able to step into the shoes of the user/learner and identify the best design/coding strategies & frameworks.
• Interact with operations & sales to understand expectations.

Skills Required:

• 0 to 2 years of experience working on C#, .NET Core, .NET MVC.
• Proficient in Entity Framework, LINQ to Objects.
• Experienced in SQLServer, Database design, and understanding database queries.
• Advanced Database knowledge like Indexing, Stored Procedures.
• REST API design and implementation.
• Knowledge of Azure Cloud Management, WebApps & Deployments.
• Hands-on in writing Unit Tests.
• Familiarity with architecture styles/APIs (REST, RPC).
• Understanding of Agile methodologies.
• Excellent problem solving and communication skills.

 Review all job requirements and specifications required for deploying the solution into the production environment. 

 Perform various unit/tests as per the checklist on deployment steps with help of test cases and maintain documents for the same. 

 Work with Lead to resolve all issues within the required timeframe and inform for any delays. 

 Collaborate with the development team to review new programs for implementation activities and manage communication (if required) with different functions to resolve issues and assist implementation leads to manage production deployments. 

 Document all issues during the deployment phase and document all findings from logs/during actual deployment and share the analysis. 

 Review and maintain all technical and business documents.  Conduct and monitor software implementation lifecycle and assist/make appropriate customization to all software for clients as per the deployment/implementation guide 

 Train new members on product deployment, issues and identify all issues in processes and provide solutions for the same. 

 Ensure project tasks as appropriately updated in JIRA / ticket tool for in-progress/done and raise the issues. 

 Should take self-initiative to learn/understand the technologies i.e. Vertica SQL, Internal Data integration tool (Athena), Pulse Framework, Tableau. 

 Flexible to work during non-business hours in some exceptional cases (for a few days) required to meet the client time zones. 

Experience on Tools and Technologies preferred: 

ETL Tools: Talend or Informatica ,Abinitio,Datastage 

BI Tools: Tableau or Jaspersoft or Pentaho or Qlikview experience 

Database: Experience in Oracle or SS 

Methodology: Experience in SDLC and/or Agile Methodology