Tech Support Engineer - Fresher sql queries

ABOUT US. (https://www.ashnik.com/" target="_blank">https://www.ashnik.com/)

Established in 2009, Ashnik is a leading open-source solutions and consulting company in South East Asia and India, headquartered in Singapore. We enable digital transformation for large enterprises through our design, architecting, and solution skills. Over 100 large enterprises in the region have acknowledged our expertise in delivering solutions using key open-source technologies. Our offerings form critical part of Digital transformation, Big Data platform, Cloud and Web acceleration and IT modernization. We represent EDB, Pentaho, Docker, Couchbase, MongoDB, Elastic, NGINX, Sysdig, Redis Labs, Confluent, and HashiCorp as their key partners in the region. Our team members bring decades of experience in delivering confidence to enterprises in adopting open source software and are known for their thought leadership.

As a team culture, Ashnik is a family for its team members. Each member brings in different perspective, new ideas and diverse background. Yet we all together strive for one goal – to deliver best solutions to our customers using open source software. We passionately believe in the power of collaboration. Through an open platform of idea exchange, we create vibrant environment for growth and excellence.

THE POSITION

Ashnik is looking for talented and passionate people to be part of the team for an upcoming project at client location.

QUALIFICATION AND EXPERIENCE

• Preferably have a working experience of 4 Years and more , on production PostgreSQL DBs.
• Experience of working in a production support environment
• Engineering or Equivalent degree
• Passion for open-source technologies is desired

ADDITIONAL SKILLS

• Install & Configure PostgreSQL, Enterprise DB
• Technical capabilities PostgreSQL 9.x, 10.x, 11.x
• Server tuning
• Troubleshooting of Database issues
• Linux Shell Scripting
• Install, Configure and maintain Fail Over mechanism
• Backup - Restoration, Point in time database recovery
• A demonstrable ability to articulate and sell the benefits of modern platforms, software and technologies.
• A real passion for being curious and a continuous learner. You are someone that invests in yourself as much as you invest in your professional relationships.

RESPONSIBILITIES

• Monitoring database performance
• Optimizing Queries and handle escalations
• Analyse and assess the impact and risk of low to medium risk changes on high profile production databases
• Implement security features
• DR implementation and switch over

LOCATION: Pune 
Experience: 2 yrs plus

Experience creating PowerPoint slide decks and along with that experience in automating the PowerPoint slide creation using excel VBA Formats extracted data based on expected report output with batching capability and multiple data formatting requirements Consolidate and combine extracted data from multiple resources using automated tools excel, VBA macro, SQL database, and/or from different system/tools/Database in one single database using SQL queries to standardize data structure

Professional Attributes :
Gathers and analyse report requirements from stakeholders Identify the processing tool Excel / SQL and provide a robust solution which can be easily leveraged or extended to other domains Building complex VBA scripts to automate Excel spreadsheet processes

Job Description:

Candidate should ideally be a B.E/B.Tech graduate with around 3 to 5 years of experience, with core T-SQL scripting , performance tuning, SSIS, NOSQL skills. The current role requires a core T-SQL , NoSQL and SSIS developer. The SQL Developer will be responsible for:

• Creating & designing database and all database objects such as tables, views, StoredProcedures, functions etc.
• Writing and troubleshooting simple to complex SQL scripts, stored procedures, views, functions, etc. as per the requirement.
• Troubleshooting and fixing all performance issues with respect to databases (objects & scripts).
• SQL Query tuning and performance tuning.
• Develop/migrate existing scripts to SSIS.
• Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints, etc.
• Maintaining database objects (like tables, views,Stored Procedures) performance by following the tuning tips like normalization, indexes, etc.
• Importing and exporting the data from different sources using tools, writing required scripts.
• Works closely with other members of the team to accomplish the projects.
• Assists project teams to design and develop core business components utilizing  industry-accepted analysis and design standards.
• Provides and/or assists with, project management and project leadership.
• Create and maintain documentation for all the projects.
• Working with NOSQL databases (Mostly on MongoDB) .

PRIMARY SKILLS: 

TSQL, SQL, NoSQL, Performance Tuning, SSIS, Import & Export of data from different data sources and from different formats.

SECONDARY SKILLS:

Database Administration

REQUIRED SKILLS:

• 3+ years of professional experience in working with MSSQL Server 2008 and above.
• 3+ years of professional experience in writing TSQL scripts.
• Thorough experience in SQL query tuning and performance tuning.
• Experience in developing and maintaining SSIS packages.
• Experience in working with NoSQL databases. MongoDB would be preferable.
• Fluent knowledge of MSSQL server DBA.
• Should be a good team player and should possess good attitude and work ethics.
• Should possess excellent communication and written skills.

PREFERRED SKILLS:

• MSSQL DBA.
• SSIS.
• NOSQL, MongoDB

Job Description

We are looking for .NET developers with following skill sets for building .NET applications.

Asp.Net with MVC 4.0+, Razor, Multi-threading, jQuery, Angular, SOAP API, Web API 2.0, DI Container, IOC, Bootstrap, Bootstrapper, HTML5, MS SQL

Primary responsibility will be to design and develop three layers of applications, and to coordinate with the rest of the team working on different layers of the infrastructure. A commitment to collaborative problem solving, sophisticated design, and quality product is essential.

Job Category            :  Software Engineer
Location                     : Delh

Experience                : 2 to 4 Years

Position Title: Senior Dot Net Developer

Key Responsibilities:

• Individual/ Team.
• Design, build, and maintain efficient, reusable, and reliable code
• Integrate data storage solutions
• Ensure the best possible performance, quality, and responsiveness of applications
• Identify bottlenecks and bugs, and devise solutions to mitigate and address these issues
• Help maintain code quality, organization, and automatization
• Timely submission of reports as necessary and achieving monthly goals is critical to this role.

Competencies:

Should possess sound communication and conflict management skills. 

Experience and Knowledge Requirements:

At least 2 years working experience with MS SQL, Asp.Net Web Form & windows services are mandatory.

Qualification:

MCA / B. Tech/ M.Sc. IT

Required Skillset:

• Strong knowledge of .NET framework
• Strong understanding of object-oriented programming
• Skill for writing reusable libraries
• Familiar with various design and architectural patterns
• Basic understanding of Common Language Runtime (CLR), its limitations, weaknesses, and workarounds
• Experience in generics collections. Client-side libraries like jQuery & Angular 1.3
• Proficient understanding of code versioning tools such as Git, SVN, and TFS
• Solid working experience on MVC, Singleton, abstract factory, facade design patterns

• 4-15 year experience in Application Support
• Must have good knowledge in Java/J2EE, Microservices, PL/SQL, Unix
• Good to have knowledge in Agile, JIRA, Splunk, Service Now
• Good understanding and hands-on experience in Incident, Problem and Change Management
• Provide technical leadership to the team & contribute in the skill development within team
  Interact with internal teams and client stakeholders to trouble shoot the tickets/incident and manage other support activities
• Good communications skills are necessary, must be team player and inquisitive.
• Strong customer service and support focus with a desire to deliver a high-quality service
• Ability to multi-task, work under pressure and to tight deadlines
• Flexible in working outside of office business hours at short notice (as required)
• Should be able to examine the system and identify the areas for Service Improvements & Value adds.

• Minimum 3 years of working experience in database related projects.
• Working experience on any of the leading Database management systems viz., Oracle,SQL-Server, etc. (Experience on Postgres database systems will be an added advantage).
• Adequate Database Development skills & should be proficient in SQL coding.
• Working experience in Database SQL Optimization/Performance Tuning.
• Working experience on any of the Database Programming languages viz., PL/SQL, PL/pgSQL,T-SQL,etc.
• Flexible to learn, adopt & scale to any data centric technologies as per the evolving Organizational product strategies.

• Good to have skill sets of the Candidate:
• Working experience on Data Warehouse projects or exhibits sound knowledge over the concepts.
• Working experience on Data Analytics/Reporting/ETL or exhibits sound knowledge over the concepts.
• Database agnostic approach to data/database solutions.
• Exhibits sound knowledge on Big-data/Hadoop, Kafka, Map-Reduce programming, NoSQL,etc.

The kind of candidates we are looking who has good experience in support role, Must work in L1 &L2,  ready to work in 24/7 environment,  good to have someone worked in ERP OR Mobile App Support.

Job Requirement: 
• Good understanding of QA methodologies, procedures and QA documentation. Design, develop and maintain test cases.
• Work closely with onsite team & client on Application Support, Maintenance & Implementation tasks.
• Must be able to perform detailed analysis from logs, Query results for an issue reported
• Must be willing to work work in Shift Environment including night shifts and in 24x7 mode, even on Public Holidays as per roaster setup.
• Ready to travel on client site (even on short notice)
• Have sound knowledge about at least one Incident Management system/application.
• Can able to work as an individual contributor and within team as well
• Maintain relevant status reports, in timely manner
• Self-motivated, goal oriented, self-driven, strong interpersonal skills

Desired Candidate Profile:
• IT Graduate
• 3-5 years of technical experience in Application Support, Maintenance & Implementation projects, on a complex environment.
• Recent 2 years of experience in Logistics (Shipping) industry, preferably. Knowledge of Container port Operations is Preferrable  

• Check the Cmg's and take the requirements from functional consultants and users.
• As per business logic (MD50) do change existing reports and develop the new reports.
• Developing new packages, procedures, functions and updating existing packages and procedures, functions.
• Developing the workflows.
• Developing the API's as per business logic's for data updates.
• Developing the data extraction automation programs (.sql files developments) for data extractions.
• Prepare the test cases and migration documents for migrating objects.

• Bachelor's Degree in IT/ Computers/ Science or Master's in Computer required.
• 2 - 5 years of relevant experience on Oracle Apps Technical.
• Candidates must have hands on experience on Oracle RDF/XML/Pl-SQL Reports, D2k Forms, Workflow, OAF, And functional knowledge on O2C & P2P.