Uploaded File
Zia
azsql.zia@gmail.com
703-981-3833
New York, NY 10001
SQL Server Database and Azure Administrator
21 years experience W2
08/09/2021
0
Recommendations
Average rating
26
Profile views
Summary

  • SQL Server Database Administrator with over 8 Years of extensive experience in Administering, Managing and Supporting SQL Servers 2008R2/2012/2014/2016/2017/2019.
  • Over 3 years of experience with Azure Administration in IaaS and PaaS Platform.
  • Strong expertise in AlwaysOn, Replication, Log shipping, Mirroring, Performance tuning, Stored Procedures, Triggers, Functions & Active monitoring in 24x7x365 environment.
  • Over 10 years of experience in Information Technology as Systems Admin & Systems Engineer with solid understanding of the Company’s core values and Resourceful.

Technical Knowledge:

  • Databases: Azure SQL & SQL Server 2019/2017/2016/2014/2012/2008R2
  • Operating System: Windows Server 2016/2012/2008R2/2003R2, Solaris, Linux, VMware
  • Languages: SQL/T-SQL/XML/HTML/DML/DDL/CRUD
  • ETL Tools: SSDT, SSIS, Import/Export Wizard, Bulk Insert
  • Reporting: SQL Server Reporting Services, Report Builder
  • Data Modeling: SSDD (SQL Server Database Diagram), ERWin
  • Upgrade/Migrate: SQL to SQL, Oracle to SQL, MySQL to SQL, DB2 to SQL
  • Third Party Tools: SentryOne, Idera, RedGate, ERWin, ServiceNow, Remedy, Trekker
  • Native tools: SSMS, Performance Monitor, Query Analyzer, Extended Events, SQL Server Profiler, Database Tuning Advisor, Execution Plan, Activity Monitor, Resource Monitor, Job Activity Monitor, DMVs & DMFs, DBCC, and SSCM, Data Migration Assistant (DMA), Data Migration Services (DMS), Microsoft Azure Storage Explorer
  • Hardware/Storage: SAN, NAS, RAID, IBM Storage, iSCSI, Azure Managed Disks
  • Networking: TCP/IP, DNS, WAN, LAN, SFTP, FTP
  • Other Tools: Git, Team Foundation Service (TFS), SharePoint, Active Directory

Training and Certification:

  • CompTIA Security+: SYO-501, Verification Code: WQFYR0RH6LB4QE91, Dec,2020
  • Microsoft® Certified Azure Database Administrator (AZ-104, DP-300, AZ-900)
  • Microsoft Certified MCSA: SQL 2016 Database Administration Charter Member
  • Microsoft® Certified Administrator, Database Infrastructure, SQL Server 2016
  • Microsoft® Certified MCP, MCITP & MCTS, SQL Server 2008
  • Microsoft® Certified Systems Engineer, MCSE
  • SUN Certified Network Administrator and Solaris Systems Administrator

Professional Summary:

  • 8 years of experience as SQL Server DBA (2008R2, 2012, 2014, 2016, 2017, 2019) in Prod, Dev and Non-Prod Environments.
  • Extensive experience in Installation, Migration, Upgrades, Configuration and Administration for SQL Server in Clustered, Non-Clustered, VMWare & Azure Environment.
  • Migrated/Upgraded On-Premise SQL Server Databases of 2008R2/2012/2014 to SQL 2016/2017/2019 to SQL Server in Azure VM (IaaS)
  • Configured Database Maintenance Solutions for SQL Servers in Azure VM using ARM templates to automate maintenance tasks.
  • Provisioned and Managed Azure SQL Databases (PaaS) in Prod and Non-Prod Environment for application Migration and Load Testing.
  • Migrated On-Prem SQL DBs to Azure SQL DBs, and Configured Geo-Replication and Failover-Group for managing HA/DR for Azure SQL Databases
  • Configure azure managed backup including long-term retention policy for Azure SQL DBs
  • Working experience in controlling and coordinating with Patch management (Security patches, Service packs/Cumulative Update) and system performance on pre-deployment.
  • Extensive experience in Configuration, Implementation and Maintenance for High Availability & Disaster Recovery solutions Using AlwaysOn, Log Shipping, Database Mirroring, and Replication.
  • Experienced in automating Backups and Restore, Point-in-Time Recovery in accordance with RTO and RPO guidelines, and Maintenance plans.
  • Set Up Jobs, Alerts, Emails, Controlling User Privileges, Security and Audit.
  • Expertise in Performance Monitoring, Database Tuning Advisor, Profiler, Extended Events, and Performance Monitor & Third-party tools like Idera SQL Diagnostic Manager.
  • Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Index tuning, Update Statistics, Error and Event Handling.
  • Worked on Database refresh in Dev/Test servers with PROD data.
  • Implemented Transparent Data Encryption (TDE), Creating and managing logins/users, granting/revoking access at database or Server level.
  • Solid experience in Installation, Configuration and Migration of SSRS, SSIS.
  • Proven work experience in TempDB configuration, shrinking and Linked Servers.
  • Exported / Imported data from SQL Server to Flat file, CSV file, Oracle, MySQL
  • Extensive knowledge of Normalization and Relational Database Management Systems
  • Solid Experience with Verbal/Written Communication, on-call Rotation, Multi-tasking and Task prioritizing.

Experience
SQL Server Database and Azure Administrator
Information Technology
Aug 2012 - Jun 2020
  • Worked on maintaining and optimizing the database systems across different platforms.
  • Supporting and mentoring teams as a collective unit in thriving with the organization.
  • Provided BAU (Business as Usual) Supports for Prod, Non-Prod environments.
  • Monitored database activities such as database status, logs, space utilization, extents, Checkpoints, locks, Block, Dead Lock and long-running transactions.
  • Worked on Installation, Configuration, Administration, and Implementation of SQL Server 2019/2017/2016/2014/2012/2008R2 and Azure SQL Databases.
  • Involved in Migration/Upgrade projects of Databases from SQL Server 2008R2 to SQL Server 2012/2014/2016/2017/2019.
  • Determined and Provisioned right size of Azure VM in Azure cloud for migration SQL Servers according to existing workloads.
  • Migrated SQL Server Databases of 2008R2/2012/2014/2016/2017 to SQL Server in Azure VM (IaaS) using DMA, DMS and .bakpac files.
  • Move/Copy files from on-prem to Azure Blob using Microsoft Azure Storage Explorer.
  • Setup Database Maintenance Solutions for SQL Servers in Azure VM to automate maintenance tasks and provisioned Azure VMs in Azure as part of Azure Migration.
  • Configured Database Backups using Azure Blob Storage
  • Created and Managed Azure SQL Database (PaaS) in Non-Prod environment for application Load Testing and future Migration purpose.
  • Migrated on-premise SQL databases to Azure SQL (PaaS)
  • Configured Proper Service tiers/Deployment options for Azure SQL Databases.
  • Configured Azure Managed Backup including long-term retention policy for Azure SQL DB
  • Configured Geo-Replication and Failover-Group for managing HA/DR for Azure SQL DB
  • Configured firewall rules for Azure SQL databases to manage clients' access.
  • Managed accesses to Azure SQL DBs by creating contained users both for SQL and Azure Active Directory (AAD) Accounts.
  • Configured Linked Servers between on-prem SQL Server to Azure SQL Databases
  • Applied Security patches and service packs and worked on performance improvement.
  • Analyzed slow running queries and tune to optimize application and system performance.
  • Worked with Execution Plan, Extended Events, SQL Server Profiler, Database Tuning Advisor, PerfMon, Activity Monitor for monitoring, tuning, and troubleshooting.
  • Configured and Managed AlwaysOn Availability Group to set up HA/DR, and Replication, Log Shipping and Mirroring solutions using SQL Server 2012/2014/2016/2017.
  • Implemented & managed MS SQL Cluster (Active/Passive) and load balancing technologies and SQL Security, TDE, logins/users, on database and Server level.
  • Utilized DMVs and DMFs to monitor server health, diagnose problems, tune performance.
  • Performed Database Refresh tasks from production to Development and Test Servers
  • Monitored Server Activity, Error Log, Disks Database health and backup verification.
  • Extensive work experience in Linked servers, Service Packs, Patches, and Hot Fixes.
  • Deployed and Administered SSRS Reports and SSIS Packages.
  • Used Report Manager to assign roles, permissions and to create report schedules
  • Performed regular backups, restores, Point-in-Time Recovery, maintaining RTO and RPO.
  • Created and managed schema, entities, relationship, constraints, normalization, developed ER Diagram using ERWin and SQL Server Data Diagram and Data Modeling.
  • Exported/Imported data from SQL Server to Flat file, CSV file, Oracle and MySQL.
  • Solid Experienced with Rotational on Call Support for Production Platform
  • Maintained database system compliant with the Industry standards.
  • Optimized database systems from a long running jobs from hours to minutes with query optimization and used Power Shell for Automating processes.
  • Made process improvements and suggestions to the leadership on database and security.
  • Worked on helping new hire, training and mentoring needed for our DBA team.
  • Data Quality, Integrity, automating reports/queries, store procedure, scheduling to job.
Azure Active Directory Azure Migration Azure Storage Data Modeling Data Replication Database Backups DBA Erwin Data Modler Firewall HA Load Balancing MS Active Directory MS Azure MySQL Oracle Patch Management PowerShell Process Improvement SQL SQL Server SSIS SSRS Stored Procedure Windows Windows Server Cloud Migration SQL DW
Remove Skill
Windows Server Admin
Information Technology
May 2010 - Aug 2012
  • Assessing the stability, security, and scalability of installed Windows systems.
  • Installing or upgrading Windows systems and servers.
  • Providing technical support for staff and back-end system users.
  • Troubleshooting system and server errors and Monitoring system performance.
  • Reviewing system error logs and user-reported errors.
  • Monitoring and updating the Windows codebase, Handled systems and servers upgrade.
  • Managing user access via Active Directory and Domains.
  • Maintaining server architecture security and creating system backups, system snapshot, system clones, Volume snapshot (VSS) and VEEM backup.
  • Managed 50 plus OS servers with the Database teams.
  • Excellent experience with Root cause analysis and troubleshooting server/database issues.
Database Backups MS Active Directory Windows Windows Server Server Admin Technical Support Problem Solving
Remove Skill
Software Support Engineer
Information Technology
Apr 2007 - May 2010
  • Configuration, Installation, Administration of Sun Microsystems Servers
  • Supports Technology Group with latest Firmware and Patching, Server Builds
  • SW/HW Upgrade, Collect, Run and Upload Core Dump, error Logs & SC Explorer
  • Ample Experience with Solaris Tools, Jumps Start, VTS, Domain, Active Directory, Veritas.
  • Configuration of TCP/LAN Environment with NIS, NIS+, NFS, DNS & DHCP, Solstice.
  • Provide on-call flexible rotation duty as a technical resource to any SUN Systems
DHCP DNS Firmware LAN MS Active Directory NFS NIS Solaris Veritas Sun Server Builds
Remove Skill
UNIX Systems Administrator
Information Technology
May 2005 - Mar 2007
  • Administration of UNIX /Linux/NT Servers, Build New servers, Solaris Jump-starts
  • Install Configure and Monitor Solaris, Linux, MS Servers, Veritas, Big brother, Realtick, Insight Manager, FIX/OTC/Listed Stocks, GTM Tools, Remedy, Wisetrack
  • Monitoring performance of Production Servers, Trading transactions, Data flow, Volumes, Client connectivity, failover, re-route data/connections, FTP and CAPCO.
Linux Solaris System Administration UNIX Veritas BMC Remedy Trading FTP
Remove Skill
Sr. Systems Engineer
Information Technology
Aug 2000 - Apr 2005
  • Configuration, Installation and Maintenance of SUN Microsystems Servers
  • Expertise on Solaris Jump Starts, VTS, explorer tools, Firmware and Patch Upgrade
  • Trading Floors and Data center supports with Sun and MS Windows Systems
Data Center Firmware Solaris Systems Engineering Windows Sun Database Maintenance Trading
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in -
University of Dhaka
Skills
Windows
2020
14
MS Active Directory
2020
13
Database Backups
2020
10
Windows Server
2020
10
Solaris
2010
9
Azure Active Directory
2020
7
Azure Migration
2020
7
Azure Storage
2020
7
Cloud Migration
2020
7
Data Modeling
2020
7
Data Replication
2020
7
DBA
2020
7
Erwin Data Modler
2020
7
Firewall
2020
7
Firmware
2010
7
HA
2020
7
Load Balancing
2020
7
MS Azure
2020
7
MySQL
2020
7
Oracle
2020
7
Patch Management
2020
7
PowerShell
2020
7
Process Improvement
2020
7
SQL
2020
7
SQL DW
2020
7
SQL Server
2020
7
SSIS
2020
7
SSRS
2020
7
Stored Procedure
2020
7
Sun
2010
7
Trading
2007
6
Data Center
2005
4
Database Maintenance
2005
4
Systems Engineering
2005
4
Veritas
2010
4
DHCP
2010
3
DNS
2010
3
LAN
2010
3
NFS
2010
3
NIS
2010
3
Server Builds
2010
3
Problem Solving
2012
2
Server Admin
2012
2
Technical Support
2012
2
BMC Remedy
2007
1
FTP
2007
1
Linux
2007
1
System Administration
2007
1
UNIX
2007
1
Data Migration
0
1
Database Upgrades
0
1
DB2
0
1
Disaster Recovery
0
1
ETL
0
1
Git
0
1
HTML
0
1
IaaS
0
1
iSCSI
0
1
MS SharePoint
0
1
NAS
0
1
Network Administration
0
1
PaaS
0
1
Performance Tuning
0
1
RAID
0
1
SAN
0
1
T-SQL
0
1
TCP/IP
0
1
Triggers
0
1
VMWare
0
1
WAN
0
1
XML
0
1