Sr Microsoft SQL DBA I (WFH) START ASAP!

SUMMARY
The Senior Database Administrator I (Sr DBA I) will be responsible for the monitoring, maintenance, and operational support of our entire portfolio of databases and SQL instances. This role will maintain the reliability, stability, and data integrity of all organization databases in addition to coordinating all database activities and leading and securing Microsoft SQL Server instances and databases.

Additional responsibilities include supporting back-up, maintenance, restore, documentation, process development, testing, tuning, continued improvement, optimization, software upgrades, and administration of all Microsoft SQL Server instances while maintaining a focus on availability and performance of all databases and underlying operating systems.

Furthermore, this position needs to be able to guide colleagues in database security, performance, and maintenance of Microsoft SQL Server BI products. The position may also draw on skills and experience gained from working on cloud-based database solutions, supporting databases and data movement either on-premises in the global data centers and cloud-based solutions located in Microsoft Azure cloud.

Finally, the Sr DBA must be capable of working independently and collaboratively with team members to support the global infrastructure and other IT teams. This includes solving complex problems and independently identifying areas for improvement and implementing these changes following best practices. You will need a strategic mindset, strong collaboration skills, and experience in CI/CD for databases using Microsoft Azure DevOps.

RESPONSIBILITIES
Monitor performance of database systems resources and query throughput
Guide colleagues on database best practices.
Monitor and maintain database storage resources.
Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics.
SQL Server Installation, Upgrades, Migrations and Configuration
Install database software service packs and cumulative updates, as necessary.
Maintain database documentation as required.
Maintain and administer database security access.
Perform database Ad-hoc backups and restores.
Troubleshoot and resolve complex database-related issues.
Identify areas for improvement and implement it following best practices.
Follow Change Management processes to implement database configuration changes (Azure DevOps)
Follow Problem Management processes to troubleshoot and resolve recurring issues.
Proactively monitor and respond to MSSQL database alerts.
Continuous Integration and Deployment in Azure DevOps
Experience with Microsoft Azure focused on the data solutions (Azure Data Factory / Azure Synapse / SQL database)
Assist internal/external audit with reporting requirements.
Develop scripts for consistent and secure execution of common tasks.
Providing SQL expertise, proposing design recommendations, optimization performance improvements.

WORK ENVIRONMENT / EHS RESPONSIBILITIES
Sedentary category requiring exertion up to 10 lbs. of force occasionally and uses negligible amounts of force to move objects. Sedentary work involves sitting most of the time.
Occasional: Standing: Remaining on one's feet without moving.
Frequent: Sitting: Remaining in seated position
Frequent: Reaching below shoulders: Extending arms in any direction below shoulders.
Continuous: Communication: Expressing or exchanging written/verbal/electronic information.
Continuous: Vision: Clarity of near vision at 20 inches or less and far vision at 20 feet or more with depth perception, peripheral vision, color vision.

EDUCATION, EXPERIENCE AND SKILLS/COMPETENCIES to perform the job duties
Key Education or Certification Required
Required Bachelor’s Degree in Computer Science or Information Systems, or equivalent combination of education and experience
Microsoft SQL certification (MCSA) or ability to work towards this
Required Minimum Number of Years of Relevant Experience
Required (7) years’ experience as a database administrator in SQL Server environment.
Required (3) years’ experience working in Microsoft Azure or other cloud provider.
Required (3) years’ experience working in Microsoft Azure DevOps or other CI/CD tooling.

Required Skills and Competencies
Experience with SQL Server 2012 and upwards
Experience with SQL Server integration/Analysis/Reporting services
Experience with PowerBI
Experience with Microsoft Windows Operating systems
Experience with Active Directory / Azure Active Directory
Good understanding of current database technologies and applications
A keen interest to learn about new technologies.
Solves complex problems; takes a new perspective on existing solutions.
Willing to work occasional extended hours.
Highly detail oriented with excellent interpersonal and communication skills

Only Apply if you meet the requirements above!