Migrates the MySQL database to Azure MySQL Database
Design and deploy data table structures, forms, reports, and queries
Identify inefficiencies in current databases and investigate solutions
Diagnose and resolve database access and performance issues
Develop and maintain the database stored procedures, views and functions
Assist with the administration, security and performance monitoring of all relational databases in production and non-production environments
Produce ad-hoc queries and develop reports to support business needs
Create and maintain technical documentation
Develop and maintain the Data Warehouse
Implement data dashboards to display data in differing formats
Perform other duties as assigned
Design, develop and implement database systems based on customer requirements
Optimize database systems for performance efficiency
Perform space management and capacity planning for database systems. ï· Develop database tables and dictionaries
Ensure data quality and integrity in databases
Identify any issues related to database performance and provide corrective measures
Create complex functions, scripts, stored procedures and triggers to support application development
Participate in database design and architecture to support application development projects
Perform data back-up and archival on regular basis
Test databases and perform bug fixes
Troubleshoot database related issues in a timely fashion
Develop security procedures to protect databases from unauthorized usage
Evaluate existing database and recommend improvements for performance efficiency
Develop best practices for database design and development activities.