Senior SQL DBA

Bangalore, Karnataka
Permanent
Full-time

14 days ago

In today's economic climate, job hunting can be daunting. Finding the right job - that job that makes you feel like you're in the right place, at the right time may seem downright impossible. Here at ServiceChannel, http://www.servicechannel.com/, we like to think we're defying those odds. We're not only growing (and growing fast), but we're also building a dynamic, innovative, collaborative team primed for success in today's marketplace.The winning combination?Groundbreaking software (that's where you'd come in)On-site services (our software helps customers manage them)Great customers-the world's leading retailersGreat people (your teammates)As MS SQL Database Administrator, you will help develop and manage the database systems that power the ServiceChannel SaaS software. You will build highly available, redundant, scalable, and high performing database systems to support our tremendous growth. You will manage the systems to keep them running at peak performance levels. You will have the chance to learn on the job while sharing your own experience and expertise. You will work closely with other members of our database administration team and the development and infrastructure teams to successfully deploy solutions that meet requirements and exceed expectations.ResponsibilitiesAdminister database systems across Production, Staging, QA, and Development environmentsRecognize system deficiencies, diagnose performance issues, and implement effective solutionsSQL Server replication and cluster constructionPlan and implement disaster recoveryDatabase sharding and tuningMonitor and report on database availability and performanceOptimize stored procedures, triggers, and functionsOptimize database schemas, views, and indexesData Warehousing, archival, and backupDatabase change deployment processDatabase maintenance and on call rotationsGenerate code to extract, transform, and load data from/to production data sources from/to external sources (excel, text comma and tab delimited files, other Access, SQL databases, XML, etc)Write code and create jobs to automate repetitive tasksWork alone and in a groupResearch problems independentlyEstablish and enforce coding standardsImplement, maintain, and audit database security and encryptionPlan growth and changes (capacity planning)Resource governingExperience, Skills & Education3 years plus of experience as DBA expectedLight database administration expertise is acceptable given strong SQL development skillsProficiency writing and optimizing Transact SQL, stored procedures, functions, performing bulk set operations (select/insert/update/delete) in MS SQL 2008 and newerDetailed knowledge of relational database conceptsRecent experience with SQL Server 2008 (2019/2022 a plus)Building and administering MS SQL Server Database Systems a major plusKnowledge of SQL Server replication and clusters in Cloud environments a major plusKnowledge of principles of database design, data acquisition, and data access analysis and designExperience with SSIS and SSRS a plusStrong verbal and written communication skillsDemonstrate ability to work in a small group setting to rapidly develop new and enhance existing systemsA BS degree in business or computer science, comparable work experience acceptedAdditional experience welcomed:Experience with JIRA;Experience with Github, TeamcitExperience with MongoDB,Cosmos DBExperience with Redgate DLM, SQL Sentry, PowershellFortive Corporation OverviewFortive's essential technology makes the world stronger, safer, and smarter. We accelerate transformation across a broad range of applications including environmental, health and safety compliance, industrial condition monitoring, next-generation product design, and healthcare safety solutions.We are a global industrial technology innovator with a startup spirit. Our forward-looking companies lead the way in software-powered workflow solutions, data-driven intelligence, AI-powered automation, and other disruptive technologies. We're a force for progress, working alongside our customers and partners to solve challenges on a global scale, from workplace safety in the most demanding conditions to groundbreaking sustainability solutions.We are a diverse team 17,000 strong, united by a dynamic, inclusive culture and energized by limitless learning and growth. We use the proven Fortive Business System (FBS) to accelerate our positive impact.At Fortive, we believe in you. We believe in your potential-your ability to learn, grow, and make a difference.At Fortive, we believe in us. We believe in the power of people working together to solve problems no one could solve alone.At Fortive, we believe in growth. We're honest about what's working and what isn't, and we never stop improving and innovating.Fortive: For you, for us, for growth.About ServiceChannelServiceChannel empowers many of your favorite brands to take care of their brick and mortar locations. Our customers are market leaders in the retail, restaurant, grocery, convenience store, fitness, banking, education and health industries. The facilities and store operations teams at CVS, Trader Joe's, Adidas, Louis Vuitton and Chipotle, among 500 other brands in over 70+ countries, rely on us to deliver the best possible guest and employee experience. We are the leader in our space, and we continue to earn that position by driving innovation around IOT, AI and data with our software and services.In 2021, we joined the Fortive family of leading technology companies, united by a common purpose to make the world stronger, safer and smarter. Fortive is a Fortune 500 company and has been named by Fortune as one of the world's most admired companies. Being part of Fortive means we are supported by a strong foundation of business systems, resources and culture, which will accelerate our growth journey!We offer an excellent benefits package including medical, dental, vision, life and LTD insurance, HSA, and a 401(k) retirement plan.We Are an Equal Opportunity Employer. Fortive Corporation and all Fortive Companies are proud to be equal opportunity employers. We value and encourage diversity and solicit applications from all qualified applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity or expression, or other characteristics protected by law. Fortive and all Fortive Companies are also committed to providing reasonable accommodations for applicants with disabilities. Individuals who need a reasonable accommodation because of a disability for any part of the employment application process, please contact us at applyassistance@fortive.com.Bonus or Equity
This position is also eligible for bonus as part of the total compensation package.

Fortive

Apply Now