
MS SQL Database Administrator
- Bangalore, Karnataka
- Permanent
- Full-time
- Design, implement, and optimize databases across MS SQL Server, Oracle, and PostgreSQL environments.
- Participate in architecture/design reviews, ensuring database structures align with application needs and performance goals.
- Define and maintain best practices for schema design, indexing strategies, and query optimization.
- Conduct proactive query tuning, execution plan analysis, and indexing strategies to optimize database performance.
- Monitor, troubleshoot, and resolve performance bottlenecks across MS SQL Server, Oracle, and PostgreSQL.
- Implement partitioning, replication, and caching to improve data access and efficiency.
- Implement HA/DR solutions for all supported databases, including MS Clustering, Oracle Data Guard, PostgreSQL Streaming Replication, and AlwaysOn Availability Groups.
- Perform capacity planning and ensure proper backup and recovery strategies are in place.
- Automate and test failover and recovery processes to minimize downtime.
- Implement role-based access control (RBAC), encryption, auditing, and compliance policies across all database environments.
- Ensure adherence to SOC 2, ISO 27001, GDPR, and HIPAA security standards.
- Collaborate with security teams to identify and mitigate vulnerabilities.
- Integrate database changes into CI/CD pipelines, ensuring automated schema migrations and rollbacks.
- Use Terraform or other IaC tools for database provisioning and configuration management.
- Automate routine maintenance tasks, monitoring, and alerting using New Relic and PagerDuty or similar.
- Manage cloud-based database solutions such as Azure SQL, Amazon RDS, Aurora, Oracle Cloud, and PostgreSQL on AWS/Azure.
- Work with NoSQL solutions like MongoDB when needed.
- Support data warehousing and analytics solutions (e.g., Snowflake, Redshift, SSAS).
- Provide on-call support for database-related production incidents on a rotational basis.
- Conduct root cause analysis and implement long-term fixes for database-related issues.
- DevOps & SRE teams to improve database scalability and monitoring.
- Developers to ensure efficient database designs and optimize queries.
- Cloud & Security teams to maintain compliance and security best practices.
- 7-10 years of experience managing Oracle, MS SQL Server, and PostgreSQL in enterprise environments.
- Expertise in database performance tuning, query optimization, and execution plan analysis.
- Ability to implement replication, clustering, and HA, AlwaysOn, and cloud technologies.
- Hands-on experience with cloud databases in AWS or Azure (RDS, Azure SQL, Oracle Cloud, etc.).
- Solid understanding with backup strategies, disaster recovery concepts, and failover testing.
- Proficiency in T-SQL, PL/SQL, and PostgreSQL SQL scripting.
- Basic scripting understanding and exposure to PowerShell, Python, or Bash.
- Experience with cloud-based databases (e.g., Azure SQL, Oracle Cloud).
- Exposure to high availability features like Always On or Oracle RAC/Data Guard.
- Basic scripting skills in PowerShell or Bash.
- Relevant certifications (e.g., Oracle OCA, Microsoft Azure Database Fundamentals).
- Azure Database Administrator Associate, or AWS Certified Database - Specialty.
- Bachelor's degree in Computer Science, Data Engineering, or equivalent experience.
- This role requires a satisfactory Criminal Background Check and Public Safety Verification.
- Work with cutting-edge database technologies in a fast-paced, DevOps-driven environment.
- Make an impact by supporting critical EHS applications that improve workplace safety.
- Flexible remote work options and opportunities for professional growth.
- Collaborate with top-tier cloud, DevOps, and security experts to drive innovation.
This position is also eligible for bonus as part of the total compensation package.