*** 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
MS SQL 2012 Server Administrator, with experience of data migration projects using SSRS, SSIS packages. Needs to have a very strong and credible record as a DBA, experience of handling enterprise Data Base migration projects preferably in a financial or banking arena. Provide hands on support to our internal DBA and development teams. Strong knowledge of database design, query cost and performance measurement, use of stored procedures and performance tuning. Experience in using Integration Services (SSIS) platform for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations. Will provide database functions by designing and coding utilities and scripts Maintains database performance by calculating optimum values for database parameters; implementing new releases and completing maintenance requirements. Provides information by answering questions and making recommendations. Maintains quality service by establishing and enforcing organization standards.