Job Responsibilities:
* Technical Leadership:
* Provide technical guidance and mentorship to the database development team.
* Design, develop, and optimize database systems to meet business requirements.
* Recommends improvements to the database architecture and design to enhance scalability, availability, and security.
* Collaborates with the DevOps team to automate database deployments and integrate with CI/CD pipelines
*
* Documentation:
* Create and maintain comprehensive documentation for database systems and processes.
* Innovation:
* Stay updated with the latest database technologies and best practices, and implement improvements as needed.
*
* Database development support: Focus on providing database development support which includes;
* Monitor and optimize database performance, ensuring high availability and reliability. Work closely with software developers, business analysts, and other stakeholders to integrate database solutions with applications
* Perform code reviews to support Database development
* Perform database deployments
* Optimize database queries and stored procedures for maximum efficiency and performance
* Develops complex SQL queries, stored procedures, functions, triggers, and views to support business logic and application functionality
* Performs data modeling, including designing schemas, tables, indexes, and relationships, for both transactional and analytical use cases
* Provides support for troubleshooting and resolving database-related issues reported by application teams
* Works closely with application developers to integrate database systems with applications and ensure efficient data flow
* Azure Cloud Database Management:
* Configures and manages Azure Databases, including automated backups, replication, and high-availability options
* Implements and manages database security, including encryption, access controls, and auditing, to meet industry standards and regulatory requirements.
* Ensures disaster recovery strategies are in place, including point-in-time restore and geo-replication for Azure SQL Database
* Stays current with Azure database services and industry trends, incorporating new features and best practices as appropriate
* General Database support:
* Provides off-hours support when required
* Provides on-site disaster recovery assistance when required
* Perform all other duties and special projects as assigned
Education and/or Training:
* Bachelor's degree in a related field or equivalent work experience
* Additional education, certifications, or other distinctions are a plus
* Proficient in various desktop tools including MS Office Programs (i.e. Outlook, Excel, Word, PowerPoint, Project, Visio, SharePoint etc.)
* Azure AZ900, DP900, DP-300 training required
* Azure certifications such as Microsoft Certified: Azure Database Administrator Associate or Azure Solutions Architect Expert are highly preferred
Relevant Work Experience:
* Minimum 5 years tenure as a Database Administrator Experienced with relational architecture and Data Warehouse
* Minimum 3 years' experience with installing, configuring, and supporting Oracle and/or SQL server database environments
* Experience with Azure SQL database environments.
* Understanding of Azure ecosystem and database services like Azure Blob Storage, Azure Data Lake, Azure Key Vault, etc.
* Must be well versed with database procedures to include: installation, configuration, backup and recovery, performance tuning, and SQL statement tuning
* Experience using ETL tools to document and move data as needed
* Experienced with Linux operating system and shell scripting
* Experienced with Windows Server operating systems
* Experienced with scripting languages and automation tools a plus (AI tools, Infrastructure as Code (IaC), Azure DevOps, PowerShell, and ARM templates)
#LI-BS1
#LI-REMOTE
or continue with email
* Technical Leadership:
* Provide technical guidance and mentorship to the database development team.
* Design, develop, and optimize database systems to meet business requirements.
* Recommends improvements to the database architecture and design to enhance scalability, availability, and security.
* Collaborates with the DevOps team to automate database deployments and integrate with CI/CD pipelines
*
* Documentation:
* Create and maintain comprehensive documentation for database systems and processes.
* Innovation:
* Stay updated with the latest database technologies and best practices, and implement improvements as needed.
*
* Database development support: Focus on providing database development support which includes;
* Monitor and optimize database performance, ensuring high availability and reliability. Work closely with software developers, business analysts, and other stakeholders to integrate database solutions with applications
* Perform code reviews to support Database development
* Perform database deployments
* Optimize database queries and stored procedures for maximum efficiency and performance
* Develops complex SQL queries, stored procedures, functions, triggers, and views to support business logic and application functionality
* Performs data modeling, including designing schemas, tables, indexes, and relationships, for both transactional and analytical use cases
* Provides support for troubleshooting and resolving database-related issues reported by application teams
* Works closely with application developers to integrate database systems with applications and ensure efficient data flow
* Azure Cloud Database Management:
* Configures and manages Azure Databases, including automated backups, replication, and high-availability options
* Implements and manages database security, including encryption, access controls, and auditing, to meet industry standards and regulatory requirements.
* Ensures disaster recovery strategies are in place, including point-in-time restore and geo-replication for Azure SQL Database
* Stays current with Azure database services and industry trends, incorporating new features and best practices as appropriate
* General Database support:
* Provides off-hours support when required
* Provides on-site disaster recovery assistance when required
* Perform all other duties and special projects as assigned
Education and/or Training:
* Bachelor's degree in a related field or equivalent work experience
* Additional education, certifications, or other distinctions are a plus
* Proficient in various desktop tools including MS Office Programs (i.e. Outlook, Excel, Word, PowerPoint, Project, Visio, SharePoint etc.)
* Azure AZ900, DP900, DP-300 training required
* Azure certifications such as Microsoft Certified: Azure Database Administrator Associate or Azure Solutions Architect Expert are highly preferred
Relevant Work Experience:
* Minimum 5 years tenure as a Database Administrator Experienced with relational architecture and Data Warehouse
* Minimum 3 years' experience with installing, configuring, and supporting Oracle and/or SQL server database environments
* Experience with Azure SQL database environments.
* Understanding of Azure ecosystem and database services like Azure Blob Storage, Azure Data Lake, Azure Key Vault, etc.
* Must be well versed with database procedures to include: installation, configuration, backup and recovery, performance tuning, and SQL statement tuning
* Experience using ETL tools to document and move data as needed
* Experienced with Linux operating system and shell scripting
* Experienced with Windows Server operating systems
* Experienced with scripting languages and automation tools a plus (AI tools, Infrastructure as Code (IaC), Azure DevOps, PowerShell, and ARM templates)
#LI-BS1
#LI-REMOTE
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more