Senior Engineering Specialist, Database Administration

Job title : Senior Engineering Specialist, Database Administration

• Provide sound, professional database advice, administration and proactive maintenance of the company data and database environments.
• Support the process for database architecture, installation, configuration, and management, while ensuring prompt and thorough backup, recovery, replication, and high availability.
• Perform optimization, including the writing of query, indexing, and optimization techniques to ensure efficient data retrieval and manipulation.
• Carry out database design, data modeling, and normalization to ensure scalable and performant database structures.
• Monitor, analyze, and optimize database performance, troubleshoot issues, and resolve problems related to query performance, indexing, and resource utilization.
• Set up procedures to monitor all database environments and ensure a minimum of 99.9% uptime.
• Work with the team to resolve issues and escalate extreme cases to the appropriate OEMs.
• Recommend new database and data architecture which would yield cost saving and enable increased growth of the revenue of the organization.
• Ensure periodic security checks on the database systems to prevent fraud and expose any compromise attempt noticed on the database.
• Ensure and test performance level on the databases and ensure compliance with data protection regulations and industry best practices.
• Plan Business Continuity operations and Disaster Recovery Operations to meet the required RTO and RPO as defined by the organization.
• Manage and maintain databases, ensuring high availability, performance, and security.
• Design and implement backup, recovery, and disaster recovery plans, and optimize server databases for efficiency and scalability.
• Troubleshoot database issues and implement long-term solutions; maintain database documentation, procedures, and governance policies.
• Collaborate with development teams to improve database architecture and optimize queries.
• Monitor disk usage, system performance, and capacity planning; update and maintain repositories with database-related code and scripts.