@bestsecret(Senior) Database Administrator (m/w/d) | on-site or remote
Webseite BestSecret
Your responsibilities
As member of our small database team, you will participate in daily database server administration and monitoring tasks. You will also design and develop reliable HA and DR procedures, backup/restore plans, database maintenance, server upgrades and service pack implementation. Close collaboration with different application development teams would be also part of your job. You will help them in resolving different database architectural issues and build effective query execution plans. In addition, you will participate in constant improvements of our monitoring system.
Installation
- SQL Server Installation, Upgrades, Migrations and Configuration
- Install database software service packs and cumulative updates as necessary
- Follow Change Management processes to implement database configuration changes
Support
- The administration, backup, integrity and security of various SQL servers and databases
- Responsible for database tasks from software upgrades and custom deployments, to troubleshooting
- Troubleshoot and resolve different server and database issues
- Define, administer and maintain database security access
Monitor and Maintenance
- Reliability, stability and data integrity of databases
- Database systems/storage resources and query throughput
- Perform index maintenance (rebuild/defragment)
- Collect ana analyze different server and database statistics
- Proactively monitor and respond to MSSQL database Alerts
- Continually assess, improve, and optimize our current database environment
- Perform database Ad-hoc backups and restores for both ad-hoc requests and validating database integrity
Your qualification
- You have at least 3-5 years of practical experience in MS SQL Server
- SQL Server knowledge from the version SQL Server 2008R2 – SQL Server 2019
- Deep understanding of the SQL Server architecture
- Knowledge of the DMV and DMF
- Understanding and ability to analyze different performance counters
- Knowledge of query optimizer and index usage
- Very good knowledge of the T-SQL and SSIS
- Basic Azure knowledge (VM, SQL Databases, Storage Accounts, manage backups/restore …)
- Basic knowledge of PowerShell
- Basic knowledge of PowerBI
- Available to do on-call service (7-10 days monthly)
Preferred
- Experience with Monitoring & Diagnostic tools
- Experience working with Windows server, including Active Directory and disk configurations
What’s in it for you
- An appreciative and open corporate culture
- Thorough onboarding by mentors
- Opportunities for personal development and advanced training
- Flexible working hours and 30 days’ holiday
- Mobile working is part of our working culture: No matter whether you live in Berlin, Hamburg, Cologne, Frankfurt, Stuttgart or Leipzig – working remotely is possible with us
- State-of-the-art IT-equipment (e.g. Mac) and tools
- Attractive staff discounts at BestSecret
- Company health-management scheme (corporate membership at Body & Soul and Urban Sports Club, on-site massage at the workplace and much more)
- Company events and joint sporting activities
- Free drinks, fresh fruit, and discounted food in the Office
- Good public transport access and free parking
Is this job exactly what you’re looking for?
Perfect! Then apply now. We look forward to receiving all your application documents, stating your earliest possible start date and your salary expectations.
Don’t have a cover letter or references/credentials handy? No problem! Just a CV is enough for an initial impression.
@bestsecret