Database Administrator

SUMMARY The Database Administrator is responsible for administering and maintaining the organization’s on-premises and Azure-based database platforms. Ensure high availability, security, and optimal performance by following established standards, procedures, and automation practices. Work includes building and executing SQL and cloud-native scripts to manage and modify data, collaborating with the Senior Database Administrator on performance and scalability improvements, and leading initiatives for physical data modeling and architecture design across hybrid infrastructures. Installs, patches, upgrades and maintains the system health for the database servers. Builds database schemas and structures based on customer needs and established standards. Suggests performance tuning database systems/servers and database structures. Identifies database requirements by interviewing customers; analyzing department applications, programming, and operations; and evaluating existing systems and designing proposed systems. Evaluates and runs SQL and other Database scripts. Azure Data Factory (ADF) pipeline management. Uses data and database processes and procedures for daily tasks such as log analysis. Implements and maintains transactional replication for the database environment. Troubleshooting DB integrity and performance issues. SQL Job scheduling and automation. Backup and restore strategy. Indexing and parameter optimization. Utility and tool development for DB support. Collaborate across Dev and User teams related to database setup and data related activities. On‑call rotation support. Monitoring tool assessment and set up. Evaluates Security Auditing and Maintaining server & DB permissions. Documents business continuity, plan processes and procedures. Troubleshoots and resolves database integrity issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, etc. Develops and maintains SQL Jobs based on maintenance tasks as well as tools and requirements of Dev and User communities. Runs and schedules backup schedules to meet organizational RTO and RPOs. Restores data and databases based on organizational needs. Tests restores data recovery at a regular interval. Participates and provides feedback on Disaster recovery plans and tests. Maintains database performance by calculating optimum values for database parameters. Creates and suggests changes to indexes and performance methods. Supports database functions by designing and coding utilities. Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state‑of‑the‑art practices; participating in professional societies. Contributes to team effort by accomplishing related results as needed. Works closely with various Dev and User Community teams in progress of HBE goals/strategies. Supports Microsoft SQL Server Integration Services (SSIS). Generates reports using Microsoft SQL Server Reporting Services (SSRS). Models data using Microsoft Data Warehouse technologies. Creates database reports using Business Intelligence concepts and best practices. Modifies database related DNS, DHCP, Active Directory and Group policies. DB migration—Migrates the databases from on premise to Azure SQL. Identifies the big tables and partitions the tables based on usage and application along, Compression and Encryption. Configures the SQL Monitoring system or similar products for managing multiple SQL Server instances. Conducts Root Cause Analysis and SOP documents. REQUIRED Seven years of experience in enterprise SQL Database administration with large‑scale, mission‑critical applications (Microsoft SQL Server 2016+, MySQL, etc.). Experience with SSMS, MS tools, Azure VM deployment, lifecycle patching, Azure SQL database. Experience with Data modeling, ER/physical design tools. Experience with Database Server Performance and Optimization tools. Experience in understanding Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) concepts. Experience with ADF triggers and activities, data integration, performance monitoring. Experience with role‑based access control, Active Directory, Azure AD, encryption standards. Experience in implementation of replicate database. Experience using performance tools like Extended Events, SQL Profiler, Azure Diagnostics, blocking/deadlock analysis. Experience scheduling jobs using SQL Agent, ADF scheduling, Logic Apps for orchestration. Experience managing database backup, restore and data archiving tasks, Azure Backup, Recovery Vault, LRS, ZRS restore validation and compliance. Experience in Database performance metrics, query optimization tools, cloud‑based tuning. Excellent written, oral and presentation skills and ability to communicate complex concepts. Experience being on call rotation support 24*7 for monitoring and handling severity problems. Familiarity with SQL Monitor or similar products for managing multiple SQL Server instances Azure cloud, third‑party tools. Experience in Database Auditing, Roles and permissions. Better understanding on Database internals. Experience with Database backup and restore. Experience with Database PAAS solution for backup and recovery. Experience with Database PAAS for recovery. Database design. Excellent analytical skills: ability to identify core issues and formulate a workable plan of action for complex problems that cross the boundaries of database, operating system, and application. Self‑motivated and driven to improve processes and increase velocity. Experience working with Data Warehouse teams and understanding concepts. Better understanding on BI tools. DESIRED Bachelor’s degree in computer science or related field, or equivalent training and experience. Scripting knowledge for automating day‑to‑day tasks (Shell script, Power shell). Experience in automation tools like PowerShell, Python, Azure SDKs, SSMS scripting, tooling automation. Experience in developing and maintaining SQL Jobs based on maintenance tasks as well as tools and requirements of Dev and User communities. Experience in participating and providing feedback on Disaster recovery plans and tests in disaster recovery setup and maintenance. Experience in Database Partitioning, Compression and Encryption. Professional demeanor; ability to represent project to stakeholders in a friendly, unbiased and professional manner. Experience and understanding the concepts of SSIS. Experience and understanding the concepts of SSRS. Experience working with network and system admins. Experience in database migration from on premise to cloud. Experience in database performance tuning. Experience in setting up database monitoring systems. Certification in Microsoft SQL Server. The Washington Health Benefit Exchange is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, marital status, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. #J-18808-Ljbffr