I am an experienced DBA/SQL Developer providing oversight and expertise for databases and data structures, experience in reviewing database performance trends, and identifying opportunities for improvement. I am passionate about data, coding, and technology; utilizing different skills and tools to solve complex problems requiring extensive use of data collection and analysis. I am an avid learner; proficient in the entire SQL Server suite and entering new frontiers in Business Intelligence and Data Warehousing.
Delivers data warehouse and ETL solutions as part of an agile team using advanced machine learning techniques to improve performance and processes.
Helps build and improve infrastructure, application and performance development and ensures tight security including data encryption, security groups, and environment scanning.
Ensures high-quality deliverables and implements DevOps and security best practices in fast-paced environments.
Design, develop and implement database solutions based on customer requirements on projects; optimizing database solutions for performance efficiency.
Monitored database capacity on projects for clients; handling space management, iterating database tables and dictionaries, and ensuring data quality and integrity on projects.
Create complex functions, scripts, stored procedures and triggers to support software development; participating in database design and architecture tasks, and perform data backups and archiving regularly.
Database Director / Database Administration Manager / Database Administration Team Lead / Senior Database Administrator
2017 - 2019 (2 years)
Dominica
Provided 24/7 technical support for different database environments; implementing policies, enforcing methodologies for database administration and database maintenance.
Designed and implemented solutions on database security, database backups and highly available solutions; working on developments, QA and UAT within production environments.
Managed task priorities to support ERC's Business Intelligence department; designing and deploying Power BI reports and working on the database engine's version upgrade and patches.
Built and maintained Oracle DB and SQL Server systems with high availability and throughput for Claro's IPTV department; configuring and administering the servers in Windows and Linux.
Worked on the maintenance of databases to keep them in optimal conditions; minimising database downtime and managing parameters to provide fast query responses.
Handled the design and implementation of the database security schemes on the project; enforcing and documenting database policies, procedures and standards.
Supervised the configuration and administration of database servers in Windows and UNIX/Linux; monitoring database performance and implementing changes when necessary.
Provided database subject matter expertise for the maintenance of databases within Banco H.D; keeping them in optimal conditions, assisting with technical solutions and implementing enhancements.
Designed and defined the disaster recovery strategy and worked on database consolidation to reduce the sub-utilization of server resources.
Led the bank’s data management, security, and migration tasks; handling installations and configurations and the administration of database environments.
Examined the bank’s data management systems; identifying opportunities to enhance server and database performance, and improve backup strategies.
Identified requirements and implemented solutions to support database tasks, data analysis and PeopleSoft administration.
Managed multiple server resources and databases in development, staging, and live environments; requiring different methods of management and deployment.
Diagnosed and triaged database issues for the client; handling database documentation, design and implementation.
Work closely with development programmers on database tasks; ensuring that backup and other critical processes are running successfully and resolve issues quickly.