What are the responsibilities and job description for the Database Engineer (Azure) position at Pierce Technology Corp?
- Work closely with development teams to design and implement highly available and scalable Azure-based database solutions
- Optimize database performance and troubleshoot any performance issues
- Design and implement database backup and recovery strategies
- Collaborate with cross-functional teams to ensure data governance and security
- Develop and maintain database documentation, including data definitions, data models, and data flow diagrams
- Monitor database systems and provide proactive maintenance and support
- Stay up-to-date with the latest Azure technologies and recommend improvements to enhance the database infrastructure
- Implement and manage database access control and user privileges
- Strong experience with Azure SQL Database, Azure SQL Managed Instance
- Proficient with Azure Data Studio, Azure Portal, and PowerShell
- Experience in managing and optimizing database performance
- Working knowledge of disaster recovery and business continuity planning
- Experience with Azure data services like Azure Data Lake Storage, Azure Data Factory, and Azure Databricks
- In-depth knowledge of T-SQL and SQL Server
- Strong understanding of database security and access control
- Ability to work collaboratively in a cross-functional team environment
- Excellent problem-solving and troubleshooting skills
- Strong communication and documentation skills
- Bachelor's degree in Computer Science or a related field
- Azure certifications are a plus
