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

 

 

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

*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

We are looking for Young, Energetic and Experienced Professionals who can join our Team as Senior Database Developer.
• Experience in Database Development and Support in MS SQL Server environments.
• Hands-on End to End Database Development encompassing Database Design and Development
working with cross-functional teams.
• Hands-on experience of Transact SQL(T-SQL) utilizing SQL Server 2016 and above.
• Excellent understanding of T-SQL programming
• Hands-on experience in SQL - writing hands on experience in complex stored procedure, function,
triggers
• Sound knowledge of SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
• Develop, implement and optimize stored procedures and functions using T-SQL
Review and interpret ongoing business report requirements
• Analyze existing SQL queries for performance improvements.
• Develop procedures and scripts for data migration Provide timely scheduled manage

Requirements:

• Retrieve Data from Databases

SSRS developers optimize SQL server queries to retrieve data efficiently and quickly. As

teams submit requests for different ways of doing things, SSRS developers work with them to find solutions that meet their needs.

• Design Data Solutions

To create and design best-practice data warehouse solutions that support business reporting tasks. This is achieved using different programs and software, such as Microsoft Excel, MS SQL Server, and Tableau.

• Create and Maintain Reporting Processes

To maintain a record of the different reporting processes in place. Evolve ways & means for a more effective data management.

• Resolve IT and Data Issues
• Provide Delivery Plans and Estimates for Projects

1) designing and implementing applications
2) developing and testing software and resolving technical issues that arise
3) Prepare and maintain all applications utilizing standard development tools
4) Utilize backend data services and contribute to increasing existing data services API
5) Lead the entire development life cycle right from concept stage to delivery and post-launch support
6) Convey effectively with all task progress, evaluations, suggestions, schedules along with technical and process issues
7) Document the development process, architecture, and standard components
8) Coordinate with co-developers and keeps project manager well informed of the status of development effort and serves as a liaison between development staff and project manager
9) Keep abreast of new trends and best practices in web development
10) Fixing bugs

Office Location: Goregaon Mumbai

Position description:

4+ years of experience in database development.

Primary Responsibilities:

• Understand requirements from front end applications developers
• Write advanced queries, stored procedures, cursors, functions & triggers
• Conduct code reviews
• Work with high-traffic application servers
• Complete understanding of various DB like Postgresql, Mongo DB, MySQL 
• Ability to identify root cause and mitigate issues
• Ability to lead a team of DB developers

Required Skills:

Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented, Strong communication skills

 

Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, DB Backup/Recovery.

We are looking for a Senior Software Engineer to implement functional software solutions. The goal will be to develop high-quality software/s that is aligned with user needs and business goals.Roles & Responsibilities :- Will own a complete platform from initial architecture, design of components, quality and deployment planning- Will act as an evangelist for the product platform. Identify right technologies for the business use cases. Will be involved in creation of user manuals, internal documents and customer API documentations.- Will understand requirements by studying information needs, discussing with the stakeholders, understanding workflow processes, data flows. Create design and architecture documents to explain, justify and evaluate design approaches.- Should be strong in design principles and have implemented them in existing projects.- Involved in troubleshooting existing applications in production. Identify and build tools for troubleshooting.- Will be involved in creating flowcharts and data flow diagrams. Will be involved in code review for peers. Should be able to identify and implement best practises.- Should be an advocate of automating daily tasks. Should have a high inclination towards building self managed systems.- Should be aware of the latest technology trends. Should participate in professional publications, conferences and events.- Will be involved in mentoring junior team members and aligning them towards company goals.- Identify and implement metrics for measuring platform stability and end user feedback.Requirements :- BS/MS degree in Computer Science/Information Science, Engineering or related field from reputed institute.- Experience of 4-7 Yrs- He/She has built distributed systems. Has the capacity to identify a problem and provide a solution- Has experience with scalable applications. Should identify probable bottlenecks and come up with approaches to mitigate them.- Has experience in working in cloud infrastructure. Should have exhibited capability in identifying and working with IaaS and PaaS providers.- Has a good understanding of OOPs and Functional programming concepts.- Has hands on working experience in one or more of the technologies like PHP (laravel, YII, Code Ignitor ), NodeJs (hapi.js express.js, socket.io), Golang, Java.- Have a working knowledge of web technologies like HTML, CSS and Javascript.- Has experience in identifying database solutions for a given problem. Should have experience working with one of RDBMS and NoSQL databases.- Has a good knowledge about API fundamentals.- Should have worked with third party APIs integrations.- Good written and verbal communication skills.- Should be a highly motivated and a quick learner.

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