Project Management Sql Server

Aly Sangare New York, NY 917-***-**** *******@*****.*** LinkedIn

IT Consultant SQL Server DBA

Motivated and experienced IT engineer with over 7 years of experience in banks and software companies. Proficient in SQL for query databases, cybersecurity measures, IT auditing, and project management. Adept at ensuring high availability, and IT General Control.

Core Competencies

- SQL Server Database Administration

- Cybersecurity Protocols and Practices

- IT Auditing and Compliance, PCI DSS

- Project Management and Coordination

- Data Analysis with Power BI, Machine Learning

- Data Modeling, monitoring, and Query Optimization

- Data Backup and Recovery

- Database Security Management

- Scripting with T-SQL, DAX, and PowerShell

- Agile and Risk management

- Programming fundamental in Python, C++, C# and

ASP.NET, Scripting with T-SQL, and PowerShell

Professional Experience

Allied Universal Services for Bank of America– New York, NY February 2023-Current Corporate Security Professional

Used video cameras to monitor individual physical access to sensitive areas using PCI DSS requirements

Ensure the visitor’s log contains the name, firm represented, and the onsite personnel authorizing physical access.

Ability to perform physical controls, wrote daily reports and archived them to be reviewed later as needed. Who’s Your Data– Spanaway, WA June 2022-December 2022 IT Support Engineer

Unified work organization with ServiceNow

Customized, and configured computers to optimize performance and meet user needs.

Conducted data recovery and provided proactive help desk support for technical issues.

Performed tests to validate the integrity and effectiveness of controls that are in place. EDITEC UK Ltd– Kinshasa, DRC April 2013-February 2020 DBA Consultant

Ability to conduct IT projects and ensure database updated and available.

Conducted database management and documented audit evidence.

Provided high availability and performance for mission-critical databases.

Coordinated and collaborated with developers to ensure data models meet application requirements.

Perform database performance tuning, query optimization, and backup/recovery operations.

Implemented database security methods to ensure the security of company data.

Created reports and visualizations with Power BI, T-SQL scripting, and Excel AFRIQUE EMERGENCE & INVESTISSEMENTS– Abidjan, Ivory Coast August 2008-Mars 2013 IT Support Engineer

IT conference to find an application for microfinance, AFRICAP Johannesburg – South Africa

IT conference to improve Bankers Realm Microfinance (BRMFO) System, Craft Silicon Nairobi – Kenya

Managed databases migration and ensured BRMFO deployment efficiency.

Communicated with all levels of management to ensure full understanding of IT objectives, risks, and controls. Education

Bachelor’s degree in Computer Science, Institut National Polytechnique Houphouet Boigny, Ivory Coast (Cote d’Ivoire) Certificate Cybersecurity, Columbia University Engineering Bootcamp, New York Certificate Project Management Program, Stony Brook University, New York Certification

Certificate program IT Audit and Cybersecurity Compliance, Your IT Career, New York Certificate SQL Server DBA, NSTAR Technologies, New York Certificate SQL Server Database and Business Intelligence, JanBask Training, New York Certificate Cloud Computing and Project Advanced Database, Coursera, New York Project

Database Migration Project

I managed a cross-functional team to successfully migrate databases to a new SQL Server environment with zero downtime also enhancing database security, resulting in a 50% reduction in vulnerabilities. Analysis of a vulnerable Network Project

In this project, I acted as a security engineer supporting an organization's SOC infrastructure. The SOC analysts have noticed some discrepancies with alerting in the Kibana system and the manager has asked the security engineering team to investigate and confirm that newly created alerts are working. Then I monitored live traffic on the wire to detect any abnormalities that aren't reflected in the alerting system. Then, I reported back my findings to the manager with appropriate analysis. System integration to launch a new product

The project included infrastructure selection, data migration, users training, customization, and system integration with existing platforms. I implemented a system connected to the private cloud, generated reports for managers and improved data management. As a team leader, I ensured that technicians and operation manager understand how the system works and how to generate their reports. I continued to communicate with the team and solve some problems remotely. Member of Association

Member of ISACA

Contact this candidate