What are the responsibilities and job description for the Lead SQL Server DBA position at HireRight?
About HireRight:
Bachelor's/Master’s degree in Information Systems, Computer Science or a related field is required.
Experience
Skills
HireRight, LLC is an Equal Opportunity Employer
Minorities / Females / Veterans / Disabilities
HireRight does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of HireRight and HireRight will not be obligated to pay a placement fee
This job description in no way states or implies that these are the only duties to be performed by a team member’s occupying this position. Team members may be required to perform other related duties as assigned, to ensure workload coverage. Team members are required to follow any other job-related instructions and to perform any other job-related duties requested by their supervisor. This job description does not constitute an employment agreement between the employer and team member and is subject to change by the employer as the organizational needs and requirements of the job change. This job description is subject to change at any time.
HireRight is the premier global background screening and workforce solutions provider. We bring clarity and confidence to vetting and hiring decisions through integrated, tailored solutions, driving a higher standard of accuracy in everything we do. Combining in-house talent, personalized services, and proprietary technology, we ensure the best candidate experience possible. PBSA accredited and based in Nashville, TN, we offer expertise from our regional centers across 200 countries and territories in The Americas, Europe, Asia, and the Middle East. Our commitment to get it right every time, everywhere, makes us the trusted partner of businesses and organizations worldwide.
Overview:
The Senior SQL Database Administrator is a highly responsible, technical and administrative database position managing a large scale environment, supporting all environment builds, capacity planning, installations, configurations, cluster setup, performance tuning and ongoing monitoring. Work also involves providing consulting to multiple development teams on analysis, design, development, and performance tuning issues in a proactive manner - driving improvements in reliability and optimization to the database and application services. This position will support Microsoft SQL environments, but MongoDB experience is also required. Experience with MySQL or any GCP technologies would be a plus.
Responsibilities:
- Perform design, installation, configuration and upgrade of databases.
- Coordinate the allocation of system storage and plans future database storage requirements.
- Coordinate and create primary database objects.
- Coordinate and modify the database structure, as necessary.
- Coordinate and enroll users and maintain system security.
- Provide development and maintenance of the physical database models.
- Analyze and implement data security requirements.
- Continually improve database administration standards, guidelines, and procedures.
- Develop and implement processes and procedures to monitor and tune databases.
- Develop and implement processes and procedures to backup and recover databases.
- Develop and implement processes and procedures to archive data to appropriate targets.
- Analyze, document and present database hardware and technology requirements.
- Review database development activities to ensure they are performant and in conformance with design specifications and standards.
- Provide comprehensive database trouble shooting
- Assist application developers with best practices and tuning.
- Maintain high customer satisfaction
- Flexible with work schedule, on call and some travel.
Working relationship:
Internal
- Reports to Sr Manager - Database Operations
- Communicates closely with other Database team members.
- Works closely with customers and development teams.
- Works with all levels of management.
External
- Interacts as part of an IT technical team with end users.
- Communicates with outside vendors, contractors, and suppliers as needed.
- Communicates with professional organizations and user groups as needed.
Education
Bachelor's/Master’s degree in Information Systems, Computer Science or a related field is required.
Experience
- Seven to ten years of experience in Information Systems development and integration.
- Seven to ten years of hands on experience with Microsoft SQL
- Seven to ten years of hands on experience with Database High Availability
- Seven to ten years of hands on experience with advanced coding T-SQL.
- Seven to ten years of hands on experience with advanced SQL tuning in an Microsoft SQL environment.
- Seven to ten years of hands on experience in support of application design and development.
- Three to five years of hands on experience with MongoDB.
- Three to five years of hands on experience with Windows, Windows Core, and/or Linux.
Skills
- Strong ability to ascertain, interpret, design and document requirements.
- Demonstrated knowledge and experience with Microsoft SQL RDBMS
- Demonstrated knowledge and experience with Windows and/or Windows Core.
- Demonstrated knowledge and experience with coding T-SQL.
- Demonstrated knowledge and experience with Always On, SQL Replication and/or Log Shipping
- Demonstrated knowledge and experience with SQL tuning.
- Demonstrated knowledge and experience with tuning Microsoft SQL Database Engine.
- Strong interpersonal skills, customer service and team orientation.
- Effective listening, oral, presentation, and written communication skills.
- High level of motivation and commitment.
- Strong time management and organizational skills.
- Exhibit the following traits:
- Self Confidence
- Curiosity
- Tenacity
- Tactful
- Self starter
- Detail oriented
HireRight offers a competitive benefit package which includes:
- Medical
- Dental
- Vision
- Paid Life/AD&D Insurance
- Voluntary Life Insurance
- Short & Long Term Disability
- Flexible Spending Accounts
- 401K
- Generous Vacation and Sick Program
- 10 Paid Holidays
- Education Assistance Program
- Business Casual Attire
- Generous Referral Program
- Employee Discounts and Rewards
- And much more!
- All resumes are held in confidence. Only candidates whose profiles closely match requirements will be contacted during this search.
HireRight, LLC is an Equal Opportunity Employer
Minorities / Females / Veterans / Disabilities
HireRight does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of HireRight and HireRight will not be obligated to pay a placement fee
This job description in no way states or implies that these are the only duties to be performed by a team member’s occupying this position. Team members may be required to perform other related duties as assigned, to ensure workload coverage. Team members are required to follow any other job-related instructions and to perform any other job-related duties requested by their supervisor. This job description does not constitute an employment agreement between the employer and team member and is subject to change by the employer as the organizational needs and requirements of the job change. This job description is subject to change at any time.
