MSSQL Database Administrator Resume

SUMMARY:

Leveraging technical acumen, resource management, and problem solving expertise to design, manage, and maintain database systems and networks on multiple platforms in complex computing environments. Provides user support for software and hardware issues and oversees system/application configuration.

CORE COMPETENCIES:

MS SQL SQL Server MS Exchange ETL SSIS Visual Basic ASP AS/400 DTS SSRS PeopleSoft Idera SQLSafe Idera SQL Diagnostic Manager SQL Profiler

PROFESSIONAL OVERVIEW:

Confidential

MSSQL Database Administrator

Responsibilities:

Troubleshoots and develops new SSIS/ETL processes; fine tunes performance for SSIS packages.
Designs table structures for storing loaded data and indexing structures.
Crafts store procedures for maintenance and data manipulation to assist data loads.
Manages over 100 SQL Servers as part of a team of DBA's, including automating maintenance, monitoring and troubleshooting performance, backups and developing/enhancing monitoring software for those servers.
Analyze and manage security issues for SQL Servers, such as permissions schema and weaknesses.
Manages SSRS servers.
Writes SSRS reports for regularly gathered metrics and details for the SQL Servers on the network.
Troubleshoot, maintain, and modify legacy data loading processes for the SQL Servers utilizing Windows Script Host, VBScript, and JavaScript.
Analyze data to diagnose data problems with automated data loads using any combination of SSIS, VBScript, JavaScript, and batch language.

Confidential

SSIS ETL Developer

Responsibilities:

Troubleshoots and develops new SSIS/ETL processes; fine tunes performance for SSIS packages, including re - architecting the DB structure used for those processes.
Designs table structures for storing loaded data and indexing structures.
Crafted store procedures for maintenance and data manipulation to assist data loads.

Confidential

MS SQL Server Database Administrator

Responsibilities:

Automated maintenance on SQL servers for backup, re-indexing, and data integrity checks; added the ability to e-mail database administrators if system registered performance issues.
Installed clustered SQL servers on Windows operating systems.
Formulated plans for enterprise-level management of SQL server infrastructure.
Analyzed existing inventory reports and developed new template with SQL reporting services.

Confidential

MS SQL Server Database Administrator

Responsibilities:

Advised on data integrity, risk assessment, and general maintenance procedures.
Guided senior management on the technical evaluation of helpdesk software.

Confidential

Database Administrator

Responsibilities:

Utilized native tools, custom scripts, and third-party applications to create backup strategies, oversee database maintenance, and plan disaster recovery strategies.
Employed NAS and SAN technologies to ensure redundancy in a remote data recovery center.
Setup reporting services web servers and wrote reports in SSRS.
Evaluated and troubleshot performance problems and oversaw system development, testing, and production.
Upgraded PeopleSoft application, migrating PeopleCode objects between environments and provided Web Logic and Tuxedo administration for a company with more than 15,000 employees.

Confidential

Network Manager

Responsibilities:

Handled software and hardware troubleshooting and problem resolution for LAN/WAN setups; provided application design and development using Visual Basic, ASP, web, and intranet technologies.
Worked with telecom vendors to order and track leased-line installation for local and remote offices.
Managed and maintained DNS servers and the company Exchange server, including e-mail accounts, server recovery, and e-mail connectivity for 100+ onsite and remote users.
Assisted the development team in solving connectivity, security, and programming issues.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship