
Database Administrator Noida, Uttar Pradesh, IndiaInformation Technologies
BOLD Limited
- Noida, Uttar Pradesh
- Permanent
- Full-time
- 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.
- 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 automation tools / scripts.
- Knowledge of indexes, index management, and statistics.
- Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQLProfiler 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, MongoDB.
- Capacity Planning (Backup Share, Disk, CPU, Memory etc)
- Able to manage demanding stakeholders on technical solutions and align architects
- Experience in OLTP environment
- Knowledge on Redash, Grafana, ELK
- Junior DBA- 2.5yrs+
- Senior DBA- 4.5 years+
- Competitive salary
- Tax-friendly compensation structure
- Bi-annual bonus
- Annual Appraisal
- Equity in company
- 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
- 24 days paid leaves
- Declared fixed holidays
- Paternity and maternity leave
- Compassionate and marriage leave
- Covid leave (up to 7 days)
- Internet and home office reimbursement
- In-office catered lunch, meals, and snacks
- Certification policy
- Cab pick-up and drop-off facility