Sql Server Ms
Resume:
Robert C. Hendricks
Raleigh, North Carolina 27615
Mobile 201-***-****
***********@***.***
SUMMARY
Twenty nine years of diverse work experience in Information Technology. Highly motivated, dependable, well organized senior database administrator with strong verbal, written communication skills, analytical and interpersonal skills.
Technical Skills SYBASE DBA (25+ years), MS SQL DBA (15+ years), Oracle DBA (5 years)
DBMS Sybase DB server version 4.9 to 15.7, Sybase Replication, IQ, MS SQL SQL2000, SQL2005, SQL2008, SQL2012, SQL2014, SQL2016, Oracle 8i, 9i,10g, 11, 12
PROFESSIONAL EXPERIENCE
Ingram Content Group. Jackson, Tennessee (Remote) March 2016 – October 2016
Senior Sybase Database Administrator
Senior Sybase/MS Sql server DBA consultant supporting Ingram Content Group is a United States-based service provider to the book publishing industry based in Jackson, Tennessee. They have the industry's largest active book inventory with access to 7.5 million titles. The markets they serve include booksellers, librarians, educators and specialty retailers. Ingram employs approximately 3,000 people worldwide. I was supporting Ingram Industries publishing company as a consultant concentrating on Perseus project work supporting the business. I documented their entire maintenance cycle and found where maintenance jobs were not working. These were corrected. Recommended running index statistics jobs for better performance on large heavily used tables along with organizing their DBA maintenance cycle. I also implemented configuration changes (increase Sybase memory, and lowering some of the other configuration values that were wasting memory, created separate . Implemented security standards. Managed database replication. Monitored Sybase error logs to ensure there were no issues that needed to be investigating.
IBM (CDI-Corporation) Raleigh, North Carolina. (Remote January 2015 – September 2015
Senior Sybase Database Administrator
IBM consultant Sybase/MS Sql server DBA supporting PHH Mortgage Corporation as an IBM Consultant concentrating on RFS project work pertaining to disentanglement separation project from former co-partner Element Corporation. Worked on disentangling a project that was bought by another company and transferred data, maintenance jobs and ddl as needed. Maintained database management documentation for the client and alerted customer on was needed to better monitor the system. Supported disaster recovery testing as scheduled monthly. Attended group team meetings to discuss weekend application changes going to production machines. Supported user checkouts and ensured the databases were ready for production Monday morning.
Robert C. Hendricks Page Two
CNH Industrial (Fiat/Chrysler) Racine, Wisconsin (Remote) August 2014 – January 2015
Senior Sybase Database Administrator Sybase/MS Sql server Database Administrator liaison coordinating between the CNH Industrial West Racine Wisconsin application development teams, IBM DBA European offshore team and Sybase (SAP). Supporting two major applications AMAX ( AvailabiltyMax – a parts replacements system for the manufacturing company improving parts availability while maximizing inventory productivity) and D2D (Dealer to Dealer) making parts readily available between depots domestically/globally in a timely manner for daily business continuance. Improved performance of test, dev, product and production servers by implementing daily DBA maintenance cycles and new indexing along with optimizing configuration parameters where needed. Upgraded both servers/applications to Sybase 15.7 on new hardware implementing new SAN storage and also introducing Sybase Partitioning and Sybase Replication.
Allscripts, Raleigh, North Carolina March 2014 – June 2014
Senior MS Sql Server Database Administrator
Troubleshoot and support Allscripts' Professional EHR Software Support clients by remote login into their database server and running multiple SQL scripts in Microsoft SQL Studio 2005/2008 to fix many EHR issues. Troubleshoot Terminal Server application problems for both 2003 and 2008 Windows Server environments. Manage a personal queue of support tickets in Salesforce.com offer superior support with each case offer superior support with each case.
FedEx World Headquarters, Collierville, Tennessee December 2013 – March 2014
Senior Sybase Server Database Administrator
Provide 24x7 technical incident and problem management for FedEx Sybase Database infrastructure for worldwide organization. Weekend defragmentation jobs run to organize 30 million row tables.
.
Credit Suisse, Cary, North Carolina April 2012 – October -2013
Senior Sybase/MS Sql Server Database Administrator
Provide 24x7 technical incident and problem management for Credit Suisse Database infrastructure for business groups and branch offices in the Americas, EMEA and APAC. Resolve issues coming through ITSM GIM system, critical alerts/events escalated from the Global Production Control team's monitoring consoles and instances reported via the hotline.
A two-site team homed in Singapore in Southeast Asia and the Raleigh office at Research Triangle Park in North Carolina, United States.
Robert C. Hendricks Page Three
Barclays Capital, Jersey City, New Jersey February 2010 – June 2010
Senior Sybase Database Administrator
Consultant for IBM DBA Data Center Move project team migrating Sybase, UDB, ORACLE and MS/SQL servers from NYC/Livingston, NJ to Piscataway, NJ. Over 300 + servers involved in the move from legacy Lehman Brothers businesses now currently supported and maintained by Barclays Capital. Successfully migrated Sybase ASE 12.5, Sybase IQ and Sybase Replication servers.
Citi, Warren, New Jersey (formally Salomon Brothers, Salomon Smith Barney) 1982 - 2009
Senior Database Administrator / AVP
Performed full range of Senior Database Administrator responsibilities to support of all aspects of database and SQL server maintenance including server installs/upgrades, database/transaction dumps and loads, Data Center migrations globally, Sybase replication, MS SQL Server and Oracle log shipping and critical error recovery.
Administered as primary DBA support of 200+ database servers including replication server across 3 DBMS’s by providing troubleshooting, performance and tuning when needed resulting in little or no impact to the business of the firm.
Proactive approach taken for end of life db software version’s and necessary VTM’s applied in agreement with Citi compliance policy by software company deadline resulting in 100% success every year.
Coordinated DR testing for all database environments for DBA team globally completing with 100% success for the past seven years.
Ensured any DBA maintenance failures and BMC PATROL alerts were addressed in a timely manner without any production interruption by transitioning all jobs to Autosys and providing 24X7X365 support globally for the group allowing other team members to concentrate on their critical daily work.
Implemented backup optimization project to reduce cost of tape/disk storage by coordinating with application teams to eliminate unneeded database dump files and filesystem backups resulting in 3 million dollar savings for Fixed Income area. Reduced overall storage utilization by 10%.
Created and maintained standards and procedures DBA manual for the team. This
documentation was used in yearly departmental internal audits and as a new employee on-boarding reference guide domestically and internationally.
Remediated 100% of all Major/Minor database server security violations within 30 days of notification.
Created and maintained weekly DBA team accomplishment report summarizing all weekly changes, application releases, upgrades, VTM’s keeping upper management fully informed.
Reduced severity 1 production outages by 15% where root cause was the responsibility of the DBA team by better monitoring (i.e. BMC Patrol alerts, maintenance jobs setup in Autosys, dataserver configuration changes).
Projected and recorded accurate time reporting to ensure accurate application team area chargeback
Robert C. Hendricks Page Four
EDUCATION
Taylor Business Institute
Marlton, New Jersey
1984 -1985
Certification in Computer Programming
Studied Chemistry, Business and Art degrees
Rowan University, Glassboro, New Jersey
Sept 1981 - Dec 1983
Contact this candidate