Software Engineer

• You would be responsible for Developing SQL Databases, automation of business reports and Developing Business Dashboard using BI Tools.
• Development of high quality database solutions 
• Create complex functions, scripts, stored procedures and triggers to support application development.  
• Develop, implement and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements
• Build appropriate and useful reporting deliverables
• Analyze existing SQL queries for performance improvements
• Fix any issues related to database performance and provide corrective measures.  
• MIS Automation
• Provide timely scheduled management reporting
• Create Business dashboard using Tableau BI Tool

Requirement / Desired Skills:

• 5+ years of business Analyst / SQL developer experience in Fintech,internet,consulting etc industry
• Excellent understanding of T-SQL programming
• Excellent understanding of Microsoft SQL Server 
• Good knowledge of HTML and JavaScript 
• SQL Server Reporting Services and SQL Server Analysis Services
• Knowledge of any of the BI Tool (Tableau, PowerBI or Qlikview)

· Providing technical advice and troubleshooting for end users

 · Experience in Enterprise Apple support like ABM, VPP,ACE and MDM

· Excellent OSX desktop and server support skills

· Experiencing supporting OS X desktop and server across a range of versions

· Strong experience with using and administrating JAMF

· Package Deployment, Image upgrade. Security patches &DEP

· Hands on experience with JAMF tools like Recon , Composure , remote and Admin

· Endpoint hardening via JAMF and self service management.

· Experience using terminal commands and scripts

· Great customer relationship skills

· Good written & verbal communication skills

· Being flexible and customer solution focused

· Experience in various application outlook , AD and Teams.

· Cloud knowledge

Job Description:

• Configure and maintain database servers and processes
• Monitor the system's health and performance
• Ensure high levels of performance, availability, sustainability, and security
• Analyze, solve, and correct issues in real-time
• Provide suggestions for solutions
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Provide on-call support for critical production systems
• Perform scheduled maintenance and support release deployment activities after hours
• Basic knowledge of SSRS, SSIS, and Postgres will be added advantage.

Required:
1) WebFOCUS BI Reporting
2) WebFOCUS Adminstration
3) Sybase or Oracle or SQL Server or Snowflake
4) DWH Skills

Nice to have:
1) Experience in SAP BO / Crystal report / SSRS / Power BI
2) Experience in Informix
3) Experience in ETL

Responsibilities:

• Technical knowledge regarding best practices of BI development / integration.
• Candidate must understand business processes, be a detailed-oriented person and quickly grasp new concepts.
• Additionally the candidate will have strong presentation, interpersonal, software development and work management skills.
• Strong Advanced SQL programming skills are required
• Proficient in MS Word, Excel, Access, and PowerPoint
• Experience working with one or more BI Reporting tools as Analyst/Developer.
• Knowledge of data mining techniques and procedures and knowing when their use is appropriate
• Ability to present complex information in an understandable and compelling manner.
• Experience converting reports from one reporting tool to another

Mandatory Skills required:

1. Ability to translate business requirements into technical requirements for QlikView

2. Perform detailed analysis of source systems and source system data and model that data in

Qlikview

3. Design, develop, and test QlikView scripts to import data from source systems, data feeds, flat files

to create Qlik marts

4. Proficiency with QlikView Scripting, use of complex QlikView functions,

advanced QlikView Expressions, experience with complex data models and optimization of data

model for query performance to create Qlik Marts

5. Architecture optimization ( includes hardware sizing , security setup , performance tuning )

6. Development of Qlikview/ QlikSense

• Job Title:- Microsoft Tech Lead
• Location:- CG Road, Ahmedabad(Mobile and flexible), WFH is available, sometime you have to come attend business meetings
• Education:- No bar in Education
• Desired Skills:- ASP.Net, C#, Database Design, MySQL, MSSQL, Bootstrap, SQL Server
• Experience: - 05 yrs. to 06 yrs.
• Number of Vacancy:- 01
• Job Timing:- Flexible Time
• Interview Process: - 2 round, First round is Telephonic, Second round is face to face only.

Job Description

Responsibilities:-

• Plan, lead and deliver the software development cycle.
• Lead technical team and solve their day to day issues.
• The successful candidate would lead a team of 6-10 developers.
• Handle ongoing projects as well as new projects.
• Guide or mentor new team members and existing members.

Skills Requirement

• Experience in Microsoft ASP, C#, SQL server, MS SQL, Bootstrap, database design and github.

Who can Apply

• Education : No bar
• Experience : Good to have: BFSI domain and professional certification

Job Requirement – Sr. SQL _PBI Developer

• Minimum 6+ years of expertise in SQL Database Development including SQL queries, data structures, stored procedures, index etc.
• Excellent written and verbal communication
• Advanced knowledge and experience in T-SQL coding: query writing, stored procedures, triggers and user-defined functions.
• Advanced knowledge and experience in development and maintenance of SSIS and SSAS (Tabular and Multidimensional)
• Advanced knowledge and experience in creating dashboards and reports using PowerBI
• Advanced knowledge and experience in DAX
• Experience in creating and publishing reports using SSRS
• Experience in writing MDX queries
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Optimize and manage SQL server databases
• Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Flexible, team player, “get-it-done” personality
• Ability to organize and plan work independently
• Ability to work in a rapidly changing environment
• Ability to multi-task and context-switch effectively between different activities and teams

Optional Skills (Good to have):

• Microsoft certification in Azure data engineering

Database Administrator (DBA)

EDUCATION,EXPERIENCE REQUIRED:

BE/MCA/ B.TECH / BCA

Exp -  Min 4 yrs  

CTC – Upto 12 LPA

Job Description:

1. Installing, Configuring, Managing, Monitoring and troubleshooting SQL Server 2005/2008/2008R2/2012/2014/2016
2. Database administration activities like Installation, Configuration, Backup & Recovery, and Database Security.
3. Providing availability solutions like Mirroring, Log Shipping, Replication and Always on.
4. Database Up gradation and Migration
5. Ensure performance monitoring, backup, restore, and security recovery solutions.
6. Troubleshooting expertise in SQL server issues under production environment.
7. Handling the entire production servers with skills and understanding client's requirement Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them).
8. Automating process by creating jobs, and error reporting using Alerts by SQL Server Agent.
9. Backup and Recovery strategy, Database Refreshes.
10. Creation and maintenance of Databases, creating Roles and managing user permissions.
11. Setting up, trouble shooting and maintenance of production server databases.
12. Providing Production support for Database and Applications.
13. SQL Server store procedure, functions, View, Index and trigger development.

 

Job requirement:

1. Deep understanding of OS and its management including kernel space management
2. Experience with Linux servers in virtualized environments
3. Experience installing, configuring, and maintaining services such as Bind, Apache, MySQL, Nginx, etc.
4. Experience in Monitoring tools like Nagios.
5. Familiarity with load balancing, firewalls, etc.
6. Proficient with network tools such as iptables, Linux IPVS, HA Proxy, etc.
7. Experience with virtualization technologies, such as Xen KVM and VMware.
8. Ability to build and monitor services on production servers