Robert Mccormick Email & Phone Number

Alpharetta, Ga

Database Administrator 3 • Maintained responsibilities held under Database Administrator 2 position.• Currently participating in Data Center Relocation (McKesson to Change Healthcare) including SQL Server 2008 R2 to SQL Server 2016 Migration. • Consult and provided SQL Server expertise to external departments.• Work as part of a SAFe Agile project team to coordinate database development and determine project scope and limitations.• Train developers SQL Server Integration Services fundamentals.Database Administrator 2 • Develop and maintain SSIS 2012 Data Pumps to facilitate loading and relocation of data across multiple platforms.• Manage Change Control process to facilitate movement of database changes and SSIS packages from development to production.• Developed, maintained, and implemented database standards for database design, administration, security, backup, capacity planning and architecture. • Optimized and performance tuned SQL Queries and stored procedures.• Managed Multiple Database SAN Migration, including VLDBs > 5TB and 8TB.• Upgraded SQL Server 2000 Systems to SQL Server 2008 R2 (clustered environment).• Migrated Data Transformation Services (DTS) Packages to SQL Server Integration Services (SSIS) packages• Develop and maintained complex SSIS 2012, SSIS 2008, and DTS Data Pumps to facilitate loading and transport of data across multiple platforms.• Perform backups, index maintenance, patching, and system administration for multiple VLDB Data Warehouse systems; including SQL Server 6.5 – SQL Server 2016.Programmer Analyst • Resolved data quality issues and debugged loading errors from multiple platforms.• Created, updated and maintained SQL Server stored procedures to aggregate billing and collections data into Business Intelligence reporting.

Dacula, Ga

• Developed database driven umpire scheduling program.• Developed payroll module to simplify process of paying umpires, billing and collecting from clients and cost reporting.• Developed and maintained company website.

• Supported and maintained worldwide HP corporate intranet employee training portal.• Developed stored procedures, functions and views in Oracle 8i PL/SQL.• Developed VBA Applications to update sales reports across NT Network.

Norcross, Ga

• Worked on team to develop a web based Open Enrollment Portal utilizing J2EE for the front end; and wrote SQL Server 7.0 Stored Procedures for data access layer.• Wrote Excel tool to query Silk Radar database (SQL Server 6.5) and graph progress on software bug resolution turnaround.

Dunwoody, Ga

Lead Programmer Analyst - Network Engineering• Reverse engineered obsolete legacy application and created web based tool to dynamically assign IP address to hotels for the Holidex Reservation System.• Migrated Sybase System X database to SQL Server 6.5.• Maintained Stratus Network that routed data between Holidex and numerous airline linksOracle Programmer Analyst• Worked on team to develop Property Management System in ProC and PL/SQL. TPF Programmer Analyst Reservations Development Apr 1994 – Nov 1995• Worked on team to retrofit Property Management System from Holidex to independent hotel reservations system.

Ms, Information Systems

Bs, Information Technology

Graduated Magna Cum Laude