Job Description :

JDs:

Role: Azure SQL DBA

Work Location: Pleasanton, CA or Dallas, TX (Initially Remote)

Desired Experience: 8- 10 years

Duration: 12 years

Must Have:

  • 8-10 years' experience as Azure SQL DBA
  • Experience in Azure environments. Create, maintain, and execute SQL Server jobs. SQL Server (Scripting, Indices, Views, Stored Procedures).
  • Experience with cloud database backup and transaction recovery techniques.
  • Migrate SQL server database from on premise to Azure IAAS/PAAS Migration using Azure
  • Implement, configure, and maintain performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications
  • Manage AZURE SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems
  • Migrate SQL server database from on premise to Azure IAAS/PAAS Migration using Azure Site Recovery Setting up and testing HA & DR
  • Monitor performance, availability, and security of databases and associated processes, and remediating issues as they arise in order to provide fast responses to front-end users
  • Develop data solutions that utilize cloud-based technologies and platforms (PaaS etc.)
  • Knowledge on Azure eco system tools (BLOB storage, ADF, Data Bricks)
  • Hands on experience in converting design documents into workable solutions for Azure SQL.
  • Understanding of performance tuning concepts on the cloud
  • Experience Modernizing / migrating mainframe applications is a plus.
  • Prior experience of working in Agile projects
  • Job Duties include ( Below activities for the purpose of modernizing large scale retail Mainframe applications to Cloud)
  • Data Migration activities
  • File conversion
  • Query conversion
  • Writing batch procedures for processing large volume data
  • Performance tuning activities

Roles & Responsibilities

  • Hands on experience in Data modeling, data migration and through knowledge on RDBMS concepts
  • Hands on experience in query/procedure writing for multiple RDBMS.
  • Understanding of performance tuning concepts on the cloud
  • Experience in closely working with clients & participating in architecture reviews
  • Experience Analyzing, building and supporting Retail application ( Merch, Supply chain , Accounting, Stores)
  • Experience Modernizing / migrating mainframe applications is a plus.
  • Analyzing source database hosted on mainframe environment and coming up with optimal schema/data migration strategy for the target on Azure cloud.
  • Understanding business functionality of various applications and building dependency diagram for the database objects.
  • Data Migration activities
  • Performance tuning activities
             

Similar Jobs you may be interested in ..