Azure/SQL-Server DBA

company banner
Tentek, Inc.
Azure SQL or SQL Server Administration; SSDT and SSIS; NOSQL Databases including MongoDB; High Availability and Disaster Recovery (DR) options for Azure SQL or SQL Server
C2H Corp-To-Corp, C2H Independent, C2H W2, 3-mo C/H
$70-$83/hr
Telecommuting not available Travel not required

Job Description

Azure/SQL-Server DBA

 

This position is primary responsible for designing, developing, implementing, testing, and maintaining Azure SQL databases for the platform, which includes its content management system, search/recommendations and notifications engines, web sites, client apps and back-end services.

 

RESPONSIBILITIES

  • Azure Database backup and restore from Azure/Aws table Storage.
  • Manage Azure Geo-Replica databases.
  • Perform database index/statistic tuning daily.
  • Implement data partitioning or sharding based on the data scale.
  • Create reports for business users and maintain data extracts via SSDT and SSIS packages.
  • Real time Data sync between Azure SQL and AWS DR SQL via Powershell and Azure Automation.
  • Stored Procedure and Database Schema Review.
  • Data Refreshing using 3rd party tool (such as Red-Gate Schema & Data Compare).
  • Database Monitoring using 3rd party monitoring tools.
  • Identify bad query executions and work with developers to optimize queries.
  • Troubleshoot for any database schema sync issue.
  • Monitor performance and managing parameters to provide fast responses to front-end users.
  • Map out the conceptual design for a planned database.
  • Refine the logical design so that it can be translated into a specific data model.
  • Further refine the physical design to meet system storage requirements.
  • Maintain data standards, including adherence to the Data Protection Act.
  • Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata).
  • Control database access permissions and privileges.
  • Develop, manage and test back-up and recovery plans.
  • Ensure that storage and archiving procedures are functioning correctly.
  • Capacity planning.
  • Work closely with IT project managers, solutions architects and software developers.
  • Communicate regularly with technical, applications and operational staff to ensure database integrity and security.

 

REQUIREMENTS

  • Minimum 5-7 years of professional MS server Administration experience.
  • Minimum 2-3 years of professional Azure SQL or SQL Server Administration experience.
  • Knowledge of variety of Databases including SQL Server or PostgresQL.
  • Experience with SSDT and SSIS.
  • Working experience of writing Stored Procedures.
  • Working experience of leveraging executing plans.
  • Working experience with Powershell and automating tasks via scripts and Azure Automation.
  • Hands on experience with Data publish/subscribe services.
  • Hands on experience with database load testing and Data Access Layers in C# or Java.
  • Understanding of NOSQL Databases including MongoDB.
  • Working knowledge of indexes, High Availability and Disaster Recovery (DR) options for Azure SQL or SQL Server.
  • Must have strong database design skills. Must be able to explain database schema that he/she have designed, including tradeoffs they made and why.
  • Excellent written and verbal communications skills – good at documenting code.
  • Detail-oriented, well organized, quick learner with very strong technical aptitude and the ability to work concurrently on multiple projects.

 

Posted By

Joe Elizondo

101 N. Brand Blvd., Suite 1660 Glendale, CA, 91203



Company Information

Providing quality resources and services to the Information Technology industry since 1989.
Dice Id : tentekgl
Position Id : JE13644

Similar Positions at Tentek, Inc.