BOLD seeks a DBA professional to provide support for various MS SQL databases This person will perform database structure and software maintenance and implementations support database tuning and consultation and assist with database configuration implementation The person will also participate in incident change and problem-management activities ABOUT THIS TEAM Infrastructure team provides various services including automation observability cloud server network architectures CICD infrastructure as code database administration incident management vendor management security and compliance and acquiring current skills These services help to improve efficiency reduce errors and ensure fast and reliable application releases while maintaining security and compliance Techops help teams monitor applications and infrastructure create resilient infrastructure identify and resolve IT service issues manage vendors and ensure cloud security and compliance The team also focuses on continuous learning and implementing new technologies to provide better value to the organization WHAT YOU LL DO Enhancing the scalability and performance of existing database architecture Protecting data by developing data security and restoration policies procedures and controls Conducting diagnostic tests and evaluating performance metrics Developing procedures to ensure data integrity and quality Performing database maintenance migration and upgrading hardware and software Documenting processes and complying with best practices in database management WHAT YOU LL NEED Knowledge of Physical design of a database cluster RAID SAN and likewise Strong understanding of SQL Server IaaS and PaaS based on Azure and on-premise SQL Server setup Hands-on experience in Unix Linux command line options Experience on DB migrations maintenance and optimization strategies Experience in implementing operational automation using PowerShell Python automation Knowledge of indexes index management and statistics Experience in Performance Tuning Query Optimization using Performance Monitor SQL Profiler and other related monitoring and troubleshooting tools Ability to detect and troubleshoot SQL Server-related CPU memory I O disk space and other resource contention Experience in troubleshooting and resolving database integrity issues performance issues blocking deadlocking Experience with backups restores and recovery models Knowledge of High Availability HA and Disaster Recovery DR options for Azuer PAAS MSSQL Server Capacity Planning Backup Share Disk CPU Memory etc Able to manage demanding stakeholders on technical solutions and align architects WHAT S GOOD TO HAVE Experience in OLTP environment Knowledge on Redash Grafana ELK EXPERIENCE- Module Lead DBA- 6 years LI-SV1 Benefits Outstanding Compensation Competitive salary Tax-friendly compensation structure Bi-annual bonus Annual Appraisal Equity in company 100 Full Health Benefits Group Mediclaim personal accident term life insurance Group Mediclaim benefit including parents coverage Practo Plus health membership for employees and family Personal accident and term life insurance coverage Flexible Time Away 24 days paid leaves Declared fixed holidays Paternity and maternity leave Compassionate and marriage leave Covid leave up to 7 days Additional Benefits Internet and home office reimbursement In-office catered lunch meals and snacks Certification policy Cab pick-up and drop-off facility About BOLD We Transform Work Lives As an established global organization BOLD helps people find jobs Our story is one of growth success and professional fulfillment We create digital products that have empowered millions of people in 180 countries to build stronger resumes cover letters and CVs The result of our work helps people interview confidently finding the right job in less time Our employees are experts learners contributors and creatives We Celebrate And Promote Diversity And Inclusion We value our position as an Equal Opportunity Employer We hire based on qualifications merit and our business needs We don t discriminate regarding race color religion gender pregnancy national origin or citizenship ancestry age physical or mental disability veteran status sexual orientation gender identity or expression marital status genetic information or any other applicable characteristic protected by law