This is NOT a migration project. This is an Azure DBA. This person needs to have worked in Azure and is considered an Azure expert.
Role: Azure Database Administrator – SQL Server (remote)
Duration: 6 month contract for hire
10+ years of experience –
- Azure Databases on VM and database management (Create, deploy, monitor, performance, backup, restore, capacity planning, and management)
- Azure PAAS Databases and database management (Create, deploy, monitor, performance, backup, restore, capacity planning, and management)
- Data encryption, Data decryption, Data Masking, Data deduplication
- CICD (Continuous Integration and Continuous Delivery/Deployment)
- Azure Key Vault, Data Factory, Function App, Azure Data Bricks etc.
Skills Required
- Ability to work in a dynamic environment with changing requirements
- Good communication and presentation skills
- Working experience as a SQL Server database administrator in Azure
- Working experience creating and supporting Data Factory data pipelines, DataBricks workspaces, and security groups in Azure.
- Working experience using DevOps CI/CD in Azure.
- Review and rewrite high performance SQL queries using Joins, Cross Apply, Aggregate Queries, Merge, Pivot
- Migrate Stored Procedures, Functions and Views
- Review database designs to identify proper indexing and constraints
- Perform SQL query tuning and performance optimization on complex inefficient queries
- Provide guidance in the use of table variable, temporary table, CTE appropriately to deal with large datasets
- Analyze complex queries for any deadlock resulting due to conflicts
- Collaborate with other DBAs on database design and performance enhancements
- Debug existing code and troubleshoot for issues
- Keep up to date with the latest database features, techniques, and technologies.
- Support current business applications including the implementation of bug fixes as needed
- Able to multi-task and adapt to shifting priorities
- Able to meet deadlines set in project planning
- Effectively communicate progress through the project execution phase
- Follow industry and company standard coding practices
- Produce technical and application documentation
- Test database process for future enhancements and bug fixes
- Assist support analysts and developers with issues they are unable to resolve.
- Ensure customer satisfaction by meeting customer needs in a courteous and timely manner
Roles & Responsibilities
- Work with a highly dynamic team focused towards Digital Transformation
- Understand the domain and business processes to successfully perform SQL Server database administration tasks (project or maintenance related) in Azure.
- Provide work status and coordinate with other Database administrators and developers.
- Manage customer deliverables and regularly report the status via Weekly/Monthly reviews