Senior MySQL DBA position
Location: Montreal Downtown
Start: ASAP
Permanent position
Description of the Position
Reporting to the Director of IT Support, working as part of the technology operations team, this candidate will be responsible for the administration of our MySQL database environment including database design, implementation, performance tuning, capacity planning and replication
KEY RESPONSIBILITIES:
•Develop and support database replication
•Monitor and optimize database performance and capacity planning.
•Install, configure and upgrade of MYSQL databases.
•Performance tuning of MYSQL databases
•Develop methods for monitoring , proactively monitoring database performance and come up with suggestions
•Data modeling (Logical and Physical) and architecture
•Design and Implement various MYSQL backup/recovery strategies
•Troubleshoot database issues, maintain database systems availability and scalability
•Standardize the program environments to ensure that we have the same set of procedures and guidelines for developing queries and moving releases to production.
•Participate in the application deployment and roll back process
•Ensure we have monitoring scripts to track database configuration modifications
•Investigate all User feedback/production issues in a timely manner and provide a recommendation to the development team.
•Assess weaknesses of our current environment, recommend improvements to our database environments to help standardize and streamline the move to prod and support process
•Establish and maintain sound backup and recovery policies and Procedures.
•Implement and maintain database security
•Setup and maintain documentation and standards
•Do general technical troubleshooting and give consultation to development teams
•Participate in Disk layout and Disk capacity planning
•Set up and monitoring of data replication
•Help Monitoring and maintenance of standby databases
•Help design and develop tools for Database Services team
•Perform Load testing.
•Design and Deploy the database for the specific requirements, perform data migration
•Lead Components of Projects/tasks
•Identify Bottle necks and provide solutions
•Support Linux and Windows DB Servers, in production and other environments.
•Will act as a project resource – research, testing, implementation, training etc.
QUALIFICATIONS :
•University or college Computer Science degree or equivalent experience
•8 years in DBA role. At least 4 years of MySQL DBA experience.
•Certified MySQL DBA is a PLUS
•Experience with Microsoft SQL DBA experience will have an added advantage.
•Candidate should be senior technologist/DBA expert.
REQUIRED SKILLS:
•Proven experience in supporting databases in production
•Demonstrated experience with MySQL database design, implementation, performance tuning, capacity planning, replication and slave setup.
•Experience managing a large scale database system is a PLUS
•Familiar with MYSQL Administration including various storage engines, client tool and working with MYSQL technical support.
•SQL: T-SQL, Triggers
•Experience working with innodb
•Demonstrated experience with Open Source/Linux development and production environment
•Solid experience in shell scripting, Coding Scripts, Procedures, functions, etc.
•Excellent in OLTP Performance tuning
•Skills required in areas of Microsoft SQL Server 2000/2005 such as Transact-SQL, replication, DTS/SSIS packages, SQL Agent jobs, SQL Reporting Services, and ActiveX scripting.
•Familiar with other software such as Visual Studio .NET, Windows Server Applications (IIS, Cluster Administrator, & Terminal Services).
•Excellent problem solving skills.
•Team player with excellent communication skills.
•Strong knowledge of software quality assurance best practices and methodologies.
•Ability to work under pressure and adhere to deadlines/SLA agreements
•Highly motivated, resourceful and adaptable
•Experience in a small or medium-sized business an asset