Required Skills

MSSQL DBA

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 28th Jul 2021

JOB DETAIL

The ideal candidate for this role will have a passion for building, designing, and supporting complex and mission-critical data solutions with some experience in translating large-scale environments into the Microsoft Azure cloud environment.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Responsibilities for a Senior Database Administrator may vary, but should include:

·  Work independently and take a lead role on projects with minimal supervision.

·  Serve as a go-to resource for questions related to database systems.

·  Identify database performance and capacity requirements by analyzing current workloads and utilizing best practices.

·  Serve in an architectural capacity for database high availability and disaster recovery design.

·  Support team initiatives by developing tools and identifying opportunities for process automation; assist in evaluation and selection of standard tools.

·  Support and build automated environment installation and setup processes.

·  Interact positively with customers to support processes critical to business operations.

·  Monitor and troubleshoot database instances; perform root-cause analysis; identify opportunities for improved system performance, assist development teams with implementation.

·  Work closely with System Administration team to support infrastructure enhancements and maintenance.

·  Participate in production support on-call rotation to triage and resolve critical issues outside of business hours.

·  Contribute to other team efforts as needed to support day-to-day database operations.

·  Drive vulnerability remediation

·  Create and manage database standards

REQUIRED SKILLS:

·  Strong verbal and written communication skills

·  Ability to develop and grow interpersonal relationship within and across teams

·  Expert knowledge of common database administration tasks such as backup & restore, recovery models, integrity checks, and replication methods.

·  Experience automating SQL Server administration tasks and workflows at scale.

·  Modern SQL Server High Availability & Disaster Recovery features.

·  Familiarity with modern SQL Server data protection and security features.

·  Firm understanding of the most prominent Azure database technologies such as Azure SQL Database and Azure SQL Managed Instance.

·  Fundamental knowledge of performant T-SQL code is required, strong expertise in this area is a bonus.

·  Experience with Azure Cosmos Db

·  Experience with common tools utilized in our environment such as Splunk, Litespeed SQL Backup, Git, ServiceNow, Foglight, and Spotlight.

·  Experience developing and delivering presentations.

EXPERIENCE:

·  10+ years of experience in an Information Technology environment with at least 5 years in an operational role directly supporting MS SQL Server.

·  Prior experience working with large (2tb+) transactional databases.

·  Prior experience working at scale across a large environment with hundreds to thousands of databases in-scope.

·  Experience translating environments into Azure Managed Instance and other Azure technologies will be given a strong preference.

·  Experience working with SQL replication and SQL Availability Groups

Schedule:

·  Monday to Friday including some weekend on-call

Education:

·  Bachelor's (Preferred)

Experience:

·  Microsoft SQL Server: 5 years (Required)

·  Database Administration: 6 years (Required)

·  Azure: 2 years (Required)

·  T-SQL: 3 years (Required)

·  Recent SQL certifications (Preferred)

Company Information