Database Administrator

Summary

The Database Administrator is responsible for administering and maintaining the organization’s on-premises and Azure-based database platforms. They ensure high availability, security, and optimal performance by following established standards, procedures, and automation practices. The role involves 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 for 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.
• Manages Azure Data Factory (ADF) pipelines.
• Uses data and database processes and procedures for daily tasks such as log analysis.
• Implements and maintains transactional replication for the database environment.
• Troubleshoots DB integrity and performance issues.
• Schedules SQL jobs and automates them.
• Designs backup and restore strategies.
• Optimizes indexing and parameters.
• Develops utility and tool support for database operations.
• Collaborates across Dev and User teams related to database setup and data activities.
• Provides on‑call rotation support.
• Assesses and sets up monitoring tools.
• Evaluates security auditing and maintains server & DB permissions.
• Documents business continuity, plan processes, and procedures.
• Troubleshoots and resolves issues such as blocking, deadlocking, replication, log shipping, connectivity, and security.
• Develops and maintains SQL jobs based on maintenance tasks and community requirements.
• Schedules backup schedules to meet organizational RTO and RPOs.
• Restores data and databases based on organizational needs.
• Tests restore data recovery at a regular interval.
• Participates and provides feedback on disaster recovery plans and tests.
• Maintains database performance by calculating optimum parameter values.
• 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 practices, and 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.
• Makes changes to database‑related DNS, DHCP, Active Directory, and Group policies.
• Migrates databases from on‑premise to Azure SQL.
• Identifies large tables and partitions them based on usage and application, applying compression and encryption.
• Configures SQL monitoring systems for managing multiple SQL Server instances.
• Conducts root cause analysis and creates SOP documents.

• 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 understanding OLTP and 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 implementing replication.
• Experience using performance tools like…