Daniel Berber Email & Phone Number

Kingwood, Texas

Part of the Infrastructure DBA Team in charge of all SQL Server Instances including standalone, FCI, Always ON Availability Groups. Main automation engineer to the team by creating multiple PowerShell Modules for automating our SQL Builds and Data collection for analysis and reporting using Jenkins job pipelines and other open source stack such as (Telegraf/InfluxDB/Grafana).Responsibilities:• Install and Configure SQL Server according to best practices• Monitor the health and availability of all databases in our enterprise• Performance tuning by analyzing execution plans and IO Statistics using query store and DMVs• Improve Instance overall performance by looking at the top wait times• Maintain 99.999 availability in our Mission Critical Databases• In charge of the SQL Server Hyper-V Templates, making sure they follow industry best practices• Backup and Restore Databases and needed• Setting up database maintenance jobs including rebuild, dbcc checkdb, update stats• Automate SQL Builds using Jenkins Pipelines• Azure Database deployment and access management• Docker POC• SQL Server encryption using TDE, column level encryption and in network encryption using TLS and certificatesEnvironment:SQL 2012/2014/2016/2017/2019, PowerShell, Telegraf, Influxdb, Grafana, Solarwinds, Redgate sql toolbelt, Windows Server 2016, 2019, 2022, DockerAchievements:• Implemented performance data collection by using open source components such as Telegraf, influxdb and Grafana.• Fully automated SQL Builds using Jenkins Job pipelines, from setting up the required gmsa accounts, expanding drives, installing sql server, setting up maintenance plans, disabling sa, enabling IFO, etc. with a single click of a button• Created Kraken – A Powershell Module I developed and available in the PowerShell Gallery which collects useful sql server metadata for auditing and reporting purposes https://github.com/danielberber/Kraken

Houston, Texas Area

Member of the Big Data and Analytics Team providing SQL Server and Hadoop engineeringwork for Hewlett Packard Enterprise.Responsibilities:Install and Configure Elasticsearch clusters and KibanaProvide support and execute MTPs for Elasticsearch clustersSupport, maintenance and installation of Hortonworks Hadoop environmentsSME for SQL Server and escalation point for Production issuesSME for System Center Operations Manager, which monitors more than 10Kproduction databases and 12k non-production environmentCertify new versions of SQL server ensuring proper integration with our backupsolution (Data Protector), our monitoring tool (SCOM) and HPE HardwareWork in collaboration with Windows/Linux and Storage Engineering Teams in go-forward HA solutionsHost Big Data and Database Town Hall meetings for the rest of the organizationEnvironment: Windows 2008-2016, SQL Server 2008-2016, SCOM 2012-2016,AppsManager, Hortonworks HDP, Elasticsearch 2.3-2.5, Kibana, MongoDB, CassandraDatastaxAchievements:Deployed a new SQL Server Smart Index/Statistics Maintenance Solution acrossall production and non-production environments to take full advantage of thenew versions of SQL serverParticipated in the early adopters program for SQL Server on Linux and currentlyworking to add this to our portfolio of available optionsPOC for running SQL Server on Linux in DockerCreated a bot using Hubot as part of DevOps effort to help us do repetitive tasks

Houston, Texas Area

Member of the Engineering team in charge of SQL Server, MongoDB and Cassandra andmonitoring tools including System Center Operations Manager and Applications Manager.Also part of the big data team working with Hadoop Hortonworks.Responsibilities:Define standards and best practices across all HPE IT for SQL server, MongoDBand CassandraDefine the roadmap for the aforementioned DB technologies and monitoringsolutions for FY15-FY17 in all HPE ITCertify new versions of SQL server ensuring proper integration with our backupsolution (Data Protector), our monitoring tool (SCOM) and HPE HardwareWork in collaboration with Windows/Linux and Storage Engineering Teams in go-forward HA solutionsSME for SQL Server and escalation point for Production issuesSME for System Center Operations Manager, which monitors more than 10Kproduction databases and 12k non-production environmentAutomation of SQL Server builds with PowerShellPerform proofs of concept for new technologiesHost Database Town Hall meetings for the rest of the organizationEnvironment: Windows 2008/2012 R2, SQL Server 2008/2016, SCOM 2007/2012,AppsManager, Hortonworks HDP, MongoDB, Cassandra DatastaxAchievements:Certified SQL Server 2014 & SQL Server 2016 to be used across all HPE IT inclustered and non-clustered environments including FCI and Always ON AGsDeployed a new environment for System Center Operations Manager andApplications Manager for Hewlett-Packard (monitoring tools) as part of theseparation of HPE/HPICreated documentation for moving SQL Server environments into new networkcompartments and domainsFully automated SQL Server builds for physical and cloud environments usingPowerShell script including post steps to meet our standard requirementsCertified a new Site to Site solution using Microsoft Multi-subnet clusters with3PAR replication, moving away from using VERITAS clustering software and savingmoney for the company

Houston, Texas Area

Operations Team Responsibilities:Primary DBA for more than 150 Servers including Mission Critical and EntityEssential SQL Server DatabasesOperational support for all Production and Non-Production environments in a 24 x 7 modelTroubleshoot and solve performance issues during Major Incident callsMaintain 99.999% Availability in our Production InstancesResolve pro-active System Center Operations Manager (SCOM) alerts and resolveIncident ticketsExecute Emergency changes in PRO Environment following ITIL RFC proceduresTroubleshooting and performance tuning using DMV’s, performance countersand Extended EventsSupported Site to Site Environments using VERITAS clustering, FailoverCluster Instances, as well as Always ON AG EnvironmentsInnovation Team Responsibilities:DBA consultant for the top 10 Mission Critical Applications in HPMigrations from SQL 2005 to SQL 2008 and SQL 2012 across Data CentersPlanning and execution of changes in Production and Non-productionenvironmentsPerformance tuning and design changes recommendationsAssisted in complete life cycle including from Development to ProductionNoSQLInstalled multiple 3 node MongoDB replica clusters and provided support asneededProvided support to our single Cassandra 9 node clusterEnvironment: Windows 2003/2008/2012 R2, SQL Server 2005/2012, SCOM 2007/2012,AppsManager, MongoDB, Cassandra DatastaxAchievements:Received a CIO Award for participating in the PCI DSS Database compliance effortDesigned and implemented a tool for pulling login data across all of our SQLServer environments for login expiration reporting and conversion to criticalservice accountsContributed with teaching material for the HP University internal websiteEstablish and delivered the first NoSQL Big data development training classes inHP ITTuned Autonomy Qfinity database which improved the performanceby 30x times. Autonomy included the fix to HP Software Qfnitiy new release toimprove HP Customers experience

Guadalajara Area, Mexico

Part of the NOC (Network Operation Center) providing support to external customersincluding some of the largest pharmaceutical companies in the US.Responsibilities:Install & maintain SQL Server 2000-2008R2 Instances, providing productionSupport 24/7 for more than 150 servers.Installing & configuring Reporting ServicesCreate database maintenance plans for SQL Server including Database integritychecks, updating statistics and re-indexingSet up log shipping and mirroring in production databasesInvolved in migration from SQL 2005 to 2005 and 2008Create databases and assign permissions to principals as per the application teamrequestRestore databases to different environments as per requirementsApply Service Packs and Hot-Fixes to SQL InstancesCreate & manage databases and apply best practicesParticipating in Problem Management to find root cause to class issuesEnvironment: Windows 2000-2008R2, SQL Server 2000-2008R2Achievements:Automated multiple NOC Senior management metric reports using SSRSTuned multiple production databases by doing Index Analysis recommendationfor several external customers

Guadalajara Area, Mexico