This position is responsible for analyzing, designing, configuring, and maintaining the company's database infrastructure and associated components. The role includes troubleshooting and resolving system errors and inefficiencies to ensure the database environment operates smoothly and effectively. They will collaborate closely with the Data team to stay updated on changes in the environment, provide insights and recommendations on design and implementation plans, and maintain a comprehensive understanding of the overall database architecture. This individual will be involved in planning, communication, documentation, and implementation tasks related to infrastructure projects and will serve as an escalation point for support issues and service requests.
The ideal candidate will have a strong background in SQL Server and Azure SQL, with a comprehensive understanding of database administration, performance tuning, and security. This role involves managing and maintaining our database systems to ensure high availability, performance, and security.
MAJOR DUTIES AND RESPONSIBILITIES
Database Management:
Design, implement, and maintain SQL Server databases environments
Perform database backup and restore operations to ensure data protection.
Manage database access using Role-Based Access Control (RBAC).
Manage SQL migrations and upgrades.
Manage and maintain Hybrid Cloud database infrastructures
Design and maintenance of SQL Server and Azure SQL database servers and clusters, including database continuity planning and data retention.
Design, configure, and manage system components such as SQL clusters, and SQL as a Service
Monitor the daily ticket queue for infrastructure support items. Responding to inquiries from staff, administrators, service providers, site personnel and outside vendors to provide technical assistance and support.
Maintain systems and applications uptime to support the enterprise through rigorous adherence to change control policies and pro-active monitoring for abnormal events.
Collaborate with cross-functional teams to align database solutions with organizational needs.
Performance and Monitoring:
Monitor and optimize database performance using execution plans and performance monitoring tools.
Set up and maintain database alerts and monitoring systems.
Troubleshoot and remediate SQL environment issues promptly.
Security and Compliance:
Ensure compliance with data security standards and best practices.
Manage access control and security configurations for database environments.
EDUCATION AND WORK EXPERIENCE
Bachelor's degree in Computer Science, Information Technology, or equivalent experience.
4+ years of experience as a SQL Server DBA or in a similar role.
Expertise in backup and restore operations, RBAC, and T-SQL.
Experience with database automation tools and scripting languages (e.g., Python and PowerShell)
Strong knowledge of Azure SQL environments
Knowledge of other cloud-based data warehouse platforms like Snowflake, Azure Synapse, Databricks preferred
Experience building and supporting database disaster recovery environments and procedures.
Proven experience in database and performance monitoring and alerting.
Proficient in SQL environment troubleshooting and remediation.
Ability to multi-task and respond with a high sense of urgency
Self-motivated with the ability to work in a fast-moving environment