We're seeking a Database Administrator (DBA) III that will be responsible for performing all aspects of Database Administration on Microsoft SQL Server and MySQL database technologies.
This may include system administration, troubleshooting, analysis, testing, research, training, general problem solving, technical support and testing/deployment of new systems. Designing and implementing back-up, recovery, archiving, conversion strategies, and performance tuning.
100% Remote + CLT + Benefits (Health Insurance Coverage, Meal Vouchers, Annual Bonuses, and more!)
Responsibilities:
- Maintain multiple DB Server environments in Azure, On-Prem.
- Partner with other Database Administrators in support of database services to ensure the highest standards of availability, resilience, integrity, security and performance required by our business systems.
- Set up centralized monitoring, executing scripts, patches, backup reports, status reports and performance monitoring. Monitoring system's health and performance
- Ability to think critically to diagnose and resolve on-going incidents and problems.
- Performance troubleshooting and resolution. Analyze, solve, and correct issues in real time
- Handling daily issues (Blocking, long running Transactions, Deadlocks, etc.)
- Troubleshoot issues related to TempDb, Transaction log and System databases
- Knowledge of SSIS, SSRS
- Experience with backups, restores and recovery
- Scheduling database backups, taking full and Transaction log backups.
- Automate SQL server tasks (SQL jobs, Powershell scripts, etc.)
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
- Perform appropriate Change Management duties to comply with IT policies and procedures.
- Report progress on a weekly basis of status on all assigned work tasks in a written report.
- Ability to work during non-business hours including weekends and holidays, as needed.
- Ability to work in On-Call rotations.
- Experience and understanding of DBA and/or other systems management experience in the area of database development and operations in data center and SaaS/public cloud environments.
- Experience in integrating database environments as a result of M&A activities; integration of work teams resulting from M&A activities.
- Knowledge of programming languages helpful
- Demonstrated ability to design, develop, and maintain databases Solid and modern source control practices, including Git and merge request flows.
- Experience and knowledge of the Microsoft Windows Server Operating System and Microsoft SQL Server.
Qualifications:
- 10 - 12 years experience as a Database Administrator on SQL Server
- 5 – 8 years experience with SQL Server 2016 or higher
- 5 – 8 years experience with Windows Server 2016 or higher
- 2 - 3 years of experience with MySQL DB Administration
- Powershell scripting experience
- Project Management experience
- TSQL development experience is a plus
- Understanding of, and experience with relational database environments
- Knowledge of reporting and query tools and practices
- Technical documentation skills
- Self-motivated and directed, with keen attention to detail
- Able to prioritize and execute tasks in a high-pressure environment
- Experience working in a team-oriented, collaborative environment
- Good written and oral communication skills
- Willingness to work a flexible schedule and be on call to accommodate project deadlines
- Knowledge of programming languages helpful
- Demonstrated ability to design, develop, and maintain databases
