GUNNAR SÖDERLIND

321-***-**** – acx8v4@r.postjobfree.com

SUMMARY:

20+ years of experience in data architecture, software development, IT project management and business development. Primarily focused on leadership in cutting edge development techniques and strategies utilizing web-based platforms that are data-driven using dynamic data and graphical content.

PROFESSIONAL EXPERIENCE:

Deloitte - Senior DBA/Data Architect/Linux/VM/Production Support – Lake Mary, FL

Oct 2016 – Present:

Working as a senior DBA creating/configuring databases in the following environments Windows Server 2012 Linux/Ubuntu, Linux Red Hat/Centos 6.5/7, Linux/Suse, SQL Server, MySQL 5.7, MongoDB (NoSQL) 3+

Develop procedures for production systems to install and configure SQL Server using Clustered Windows Server and Master/Slave High Availability

Administer Mongo DB 3.2. Establish production turnover procedures.

Install, setup, backup and administrate MySQL 5.7

World Fuel Service (WFS) Senior DBA(NoSQL) /Data Architect/Linux/AWS/Production Support – Miami, FL

Jan 2016 – Sept 2016:

Working as a senior DBA creating/configuring databases in the following environments: AWS/Linux/Ubuntu, Linux RedHat 6.4/6.5, Linux/Suse, MySQL 5.7, MongoDB (NoSQL) 3+

In addition, administering Linux and Windows servers using AWS. 90% of servers are virtual, 10% Physical

Convert existing system from Physical servers to AWS. The system is Python/Java/MongoDB

Deploy Mongo DB (NoSQL) Ops Manager in a HA environment (This was a complete start to finish installation)

oThis involved building load balanced web servers and clustered MongoDB servers

oInstalling Mongo Ops Manager in web servers (using AWS Linux)

oSetting up the application Database servers for DEV/QA/Prod

oDocument the entire installation process and trained other staff in the process

Develop scripts as needed for conversion process

Install and setup MySQL 5.7 servers using AWS RDS.

Develop new continuous deployment scripts using Bamboo and Ansible

Develop Docker containers for deploying distributed software applications in minutes

State of Florida Senior DBA/Data Architect/Production Support/Developer – Tallahassee, FL

Jan 2016 – Present: (Note: this is an off-hours 5-10 hours/week project)

Working as a senior DBA maintaining existing SQL Server databases. Ensuring daily backups and log files are running correctly. Adding spaces as needed. Environment: Windows Server 2012, SQL Server 2012

Write T-SQL stored procedures that report on various information in the databases according to specs provided by the client. Each report runs on a daily or monthly basis. The stored procedures each create a result set that is then reported on using SSRS reporting. The reports are then automatically emailed to a list of recipients.

The data accumulation is significant so the data is archived by running purge queries that are run on a monthly basis. Data is backed up and archived. Then the purge process clears the previous 30-day reporting period. Indices are re-built and other maintenance processes are run.

Community Health Systems (CHS) Senior DBA/Data Architect/Linux/Web Developer/Production Support and Windows Server Admin – Naples, FL July 2013 – Dec 2015:

Working as a senior DBA creating/configuring databases in the following environments: Linux RedHat 6.4/6.5, Linux/Suse, MySQL 5.6, MongoDB (NoSQL), MS SQL Server 2005, 8 and 12, Oracle 10g and DB2 9.x and 10.x.

In addition, administering Linux and Windows servers using VMWare. 90% of servers are virtual, 10% Physical

Supporting Mission critical applications. Lives depend on these systems as the hospitals are completely dependent on automation for patient care.

Provide data architecture support for various projects as requested. Primary tool is Business Objects using the Business Intelligence methodology.

Configure monitoring software (New Relic, Solar Winds and Nimbus) and coded custom java scripts for specific service monitoring

Technical Team lead – Mentor and train 3-7 DBA/Linux admins in all aspects of technical DBA/Linux/VM work.

Provide 24/7 support – All of the most challenging problems are handled by the DBA Team.

Create .net and Java (ETL) programs as requested for new applications

Develop .net applications as requested

PROJECTS at CHS

Project Description – Team Lead/Mentor - Senior DBA/Web Developer/Linux/Windows Administrator/Java Developer/Production Support

Working as a senior DBA (Team Lead – Group of 5 DBAs/Linux Admins) configure complex databases in SQL Server (2005,2008, 2012), MySQL, DB2 and Mongo DB. Install/configure monitoring software, configure and monitor DB backups. In addition, monitor SQL Server for replication and log-shipping jobs. Install/configure/monitor MS SQL Server/MySQL/DB2 and MongoDB (NoSQL) as needed.

Establish Mongo DB Hot backup restore procedures for production environment.

Developed a .NET application that creates SAML and sends a transaction to the Vendor for processing. Developed with Visual Studio 2013. The process uses CGI to send data to the client web site. This was one of the most critical systems implemented at CHS as patient health education is prepared and generated by this system.

Provide support to the Business Objects team. Evaluate queries, design server configuration and migration processes, monitor performance and correct inefficiencies.

MySQL DBA work consists of installation, monitoring, and upgrades. Set of Master/Master and Master/Slave configurations for HA patient HIPAA record logging. Number of MySQL servers manage is 20.

SQL Server DBA work in design/build servers in VM. Install SQL Server 2008/2012. Configure AlwaysOn High Availability Groups. Maintain all SQL Servers for space/data integrity.

DB2-Manage DB2 servers. Monitor backup, update security, restore databases as needed.

Create new servers for test/production for DB2. Set up new instances of DB2 and configure security.

Data Center Move- Role: DBA/Admin Team Lead for databases and Linux servers – in 2014 moved about 2000 servers from Naples Data Center to an Atlanta based DC. Key role was in identifying server owners, prepping servers for move, building new servers in new data center, scheduling migration, testing, and final push to move all servers through automated scripts. Note: Team consisted of 7 DBA’s and Linux Admins.

Develop a Java plugin with Eclipse for server monitoring. The plugin sends metrics to NewRelic with databases status of various processes.

Develop a Java program (ETL) that processes CCDA (xml files) and injects the data into the Pulse system (AS400) via a stored procedure. This is an ETL process to Extract data from the XML files and Transform it into a useable format for Loading into the AS400 system.

Technical Skills used – VM Ware – vSphere Client/Linux RedHat 6.4 6.5/ MySQL/Linux Suse/Windows Server 2008, 2012 R2/Putty/WinSCP/Java/Eclipse/SQL Server 2008 and 2012/MongoDB/DB2.

Communication Skills – Provide weekly/monthly reports as required to management on teams progress.

Project Management – This project is managed using the Agile Methodology.

General Dynamics Senior Consultant – Patuxent River, MD Dec 2012 – June 2013:

Working as a senior consultant – Web Developer/DBA.

The project work is done on the Patuxent River Naval Base. A security clearance is required to perform this job. The end user is the Navy.

PROJECTS at General Dynamics

Project Description – Technical Lead/Web Developer/DBA

Working as a senior developer on a CF/Oracle project to create a new Airworthiness application for General Dynamics with the tool being created for the US Navy. Project involves design/development using ColdFusion and Oracle with Coldbox (MVC) as the system architecture. Database design using TOAD for Oracle to interface with the database. Security clearance required. The project is replacing a cumbersome Fusebox legacy airworthiness system with an easier to maintain system using Coldbox/Oracle. All of the interfaces use CGI to communicate variables with the backend database.

Provide DBA (Oracle) support as requested by development team

Technical Skills used – Cold Fusion 9 &10, Coldbox, Fusebox, Windows Server 2008R2, Dreamweaver, Eclipse, DOM, DHTML, JavaScript, JQuery, Oracle, Starteam (version control) PL/SQL, CGI

Project Management – This project is managed using the Agile Methodology.

Kroger Senior Consultant – Cincinnati, OH August 2012 – November 2012:

Working as a senior consultant, project lead and web developer/DBA/Production Support.

PROJECTS at Kroger

Project Description – Technical Team Lead/Developer

Leading a team of two CF developers. Tracking progress, coaching and mentoring the team. Design screen UI and develop screen specifications.

Leading and mentoring team members by assigning tasks and coding challenging screen code. Coding modules as needed for example coded a Perl script to load data for new reports. Write T-SQL for Database conversion.

Project Description – Developer /MS Access to CF conversion

Working with a team of developers to convert 20 MS Access applications to CF 9. The conversion involves converting data to remove sensitive data.

Designing UI screens and program functionality based on current client standards. The project is being developed using Framework 1. Write T-SQL to establish new database from MS Access. Build a complete new database from scratch

Project Description – Developer/Lotus Notes to CF conversion

Leading with a team of developers to convert 2 Lotus Notes applications to CF 9. Process involves data analysis, UI screen design and development. Task creation, project reporting and monitoring.

Technical Skills used – Cold Fusion 9 &10, Framework 1, Fusebox, Windows Server 2008R2, Eclipse, DOM, DHTML, JavaScript, JQuery, Perl, SQL Server 2005/2008RS, Subversion(SVN), T-SQL, SSIS packages

Project Management – This project was managed using the Agile Methodology.

Northgate/Arinso Senior Consultant/ Developer – Jacksonville, FL June 2012 – August 2012:

Working as a senior middleware consultant and web developer.

PROJECTS at Northgate/Arinso

Project Description

Working as a middleware consultant converting an existing web site from ColdFusion 6 to 9/10 and moving it to new servers. Standup new VM servers in a Dev/QA/UAT/Production environment. Establish new production move procedures using Perforce for code management. Install CF on multiple servers creating multiple instances/clusters per server to load balance each server. Regression test all software and fix any issues with upgrading site to CF9/10. Site initially created using CF9 then upgraded to CF10.

Configure VM servers using CF9/10 and SQL Server 2008R2. Install new web files and configure the site to use the Vurv job application management tool. The initial project was to setup a proof of concept on development servers. Stabilize the configuration and document the process.

Then advance the project through to production servers. The project is developed using Eclipse with ColdFusion builder as the development tool.

Technical Skills used – Cold Fusion 6, 9 &10, Windows Server 2008R2, Eclipse, DOM, DHTML, JavaScript, JQuery, SQL Server 2005/2008RS, Perforce (Version Control), T-SQL

Project Management – This project was managed using the Agile Methodology.

Capgemini Senior Technical Lead/ Developer – Phoenix, AZ January 2012 – May 2012:

Working as a senior Technical Lead/DBA/Production Support and web developer for Capgemini.

PROJECTS at Discover Financial Network

Project Description

Working in a technical lead and development role for the Discover Financial Network managing a team of 5 off-shore developers. Providing daily direction to team and troubleshooting daily issues with batch and online applications. Also providing technical assistance to team to develop UI screens and helping with processes that are moving too slowly.

Technical Manager and Web developer using ColdFusion, Perl and JavaScript interacting with MySQL 5 and Teradata databases. Manage daily Ad-hoc requests for problems and fixes with existing intranet sites. Supporting 167 various online and batch systems. Researching production issues that utilize Model Glue Framework. The project is developed using Dreamweaver as the development tool.

MySQL – DBA/Manage tables and apply changes as needed. Repair crashed tables and design/review/analyze queries for development team. Perform code reviews for all SQL access to the MySQL database.

Technical Skills used – ColdFusion 7-9, Linux/Unix/Apache, MySQL 5, DOM, DHTML, Dreamweaver CS5, JavaScript, JQuery, MVC Framework, Perl, Teradata.

Florida State Senate June 2011 – December 2011:

Senior Contract Software Developer/DBA/Production Support – Tallahassee, FL

Work on various projects as they relate to the Florida State Senate Web site. Fix bugs and develop new processes on the current site using ColdFusion and SQL Server using the MVC architecture. Create new processes for web access using Mongo DB

PROJECTS at The Florida State Senate

Senate Web Development

Project Description

Fix and develop changes to the Senate web site as needed. Utilize CGI variables as needed to communicate screen to screen variables and generate reports with backend applications.

Developer programming using ColdFusion 9, .NET and SQL Server or Mongo DB to update the Senate web site. Design and develop numerous changes to the Senate web site.

Track results of various web pages for statistical analysis using BI Tools. Extensive updates using JQuery, ColdFusion, and JavaScript using MVC Framework. The project is developed using Dreamweaver as the development tool.

Technical Skills used – AJAX, Cold Fusion 9, DHTML, DOM, .NET 3.5, Dreamweaver CS5, JavaScript, JQuery, JSON, Mongo DB, MVC Framework, SQL Server 2008, XML, CGI.

Mongo DB

Project Description

Develop a strategy for implementing Mongo DB (NoSQL) into the current architecture. Develop standards and procedures and create a proof of concept for using Mongo DB specifically create test queries and build a database for use in displaying Senate Bills online.

Develop programming technique using ColdFusion 9 and Mongo DB (NoSQL).

Create a API for easy data access

Create proof of concept modules to demonstrate the ability to access data on Mongo DB for display on the Florida Senate web site.

Technical Skills used – Cold Fusion 9, .net 3.5, SQL Server 2008, Dreamweaver CS5, JavaScript, Mongo DB (NoSQL)

Senior Software Developer/DBA

Green Courte Partners March 2008 – June 2011

(3 years 3 months)

Technology: Cold Fusion 9, .net 3.5, SQL Server 2008, Dreamweaver CS5, JavaScript, Flash, Flex, ActionScript, Photoshop, Illustrator, Firebug, Pearl;

Developer all programming using .net and SQL Server to create the system Create a secure login system for GCP staff and investors Designed the database tables and elements using SQL Server Created record-level and field-level security so investors and GCP staff have access to only the data elements they can view/change.

Create a tracking mechanism for SEC compliance to insure no documents can be changed once they have been created and with a secure storage scheme to prevent un-authorized access. Created an email/communication mechanism so that communications to investors are stored and accessible to the investor and GCP. Monitor all changes and record history of activity on the web site.

Created a property tracking system using .net and SQL Server to manage all GCP properties/owners and contacts. The system also had prospective properties and clients. The system allowed downloading information to excel, modification in excel and then re-load to SQL Server showing all updates and confirming processing.

Independent Contract Projects as Senior Web Developer/DBA

Various Clients January 2003 – Current

(12 years 6 months)

Technology: Cold Fusion version 7-10 -Databases SQL Server, MS Access, ASP, JavaScript, HTML

Design Data driven web sites and applications. All sites require complete databases design and development as well as front end design and development. Also provide support for these clients and others on a contract basis as needed. This is for some clients that just need assistance on an on-going basis.

Example: For Grupo Dico Build a complete project tracking system using ASP/JavaScript and SQL Server to manage projects for them. The system was bi-lingual so it was available in English and Spanish.

Some of the Sites Created:

Lake Forest, IL Chamber of Commerce

Grupo Dico

Sage Grill - Restaurant

My Doctor and Me

Ad Ease

Manager/Senior Web Developer/Senior DBA

Jacobs Interactive February 2000 – December 2002

(2 years 10 months)

Created standards and procedures to be followed. Assigned staff to projects and managed all things related to the designed and development of the web sites. All of the sites where built from scratch in house. Some outside staff were also brought in and managed.

Manage servers and software upgrades. Order new hardware as needed and work with vendors to design new hosting strategies as more sites go online and traffic increases.

Create load-balancing strategies using a Local Director Load balancer. Conducted performance reviews for team members. Technology used at Jacobs Interactive: Cold Fusion 3-MX, SQL Server 2000, ASP, MS Access 2000, Dreamweaver, JavaScript, HTML, DHTML, SDLC, ETL, Flash, Photoshop, Visual Basic;

TECHNICAL BACKGROUND:

Applications: Incentives, Insurance, Inventory, Billing, Marketing, Technical Support, Retail, Mining, Data Architecture, Payroll, Health Care

Hardware: IBM Mainframe, IBM PC, Unix, and Macintosh

Software: ASP, Assembler, Basic, Clists, C++, COBOL, COBOL II, Cold Fusion, Dialog Tag Language (DTL), Dialog Manager, Excel Macro script, JavaScript, HTML, REXX, Perl, Visual Basic

Database Management Systems: SQL Server, Mongo DB, MS Access, MySQL, Oracle, DB2, IMS DB/DC, FileMaker Pro, and Teradata

SOFTWARE DEVELOPMENT TOOLS:

Adobe CS6 (Photoshop, Illustrator, Bridge, Dreamweaver, Flash, Fireworks, Contribute), JAVA Applets, Visual Source Safe, Abend-Aid, Aldus Persuasion, APS Entrycheck, BTS, Data, Cold Fusion Studio, Dreamweaver, Dictionary, DataVantage, DataXpert, Endevor, Eztrieve, MS Excel, Excel Macros, FTP, Host On Demand, JAVA Applets, JavaScript, JCL, IEF, IIS, IMSXpert, ISPF, Librarian, MacDraw Pro, MFS, Paint Shop Pro, Panvalet, PDSMAN, Photoshop, Platinum, PowerBuilder, QuickBooks, QMF, ResQNet, SAS, SDF II, Spectra, SQL, SQLyog, Subversion, SyncSort, TELON, TMS, TSO, Tug, Visual Basic, MS Word, Xbug, Unix Command level, Xpediter

EDUCATION:

Brown Institute – Computer Programming

Lakewood Community College – Liberal Arts

University of Minnesota – Liberal Arts

SEMINARS:

Macromedia Developers seminars (Flash, Studio MX) 2002

Macromedia Developers conference (Cold Fusion) 2000-2001

PowerBuilder Training 1995

DB2, 1991

IMS Physical and Logical (IBM training), 1983, 1984

SAS, 1983, 1986

Telon, 1986, 1987

Xpediter, 1983, 1987

Contact this candidate