Role and responsibilities:

• MYSQL database architect.
• Exp - 7+Yrs.
• Plan and install upgrades of database management system software to enhance database performance. ·        Demonstrate database technical functionality such as performance, security and reliability. 
• Identify and correct deviations from database development standards. 
• Create and enforce database development standards. 
• Set-up database clusters, backup, or recovery processes. 
• Document and communicate database schemas, using accepted notations. 
• Develop or maintain archived procedures, procedural codes or queries for applications. 
• Develop load-balancing processes to eliminate down-time for backup processes. 
• Develop data models for applications, metadata tables, views or related database structures. 
• Test changes to database applications or systems.
• Provide technical support to junior staff or clients. 
• Identify, evaluate and recommend hardware or software technologies to achieve desired database performance. 
• Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware. enhancements are scheduled appropriately.
• Design databases to support business applications, ensuring system scalability, security, performance and reliability. 
• Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.
• Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements. 
• Develop database architectural strategies at the modelling, design and implementation stages to address business or industry requirements.
• Develop and document database architectures.