We provide IT Staff Augmentation Services!

Managing Database Consultant / Technical Trainer Resume

4.00/5 (Submit Your Rating)

Orlando, FL

OBJECTIVE

To obtain a full - time, consulting, or contract position in the area of database, network, and project management, programming, or web design for one of today's leaders in the industry.

TECHNICAL SKILLS

  • MySQL 4.1/5.0
  • PostgreSQL 8.4, 9.x
  • C ++
  • SQL Server /2008/2012
  • Postgres Streaming Replication
  • PL/pgSQL
  • Embarcadero ERStudio
  • Open Source Development
  • PL/SQL
  • Erwin ER/Studio
  • Red Hat Enterprise Linux
  • T - SQL
  • Visual Studio 2005
  • Fedora Linux 7 - 16
  • PHP 5.0
  • Exchange Server 2007 pgPool - II
  • C-Programming
  • SharePoint Server 2007
  • Bucardo Replication
  • Visual Basic 6.0
  • Microsoft SSIS 2008
  • SOX Compliancy
  • Confidential 11g
  • Microsoft SSAS 2008
  • Sovera Health Information
  • Confidential RDBMS
  • Microsoft SSRS 2008
  • Crystal Reports
  • Confidential Service
  • Microsoft Office
  • Confidential Forms & Reports
  • Confidential GRID Control
  • CentOS Linux
  • Confidential Manufacturing Apps
  • Confidential RMAN
  • Backup Exec
  • Confidential Financial Apps
  • Confidential RAC
  • Veritas NET Software zLinux - Confidential zEnterprise
  • Sunrise XA Client
  • Nexpose - Rapid 7
  • Sun Solaris
  • Maximo MRO Software 4
  • Cacti RRDTool
  • Navicat GUI pgAdmin

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

Managing Database Consultant / Technical Trainer

Implemented PostgreSQL database system into custom work environments (i.e. Amazon Web Services) to make use of cloud-based solutions Used Microsoft 2012 SSAS/SSIS/SSRS to successfully migrate multiple clients to and from the PostgreSQL database environment Focused training to cover numerous topics dealing with installation, database administration, database development, and trained clients on using JSON(JavaScript Object Notation) in multiple Java-bases applications Directed clients in post-training techniques and helped each client to successfully install PostgreSQL in both production and testing environments

Used numerous techniques to help clients extract, transfer, and load their production data from other database systems, such as Confidential and MS SQL Server, and use it in their PostgreSQL environments Provided customer support for clients post-training to build customer knowledge and develop best practices on the use, administration, and management of the PostgreSQL database environment Used Microsoft 2012 SSAS/SSIS/SSRS to successfully migrate multiple clients to and from the PostgreSQL database environment Developed customized training documentation based on each client’s technical needs and built a curriculum to help each client learn both basic and advance techniques for using PostgreSQL

Confidential, Bloomington, IL

Senior PostgreSQL Data Architect

Directly responsible in performing database installation in PostgreSQL data base, database design and modeling, coding and maintenance Streamlined the automation of release processes, enhancements and features for the developmental and testing phases of the project Participated in routine product builds, release activities, and code reviews and helped provide experience-based insight on new technologies to utilize Performed periodic internal testing to identify problems early, perform error handling and stress scenarios, and created error handling procedures to help resolve database issues before they occur Identify and recommend where new technologies may be incorporated for database replication, load balancing, and data sharding in order to fully utilize available hardware resources Created specific database design configurations to help build a high-availability database environment Trained Business Analysts to perform many administrative database tasks aid in the design and maintenance of the system

Confidential, Orlando, FL

SQL Developer / Report Writer - Health Information Management

Supported multiple SQL Server databases using versions 2000/2005/2008 Developed new database processes allowing the decommissioning of legacy software and hardware Updated many user processes using Microsoft Visual Studio 2005/2008/2010 Created SQL test scripts and stored procedures to perform QA analysis of data conversion processes from SQL to Microsoft Word, and then to PDF formatted reports Participated in High Level Schema Design, Detail Design, Coding process and User Testing in order to introduce new reporting system into the user environment Received training in ICD-9, ICD-10, the Sunrise XA Client interface system, and confidential Information Management System Delivered numerous SQL scripts perform database and application tuning, and allow for high scalability of all current production systems

Confidential, Atlanta, GA

Senior PostgreSQL Database Administrator - MSS Engineering

Served as Senior PostgresSQL Database Administrator for Nexpose, the award-winning vulnerability management solution from Rapid 7 Integrated Nagios, a powerful monitoring system that enables organizations to identify and resolve IT infrastructure problems, to monitor the PostgreSQL database Utilized Cacti, a complete RRDTool which stores all of the necessary information to create graphs and populate them with data, to create detailed graphs yielding useful database health information Served as zLinux System Administrator for all servers utilized in the Nexpose Security server cluster Provided remote PostgreSQL administration services for many different company branches in the United States; Migrated data to and from production Confidential databases in PostgreSQL databases Performed shell scripting and system administration within Red Hat Linux operating system Mentored and trained junior PostgreSQL DBA to perform basic administration duties in PostgreSQL

Confidential, Clermont, FL

Database Analyst III - Information Technology

Supported multiple SQL Server databases using versions 2000/2005/2008 Utilized SSIS to convert legacy DTS Packages into SSIS jobs and allowing for more efficient data processing Created custom reports for multiple user groups of TimeShareWare software in order to help streamline access to all reports Supported day-to-day user groups through our automated ticketing system GLPI Developed new database processes allowing the decommissioning of legacy software and hardware Updated many user processes using Microsoft Visual Studio 2005/2008/2010

Confidential, Orlando, FL

Senior Database Administrator / SharePoint Server 2007 System Administrator - Information Technology

Served as Senior Database Administrator using MS SQL Server 2005 Utilized the data mining features which are available to SQL Server Analysis Services (SSAS) to slice and navigate specific queries used in legacy databases and Report Builder Created and updated various reports for all company divisions using Reporting Services in conjunction with the SyteLine reporting system and performed daily T-SQL programming duties Integrated legacy and new data from MS Access and SQL Server 2000 into the database using SQL Server Integration Services (SSIS) Administered Microsoft Office SharePoint Server 2007 to help organize project information being used throughout the company into a relational organized website to benefit all work groups Learned and facilitated various changes for SyteLine, an ERP system used within the AeroTech division at JBTC

Confidential, Tampa, FL

IT Project Manager / Senior Database Administrator / Software Developer

Delivered the Asset Management Database Application for the Operations and Financials Groups Created and executed project plans to meet the various changing needs and requirements for the IT Group (Switch and Data is a Co-location provider for the entire USA - confidential site ) Used Powerbuilder to help coordinate code development with developers and analysts Reviewed and delivered all IT deliverables on time and within scope for the entirety of the project Utilized Confidential Real Application Clusters (RAC) within a zLinux Enterprise environment to ensure server availability to cross-country clients through the use multiple PL/SQL stored procedures Served as senior database administrator for a variety of other projects using Microsoft SQL Server 2005, Confidential 10g, Sybase SQL Anywhere, and MySQL 5.0 for numerous applications Effectively applied the SDLC methodology to complete all action items and enforced project standards according to Sarbanes-Oxley standards Adequately managed project budget to stay under the IT Group’s financial spending while meeting all group requests, such as the transferring of monthly group reporting Communicated necessary deliverables with all third-party clients in order to meet the project goals, but also in a way which minimized IT’s exposure and risk on this project Developed an online reporting database application for the Financials Group to allow them to track all open and closed purchase orders using a web interface Served as Confidential Subject Matter Expert, installing Confidential 10g database and Confidential Apps ( Confidential Service, Confidential Financials Apps, etc.) and configured testing and production database environments Facilitated team and client meetings on a regular basis to help steer business development and utilize “best practices” in project delivery

Confidential, Dunedin, FL

SQL Server 2000 Database Administrator / Software Engineer / MySQL/PostgreSQL DBA

Performed specialized processes such as customizing SQL Replication for MS SQL Server 2000 Configured custom servers to utilize new resource sharing technology using VMWare utilities in a virtual server environment Used Red Hat Enterprise Linux 4 and Fedora 7 to build development environment Performed UNIX Shell Scripting to help automate many system functions within Red Hat Linux Researched and recommended new technology and methodologies such as JitterBit, SugarCRM, and other open source software to help increase overall efficiencies Supported internal network by utilizing Open Source software to perform network auditing

Assisted with backups of data while aiding in database creation/analysis, database health monitoring and diagnostics; tested proposed database environments for MySQL 5.0 Managed database tools, created stored procedures, triggers, and information to help facilitate web-based solutions using SQL Server 2000 DTS Packages Created numerous white papers and documented many database issues that were either lingering from legacy design problems or being caused by the advent of using new technology, and also supplied solutions, suggestions, and best business practices for the company to improve Performed routine updates to the firm's Intranet and Internet sites for marketing and informational purposes Planned and implemented many application databases using SQL and VB. NET

Trained end users on database query techniques that could be used in retrieving data from marketing reports and help the Sales department to increase revenue for future quarters

Confidential, Tampa, FL

MySQL 5.0 Database Administrator / Developer /Asst. Project Manager - Technology Division

Installed, configured, managed, updated, and maintained multiple MySQL 5.0 servers and databases Developed an automated network provisioning system for SS7, CCNS, IP and Frame orders Held responsibilities for all DBA duties for this project on the platforms Redhat Linux and Solaris 10 using Apache with the MySQL database Participated in High Level Schema Design, Detail Design, Coding process and User Testing Created data migration scripts from spreadsheets, Access databases, Foxpro databases, etc. Designed both logical and physical data models using Embarcadero ERStudio Developed stored procedures and triggers in PL/SQL to convert data between Confidential and MySQL Communicated with the developers the impact changes have on the database. i.e.: adding columns and indexes; able to articulate to developers how certain changes would impact the DB results and performance; Converted database from MySQL 4.1 to 5.0 Created/Maintained/Tested MySQL master/slave replication Researched and recommended new technology and methodologies such as Navicat and other open source software to help increase overall efficiencies Served as system administrator in the zLinux environment for ETL data from Confidential 10g to MySQL Assisted with backups of data while aiding in database creation/analysis, database health monitoring and diagnostics

Confidential, Ocala, FL

MS SQL Server 2000/PostgreSQL Administrator / Manager

Served as in-house Confidential 9i and 10g database and RAC implementation specialist for First Advantage - Successfully migrated the company’s primary database from MS SQL Server 2000 to PostgreSQL 8.0 in order to provide the company with a stable database system without the high overhead

Performed shell-scripting within the HP-UX environment to scrub and migrate legacy data Utilized PostgreSQL database in a company-wide development environment to allow users to create applications for users of the PostgreSQL database system Migrated the company’s production database to the PostgreSQL database system in a development environment; utilized MySQL 4.1 and 5.0 in both Linux and Windows environments Prepared and migrated SQL code from Sybase SQL Anywhere to Confidential 10g and PostgreSQL Created logical and physical data models for the production database using Erwin Data Modeler Received DB2 data and migrated DB2 database to SQL Server 2000 within the zLinux environment Provided information from a database security perspective to help the company achieve Sarbanes-Oxley compliancy and also performed compliancy testing throughout the Confidential Configured and implemented Confidential RMAN 9i in Linux (Red Hat Enterprise) to Backup Exec tape Performed database administration and development to utilize Confidential architecture more efficiently by creating functions and triggers in PL/SQL, T-SQL, and VB 6.0 to help automate periodic processes Successfully completed official PostgreSQL Training BootCamp with Big Nerd Ranch Configured Linux servers to monitor production server status at Co-location facility in Georgia Implemented database replication between the company’s production primary and backup servers using Software Development Life Cycle (SDLC) methodologies

Confidential, Orlando, FL

Senior MS SQL Server 2000 Database Administrator / Asst. Project Manager

Designed project plans in Transact-SQL and Visual Basic to implement SQL Server Clustering into the company’s production environment Performed the migration of the company’s production server to a newly clustered environment featuring Active/Passive clustering and giving the client a more stable and readily available server

- Upgraded the production server from SQL Server 7.0 to SQL Server 2000 and linked all corresponding databases, DTS Packages, Jobs, and backups to the new server

Installed and schedules daily/monthly backup and restore processes for the new server environment using Veritas Backup Exec 8.0

Developed both physical and logical data models for the client using MS Project 2000 Coordinated the use of current company-wide resources with area managers in order to help facilitate more productive call center service and helped to allocate their data resources for each support team Utilized highly successful methods for deploying the data warehouse system throughout the entire lifecycle of this consulting project by finishing many action items ahead of scheduled delivery time

Confidential, Orlando, FL

Senior Systems Analyst / MS SQL Server 2000/7.0 Database Administrator

Maintained up to 20 different third-party applications for the largest law firm throughout the state of Florida Performed routine updates to the firm's Intranet and Internet sites for marketing and informational purposes to allow for EDI processing with clients Planned and implemented many application databases using SQL and VB. NET to allow the attorneys and staff in the firm to utilize document and case management abilities Upgraded all third-party applications for which I am responsible for to ensure that all users have access to newest and latest features of each software package Scheduled and performed daily backup procedures using both SQL Server 7.0 and Veritas Backup Exec 8.0 for all firm databases Researched and tested many of the latest software applications utilized by some of today's leading law firms throughout the nation Administered the Elite Database system, the standard for today's leading law firm, which provides the entire law firm with functionalities such as billing, time tracking, workflow tracking, and other various activities Implemented two major client-relationship management products (InterAction 4 and Time Matters 4) to many of the employees throughout the firm Created and maintained over 20 different databases in SQL Server 7.0 for testing and firm-wide utilization, as well as performing routine tuning procedures

Confidential, Lake Buena Vista, FL

MS SQL Server 7.0 Access Database Administrator and Application Developer

Prepared DELL Poweredge 2500 to be the primary domain controller and server for all users of the MS Access 97 application called the “Reservation Tracking Overflow System” Scheduled daily backup and tuning procedures to run as specific jobs in SQL Server for the lifetime of use of the Overflow System on site and using PC Anywhere Coordinated SQL Mail within SQL Server to log error messages and contact the database administrator if an unexpected shutdown of the database Created many stored procedures and views for the Overflow System in MS Access 97 and in SQL Server to add more features to the application in T-SQL

Developed and programmed many different functions within the Overflow System to help stream- line day-to-day business processes

Confidential, Altamonte Springs, FL

Network and System Administrator

Monitored and set up existing and new networking system including IP Addresses, IP Routing, the Domain Naming System, and observing the Domain Name Servers Configured the networking hardware including devices and drivers, Ethernet installation and cabling, and setting the configurations for TCP/IP, configured user e-mail using MS Outlook 2000 Administered a network of systems for users utilizing operating systems on Windows 98 and Windows NT, as well as Windows Office 2000 Converted PL/SQL code and procedures into recognizable T-SQL for Microsoft SQL Server Managed database tools, created stored procedures, triggers, and information to help facilitate web-based solutions using MS SQL Server Programmed MS FoxPro database using MS Visual Studio 6.0 and VB. NET, which allowed for the automation of many day-to-day functions within the company’s shipping and inventory system Installed many of the leading operating systems and software from Microsoft for system with more than 100 users Used MS Project 2000 to track and record the progress of daily action items within the system

Confidential, Altamonte Springs, FL

Microsoft Database Administrator / Database Innovations Developer

Designed intricate database model and system using MS SQL 7.0 and MS SQL 2000 to store components to hold more than 2 terabytes of information Managed database tools and information to help clients create web-based banking and credit card solutions using MS SQL Server and Sylvan Faust SQL Programmer Utilized database management tool called ErWin (Computer Associates) to plan, model, and help design data models to be more graphically friendly for new database users Created stored procedures and triggers using Transact-SQL for data programmers to utilize for the creation of e-business products and applications

Confidential, Orlando, FL

Confidential / SQL Server DBA

Held responsibilities as database administrator utilizing both Confidential 9i and SQL Server 2000 Produced both physical and logical design models using ERwin for the Confidential database structure Developed simulation models for office and field facilities specific to each branch of the Armed Forces using the system Implemented Maximo Release 4 as the preferred simulation model to produce customized reports

Developed multiple stored procedures and triggers using T-SQL and PL/SQL to manage system performance, reliability, and availability for a multiple number of users on a network Used MS SQL Server 2000 to manage system storage using techniques such as data compression, remote storage, and disk fragmentation Designed customized screens and modifications using VB 6.0 and Centura Object Nationalizer Specified Maximo data collection processes for both Confidential and SQL Server databases to help facilitate the creation of Crystal customized reports for each user’s purposes Migrated system data from Sybase SQL Server to Confidential database environment Managed system accounts for over 40 international users and improved overall system processes

Confidential, Orlando, FL

Technical Trainer / Confidential 9i RDBMS Team Lead - 24/7 Customer Applications

Provided customers with answers to issues crossing many Confidential Applications on a team specifically designed to handle issues from all over the world including setup and implementation, design & development, end customer support, and many other database administration functions Performed training in the use, implementation, and troubleshooting of all areas of Confidential Manufacturing 9i applications (order entry, receivables, inventory, etc.) Performed training in the use, implementation, and troubleshooting in all areas of Confidential Financials 9i applications (general ledger, assets, receivables, payables, etc.) Developed patches to fix specific bugs within client databases using PL/SQL programming Installed and supported numerous Confidential 9i databases (30+) on Windows, UNIX, and Linux environments Utilized Sun Solaris (UNIX), MS Windows NT, and Think Blue Linux (zLinux) platforms on Confidential Trained new employees and clients in using PL/SQL in a classroom setting Composed training for co-workers in a variety of database administration for Confidential platforms Integrated Confidential to many systems including SQL Server, UNIX, and Sun Solaris

Confidential, Orlando, FL

Intern - Plant & Factory Engineering Department

Designed systematic database for existing and future power distribution networks Created detailed schematics to display and update system information using AutoCAD 13 Stored all relevant information in an MS Access 97 database for future reference Compiled power systems information for overall facility Analyzed power distribution routes throughout the state of Florida

Confidential, Willow Run, MI

Intern - Component Testing Laboratory

Calibrated transducers for testing on component testing machine Utilized PLC's (Programmable Logic Devices) and systems to record results Created database system using MS Access with network capabilities containing product information Performed high-performance test drive to collect information on transducer temperatures in Arizona Training facilities Received high-performance test drive certification at the GM Desert Proving Grounds facility

We'd love your feedback!