Description

Key skills to look at( Must have)

  • Query optimization and performance troubleshooting 5 to 8 years of experience
  • Experience working on large databases size between 10TB to 30 TB
  • Very good knowledge of MSSQL server internals
  • Hands-on experience working with table partitioning and maintenance (expert)
  • HA/DR good hands-on experience troubleshooting Always ON and clustering
  • Automation: PowerShell / Python / T-SQL ( 8 /10 at least) – worked on automation projects

 

Secondary Skills

  • At least 6 months of AWS RDS experience

 

Good to have

  • Database knowledge/expertise on MySQL/ PostgreSQL, RedShift, Snowflake, Oracle etc..  

 

 

Mandatory skills - SQL Server administration required skills

·      Knowledge on AWS Cloud services like RDS, S3, Redshift etc

·      MySQL/PostgresSQL knowledge / experience.

·      Linux Knowledge.

·       Experience with Azure

·       Experience with Snow Flake

·       Experience in PowerBI

Certifications Desired

•           MS certifications on MSSQL latest versions or AWS/Azure

 

Responsibility :

 

·       Ability to think about a problem, identify what we have and implement solutions to solve the problem independently

·         Work with onsite client team / Application owners in US / UK to Migrate Applications, Database building and Decommissioning

·         Ability to take lead on some projects and works as part of a team (follow another leader on others)

·       Strong verbal and written communication skills

·       Ability to think in and out of the box. Come up with service improvement ideas and innovative solutions.

·       Self-motivated, conscientious, dedicated individual who works equally well independently or as a member of a team

·       Must be willing to take responsibility and ownership instead of waiting to be assigned work

·       The candidate must be willing to provide On-call and weekend support for SQL and MYSQL, the support is rotated among DBA's in US and India

·         Enable and support the team in resolving day-to-day production issues, application upgrades and patches, performance analysis, disaster recovery implementation, capacity planning and other activities as may be necessary.

·         Work on Change implementations during UK, US business hours & weekends as per change management process

·         Documentation & Operational performance reporting

·         Own Service Improvements

·         Execute on demand IT projects

·         Drive compliance to client and organization processes and policies

·         Ensure Quality of deliverables

The above is not a comprehensive list and could change based on business requirements

Education

Any Graduate