Sql Database Administrator Resume
Fairfax, VA
PROFESSIONAL SUMMARY:
- Highly motivated, tech - savvy and certified SQL DBA with strong experience in SQL Server Database Administration Data Modeling, Advanced Installation/ Configuration, Backup/Recovery, Upgrade, Migrate, Service Pack (SP), SQL/T-SQL, Stored Procedure, Trigger, DMV, Replication, Mirroring, Log shipping, Clustering, Always On and other related technologies of SQL Server (2000, 2005, 2008, 2008R2, 2012, 2014, 2016), ETL Development & Management, Report Development and Management including experience with third party tools such as Toad Data Modeler, ERWin, Idera, RedGate, Solarwinds and IIS Web Server - Application deployment and management.
- Eager to learn new skills, quick learner, exceed expectation; possess effective communication, multi-tasking, prioritizing skills and dependable seeking for SQL Server DBA job.
- Creative, motivated and highly competent
- Have the ability to adapt to changing environments
- Can work with little or no supervision
- Effective team player and quick learner
- Endowed with problem solving abilities
- A very good foundation, knowledge and working experiences as Database Administrator of MS SQL Server (2000, 2005, 2008, 2008R2, 2012)
- Strong work experience and knowledge with SQL Server Standby/Replication, Log shipping, Clustering, Always On, Performance tuning, Backup/recovery, Query Optimization and Security Management
- Worked on multiple Database design project - Conceptual, Logical, and Physical Data Model
- Tools used ERWin and Toad Data Modeler
- Installation, Configuration and Management
- Developed, Deployed and Managed Reports and report server using SSRS (SQL Server Reporting Services)
TECHNICAL SKILLS:
Operating Systems: Strong knowledge and working experience on Operating Systems (O/S) Windows Server 2012 R2, 2008 R2, 2003 R2 and 2000 Advanced Sever VMWare - Installed, Configured, and Managed SQL Server in VMware Environment Active Directory Domain Server
Programming: T - SQL: SQL, TSQL, Stored Procedures, Triggers and managed applications in .NET and ASP.NET R programming for data analysis and visualization Beginner in Python programming Basic idea about FORTRAN and SAS programming language
Office Products: Word processing: MS Word and Google Docs Spreadsheets: MS Excel and Google Spreadsheets Microsoft Power Point
PROFESSIONAL EXPERIENCE:
SQL Database Administrator
Confidential, Fairfax, VA
Responsibilities:
- Installed, Configured, and Managed SQL Server 2014, 2012, 2008 R2 in development, test, UAT and production environment
- Responsible for analyzing, recreating and resolving client reported problems in complex software.
- Communicating with engineering, quality assurance and other support teams as well as other department to facilitate problem resolution
- Installed, Configured, and administered SQL Server Reporting Services (SSRS) in SQL Server 2012, and 2014
- Developed, Deployed Reports, managed reports and Report Server including applying SP, Upgrade/Migrate
- Developed Ad-hoc Reports using Report Builder 3.0, 2.0Upgraded SQL Server databases and Instances from lower to higher version such as from 2000, 2005, 2008 R2 to 2012 and 2014
- Database Migrated (testing and production environment)
- Migrated MS Access databases, Oracle 10gR2/11gR2 and MySQL databases to SQL Server 2012 and 2014
- Worked on Database Redesign Projects to make modifications of the existing design and generated E-R Diagram including adding constraints, views, keys and so on
- Applied SP (Service Pack) and HOT Fixes on SQL Server Database Servers
- Strong on database Monitoring and Performance tuning
- Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
- Monitor SQL Server Error Log, space usage