Gary Nixon Email & Phone Number

Austin, Texas, United States

• Recruited to provide server and database support, including installation, patching, upgrading and maintenance for over 250 database servers and 1,500 databases.• Implement and maintain encryption using TDE and SSL.• Perform database maintenance such as indexing, statistics, backup and restore, performance also developed and deployed reporting solutions using SSIS.• Administer user access in accordance with policy and procedures and implemented changes to data as requested by internal customers.• Collaborate with developers, project teams and business sponsors to address their needs.• Write and implemented stored procedures, functions and triggers as required to meet job specifications.• Manage installation and configuration of all components of SQL Server, SSIS, SSRS and SSAS in the support of the enterprise data warehouse.

Austin, Tx

• Serve as a technical liaison to internal customers which includes maintaining the reporting system for a nationwide timekeeping system and serving as a solutions developer for a multi-tenet healthcare data warehouse.• Provide support to other ETL developers on architecture standards/processes and am frequently called upon to provide solutions or be a liaison to other teams or internal customer for potential problems • Significant participant in ‘hackathon’ by leading team to define process flows for development tools. • In charge of architecting and developing ETL processes.• Worked in conjunction with Google to implement and test GSUtil, GCS and GCP when moving from Microsoft products. • Build tools to better assist customers and co-workers that are not technical also test new technology for internal use. • Execute changes to applications requested by internal customers.• Write PowerShell scripts and SSIS packages and develop Streamsets pipelines to transfer data from source location to data lake.• Recognized for successfully leading, mentoring, and managing large teams and delivering projects on time.• Frequently called upon to serve as a liaison between the team and internal customers to resolve issues.• Use Scrum Agile Methodology (Daily Scrum Meetings, Planning Poker, Sprint Backlog, 1on1 meetings).

Austin, Tx

• Recruited to provide server and database support, including installation, patching, upgrading and maintenance for over 153 database servers and 1,500 databases.• Implemented and maintained encryption using TDE and SSL.• Performed database maintenance such as indexing, statistics, backup and restore, performance also developed and deployed reporting solutions using SSIS.• Administered user access in accordance with policy and procedures and implemented changes to data as requested by internal customers.• Collaborated with developers, project teams and business sponsors to address their needs.• Wrote and implemented stored procedures, functions and triggers as required to meet job specifications.• Managed installation and configuration of all components of SQL Server, SSIS, SSRS and SSAS in the support of the enterprise data warehouse.

Austin, Tx

• Analyzed, designed, created, implemented, maintained, and queried various SQL databases and servers to support police departments, sheriff’s departments, and prisons, both domestic and international.• Worked closely with customer support and developers to support day to day application development activities.• Performed troubleshooting complex queries and server performance issues also executed deployments of new releases• Performed backup and restore, disaster recovery, and replication.• Administered database user accounts, created, modified, deactivated user accounts also assigned and monitored access rights.• Completed data conversion for police departments, sheriff’s departments, and prisons throughout the US.• Implemented translation for mapping, scrubbing, and consolidating data.• Updated data conversion tools and evaluated new technology to assist with more efficient, higher quality migration projects.• Customer facing support for police departments, sheriff’s departments, and prisons, both domestic and international, traveling as needed to provide this support.

Animosa, Ia

• Capture business requirements, identify functional issues, and create detailed technical specifications to successfully complete projects using ASP, HTML, VB, VB Script, Visual Interdev, Controller +, SQL and Access.• Developed and maintained multiple websites, web servers and SQL servers including http://www.jpcycles.com.• Designed, developed and maintained various complex databases as well as SQL servers.• Accomplishments included: Effectively increased website sales by $7M in the first year alone.• Designed and created reports for the multi-faceted internal departments including various online reports written in ASP connecting to a SQL Server 7.0 database.Conducted analysis, assessed technical capabilities, and allocating resources to optimize websites, servers, databases and applications.• Rapidly adjusted to changing priorities while effectively managing deadlines.

Cedar Rapids, Ia

• Designed, implemented, customized and maintained windows servers, desktops, file servers, print server and DNS.• Reconfigured and supported 60 user networks with Windows servers, Exchange server, SharePoint server and SQL server.• Responsible for configuring and troubleshooting routers, switches, hubs and firewalls.• Responsible for system configuration, installation of hardware, operating systems and software applications.• Monitored, troubleshot network as well as resolved security issues.• Responsible for data backup and data recovery.• Ability to perform quick diagnosis and analyze system and network problems.

Phoenix, Arizona Area

• Oversaw a staff of 6 responsible for completing projects and deliverables using ASP, HTML, VB Script, SQL or MS Access from conceptualization to implementation.• Designed and documented software and hardware projects. Developed and maintained SQL database system. • Developed innovative methods for using the Web to benefit client companies.• Prepared bids and negotiated contracts for website development and networking installations and upgrades.• Supported, installed, configured and / or maintained switches, routers, hubs, multi-processor servers, tape back-ups, CD duplicators, RAID servers, SCSI interfaces, routers, Portmasters, CSU/DSUs, Ethernet, and Twisted Pair CAT 3 & 5 cabling.• Implemented hardware and software upgrades and modifications for in-house users and clientele. • Designed, built, installed and configured servers and workstations.