DBA

Job Profile

Purpose of Role: To support and maintain the existing and future applications managed by ABD (Agile Business Development) Team.

 

Main Responsibilities:

• To work on existing and future applications as required
• Work with ABD India Application Support and Business Support team to address production issues and/or to do development work
• Work with US ABD team to coordinate the on-going support and monthly release of C-Hub (Customer-Hub) application and other ABD Applications
• Report status to management on project progress
• Identify and escalate related issues and risks
• Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies 
• Assess current modules and offer performance improvements techniques  
• Make sure Database Design Standards/coding standards established by ABD are followed
• Constant communication with ABD leadership team in US.
• Problem Solving ability with “Can-do” attitude
• IT experience in Banking industry is preferred

Candidate Profile:

• Minimum 10 years of experience at least 3-5 years of experience in Corporate & Investment Banking area and Bachelor's degree in Engineering, Accounting, Finance, or equivalent
• Expertise with MS SQL Server development including SSIS and SSRS, Proficient in development of Stored procedure, Views, Functions etc in MS SQL Server
• Experienced with DBA kind tasks such as replication, linked server, query analyzer, DBCC commands, data transfer from one DB server to other DB Server etc
• Experienced in MS Excel VBA and macro scripting
• Knowledge of data Encryption in database

 

 

5+ Yrs in SSIS, SQL
Bangalore
Immediate

• Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
• Understand platform’s data model (table structures, linkages, optimal designs) for designing various planning use cases
• Review and analyse the data provided by customers along with its technical/functional intent and interdependencies
• Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data
• Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery
• Create and execute test plans,document issues and track progress at resolving issues.

*Apply only if you are serving Notice Period

HIRING SQL Developers with max 30 days Of NOTICE PERIOD

Job ID: TNS2022DB08

Who Should apply?

• Only for Serious job seekers
• Technically Strong Candidates who are willing to take up challenging roles and want to raise
their Career graph
• No DBA’s & BI Developers please
Why Think n Solutions Software?
• Exposure to latest Technology
• Opportunity working in different platforms
• Rapid Career Growth
• Friendly Knowledge sharing Environment

Criteria:

• BE/MTech/MCA/MSc
• 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
• Immediate joiners preferred/ Maximum notice period between 15 to 30days
• Candidates will be selected based on logical / technical and scenario-based testing

Note: Candidates who have attended the interview process with TnS in the last 6 months will not be eligible.

Job Description:

1. Technical Skills Desired:
a. Experience in MS SQL Server and one of these Relational DB’s, PostgreSQL / AWS
Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in
an application development environment and eagerness to switch DB.
b. Design database tables, views, indexes
c. Write functions and procedures for Middle Tier Development Team
d. Work with any front-end developers in completing the database modules end to end
(hands-on experience in parsing of JSON & XML in Stored Procedures would be an
added advantage).
e. Query Optimization for performance improvement
f. Design & develop SSIS Packages or any other Transformation tools for ETL
2. Functional Skills Desired:
a. Banking / Insurance / Retail domain would be a plus.
b. Interaction with a client a plus.
3. Good to Have Skills:
a. Knowledge in a Cloud Platform (AWS / Azure)
b. Knowledge on version control system (SVN / Git)
c. Exposure to Quality and Process Management
d. Knowledge in Agile Methodology
4. Soft skills: (additional)
a. Team building (attitude to train, work along, mentor juniors)
b. Communication skills (all kinds)
c. Quality consciousness
d. Analytical acumen to all business requirement
e. Think out-of-box for business solution

Why Think n Solutions Software?
• Exposure to latest Technology
• Opportunity working in different platforms
• Rapid Career Growth
• Friendly Knowledge sharing Environment

Criteria:
• BE/MTech/MCA/MSc
• 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
• Immediate joiners preferred/ Maximum notice period between 15 to 30days
• Candidates will be selected based on logical / technical and scenario-based testing

Note: Candidates who have attended the interview process with TnS in the last 6 months will not be
eligible.

Job Description:
Technical Skills Desired:

• Experience in either of these Relational DB’s MS SQL Server / PostgreSQL / AWS Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch DB.
• Design database tables, views, indexes
• Write functions and procedures for Middle Tier Development Team
• Work with any front-end developers in completing the database modules end to end (hands-on experience in parsing of JSON & XML in Stored Procedures would be an added advantage).
• Query Optimization for performance improvement
• Design & develop SSIS Packages or any other Transformation tools for ETL

Functional Skills Desired:

• Banking / Insurance / Retail domain would be a plus.
• Interaction with a client a plus

Good to Have Skills:

• Knowledge in a Cloud Platform (AWS / Azure)
• Knowledge on version control system (SVN / Git)
• Exposure to Quality and Process Management
• Knowledge in Agile Methodology

Soft skills: (additional)

• Team building (attitude to train, work along, mentor juniors)
• Communication skills (all kinds)
• Quality consciousness
• Analytical acumen to all business requirement
• Think out-of-box for business solution

• BE/MTech/MCA/MSc
• 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
• Immediate joiners preferred*
• Candidates will be selected based on logical/technical and scenario-based testing

 

Note: Candidates who have attended the interview process with TnS in the last 6 months will not be eligible.

 

 

1. Technical Skills Desired:
   1. Experience in MS SQL Server and one of these Relational DB’s, PostgreSQL / AWS Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch
   2. Design database tables, views, indexes
   3. Write functions and procedures for Middle Tier Development Team
   4. Work with any front-end developers in completing the database modules end to end (hands-on experience in parsing of JSON & XML in Stored Procedures would be an added advantage).
   5. Query Optimization for performance improvement
   6. Design & develop SSIS Packages or any other Transformation tools for ETL

 

1. Functional Skills Desired:
   1. Banking / Insurance / Retail domain would be a
   2. Interaction with a client a

1. Knowledge in a Cloud Platform (AWS / Azure)
2. Knowledge on version control system (SVN / Git)
3. Exposure to Quality and Process Management
4. Knowledge in Agile Methodology

 

1. Soft skills: (additional)
   1. Team building (attitude to train, work along, mentor juniors)
   2. Communication skills (all kinds)
   3. Quality consciousness
   4. Analytical acumen to all business requirements

Think out-of-box for business solution

 

• Over 2 years of Dynamics NAV consultancy experience/ Minimum 1 Yr experience in Business Central
• Strong understanding of Microsoft Dynamics NAV 2009/2013/2015/2016
• Undertake the design, coding, testing, releasing the code, and NAV / Dynamics 365 Business Central support
• Proficient in RDLC Report Development & SQL Server Database
• Experience working on the technical side of Dynamics NAV / Dynamics 365 Business Central
• Should be fluent and conversant with (A/L, C/AL & C/Side) Programming and ability to do developments independently
• Experience in working on full life cycle implementations across multiple versions of Dynamics NAV
• Excellent understanding and knowledge of core Microsoft Dynamics NAV modules
• Manage resources and deliver project tasks, both external and internal. 
• Communicate and document system specifications for clients and team members. 
• Manage multiple developments and project initiatives at one time, while effectively communicating utilization, roadblocks, and progress to technical leadership and prioritizing based on feedback.
• Strong understanding of Microsoft Dynamics NAV/BC and its modules.
• Strong analytical skills with an ability to diagnose problems quickly and recommend solutions
• Excellent time management skills and ability to meet deadlines and work under pressure

Responsibilities and Duties

The candidate will be responsible for working on .NET based projects for our clients in USA. The candidate must be self-motivated and quick learner. The candidate should also be able to communicate with the client on a regular basis and gather requirements from the client, provide updates. The work would be in ASP.NET / VB.NET and C# with SQL Server databases. The candidate will be responsible for maintaining existing web applications as well as implement new applications based on client requirements.

Required Experience, Skills and Qualifications

- Must have 3+ years experience in ASP.Net with C# and VB.NET
- Must have at least 2 years experience in SQL Server
- Must have experience working with SOAP and REST Web Services
- Must have experience with SSRS and SSIS
- Must have some experience with MVC framework and Angular JS
- Must be able to work with basic CSS and HTML
- Must be able to work with jQuery and Javascript
- Experience with Reporting Services, WCF, etc would be a strong positive

Ecperience- Minimum 3 years
Location - Ahmedabad

We are urgently looking Azure Data Factory Engineers with 3 to 7 years of overall experience, having good experience on Azure Data Factory and SSIS.

Requirements:

• Qualification: Engineering Graduate.
• Years of Experience: 2+ yrs of relevant experience on Azure Data Factory & SSIS.
• Strong understanding of ETL/ELT concepts.
• Hands on experience on Azure Data Factory.
• Exposure of Cloud technologies, standards, and platforms.
• Sound knowledge of ADF pipeline, configuration, parameters, variables, Integration services runtime (part of Data Factory).
• Strong Experience on SSIS.
• Sound knowledge of implementing slowly changing dimensions and transactional, fact less, snapshot fact tables.
• Azure Data Warehouse.
• Knowledge on Azure components especially file storage and Azure Sql, Blob storage and Data Lake Gen2 storage (just used as a file system on the blob).
• Azure Data Migration tool.
• Well versed with RDBMS systems like Sql server, DDL, DML scripts.
• Sound knowledge of T-SQL and stored procedures.
• Strong Query writing skills, Scheduling tools.
• Ensure quality deliverable and ability to extend work hours if required.
• Azure Certification: Preferred.
• Ability to understand Customer requirements and convert the requirements into technical specifications.
• Ability to understand the overall solution and design components to fit the overall solution.
• Ability to take technical decisions and support the decisions with justifications.
• Ability to work in Agile manner.
• Ability to work independently without much guidance.
• Self-Motivated, team player, results oriented, strong Time Management skills.
• Excellent written and verbal communication skills.
• Willing to travel to outside India (Short term as well as long term)

Duration of contract: 12 Months Total Yrs. of Experience: 7years Relevant Yrs. of experience: 7years Detailed JD *(Roles and Responsibilities): · 7 yrs experience with technology. · Proven experience with heavy usage of SSIS and SQL database tool and related infrastructure like development, deployment, administration and investigation of issues with quick turnaround (functional as well as performance). · Demonstrated development/deployment/administration/support with SSAS Tabular project using advanced concepts like percentile, partitioning, row level security implementation is a must · Good understanding of reporting UIX and demonstrated development of reports using "Online Microsoft Power BI" features and visuals for 5K+ users. · Demonstrated effective and proactive communication with clients · In general, the candidate would be working in fast paced agile environment having around 8-10 team members to work with and direct daily client interaction (in second shift 2pm to 11pm) in GDM model. The daily activities would be as below but not limited to o identify data needs and analyze available data o comprehend business and technical requirements o analysis of code and understanding existing system o and preparing high level design document, low level design o contributions to schedule and effort estimation o Build, Unit testing, Understanding of configuration management · SQS Server 2016 experience is plus · Azure experience related to Microsoft business intelligence stack is a plus · SSRS experience is good to have

Who we are? A smart tech company that places more focus on lateral thinking and uses common sense to create innovative models and create an impression at the world stage. From being an absolute no paper usage to being the most desired organisation to work with and create the perfect partners for business and perfect workplace for any professional. We intend to change the way business will be conducted and managed henceforth What is Eazo? An integrated app for logistics - Supply chain needs to evolve. There are many pieces that needs to be brought together to drive an effective model which now Eazo has designed using it’s ecosystem while tapping in to the largest workforce imagined.