• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 24th Nov 2020

Job Responsibilities:

·         Administer and maintain all environments and provide day-to-day operational support

·         Provide thought leadership, advice and guidance in your field of expertise, especially for architecture and design

·         Provide inputs in setting governance and standards related to all aspects of databases

·         Reduce the frequency and duration of IT database failures

·         Perform ongoing tuning of database instances

·         Build and provide actionable reports in support of performance testing to be submitted to the project teams to review and provide follow up actions to ensure optimum support to meet SLAs

·         Provide problem and root cause analysis data to the IT support organization through capacity management tools and techniques

·         Plan and implement backup and recovery of databases

·         Control migrations of database changes through the development life cycle

·         Perform database re-organizations as required to assist performance and ensure uptime of the database

·         Put standards in place to ensure that all application design and code is produced with proper integrity, security and performance

Qualifications:

·         Bachelor’s degree or equivalent work experience.

·         Minimum 7 years' experience with database administration for MSSQL Server 2014 and up

·         Minimum 3 years of SQL server database architecting experience

·         Good understanding of AWS technology and one year hands-on knowledge of Aurora + mongodb or some nosql db’s

·         Experience with administering databases greater than 5 TB

·         Experience in architecting a vldb

·         Automation experience for day to day tasks is required.

·         Experience with High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server 2014 and up, including failover clustering, log shipping, and MSSQL Always On

·         Experience in troubleshooting and resolving problems (performance issues, database integrity issues, blocking and deadlocking issues)

·         Experience in MS SQL Business Intelligence Stack (SSIS, SSAS and SSRS)

·         Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools

·         Experience with Microsoft SQL Server backup and recovery scenario

·         Experience with Microsoft SQL Server replication

·         Excellent communication and documentation skills

·         Experience in implementing operational automation using scripts is desirable

·         Experience with Delphix is highly desirable