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

Job code: CSAW0001

• Plans and contributes to software (product) development programs at all stages including testing and verification,
• Focusing on PC software.
• Expertise in .Net framework, C# (Desktop Application)
• 6 - 8 years of relevant experience in C#
• WPF, MVVM Architecture
• DBMS (SQL Server)
• XML, XSLT

ESSENTIAL EXPERIENCE 

1.   3.5 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 PAPIs.

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. 

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

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.

• Designing and building the WordPress website front-end
• Creating the website architecture
• Designing and managing the website back-end including database and server integration
• Creating landing pages 
• Generating WordPress themes and plugins
• Conducting website performance tests
• Troubleshooting content issues
• Monitoring the performance of the live website and improving it
• Work on SEO and Optimise continuously for website using Google Analytics
• Assist in Social Media Management and Email Marketing
• Stay updated with latest web technologies, SEO Tools and Website optimising tools and widgets
• Managing Social Media Management Tools

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.