SQL Server Database Administrator Resume Fairfax, VA - Hire IT People

TECHNICAL SKILLS

Operating Systems: Microsoft Windows Server 2012R2, 2016.

Database Management: Microsoft SQL Server (2008 - 2017), Microsoft SharePoint.

Database & SQL Server Tools: Data Tools (Visual Studio), Management Studio, Database Diagram, Activity Monitoring Tool, SSAS (SQL Server Analysis Service), Microsoft Power-BI with SSRS (SQL Server Reporting Service). New Query (T-SQL), DBCC, DMV, ETL (Extract Transform and Load SQL Server Integration Service), SSMA - SQL Server Migration Assistance, Database Mail & Alert/Notification.

Other Relevance: SQL Server Activity Monitoring, Native Client (ODBC, OLEDB), SQL Server Profiler, Database Engine Tuning Advisor, Data Tools (Visual Studio), Management Studio - Database Diagram - Activity Monitoring Tool, SSAS (SQL Server Analysis Service), Microsoft Power-BI with SSRS (SQL Server Reporting Service), Service Manager, NetBackup, Tape backup.

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator

Confidential, Fairfax, VA

Responsibilities:

High Availability (currently monitoring and maintaining clustering, replication, mirroring with AlwaysOn environment).
Daily performance monitoring and troubleshooting performance Database and Server level.
Utilized ETL packages using SSIS, Visual Studio/Data Tool for building, developing and deploying them and creating automated task or job with using SQL Server agent or other native tools
Configured SQL Server Reporting Service, creating, built reports for the management and managed security, granted role base permission for the users
Working and supporting various groups and team for SQL Server 2012-2017, managing, installing and configuring on Windows Server 2012R2/2016 environment in where Windows Failover Cluster &AlwaysOn High Availability solutions have been using.
Managing account, creating login, mapping users for database and server level access as needed.
Working day to day to manage security; manage windows authentication and SQL Server authentication login/user as require.
Supporting end-users, customer.
Installing SQL Server and Management tools for users.
Helping with deployment, developing report, creating/developing enterprise dashboard reports by using ETL tool (SSIS), SSRS and Report Builder.
Creating, modifying SQL Server Agent jobs, alerts and Database Mail.
Mapping, granting permission on SQL Server based on role.
Working on deployment, backup plan and disaster recovery plan.
Supporting and helping users for mortgage application for reports and dashboard report on weekly and monthly.
Writing T-SQL as needed for inquiry purpose.

Remote Database Administrator

Confidential, Boston

Responsibilities:

SQL server 2008, 2008R2, 2012, and 2014 installation, configuration and managing on Windows Server 2008R2 and 2012 platforms.
Performance monitoring and Tuning for Systems and Database level
Index rebuild, reorganize based on fragmentation level, SQL Query tuning by using database tuning advisor.
Backup and Restore planning- Point-In-Time recovery plan, automatic backup maintenance with proper retention policy and disaster recovery planning without data loss.
Reporting, creating packages, upgrading and migration.
Security Management - managing end users, logins, creating, mapping SQL users, application users, grant permission as role based, apply security patches, service packs and other updates as advertise.
Database Encryption - TDE (transparent data encryption) for protecting data with AES and 3DES encryption keys without changing existing applications.
Work in various teams as good team player and support deployment, web team and work with developers for code view, database design diagram etc.

DBA and User Support

Confidential, Mclean, VA

Responsibilities:

Worked on various databases that are managed by Share Point (Content and Management databases)
Developed database maintenance plan (for various platform- automated and on demand)
Migration/Upgrading - Performed database migration from Access and MySQL to SQL Server 2012 and upgraded SQL Server 2008 to 2012.
Documentation - Created documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices
Applied Service Packs patch, cumulative and hot fixes

Remote Database Admin

Confidential, Manhattan, NY

Responsibilities:

I provided production support for database management systems, deliver quality project support to development teams.
I ensured the recoverability of all production data for operational and business continuation needs. Provided performance monitoring and tuning, improved the quality and reduced defects in all database environments.
I had worked with other partners to optimize the performance and efficiency of the database structures and data access.

We provide IT Staff Augmentation Services!

Sql Server Database Administrator Resume

Fairfax, VA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship