John Greeson Email & Phone Number

Cary, Nc, Us

Lead 16-member international team responsible for providing platforms used by value aligned DevOps teams to deliver solutions. Platforms include everything from data storage, data streaming, ci/cd, application runtime environments, source control, systems integration, and API management. Work within the team to transition mindset and work habits from traditional application support to true DevOps platform delivery. Work with customers to understand needs and platform usage patterns to identify opportunities for platform enhancement as well as greater platform adoption. Work with team, customers, and leadership to prioritize areas for reduction in our platform portfolio to ensure core services are provided in the most consistent and cost-effective manner.• Lead implementation of new API Management system providing data residency needed to preserve $10 million dollar deal. Coordinated work across five teams to meet an aggressive timeline to deliver a new platform ahead of schedule and under budget.• Led self-help overhaul of platforms (GitHub onboarding, MySQL, Oracle, etc.) which resulted in over 200-man days in savings each year.• Worked with customers reduce the number of platforms needed by 18% resulting in better attention to remaining platforms and saving about $350K in annual savings.

Cary, Nc, Us

Led seven-person international team responsible for the administration and automation of 7 database platforms (SQL Server, Oracle, MySQL, MongoDB, Kafka, ZooKeeper, and Amazon AWS). The team supported over 3,000 line of business and departmental databases data sets supporting over 300 applications. • Led implementation of derivative event processing using Kafka, Oracle, and GoldenGate to allow a large monolithic application to transition towards micro-service architecture without having to take on a full re-write. • Led implementation of new monitor (Zabbix) which enabled team to implement integration with ticket system (ServiceNow) to ensure consistent response for issues experienced by our customers. Also implemented self-healing and issue avoidance processed within the monitor to prevent and heal from common issues avoiding about 18 hours of downtime a year across data platforms.• Led migration of 54 Oracle databases from Exadata to VMs. Leveraged solid state drives to improve performance for customers while simultaneously saving $300K annually in Exadata hardware and support costs.

Cary, Nc, Us

Combined 2 database administration teams supporting SQL Server and Oracle into a single team. With seven team members increased support from those 2 platforms to 5 platforms (SQL Server, Oracle, MySQL, MongoDB, and PostgreSQL). We provided support for over 2,300 line of business and departmental databases across the five platforms. Databases were deployed on virtual, physical and engineered systems (Oracle Exadata). We supported various High-Availability solutions including SQL Server Availability Groups, SQL Server Mirroring, SQL Server Log Shipping, Oracle Data Guard, Galera Clusters, and MongoDB Replica Sets. We developed and integrated tools to provide customer self-help for performance monitoring and tuning, database code deployment, and other customer needs. Created and maintain standardized and customized maintenance processes to ensure integrity, availability, and performance of database systems. Interfaced with developers and system administrators to design cost effective solutions that meet business needs, as well as to rapidly identify and respond to issues.• Managed effort to migrated Oracle databases off of legacy HP UX systems to Exadata resulting in an average of a 438% increasing in query performance across supported systems.• Led rollout of MySQL taking team from zero experience to full support of MySQL and Galera Clusters in less than a year without disrupting existing commitments.

Cary, Nc, Us

Lead Database Administrator responsible for over 70 servers hosting approximately 1,700 databases supporting line-of business applications. Partner with application developers and system administrators to identify and resolve issues in a timely manner. Consult with developers to review database objects and code to increase performance and eliminate errors. Manage highly available SQL Server systems using clustering, replication, mirroring, and Availability Groups. Create and maintain standardized and customized maintenance processes to ensure integrity, availability, and performance of SQL Server data. ITIL Foundation level certified.• Reduced annual operating budget by $90,000 by performing cost benefit analysis showing Software Assurance was not needed• Built database migration utility allowing customers to perform self-service moves saving an average of 8 hours per month• Built web-based performance monitor allowing customers to see performance of their systems in real-time reducing help calls• Serve on cross departmental Architecture Review Board ensuring solutions meet corporate needs while reducing costs• Led effort to provide production class PostgreSQL on Linux support while reducing database spend

Robins Afb, Ga, Us

Managed five member team providing worldwide technical support for computer intrusion investigations. Executed information operations through development and operation of computer network surveillance tools leveraging open source and custom developed Linux based systems used by law enforcement and counter intelligence organizations. Provided direct operational and technical support to counterespionage activities. Served as liaison between Air Force and other federal investigative agencies.• Designed first of its kind Honeypot providing greater functionality while reducing implementation costs by over $10,000• Protected $300,000 equipment investment by identifying critical power and cooling issues in new data center prior to move in• Designed incident data reporting system saving over 1,000 man hours per year by automating data analysis and report generation

Greensboro, Nc, Us

Managed four data acquisition specialists responsible for mapping, transforming, and loading data into standard format from various accounting systems including SAP, Oracle Financials, and JD Edwards. Mentored data acquisition personnel in SQL Server operations and query development by providing them formal training, one-on-one instruction, and hands on assistance. Sole database administrator responsible for over 200 SQL Server 2000 databases, ranging in size from 10 Mb to 1.5Tb, providing administrative and database development support. Performance tuned databases, servers, and network infrastructure to maximize return on hardware investments. Administered XIOTech storage area network providing high speed, redundant disk storage for key databases.• Cleared 3 month backlog in data acquisition in first month by improving both process and training • Replaced cursor based data transformation process with set based operations shortening process from 2 weeks to 3 days• Reworked database backups using SQL Litespeed, allowing for daily backups of all databases, reducing exposure to information loss• Created data import process using Data Junction loading over 10 million invoices into SQL Server, allowing company to turn information hidden in report files into money

Houston, Tx, Us

Lead database administrator responsible for the day-to-day operation of forty-three SQL Server 2000 and seven Oracle 8i databases. Responsible for performance tuning, disaster planning, capacity planning, replication, and monitoring of business critical database systems. Provided data schema design assistance and helped system architects understand design implications on database systems. Design and implement data structures in support of all company data systems including: CRM, billing, operational, and reporting systems.• Optimized customer care database, increased throughput 20%, reduced batch process time by 50%, and improved response time• Built Visual Basic application used to help solve billing problems, saving company $500,000• Develop custom reporting solutions using SQL Server, Oracle, C#, DTS, and XML• Use Data Junction 7.5, Visual Basic, and Oracle to create a repository to store all EDI data used to communicate with trading partners, allowing for analysis and correction of operational systems• Work with project management in gathering business requirements, analyzing data support needs, and producing project documentation including: data flow diagrams, and logical and physical data models

Us

Database administrator and Visual Basic programmer, I was responsible for all databases developed using SQL Server. Lead web developer, responsible for developing systems and training other developers on web techniques. Provided SQL Server administration training to ADC customers migrating to SQL Server from other database platforms.• Developed DTS packages to automate data loads into SQL Server from varied data formats• Developed reporting system using Crystal Reports 8.5 and Active Server Pages, allowing users to retrieve reports from within existing web-based systems• Designed and developed time sheet management system in Active Server Pages and Microsoft Access, allowing ADC to manage billing of employee time more efficiently

Randolph Afb, Tx, Us

Deputy Branch ChiefWork center manager supervising 14-member team comprised of database administrators, programmers, and system administrators responsible for building and operating web-based and client-server systems. Briefed General Officers on status of Air Force assignment and career management initiatives.• As youngest officer in the division, I was recognized as best Company Grade Officer of the Quarter• Led development of web-based Duty Change Request system decreasing response time for customers in the field from 45 to 10 days• Ensured on time delivery of $1,000,000 legislatively mandated Aviation Continuation Pay SystemAssignment Systems Programmer/AnalystAs a project manager and developer, I oversaw nine developers. Designed, developed and deployed web-based and Windows-based systems supporting new Air Force Assignment System. Systems developed using Visual Basic and Cold Fusion with a common SQL Server database.• Migrated all SQL Server 6.5 databases to SQL Server 7.0• Converted process that moves mainframe data to SQL Server from Visual Basic applications to Data Transformation Services in SQL Server, reducing refresh time from 4 days to less than 5 hours

Master Of Business Administration (Mba), Information Security Management

Bachelor Of Science (Bs), Mathematics And Computer Science