Database Engineer/Database Administrator/Back-end Web Development

Dave Babler Lutz, FL 248-***-**** ********@*******.*** Github LinkedIn

Database Administration & Programming Professional Database Architecture – Requirements Gathering – Database Structures – Database Coding & Support Strategy, Problem Analysis, and Resolutions strengths, founded in the ability to analyze complex needs and offer effective solutions for a variety of situations including server installation and data migrations. Ability to re-engineer and automate manual tasks to create efficiencies as well as integrate disparate systems. Accomplished database administrator, experienced in installing, configuring, and managing data structures and building solutions that meet end-user requirements. Skilled with network monitoring tools and vulnerability remediation. Articulate communicator skilled in delivering insightful presentations, effective trainings, and strengthening relationships with business partners, peers and senior leadership. Technical Strengths

SQL (Advanced) PL/SQL (Intermediate) Linux – bash shell (Beginner) C# (Intermediate) C (Intermediate) VBA – Office (Advanced) Visual Basic (Intermediate) PHP (Intermediate) jQuery/JavaScript (Beginner) Experience

VENTURE CONTROLS INC. Lutz, FL

DBA/CODING SUPPORT PROGRAMMER 2017 to Present

Deliver database design and management support for projects; focus on improving database application performance by monitoring and tuning databases to optimize storage and minimize server processing.

• Perform problem determination, support various data environments, capture connection activity, identify performance degradation, and execute end-to-end process improvement initiatives.

• Implement security checks and perform remediation, audit, reports at the database and operating system level; engineering plug-ins, queries and solutions that allow authorized users to process information more quickly.

• Utilized LINQ queries to process a list of fuzzy match terms vs. email bodies and then sort to the specified folder within a custom MS Outlook VSTO plug-in that I wrote using C#.

• Wrote custom MySQL stored procedures, jQuery & PHP to take an existing OMS web portal and add needed functionality and features for additional types of order submission.

• Used Bootstrap, jQuery, and HTML to manipulate DOM elements for features integration into a newly created order management system portal.

• Created column manipulation programs and macros using VBA to manipulate flat files that could not, or should not, be stored in a proper RDBMS.

• Usage of stored procedures to enhance the native AES_ENCRYPT functionality of MySQL for storing personally identifiable data.

• Created a MYSQL program using stored procedures to create Views with ongoing Rolling data effectively replicating some of Oracle’s native GROUP BY functionality such as GROUP BY GROUPING SETS.

• Devised and implemented a technical solution utilizing a variety of data retrieval tools to access a shared MySQL server through a joint use agreement.

• Created CURL and BASH scripts for point in time FTP file retrieval and manipulation.

• Developed a database using MySQL with the logic entirely written inside the RDBMS using MySQL's stored procedures that processes, and sanitizes data based on specified business rules such as suppression lists, naming conventions and substring fuzzy matching.

• Engineered a program using MySQL's stored procedure functionality to organize and reduplicated tens-of- millions of records by creating a compound-key converting that key to binary and bit shifting it to allow the database to complete its task in seconds.

• Normalized and created ACID compliant RDBMS structures of many different flat file systems. EXTRA SPACE STORAGE Multiple Locations

FACILITY MANAGER 2007 to 2015

STORAGE CONSULTANT 2006 to 2007

Drove the delivery of client services, achieving optimal fill rates of storage units and the utmost customer satisfaction. Directly Accountable for all business operations, included maximizing rentals, revenue and profits for all sites, hiring, training, performance reviews and evaluations, property audits, expense control, employee scheduling, site maintenance, budget management, payroll, AP/AR, and marketing.

• Managed customer inquiries and in-bound calls and assisted customers in front counter for truck/trailer/storage reservations, sales and billing inquiries.

• Documented customer information, including all details regarding space rental agreements and material leasing for local or one-way rentals.

• Rent/move out storage units, conducted daily walk-through of the facility, held collection calls/collected payments, lock customers units for non-payment, make sure units are in good condition, supervised auctions.

• Ensured property maintenance, coordinated vendors to clean storage units that move out and performing moderate to heavy maintenance to the building and grounds. FOOTLOCKER INC. Various Locations, Michigan

STORE MANAGER 2003 to 2005

ASSISTANT STORE MANAGER 2002 to 2003

Coordinated and oversaw the day-to-day operations of the store including employee management, store promotions, ordering, stocking, unloading truck, customer relations, employee relations, and training for the employees.

• Managed all team member activities including hiring, development, coaching and motivating to achieve sales, profit, and customer experience goals.

• Maintained the company's visual merchandise standards for the store, including general housekeeping cleanliness.

• Navigated challenging situations with customers by providing them with information and knowledge, while staying within company guidelines.

• Supported and executed pricing policies on merchandise according to requirements for profitability of store operations.

Early Career

FALCON GROUP, INC. Southfield, MI

OFFICE MANAGER 2001

CATHOLIC FAMILY SERVICES/THE ARK FOR YOUTH Kalamazoo, MI CASE MANAGEMENT INTERN 2000 to 2001

GOODRICH QUALITY THEATERS, INC. Three Rivers, MI

ASSISTANT MANAGER 1999 to 2000

Education

WESTERN MICHIGAN UNIVERSITY Kalamazoo, MI

Bachelor of Science (B.S.)

HILLSBOROUGH COMMUNITY COLLEGE Tampa, FL

Associate of Science (A.S.) Databased Technology

HILLSBOROUGH COMMUNITY COLLEGE Tampa, FL

Database Administrator Certification

HILLSBOROUGH COMMUNITY COLLEGE Tampa, FL

Computer Programming Specialist Certification

Contact this candidate