Senior Database Developer / Admin

Job Description

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.
• GCP’s 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

• Bachelor’s 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.