Jorge Berrios Email & Phone Number

Charleston, South Carolina Metropolitan Area

In support of the DHA SharePoint database servers, DBA’s responsible for the maintenance, configuration, and up-time and accessibility of all Microsoft SQL Server instances support SharePoint WebSites. This include patching, database management, server maintenance, server tuning and interpreting and applying security policies along with the installation of new instances when required and approved by Technical Management Team, validation and installation of OS and SQL updates on the above indicated servers when such updates are approved by Technical Management Team. Report all problems found during status checks or maintenance window operations to the chain of command for review along with recommendations to correct the issues. Responsible for interfacing with and assisting customers of DHA and Associated commands in support of commands local SQL server issues as approved by DHA Management.

Charleston, South Carolina Area

In support of the ESOC and DHA Remedy database servers, DBA’s responsible for the maintenance, configuration, and up-time and accessibility of all 142 Microsoft SQL Server installed instances installed across the enclave globally along with the DHA Global Remedy Database. This include patching, database management, server maintenance, server tuning and interpreting and applying security policies along with the installation of new instances when required and approved by Technical Management Team, validation and installation of OS and SQL updates on the above indicated servers when such updates are approved by Technical Management Team. Report all problems found during status checks or maintenance window operations to the chain of command for review along with recommendations to correct the issues. Responsible for interfacing with and assisting customers of ESOC and Associated commands in support of commands local SQL server issues as approved by ESOC Management.

Charleston, South Carolina Area

• Oversee SQL Server Enterprise environment in VMware virtual solution.• Designed, installed, configured and administered SQL Server 2000/2005/2008/2008 R2/2012 on production and development environments. • Managed and configured over 15 SQL Server instances while maintaining a high level of application availability in an enterprise level environment. Incorporated virtual technology (VMware) to lower physical overhead.• Performed administration tasks that included backup, restore, mirroring, log shipping, schema compare, user account creation, database user role, stored procedures, performance monitoring and index optimize on different databases.• Created database objects such as tables, indexes, constraints, stored-procedures, functions and schemas using T-SQL scripts.• Supported multiple databases in production & development environments as lead DBA. • Provided new database solutions including design new SQL Server, databases, schemas, indexes and backup strategy.• Constant database monitoring to identify bottleneck and slow T-SQL statement.• Provided fault tolerance solution including replication, mirroring and log shipping.• Responsible for database security to ensure accurate and appropriate use of resources and data.• Performed scheduled tests to assess the database backup plan and integrity of the backups.• Took ownership of an aspect or task on a project with little to no assistance.• Designed, configured and integrated virtual MS SQL servers used VMware ESXi 5.• Installed, configured, supported multiples VM Windows Servers 2000, 2003, 2008R2 and 2012 using vSphere 5.x.

Charleston, South Carolina Area

• Designed, installed, configured and administered SQL Server 2000/2005/2008/2008 R2/2012 on production and development environments. • Managed and configured over 15 SQL Server instances while maintaining a high level of application availability in an enterprise level environment. Incorporated virtual technology (VMware) to lower physical overhead.• Performed administration tasks that included backup, restore, mirroring, log shipping, schema compare, user account creation, database user role, stored procedures, performance monitoring and index optimize on different databases.• Created database objects such as tables, indexes, constraints, stored-procedures, functions and schemas using T-SQL scripts.• Supported multiple databases in production & development environments as lead DBA. • Provided new database solutions including design new SQL Server, databases, schemas, indexes and backup strategy.• Constant database monitoring to identify bottleneck and slow T-SQL statement.• Provided fault tolerance solution including replication, mirroring and log shipping.• Responsible for database security to ensure accurate and appropriate use of resources and data.• Performed scheduled tests to assess the database backup plan and integrity of the backups.• Performed physical to virtual (P2V) using VMware vCenter Converter and VMware converter standalone version.• Designed, configured and integrated virtual MS SQL servers used VMware ESXi 5.x• Provided administration, configuration, and maintenance for NetApp 3140 and 2240 appliances (Ontap version 8.1). This included aggregate, volumes, lun, and iSCSI initiators maintenance using CLI or OnCommand system manager.

Fort Lauderdale, Fl

Installed, configure and deployment new Windows Server 2008 Domain, DHCP and DNS. Configure Windows Server 2008 member server and installed SQL Server 2008 with COTS application.Install Windows 7 Professional Configure database server and database security add new users and assign database role. Created stored procedure, T-SQL Script, table, clustered and non-clustered index.Create financial report using SSRS.Configured a maintenance plan for backing up database and transaction logs, reorganizing and rebuilding index, checking database integrity, updating statistics, deleting old history logs.

Administer Windows Server 2003 domain that included user accounts creation, NTFS configuration, active directory security permissions, file sharing, troubleshooting and resolve complex server based problems.Configured and troubleshooting Windows Vista and XP to LAN using DHCP and static IP address configuration.Ensured servers were effectively monitored and maintainedMaintained and support the Microsoft servers and desktop including: upgrading to new releases, applying patches, maintenance upgrades, server configuration, security patches and hardware assembly to maintain 500 workstation and server farm.

Analyze and design new servers and storage systems. Performed project management for technical projects that improved performance and business functionality to QC and In-Process Laboratories. Optimize LAN using performance reports and monitoring applications in 24 x 7 environments. Hand-on experience with MS SQL 2000/2005, T-SQL, PL/SQL, Oracle database administration, maintenance, migration and testing database in Windows 20003 server environment. Implement TCP/IP core networking service using Windows NT, XP, 2003 Sever, 2000 professional, DHCP, WINS and DNS. Supervised and directed two Consulting personnel during project implementation

Performed administrations for Windows 2000, 2003 and NT network with over 500 end users. Provided technical support to Waters® NuGenesis, Waters® Empower, Isotrain, and LIMS systems that included troubleshooting, tuning, monitoring, backup and restore of Oracle databases 8 and 8i. Performed system administration for Unix AIX servers with Oracle database 8i that included user accounts maintenance, applied upgrade, patches maintenance and monitoring application in 24 x 7 environments.