SQL Database Administrator

*SQL DATABASE ADMINISTRATOR - POSTITION SUMMARY* As a SQL Database Administrator (DBA) at REcore, you'll manage and maintain databases, emphasizing performance, security, and availability in on-premises and Azure cloud environments.
Collaborating with IT teams, engineers, and data analysts, you'll design and optimize database systems, ensuring seamless integration with Azure services.
Responsibilities include security implementation, performance tuning, backup planning, and compliance adherence, all aimed at enhancing database resilience and reliability.
Your role is pivotal in maintaining data integrity and efficiency across our organization's infrastructure.
*FIRST YEAR EXPECTATIONS* These are examples of technical projects and tasks that you should be capable of completing in your role as SQL DBA.
* Gain understanding of the organization’s technology and information systems.
* Become familiar with our existing infrastructure and procedures.
* Collaborate with teams to identify optimization opportunities.
* Implement database security best practices and standards across all environments.
* Review Database related security vulnerabilities reported by Azure Advisor and Mend SCA and SAST scans and implement resolution.
* Design and implement enhanced DR/HA architecture using Azure Well-Architected Framework best practices.
* Restructure and organize existing cloud database resources for optimized management and automation practices wherever possible.
* Optimize cloud database resources to ensure high availability, performance, and cost-effectiveness.
* Develop and maintain scripts, automation tools, and IaC to enhance deployment, monitoring, and management processes.
*EDUCATION AND EXPERIENCE* Bachelor of Science degree in Computer Science, Information Systems or other related discipline from a four-year college or technical school.
A minimum of seven years related DBA work experience; or an equivalent combination of education and related experience.
*ESSENTIAL DUTIES AND RESPONSIBILITIES* * Database Installation and Configuration: Install and configure database management systems (DBMS) such as SQL Server, both on-premises and in Azure cloud environments, ensuring they meet organizational requirements.
· * Database Design: Collaborate with application developers to design and implement efficient database schemas, tables, and structures optimized for Azure cloud deployments.
· * Database Security: Implement and maintain database security measures, including user access control, authentication, and encryption, adhering to Azure security best practices and compliance standards.
· * Performance Tuning: Monitor database performance in both on-premises and Azure environments and optimize queries, indexes, and configurations to ensure efficient operation and responsiveness, leveraging Azure-native performance tuning tools and features.
· * Backup and Recovery: Develop and implement backup and recovery strategies leveraging Azure Backup and Azure Site Recovery services to safeguard data and ensure business continuity in case of data loss or system failures.
· * Database Maintenance: Perform routine database maintenance tasks such as updates, patches, and version upgrades, ensuring seamless integration with Azure services and adhering to Azure maintenance schedules.
· * Data Migration: Plan and execute data migration projects between on-premises and Azure environments, ensuring data integrity and minimal downtime during migrations, utilizing Azure Data Factory or other relevant Azure services.
· * Capacity Planning: Estimate future database storage and performance needs in Azure environments and plan for capacity scaling as required, leveraging Azure scalability features such as auto-scaling and storage tiering.
· * Troubleshooting: Investigate and resolve database-related issues in both on-premises and Azure environments, including errors, connectivity problems, and performance bottlenecks, utilizing Azure monitoring and diagnostic tools.
· * Documentation: Maintain detailed documentation of database configurations, procedures, and troubleshooting processes for reference and compliance purposes.
· * Disaster Recovery Planning: Develop and maintain disaster recovery plans and procedures specific to Azure environments to minimize data loss and downtime in emergency situations, utilizing Azure Backup and Azure Site Recovery services.
· * Collaboration: Work closely with software developers, system administrators, and data analysts to support database-driven applications and reporting systems.
· * Compliance: Ensure that databases deployed in Azure comply with relevant data protection and privacy regulations, such as GDPR or HIPAA, leveraging Azure compliance features.
· * Monitoring and Alerting: Set up monitoring tools and alerts specific to Azure database services to proactively identify and address database issues, leveraging Azure Monitor and Azure Security Center.
· * Training and Knowledge Sharing: Provide training and guidance to other team members and stakeholders on database best practices and usage.
*SKILLS AND COMPETENCIES* Candidates should be skilled at the following: * Proven experience as a Database Administrator, preferably with expertise in SQL Server on-prem and Azure SQL Service.
* Strong knowledge of database design, performance optimization, and security best practices.
* Proficiency in SQL and scripting languages for automation (e.
g.
, Python, PowerShell).
* Familiarity with database backup and recovery procedures, including HA best practices.
* Excellent problem-solving and troubleshooting skills.
* Strong communication and teamwork abilities.
* Relevant certifications (e.
g.
, Microsoft Certified: Azure Database Administrator) are a plus.
*WORK ENVIRONMENT * This position requires the ability to work with team members in an open and collaborative environment.
Deadlines and customer service needs may, from time to time, require after-hours work and a flexible schedule.
Job Type: Full-time Pay: $125,000.
00 - $150,000.
00 per year Benefits: * 401(k) * 401(k) matching * Dental insurance * Employee assistance program * Flexible schedule * Flexible spending account * Health insurance * Health savings account * Life insurance * Paid time off * Parental leave * Vision insurance Schedule: * 8 hour shift * Monday to Friday * On call Experience: * Microsoft SQL Server: 7 years (Required) * Azure SQL Service: 5 years (Required) * Infrastructure as Code: 5 years (Preferred) * Database administration: 7 years (Required) Work Location: Remote