SUPER RESUME
< Back
Edit this resume to make it your own!

Your Name

Database Administrator

Stockbridge, GA

your.email@example.com
111-222-3333
www.your-website.com

Summary

I am a core production MS-DBA with over 10 years IT Technical experience. I have been in the business of managing MS SQL Server databases for the last 3 years. As a MS-SQL database administrator (DBA), I am responsible for the configuration, upgrade, administration, monitoring and maintenance of physical SQL databases. I am also responsible for the development and design of database strategies, monitoring and improving database performance and capacity planning for future expansion requirements. I plan and implement security measures to safeguard various production databases. I am experienced in designing and implementing Extract, Transform, Load (ETL) operations using Microsoft SQL Server Integration Services (SSIS). 
 
Core experience: 
 
Data Migration Disaster Recovery Integration Services Performance Tuning Reporting Services Database Upgrades patches 
Backup and Recovery Database Security High Availability Solutions

Work Experience

Database Administrator

Join Group Consulting,

Jan 2012Current

Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.
  • Knowledge of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, System SPROCS).
  • Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery, clustering, index maintenance, in a very large, high-transaction volume and fast-paced environment.
  • Creating and maintaining various databases on production/development servers and provide 24 x7 support
  • Configuring Log shipping from Production to Disaster Recovery server.
  • Development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification, replication verification, and indexing updates.
  • Designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
  • Identifying, testing and resolving database performance issues to ensure data optimization.
  • Using tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
  • Implementation of system wide security policies and trouble shooting.
  • Installations of SQL Server 2008/2008 R2 and 2012 on Development and Production.
  • Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
  • Deploying, developing and scheduled SSIS packages.
  • Setting up Failover Clustering in SQL server 2008 (Active/Passive)
  • Migrating SQL Server Databases from Development to Production Server.
  • Managing Login and User: adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.
  • Creating Jobs, Alerts, and SQL Mail Agent
  • Configuring and supporting SSIS and SSRS for SQL Server 2005 and 2008 R2.
  • Design, implement, and administered of MS SQL Server database solutions.
  • Responsible for improvement and maintenance of the databases to include release rollout and upgrades and application of patches.
  • Using Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) and Extract, Transform, and Loading (ETL) tool of SQL Server to populate data from various data sources.
  • Creating packages for different data loading operations for application.
  • Scheduled full and transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.

SQL Server Database Administrator

Inverse Tech,

Mar 2009Dec 2011

Proactively performed DBA duties including: database backups, restores, performance tuning, and capacity analysis.
  • Performed DBA duties including: space management, database security, copy/ modification creating databases in all environment, troubleshooting defragmentation of objects and databases.
  • Managed the products and development, test and production databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
  • Troubleshoot databases and custom application issues for OLTP systems.
  • Work with end users to define, implement, and maintain their reporting requirements.
  • Participated and coordinated the creation, modification and maintenance of database structures with minimal supervision.
  • Assisted in the design, coding, testing and implementation of SQL databases instances
  • Took an important role in a critical situation of restoring a corrupted database from a point in time with zero loss of data
  • Resolving tickets in compliance with meeting clients SLA and having effective communication with client customers in resolving all SQL issues.
  • Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code.
  • Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis.
  • Generated the weekly, monthly, and quarterly report by using SQL Reporting Services.
  • Developed, modified, and optimized regularly used stored procedures, triggers to handle complex business rules, history data and audit analysis.
  • Designed and implemented SQL Server 2005 databases for mission-critical business.
  • Developed and optimized stored procedures, triggers, and SSIS packages.
  • Troubleshoot databases and custom application issues and provided 24x7 support.
  • Developed and created stored procedures, advanced queries, triggers, views, indices, and functions for databases.
  • Work with end users to define, implement, and maintain their reporting requirements.
  • Develop and maintain SSIS packages for database maintenance tasks such as index maintenance as well as database, agent jobs and login migration.
  • Participated and coordinated the creation, modification and maintenance of database structures with minimal supervision.
  • Assisted in the design, coding, testing and implementation of high volume transactional (OLTP) SQL databases instances.
  • Wrote, evaluated and optimized SQL codes, stored procedures and scripts for maintenance and reporting purposes.

Consultant/Project Manager

Metro Information Services,

May 2005Feb 2009

Responsible for the delivery of solutions for projects managed through communication to all resources engaged in project (i.e. customers, internal and senior management).
  • Defined roles of teams and assigned and delegated milestones and timelines, liaising with customer and internal resources to eliminate obstacles to ensure a quality solution.
  • Defined technical requirements produced estimates and created project plans.
  • Identified and tracked project issues and resolutions.
  • Provided change management and strategic management direction during projects.
  • Created project documentation and coordinated handoff between all appropriate internal and external departments.
  • Coordinated and lead project meetings to include defining and managing to a set agenda.
  • Summarized meeting results in writing to internal and external customers including follow-up items.
  • Tracked outstanding action items resulted from meetings.
  • Established mutually agreed upon measurements of success as indicators of project performance and deliverables.
  • Assisted with transition of technical support to post-implementation support group to ensure projects were supported effectively.
  • Proficient use IT packages and tools including but not limited to Microsoft Office, Project Management tools and reporting tools.

Project Manager

Federated Systems Group,

Mar 2002Apr 2005

Responsible for the coordination of the building, testing, validating and implementing of system wide application changes to the Enterprise Data Warehouse (EDW) for several releases.
  • Conducted data mapping sessions of the data being extracted from mainframe systems and loaded to the Teradata box.
  • Worked with end users to define, implement their reporting requirements from data extracted from each system loaded to the EDW.
  • Created and tracked project plans for each phase of the system life cycle (SLC) utilizing Microsoft Project.
  • Established and maintained critical business relationships with management on the reporting of project statuses.
  • Coordinated and facilitated meetings for projects managed across multiple workgroups as part of the Project Office team.
  • Tracked and escalated project issues and resolutions during project.
  • Participated in 24/7 on-call duties during project implementation releases.

Enterprise Data Warehouse Supervisor

Federated Systems Group,

Jan 2001Mar 2002

Lead team of technical system analysts through the loading of data to the Teradata EDW from development to production.
  • Created project life cycle documentation, (design, build, test/validation) utilizing Microsoft project plan.
  • Executed and monitored project plan task with the ETL teams to ensure timely execution of all phase of the SLC to the EDW.
  • Coordinated and facilitated weekly team meetings to track progress of the teams' EDW Load task.
  • Responsible for tracking and reporting team task status to EDW Project Office project plan during weekly Project Office meetings.
  • Tracked issues and resolutions throughout each phase of SLC for each release and provided contingence plan.
  • Assisted manager with input into the teams' performance evaluation process.
  • Participated in 24/7 on-call duties of production.

Education

Bachelors of Science in Business Administration

University of Florida, Gainesville, FL

Diploma in Computer Programming Technology

DeKalb Technical Institute, Clarkston, GA

Additional Information

Skills Summary:
  • Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
  • Knowledge in troubleshooting and problem solving of MS SQL database Servers.
  • Experienced with the design, implementation, and administration of MS SQL Server database solutions.
  • Responsible for improvement and maintenance of the databases to include release rollout and upgrades.
  • Knowledge in managing multiple MS SQL 2005, 2008, 2008 R2 RDBMS as backend for web-based, transactions.
  • Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery, clustering, index maintenance, in a very large, high-transaction volume, and fast-paced environment.
  • Knowledge with setup and administration of SQL Server database security environments using profiles, permissions, and roles.
  • SQL Server Replication
  • Knowledge in working with merge and transactional replication.
  • Proficient in use of tools like SQL Server Profiler and Windows Performance Monitor.
  • Knowledge in configuring and supporting SSRS for SQL Server 2005 and 2008 R2.
  • Proficient in performance of SQL Server software new installation and upgrades.
  • Proficient in Backup/recovery strategies implementation.

Skills Summary 'd):
  • Proficient in maintaining and supporting SQL Server transactional and merge replication.
  • Expert in reviewing overall physical database structure for overall stability.
  • Proficient in use of tools like SQL Server Profiler and Windows Performance Monitor.
  • Experience using PowerShell (Windows and SQL Server).
  • Experience configuring and supporting SSRS for SQL Server 2005 and 2008r2.
  • Have good understanding of Disk and Server configuration for SQL Server.
  • Experience with network connection tuning using SQL SERVER 2005.
  • Development database support (SQL, T-SQL tuning, Application tuning etc).
  • Proficient in SQL SERVER 2005, 2008 and 2008r2 database cloning.
  • Proficient in data conversions, scrubbing and ETL using DTS and SSIS packages.
  • Experience with SAN from the workgroup servers to the enterprise servers, providing the computer applications and database resources necessary to drive the data.
  • Experience with monitoring and troubleshooting 24x7 operations.

Technical Skills Summary:

Programming Languages: T-SQL, PowerShell
RDBMS: MS SQL SERVER /2005/2008/2008R2; Microsoft Access; Microsoft Excel
Operating Systems: Windows 2003/2003R2/2008/2008R2 Server, Windows 95/98/2000/NT/XP/VISTA/7/8
Data Migration: MSDTS, SSIS, BCP, Import/Export Wizard, Bulk Load
TOOLS: Spotlight on SQL Server, Foglight for SQL Server, SQL Sentry, Idera, Redgate,
Litespeed, PowerShell.
Resume Builder | Resume Templates | Resume Examples | About Us | Privacy Policy | Terms of Use | Help Articles | Contact Us
Super-Resume.com © 2013-2017