Database Administrator - SQL Server (Azure)
Location
Oregon State | United States
Job description
Database Administrator – SQL Server – Azure
Job Title: Database Administrator
Location: Remote
Duration: 6 Months Contract
Must have EXCELLENT communication skills
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
Job tags
Salary