Database Administrator Server

Name: Sabera Khatun

Phone: 267-***-****

Email: adt12b@r.postjobfree.com

Microsoft Certified SQL Server Database Administrator with 7 years of experience in supporting databases and servers as well as managing large enterprise environments using SQL Server 2019, 2016, 2014, 2012, 2008 R2. Also with experience in areas of Database Installation, Configuration, Migration, Disaster Recovery, High Availability Solutions, Always On Availability group, SQL Server Failover Cluster, Replication, Log Shipping, Backup, Maintenance plan, Automation Job, and SSIS. Strong experience in performance tuning and optimization, Index, store procedures, triggers, functions, and constraints. Furthermore, I have experience working with Microsoft Azure in various areas including creating and configuring virtual machines and storage accounts, managing Azure Active Directory, as well as migrating databases to Azure IaaS/PaaS for different SQL Server versions on various operating systems. Self-motivated team player with strong client orientation and the ability to work in a diverse environment. Seeking Database Administration related field to obtain extensive knowledge and opportunity to learn modern technologies.

Professional Experience _

Freddie Mac ~ Reston, VA May 2020 - Present

SQL Database Administrator

●Upgrading/Migrating SQL server to SQL server as well as on-premises SQL database to Azure database and instances.

●Applied SP (service pack), Hot Fixes, and cumulative updates on SQL server instances to address security and upgraded related issues

●Performing troubleshooting, resolution, and root cause analysis for database and application-specific incidents

●Worked out effective solutions for slow-running queries, deadlock, blocking issues, and disk full issues to optimize overall productivity

●Monitor SQL Server Error Log, Space Usage, SQL Server Profiler, Extended Events, Database Engine Tuning Advisory, Performance Monitor, Activity Monitor, and Execution Plan

● Installed, configured, and maintained HA (high-availability)/DR (disaster recovery) solutions - Always On, Failover Clustering, Replication, Log Shipping

●Configuring database mail, notification services, scheduling jobs and alters for blocking, disk space, services, replication, etc.

●Database Backup - designed backup strategies for development, Staging, Test/UAT, and Production Environment, setup automated backup verification process for backups

●Refresh/Deployment across the environment including Point-In-Time Recovery

●Setup and managed database security by creating new users, then roles and providing required privileges to users

●Used DBCC and ALTER statements to check and manage database consistency, index, fragmentation/rebuilding, and statistics.

JetBlue Airways Corporation ~ Long Island, NY Oct 2017 - April 2020

SQL Database Administrator

●Installed, configured, and managed instances and databases in SQL Server 2016, 2014, and 2012 in development, stage, test, and production environments

●Involved in migration of databases from SQL Server 2008 R2 to SQL Server 2012 & SQL Server 2014, 2016

●Performed High Availability and Disaster Recoveries administrative tasks such as design and implementation of Disaster Recovery solutions based on RTO and RPO guidelines, and performed restore and point-in-time recovery. Configured AlwaysOn, managed availability group and clusters

●Set up jobs from SSIS packages. Developed, deployed, and managed SSIS packages to perform various ETL operations from/to various sources and destinations using SSDT, SSIS, and import/export Wizard for SQL server

●Setup and configured SSRS, created and deployed reports from BIDs, provided access to SSRS reports

●Planning, analyzing and developing Ad-Hoc reports using SQL Server Reporting Service(SSRS) and Report Manager to support various user requirements

●Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server, and Flat files, and other data sources supporting ODBC, OLEDB.

●Scheduled weekly jobs and maintenance tasks for better performance created the alerts

●Recovered databases from backup in disasters and implemented Point-In-Time Recovery solutions

●Used DBCC and altered statements to check and manage database consistency, index fragmentation/rebuilding, and statistics,

●Worked extensively in performance tuning including query tuning, server tuning, identifying and troubleshooting I/O bottlenecks, memory, lock, block, deadlocks, monitoring sessions, query executing, and proposal of short-term fixes, long-term solutions

Trawick & Associates ~ Alexandria, VA Feb 2016 - Sep 2017

Jr. SQL Database Administrator

●Installed, configured, and migrated database for database version upgrade

●Installed SQL Server 2012 in Windows Clustered environment (Active - Passive)

●Worked on data modeling projects, developed E-R diagram using multiple tools like Erwin and SQL Server Data Diagram

●Set up and manage database security by creating new user roles and providing required privileges to users. worked with Windows authentication, SQL server authentication, and mixed modes.

●Performance tuning SQL queries by adding indexes for better performance

●Planned and developed backup strategies, set up backup jobs, maintenance plan jobs, alerts, notifications, monitoring, and troubleshooting jobs.

●Perform daily incremental and weekly full backups by creating maintenance jobs.

●Automation - created jobs, set up schedules, configured mail server, operated notifications, and other related services

Star Sky Electronic Company ~ Abu Dhabi, UAE Feb 2014 - Jan 2016

IT Help Desk

●Assist with onboarding of new users

●Maintain user PCs, including upgrades and configuration as needed.

●Served as first point of contact for staff seeking technical assistance over phone/email

●Performed remote troubleshooting through diagnostic technical and pertinent questions.

●Determine the best solution based on the issue and details.

●Responding in a timely manner to service issues and requests.

●Monitor and respond quickly to incoming requests related to IT issues.

Core Qualifications and Technical Skills _

●Database Skills - SQL Server 2019/2016/2014/2012/2008 R2, Azure SQL

●SQL Server Tools - Server Management Studio (SSMS), Query Analyzer, SQL Profiler, SSIS, Clustering, Database Tuning Advisor, Index Tuning Wizard, Activity Monitor, DBCC, DMV, Performance Monitor, Task Manager, Reporting Services Report Manager, Extended Events, SQL Server Configuration manager - Execution Plan

●Database Migration/Upgrade - Migration SQL server to SQL server, and non-SQL server using SSMA, SSIS, DTS, DMA & Exp/Imp.

●Performance Tuning - Root cause analysis/monitoring Query Optimization, Experience in resolving Indexes fragmentation, deadlocks, and blocking long-running queries. Experience in using different tools Profiler, Execution Plan, PerfMon, Database Tuning Advisor, DMV, Windows Performance Monitor, and Idera SQL Diagnostic.

●Security - Permission issue, Orphan user, using principal/Roles Auditing, Transparent Data Encryption (TDE), Dynamic Data Masking (DDM), and Always Encrypted.

●High Availability/Disaster Recovery - Configured and administered High availability Solutions like Always On, Clustering, Replication, and Log Shipping.

●Service Pack - Applied Service Pack (SP), Hot Fixes, and Cumulative Update (CU)

●SSRS - create various reports to serve client needs

●SSIS - create, manage, deploy, upgrade, and migrate packages

●ETL - SSIS/DTS, Bulk Copy Program

●Azure/Cloud - Azure Services, PaaS. Iaas, Migrated On-Premises databases and products on Azure, deployed products on Azure, and set up development and test environment on Azure.

●Domain/AD - Active Directory, DNS

●Third-Party Tools - Idera, Jira, ServiceNow, Red Gate, Remedy

Education and Certification _

●Bachelor of Computer Science & Engineering

●Microsoft Certified Azure Database Administrator

Contact this candidate