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.

Must-Have Technology Skills:

• OOP Concept, Java 8+, Spring Boot, API development, Agile Scrum knowledge, Strong Databases design concepts of RDBMS, and capable of writing and optimizing complex queries.
  Good understanding of any Database tool e.g. Postgres, MySQL, etc.,
• DevOps basic knowledge e.g. implementation of logging in the code, Application Performance Management.
• Basic API & Application security, and Basics of tuning application performance.
• Basic Understanding of DevOps concepts e.g. CI & CD, Deployment lifecycle, Basic understanding of unit testing concepts e.g. TDD (test-driven development).
• A basic understanding of Microservices patterns
• A basic understanding of Java scripting.
• Good understanding of UI Frameworks like Angular 8+

Must-Have Soft Skills:

• Verbal & Written English communication, Good Problem-solving skills,
• Good Planning skills,
• Team Player,
• Good leadership skills
• Good written and verbal communication

Job Description

• Good experience as a full-stack developer in DB-centric applications and should be able to write and optimize complex database queries
• Requirement gathering & understanding, effort estimation, technical design, project planning, and monitoring in an Agile environment.
• Work proactively & independently to address project requirements, and articulate issues/challenges with enough lead time to address project delivery risks.
• Providing expertise in technical analysis and solving technical issues during project delivery.
• Customer interfacing - understand customer requirements, and propose technical solutions.
• Full Software Development Lifecycle (Agile).
• Code reviews, test case reviews and ensure code developed meets the requirements.
• Component Design/ Coding/ Unit Testing/ Debugging / Test Driven Development / Continuous Integration.
• Carry out adaptive changes necessitated by changes in Business Requirements and Technology

Roles and Responsibilities

• Develop and manage highly trafficked, highly scalable web properties with PHP5 using Laravel/ZEND CodeIgniter/Yii/Symfony framework.
• Understand the specifications to define system requirements.
• Collaborate and communicate project updates and progress to team members and clients.
• Analyze, design, code, debug, test, document and deploy changes to the system.

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.