Database Administrator Resume
Arlington, VA
PROFESSIONAL SUMMARY:
- MS SQL Server DBA with 5 years experience looking for a SQL Server database administrator position
- Extensive experience in installation, configuration, upgrading, migration, backup and disaster/recovery, performance tuning, high availability solutions, security, and data transformation in MS SQL Server environment.
TECHNICAL SKILLS:
Database ( RDBMS): SQL Server 2008, 2008 R2, 2012, 2014, MS Access,
SQL Tools: SQL Server Management Studio, Upgrade Advisor, Query Analyzer, SQL Profiler, Database Tuning Advisor, Index Tuning Wizard, SQLCMD, SQL Configuration Manager, and SQL Server Data Diagram
High availability: SQL clustering, always on availability, mirroring, log shipping, replications
ETL Tools: SSIS
Reporting: SSRS (SQL Server Reporting Services/Server)
Operating Systems: Windows server 2008/2012, Active Directory, VMware, Cloud Computing
Web Application: SharePoint Enterprise
Web Server: IIS 6.0
Monitoring Tools: System Monitor, Counter, Windows Event Logs, Activity Monitor, DMV, Idera
Other Tools: SQL Server Migration Assistant, ODBC/DB Link, Toad Data Modeler, Redgate
PROFESSIONAL EXPERIENCE:
Confidential, Arlington/VA
Database Administrator
Responsibilities:
- Installed, Configured & Maintained SQL Server 2008, 2008R2,2012 on standalone and clustered Servers
- Successfully upgrade and apply service packs, patches
- Migrated databases from My SQL and Oracle to SQL Server
- Implemented periodic security controls to manage database users and their appropriate level of permission and data encryption
- Extensive knowledge in documenting and implementing database backup and recovery for DR solutions and point - in-time recovery
- Automated daily database refreshes from production on-demand database refreshes from Production to Test environments involving different versions of SQL Server
- Created and modified database structure using Data Definition Language (DDL) statements to create tables, indexes, store procedures, functions, views and trigger
- Manage very large databases (VLDB)
- Table partition to improve I/O access
- Importing and exporting data between SQL Server and other sources such as Flat file, CSV file, Oracle, My SQL, Access, ODBC/OLEDB data sources, etc. using SSIS and Import/Export Wizard, BCP
- Generated reports using SSRS (SQL Server Reporting Services) and deployment, managed reports and managed reports security
- Experience in creating and maintaining High Availability solutions including Database Mirroring, Log Shipping, and Replication (transactional replication)
- Monitored and scheduled automation jobs using SQL Server Agent and maintenance plan
- Configured Database Mail, Operator, notifications to send and receive database related information
- Monitored databases for optimal performance and diagnosed performance problem using SQL Profiler, Wait Stats, DMV’s (Dynamic Management View), Activity Monitor, Extended Events, Error log, Windows Performance Monitor
- Identified and Optimized poorly-performing queries to improve system performance
- Used SQL execution plan to find the cost and running process for TSQL code and optimized poorly written code
- Developed script to find missing indexes, unused indexes and duplicate indexes and created appropriate indexes to optimize slow running queries
- Rebuilding / monitoring the indexes at regular intervals for better performance.
- Troubleshoot day-to-day problems encountered on Production and Non-Production environments
- Run various DBCC commands to checks database consistency
- Ability to work independently and in a team environment
- Available On-call support to ensure database operations
- Check ticketing system and work on requests as a Production DBA.