Job Overview
We are seeking a highly skilled Senior Database Administrator to join our innovative team in a remote capacity. In this pivotal role, you will be instrumental in the migration of SQL Server databases to Microsoft Azure, as well as in the ongoing maintenance and optimization of these systems post-migration. You will thrive in a collaborative atmosphere where you will assist in administering and supporting both new and existing SQL systems, as well as facilitate data conversions and migrations. Your expertise will also contribute to performance tuning and maintenance across multiple core systems.
Key Responsibilities
- Migrate SQL Server databases to Microsoft Azure.
- Maintain and optimize SQL Servers and databases within the Azure environment.
- Ensure system availability and develop effective recovery strategies.
- Carry out performance tuning, backup, and restoration for databases.
- Oversee daily operations of the Microsoft SQL Server infrastructure to guarantee service availability.
- Optimize database performance and address any issues that arise.
- Implement robust security measures to safeguard data integrity.
- Collaborate closely with business users, developers, and infrastructure teams to deliver exceptional products.
- Maintain compliance by adhering to established policies and procedures.
- Keep SQL servers updated with necessary patches and upgrades.
- Execute server migration and upgrade tasks as needed.
- Perform additional responsibilities as assigned.
Required Skills
- Over 5 years of experience in database administration within complex SQL Server production environments.
- Proficient in migrating SQL Server databases to Microsoft Azure.
- Skilled in maintaining SQL Server on Azure VMs and Azure SQL Databases.
- Strong knowledge of Microsoft SQL Server 2016 and later versions.
- Comprehensive understanding of relational databases, T-SQL scripting, and database normalization best practices.
- Proven ability to troubleshoot and resolve database integrity and performance challenges in production settings.
- Expertise in performance tuning and query optimization.
- Proficient in SQL development, with the capability to write and troubleshoot SQL code as well as design stored procedures, functions, tables, views, triggers, indexes, and constraints.
- Experience in database design within a software development context.
- Familiarity with Team Foundation Server, Visual Studio Team Server, and/or Azure DevOps.
Qualifications
- A Bachelor's degree in Computer Science or a related field, or equivalent professional experience.
Career Growth Opportunities
We are dedicated to fostering professional advancement and development within our organization. You will have the chance to contribute significantly to impactful projects, enhancing your skills and expanding your professional network.
Compensation And Benefits
We offer a competitive compensation package that varies based on location, skills, experience, qualifications, and current market conditions. The salary range for this position is \(95,000 - \)160,000. For leveled roles (I, II, III, Senior, Lead, etc.), placements may differ based on assessments during the interview process, considering overall fit for the role. Adjustments to the salary range will be clarified during the offer discussions.
Employment Type: Full-Time