Lead Database Administrator
What you will be doing
• Design, build, and maintain scalable data lake architectures to support analytics, reporting, and data-driven decision-making
• Manage data ingestion pipelines, enforcing data quality and governance standards
• Manage, monitor, and maintain all databases, including Microsoft Access, SQL Server, MySQL, and PostgreSQL
• Maintain a comprehensive inventory of all databases, including ownership, usage, and technology stack
• Perform routine database administration tasks, including backups, restores, copying, archiving, and schema updates
• Ensure database availability, integrity, and reliability across all environments
• Monitor and tune database performance to ensure optimal response times and resource utilization
• Analyze and optimize queries, focusing on improving performance in VB-based applications
• Proactively identify and resolve database bottlenecks and performance issues
• Implement indexing strategies, query optimization, and execution plan analysis
• Lead and support the migration of Microsoft Access databases to SQL Server, MySQL, and PostgreSQL
• Collaborate with the Principal Architect and product teams to define migration strategies and timelines
• Document legacy database structures and develop migration plans that minimize disruption to operations
• Evaluate and recommend modern database technologies and architectures
• Partner with development teams to establish and enforce database query best practices
• Provide hands-on guidance and code review for database interactions within applications
• Create and maintain documentation, standards, and reference guides for database development
• Serve as a technical resource for developers on schema design, stored procedures, and data modeling
• Implement and manage database monitoring and alerting solutions to detect and respond to issues
• Define and track key database health metrics, including performance, storage, and availability
• Respond to and resolve database incidents, performing root cause analysis and implementing preventive measures
• Maintain audit logs and ensure compliance with data governance and security policies
• Manage database access controls, user permissions, and role-based security
• Ensure sensitive data is protected in accordance with organizational and regulatory requirements
• Perform regular security assessments and vulnerability reviews of database environments
• Analyze and optimize queries, with a focus on improving performance in VB-based applications
• Manage data ingestion pipelines, enforcing data quality and governance standards
• Manage, monitor, and maintain all databases, including Microsoft Access, SQL Server, MySQL, and PostgreSQL
• Maintain a comprehensive inventory of all databases, including ownership, usage, and technology stack
• Perform routine database administration tasks, including backups, restores, copying, archiving, and schema updates
• Ensure database availability, integrity, and reliability across all environments
• Monitor and tune database performance to ensure optimal response times and resource utilization
• Analyze and optimize queries, focusing on improving performance in VB-based applications
• Proactively identify and resolve database bottlenecks and performance issues
• Implement indexing strategies, query optimization, and execution plan analysis
• Lead and support the migration of Microsoft Access databases to SQL Server, MySQL, and PostgreSQL
• Collaborate with the Principal Architect and product teams to define migration strategies and timelines
• Document legacy database structures and develop migration plans that minimize disruption to operations
• Evaluate and recommend modern database technologies and architectures
• Partner with development teams to establish and enforce database query best practices
• Provide hands-on guidance and code review for database interactions within applications
• Create and maintain documentation, standards, and reference guides for database development
• Serve as a technical resource for developers on schema design, stored procedures, and data modeling
• Implement and manage database monitoring and alerting solutions to detect and respond to issues
• Define and track key database health metrics, including performance, storage, and availability
• Respond to and resolve database incidents, performing root cause analysis and implementing preventive measures
• Maintain audit logs and ensure compliance with data governance and security policies
• Manage database access controls, user permissions, and role-based security
• Ensure sensitive data is protected in accordance with organizational and regulatory requirements
• Perform regular security assessments and vulnerability reviews of database environments
• Analyze and optimize queries, with a focus on improving performance in VB-based applications