SQL server Jobs in Pune

*** This role will require you to work at US hours i.e. 6 PM IST to 3 AM IST *** Required Experience, Skills and Qualifications Maintain and monitor all databases across the enterprise to ensure issues are taken care of before they pose a problem. This includes monitoring several dozen physical servers across multiple geographic locations, containing over 200 databases, several thousand tables, spanning billions of records. Monitoring is accomplished via a variety of tools such as scripts, email alerts, dashboards and user inquiries describing end user symptoms that need to be corrected.  Setting up, Maintaining and monitoring database server security via a combination of Active Directory and server level permission settings. Ensure we are compliant with all industry best practices wherever possible, ie PCI compliance, Sarbanes-Oxley Act, etc.,.  Create, implement, test and manage automated database backups for the entire SQL server farm across all geographical locations using industry standard software and best practices Create and maintain all server documentation on the local Wiki regarding security policies, replication polices, server architecure and backup policies. Included in this documentation would be a change log to track changes made by any individual to any live production database at any time. Create, manage and troubleshoot server replication policies all geographical nodes. Troubleshooting will include research and analysis of slow moving replications, missing records and other anomolies that can occur during replication. Participate in design of new databases and servers, working with stakeholders and acting as a subject matter expert to determine proper industry best practices. Assisting Database developers to retrieve data whenever needed, using SQL scripts and procedures Responsible for tuning queries as needed for optimal response time using various methods such as script optimization, file grouping, index creation and optimization as well as location and geographic optimization Responsible for reviewing and publishing changes to the production environment all changes created by the development team using provided scripts and packages on a scheduled basis. Required Skills SQL Skill tSQL / Replication / SSIS / OLAP / Log Idera Backup Software Microsoft SQL Server Administration (SQL 2012+) AtTask or other Project Management software Troubleshooting and data analysis skills Technical documentation skills Required Experience Excellent problem-solving skills and ability to navigate challenging situations, in a professional manner. Work collaboratively with willingness to listen and work in fast paced challenging environment Prior Database Administration experience required Ability to independently apply production upgrades and support the products and technologies Experience in providing services to agreed SLAs. Database architect/developer experience is a plus.

The Technical Lead will be developing internet based and installed software for both internal employee use as well as customer facing use. Our ideal candidate will have experience working in a team environment as well as experience in leading or mentoring team members. We’re looking for a Technical Lead that is self-motivated and is a self-starter. Ideal candidate will have a passion for developing and a genuine interest in providing value to their team and the company as a whole. Essential Duties and Responsibilities Seeking a Technical Lead who has solid C# experience utilizing MVC and Entity Framework. This position will be responsible for working on multiple customer facing websites and internal business applications. Required Skills Visual Studio C# ASP.Net MVC Software Design Patterns CSS HTML JavaScript Interacting with Databases .Net Framework Web Services AngularJS or other similar library Source Control (GIT preferred) Required Experience Prior full-time development utilizing MVC Previous programming experience for a retailer is a huge plus. An Engineering Graduate UA Brands is a Drug Free Workplace. As an employee of any UA Brands division, you will be part of an established and dynamic organization. We believe that success starts from within and we are seeking individuals who thrive in an environment that encourages and supports self-management. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at UA Brands will be based on merit, qualifications, and abilities. UA Brands does not discriminate in employment opportunities or practices on the basis of race, color, religion, sex, national origin, age, disability or any other characteristic protected by law. UA Brands will make reasonable accommodations for qualified individuals with known disabilities unless doing so would result in an undue hardship.

Minimum 4 years of experience in working with C#, JavaScript (NodeJS), .Net Framework, MVC, MEAN Stack, for developing web applications/Web API with Storage like SQL server, MongoDB etc. using ORM like Entity Framework or Custom ORM Working experience in writing high performance and secured Web Services ( WCF, REST Web API) Ability to write a quality and modular code Extensive Web development expertise using Html/Html5, CSS, JavaScript, jQuery, XML,JSON, AJAX along with C#, NodeJS and .Net Framework. Experience in implementing required Design Patterns, good understanding on Solid Principles and Object-oriented application design. Experience in various source control/Agile/Build and release tools like TFS, JIRA, Jenkins etc. Working with Chart controls, Excel Files, Reporting tools is preferable Passionate about building high-quality systems with software implementation best practices while leading and mentoring a team of developers, if assigned to. Analyse, diagnose and resolve errors related to the product/application Capable of defining LOE, project plans based on business requirement Investigate operational or systematic problems and user queries as required Interact and communicate effectively with all levels of staff, senior management and customers Strong debugging skills, communication skills and Dedicated Team player Bachelor degree in related field, or relevant experience

You will be responsible for working as a Business Intelligence developer with a team of other BI developers providing technical Solutions and implement the BI and Analytics strategy and direction to a large-scale e-commerce business. You will be required to be hands-on, bring innovative approaches that continuously improve our ability to deliver faster, better and cheaper solutions while reducing the time and cost to build BI and analytics solutions and on-board with highest quality. You’ll be responsible for designing, developing high quality code solutions with an emphasis on quality, simplicity and maintainability in SQL Server suite of business intelligence and adopt the same in the e-commerce BI solutions. Required Experience, Skills and Qualifications BE/B.Tech/MCA in Computer Science or related field 6+ years of experience and proven track record in end-to-end DW Design, Development and implementation of at least one or more DW project/projects. Excellent ability to translate business requirements into logical, conceptual and physical data models Experience in data warehouse life cycle management Professional, practical programming using SSIS Should be able to quickly adapt to business processes and understand the domain. Strong Logical and Analytical Reasoning Skills, Excellent Communication with good Listening, Presentation and Interpersonal Skills. Possesses a professional demeanor Willing to work hands on as per project / initiative requirements Drive to take up new incentives and deliver them Strong SQL skills Required Skills ETL tools: SSIS Database: SQL Server (2005/2008/2012/2016), Oracle, MySQL Knowledge of SAP BO, Cognos Report Builder is added plus. Required Experience Exposure to dimensional data modelling Hands-on experience experience on DB and ETL Performance Tuning and troubleshooting Strong exposure to database performance tuning Experience in Data Quality Profiling Tools is a plus

We are seeking a DevOps Engineer lead to join our growing Run the Business “RTB” (Continuous Delivery) team here at UA Brands. This engineer would be responsible for designing architecture and managing web application environments and lead cross-functional teams, architecture discussions between development, operations, and QA. If you are looking for an opportunity to solve technical challenges and build innovative solutions in a fast-paced environment working with passionate software developers, this might be the role for you. In addition, this role will play evangelist to come up with creative solution to mitigate future risks and increase operation reliability and performance. Duties and responsibilities. Troubleshooting, diagnosing and fixing production software issues, developing monitoring solutions, performing software maintenance and configuration, implementing the fix for internally developed code (ASP, C#, VB, JavaScript), performing SQL queries, updating, tracking and resolving technical challenges for web applications. These solutions will affect our customers directly! High Impact production issues often require coordination between multiple Development, Operations and IT Support groups, so you get to experience a breadth of impact with various groups. Monitor and optimize server and application performance. Responsible for development and operation of CI/CD pipeline. Define and automate release pipeline and environment, build resilient systems and create repeatable processes. Ideal candidate should be detail-oriented, have superior verbal and written communication skills, strong organizational skills with ability to juggle multiple tasks at once. Must be able to work independently and maintain professionalism under pressure. Should be able to identify problems before they happen and implement solutions that detect and prevent outages Must have the ability to accurately prioritize projects, make sound judgments, work to improve the customer experience, and get the right things done. Participate in requirements gathering sessions. Provide mentoring for junior members of the team and train them. Communicate accurate and useful status reports on a timely basis Required Skills Bachelor's Degree in Computer Science or a related field 8 or more years overall development/technical support experience 8 or more years of Object oriented development experience in C# 5 or more years’ experience with SQL, relational data management Required Experience Excellent problem-solving skills and ability to navigate challenging situations, in a professional manner. Qualification should be BE / B.Tech / Computer Science / MCA Work collaboratively with willingness to listen and work in fast paced challenging environment Ability to independently apply production upgrades and support the products and technologies Experience in providing services to agreed SLAs.

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

Full Stack Leads and Developers: Microsoft Technologies As a full-stack leads and developers, you'll be working across an entire product platform, from public-facing enterprise apps, to internal tools, APIs, third-party systems & services, and cloud focused environments. Leads having 6+ years and Developers having 3+ years of relevant experience can apply. Must Have •Relevant experience in web development .NET Core, ASP .NET , Entity Framework and Azure Web Apps •Relevant experience in web development Nodejs, MEAN Stack and AngularJS/ React. •Good understanding of relational data modelling concepts and comfortable with SQL databases - specifically MSSQLServer or MySQL •Ability to work with clients and key stakeholders to ensure requirements are met •Strong problem solving and debugging skills •Passion to work in an start-up environment and readiness to dabble with challenging technologies. Nice to Have •Exposure to search solutions like Elasticsearch and So will be an advantage. •Exposure to enterprise development environments - both on premise and Azure cloud services. •Exposure or readiness to learn new web development technologies – Typescript, React. What Cognologix offers •People first Culture, Growth, Challenging Problems •Smart co-workers and mentors, agile and cross functional teams •We are equal employment opportunity provider. We firmly believe that a diverse and equitable workplace is critical to our business. Introduce Yourself If you don't see a role that is directly relevant to your background or area of expertise - please take a moment and introduce yourself. We look forward to hearing from you and truly appreciate your interest in Cognologix. All Resumes can be sent to talent@cognologix.com