MS SQL Database Administrator @ iGuru Software

Job Description

We're seeking a Database Administrator to manage and support SQL Server databases on mission-critical high volume OLTP production systems. The ideal candidate will possess some database development background as well as current experience as a production SQL Server database administrator. The role requires a proactive and self motivated individual, who is willing to take an idea, groom it into a well defined user story, and see through the implementation. Responsibilities: Configure and maintain database servers and processes, including monitoring of system health and performance to ensure high levels of performance, availability and security Troubleshoot and resolve performance issues SQL Server performance tuning, including analyzing query execution plans, SQL server profiling, index design and tuning, and index maintenance strategies Database backup management and recovery Database administration related projects, as needed Respond to critical and non-critical. production alerts, and availability to be on an on-call rotation schedule to provide production support when critical issues arise will be required Create requested database objects and assist with production releases Qualifications: 4-6 years SQL Server experience, with 2+ years SQL Server development experience, 3+ years in Database Administration Bachelors degree in Computer Science or related major SQL Server 2016 and 2019 experience required. Experience with Azure Extensive experience writing SQL queries and stored procedures Experience optimizing queries and database objects, including advanced skills in index design and maintenance Experience with SQL Server Service Broker, SQL Server in a Windows Cluster environment, and AlwaysOn Availability Groups Experience with encryption including TDE and Always Encrypted Experience with monitoring tools such as SQL Monitor, Zabbix, SolarWinds, Idera, System Center Excellent problem solving and effective research skills Dedication and willingness to work some alternative schedules as necessary Effective verbal and written communication skills Self-motivated with the ability to work as part of a team or independently Experience supporting enterprise level production systems in a fast-paced, high availability server environment Desired Qualifications: Experience in PostgreSQL is a plus Diversity, Equity and Inclusion Program/Affirmative Action Plan: We have transformed our company into an inclusive environment where individuals are valued for their talents and empowered to reach their fullest potential. At PrismHR, we strive to continually lead with our values and beliefs that enable our employees to develop their potential, bring their full self to work, and engage in a world of inclusion. Ensuring an inclusive environment for our employees is an integral part of the PrismHR culture. We aren't just checking a box, we are truly committed to creating a workplace that celebrates the diversity of our employees and fosters a sense of belonging for everyone. This is essential to our success. We are dedicated to building a diverse, inclusive, and authentic workplace, so if youre excited about our roles but your past experience doesnt align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for these open roles or other open roles. We particularly encourage applicants from traditionally under-represented groups as we seek to increase the diversity of our workforce and provide fair opportunities for all. The Company is committed to complying with all applicable laws providing equal employment opportunities. This commitment applies to all persons involved in the operations of the Company and prohibits unlawful discrimination by any employee of the Company, including supervisors and co-workers. Privacy Policy: For information about how we collect and use your personal information, please see our privacy statement available at https://www.prismhr.com/about/privacy-policy. PrismHR provides reasonable accommodation for qualified individuals with disabilities and disabled veterans in job application procedures. If you have any difficulty using our online system and you need a reasonable accommodation due to a disability, you may use the following alternative email address to contact us about your interest in employment at PrismHR: hidden_email candidates being considered for a position who require an accommodation will receive a follow-up response. #LI-ML1 FxxnXHs9Ow

Employement Category:

Employement Type: Full time
Industry: IT
Role Category: IT Services & Consulting
Functional Area: Not Applicable
Role/Responsibilies: MS SQL Database Administrator

+ View Contact

Keyskills:   SQL Server Database Administration SQL queries Stored Procedures Monitoring Tools Problem Solving Verbal Communication Written Communication Teamwork Azure Index Design Index Maintenance SQL Server Service Broker AlwaysOn Availability Groups TDE Always Encrypted Research Skills