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 Summary

• Candidate will be responsible for providing full life-cycle development (design, coding, and testing) and maintenance of web-based system on Azure
• Candidate should have experience in GitHub, knowledge of DevOps is a plus
• Experienced in designing and implementing web portals, experience with DNN is must
• Ability to work with multiple languages including C#, ASP.Net, MVC, Javascript and related libraries, HTML, Complex SQL queries, CSS, BootStrap, JSON.
• Experience in Agile project management methodology
• Developing and Delivering Excellent Web based solutions/portals/sites based on customer’s requirement within the stipulated timeline
• The candidate should be flexible to learn new technology and platform and should be creative, innovative for improvement ideas, detail oriented, diligent, and eager to learn and grow

Duties and Responsibilities

• Understand business requirements to apply logic to integrate functionalities
• Identify and understand any technical bugs on the server, site, log files or modules and work on resolving the bugs
• Understand how FTP server is setup for the site
• Understand system/site technical requirements and suggest enhancements if applicable
• Designing, coding, unit Testing, and integration with Database
• Handle site deployment
• Designing, coding, debugging, technical problem solving, and writing Unit Test cases, etc.

Qualifications

Education / Certification

• B.E. / B.Tech. /MSC in Computer Science or IT.
• MCAD/MCSD/MSITP/MCPD

Technical Expertise

• ASP/ASP.NET/VB.NET/MVC/C#/SQL Server 2012+
• HTML, Javascript, Jquery, CSS, Bootstrap
• GitHub/DevOps, Azure
• Web API/ Web Services, Email Services

Skills and Abilities

• Be able to work with diverse global teams and in an individual contributor role as needed
• Excellent English written and verbal communication skills (for local team and global stakeholders/team members)
• Strong task management skills including time management, and ability to manage multiple projects simultaneously
• Flexibility required to attend late evening meetings with global team members
• Attention to detail and delivering quality projects and knowledge assets

Job brief :

We are looking for a Senior Python Developer to build functional and efficient data-centric applications. Lead Python Developer responsibilities include participating in all phases of the software development lifecycle and coaching junior developers. If you're a seasoned developer with a love for back-end technologies, we'd like to meet you. Your ultimate goal is to create high-quality products that meet customer needs.

Responsibilities :

• Help design and implement functional requirements
• Build efficient back-end features in Python
• Integrate front-end components into applications
• Manage testing and bug fixes
• Prepare technical documentation
• Coach junior team members
• Implement software enhancements and suggest improvements

Requirements and skills :

• Solid experience as Python Developer
• Experience with Python frameworks - NumPy, Pandas etc.
• Familiarity with Amazon Web Services (AWS) and REST API
• Understanding of databases and SQL
• Attention to detail
• Leadership skills
• BSc in Computer Science, Engineering or relevant field
• Need data based approach from the person.
• Finance knowledge is a plus.

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

• Excellent troubleshooting and communication skills
• Participate in requirements analysis and give estimates for development.
• Collaborate with internal teams to produce software design and architecture
• Client handling experience
• Write clean, scalable code using .NET programming languages
• Test and deploy applications and systems
• Revise, update, refactor and debug code
• Improve existing software
• Ability to work as a team player also as an individual contributor.
• Understanding of Scrum, Agile and Agile processes.

Required Knowledge, Skills, and Abilities:

• 3+ years of C#, .Net core, ASP.NET MVC professional development experience
• Candidate should have  hands-on with Logic App, Function App, Azure Function
• Working experience on SQL Server and No SQL Database
• Experience in ORM like LINQ & Entity Framework
• Knowledge of the NoSQL Database will be a great advantage.
• Great analytical skills and logical reasoning.
• Thorough understanding of object-oriented programming concepts, and data structures.
• Experience designing and consuming REST APIs
• Experience in JavaScript, jQuery or related frameworks.
• Knowledge of Code Repository systems including GIT, Github & SVN
• Should have strong practical knowledge of API Management Services (APIM)
• Good to have: Angular JS, React JS or any other frameworks.

Tools :  Visual Studio ,Visual studio code ,SQL server management studio, swagger and postman tool
Educational Qualification: BE, MCA OR Msc IT

Wissen Technology is now hiring for a Java Developer with hands-on experience in Core Java, multithreading, algorithms, data structure and SQL skills. (Spring boot is mandatory)

We are solving complex technical problems in the financial industry and need talented software engineers to join our mission and be a part of a global software development team.

A brilliant opportunity to become a part of a highly motivated and expert team which has made a mark as a high end technical consulting.

Required Skills :
Exp – 4 to 10 years (Bangalore/Mumbai)
Experience in Core Java  and above, CXF, Spring.
Extensive experience in developing enterprise-scale n-tier applications for financial domain. Should possess good architectural knowledge and be aware of enterprise application design patterns.
Should have the ability to analyze, design, develop and test complex, low-latency client-facing applications.
Knowledge of multi-threading and high volume server side development
Experience in sales and trading platforms in investment banking/capital markets
Basic working knowledge of Unix/Linux
Excellent problem solving and coding skills in Java
Strong interpersonal, communication and analytical skills.
Should have the ability to express their design ideas and thoughts.

About Wissen:

Wissen Technology is a specialized technology practice for high end consulting primarily geared towards the domains of Banking & Finance, Telecom, and Healthcare. Established in the year 2000 in the US, we have global offices in US, India, UK, Australia, Mexico and Canada, with best in class infrastructure and development facilities spread across the globe. We are an end to end solution provider in Banking & Financial Services, Telecom, Healthcare, Manufacturing & Energy verticals and have successfully delivered $650 million worth of projects for more than 20 of the Fortune 500 companies. We have more than 1400 highly skilled professionals.

We offer an array of services that includes Application Development, Artificial Intelligence & Machine Learning, Big Data & Analytics, Visualization & Business Intelligence, Robotic Process Automation, Cloud, Mobility, Agile & DevOps, Quality Assurance & Test Automation and Infrastructure Management. Wissen is uniquely positioned to help clients with Building Enterprise Systems, Implementing a Digital Strategy and Gaining Competitive Advantage with Business Transformation.

Wissen Technology is been certified as a Great Place to Work® company in 5 years of inception which is a testament to our progressive and flexible work culture. As we cast our eyes to the future, we remain committed to our core philosophy of our management team ‘Employee First’.

The key aspects of this role: 

• Candidate with exceptional programming skills, problem-solving abilities and strong work  ethic. 
• The candidate has to work on custom programming and web application development for  Drupal. 
• Testing, maintenance and troubleshooting of existing company sites and resolving issues if  any. 
• Contributing ideas and efforts towards internal projects and working as part of a team to  find solutions on various problems. 
• Communicate technical ideas to business users and other teams (design, QA). • Collaborate with team members and to work independently when needed. • Eager to embrace current and emerging web technologies. 

To be the right fit, you'll need: 

• Experience of total 4+ years working on PHP and Drupal 7,8 Development (at least 2+ years  in Drupal 8) 
• Strong knowledge of MySQL, jQuery, HTML5, CSS 
• Experience with Drupal architecture, best practices and coding standards 
• Knowledge on Views, Services etc. 
• Experience in custom module and theme creation 
• Familiar with sub version control systems such as Git or SVN 
• Basic knowledge of environment setup for Linux distribution