Sql Server Database Administrator Resume
5.00/5 (Submit Your Rating)
Atlanta, Ga
SUMMARY
Professional with progressive experience in SQL Server Database Administration, developed over 7 years working on multiple database systems and knowledgeable in SQL server installation, implementation, performance tuning and Database maintenance and security.
TECHNICAL SKILLS
- SQL Server Database Administration (Installation & Configuration).
- SQL Server tools Enterprise Manager, Management Studio, TSQL
- Performance Monitoring and Performance Tuning
- Create Jobs, Stored Procedures, Views & Build Indexes - (Clustered & Nonclustered), Rebuild & Reorganize Indexes and Failover Clustering
- SQL Server Log shipping, Mirroring and PowerShells.
- Database Backups, Migration and Disaster Recovery.
- Database Maintenance- Migration, Restoration & Replication.
- Experience in multiple 3 rd party tools: SQLSentry, SQLProfile, Quest, Spotlight Redgate & others
- Excellent Presentation/Communication skills.
PROFESSIONAL EXPERIENCE:
SQL Server Database Administrator
Confidential, Atlanta, GA.
Responsibilities:
- SQL Server Database Administration (Installation & Configuration).
- Performance Monitoring and Performance Tuning
- Responsible for all General Database Administration functions associated MS SQL Server systems including security, back-up, logging, reporting and recovery procedures.
- Management of all technical aspects of the databases, processes, and systems.
- Manage data import/export to/from multiple sources including non-SQL source systems.
- Assist in improving and maintaining database operational efficiency.
- Perform daily, weekly, and monthly data maintenance tasks.
- Operational monitoring of SQL Infrastructure.
- Performance tuning including hardware and code optimization.
- Assist in client support and setup configurations.
- Assist clients in developing and implementing data systems management processes
SQL Server Database Administrator
Confidential, Seattle, WA
Responsibilities:
- Migration of Databases from SQL Server 2008R 2 /2012/2014.
- Installation and configuration multiple Database Engine Instances
- Knowledge of SQL Server Clustering, Log Shipping and Replication and Migration setup to SQL Server 2012/2014.
- Team player managing tens of databases with a combined capacity of 5TB to 6TB with Database developers.
- Perform physical database analysis and feasibility requirements, involving security and recovery requirements.
- Review daily related reports for database backups, monitoring and maintenance.
- Worked extensively on fine-tuning and troubleshooting of database performance.
- Analyzing, recommending changes for maintenance standards & best practices in all SQL Servers overseen.
- Support databases on virtual environments like VSphere and Hyper-v.
- Modifications of database structures tables and stored procedures, disk configuration and storage allocation support application enhancements.
SQL Server DBA/Support
Confidential, Bentonville, AR.
Responsibilities:
- Engaged in massive Installation and upgrade of SQL Database Severs remotely and standalone environments.
- Hands-on monitoring of all database systems, ensuring secure services with minimum downtime.
- Database creation and Design, performing backups.
- Engaged in Database records recovery efforts.
- Engaged SQL profiler for troubleshooting, monitoring, optimization of SQL Server and SQL Codes.
- Developed and Supported RDBMS.
- SQL Server performance tuning, index maintenance.
Database Analyst/Support
Confidential
Responsibilities:
- Implementation of SQL Logins, Roles & Authentication modes, ensuring security policies for various categories users.
- Importing and uploading of data into SQL Server from MS Access databases.
- Managing and resolving space issues on data, log file drives.
- Creating and managing database objects including tables, views, stored procedures and User defined functions.
- Assisted with security and non-security patches as approved in maintenance schedules.
- Creation of views, table partitioning and creation of databases.
- Performed other duties as assigned by supervisor and management.
- Worked in the team that worked on backlog installations and upgrades of SQL Servers in record time.
- Team lead for managing 20 Servers with capacity of over 5TB, handling tuning and backups hard-drive monitoring of all Servers.
- Spearheaded efforts in improving SQL Server performance, using index tuning wizards, performance tuning methods, execution plans & SQL Profiler.