Required Skills

SQL Server DBA MSSQL MySQL and Postgres

Work Authorization

  • Us Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

Employment Type

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 24th Feb 2021

JOB DETAIL

 

 

Responsibilities:

• Manage multiple RDBMS platforms (MSSQL, MySQL and Postgres etc.) through multiple product lifecycle environments, from development to mission-critical production systems.

• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.

• Independently analyze, solve, and correct issues in real time, providing problem resolution endto-end.

• Refine and automate regular processes, track issues, and document changes.

• Assist developers with complex query tuning and schema refinement.

• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

• Provide rotation-based 24/7 on call support for unplanned outages and planned maintenance/release events.

• Collect and report database performance KPI’s on regular basis.

 

Skills:

• Bachelor’s degree in information technology or related discipline.

• 5+ years of database administration experience preferably in MSSQL, MySQL and Postgres.

• At least 2 years of cloud based database administration experience.

• Experience in troubleshooting and resolving database problems

• Experience in implementing operational automation using scripts.

• Hands on experience with SSIS,SSRS,SSAS and PowerShell. 

• Extensive experience with Windows/SQL*Server Clustering (On Physical & Cloud based VM’s), Always ON, Replication, Mirroring.

• Experience with Performance Tuning and Optimization (PaaS & IaaS).

• Experience with backups, restores and recovery models

• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

• Experience working with Windows server, including Active Directory

• Excellent written and verbal communication

• Flexible, team player, “get-it-done” personality

• Ability to organize and plan work independently

• Ability to work in a rapidly changing environment

Company Information