Administer, optimize, and maintain MSSQL databases for optimal performance and data integrity. Install, configure, maintain, patch and upgrade MSSQL servers Strong hands-on knowledge in performing in place and side by side database migration within cloud and on-prem to cloud platform Responsible for Capacity planning, Security Management, Backup and Recovery planning and implementation. Must understand writing and executing stored procedures, DMVs and DMFs Database Encryption and TDE Must have strong knowledge of Always on high availability features on all versions starting 2012 In-depth understanding of Windows/OS clustering and it's partnering features like storage/disk IOPS and Throughputs (latency related to disk IO) Implement and follow ITIL best practices in database management and fine understanding of ServiceNow tool Respond to and resolve database-related issues to minimize downtime and ensure uninterrupted services. Conducting regular database performance assessments and data backups. Stay current with emerging database technologies and industry best practices. Provide technical expertise and support to internal teams on database-related matters. Automate day to day SQL administration tasks and health checks. Prepare daily, Weekly and Monthly maintenance report Knowledge of Monitoring tool and synthetics will be an added advantage (like Datadog/SolarWinds) Write efficient and optimized code to build tools and applications that facilitate database management and orchestration

Skillset requirement
SQL Server Database, 

PowerShell/Ansible/Terraform/Python/Go Lang Scripting,  Understanding of cloud computing like AWS and Azure, architectural understanding of frontend (application)and backend (database) integration AWS Certified Data Engineer or Azure Database Administrator Certification preferred 

Good to have: RDS for SQL and Postgres, CI/CD pipelines, tools like Jenkins/Harness, Ansible/Python.
 

Education & Experience

5+ years of relevant experience in Administration and Maintenance of DBaaS Bachelor’s degree in engineering or equivalent Location Bangalore