Cloud SQL Server DBA

TEKsystems, Inc
Published
October 31, 2019
Location
Sacramento, CA
Category
Default  
Job Type

Description

Specific responsibilities may include the following:

  1. SQL Server
  • Designing and maintaining of data and database solutions;
  • Identify, maintain, and audit database standards, best practices, and processes;
  • Database installation and configuration (2012, 2014 and 2016 versions);
  • Design, configure and maintain HA/DR solutions (AlwaysOn, FCI, Log Shipping, Replication);
  • Performance Tuning and System Optimization.
  1. Microsoft Azure Cloud
  • Understand Microsoft Azure architecture in general, be Subject Matter Expert on the cloud database offerings, their differences and limitations;
  • Provide strategic design and consultancy for Cloud database services;
  • Perform research on an enterprise Cloud SQL architecture, partner with DB architect in defining standards and best practices.
  1. Azure SQL Database
  • Migration of SQL server databases from on-premise to Azure IAAS/PAAS;
  • Expertise in architecting and implementing HA/DR solutions for SQL server databases running on Azure;
  • Establish database standards for operations, upgrades, migrations and onboarding new applications and/or clients;
  • Implement cloud security models along with data masking, de-identification and encryption methodologies, establish appropriate end-user access control levels;
  • Implement database technology policies, and procedures for maximum systems uptime;
  • Support day-to-day operations and management of an enterprise level production database in the cloud;
  • Perform applications database administration functions including SQL code review, performance analysis, query tuning, database application design, physical data modeling, and developer support.

REQUIRED EXPERIENCE, SKILLS AND COMPETENCIES:

  • BS in Computer Science or related field
  • 4+ years relevant work experience in a software development environment
  • 4+ years of work experience performing Database Development and Administration duties on SQL Server databases
  • 2+ years of experience with Cloud technologies (Microsoft Azure preferred)
  • 2+ years of experience with implementing and administering SQL Server databases in the Microsoft Azure
  • 1+ years of hands-on experience with Azure Site Recovery
  • Strong understanding of logical and physical data modeling and using tools such as ER/Studio or equivalent
  • Strong understanding of database standards and best practices
  • Demonstrated proficiency in T-SQL (queries, Stored Procedures, User-Defined Functions, Views, Indexes, etc.)
  • Demonstrated experience in the area of database/query performance tuning
  • Development experience in Java (J2EE) and/or .NET
  • Familiarity with prevalent SDLC methodologies and ability to work in an agile environment

PREFERRED EXPERIENCE, SKILLS AND COMPETENCIES:

  • Experience performing Database Administrator duties on Oracle (11g, 12c)
  • Experience with Data Warehouses and High-Volume databases
  • Experience with Database ETL-s such as SSIS
  • Experience with Visual Studio .NET and/or Eclipse
  • Experience with version control software and related principles (tagging, branching, etc.)
  • Configuration/Build management experience, including knowledge of InstallShield

About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

Only registered members can apply for jobs.

Related Jobs

Cloud Architect   Boston, MA new
November 15, 2019
Azure Infrastructure Engineer   Rosemont, IL new
November 15, 2019
Azure Identity Engineer   Indian Land, SC new
November 14, 2019
Azure Consultant   Carrollton, TX new
November 13, 2019
Cloud Engineer   Reston, VA new
November 12, 2019

St. Cloud OfficeTeam Staffing Manager

Azure Engineer