We provide IT Staff Augmentation Services!

Sql Database Developer / Administrator Resume

5.00/5 (Submit Your Rating)

DallaS

SUMMARY:

  • Database Developer /Administrator with over 20 years management experience, including project management, application development, and system integration, seeking opportunity where my skills, business acumen and desire to grow will be utilized to the fullest extent.
  • SQL Server 2000 Certified
  • SQL Server 2005, SQL Server 2008
  • Windows Server 2003, 2008 & 2008 R2 Management
  • Exchange Server 5.5 / 2000, 2010
  • Microsoft IIS
  • VB Scripting
  • .Net Architecture Support
  • Active Directory Implementation and Migration
  • Information Systems Infrastructure Design and Deployment
  • Enterprise Management
  • Windows 2003 Certified
  • Application Design, Development, and Deployment
  • Proven Project Management Skills
  • Ability to Thoroughly, Decisively, and Rapidly resolve Technical Issues
  • Systems testing and tuning
  • 15 + Years of Information Systems Experience

COMPUTER SKILLS

  • Microsoft SQL Server 6.5, 7.0, 2000, 2005 and 2008
  • SQL Query Language
  • ImageNow
  • Brainware
  • Triggers / Views
  • SQL Scripting, SQL Stored Procedures, T - SQL
  • DTS, Transactional Replication
  • Microsoft / IBM-based systems
  • Microsoft Windows 3.1 - 95 - 98 - ME
  • Microsoft Windows NT - XP - 2000
  • Microsoft Windows Server 2003
  • Microsoft Exchange Server 5.5
  • Microsoft Exchange 5.5 and 2000
  • Microsoft Office 97, 2000, 2003, XP, 2007
  • Microsoft Visio
  • Cognos ReportNet 7
  • Crystal Reports
  • Cognos 8
  • Remote Desktop / Terminal Server
  • Framework Manager
  • Routing and Remote Access
  • TCP/IP
  • DHCP
  • DNS
  • SMTP
  • POP3
  • IMAP
  • MIME
  • HTTP
  • HTTPS
  • FTP
  • Domain Registration

TECHNICAL SKILLS:

Platforms: Windows 95, 98, ME, Windows XP, Vista, 7 - Windows NT-2000, 2003, 2008 Standard and Enterprise Edition, Windows Server 2008 R2 Standard and Enterprise Edition.

Hardware: Dell Servers, Dell NAS and SAN Devices, DLT4000 Series Tape Backup, Exabyte Series Tape Backup Devices, Data General MV-1000, Sonic Wall Firewalls, Hubs, T1, xDSL 10-baseT, 100-baseT, VPN, ISDN, SCSI, IDE, Modems, Nortel Telephone System.

Software: Active Directory, Exchange Server 5.5-2003, SQL 6.5, SQL 7.0, SQL 2000, SQL 2005, SQL 2008 and SQL 2008 R2, Cognos, ReportNet, IIS, LAN Browser, Veritas BackupExe, Symantec Security Suite 8.0, MS Project, Visio Enterprise, MS Office 1997, 2000, 2003, 2007 & 2010, Crystal Reports, Visual Basic, SQL Query Language, Visual Source Safe, Fed-Ex Ship Manager, ImageNow, Business Insight, Brainware Distiller

PROFESSIONAL EXPERIENCE:

SQL Database Developer / Administrator

Confidential

Responsibilities:

  • Develop and implement 2008 SSIS Conversion Packages - Major Enterprise Software Implementation
  • Develop and deploy SQL Server 2008 Databases, Tables and Maintenance Plans
  • Develop and deploy in coordination with third party vendors and in-house users: Tables, Stored Procedures, Views
  • Develop and deploy front tier user interface applications for data normalization and conversion (Access)
  • Configure and deploy AP imaging solution from Perceptive Software, ImageNow.
  • Configure and deploy OCR solution for AP imaging solutions, Brainware.
  • Configure ImageNow / Brainware SQL 2008 Database maintenance plans, backups and connectivity.
  • Support .Net Applications and Developers
  • Spec, design and build SQL Server Stored Procedures, Views, Functions and Tables for Crystal Report Requests

SQL Database Developer / Administrator

Confidential

Responsibilities:

  • Develop and Manage ETL of incoming Client Data
  • Migrate Processed Data to Production Environment as QA Process allowed
  • Develop and Enforce Schema Integrity Enterprise wide.
  • Develop and Validate New Processes, Tables, Procedures and Schedules for Existing and New Product Lines.
  • Development and implementation of Database Objects (Tables, Stored Procedures, Views, Functions, Jobs, etc.) as needed per project specifications.
  • Ensure data integrity and consistency.
  • Promotion of all objects into Test and Production SQL Server environments.
  • Develop and maintain SQL Server Jobs and DTS Packages for various SQL and non SQL functions.
  • Trouble shooting / ticket resolution.
  • SQL Scripting.
  • Process automation
  • Create and validate complex algorithms for analysis of Clients Cash flow and resultant Company Cash flow.
  • Develop, create and implements proprietary data modeling software the identify high value records for review.
  • Develop average to complex Stored Procedures for reporting services.
  • Support .Net Applications and Developers.

Sr. SQL Database Developer

Confidential, Dallas

Responsibilities:

  • Development and implementation of Database Objects (Tables, Stored Procedures, Views, Functions, Jobs, etc.) as needed per project specifications.
  • Ensure data integrity and consistency.
  • Promotion of all object into Test and Production SQL Server environments.
  • Development of Scripting Code from Source Safe objects for emergency Database deployment.
  • Develop and maintain SQL Server Jobs and DTS Packages for various SQL and non SQL functions.
  • Trouble shooting / ticket resolution.
  • Deploy reports using Microsoft Reporting Services and Cognos ReportNet v.7 and Cognos V. 8
  • SQL Scripting.
  • Develop SQL Server Performance Monitors and Baseline analysis for server tuning.

Sr. SQL Database Administrator

Confidential, Ft. Worth, Texas

Responsibilities:

  • Daily Administration of health and performance of all Test and Production SQL Servers.
  • Monthly maintenance (Patch and Hot Fixes) for all Test and Production SQL Servers.
  • Promotion of all object into Test and Production SQL Server environments.
  • Development and daily maintenance of Source Safe application for Versioning.
  • Development of Scripting Code from Source Safe objects for emergency Database deployment.
  • Mentor development staff in creating tuned and optimal Stored Procedures, Tables, Functions, View and Triggers.
  • Migrated Production SQL Servers to SAN Environment.
  • On call scheduling for problem resolution.
  • Develop and maintain SQL Server Jobs and DTS and ETL Packages for various SQL and non SQL functions.
  • Trouble shooting / ticket resolution.
  • Deploy reports using Microsoft Reporting Services.
  • SQL Scripting.
  • Develop SQL Server Performance Monitors and Baseline analysis for server tuning.

Contractor

Confidential, Denton, Texas

Responsibilities:

  • Migrate many SQL Server 2000 Databases from aging servers running Windows 2000 to newer, more robust equipment and VM’s running Windows Server 2003 using SQL tools, DTS Packages and DBArtisian.
  • Administration of various web environments using Microsoft IIS
  • Administration of SOAP / Apache Web Services.
  • Promote Web based, Standard and .Net, applications through Testing, Certification and Production environments.
  • Assist with testing and verification of internally developed applications for national distribution.
  • Upgrade third-party applications, such as MaintiMizer.
  • Setup and troubleshoot FusionDX / Python application through Testing, Certification and Production environment.
  • Process daily import on Coldread data into Docuware SQL Database.
  • Develop SQL Server Performance Monitors and Baseline analysis for server tuning.

Network / Database Administrator

Confidential, Dallas, Texas

Responsibilities:

  • Design, Build, and Migrate SQL Server 6.5, 7.0 & 8.0 Databases.
  • Design, Build, and Manage E-Commerce Client / Server OLTP Databases.
  • Migrate Diverse Database Systems to SQL Server Database’s.
  • Create, Tune and Maintain Tables, Stored Procedures, Triggers, Jobs, DTS Packages in SQL Server 6.5, 7.0 & 8.0 Databases.
  • Design, Build, Migrate, Maintain, Test, Tune and Optimize SQL Server Databases with, but not limited to T-SQL, Stored Procedures, Triggers, DTS packages, ETL Functions and Jobs.
  • Web management via Microsoft IIS.
  • Create web base report templates using Crystal Reports for integration into Client - Server application.
  • Create ad hoc reports using Crystal Reports and T-SQL scripts for management.
  • Design and Implement Disaster Recovery strategy for SQL Server Databases using Microsoft and RFC’s Best Current Practice’s (BCP).
  • Estimate space and anticipate growth for SQL Databases and Tables.
  • Design and implement migration from Windows NT to Windows 2000 Active Directory Infrastructure.
  • Design and implement Exchange 5.5 - Migrate to Exchange 2000.
  • Develop proprietary Data Migration (Export / Import) Software package to import into SQL Server 6.5, 7.0 & 8.0 Databases from various data products and / or .txt/.csv files.
  • Develop proprietary Accounting Application for Web Based - Client / Server application using Visual Basic.
  • Convert many Insurance (Health / Life / P&C) companies from outdated technologies to SQL Server 8.0.
  • Develop many Insurance (Health / Life) companies’ user interfaces for SQL Server Databases using Visual Basic.
  • Upgrade, patch, local and remote deployment of SQL Server 6.5, 7.0 & 8.0 Databases.
  • Perform Data mining and data warehousing for SQL Server 6.5, 7.0 & 8.0 Databases.
  • Oversee all aspects of production for an annual payroll of over one billion dollars.
  • Successfully negotiated significant cost reductions with various vendors and utilities.

Technology Consultant

Confidential, Grapevine, Texas

Responsibilities:

  • LAN/WAN Profile: IBM Desktop, SO/HO Network, HP Printers.
  • Develop advertising print work for Small Business Owners.
  • Development and implementation of LAN\WAN architectural solutions for Small Business Owners.
  • Developed Inventory Control system for Small Business Owners.
  • Developed Cost / Retail computation application for Small Business Owners - Restaurants.
  • Migrate various operating systems and applications to Microsoft platforms.
  • Taught basic Microsoft Windows and Microsoft Office classes.
  • Maintain responsibility for developing, administering and monitoring budgets.
  • Build and foster workplace environment conducive to highest level of employee participation.
  • Motivate, train, mentor individuals, providing necessary tools to meet or exceed company goals.
  • Consistent expense reduction through employee productivity and material cost control.

Fleet Licensing Manager

Confidential, Carrollton, Texas

Responsibilities:

  • Process truck rental contracts as received from nationwide facilities where information not previously processed.
  • Monitor branch offices - rental fleet.
  • Track in-service of rental fleet from nation and international chassis manufacturing facilities.
  • Coordinate completion of body fabrication with various nationwide vendors.
  • Register nationwide rental fleet with various state agencies.
  • Ship registration documentation to nationwide rental fleet at in-service locations.
  • Reduced licensing and renewal process from 10 months to 3 months in less than two years.
  • Ensure compliance with I.F.T.A. regulations for nationwide fleet of diesel powered vehicles.
  • Successfully reduced federal fuel tax exposure (I.F.T.A.) for nationwide diesel fuel fleet.
  • Subrogation of Claims.
  • Recovered missing / stolen vehicles nationwide, Mexico, Canada and Hawaii.
  • Travel to nationwide branch offices as needed to assist with fleet issues.
  • Travel to nationwide branch offices to open / close facilities as needed.
  • Assist with fleet disposal when needed.

We'd love your feedback!