Jobs via Dice
Overview
Role
: DBA Location
: Dallas, TX (Onsite) The Azure SQL Database Administrator will be responsible for the design, implementation, maintenance, and optimization of our cloud-based SQL database infrastructure. This role focuses on database security, credential management, performance tuning, query optimization, and comprehensive audit trail implementation to meet enterprise and regulatory requirements. Responsibilities
Database Security & Credential Management
Azure Active Directory Integration: Implement and maintain Microsoft Entra ID (formerly Azure AD) authentication for centralized identity management Database Credential Management: Establish secure credential policies, manage SQL authentication, and implement least-privilege access principles Network Security Configuration: Configure IP firewall rules, virtual network service endpoints, and private endpoints for secure database access Encryption Management: Implement and maintain Transparent Data Encryption (TDE), Always Encrypted for sensitive data columns, and manage encryption keys through Azure Key Vault Access Control: Design and implement role-based database access using custom database roles and object-level permissions following security best practices
Performance Tuning & Optimization
Query Performance Analysis: Identify and resolve slow-running queries using Azure SQL Database Query Performance Insight, Query Store, and Dynamic Management Views (DMVs) Index Optimization: Analyze and optimize database indexes, implement automated index tuning recommendations, and manage index fragmentation Resource Monitoring: Monitor DTU/vCore utilization, implement auto-scaling policies, and optimize resource allocation for cost-effectiveness Performance Baseline Management: Establish performance baselines, implement proactive monitoring alerts, and conduct regular performance assessments Batch Processing Optimization: Optimize large data processing jobs, implement parallel processing strategies, and manage long-running operations
Database Query Optimization
SQL Query Tuning: Analyze execution plans, optimize complex queries, and implement query hints where appropriate Stored Procedure Optimization: Review and optimize stored procedures, functions, and triggers for maximum efficiency Database Schema Design: Provide recommendations for optimal table structures, partitioning strategies, and archival processes Deadlock Resolution: Identify, analyze, and resolve database deadlocks and blocking issues Statistics Management: Maintain up-to-date statistics for optimal query plan generation
Audit Trails & Compliance
SQL Auditing Implementation: Configure and maintain comprehensive SQL auditing to Azure Storage, Azure Monitor Logs, and Event Hubs Compliance Monitoring: Ensure adherence to regulatory requirements (SOX, GDPR, HIPAA) through proper audit trail configuration Data Classification: Implement data discovery and classification for sensitive data identification and protection Audit Log Management: Design audit log retention policies, implement log archival strategies, and ensure audit log integrity Vulnerability Assessment: Conduct regular vulnerability assessments and implement remediation strategies
High Availability & Disaster Recovery
Business Continuity Planning: Design and maintain geo-replication, failover groups, and backup strategies Backup & Recovery: Implement automated backup policies, test recovery procedures, and manage point-in-time recovery operations Monitoring & Alerting: Configure comprehensive monitoring using Azure Monitor, set up proactive alerting, and maintain 24/7 system availability Disaster Recovery Testing: Conduct regular DR tests, document recovery procedures, and maintain RTO/RPO compliance
Database Development Support
Database Design Review: Review database schemas, provide optimization recommendations, and ensure best practices implementation Migration Support: Plan and execute database migrations from on-premises to Azure SQL Database/Managed Instance Version Control: Implement database version control practices and manage database schema changes through CI/CD pipelines Development Team Collaboration: Work closely with developers to optimize application database interactions
#J-18808-Ljbffr
Role
: DBA Location
: Dallas, TX (Onsite) The Azure SQL Database Administrator will be responsible for the design, implementation, maintenance, and optimization of our cloud-based SQL database infrastructure. This role focuses on database security, credential management, performance tuning, query optimization, and comprehensive audit trail implementation to meet enterprise and regulatory requirements. Responsibilities
Database Security & Credential Management
Azure Active Directory Integration: Implement and maintain Microsoft Entra ID (formerly Azure AD) authentication for centralized identity management Database Credential Management: Establish secure credential policies, manage SQL authentication, and implement least-privilege access principles Network Security Configuration: Configure IP firewall rules, virtual network service endpoints, and private endpoints for secure database access Encryption Management: Implement and maintain Transparent Data Encryption (TDE), Always Encrypted for sensitive data columns, and manage encryption keys through Azure Key Vault Access Control: Design and implement role-based database access using custom database roles and object-level permissions following security best practices
Performance Tuning & Optimization
Query Performance Analysis: Identify and resolve slow-running queries using Azure SQL Database Query Performance Insight, Query Store, and Dynamic Management Views (DMVs) Index Optimization: Analyze and optimize database indexes, implement automated index tuning recommendations, and manage index fragmentation Resource Monitoring: Monitor DTU/vCore utilization, implement auto-scaling policies, and optimize resource allocation for cost-effectiveness Performance Baseline Management: Establish performance baselines, implement proactive monitoring alerts, and conduct regular performance assessments Batch Processing Optimization: Optimize large data processing jobs, implement parallel processing strategies, and manage long-running operations
Database Query Optimization
SQL Query Tuning: Analyze execution plans, optimize complex queries, and implement query hints where appropriate Stored Procedure Optimization: Review and optimize stored procedures, functions, and triggers for maximum efficiency Database Schema Design: Provide recommendations for optimal table structures, partitioning strategies, and archival processes Deadlock Resolution: Identify, analyze, and resolve database deadlocks and blocking issues Statistics Management: Maintain up-to-date statistics for optimal query plan generation
Audit Trails & Compliance
SQL Auditing Implementation: Configure and maintain comprehensive SQL auditing to Azure Storage, Azure Monitor Logs, and Event Hubs Compliance Monitoring: Ensure adherence to regulatory requirements (SOX, GDPR, HIPAA) through proper audit trail configuration Data Classification: Implement data discovery and classification for sensitive data identification and protection Audit Log Management: Design audit log retention policies, implement log archival strategies, and ensure audit log integrity Vulnerability Assessment: Conduct regular vulnerability assessments and implement remediation strategies
High Availability & Disaster Recovery
Business Continuity Planning: Design and maintain geo-replication, failover groups, and backup strategies Backup & Recovery: Implement automated backup policies, test recovery procedures, and manage point-in-time recovery operations Monitoring & Alerting: Configure comprehensive monitoring using Azure Monitor, set up proactive alerting, and maintain 24/7 system availability Disaster Recovery Testing: Conduct regular DR tests, document recovery procedures, and maintain RTO/RPO compliance
Database Development Support
Database Design Review: Review database schemas, provide optimization recommendations, and ensure best practices implementation Migration Support: Plan and execute database migrations from on-premises to Azure SQL Database/Managed Instance Version Control: Implement database version control practices and manage database schema changes through CI/CD pipelines Development Team Collaboration: Work closely with developers to optimize application database interactions
#J-18808-Ljbffr