Post Job Free
Sign in

Sql Server

Location:
United States
Posted:
December 11, 2017

Contact this candidate

Resume:

Kevin Kirksey

214-***-**** (***************@*****.***)

Summary

Computer professional with over 15 years of experience. Knowledgeable and experienced with SQL Server SQL 2014, SQL 2012, 2008R2, 2008,, 2005, 2000 & 7.0, Windows 2012, 2008, 2003 & 2000 Server, VWware, Clustering, ERP PeopleSoft, SharePoint, IIS, Exchange, Citrix Metaframe, Terminal Server, Veeam, Netbackup, Project Management, RFP, Risk Management, PCI and SOCKS.

Education

Education: Computer Science 1984-1989, Langston University: Langston, Oklahoma, SQL MCTS and MCITP Certified. Microsoft Certification ID: 8757827

Skills

HARDWARE

Compaq Proliants, Dell 710, Power Edge, IBM RISC 6000, SUN SPARC, HP 3000, HP 9000,

Net Frame, Cisco Routers, 3COM, Wellfleet, Synoptic, Cubix and Cabletron

OPERATING SYSTEM

SQL 2012, 2008 R2, 2008, 2005, 2000 & 7.0, Windows 2008 R2, 2008, 2003 & 2000 Server, IIS 8.0, 7.0, Windows 2000 Workstation, Windows 7,98, Windows 95, NT Workstation, Windows XP

SOFTWARE

SQL DB Artisan, DB Change Manager, Litespeed, Comm Vault, Idera (SQL Safe & Admin Tools), LanDesk, Red Gate SQL Compare, Visual Basic InterDev, Visual SourceSafe, Erwin, MS Sharepoint, Quest Spotlight & FogLight, Red Gate’s SQL Compare, Nagious, MS Office 2010, 2003, 2000 & 97, MS Project Manager, Cisco VPN, FTP, SMS, Truesight, Sitescope, Netscaler, Unicenter, Exchange, Microsoft PSDIAG & Read80Trace, Tidal Job Scheduler, Microsoft Baseline Security Analyzer, Cisco VPN Client, Lotus Notes Mail

SR. SQL DBA – Paladin Consulting (Contract) Dallas, Texas 3/2015 to Present

Client XO Communications/ Verizon

Install/configuration/maintenance of SQL Servers (Physical, VmWare) SQL 2012, SQL 2008 R2, 2008, 2005, 2000

SQL Clustering installation, design, implement & Support

Data center migration SQL 2012, SQL 2008 R2, 2008, 2005, 2000 physical instances, SQL Clusters & VmWare in a Prod, Stage, QA, Dev & test environment

SQL Database & Server Migrations

SQL backups & restores with Netbackup & Veeam

Capacity planning SAN & Local storage recommendations and implementation

Database design/de-normalization (Tables/Schema, Views, Stored Procedures, Views)

Providing data reports from various required applications

Performance tuning/optimization with SCOM, Idera, SQL Profiler traces, Perform monitor, SQL DB Tuning Wizard, Execution Plans, VmWare and Windows server tools.

Disaster Recovery

Provides R&D for new SQL Technology and tools (SQL 2014, Solarwinds, Veeam Backup, SSIS, SSRS, SAN storage for SQL VmWare & Physical Servers

Writing T-SQL queries

Recommending SQL Operations and Development best practices implementing both

Installing/configuring, implementing and supporting SSIS, SSRS

Writing SSIS packages, jobs & supporting them where requested

SharePoint DBA support, migration and support for servers (Operations, Design and Performance and generating reports. Recommending best practices and assisting in the implementation.

SQL database application support

Link Servers for data important/export

SQL Documentation (Operational, DBA Guide, Performance SSIS best practices, SharePoint best practices

Application support with developers and end users

SQL DBA – Agile Premier Consulting (Contract) Addison, TX 1/2015 to 2/2015

SQL DBA/ Architect CoreLogic via Morningview – (Contract) SouthLake, Texas 6/2014 to 12/2014

Data center migration SQL 2012, SQL 2008 R2, 2008, 2005, 2000 physical instances, SQL Clusters & VmWare in a Prod, Stage, QA, Dev & test environment

SQL backups with Idera & Litespeed

Capacity planning SAN & Local storage recommendations and implementation

SQL Clustering design/implement & Support

Performance tuning/optimization with Profiler traces, Perform monitor counters & Execution Plans

Disaster Recovery

Writing T-SQL queries

Creating & supporting SSIS packages

SSRS server designs & implementation

Documentation

SharePoint DBA support and migration

SQL database application support

Link Servers for data important/export

Performance tuning/Optimization (Profiler/Perfmon, NETIQ, Solarwinds, T-SQL)

SQL DBA – Source1Tek (Contract) Branchburg, NJ /2014 5/2014 to 6/2014

App/Sys/Programmer Specialist (Also working as SQL DBA work)- Parkland/ Dallas County Health and Human Servies –(Permanent) Dallas, TX. 2/2011 to 2/27/2014

SQL DBA Lead of 100 SQL Servers (Physical Clusters & Single Instances & VMware), (2012, 2008 R2, 2008, 2005, 2000). SQL DBA Lead 1 of Jr. SQL DBA

Re-Architecture SQL Server environment

Acted as the primary point of contact with customer SQL DB Applications

Project management (meeting deliverables, timelines,

and defining needed resources and all requirements

specifications being defined/implemented

Customer support to all related SQL DB/application/content

questions

Provided monitoring and constant evaluation of projects (status reports, SOW)

Responsible for the quality control doing the actual implementation of

software/applications with clients onsite.

Provided ongoing input to onsite manager regarding all project related

processes (Status, milestones, plans, status, deliverables, risk & issues).

Participated with on going status/change incident meetings and report on

project progress.

Supported end users and provided DB/application training where required

providing great warm hand off of implemented software applications

for SQL Databases.

Working with Oracle DBA using PeopleSoft to Migrating data to SQL Datawarehouse

Working with RFP’s

Risk Management

Performing Database Architecture Modeling

SQL DBA Lead over 80 Web Application servers

SQL DBA Lead over 20 Citrix applications on SQL back end

SQL Lead working with application developers and support

Manager/Support of 6 Active/Passive Clusters

Working with EMC SAN team on configurations for SQL Servers

Creating solutions that meets both external and internal customer’s data needs regarding marketing and advertising web applications.

Mentor junior App Support, DBA and application management

Implemented/support enterprise backup solution with Idera SQL Safe & SQL

Setup/Configure & support Replication (Transactional & Snapshot)

Setup/Configure & support DB Mirroring

Create/support SSIS packages & jobs. Import/Export data using Excel, Access & text files into databases

Managed databases from 1GB to 2 TB databases

Patch management & deployment

Working with secure DMZ’S for SQL Servers

Performance monitoring, tuning & troubleshooting (Solarwinds, Profiler, Perfmon, SQL Dashboard & DTA)

Experience on installing SQL Server and configuring SAN and Cluster server.

Work under pressure to meet tight delivery timelines

Interacts between application developers, vendors, managers and

App support, Intel & VMware

Working with Windows 2008 R2, 2008 & 2003 servers

Administers, maintains, develops and implements policies and procedures

Implements data models & database designs, data access & table maintenance codes; resolves database performance issues, database capacity issues

Designed/Implemented DR plan (San Replication between sites)

Code/Scripts Review of developers and Vendors

Implement/Support SQL Security (Windows & SQL Authentication, roles and AD groups)

Assess and develop long-term strategic goals for production databases in conjunction with data owners and managers. Act as a liaison between the developers, application support

Design and implement redundant systems, policies and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

Conduct research and make recommendations with servers, applications, database products, services and standards in support of procurement and development efforts; liaise with vendors and service providers for the selection and procurement for new technologies.

Troubleshooting though DBA tools (SSMS, Solarwinds, Quest Foglight, Idera, Microsoft Performance Profiler & Monitor)

24x7 on call rotation

Manages outsourced support resources to meet operational and delivery objectives

Technical presentation to CIO, Director of Technical Services & other Department App Directors

Worked with exporting and importing data with SSIS to from Oracle 10g and 11g with SQL Server databases

Working with DB applications: Epic, Cloverleaf, HIM, Pharmacy, BedTracking, INFOSEC security, DigiSonics, EDMS, Radiology, Help Desk, IT Jail health (CIPS, Accuflo, Talyst), TrueCode, Ansos,APC Grouper Financial, Audit Leverage DB Server, Bio Medical Engineering,Bio-Rad, BlackBaud, CNA, Cardiology, Care Fusion,

Censitrac(OR), Chart Tracking, Citrix SQL DS CPS4.0, Clarity Reporting,

Clinical Innovation, Computrition, Core Privilige, CPS5.0 SQL DS - AR,

Critigen,DPS-DSX, EdgeSight, EMR, Exchange archive/reporting,

Eye clinic server, GHX server (Interfaces with Lawson and Catalyst),

Grants Management Server, Harmonie, HIV SQL, Information Security,

Interqual/Care Enhanced Review Mgr, Help Desk ITSM,Kaufman Hall Budget

Advisor, Lab Care, Landesk Management DB Server, LVM, Medical Records

cancer registry, Muse,My Chart, OBIX Omnicell, OR Greaseboard, PaceArt

Peoplesoft - Citrix, PFS,Phillips MDI

SQL DBA -- Client – Cash America (Contractor) FT Worth, TX. 5/2010 to 9/2010

Supported end users and provided DB/application training where required

providing great warm hand off of implemented software applications

for SQL Databases.

Assisted with pre-sales and marketing of SOW, applications, demos, writing against RFP RFIs & RFPs and responding to business problems customers brought up during meetings.

Database administration of SQL 2005 on Windows 2003 and SQL 2008 and SQL 2008 R2 Servers on Windows 2008

Standardized and configuration new SQL Servers

SQL best practices

Implemented & managed all SQL security

Release Performance – responsible for monitoring all release testing and gathering performance metrics to determine if adjustments need to be made before production migration. This includes load testing a simulated production load.

Production Performance – reviewing production performance metrics to determine how changes are needed to prevent issues. Application\Database tuning

Project management (meeting deliverables, timelines and defining needed

resources and all requirements specifications being defined/implemented

Customer support to all related SQL DB/application/content questions

Provided monitoring and constant evaluation of projects (status reports, SOW

and provided RFP'S)

Responsible for the quality control doing the actual implementation of

software/applications with clients onsite.

Provided ongoing input to onsite manager regarding all project related

processes (Status, milestones, plans, status, deliverables, risk & issues).

Participated with on going status/change incident meetings and report on

project progress.

Liaison, between IT and tech services, communicated with Application support teams, to ensure everyone was aware of release schedules, turns, issues and fixes.

Liaison, between IT and Vendor – Communicate any questions or issues that relate to database performance to the vendor. Discuss solutions with tech services Database Administration.

Test\QA Application Database support – responsible for coordinating, communicating and executing turns for stored procedures, views, tables, DTS packages, and SSIS Packages within Development\QA.

SQL Server Application Job Support – responsible for coordinating the creation and scheduling of application database jobs for all environments with Database Administration. First level of support responsible for: receiving all application job alert notifications, researching application job failures, rerunning application jobs as needed

IT Resource – available to IT support team members to recommend ‘best practices’ when developing database processes (e.g. extracts\loads).

Database Data Loading - data loading through application code, SSIS packages or imports.

Database Data Extracting - data extraction through application codes, SSIS packages or exports.

Database archiving\purging – responsible for determining what data should be archived\purged.

Table Capacity monitoring – tracking growth of largest tables to determine ways to handle the growth, purges, creation of an archival system

Batch Performance monitoring – monitoring the batch processes to ensure optimal performance.

Maintenance Jobs – Create SQL jobs (SSIS, security, SQL scripts & database maintenance)

Backup\Recovery –create Backup\Recovery jobs (Using Comm vault and SQL)

Web Administration – Performed Installation, Configuration and Support of web servers, Web turn deployments, troubleshooting & performance monitoring

Performance monitoring of SQL servers, Windows 2003 & 2008 servers & Web servers using SQL Perfmon, profile, SQL scripts, Solar Wind

SQL Server Clustering Support Active Passive

Created SQL &Web server & Application documentation

Implemented Database Mirroring in Development

Created SQL Server best practices for Security, Database Administration, Backups & restores, job management, Disaster recovery, patch deployment.

Worked with Change control

DB2 backup DBA

Worked with exporting and importing data with SSIS to from Oracle 9x and 10x with SQL Server databases

SQL DBA (SQL SQL 2005, 2008, Environment) Client -Humana Louisville, KY. 7/2008 to 1/2010

Syntel Inc. – Employer

SQL DBA – Inovar Packaging, (Contractor) Dallas, TX. - 3/2008 to 5/2008

SQL DBA – VHA – CONTRACT – Dallas, TX. - 11/2007 To 3/2008

Database Design – reviewing\approving database designs before moving to production.

Supported end users and provided DB/application training where required

providing great warm hand off of implemented software applications

for SQL Databases.

Database Code – reviewing\approving database code before moving to production.

Release Performance – responsible for monitoring all release testing and gathering performance metrics to determine if adjustments need to be made before production migration. This includes load testing a simulated production load.

Production Performance – reviewing production performance metrics to determine if\how changes are needed to prevent issues. Application\Database tuning – proactively reviewing database specific application code (e.g. stored procedures, packages, etc…) to ensure optimal application and database performance.

Liaison, between IT and tech services, communicated with CAE Application support teams, to ensure everyone was aware of release schedules, turns, issues and fixes.

Liaison, between IT and Vendor – Communicate any questions or issues that relate to database performance to the vendor. Discuss solutions with tech services Database Administration.

Test\QA Application Database support – responsible for coordinating, communicating and executing turns for stored procedures, views, tables, DTS packages, and SSIS Packages within Test\QA.

SQL Server Application Job Support – responsible for coordinating the creation and scheduling of application database jobs for all environments with Database Administration. First level of support responsible for: receiving all application job alert notifications, researching application job failures, rerunning application jobs as needed

IT Resource – available to IT support team members to recommend ‘best practices’ when developing database processes (e.g. extracts\loads).

Database Data Loading - data loading through application code, DTS packages, SSIS packages or imports.

Database Data Extracting - data extraction through application code, DTS packages, SSIS packages or exports.

Database archiving\purging – responsible for determining what data should be archived\purged.

Table Capacity monitoring – tracking growth of largest tables to determine ways to handle the growth, purges, creation of an archival system, etc. This also entails managing the data stored in DataMart databases.

Batch Performance monitoring – monitoring the batch processes to ensure optimal performance.

Maintenance Jobs – Create SQL jobs (DTS, security, SQL scripts & database maintenance)

Backup\Recovery –create Backup\Recovery jobs

Managed databases from 50 GB to 2 TB

Web Administration – Performed Installation, Configuration and Support of web servers, Web turn deployments, troubleshooting & performance monitoring

Performance monitoring of SQL servers, Windows 2003 servers & Web servers using SQL perfmon, profile, SQL scripts, Truesight, HP open View, Sitecope)

Windows Server 2003 Administration – Providing support, troubleshooting and configuration for SQL and web environment

SQL Server Clustering Support

Created SQL &Web server & Application documentation

Supported Database Mirroring (Principal, Mirror & Witness)

Worked on Sarbanes-Oxley Compliance

SQL DBA – ACCOR – CONTRACT – Dallas, TX. - 4/2007 To 10/2007

Managed SQL 2005 & 2000 servers (Production, Staging, QA, Test and Development)

NET Application Support with SQL developers on all SQL databases and supporting databases

Created and Managed Tables, Indexes, Performance Tuning and Optimization of Databases, Stored Procedures, Indexes

Installed, configure, Support SQL 2000 & 2005 Servers on Windows 2003 Servers

Setup and Maintained SQL Server Security for SQL databases. Provided Disaster Recovery Plans.

Profiler, Perfmon, Microsoft PSDIAG & Read80Trace for performance optimization

Configure and Support SQL Database Backups & Restores

Performed Merge replication on SQL Server Databases

Implemented & Supported Security of SQL Databases in Production, Staging, QA, Development and Test Environments. SQL script deployment to all SQL Servers through Change Management

Disk capacity management

Application Support with SQL developers on all SQL databases and supporting databases

Installed, Configured, Managed and Support of SQL 2000 & Servers

Creating Reports from SQL Databases

SQL DBA – Benny Hinn Ministries – CONTRACT – Dallas, TX. - 9/2006 To 4/2007

Managing 5 SQL 2000 Servers (Production, Staging and Test)

Created and Managed Tables, Indexes, Performance Tuning and Optimization of Databases, Stored Procedures, Indexes

Acted as the primary point of contact with the customer

Project management (meeting deliverables, timelines,

and defining needed resources and all requirements

specifications being defined/implemented

Customer support to all related SQL DB/application/content

questions

Provided monitoring and constant evaluation of projects (status reports, SOW

and provided RFP'S)

Responsible for the quality control doing the actual implementation of

software/applications with clients onsite.

Provided ongoing input to onsite manager regarding all project related

processes (Status, milestones, plans, status, deliverables, risk & issues).

Participated with ongoing status/change incident meetings and report on

project progress.

Supported end users and provided DB/application training where required

providing great warm hand off of implemented software applications

for SQL Databases.

Provided written T-SQL Queries for reporting of business applications Database Logical & Physical Modeling using E/R Studio

Installed, configure, Support SQL 2000 Servers on Windows 2000 & 2003 Servers. Setup and Maintained SQL Server Security for SQL databases. Provided Disaster Recovery Plans.

Provided business and technical recommendations for SQL server environment server environment and implementation.

Supported Active passive Clustering

Profiler, Perfmon, Microsoft PSDIAG & Read80Trace for performance optimization

Configure and Support SQL Database Backups & Restores

Performed Transactional, Snapshot Replication on SQL Server Databases

Implemented & Supported Security of SQL Databases in Production, Staging, QA, Development and Test Environments. SQL script deployment to all SQL Servers through Change Management

Created, managed & supported DTS packages. Installed Upgraded SQL Service packs

Disk capacity management

Application Support with SQL developers on all SQL databases and supporting databases

Installed, Configured, Managed and Support of SQL 2000 Servers locally and remotely

MS Share Point Administrator

Creating Reports from SQL Databases

Manage and support SQL 200 Cluster Servers running on Windows 2003 Server

SQL DBA – FORT KNOX NATIONAL COMPANY, CONTRACT– Louisville, KY. 6/05 to 9/2006

Managed 10 SQL 2000 Server (Production, Staging, QA, Test and Development)

Working with RFP’s

Risk Management

Acted as the primary point of contact with the customer

Project management (meeting deliverables, timelines,

and defining needed resources and all requirements

specifications being defined/implemented

Customer support to all related SQL DB/application/content

questions

Provided monitoring and constant evaluation of projects (status reports, SOW

and provided RFP'S)

Responsible for the quality control doing the actual implementation of

software/applications with clients onsite.

Provided ongoing input to onsite manager regarding all project related

processes (Status, milestones, plans, status, deliverables, risk & issues).

Participated with ongoing status/change incident meetings and report on

project progress.

Supported end users and provided DB/application training where required

providing great warm hand off of implemented software applications

for SQL Databases.

Created and Managed Tables, Indexes, Performance Tuning and Optimization of Databases using Quest Spotlight and Fog light, Stored Procedures, Indexes

Managed and supported VM Ware servers for SQL Servers 2000 and 2005 on Windows 2000 and 2003, also using VM ware performing SQL server consolidation, Virtualizing SharePont Servers to make more scalable, flexible providing reduced hardware requirements. Centralized server, storage and application m management

Provided written T-SQL Queries for reporting of business applications. Created, maintained DTS packages and extraction. SQL Server Clustering.

NET Application Support with SQL developers on all SQL databases and supporting databases

Supported Accounting and business applications on SQL back end

Supported EMC configuration for SQL servers

Provided business and technical recommendations for SQL server environment and implementation.

Supported Active passive Clustering

Created documentation for servers, security, auditing, hardware configuration, disaster recovery, backup and restore strategy and implementation using Litespeed

Database Logical & Physical Modeling using E/R Studio

Provided written Triggers on Tables to perform INSERT, UPDATE & DELETE

Configured, Supported SQL 2000 Servers on Windows 2000& 2003 Servers. Setup and Maintained SQL Server Security for SQL databases. Provided Disaster Recovery Plans.

Profiler, Perfmon, Microsoft PSDIAG & Read80Trace for performance optimization

Configured and Supported SQL Database Backups & Restores

Performed Transactional, Snapshot Replication on SQL Server Databases

Implemented & Supported Security of SQL Databases in Production, Staging, QA, Development and Test Environments. SQL script deployment to all SQL Servers through Change Management

Created, managed & supported DTS packages. Installed Upgraded SQL Service packs

Disk capacity management. Application Support with SQL developers on all SQL databases on .NET Platform, Supporting Databases with Visual Source Safe

Installed, Configured, Managed and Support of SQL 2000 Servers locally & remotely with DB Artisan, DB Change Manger, SQL Server Baseline, SQL Execution Plan, Quest Spotlight and Foglight

Standardized Production SQL Servers to PCI Compliance, Worked with Tidal Job scheduler with the NOC to execute SQL Jobs.

SQL DBA -- HOTELS.COM- CONTRACT -DALLAS, TX. 08/04 to 2/05

Supported 5 SQL 2000 Server (Production, Staging, QA, Test and Development)

Provided written T-SQL Queries, Created SQL Diagrams, Created a data dictionary

Performance Tuning and Optimization of Databases, Stored, Procedures, Indexes

NET Application Support with SQL developers on all SQL databases and supporting databases

Database Logical & Physical Modeling using ERWIN

Provided written Triggers on Tables to perform INSERT, UPDATE & DELETE

Configured, Supported SQL 2000 Servers on Windows 2000 Server

Created and Managed Tables and Stored Procedures

Profiler & Perfmon for performance optimization

Created, managed & supported DTS packages

Application Support with SQL developers on all SQL databases

on .NET Platform, Supporting Databases with Visual Source Safe

SQL DBA -- ACCENTURE – CONTRACT -FAYETVILLE, AR. 5/04 to 8/04

SQL DBA -- VERIZON (ITWB) - CONTRACT, DALLAS, TX. 12/03 to 3/04

SQL DBA -- CITIGROUP, CONTRACT, DALLAS, TX. 05/03 to 08/03

Managed 30 SQL 2000 Server (Production, Staging, QA, Test and Development)

Acted as the primary point of contact with the customer

Project management (meeting deliverables, timelines,

and defining needed resources and all requirements

specifications being defined/implemented

Customer support to all related SQL DB/application/content questions

Provided monitoring and constant evaluation of projects (status reports, SOW

and provided RFP'S)

Responsible for the quality control doing the actual implementation of

software/applications with clients onsite.

Provided ongoing input to onsite manager regarding all project related

processes (Status, milestones, plans, status, deliverables, risk & issues).

Participated with on going status/change incident meetings and report on

project progress.

Supported end users and provided DB/application training where required

providing great warm hand off of implemented software applications

for SQL Databases.

Provided written T-SQL Queries, Created SQL Diagrams, Created Data Dictionary

Performance Tuning and Optimization of Databases, Stored, Procedures, Indexes

NET Application Support with SQL developers on all SQL databases and supporting databases

Supported Accounting and business applications on SQL back end

Database Logical & Physical Modeling using ERWIN

Provided written Triggers on Tables to perform INSERT, UPDATE & DELETE

Configured, Supported SQL 2000 Servers on Windows 2000 Server

Created and Managed Tables and Stored Procedures

Profiler & Perfmon for performance optimization

Configured and Supported Database Backups & Restores

Performed Transactional, Snapshot Replication on SQL Server Databases

Implemented & Supported Security of SQL Databases

Created, managed & supported DTS packages

Disk capacity management, Performed Transaction and Snapshot Replication

Application Support with SQL developers on all SQL databases

on .NET Platform, Supporting Databases with Visual Source Safe

MKS application to manage stored Procedures, scripts & documents

Installed & Managed and Supported SQL 2000 Servers with Terminal Server

JCPenney - CONTRACT, DALLAS, TX.

SQL DBA/STORE TECHNICAL SPECIALIST 03/03 to 5/03

LSI LOGIC, SAN JOSE, CA - CONTRACT

SQL DBA CONSULTANT 08 /01 to 10/02

ENRON, HOUSTON, TEXAS -CONTRACT

SQL DBA / NT ADMINISTRATOR 08/99 to 06/01

Installed, configured & managed 30 SQL 6.5, 7.0 & 2000 production, development and test

Servers. SQL 6.5 server upgrades to SQL 7.0 & to SQL 2000 servers

SQL 7.0 & 2000 Security and Setup & Administration SQL 6.5, 7.0 & 2000 backups and restore jobs

DTS Scripting of SQL Databases

Performed Replication on SQL Server Databases along with Subscription, Publisher and

Distributor. Configured and Maintained Log Shipping SQL Servers

Performed written stored procedures and triggers

BCP and Bulk Insert of data to DBMS, Access, Excel and Indexing of databases

Configured and maintained SQL 6.5, 7.0 & 2000 backups and restore jobs

Visual Basic and ASP Application Support with SQL developers on all SQL databases

SQL Server Application Development Support

Disk capacity management on SQL 7.0 & 2000 servers

SQL Server 7 & 2000 Database Administration using Visual Source safe, Erwin, DB Artisan,

NETIQ

Performance tuning, monitoring, optimization, load balancing, SQL Clustering, Windows 2000 NT Clustering

Provided written disaster recovery plan and documentation

Installed, configured & managed and supported NT 4.0 & Windows 2000 servers

Installed and configured IIS Servers connecting to them to SQL Server 7 & 2000 applications



Contact this candidate