Antoine Hernandez Email & Phone Number

Elk Grove, California, Us

Main responsibility is to ensure company success. This includes proper products and/or services offerings, brand development, marketing strategy, and finding advantages that could help the company grow. Secondary responsibility is to utilize knowledge in information technology to deliver needed products and/or services to customers as required. Other responsibilities include ensuring employees have the training they require to do their jobs effectively, finding new business opportunities, and setting long-term strategy for day-to-day operations.

El Dorado Hills, Ca, Us

Initially upgraded most SQL Servers from 2008 R2, 2012, and/or 2014 to SQL Server 2016 in addition to upgrading Windows Servers from 2003, 2008, 2008 R2, and 2012 to 2012 R2 in the first and second quarter of 2017. Standardized the environment with drive locations, backup schedules, and security such as setting SPNs and utilizing Kerberos. Prior to the upgrade, implemented replication to copy data from one server to another for reporting purposes to replace a manual backup and restore process. Fixed problem with backup sizes being too large and also implemented Always On Availability Group to replace the replication once upgrade was complete. In the fourth quarter of 2017, upgraded most of the non-production servers to SQL Server 2017 and started implementation of upgrading Windows Servers to 2016. Introduced the use of SQL Server Data Tools (SSDT) to source control the databases. Standardized on SSDT to source control databases, SSIS, SSRS, and SSAS projects. Upgraded all SSIS projects to SQL Server 2016 project deployment model and standardized storing SSIS packages in the SSISDB Catalog utilizing project parameters when necessary. Other database duties were to help solve performance issues, rewrite queries, help solve database contention issues, and keep servers updated. Also upgraded Team Foundation Server (TFS) from 2010 to 2017 and led the change from the old XAML-based build process to the new build process. Secondary duties were to help other staff with other IT issues that may have popped up.

As a startup, my tasks were to secure funding for equipment and create relationships with industry partners to move freight across the country as needed. Also responsible for day to day operations to ensure on-time freight delivery. Utilizing IT experience to setup various solutions for integration and communication.

Sacramento, California, Us

Main responsibilities were as DBA for SQL Server for the engine, reports, analysis, and integration services. Established new standards in server configuration to enable better security, performance, and management for the SQL Server and Oracle database servers. These new standards also included the use of database schema source control for SQL Server using SQL Server Data Tools (SSDT) and Team Foundation Server (TFS). Used the new standards to help plan and perform the upgrade to SQL Server 2016 and also reconfigure existing servers to utilize new standards, which included creating new service accounts, ensuring Service Principal Names (SPNs) were setup properly, servers were able to send alerts as needed, server memory settings were configured correctly, and servers utilized best practices for security. For TFS, implemented use of more features other than source control such as work item tracking, proper code promotion, and ensuring TFS was updated; this included the plan to upgrade TFS to latest version. For SQL Server Integration Services (SSIS), implemented new standard on how SSIS packages should get created with the use of the new features using project deployment model. Lastly, used new SSIS standards to implement replacement SSIS process for legacy ETL process for database larger than 10TB. Also helped establish Active Directory group policies to enable SQL Server to work properly since some settings were blocked or limited. Other daily tasks included index maintenance, administration for AlwaysOn Availability Groups, general troubleshooting, peer mentoring, end user training, and query tuning.

Denver, Colorado, Us

My main responsibilities were maintenance and tuning of SQL Servers, consisting of SQL Server 2008 or 2008 R2, and upgrading or migrating them to SQL Server 2014. Secondary duties included using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) to move data between servers and to display data, respectively, and also upgrading these to the SQL Server 2014 version. Other tasks included database design, stored procedure development, and troubleshooting. Converted some manual repetitive tasks to automated SSIS processes and set up recurring maintenance tasks also. Three major issues resolved were reconfiguring SQL Server to minimize data contention, which drastically reduced the amount of deadlocks compared to the count when first starting, setting proper limits on server RAM, and lowering the CPU load. Helped implement better security by transitioning to Active Directory service accounts instead of SQL users to eliminate passwords in connection strings while also setting SPNs for accounts that needed them so Kerberos authentication could be used instead of NTLM. One instance utilized a two-node failover cluster, which helped minimize downtime during patching. As the only DBA on staff, I helped with some database questions regarding proper sizing, data types, and best practices. Some of these tasks included proof of concepts with SQL Server 2014 Availability Groups, PostgreSQL replication and high availablity, general server-level analysis and/or troubleshooting.

Elk Grove, California, Us

As the lead DBA, in addition to helping my team members with solving some of their questions with SQL Server Reporting Services (SSRS), SQL Server (SQL), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS), I came up with the plan to upgrade many of the SQL 2005 servers to SQL 2008 and/or SQL 2008 R2 and subsequently to SQL 2012. I also led the installation of Service Packs for all SQL versions. I directed my team on creating and implementing SQL security directives, maintenance plans, different configurations in SSIS, and utilizing source control for using SSRS. To move data between servers, I setup various methods such as using SSIS, replication, or log shipping. As the lead, I was responsible for ensuring any mirroring or clustered databases were working properly and resolving any issues that occurred, especially for performance issues. Upon release of SQL Server Data Tools (SSDT), I implemented it into our toolset to help source control the databases. I have utilized SQL Server Profiler and the Activity Monitor to help find some bottlenecks. As part of a team, I have consulted with developers to optimize database designs and set proper indexes on databases to return data faster with proper tuning. I have also set different isolation settings to help with concurrent read/write locking issues. On some of the bigger databases, I setup table partitions to help with performance. Lastly, I maintained and set security settings and data sources for SSRS deployments.

Troy, Michigan, Us

I used T-SQL to gather information from Microsoft SQL 2000 and 2005 databases, exporting to Microsoft Excel to generate reports, providing help desk support, including, but not limited to, user and application administration for the Imagitek Prodagio AP and Contracts document management system, and monitoring EMC Captiva using InputAccel.Other duties included consolidating data from thirty-three separate Microsoft Access databases into one single database and using Microsoft SQL 2005 reporting services to build web-based business intelligence reports for end users.

Us

I replaced hardware on Dell and IBM computers under warranty. Occasionally I had to contact the manufacturer to inform them their diagnosis was not sufficient and tell them what I found as the problem in order to obtain the correct part. In addition, I had to make sure the newly installed parts fixed the problem described. The position required travel to various locations throughout the day, consisting of both residential and corporate entities.

Blue Bell, Pennsylvania, Us

I replaced hardware on Dell, Gateway, Hewlett-Packard, and Compaq computers under warranty. Occasionally I had to contact the manufacturer to inform them their diagnosis was not sufficient and tell them what I found as the problem in order to obtain the correct replacement part. In addition, I had to make sure the newly installed parts fixed the problem described. The position required travel to various locations throughout the day, consisting of both residential and corporate entities.

Independence, Ohio, Us

I performed computer system reviews to determine what type of upgrades were needed on computers, designed computer service contracts customized to customer needs, and also performed standard computer technician duties, which consisted of diagnosing and repairing computer problems. Additionally, I performed field marketing to promote the business with results leading to computer service work.

I offered computer recommendations based on the client’s need. The recommendations consisted of computer systems, components, networking equipment, software, and upgrades. Furthermore, I performed the installation and configuration of the hardware and/or software for the client. Occasionally, I had to perform full operating system upgrades from older Windows operating systems, for example, Windows 98 or NT, to newer Windows operating systems like Windows 2000 or XP. I kept the client data uncorrupted and usable after the operating system upgrade 100% of the time.

I performed diagnostics, repairs, maintenance, and administration of customer computers and would occasionally diagnose a computer problem over the telephone. Duties also included networking computers with both client/server and peer-to-peer TCP/IP networks, and connection of networked machines to Windows 2000 Active Directories and NT 4 Domains. Some clients had Symantec PC Anywhere installed on their machines, which allowed remote control to look at the configuration of the computer or perform software upgrades. Often, I would visit the site of the client to perform routine maintenance upgrades and software patch installation. Many times, clients needed network installation of computers and printers using the TCP/IP protocol with network hubs or switches. Other times, I would install the hardware and configure any software necessary for the installation of ADSL.

Miami, Florida, Us

I performed diagnostics and repairs to customer Windows 95, Windows 98, Windows ME, Windows NT, and Windows 2000 computers. Occasionally, this duty included in-home visits to resolve customer issues with their computers. I recommended upgrades to customers based on the problems found in diagnosing their computer problem and performed the installation of the upgrades at the customer’s request. I worked thoroughly to ensure that the computer would not return for the same problem.

As owner of the business, my role was to grow the business but as the sole employee, I was also responsible for performing customer services and back office tasks. Main business tasks included mobile computer repair services, virus removal, and custom building computers for clients. Other tasks included selling mobile electronics. Back office tasks included accounting, billing, marketing, and business networking.

I performed diagnostics and repaired customer computers. Every now and then, I would diagnose a problem over the telephone, stepping the customer through some basic diagnostics. Often, I would recommend product upgrades to customers to enhance the performance of their computer. My main responsibility was to maintain all store-owned Windows NT 4.0, DOS, Windows 98, Windows 3.1 Novell Workstations, and Novell 4.11 Servers in addition to Hewlett-Packard LaserJet 5si printers. I was responsible for repair, configuration, administration, and maintenance of the store network and nodes, which connected to a Novell Directory Services network that spread throughout California and some parts of Arizona. Additionally, I was responsible for the store’s transition from a Novell 4.11 server-based network to Windows NT 4.0 server-based network. This consisted of running both servers simultaneously on the network while gradually moving clients to the NT 4.0 server. Lastly, I was responsible for the telephone network in the store.