*** 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.
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
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 firstname.lastname@example.org