11+ DCL Jobs in Mumbai | DCL Job openings in Mumbai

Qualifications: - B. Tech/BE/MCA/MSC (IT)  Strong experience in Database design for complex web and mobile application, including writing complex store procedures, function, triggers and ad-hoc queries.  Hands-on development experience with T-SQL.  Strong experience on Database designing, normalization, optimization and performance tuning.  Experience in advanced SQL programming, problem-solving and analytical skills.  Experience in security, troubleshooting and optimizing the performance of databases and stored procedures.  Experience in Refactoring/troubleshooting existing databases as needed.  Deep understanding of referential integrity and indexing.  Assisting with production database issues and helping to troubleshoot and isolate the root cause of issues and provide issue resolution by interacting with Developers.  Ability to estimate development tasks accurately and meet agreed upon deadlines.  Understanding of code promotion, version control and QA procedures.  Good Communication skills.

• Position: Appian Tech Lead
•  
• Job Description:      
•  
• Extensive experience in Appian BPM application development
• Knowledge of Appian architecture and its objects best practices
• Participate in analysis, design, and new development of Appian based applications
• Mandatory Team leadership and provide technical leadership to Scrum teams Certification Mandatory- L1, L2 or L3
• Must be able to multi-task, work in a fast-paced environment and ability to resolve problems faced by team
• Build applications: interfaces, process flows, expressions, data types, sites, integrations,
• Proficient with SQL queries and with accessing data present in DB tables and views
• Experience in Analysis, Designing process models, Records, Reports, SAIL, forms, gateways, smart services, integration services and web services
• Experience working with different Appian Object types, query rules, constant rules and expression rules

 Qualifications:

• At least 6 years of experience in Implementing BPM solutions using Appian 19.x or higher
• Over 8 years in Implementing IT solutions using BPM or integration technologies
• Experience in Scrum/Agile methodologies with Enterprise level application development projects
• Good understanding of database concepts and strong working knowledge any one of the major databases e g Oracle SQL Server MySQL

Additional Information Skills Required

• Appian BPM application development on version 19.x or higher
• Experience of integrations using web services e g XML REST WSDL SOAP API JDBC JMS
• Good leadership skills and the ability to lead a team of software engineers technically
• Experience working in Agile Scrum teams
• Good Communication skills

 

Job Summary

• Candidate will be responsible for providing full life-cycle development (design, coding, and testing) and maintenance of web-based system on Azure
• Candidate should have experience in GitHub, knowledge of DevOps is a plus
• Experienced in designing and implementing web portals, experience with DNN is must
• Ability to work with multiple languages including C#, ASP.Net, MVC, Javascript and related libraries, HTML, Complex SQL queries, CSS, BootStrap, JSON.
• Experience in Agile project management methodology
• Developing and Delivering Excellent Web based solutions/portals/sites based on customer’s requirement within the stipulated timeline
• The candidate should be flexible to learn new technology and platform and should be creative, innovative for improvement ideas, detail oriented, diligent, and eager to learn and grow

Duties and Responsibilities

• Understand business requirements to apply logic to integrate functionalities
• Identify and understand any technical bugs on the server, site, log files or modules and work on resolving the bugs
• Understand how FTP server is setup for the site
• Understand system/site technical requirements and suggest enhancements if applicable
• Designing, coding, unit Testing, and integration with Database
• Handle site deployment
• Designing, coding, debugging, technical problem solving, and writing Unit Test cases, etc.

Qualifications

Education / Certification

• B.E. / B.Tech. /MSC in Computer Science or IT.
• MCAD/MCSD/MSITP/MCPD

Technical Expertise

• ASP/ASP.NET/VB.NET/MVC/C#/SQL Server 2012+
• HTML, Javascript, Jquery, CSS, Bootstrap
• GitHub/DevOps, Azure
• Web API/ Web Services, Email Services

Skills and Abilities

• Be able to work with diverse global teams and in an individual contributor role as needed
• Excellent English written and verbal communication skills (for local team and global stakeholders/team members)
• Strong task management skills including time management, and ability to manage multiple projects simultaneously
• Flexibility required to attend late evening meetings with global team members
• Attention to detail and delivering quality projects and knowledge assets

 

Job Description:

Candidate need to handle the ticket raised by the team, where they asked to perform the operations on database. Once ticket get’s solved they need to update team for the same.

What would be the key responsibilities expected out of this role

1) Help write and optimize in-application SQL statements

2) Ensure performance, security, and availability of databases

3) Prepare documentations and specifications

4) Handle common database procedures such as upgrade, backup, recovery, migration, etc.

5) Good in DML and DDL

Must Have Skills:

MS-SQL 

Good To Have Skills: 

SSIS & SSRS Or MSBI

Notice Period: 

15 Days - 30 Days (Immediate Joiners Preferred)

• Analyze and document requirements for enhancements to systems and / or business processes.
• Write clean, testable code using .NET programming languages
• Develop technical specifications and architecture
• Test and debug various .NET applications
• Review and refactor code
• Deploy fully functional applications
• Upgrade existing programs
• Document development and operational procedures
• Support junior developers’ work

 

Technical Competencies

• Strong understanding of object-oriented programming concepts, design patterns and SOLID principles
• Must have hands on experience with C#, ASP.NET, MVC, Windows Services, .NET Entity Framework, SQL Server/T-SQL, IIS and related technologies
• Expertise in REST APIs and WCF
• Strong knowledge of modern techniques such as Responsive Web Design, LINQ, Dependency Injection and Design Patterns
• Strong Skills and experience with web client technologies inclusive of HTML5, CSS3, JavaScript, AJAX, JSON and JQuery
• Knowledge of various industry standard development practices (Agile methodology, OOD, TDD, BDD)
• Proficient with tools to enable SDLC (TFS, Visual Studio, etc.)

 

Behavioural Competencies

• A go getter attitude with the ability & desire to work in a fast-paced challenging environment
• An innovator mind-set who strives to make things better
• Ability to work independently with the knowledge as well as capability to quickly grasp and make an immediate impact
• Good written & verbal communication skills

"Responsibilities Include Develop, test, implement and maintain application software Take part in software and architectural development activities Transform requirements into implementation details Debug application issues and helping support respond to client queries Participate in application development meetings Provide accurate estimates, clearly communicate status of tasks and identification of risks Commitment to accomplishing the task at hand and identify the fastest and most reliable way to solve a problem Performance tuning of application code at different service levels Incorporate design changes to improve performance of the application Interact with customers of the application and help address issues reported Interact with customers of the application and collect requirements or potential uses cases and draft technical and user requirements

We are looking for some one with 3+ Years of experience  with Microsoft technologies including.NET, ASP.Net Core MVC, C#, MS SQL Server. WPF, WCF C#, ASP.NET, XML, XSL, scripting languages including JQuery/JavaScript and HTML. 

Good to have knowledge with SQL Server 2012, indexing and queries and SSIS/SSRS.

Has Implemented Ajax Controls in C# . Net Projects

Complete understanding of MS SQL Database. Data modelling to visualize database structure.

Writing queries use for front‐end applications (websites, desktop applications, Mobile App or cloud apps).

Good understanding of Reviewing query performance and optimizing code.

Designing and coding database tables to store the application’s data.

Creating database triggers, stored procedures & functions.

Creating table indexes to improve database performance.

Has experience in writing unit tests & performing unit tests on own codes.

 

Responsibilities:‐

• To be responsible for managing technology in projects and providing technical guidance / solutions for work completion.

• To develop and guide the team members in enhancing their technical capabilities and increasing productivity.

• To ensure process compliance in the assigned module and participate in technical discussions/review.

• To prepare and submit status reports for minimizing exposure and risks on the project.

• Experience working with MVC framework.

• Hands on experience on various design patterns

• Experience in Unit testing development.

• Good to have experience on Team foundation server and Agile Development.

• Oversee and review code as required.

• Drive implementation and address technical roadblocks that the team is facing.

• Experience with diagnosing performance and/or memory issues is a plus, including using relevant profiler tools.

• Oversee and assist during system testing, UAT and deployment.

Asp.Net MVC, C# .Net, SQL Server, Jquery

WORK FROM HOME We are looking for a Web Developers to join our dynamic and innovative team, building exciting web and mobile apps in a rapidly growing innovative company. If you are looking to build innovative web applications and mobile apps using the latest technologies with a passionate team then this role is perfect for you. About You We are looking for someone who is passionate about building applications using cutting edge technologies. You will have a deep understanding and JavaScript, Node.js, Reactjs and a solid grasp of software design patters and why they’re important. Required skills: • Degree in IT or computer science (or significant demonstrated experience) • Solid JavaScript, Node.js, Reactjs experience • Good knowledge of JavaScript frameworks such AngularJS and React • Knowledge of Jira, Bitbucket and using Git • Web Fundamentals (HTML5, JavaScript, CSS) • Good understanding of both front and back end development • Demonstrated knowledge of application security and security best practices MUST HAVE Good English Proficiency Preferred skills: • Database concepts and design (table normalization, indexing, performance turning) • Cake PHP, CodeIgniter or other PHP frameworks • AWS technologies such as Amazon API Gateway

Desired Candidate Profile – 1. Must have hands-on experience in C#, C# OOPS concepts, SQL queries up to 3 yrs. (minimum). 2. Must have worked on WCF/Web services/MVC up to 2 yrs. (minimum). 3. Good to have exposure to PostgreSQL. 4. Good to have exposure to Web API (DotNet Core). 5. Good to have exposure to AngularJS (version 2 & above). 6. Good to have exposure to C# Unit Testing (VSTS, NUnit etc). 7. Must have good analytical & logical abilities, can work independently with minimum supervision.

Job Description We are looking for an experienced MySQL database administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams, preparing documentations and specifications as required. Responsibilities Provision MySQL instances, both in clustered and non-clustered configurations Ensure performance, security, and availability of databases Perform database administration tasks, including automation, performance monitoring and tuning, and query optimization. Prepare documentations and specifications Handle common database procedures, such as upgrade, backup, recovery, migration, etc. Profile server resource usage, optimize and tweak as necessary Collaborate with other team members and stakeholders Skills and Qualifications Strong proficiency in MySQL database management Decent experience with recent versions of MySQL Understanding of MySQLs underlying storage engines, such as InnoDB and MyISAM Experience with replication configuration in MySQL(Master slave, Master-Master) Knowledge of de-facto standards and best practices in MySQL Create and Manage MySQL users with proper permissions. Proficient in writing and optimizing SQL statements. Automate day to day regular tasks. Strong knowledge in MySQL Binlog and point in time recovery. Tuning MySQL servers configurations as per the workload. Decent experience in Linux Administration. Knowledge of MySQL features, such as its event scheduler Ability to plan resource requirements from high level specifications Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc. Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases Proficient understanding of code versioning tools such as (Git / Mercurial / SVN) The below qualifications are adds Plus: Public cloud platform (AWS/Azure/GCP). Knowledge in AWS RDS and Aurora. Python scripting. Query Tuning.