BOLD seeks a senior 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 new 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
- Strong understanding of SQL Server (IaaS and PaaS based on Azure) and on-premise SQL Server setup.
- Strong understanding of Database concepts, SQL Architecture
- Automation experience with Powershell or Python
- 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, 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 data modelling, database architecture and design
- 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.
EXPERIENCE-
- Sr. DBA - 4.5 years+
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.
Under San Francisco's Fair Chance Ordinance, qualified applicants with arrest and conviction records will be considered for the position.
Skills Required
- Strong understanding of SQL Server (IaaS and PaaS based on Azure) and on-premise SQL Server setup
- Strong understanding of Database concepts and SQL Architecture
- Automation experience with PowerShell or Python
- Hands-on experience in Unix/Linux command line
- Experience with DB migrations, maintenance and optimization strategies
- Experience implementing operational automation using automation tools/scripts
- Knowledge of indexes, index management, and statistics
- Experience in Performance Tuning and Query Optimization using Performance Monitor, SQL Profiler and related tools
- Ability to detect and troubleshoot SQL Server CPU, memory, I/O, disk space and resource contention
- Experience troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking
- Experience with data modeling, database architecture and design
- Experience with backups, restores and recovery models
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for Azure PaaS and MSSQL Server
- Capacity planning for backup share, disk, CPU, memory
- Ability to manage demanding stakeholders and align technical solutions with architects
- Senior DBA experience of 4.5 years or more
What We Do
LiveCareer, www.livecareer.com, is the leading online career destination for successful job seekers. We’ve helped more than 10,000,000 registered users build job-winning resumes and find careers they absolutely love. Our Resume Builder has been described as “the most impressive resume builder on the market today”. Featuring hundreds of industry-specific templates, and thousands of expert-written text examples, Resume Builder makes it easy to create a polished, professional, strategically-targeted resume in minutes. In addition to America’s #1 Resume Builder, LiveCareer offers an impressive suite of job-finding tools, including resume reviews, resume writing, customized cover letters, job boards, career tests, interview tips, and more. LiveCareer has been recognized as one of the top 100 employment websites by Weddle, and was recently named the 2013 Best Employment Interactive Application by the Web Marketing Association. Ready to take the next step at work? Download your FREE eBook now! http://www.livecareer.com/ebooks/get-what-you-want-raises-promotions Whether you want to make more money, win a promotion, or move into a leadership role, our FREE eBook is filled with tips, advice, and inspiration that can help make this your most successful year yet! Share this free guide with friends and family using #NewYearBetterCareer
