Sql Dba/database Engineer Resume
Washington, DC
SUMMARY:
Microsoft certified SQL Server DBA with over 6 (six) years of experience of database administration, server and database security management, encryption, database Migration, Hands - on experience installation, backup restore, index tuning, performance tuning, automation, SSIS, SSRS, managed HA/DR Solutions including Log Shipping, Mirroring, Replications, Always On Availability Groups and SQL Server failover Clustering. Experience on azure cloud data migration from on-premises to azure sql database, managed Instance, azure active directory, Networking, Vnet, NSG, deploying VM, infrastructure code development (ARM) template, storage account, VM Snapshot and so on
SUMMARY OF EXPERTISE:
- Administered SQL Server High Availability and Disaster Recovery strategies
- Performed Azure Database Administration, and Development
- Experienced in managing and upgrading High Availability solutions
- Expertise in MSSQL Database Administration in server configuration, monitoring, performance tuning and maintenance with efficient troubleshooting capabilities
- Strong technical ability to perform business analysis, write effective documentations and specifications
- Wrote T-SQL, stored procedures, triggers and functions
- Performed ETL operations using SSIS, and DTS and developed ETL packages using BIDS and SSDT tools
- Performed Logical and Physical Data Modeling
- Experienced in using DMV for performing different types of tasks
- Performed SQL Server Backup/Recovery and Disaster Recovery solutions
- Experienced on SQL Server 2016 upgrade (in place and side/side) from SQL Server 2012 / 2008
- Worked on SQL Server 2016/2014 database migration from SQL Server 2012/2008.
- Maintained individual and group service accounts for SQL Server security
- Familiar with Data Center servers and handling VLDB databases
- Performed Import, Export, Backup, Database Monitoring tools and Application support
- Implemented Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g
- Strong knowledge in Integration Services (SSIS) and Reporting Services (SSRS)
- Working knowledge in Data Encryption and Data Decryption for data security
- Experienced in mentoring, coaching and writing documentation
TECHNICAL SKILLS:
Database: Azure SQL Database, SQL Server 2017, 2016, 2014/2012/2008 R2
Operating System: Windows Server 2016, 2012/2008 R2/2003 R2 including Windows XP/7/8, VMware, Active Directory
Languages: SQL, T-SQL, HTML, XML, PowerShell, Az-Module, CLI
ETL Tools: Native Tools (SSDT, BIDS, DTS and SSIS)
Reporting: SSRS (SQL Server Reporting Services) in HTML, Excel, Text
Data Modeling: ER win, Toad Data Modeler, SSDD (SQL Server Database Diagram)
Third-Party Tools: Idera, SQL Sentry, Red Gate, Logic Monitor, Dynatrace, ServiceNow.
Virtualization: V-Spare, VM Ware, Hyper-V, Virtual Box
Cloud: MS Azure
PROFESSIONAL EXPERIENCES:
SQL DBA/Database Engineer
Confidential, Washington, DC
Responsibilities:
- Created VM, Storages, Databases in Azure SQL Database
- Migrated SQL Server Databases from On-Premises to Azure SQL
- Performed backup, setup jobs
- Created and Managed Security
- Performed Azure Database Administration, and Development
- Installed, Configured, and Administered SQL Server 2016. 2014, and 2012
- Designed Database Backup and Disaster Recovery Strategy
- Setup maintenance plan
- Performed Point-in-Time Recovery
- Setup jobs, Alerts, and Notifications
- Deployed databases in Development and UAT/Test and Lab Environment
- Installed, Configured and Managed Always On, Fail-Over Clustering, Mirroring, Log Shipping and Replication
- Identified root cause of different problems, resolve job failure related to different issues such as lock, block, sessions, performance and disk space
- Upgraded, and applied SP on HA Solutions
- Upgraded Lower Version of SQL Server to Higher Version of SQL Server
- Migrated Databases and Instances
- Moved Data/Log files to different allocated drives in different servers
- Migrated MySQL and Oracle databases to SQL Server 2012 and 2014
- Applied SP (Service Pack) and HOT Fixes
- Worked on data modeling existing and new projects to support new application
- Performed redesigning existing schema
- Performed Backward & Forward Engineering
- Tools used: Erwin and Toad Data Modeler
- Performed Database Monitoring, Session Monitoring, IO Monitoring, Application Slowness
- Performed Database and Query Tuning
- Monitored Server Activity, Server Error Log, space usages
- Analyzed the root cause of variety Database Performance issues and resolved them time to time
- Assisted Database Developers to optimize SQL queries and Procedures
- Created and Managed different types of Indexes including managing fragmentation
- Tools used: Server Activity, Profiler, Execution Plan, Query, Logs, Event Viewer
- Wrote SQL, T-SQL, Trigger, Cte, and Stored-Procedures
- Transferred data from various data sources such as Databases, Flat Files, MS Excel to SQL Server Databases
- Dumped data from Database to Excel for reporting purposes
- Used SSIS to migrate Data, Objects, Logins and other objects
- Managed users and group security including fine-tuned security at object level
- Implemented TDE (Transparent Data Encryption), Data Masking, Dynamic Data Masking, Row and column level data security
- As part of regular job find different job failure issues, monitoring disk space & availability, Login issues, AlwaysOn and clustering related issues
- Scheduled jobs to automate different Performance related jobs for monitoring database health including disk space
- Created different Maintenance Plans and automation to monitor databases for better performance
- Utilized DBCC to check database validity, health, and repair if needed
- Installed, Configured and Managed Reporting System (SSRS: SQL Server Reporting Services)
- Managed Security of the reports and Reporting Server
- Developed, Deployed, and Managed reports including security of the reports
- Deployed Reports Developed by Report Developers
- Exported/Dumped data from SQL Server Database to different reporting format like PDF, Excel and so on
- Worked with reporting team to deploy and generate report
- Worked with users to create and manager users permissions and troubleshooting their accounts
- Monitor and administer SQL Servers/Databases daily basis and solved problems as needed
- Work with PM, developers and vendors to solve different issues as needed
Work Environment: Windows Server 2016, 2012 R2, IIS 7.5, SQL Server 2016, 2014, 2012 R2, 2008, AD (Active Directory), and applications, ServiceNow, Symmetric NetBackup, Github Enterprise, MS Azure, Idera, Devops.
SQL Database Administrator
Confidential, Buffalo, NY
Responsibilities:
- Installed, Configured, and Maintained SQL Server 2012 and 2014 in test and Production environments
- Upgraded both in place and side/side from SQL Server older version to higher version
- Configured and Maintained Fail-Over Clustering using SQL Server 2012
- Installed and Configured SQL Server Reporting Services (SSRS)
- Configured and Maintained Log Shipping and Mirroring for High Availability.
- Migrated MS Access 2003/97 databases into MS SQL Server 2008 R2
- Applied Patch (Service Pack) on SQL Server Instance as needed
- Exercised time to time on database Performance tuning
- Utilized DBCC to check database conditions and Rebuilding indexes as well
- Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints, Views, Stored Procedures and Triggers
- Worked with developers supporting in query optimization
- Data Modeling, established E-R Diagram, Reverse Engineering, Forward Engineering using Erwin and SSDD (SQL Server Data Diagram)
- Export & Import data from/to databases like Oracle, MySQL and Access to/from SQL Server
- Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and SSDT
- Assisted to generate reports using SSRS in Excel, html and text as well
- Excellent working experience in Database Backup, Restore and Point in Time Recovery
- Working experience and strong knowledge in High Availability and Disaster Recovery solutions
- Implemented different Maintenance Plans to scheduled jobs to automate different database related activities including backup, performance, optimization, disk space and memory usage
- Used third party tool Service Now for ticketing and fixed issues accordingly
- Monitored Server activity, error log, space usage and solved problems as needed
Work Environment: Windows Server 2016, 2012, 2008 R2, IIS 7.5, SQL Server 2016, 2014, 2012, 2008 R2, AD (Active Directory), Dynatrace, Logic Monitor, Remedy, Github Enterprise and applications in J2EE, PHP and ASP.net.