MS SQL DBA

Link Technologies (LinkTechConsulting.com), a Las Vegas based IT consulting firm, is currently seeking an MS SQL DBA to join our team. Employer asks for I-9 information. QUALIFICATIONS Bachelor's degree in Computer Science or Management Information Systems or equivalent experience. Minimum of eight (8) years Microsoft SQL Server experience with strong knowledge and experience on Microsoft SQL Server technology architecture including high availability, encryption at rest, and log shipping. Skilled in the installation, setup, patch administration, maintenance, and upgrading of SQL Server databases. Familiarity with Microsoft SQL Server 2019 and Microsoft SQL Server 2022. Proficiency in performance monitoring, instance optimization, and SQL query tuning. Experience performing hot and cold backups. MUST have strong understanding of database hardening, security administration, and security-related tools. Practice reviewing and implementing monthly security updates. Active management of production database environments and risk reduction. Strong communication and analytical abilities with readiness to provide future guidance on database technology implementation. Ability to collaborate with multiple development teams and software vendors for issue resolution and planning. MUST have the capability to conduct root cause analysis of issues and deliver solutions. RESPONSIBILITIES Primary responsibility is for the day-to-day management of numerous SQL server databases and instances on Microsoft Windows environments including Microsoft SQL server 2019 and 2022. Research, plan, recommend, and implement patches, upgrades and installations for Microsoft SQL Server technology products, including PSU patches. Responsible for monitoring database availability, statistics and other application specific parameters to maintain performance of the system. Responsible for capacity planning. Develop and tune database environments to ensure performance and service delivery expectations are met. Participate in the resolution of critical and complex design and implementation issues across projects. Write shell scripts, PL/SQL, and Perl scripts as needed. Provide advanced database services to meet the needs of the business. Provide mentoring to less experienced DBAs. Ability to support linked servers for other data sources, Oracle for example. Link Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without discrimination based on race, color, religion, sex, gender identity/expression, sexual orientation, national origin, protected veteran status, disability, or any other factors protected by law.