Sql Database Administrator Resume
Mclean, VA
TECHNICAL SKILLS
Database: SQL Server 2008, 2012, 2014, 2016
SQL Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Database Tuning Advisor, SQLCMD, Reporting Services Report Manager, Reporting Services Configuration SQL Configuration manager
Reporting/ETL Tools: SSRS, SSIS
Programming Language: Transact - SQL, ASP.net, HTML, C#, C++, CMD, PowerShell
Operating Systems: MS Windows Server 2008, 2012, Windows XP, Windows 7
Monitoring Tools: System Monitor, Counter, SQL Diagnostic Manager by IDERA, Windows Event Logs, Activity Monitor
Other Tools: SSMA (SQL Server Migration Assistant) and ODBC/DB Link, Red-Gate, SharePoint 2010/2013, VISIO, VMware
Methodologies: Agile Scru
PROFESSIONAL EXPERIENCE
Confidential, McLean, VA
SQL Database Administrator
Responsibilities:
- Install and configure different versions of SQL Server in Development, Test, Stage and Production environments.
- Upgrade earlier versions SQL Server 2008, SQL Server 2012 and SQL Server 2016.
- Work with business analyst to deploy databases and manage database availability.
- Rebuild servers when master database was corrupted.
- Develop and apply Disaster Recovery strategies.
- Configure and manage SQL Server Always-On High Availability Groups with multiple secondary nodes.
- Experience on public cloud infrastructures and migration of on-premises SQL server databases into the cloud (Azure).
- Work with developers to tune-up performance of SQL and T-SQL queries.
- Performance tuning & optimization of servers in Production and Test environments.
- Create and manage database security, data encryption and apply object level security.
- Develop Database Maintenance Plan for different business requirements.
- Used DBCC and Alter statements for different database administration tasks such as checking database consistency, reorganizing and rebuilding indexes, updating statistics.
- Used DMV (Dynamic Management View) for different database administration tasks such as backup history, indexes fragmentation levels, statistics and status of different jobs.
- Export & import database objects from/to Oracle, MySQL, Access Database, flat files (text, excel, and CSV files) and MS SQL Server.
- Experience in using SSIS/DTS, BCP to import & export data from flat files, excel, MS Access, and other OLEDB databases to MS SQL Server databases.
- Working experience with SAN and RAID.
- Providing customer support, dealing with non-technical and upper level management.
- Experience in providing end-user support on a day-to-day basis.
- Provide 24x7 supports for critical production systems.
Confidential, Bethesda, MD
SQL Database Administrator
Responsibilities:
- Installed, Configured, and Managed SQL Server 2008 R 2/ 2012/2016.
- Performed regular database maintenance tasks such as rebuilding indexes, update statistics, database integrity check, storage management, monitoring performances.
- Applied Hot Fixes, Patches, Cumulative Updates, Service Pack, Service Pack), Upgrades.
- Managed Backup and Recovery systems based on RTO and RPO, use Native SQL server Backup/Recovery Tools, Red Gate SQL Backup Pro.
- Refreshed database from production and attach the database from data file when needed.
- Created and manage database security, data encryption and apply object level security.
- Implemented SQL Server Always-On High Availability Groups with multiple secondary nodes.
- Applied patches and CUs on Always-On Availability group replicas in production and non-production environment.
- Worked on public cloud infrastructures and migration of on-premises SQL server databases into the cloud (Azure).
- Designed high availability architecture for database availability.
- Maintained performance tuning and optimization of servers in Production and Test environments.
- Used Activity monitor, Wait stats, Stored Procedures, DMV, DMF, SQL Profiler, Extended Events, Error log, Windows Performance Monitor to find out health and performance problems for the servers.
- Wrote automating database maintenance processes and monitoring using T-SQL scripts.
- Worked on query optimization and tuning using Database Engine Tuning advisor, Activity Monitor and analyzing Execution Plan.
- Performed research into database performance issue and come up with solutions to address those concerns.
- Enjoyed working in a team environment and independently as well.
Confidential, Tampa, FL
SQL Database Administrator
Responsibilities:
- Installed, configured, and managed SQL Server 2008/2012/ 2014/2016 in Development, Test, and Production environments.
- Ensuring system availability, data integrity; monitor/troubleshoot backup and recoveries, performance, disk space, and network connectivity.
- Coordination with the team, providing technical assistance, support to system operations staff and end-customer client organizations.
- Handled common database functions, such as upgrade, backup, recovery, and migration.
- Resolved, troubleshoot database issues, and performed upgrades, conversions and deployments.
- Proactively monitored the production database(s) and optimize stored procedures for better performance. Resolved locking conflicts and resource utilization.
- Written automating database maintenance processes and monitoring using TSQL scripts.
- Provided project database consulting including query analysis, and database implementation.
- Refined and automated regular processes, track issues, document changes.
- Assisted developers with complex query tuning and schema refinement.
- Implemented SQL Server ALWAYSON High Availability groups with two secondary nodes.
- Performed scheduled maintenance and support release deployment activities after hours.
- Configured and Maintained; Log shipping, Mirroring, Replication as part of a high availability solution.
- Exported & imported database objects from/to Oracle, Access Database, flat files (text, excel, and CSV files) and MS SQL Server.
- Installed, configured, and Managed SQL Server Reporting Services (SSRS).
- Generated Report using SSRS (SQL Server Reporting Services).
- Responsible for creating, modifying and managing tables, Index (Cluster/Non-Cluster).
- Monitored Server Activity, Error Log, space usage, and solving problem as needed.
- Managed and resolved trouble tickets (Remedy) for database-related issues submitted.
- Designed database backup and restore plan, recovered database from back up in disasters, implement point in time recovery solutions.
- Created database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting.
- Written SQL queries, Triggers, Functions, creating Tables, Views and Indexes.
- Audited and generated monthly management reports using third party tool.
- Created the database, tables, table spaces, data objects, setting privileges, indexes, user login and password (Security).
- Provided 24x7 supports for critical production environment.