Andrew Warren Email & Phone Number

Raleigh, Nc

Work with clients to provide secure and stable networksSupport local network and software applications to perform business solutionsMaintain online presence and support web applications Maintain email accounts

Apex, Nc

4th Degree Black Belt and Level 2 Certified ATA instructor Training students of all ages in taekwondo, building good habits, discipline and other life skills

Raleigh, Nc

Lead Scrum team as Scrum MasterWork with Product Owner to set time lines and prioritize backlog for Scrum teamWrite stories to be consumed by various Scrum teamsDocument Mongo backup strategy for all production and internal instances and setup monitoring and alertsComplete Senior Database Administrator duties as well.

Raleigh, Nc

Responsible for all aspects of SQL Server database administration including hardware and software for multiple products in Peoplefluent suite of products Maintain and troubleshoot a variety of physical, virtual and clustered SQL servers Maintain and troubleshoot a variety of data models in both single and multi tenant data structuresSome experience with MongoDB (basic select and find data operations for our integrations team)Perform structured testing of database schema design changesTroubleshoot application database access issuesDevelop, maintain and troubleshoot backup and recovery solutionsDevelop, maintain and troubleshoot security solutions Server capacity planning, performance and tuningUpgrade SQL Server versions from 2008 and 2008 R2 to 2014Implement new instances of SQL server for DR solution in AWSSetup new Log shipping instances to be used by developers for defect resolutionDevelop new methods and automate processes using PowerShell Enhance the release process from an outdated bat file process to a more robust PowerShell solution for production and internal environmentsUtilize Windows Task Scheduler combined with PowerShell to automate the release to internal environmentsResearch and evaluate new tools and techniquesAdhere to change management policies and proceduresDesign, code, test and implement custom database scripts and stored proceduresInteract with Development, engineering and Implementation team members to support various projectsDevelop, revise and implement policies, standards, procedures and guidelines necessary to effectively administer the database environment following the SQL Server database administration best practicesWork as a member of a Scrum team to develop new database solutions for our core product and BI reporting solutionAct as a senior resource to Database Administrators and to other teams

Sanford, Nc

Managed a group of .NET and Web Application programmers and their projects. Maintained the timelines for the projects, making sure deadlines were met and kept project stakeholders informed on the status of their projects. Managed all SQL DatabasesManaged any projects that require data design and data manipulation. Ensured the company had a well implemented backup strategy for all Microsoft SQL databasesDeveloped and maintained executive management reporting Developed SQL queries and jobs using DTS/SSIS/SQL Agent to move data from other databases and work to centralize data storageCreated a large reporting database used to combine 4 different iSeries data environments into one SQL DB to make reporting easier

Managed the corporate help desk by supervising and evaluating employees and interviewing prospective candidatesDesigned and implemented the imaging system using MS SQL Server and Eastman Imaging and Workflow softwareMaintained and supported corporate web sites Designed intranet sites and web applications to accomplish internal tasks like LAN Administration and Service RequestsUsed ASP technology to perform database transactions for dynamic web pagesDesigned and built the Professional Insurance Corporation and Pennsylvania Life WebsitesDesigned and maintained access to the corporate data warehouseDesigned and maintained the corporate data model for the data warehouseSupported and maintained hardware and software used by the data warehouse and the Solomon financial system

Maintained user access in a NetWare 4.1 and NT 4.0 EnvironmentMaintained LAN in all field offices including hardware and end user support over the phoneWorked as a team member of the help desk to solve hardware and software problems

Maintained shedule with employees and end users to install computer hardware and softwareMet with department liaisons to determine schedule for deploying computer hardware and softwareMaintaned and tracked purchases made for department liaisons for 10 departmentsTroubleshooting and building computers for deployment and post deployment

Built and assembled computers to be installed and replace terminalsTroubleshoot hardware and software issues Worked with various teams to organize and complete move/add/change requests

Associate Of Science (As), Computer Engineering Technology/Technician

General Studies

Aviation/Airway Management And Operations And General Studies

High School Diploma

Education record