MsSQL Dba

Support Database Platform Engineering in the architecture, development, and deployment of MySQL databases in high SLA environments.- Manage, support, and maintain database technology and infrastructure, adhering to the architectural guidelines and policies.- Install, configure, monitor, upgrade and maintain MySQL database in production and non-production environments.- Participate in Database Maintenance and DR activities.- Provide technical expertise and hands-on support in consolidation and migration of databases to new hardware and platforms.- Physical implementation of databases, storage structures, high-availability solutions, replication, and disaster recovery solutions.- Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of escalated Level 2 and Level 3 issues. Responding to database-related incidents, diagnose issues, perform root cause analysis, and implement corrective actions to ensure system stability and availability.- Regular database capacity planning related to database growth and system utilization, trend analysis, predictive future database resource requirements, and the structured organized reporting of the same.- Work closely with other Infrastructure engineering, product development, business operations, and technical operations to ensure delivery of database services within the SLA’s and performance targets.- Adapt business requirements, model data, and develop database specifications, table, and element attributes.- Participate in the evaluation, selection, and implementation of DBA tools to improve the effectiveness of tasks such as performance monitoring and tuning, recovery, and database change management processing.- Database Performance Optimization: Monitor, analyze, and optimize the performance of MySQL databases by identifying and resolving performance bottlenecks, optimizing queries, and implementing performance tuning techniques.- Database Administration: Perform regular database administration tasks such as database installation, configuration, backup, recovery, and security management. Ensure high availability and disaster recovery strategies are in place.- Monitoring and Alerting: Develop and implement database monitoring and alerting systems to proactively identify issues, respond to alerts, and troubleshoot database-related problems.- Database Security: Implement and enforce security measures and best practices to protect the MySQL databases against unauthorized access, data breaches, and other security threats.- Collaboration: Work closely with cross-functional teams including developers, system administrators, and network engineers to resolve database-related issues and improve overall system performance.Basic Qualifications:- 3 or more years of work experience with a Bachelor’s Degree or more than 2- years of work experience with an Advanced Degree (e.g. Masters, MBA, JD,MD)- 3-5 years of DBA experience, with MySQL environment.- Hands-on experience with Stand alone instances, MySQL InnoDB clusters- Sound knowledge of all UNIX and MySQL utilities. Troubleshooting database- Should have strong UNIX platform skills and understanding of network,- Proficiency in writing functions and packages for administration and- Strong knowledge of operating systems, scripting languages, data modeling- Good interpersonal skills along with effective communication, both written- Demonstrated ability to solve complex systems and database environment- Demonstrate ability to work in a complex organization to determine business- Work experience in a Financial Institute will be preferred.- Ability to work well as a team and as an individual with mínimal supervision.- Strong MySQL expertise: In-depth knowledge and experience in administering,- Database Performance Tuning: Proficient in query optimization, indexing- Database Administration: Hands-on experience in database installation,- Monitoring and Alerting Tools: Familiarity with database monitoring tools- Scripting and Automation: Proficiency in scripting languages like Python,- Troubleshooting and Problem-solving: Strong analytical and problem-solving- Strong Communication: Excellent verbal and written communication skills to- Continuous Learning: A mindset of continuous learning and staying up to date**Job Types**: Full-time, ContractContract length: 12 monthsPay: $70,000.00 - $80,000.00 per month