Best Opportunity for Experienced Professionals
Role/Position - SQL DB Dev Analyst
Job Description
Proven work experience of 8+ years as a database developer.
In depth understanding of data management (e.g. permissions, recovery, security and monitoring)
Hands on experience with MS SQL Server.
Developed and maintained various T-SQL stored procedures for different applications, reports and agent jobs.
Worked with DB administrator to provide overall performance tuning of Database System which include applying Indexes and refining stored procedure.
Completed the conversion of various legacy DB applications.
Design, code, test and debug business logic for software applications using T-SQL per defined technical specifications.
Excellent analytical and organization skills.
Knowledge of software development and user interface web applications.
An ability to understand front-end user requirements and problem-solving attitude.
Should have excellent analytical and communication skills.
Qualifications
· B.E. / B.Tech. /MSC in Computer Science or IT.
Additional information Responsibilities:
· Maximize system efficiency by regularly tuning and optimizing stored procedures.
· Able to perform data analysis to clean up data, creating queries and automation routines.
· Translate use cases into functional applications
· Ensure the best possible performance, quality and responsiveness of applications.
· Help maintain code quality
· Able to work well in a team setting.
Notice Period - 15 days
Salary Package - Open

Similar jobs
Greetings!
Wissen Technology is hiring for Java developers/Lead.
Required Skillset
- 6+ years of industrial experience
- Java and related frameworks.
- Experience in Core Java 1.8 and above, Data Structures, OOPS, Multithreading, Microservices, Spring and Swift Payments
- Exposure on Fintech domain is mandatory
- Should have the ability to analyse, design, develop and test complex, low-latency client-facing applications.
- Good development experience with RDBMS
- Good knowledge of multi-threading and high volume server side development
- Excellent problem solving and coding skills in Java
- Strong interpersonal, communication and analytical skills.
Company Profile:
Company Name : Wissen Technology
Group of companies in India : Wissen Technology & Wissen Infotech
Work Location - Bangalore
Website : www.wissen.com
Wissen Thought leadership : https://www.wissen.com/articles/
LinkedIn: https://www.linkedin.com/company/wissen-technology

Position Responsibilities :
- Develop, maintain, and enhance a variety of on-prem and SaaS business applications supporting Deltek’s global business units.
- Research and analyze business requirements, provide conceptual and detailed designs to meet various business application needs, including but not limited to HR, Finance, and Enterprise Applications. Includes requirement to develop, enhance, manage configurations, and test and support the rollout of solutions as well as database and interface architecture design/support for moderate to complex projects
- Engage in all aspects of Agile development including understanding business requirements and testing support to analyze and mitigate issues.
- Apply systems and database knowledge to troubleshoot and resolve complex problems using various technical skills such as SQL and configuration setup
- Participate in code reviews and change management (release) process to develop and implement new applications and updates to existing applications
- Interface with third-party software vendors to escalate and resolve integration and software/technical issues
- Maintain pulse on emerging tools, software practices, and technologies to improve solution cost and quality
- Develop and maintain architectural documentation to sustain system integrity and facilitate knowledge-sharing
- Collaborate cross-functionally with senior-level management, business owners, solution architects, business system analysts, project managers, and other engineers/developers to discuss technical options to meet business requirements to achieve secure and scalable solutions.
Qualifications :
- Bachelor's Degree or equivalent experience is required
- A minimum of 8-10 years of experience working in an IT environment
- At least 6-8 years of experience as a developer and/or system engineer
- Experience leading complex projects/tasks
- Strong hands-on experience with a variety of code, interface, API, and database concepts
- Experience in full project life cycle development for systems and applications
- Experience integrating and customizing business applications
- Excellent oral and written communication skills, with the ability to collaborate effectively with team members at all levels, from junior developers to senior managers and business customers
- A strong desire to learn the latest technologies and the ability to acquire knowledge quickly
- Exceptional problem-solving and debugging skills


· Good understanding of OOPS, design principles and design patterns.
· C# development experience.
· Experience with WCF is required.
· Experience of working with web API is required.
· Experience with Windows services and Winforms will be useful.
· Experience of working with .NET Core is useful. Some exposure is expected.
· Experience of working with MS SQL Server.
· Experience of working with micro services will be useful.
· Experience of working with any queueing middleware like MSMQ, Rabbit MQ, WMQ will be useful.
· Exposure to cloud provisioning will be useful, in particular Azure.
· Exposure to security vulnerabilities and top 10 from OWASP will be useful.
· Exposure to front end technologies will be useful. Though it’s secondary but any experience with
SPA libs and frameworks in particular will be useful. Experience with either Angular or React will be
useful.
· Experience with any or all stated tools – TFS, Git, SOAP UI, Postman, Fiddler,
· Experience with CI/CD devOps tooling and practices is useful.
Soft skills required
· Good communication skills, both verbal and written. S/he should be able to articulate well.
RequiredSkills:
• Minimum of 4-6 years of experience in data modeling (including conceptual, logical and physical data models. • 2-3 years of experience inExtraction, Transformation and Loading ETLwork using data migration tools like Talend, Informatica, Datastage, etc. • 4-6 years of experience as a database developerinOracle, MS SQLor another enterprise database with a focus on building data integration process • Candidate should haveanyNoSqltechnology exposure preferably MongoDB. • Experience in processing large data volumes indicated by experience with BigDataplatforms (Teradata, Netezza, Vertica or Cloudera, Hortonworks, SAP HANA, Cassandra, etc.). • Understanding of data warehousing concepts and decision support systems.
• Ability to deal with sensitive and confidential material and adhere to worldwide data security and • Experience writing documentation for design and feature requirements. • Experience developing data-intensive applications on cloud-based architectures and infrastructures such as AWS, Azure etc. • Excellent communication and collaboration skills.


Job Description:
- Experienced in developing .NET Core, http://asp.net/" target="_blank">ASP.NET MVC, Web applications, WEB /REST APIs with C# Language.
- Proficient in OOP and design Skilled in the use of Structured Query Language (SQL) as a tool for retrieving, updating, inserting, deleting, manipulating, and managing data stored in enterprise databases.
- Strong knowledge of Database concepts and Relational Database Management Systems such as Microsoft SQL.
- Work closely with the other team members to meet the goals.
- Work with Quality Analysts to ensure changes are thoroughly tested before release.
- Communicating project status and timelines to business stakeholders and IT management.
● J2EE with a good understanding of Servlets and JSP
● Experience in Spring Modules – Spring IOC and AOP, Spring Boot (version 2 plus), JDBC
● Expertise in design and development of various web and enterprise – level applications using Java/J2EE
technologies such as Spring, Hibernate, Rest services.
● Web Services (including SOAP, XML, XML Schema, JSON, and REST)
● Tools required: Maven,Eclipse, Github, and Swagger
● Good knowledge of SQL and Redis (NOSql)
● Ability to document requirements and specifications
● Proven work experience as a Software Engineer or Software Developer
● Ability to develop software in Java or any other OOPS languages
● Excellent knowledge of relational databases, SQL and ORM technologies (JPA2, Hibernate)
● Experience in developing Web Applications using at least one popular Web Framework (Spring)
● Experience with test-driven development
● Proficiency in software engineering tools

Job Description:
- To resolve the tickets raised as per the defined standards of time, cost, and quality for increased customer satisfaction.
Skills and Experience
- Good SQL & PLSQL knowledge.
- Good Unix basic commands knowledge.
- Good Unix scripting knowledge will be an advantage.
- ANSI SQL
- Unix - Others/
- Experience - Fresher



Work as a member of a team responsible for problem resolutions requiring extensive analysis, troubleshooting to product development. You will apply your knowledge of building scalable, distributed applications to provide ideal solutions to solving our clients business problems by driving customer experience outcomes with enhanced technical capabilities. Essential Functions include, but are not limited to the following.
You will be expected to:
- Work closely with a team of highly technical engineers distributed geographically.
- Contribute to all phases in the software lifecycle requirements analysis, solution design, development, and delivery
- Build high quality, efficient & reusable code in server-side programming.
- Troubleshoot & debug applications/products
- Ensure assigned projects are developed in accordance with established engineering processes, adhering to scope, schedule constraints and agile project plans
- Guide/mentor the less experienced team members
- Participate in code reviews
- Document and test the features worked on by you or team
- Explore & Propose to incorporate cutting-edge technologies / plugins etc to improve applications
- In addition, position is responsible for a variety of complex Linux, SQL, networking and coding challenges.
Must Have Skills:
- Strong programming skills in C/C++, Knowledge of PHP would be advantageous.
- Experience in Networking software development and Domain Knowledge
- Experience working with Linux
- Good Understanding of Databases (MySQL) and proficiency in SQL Queries.
Good to Have Skills:
- Knowledge of RESTful APIs
- Exposure to DevOPS practices, Continuous Integration (CI/CD), Containers (Docker).
- Experience with Spark Structured Streaming API, MySQL performance optimization, Linux Kernel experience
- Exposure to Test Driven Development



- Bachelors degree in Computer Science, Software Engineering, or a related discipline
- Experience working in an IT environment
- Experience developing with C#, C++, or other object-oriented platforms
- 2+ years of web application development
- Skill for writing reusable libraries
- Hands-on experience in ASP.Net, MVC, Restful services, Web API
- Experience in .Net Web API
- Strong understanding of object-oriented programming
- Strong knowledge of C# programming
- Ability to troubleshoot problems independently. Good analytical and problem-solving skills
- Familiar with various design and architectural patterns
- Strong Knowledge in Microsoft SQL Server scripts and Stored procedures
- Exposure to Agile Software Development Life Cycle
- Experience implementing automated testing platforms and unit tests
- Proficient understanding of code versioning tools such as GIT
- Experience in Service-based architecture

We are looking for a passionate Junior/ Senior DOT NET Developer to design and develop software solutions on Microsoft and popular open-source technologies. Software Engineer responsibilities include gathering user requirements, defining system functionality, and writing code in various languages, like .NET, C#, ASP.NET MVC, SQL, JavaScript, and JQuery. Ideally, the candidate should be able to build high-quality, innovative, and fully performing software in compliance with coding standards and technical design. The developer must be skilled in development, writing clean and scalable code, and documenting user requirements.
- Executing full life-cycle software development
- Writing well designed, testable, efficient code
- Producing specifications and determining operational feasibility
- Integrating software components into fully functional software systems
- Developing software verification plans and quality assurance procedures
- Documenting and maintaining software functionality
- Complying with project plans and industry standards.
Requirements
- Must have hands-on experience in Microsoft technologies - ASP.NET, MVC, Web API, Web Forms and window forms.
- Must have a strong understanding and knowledge of OOPS concepts.
- Good knowledge of C# programming language .
- Good knowledge of Client-side programming using HTML5, CSS3, JavaScript, JQuery, etc.
- Experience with Web Services, WCF, and Service-Oriented Architecture a plus.
- Well-versed with Entity Framework, Linq, Dependency Injection, Unit of Work, Architecture Pattern, Lambda Expressions etc.
- Good knowledge of Microsoft SQL Server .
- Experienced in debugging, analyzing code, and knows how to performance tune a DB Query.
- Experience with design patterns.
- Additional Knowledge of IIS, Web Services, JSON, and XML are added skillsets
- Degree in B.Tech(CSE)/ MCA/ MSC(IT)

