MSSQL Database Administrator

HEXAWARE

5h•Onsite

About The Position

Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member is valued and empowered to succeed. Hexaware provides access to a vast array of tools that enhance, revolutionize, and advance professional profile. We complete the circle with excellent growth opportunities, chances to collaborate with highly visible customers, chances to work alongside bright brains, and the perfect work-life balance. With an ever-expanding portfolio of capabilities, we delve deep into and identify the source of our motivation. Although technology is at the core of our solutions, it is still the people and their passion that fuel Hexaware s commitment towards creating smiles. At Hexaware we encourage to challenge oneself to achieve full potential and propel growth. We trust and empower to disrupt the status quo and innovate for a better future. We encourage an open and inspiring culture that fosters learning and brings talented, passionate, and caring people together. We are always interested in, and want to support, the professional and personal you. We offer a wide array of programs to help expand skills and supercharge careers. We help discover passion the driving force that makes one smile and innovate, create, and make a difference every day. Job Description: Position: MSSQL Database Administrator Location: Washington DC Mode: 5 days onsite per week

Responsibilities

Install, configure, and maintain Microsoft SQL Server across versions 2012, 2014, 2016, 2017, 2019, and 2022, including version upgrades and maintenance plans.
Apply SQL Server service packs, cumulative updates (CUs), hotfixes, and security patches as required.
Develop and implement disaster recovery (DR) strategies and conduct DR tests for mission-critical databases to ensure high availability.
Maintain and manage databases hosted in Azure environments.
Identify and troubleshoot blocking, deadlocks, index fragmentation, and high CPU utilization queries.
Utilize Dynamic Management Views (DMVs) and DBCC commands for performance monitoring and troubleshooting.
Configure, maintain, and troubleshoot transactional replication setups.
Implement high availability (HA) solutions including clustering, database mirroring, log shipping, replication, and Always On availability groups.
Perform database refreshes different environments safely and efficiently.
Manage database capacity by planning data archiving and file movement strategies to optimize storage utilization.
Standardize SQL Server environments by establishing installation, configuration, storage, CPU, memory, account, and security guidelines following industry best practices and standards.
Conduct performance tuning and query optimization using SQL Profiler, Database Tuning Advisor (DTA), Perfmon, DMVs, DBCC, and proactive health checks.
Work with Business Intelligence (BI) components including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
Lead and support the migration of databases and BI components including SSRS and SSAS.
Develop PowerShell and T-SQL scripts for automation and troubleshooting.
Develop and maintain stored procedures, triggers, functions, and joins.
Enhance, troubleshoot, and maintain existing SSRS reporting services and reports.
Apply ITIL processes including Incident, Service Request, Change, and Problem management according to organizational standards.
Manage database backup and restoration using tools such as Veritas backup software.
Administer security management including auditing, login, user creation and permission management to ensure secure database environments.
Proactively analyze support ticket trends and implement permanent solutions to reduce recurring issues.
Demonstrate strong analytical, communication, and interpersonal skills with proficiency in technical writing and presentations.
Work independently or collaboratively in a team to achieve critical business objectives and make sound decisions under pressure.
Coordinate change review meetings and manage incident resolution within Service Level Agreements (SLAs).
Maintain logs for risks, issues, and actions; escalate and report as appropriate.
Prepare and submit management reports on a daily, weekly, monthly, or ad hoc basis.
Collaborate with stakeholders to analyze technology requirements and develop functional specifications.
Present and implement technological alternatives to streamline processes and enhance productivity.