Job
Description
Specialist - Database Administrator (SQL Server Administration) Mumbai Role Purpose Accelya software drives the airline industry. If you have ever travelled by air it is likely that our software made that journey possible. Several of Accelya s applications depend upon Microsoft SQL Server. As we embark on an insourcing exercise, we are seeking SQL Server Database engineers of different experience levels to continue to ensure our applications remain secure, highly available, fast and efficient. Duties and Responsibilities: Design and deploy architectures and configuration that maintain availability in the event of component or site failure Develop standards for deploying and configuring Microsoft SQL Server and the technologies it depends upon (storage, operating system, network, etc) Define procedures for the deployment, configuration and operation of Microsoft SQL Server on various platforms including AWS, VMWare Cloud on AWS and on-prem Develop automation to deploy, configure and operate all Microsoft SQL Server instances consistently and efficiently Design and implement monitoring, alerting and self-healing strategies that maintains the health and availability of Accelya s growing Microsoft SQL Server platform Harden Accelya s Microsoft SQL Server instances to prevent the theft or ransom of data, and to adhere to strict regulatory requirements Upgrade databases to new versions. Deploy latest patches released by Microsoft Train the wider database engineering teams on the deployment and management of Microsoft SQL Server so that Accelya can deliver services 24*7 Collaborate with our software engineering teams to help them deliver secure, highly available, high performing applications on Microsoft SQL Server Experience, Knowledge Skills Required: A solid understanding of installing configuring modern versions of SQL Server Experience of architecting, deploying operating high availability disaster recovery like clustering, Log Shipping Always On Experience backing up and restoring data at various levels of granularity - instance, database, object, rows, etc Ability to secure database data and simplify evidence gathering for security-related audits Knowledge of how to design implement monitoring, alerting self-healing strategies Ability to apply logic and data to diagnose and describe incidents and problems Experience developing automation that increases consistency and reduces human effort using tools like Terraform, Ansible, Puppet, Salt, Chef etc. Exposure to AWS and/or VMWare Cloud on AWS would be advantageous, but training will be provided if not The flexibility to support out of hours work, possibly working as part of a shift rota Knowledge and/or experience of open-source database platforms such as Postgres, MySQL, MariaDB MongoDB, and Cassandra will be advantageous, but not essential What Do We Offer We can promise that your role at Accelya will make a difference to our customers. Our work is demanding, interesting and will enable you to grow yourself and your career. We are implementing a cloud-first strategy so you will have the opportunity to experience public cloud technologies from AWS and private cloud platforms like VMWare Cloud on AWS. Accelya doesn t like to do the same thing 100s of times manually, so we are automating everything that we do. You will become a key part in this. We deliberately foster an environment where people are encouraged to share ideas and experience, admit mistakes, and ask for help. Accelya Enterprise IT support our customers 24 x 7, and some of the roles available will have an operational element, but we are already working on how to make that less demanding. About Accelya Accelya is a leading global technology and service provider to the air transport industry delivering innovative change at speed and scale. The company s market-leading passenger, cargo, and industry platforms support airline retailing from offer to settlement, both above and below the wing. Over 250 airline customers count on Accelya, with operations spread across nine countries and employing over 2,000 professionals worldwide. For more than 40 years, Accelya has been the industry s partner for change, simplifying airline financial and commercial processes and empowering the air transport community to take better control of the future. Whether partnering with IATA on industry-wide initiatives or enabling digital transformation to simplify airline processes, Accelya drives the airline industry forward and proudly puts control back in the hands of airlines so they can move further, faster. For more information, please visit www.accelya.com and https: / / accelya.turtl.co / story / accelya-corporate-brochure / page / 1 . #LI-MK1
