Employment Type : Full Time
Role : Senior Database Administrator
Experience : 10 to 12 Years
Work Location: Chennai (Hybrid)
Working hours: (From 5.00pm to 2am IST Shift)
- Minimum of 12 years of working experience in IT.
- Minimum of 10 years of experience in administering managing securing and tuning database servers (MS SQL Server MySQL & Postgres)
- Minimum of 3 years of cloud platform experience in CloudSQL/GCP or RDS/AWS.
- Install configure and maintain database instances across various environments.
- Monitor database performance identify and resolve issues related to performance capacity and reliability.
- Implement and manage database backup and recovery procedures to ensure data integrity and availability.
- Implement and manage database security policies including user access control data encryption and auditing.
- Identify and implement optimizations to improve database performance such as index tuning and query optimization.
- Maintain documentation of database configurations procedures and troubleshooting steps.
- Apply patches and updates to SQL Server instances in a timely manner to address security vulnerabilities and ensure compliance.
- Good understanding of database design physical and logical schemas and database modeling.
- Collaborate with developers to design and optimize database schemas and provide guidance on SQL best practices.
- Experience in query optimization and writing complex SQL queries.
- Experience in troubleshooting and resolving database integrity issues blocking and deadlocking issues as well as performance issues.
- Strong knowledge of indexes index management and configuration management.
- Experience in SSAS SSIS SSRS.
- GCPs Data warehouse platform experience is a plus (BigQuery DataFusion DataStream DataFlow & Looker)
- Work on projects as needed in close coordination with Architects Project Managers Application Architects and Development teams.
- Ensure team collaboration using Jira Confluence and other tools.
Qualifications :
- Bachelors degree or equivalent experience in computer science.
Additional Information :
Position Details:
This is an exempt position (40 hours /week) and is not eligible for overtime. You will participate in a Managed Objective Bonus program. Days of work are Monday through Friday 9:30 am to 6:00 pm IST or as scheduled by your supervisor.
Remote Work :
No
Employment Type :
Fulltime