UA Brands

About UA Brands

Are you driven to solve complex data driven problems? UA Brands is looking forward to hire a Database Administrator who possesses an immense sense of pride being a Techie! Maintains databases companywide for high availability. Ensures speed of data by reorganizing, indexing, and rebuilding databases, tables, ETL (Extract Transform & Load) packages, and replication schema. Creates and verifies backups for all databases. Responsible for Patching and maintaining server updates. Responsible for creation and monitoring of all Database hardware to alert and prevent potential issues before they occur. Experience with SQL Coding and scripting using PowerShell or batch. Experience with SSIS and SSRS/PowerBI. Experience with technical documentation. desire to automate process as much as possible 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, i.e. 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 architecture 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 anomalies 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. *** This role will require you to work in rotational shifts *** 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 Prior Database Administration experience required. 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. Experience with coding and Scripting language like PowerShell Watch your email here’s what happens next: If your background is a promising fit for the position, you’ll get an email from us within 1-2 business days which will include a link to our online Candidate Assessment. UA Brands International Pvt. Ltd. Blue Ridge - Paranjpe Schemes, Phase 1, Hinjewadi Rajiv Gandhi Infotech Park, Hinjawadi, Pune, MH 411057 +91-020-67708100

Synonyms

Technologies (from Job Ads)

Hiring Locations

Headquarters

Loading map...

Company Info

Legal Form: Ltd

Company Type: Private

Company Size: 51 - 250

Job Ad Metrics

Job Ads found: 34

Job Ads per Month: 2.6

Hiring Locations: 2

Data Info