SQL Database Administrator- Cloud RDS-AWS

Job Description

Role & responsibilities Understand current database designs and database deployment architectures for all product lines. Review and propose steps for optimal database response, train and advise development and support teams in appropriate data handling techniques covering security, design, collection, query and storage. Track resource utilization, collect performance metrics and tune server configuration for optimal performance. Prepare and execute database management processes, including but not limited to patching, maintenance plans, performance review plans, self-audits etc. Prepare and maintain documentation relevant to data models for all product lines. Prepare and maintain documentation relevant to data management e.g. data flows and integration, data security policies and procedures etc. Prepare and maintain documentation relevant to database administration e.g. disaster prevention and recovery processes and policies, access control, maintenance schedules etc. Report status of data management and database administration activities and checklists in reviews with senior management. Periodically identify risks and challenges, define mitigation and plans for continuous improvement in services. Review and execute DDL and DML scripts on production environments, maintain logs of changes; manage access to test and production databases. Participate in incident management and RCAs. Plan and execute approved activities in consultation with senior IT management. Keep track of industry standards and emerging tools, techniques and practices and make appropriate recommendations for implementation. Preferred candidate profile Bachelors degree or equivalent with experience in administering Microsoft SQL Server databases hosted on cloud and RDS (on AWS) / managed services on any public cloud. Work experience of 4 - 6 years with 3 5 years as a Microsoft SQL Server DBA. Experience working with product development teams and understanding of the role a DBA plays in maintaining application performance and availability. Automotive domain experience will be beneficial. Must be proficient in MS Office tools like Word, Excel, and PowerPoint.