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

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

• 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 widgetss
• Managing Social Media Management Tools

What we are scouting for

• BS/MS in computer science or equivalent work experience in IT
• 2+ years’ experience designing and developing applications using Java EE platforms
• A strong hands-on programming knowledge in Core Java including Java 8. To solve the problem given in optimized way.
• Strong knowledge on the Data structure and algorithm.
• Experience developing and designing API integrations using SOAP/RESTful
• Should be able to understand the time complexity of the existing algorithm. Able to compare different algorithms available.
• Expert understanding of the object-oriented design and programming concepts
• Know the fundamentals of Object-Oriented Programming using Java;
• Used SQL & NoSQL solutions
• Experience in GIT/SVN, build tools such as Ant/Maven/Gradle
• Experience in JUnit, Sonarqube, Mockito, Jacoco, Maven & Jenkins

Technical Competency – Nice to have

• Experience in Dependency Injection, Annotation, Validations, Auto Wiring
• Good knowledge in internal working on Memory Management, Transaction management
• Knowledge on DevOps pipeline tools like Jenkins, tools for Code quality scan, tools for security scan
• Spring boot
• Spring MVC
• Any Java Certification

Behavioural Competency

• Strong interpersonal communication skills
• Ability to lead self and team toward common goals
• Excellent oral and written communication, presentation, and analytical skills
• Excellence in technical communication with peers and non-technical cohorts

What you will be doing

• As a self-motivated and enthusiastic member of our team, you will work with extremely talented peers in a fun environment building performance efficient payment authorization services that are highly scalable, configurable and available
• You’ll work in an Agile environment with a focus on problem solving and engineering excellence.
• Worked independently and as a member of a team, determined to make active contributions to the assigned Team
• Flexible and adaptable approach to the roles assigned to you
• Ability to coordinate and prioritize tasks, and work in a fast paced and challenging environment
• Deliver on time under dynamics with a high level of integrity and flexibility, sense of urgency, attention to detail and quality standards
• Make a large impact on the design, architecture, and implementation of cutting edge products
• Work with other team members to investigate design approaches, prototype new technology

and evaluate technical feasibility

• Work in an Agile/Scrum environment to deliver high quality software
• Establish architectural principles, select design patterns and then mentor team members on their appropriate application

What You'll Do


You will be part of our data platform & data engineering team. As part of this agile team, you will work in our cloud native environment and perform following activities to support core product development and client specific projects:

• You will develop the core engineering frameworks for an advanced self-service data analytics product.
• You will work with multiple types of data storage technologies such as relational, blobs, key-value stores, document databases and streaming data sources.
• You will work with latest technologies for data federation with MPP (Massive Parallel Processing) capabilities
• Your work will entail backend architecture to enable data modeling, data queries and API development for both back-end and front-end data interfaces.
• You will support client specific data processing needs using SQL and Python/Pyspark
• You will integrate our product with other data products through Django APIs
• You will partner with other team members in understanding the functional / non-functional business requirements, and translate them into software development tasks
• You will follow the software development best practices in ensuring that the code architecture and quality of code written by you is of high standard, as expected from an enterprise software
• You will be a proactive contributor to team and project discussions

Who you are


• Strong education track record - Bachelors or an advanced degree in Computer Science or a related engineering discipline from Indian Institute of Technology or equivalent premium institute.
• 2-3 years of experience in data queries, data processing and data modeling
• Excellent ANSI SQL skills to handle complex queries
• Excellent Python and Django programming skills.
• Strong knowledge and experience in modern and distributed data stack components such as the Spark, Hive, Airflow, Kubernetes, Docker etc.
• Experience with cloud environments (AWS, Azure) and native cloud technologies for data storage and data processing
• Experience with relational SQL and NoSQL databases, including Postgres, Blobs, MongoDB etc.
• Familiarity with ML models is highly preferred
• Experience with Big Data processing and performance optimization
• Should know how to write modular, optimized and documented code.
• Should have good knowledge around error handling.
• Experience in version control systems such as GIT
• Strong problem solving and communication skills.
• Self-starter, continuous learner.

Good to have some exposure to

• Start-up experience is highly preferred
• Exposure to any Business Intelligence (BI) tools like Tableau, Dundas, Power BI etc.
• Agile software development methodologies.
• Working in multi-functional, multi-location teams

What You'll Love About Us – Do ask us about these!

• Be an integral part of the founding team. You will work directly with the founder
• Work Life Balance. You can't do a good job if your job is all you do!
• Prepare for the Future. Academy – we are all learners; we are all teachers!
• Diversity & Inclusion. HeForShe!
• Internal Mobility. Grow with us!
• Business knowledge of multiple sectors

• As a polyglot developer Ideally, you should have:
• 1.5+ years of development experience using any of technology java, scala, python or any similar exciting technologies.
• Hands-on experience in coding, and implementation of complex, custom-built applications Working knowledge of build tool like maven/sbt and code versioning systems like git/bitbucket/cvs/svn
• Familiarity with few databases, like MySQL, Oracle, PostgreSQL, SQL Server, NoSQL etc Great OO skills, including strong design patterns knowledge
• Good communication and ability to work in a consulting environment is essential

• Think through hard problems in a consultancy environment, and work with amazing people to make the solutions a reality Work in a dynamic, collaborative, non-hierarchical environment where your talent is valued over your job title or years of experience
• Build custom software using the latest technologies and tools Craft your own career path

• Providing solution to real problems in Bigdata world.
• RnD on using the latest tools,techniques and cloud services.
• Automating the manual-timetaking tasks.
• Hands-on coding, usually in a pair programming environment.
• Working in highly collaborative teams and building quality code
• Working in lots of different domains and client environments
• Understanding the business domain deeply

Required Technical Skills: 

• Java (highly capable)
• SQL (highly capable)
• Strong knowledge of software best practices, build processes, IDEs, database tools (e.g. SQL Developer, SQL Management Studio)
• Strong knowledge of source code control systems (GIT)
• Confident with Windows, Linux, Unix operating systems including command line
• Working knowledge of JIRA

Beneficial Technical Skills: 

• .Net
• C 
• Javascript 
• Experience in test management and test execution
• Experience of Agile development methods

Additional Skills and Behaviour Required 

• Experience of full software development lifecycle
• Considers competing solutions and evaluates options to create the best outcome in all aspects of the role.
• Willingness to takes ownership of whole project and engineers assigned.
• Confident to make suggestions and recommendations for improvements.
• Excellent written and verbal communication skills and ability to build good rapport
• Fluency in English, both written and oral
• Collaborates with others to achieve objectives and ensure information flow
• Seeks assistance and feedback as appropriate 

Education 

• Bachelor's degree (or equivalent) in Computer Science or Engineering or other relevant discipline (MCA, MSc in Computer Science etc.)

Job Description-

Backend Developer- Senior

Experience - 3-6 years

Location: Pune/Kota

Minimum Qualifications:

- BE/B.Tech or ME/M.Tech in Computer Science.

- Must have “Can Do Attitude” towards work

- Must have work exp of 3-6 years

- Must have programming exp of 1-2 years in any of Python/Golang/Java languages

- Must have worked in product based company

- Ready to work in a startup and adaptable to a dynamic environment

- Ready to accept ad-hoc requirements and track them till they get implemented

- Ready to learn new technologies like Andriod, Angular, etc.

- Good at HTTP basics, OOPs concepts, data structures, algorithms, networking and

security aspects

- Ability to write clean code and maintain it

- Good at SQL/No-SQL databases

Preferred Qualifications:

- Experience in any good product based startup

- Experience in working with the team and managing a small team of 2-5 associates

- Experience in being a mentor for co-developers

- Experience in design/developing scalable systems.

- Experience in public cloud platforms services/APIs of AWS, Google Cloud, etc.

- Experience in data engineering

- Experience in SOA/Microservice architecture development

Responsibilities:

- Design and develop scalable services and APIs in Python/Golang

- Always maintain the services secure

- Should optimize APIs for mobile data and apps

- Use off-the-shelf and state-of-the-art services for faster development of product

- Guide team members with designs

- Take the end to end ownership of features and resolve customer issues on priority

- Mentor/guide/monitor junior developer

- Expertise Android/Angular to the required extent and guide app developers while

designing APIs

Opportunities in the role:

- LearnAngular, Python, Node.js, Golang, ELK stack, MEAN/MERN

- Work on AWS, Azure, Google Cloud Platform

- Work on databases like RDS, MongoDB, Big Table & DynamoDB, Redis, Aerospike

- Experience with SQL/ NoSQL Databases (RDS, DynamoDB, Google Datastore, Redis)

- Experience with ELK stack.

- Fast prototyping of proof-of concept features/application based on a brief

- Work on data engineering