Description:

　　Designs the database server architecture, to include installation, maintenance, and configuration. Performs troubleshooting and resolution management. Provides support for advanced user jobs and analytics. Top Qualifications, Skills, Experience or Certifications: • Install, configure, and manage SQL Server instances (2019/2017/2016/2014/2012) in both production, development, and test environments. • Deploy and manage SQL Server on various platforms, including VMWare, Azure (IaaS/PaaS), and on-premises. • Build and manage Azure managed instances and Azure managed databases. • Facilitate database migration from on-premises environments to Azure. • Execute SQL database upgrades, migrations, backups, and restores. • Administer user access by provisioning SQL logins and users based on project requirements. • Configure and troubleshoot database Always-on availability groups (AG) and AG-related issues. • Establish AG listeners and add databases to Always On while handling failover scenarios. • Implement and troubleshoot database mirroring solutions. • Configure and troubleshoot database log shipping setups. • Set up and troubleshoot database transaction replication configurations. • Manage SQL clusters and resolve cluster-related issues. • Monitor database conditions, proactively rebuild indexes, and perform routine maintenance tasks. • Utilize monitoring and performance tuning skills to schedule automated activities, including database health checks, disk space monitoring, job alerts, index monitoring, and statistics tracking. • Configure database mail for SQL job alerts. • Install and configure SQL Server Reporting Services (SSRS), including report deployment and server security management. • Apply Service Packs to SQL Server versions (2008R2, 2012, 2016, 2017, 2019) and patches to Windows Server versions (2003, 2003 R2, 2012, 2019). • Create and manage incident/changes using the Service Now ticketing system. • Provide exceptional on-demand customer service. • Collaborate with application teams to troubleshoot application issues from a database perspective. • Demonstrate expertise in Transparent Data Encryption (TDE). • Implement SQL Server Security Technical Implementation Guides (STIG) compliance. Job Role-Specific Skill Requirements • Security and Access Control • Database Design and Schema Changes • Patch and Update Management • Capacity Planning • Automation and Scripting • Problem Resolution • Data Migration • Documentation and Knowledge Sharing • Disaster Recovery Testing • Database Upgrades and Version Management • Collaboration and Communication • Training and Mentoring • Compliance and Auditing Preferred skills and qualifications: • In-depth knowledge of SQL Server versions from 2019 to 2012. • Strong expertise in Azure, including Azure SQL Database and Azure Managed Instances. • Familiarity with VMWare, Always-on Availability Groups, database mirroring, log shipping, and replication. • Experience with SQL Server Reporting Services (SSRS). • Strong problem-solving skills and the ability to work under pressure. • Excellent communication and teamwork skills. • Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) a plus.

　　Skills:

　　Database administrator, Sql, Sql database, Database management, Sql server, azure, vmware, iaas, paas, ssrs, sql queries, sql reporting, sql server integration services, sql server reporting services

　　Top Skills Details:

　　Database administrator,Sql,Sql database,Database management,Sql server,azure,vmware,iaas,paas,ssrs,sql queries,sql reporting,sql server integration services,sql server reporting services

　　Additional Skills & Qualifications:

　　Resume Submission Checklist - Please complete this checklist and submit it with candidate sub-package Company: TEKsystems, Inc. Candidate Name: Meet the LCAT education requirement? (Explain): Meet the LCAT experience requirement? (Explain): Explain how the candidate meets the Top Qualifications, Skills, and Experience or Explain how the candidate meets the Job Role Specific Requirements:

　　Experience Level:

　　Expert Level

　　About TEKsystems:

　　We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

　　The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

　　We are an equal opportunity employers and will consider all applications without regard to race, genetic information, sex, age, color, religion, national origin, veteran status, disability or any other characteristic protected by law. To view the EEO is the law poster click here. Applicants with disabilities that require an accommodation or assistance a position, please call 888-472-3411 or email [email protected]. This is a dedicated line designed exclusively to assist job seekers whose disability prevents them from being able to apply online. Messages left for other purposes will not receive a response.