Description

Job description

  • Must have 15+ years of IT experience.
  • Must have extensive experience working in large environment.
  • Big financial customers domain experience is a plus.
  • Extensive and very strong performance tuning.
  • Must have strong experience in automation scripts.

 


Please talk to the candidates as per below skills do not submit if they don’t have any skills.

 

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

 

•            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

 


 

Education

Any Gradute