Sql Server Database Administrator/database Analyst Resume
Mclean, VA
SUMMARY
- I am looking for a very challenging role as a SQL Server database administrator where I can use my talent and skills for the fulfillment of the company’s mission and vision, and where the same talents and experiences are nurtured and appreciated.
- I have excellent ability to develop, maintain and implement the SQL Server database and Microsoft Technologies.
- Windows Failover Clustering, AlwaysOn High Availability Group and High Availability solutions (Mirroring, Log - shipping, Replication)
- Microsoft SQL Server Administration and Database Maintenance
- SQL Server Performance Monitoring, Tuning and Troubleshooting and Data Migration
- Production, Development, Test and web/application base support DBA
TECHNICAL SKILLS
Operating Systems/Platforms: Windows Server 2003, 2008R2 and 2012R2, Windows 7/8/10, VMware, AWS, Cloud Computing.
Databases (MSDBS): Microsoft SQL Server 2008/2008R 2/2012/2014/2016
SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio, Enterprise Manager, Query Analyzer, Performance Monitor, Database Tuning Advisor, DTS, Log Shipping, Server Network Utility, SQL Profiler, Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS), Database Mail, Alert, Notification, SQL Server Management Studio, SQL Server Agent, NetBackup, PowerShell, SharePoint, TFS, AppDetectivePRO.
Report Tools: MS Reporting Services (SSRS), Report Builder (configuring, managing, creating and deploying reports).
Data Migration: SQL Server Integration Service (SSIS), BCP, Data Migration, SQL Loader, Import/Export Wizard, SSMA (SQL Server Migration Assistance).
Database Modeling & Other Tools: Visio, Database Diagram, Redgate (tool belt) Application Manager, Service Manager
PROFESSIONAL EXPERIENCE
Confidential, Mclean, VA
SQL Server Database Administrator/Database Analyst
Responsibilities:
- Installed, Configure and Maintain Fail-Over Clustering using SQL Server 2014/2012/2008 R2/ Windows Server R2 environment.
- Install Configure and Maintain Database Mirroring using automatic fail-over option in, High Safety/High Performance, AlwaysOn High Availability Group technology on MS SQL 2012, 2014. Participating in migration and consolidation of SQL Server databases.
- Assisting in operational activities of database platforms that include financial, retail banking and mortgage department. Implementing performance tuning and assisted in system troubleshooting. Providing technical support for all components of major databases. Conducting data modeling and designed relational databases.
- Database security Administration. Protecting database integrity. Managing access controls and adequate segregation of duty, user access management i.e. creating and granting user access and roles, apply patching, updates, service pack and STIG.
Confidential, Reston, VA
SQL Server Database Admin
Responsibilities:
- Prepared and executed database maintenance plans. Production, development and testing platforms support DBA. Implemented maintenance jobs for data optimization.
- Updated database statistics and maintained SQL Server security. Executed backup strategies and assisted in scheduled backups. Resolved performance issues relating to critical databases. Formulated disaster recovery strategies such as replication.
Confidential, Baltimore, MD
User support specialist and Database Admin (DBA)
Responsibilities:
- Installed and Upgraded from SQL Server 2008 to SQL Server 2012 on Various Production Performed SQL Server 2008/2008 R2/2012 including database backup\restores, Transparent Data Encryption (TDE), and configurations to conform to DISA STIG’s. Installed, maintained and updated SQL Server Service Packs on VMware virtual servers.
- Documented SQL Server instances, builds, SOP’s, Migration.
