Sql Server Information Technology

Chari Link Clark

**** **** ****** *****, *******, FL 32805, 904-***-****

Email:**********@*******.***

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

Oracle 11g

Microsoft SSAS 2008

Sovera Health Information

Oracle RDBMS

Microsoft SSRS 2008

Crystal Reports

Oracle Service

Microsoft Office

Oracle Forms & Reports

Oracle GRID Control

CentOS Linux

Oracle Manufacturing Apps

Oracle RMAN

Backup Exec

Oracle Financial Apps

Oracle RAC

Veritas NET Software

zLinux – IBM zEnterprise

Sunrise XA Client

Nexpose – Rapid 7

Sun Solaris

Maximo MRO Software 4

Cacti RRDTool

Navicat GUI

pgAdmin

WORK EXPERIENCE

06/12 – Present

CLARK CONSULTING CONCEPTS, Orlando, FL

PostgreSQL Technical Trainer / Manager / Consultant

- Trained over 100 clients and users in using PostgreSQL database software in both private and enterprise technical environments

- 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

- 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

Chari L. Clark (cont’d)

- Used numerous techniques to help clients extract, transfer, and load their production data from other database systems, such as Oracle 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

12/11 – 04/12

STATE FARM INSURANCE, Bloomington, IL

Senior PostgreSQL Data Architect (Consultant)

- 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

06/11 – 12/11

ORLANDO REGIONAL MEDICAL CENTER, Orlando, FL

SQL Developer / Report Writer – Health Information Management (Contractor)

- 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 Sovera Health Information Management System

- Delivered numerous SQL scripts perform database and application tuning, and allow for high scalability of all current production systems

08/10 – 03/11

IBM, Atlanta, GA

Senior PostgreSQL Database Administrator – MSS Engineering (Consultant)

- Served as Senior PostgresSQL Database Administrator for Nexpose, the award-winning vulnerability management solution from Rapid 7

Chari L. Clark (cont’d)

- 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 Oracle 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

05/10 – 07/10

SUMMER BAY RESORT, Clermont, FL

Database Analyst III – Information Technology (Contractor)

- 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

09/08 – 01/09

JOHN BEAN TECHNOLOGIES CORPORATION (FMC), Orlando, FL

Senior Database Administrator / SharePoint Server 2007 System Administrator – Information Technology (Consultant)

- 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

Chari L. Clark (cont’d)

05/07 – 06/08

SWITCH AND DATA FACILITIES COMPANY, INC, Tampa, FL

IT Project Manager / Senior Database Administrator / Software Developer – Information Technology Group

- 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 – www.switchanddata.com )

- 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 Oracle 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, Oracle 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 Oracle Subject Matter Expert, installing Oracle 10g database and Oracle Apps (Oracle Service, Oracle 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

06/06 – 03/07

IMPACT PROMOTIONAL PRODUCTS, Dunedin, FL

SQL Server 2000 Database Administrator / Software Engineer / MySQL/PostgreSQL DBA (Consultant)

- 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

Chari L. Clark (cont’d)

- 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

02/06 - 06/06

SYNIVERSE TECHNOLOGIES, Tampa, FL

MySQL 5.0 Database Administrator / Developer /Asst. Project Manager – Technology Division (Consultant)

- 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 Oracle 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 Oracle 10g to MySQL

- Assisted with backups of data while aiding in database creation/analysis, database health monitoring and diagnostics

Chari L. Clark (cont’d)

03/04 - 01/06

NATIONAL BACKGROUND DATA, FIRST ADVANTAGE COMPANY, Ocala, FL

MS SQL Server 2000/PostgreSQL Administrator / Manager – Information Technology Group

- Served as in-house Oracle 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 Oracle 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 corporation

- Configured and implemented Oracle RMAN 9i in Linux (Red Hat Enterprise) to Backup Exec tape

- Performed database administration and development to utilize Oracle 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

08/03-11/03

STARWOOD VACATION OWNERSHIP & RESORT, Orlando, FL

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

- 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

Chari L. Clark (cont’d)

- 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

06/02-02/03

AKERMAN SENTERFITT, Orlando, FL

Senior Systems Analyst / MS SQL Server 2000/7.0 Database Administrator – Computer Applications Group

- 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

10/01-05/02

SHADES OF GREEN RESORT (DOD), Lake Buena Vista, FL

MS SQL Server 7.0 Access Database Administrator and Application Developer (Consultant)

- 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

Chari L. Clark (cont’d)

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

07/01-09/01

T. SHIPLEY, Altamonte Springs, FL

Network and System Administrator - Information Technology Group (Consultant)

- 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

12/00-3/01

FOCUS ON INNOVATION, Altamonte Springs, FL

Microsoft Database Administrator / Database Innovations Developer (Contractor)

- 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

7/00-12/00

ELECTRONIC DATA SYSTEMS - FEDERAL GOVERNMENT, Orlando, FL

Oracle / SQL Server DBA – Modeling and Simulations Group (Consultant)

- Held responsibilities as database administrator utilizing both Oracle 9i and SQL Server 2000

- Produced both physical and logical design models using ERwin for the Oracle 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

Chari L. Clark (cont’d)

- 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 Oracle 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 Oracle database environment

- Managed system accounts for over 40 international users and improved overall system processes

11/98-2/00

ORACLE CORPORATION - ORACLE WORLDWIDE SUPPORT, Orlando, FL

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

- Provided customers with answers to issues crossing many Oracle 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 Oracle Manufacturing 9i applications (order entry, receivables, inventory, etc.)

- Performed training in the use, implementation, and troubleshooting in all areas of Oracle 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 Oracle 9i databases (30+) on Windows, UNIX, and Linux environments

- Utilized Sun Solaris (UNIX), MS Windows NT, and Think Blue Linux (zLinux) platforms on Oracle

- 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 Oracle platforms

- Integrated Oracle to many systems including SQL Server, UNIX, and Sun Solaris

5/97-8/97

LUCENT TECHNOLOGIES - BELL LAB INNOVATIONS, 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

Chari L. Clark (cont’d)

5/96-8/96

GENERAL MOTORS CORPORATION - GM POWERTRAIN, 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

EDUCATION

Florida A&M University, Tallahassee, FL

Bachelor of Science - Electrical Engineering; InterdisciplinaryStudies;

Computer Information Systems; Mathematics

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate