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.
Worked on the complete migration of all database servers from an outsourced data centre to ERC's in-house data centre. The project included the migration of servers from SQL Server 2012 and 2014 to SQL Server 2016; handling the design and implementation of the new architecture to host all of the company's databases. Worked on over 50 SQL Server database servers and over 300 databases, with a total database size of around 10TB of data. Provided technical leadership for the smooth execution of the migration using the latest database admin tech stack, solutions and best practices.
Oversaw and handled the migration of the client's main production database server from SQL Server 2008 to SQL Server 2017. Architected and designed the strategy for the iteration of a new clustered SQL Server 2017 environment; moving the existing SQL Server 2008 databases to the new solution within the shortest time possible to minimize downtime. Designed new database maintenance solutions (Backups, Integrity Checks and Index Maintenance) on the solution using SQL Server 2017 and Integration Services.
This project consisted in the design and implementation of a data warehouse to support the Business Intelligence division. In this project I designed and created a SQL Server 2012 data warehouse. First, meeting with the marking and BI teams we defined what data was needed to fully support senior management in the reports they needed to make multi-million dollar decisions. I designed and implement the different ETL processes that would get data from multiple systems and consolidate them in the newly created data warehouse. Then I assisted the BI team to configure their BI solution to connect and read the data from this data warehouse. My role on this project was the lead database administrator. The technologies used in this project were SQL Server 2012, Integration Services, Reporting Services, ORACLE SQL Developer
