Senior Database Administrator Resume

SUMMARY

Performing all MS SQL DBA DevOps related tasks (development and operational) for core applications and development.
My strongest skills are in database design, performance and turning, data cleanup and analysis, and disaster recovery.
My tasks include initial installation, upgrades, migrations, design, maintenance (automating), backup and recovery, DTS/SSIS Packages, job scheduling, triggers and stored procedures;
Extensive experience in SQL (T - SQL). I have performed system analysis, logical data modeling, design and implementation.
I have extensive data analysis experience in mapping (ETL, HL7) to internal databases, data cleanup and archiving.
I am very organized, detailed oriented, take ownership of my servers/databases and a team player.

TECHNICAL SKILLS

Database Management Systems: MS SQL 6.5 to version 2014, MySQL, Sybase System 10 & 11, NoSQL

Database Tools: Microsoft SQL Server Management Studio, DBArtisan, Idera Software

Architecture Tools: Erwin, ER Studio, Visio

ADT/HL7: InterfaceWare, ETL, DTS, SSIS

Operating Systems: UNIX, DOS, TSO, OpenVMS, Windows, Task Scheduler

Languages: SQL, DOS, Korn Shell, C Shell

Software: Microsoft Suite, PowerPoint, SQL Compare (RedGate), Visio, WinSCP, Axway, QlikView, EveryAngle, Opalis, CommVault, SSRS, PasswordSafe, Gatherbird, What’s Up Gold, FileZilla

Editors/Miscellaneous.: Xedit, VI, Ted, CRON

PROFESSIONAL EXPERIENCE

Senior Database Administrator

Confidential

Responsibilities:

Supporting 60 MS SQL servers with 400 databases; MySQL - Database size from 1mb to 5TB;
Solo DBA - providing 24x7 support.
Migrated physical SQL servers to virtual servers
Optimizing stored procedures both internal (custom) and vendor owned (application related)
Recommended index on Vendors process - reduced from hours to 5 min
Recommended changes to SP and redundant indexes to improve performance
Redesigned stored procedures - initial run time of 5 min to second
Automated processes from Product Development Application (PLM), apply PLM patches
Automated email of notification of expiring Legal License/Contracts and IT licenses
Consolidated and automated FTP processes - combining DOS and FTP scripting commands.
Support data extracts for QlikView dashboards using EveryAngle for SAP extracts.
Departments request my presence in meeting to provide ideas for thinking outside the box to design database structural or data loading needs.
Set up and maintain tasks in Opalis, WinSCP, Axway, and FileZilla.- including command line scripts
Learning Oracle, SAP BW and general SAP database (Basis) tools and troubleshooting.

Senior Database Administrator

Confidential

Responsibilities:

Optimizing stored procedures both internal (custom) and vendor owned (application related)
Recommended index on Vendors process - reduced from hours to 5 min
Redesigned stored procedures - initial run time of 5 min to seconds.
Extensive experience of designing table, views, stored procedures, and functions.
Post go-live remediation of specific data - vendor did not have programs to reverse their work - I created the tables and stored procedures to handle the request and hit our end-of-year deadline for accounting.

Senior Database Administrator, Consultant

Confidential

Responsibilities:

Development and architecture tasks for Data Warehousing team.
Provide leadership to the DW developers in setting up procedures and policies along with standards for database objects.
Provide leadership in setting environment migration process. Team had no structure in promotion of objects and has seven databases with objects that are different even though they support the same project.
Provide archiving and ETL procedures to avoid large time intensive reloading of historical data.
Given ‘go-ahead’ to take charge in getting the team organized and structured.
Developing reusable code for table and database refresh needs. Team has key tables that they manually loaded data into each time they refreshed the database.

Senior SQL Database Administrator

Confidential

Responsibilities:

Supporting 53 MS SQL servers, 300+ databases, some clustered, Small to 1 TB of data
Stabilized all environment servers (UAT, Dev, QA, Prod) from daily/hourly failures due to poor design and failure notification not established - now less than a monthly issue notification received.
Review data requirements and make architecture recommendations for importing data (Data Warehouse), de-normalize tables for long-term and multiple functionality.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship