TapTalent.ai

Senior SQL Database Administrator and AWS Administrator

Bengaluru, KA, IN

4 days ago
Save Job

Summary

🌟 We're Hiring: Senior SQL Database Admin and AWS Admin for a leading product based company! 🌟

We are seeking an experienced Senior SQL Database Administrator and AWS Administrator to manage our database systems and cloud infrastructure. The ideal candidate will possess extensive knowledge of SQL databases, performance tuning, and AWS services to ensure optimal system performance and security.

📍 Location: Remote

⏰ Work Mode: Work from anywhere

💼 Role: Senior SQL Database Administrator and AWS Administrator

What You'll Do

  • Manage and maintain 20+ servers and 100+ databases, supporting a maximum size of 2TB across various SQL Server versions
  • Provide 24x7 production support for SQL Server environments, ensuring high availability and performance.
  • Install, configure, and upgrade SQL Server instances, including standalone and clustered servers.
  • Develop and implement database designs, including SQL objects, constraints, stored procedures, views, and dynamic SQL.
  • Execute code deployment in staging and production environments, including debugging and high-priority bug fixes.
  • Expertly handle database backup, recovery, restoration, and disaster recovery planning.
  • Perform comprehensive performance tuning, including analysing slow-running queries, identifying missing indexes, and optimizing statistics.
  • Configure and maintain AWS cloud environments, including RDS, EC2 instances, S3 storage, and setting up alert alarms for monitoring system health.
  • Ensure database and application server retention policies are maintained according to best practices.
  • Manage user permissions, job scheduling, and troubleshooting of failed jobs.
  • Conduct replication, log shipping, database mirroring, and disaster recovery activities, including failover and failback operations.
  • Lead migration and upgrade projects, from SQL 2005 to more recent versions and AWS migration efforts.
  • Install and configure SSRS, managing security and creating basic SSIS packages for deployment.

Requirements:

  • Minimum of 10 years of experience as a Senior SQL Database Administrator, including significant work with AWS Cloud SQL development in production environments.
  • Demonstrated experience with SQL Server versions 2005 to 2017 and AWS cloud services (RDS, EC2, S3).
  • Have experience of implementing Azure CI/CD pipelines
  • Experience of migration from AWS to Azure or vice versa
  • Strong background in database design, maintenance, and optimization with a focus on performance tuning and security.
  • Proficient in code deployment, debugging, and report generation.
  • Familiarity with high availability concepts on AWS, Windows
  • Maintenance in EC2, and various SQL Server maintenance tasks.
  • Experience with database replication, DR activities, and cluster management.
  • Knowledge of SSIS package creation and SSRS configuration.
  • Excellent problem-solving skills and ability to conduct root cause analysis on database and disk space issues.
  • Effective communication skills, with the ability to collaborate with cross-functional teams.
  • Bachelor’s/Masters degree in Computer Science, Information Technology

Ready to make an impact? 🚀 Apply now and let’s grow together!

How strong is your resume?

Upload your resume and get feedback from our expert to help land this job