SQL/SAN DATABASE ADMINISTRATION ASSISTANT MANAGER / Banco Popular Dominicano

Mar 2023 - Current

Microsoft SQL Server DBA for production areas

Description: Proficiently managed, constructed, rebuilt, and administered SQL Server instances across various versions, ensuring optimal functionality. Delivered adept support to a dynamic production environment boasting over 400 servers housing critical databases.

Sql Server Data Base Administration

• Maintenance of Sql Server Production servers and responsible for day to day activities for smooth running of the production environment.
• Carried out new servers building for Production environments
• Carried out SQL Server migrations and upgrades across multiple versions
• SQL Server performance monitoring and troubleshooting for performance bottleneck issues.
• Configuration and troubleshooting various SQL Server Application issues.

Power Shell

• Development of PowerShell scripts for comprehensive database readings on servers, with the ability to visually and systematically present results through dynamically generating HTML files.
• Retrieve servers with their databases using PowerShell.
• Folder and file sizes from a given path using PowerShell.
• Server Cores and Disks Report Generator in PowerShell.

Catholic University of Santo Domingo [Part-time]

May 2022 - Current

Dónde hacemos camino al Andar

Where we make our way when walking

Teacher at the School of Information Technology.

• Relational database
• Database I
• Database II
• Applications development
• Analysis and design of algorithms
• Introduction to programming
• Programming Language (Backend with C# .net)

Database Administrator / INABIMA

Jun 2014 - Mar 2023

Description: Role MS SQL Server DBA / Support Engineer Description Maintaining, building, rebuilding and managing servers owned by the team. The servers were Windows 2008, SQL Server 2005, 2008 R2,,2012 Provided 24x7 Tier 3 and infrastructure support to DEV, Test, QA and Production environments for over 15+ critical applications. Played Team Leader role and managed 5 members of team. Environments Supported Development, Test, program and Production environments. Contribution.

Sql Server Data Base Administration

• Maintenance of Production and pre-production servers and responsible for day to day activities for smooth running of the production environment.
• Carried out new servers building for Dev, Test, QA and Production environments
• Carried out SQL Server Migrations and Upgrades for SQL Server 2005 and SQL Server 2008,,2012 2014
• SQL Server 2008 , 2014 Reporting Services configuration and troubleshooting.
• Setting up Disaster Recovery Environment for critical applications
• SQL Server performance monitoring and troubleshooting for performance bottleneck issues.
• Worked on SQL Server 2005 / 2008 R2/ 2014 Backups, restore and recovery as well as created Disaster Recovery plan and tested successfully.
• Configuration and troubleshooting various SQL Server Application issues.
• Password reset of service accounts for SQL Server Security Accounts.
• Planned and applied major security upgrades
• Creation of Automatic Reports from Sql Server using SqlMail and HTML

Infraestructure Backup using Veams

• Creation of an infrastructure backup plan based on the frequency of execution and retention.
• configuration notification via email of backup execution plans.
• Restoration and virtual machines for both restoration tests and information recovery.

Configuration of Automatic Notifications via Sql Server.

• Creation of Punch System Reports via mail Using sql Server 2014 and HTML.
• Late Tickets.
• Take more than one hour of lunch.
• Departures Before Hours.
• Notifications of Hard Disk Spaces of MDFs Using sql server 2014 and HTML
• Security notification in case of touching tables Sencibles to pertinent user groups Using Sql Server 2014 and HTML.
• Report of Activities carried out by the database server. via Mail Using Sql Server 2014 and HTML
• Create File Copies and create folders to store them using Sql Server 2014
• Creation of Communications Reports extracted from the Transdoc system. Note: This allows a 15 day job to be Run and done in 30 Minutes

Power Shell

• Creation of Scripts to notify the space in the hard disks of the servers.
• Creation of Scripts to notify the memory consumed by the Servers in a determined time.
• Script creation to backup files, connecting to databases and updating statistics.
• Report creation using PowerShell containing information from the Active Directory.

Hybrid Android/IOS Application Development

Ionic Cordova with Angular JS

• Services Catalog
• Pensioner Payroll Consultation
• Service Centers
• News and Communications
• User Assistance
• Frequent questions.

Fire Notification App

• Fire PowerShell Disk Space Notification.
• Fire PowerShell Server memory Space.
• Fire PowerShell Backup Transport.
• Fire Employ entry, lunch and exits.
• Reports from process, backup disks Spaces from sql server

Fire Notification Control App

• This App allows us to have control over the Notifications App Installed to our Clients, in order to be able to block or unblock it on a phone whenever we want

NET/C# Developer / Distribuidora de Electricidad del Este

Mar 2012 - Jun 2014

Description: Languages/Frameworks: C#, ADO.NET, T-SQL, ASP.NET ,SQL SERVER 2008 R2 OS/Applications: Windows 7, Windows Server 2008 Summary of Duties and Responsibilities Maintaining enterprise web applications and implementing new projects for clients. This is a very structured environment where organization is a must.

C# Development
• Maintaining and adding new functionality to existing web applications and desktop application
• Developing Applications Using C # .net Sql Server and Oracle
• Development of the Energy Loss Control Application.
• Creation of applications for the control and monitoring of energy meters

Provide Maintenance and create new modules for Data Modification Application.

• Visual Basic 6
• Oracle

NET/C# Developer /DBA SQL Server 2008 R2 / Jurisdicción Inmobiliaria Poder Judicial República Dominicana

Jun 2010 - Mar 2012

Description: Managing SQL server databases for each district in the country. So how you manage domains and Windows 2003 server you lead the team that provided support to users. MS SQL Server DBA / Support Engineer Role MS SQL Server DBA / Support Engineer Description Maintaining, building, rebuilding and managing servers owned by the team. The servers were Windows 2008, SQL Server 2005, 2008 Provided 24x7 Tier 3 and infrastructure support to DEV, Test, QA and Production environments for critical applications. Played Team Leader role and managed 4 members of team. Environments Supported Development, Test, program and Production environments. Contribution

Sql Server Data Base Administration

• Maintenance of Production and pre-production servers and responsible for day to day activities for smooth running of the production environment.
• anagement of Databases SQL Server 2008,
• Creation of Apache Linux Server to distribute files necessary for the maintenance of the infrastructure.
  • Full Backup
  • Diferencial Backup
  • Transactional Backup
• creation, reconstruction and elimination of database indexes.
• Maintenance of Production and pre-production servers and responsible for day to day activities for smooth running of the production environment.
• Carried out new servers building for Dev, Test, QA and Production environments Management of Databases SQL Server 2008