Victor Ezeokonkwo
Database Administrator
Talent
Toronto, OntarioMember since June 9, 2023
·
Hire this person
Send a job offer directly to this candidate
About
With over 6 years of experience in Microsoft SQL administration. Dedicated and hardworking SQL Database Administrator. Demonstrated expertise in designing, developing, and maintaining complex real-time SQL databases and related applications. Possess a good understanding of SQL language and query optimization techniques. Strong analytical and problem-solving skills and ability to create efficient and effective solutions that meet data requirements while ensuring data integrity and accuracy.
Experience
- Managed and maintained a large-scale SQL Server database environment supporting mission-critical applications.
- Implemented database monitoring and alerting mechanisms to proactively identify and resolve performance issues.
- Resolved database-related issues promptly, ensuring minimal impact on business operations.
- Implemented and maintained SSIS packages for ETL (Extract, Transform, Load) processes, ensuring efficient data integration and transformation.
- Developed and implemented disaster recovery plans, ensuring business continuity in case of system failures.
- Participated in database capacity planning and scaling efforts to support business growth.
- Conducted regular security audits and implemented security patches and updates.
- Optimized database performance by analyzing query execution plans, indexing strategies, and database configurations.
- Installation, configuration, and administration of SQL Server Databases 2012/2014/2016/2019
- Assisted in database migration projects, ensuring smooth transition and minimal disruption.
- Completed data virtualization using Power BI and SQL server to create an interactive and insightful dashboard
- Developed, implemented, optimized stored procedures and functions using T-SQL, developed, automated maintenance plans and schedule jobs
- Implemented SQL Logins, roles, and Authentication Modes as a part of Security Policies for various categories of users.
Education
BSC in Information Technology & Business Information Systems Middlesex University, UK
