We provide IT Staff Augmentation Services!

Sql Developer Resume

3.00/5 (Submit Your Rating)

Troy, MichigaN

SUMMARY:

Offers over 15 years of database administration. Primary focus on high availability, development, performance, disaster recovery and audits.

AREAS OF EXPERTISE:

MS SQL Server DBA, TSQL Development, Backups and Recovery, Performance Improvement, Process Improvement, High Availability, Clustering, Mirroring, Log Shipping, ETL, SSIS, SSRS, ERD, Problem Solving, Legacy Data Migration, Technical Support, Accounting, Inventory Control, Mentoring.

TECHNICAL SKILLS

  • SQL Server 2000 - 2017 administrator
  • T-SQL
  • replication clustering
  • log shipping
  • mirroring
  • high availability
  • DTS/SSIS/SSRS
  • stored procedures
  • triggers
  • functions
  • indexes
  • maintenance
  • disaster recovery
  • security/access/auditing
  • execution plans
  • performance tuning
  • mentoring
  • management
  • relational database design
  • modeling
  • business rules and processes
  • process improvement
  • connectivity
  • Red-Gate tools
  • Tableau
  • Task Factory
  • Microsoft Office
  • Windows Server OS
  • RAID
  • SAN.

PROFESSIONAL EXPERIENCE:

Confidential, Troy Michigan

SQL Developer

Responsibilities:

  • data extracts using SSIS, SSRS and SQL Server database objects for Confidential fund management.
  • Assisting in index performance and general issue troubleshooting from daily production.
Confidential

Database Administrator

Responsibilities:

  • Managed thirty - seven (37) MS SQL Servers at 3 facilities including 319 databases, 26,000+ tables, 57,994,085,358 records with the largest database containing 3,925,114,269 records. SSIS/DTS packages, security, performance monitoring, capacity planning and tuning as well as application tuning, alerts, TSQL, maintenance and regular interaction with development, customer support and operational staff and management.
  • Total physical data storage 10tb with an additional 9.6tb of index space.
  • Created audit system for tracking access to database servers and DDL commands.
  • Process improvement of business rules contained within SQL Server.
  • Created source control of database objects within SQL Server.
  • Designed and created security access system for 24 hour service and audit logging for forensic analysis.
Confidential

Database Administrator

Responsibilities:

  • Use of meta-modeling
  • Responsible for Backup Exec backup plans and tape rotation.

Assistant Director of Information Technology

Confidential

Responsibilities:

  • Managed SQL Server 2000 cluster including all performance tuning, disaster recovery, legacy data migration, security and architecture. Served as Senior VB Developer. Oversaw the operation of a data library (RAID) with 300 gigabytes of document images. Maintained a USPS database of 32 million records.
  • Coordinated the implementation of RightFax for automated fax noticing.
  • Migrated Legacy data, facilitated network functions, provided special queries for statistical reporting to administration, and researched software packages for integration into court automation systems.
  • Designed, wrote and implemented Docview/RACER document imaging system. The program had developed into the basis for a new case management system.

We'd love your feedback!