Senior DBA (PostgresDB, BigQuery) with GCP

Job Description

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. Highly Preferred scripting experiences: Python and PowerShell. 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.