Database Administrator/SR. Database Administrator

Position Overview

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

Company Overview

BOLD is an established and fast-growing product company that transforms work lives. Since 2005, we've helped more than 10,000,000 folks from all over America (and beyond!) reach higher and do better. A career at BOLD promises great challenges, opportunities, culture and the environment. With our headquarters in Puerto Rico and offices in San Francisco and India, were a global organization on a path to change the career industry.

Key Responsibilities

• 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.

Required Skills

• 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 architect

Additional Skills

• Experience in OLTP environment
• Basic understanding of MySQL or MongoDB to handle L1 issues