We provide IT Staff Augmentation Services!

Azure Sql Dba Resume

3.00/5 (Submit Your Rating)

Boise, ID

SUMMARY

  • Strong working experience as a Database Administrator in SQL Server 2019/ 2017/2016/2014/2012/2008 R2/2008/2005 in Production, Development, and Test (Clustered, Stand Alone, VM and Azure IaaS, PaaS) Environments
  • Expertise on Azure IaaS and PaaS Environments for Deployments, Maintenance, and Troubleshoot Like Azure DB Security, Automation Jobs, Storage Account, HA solutions, Geo - Replication, Log Shipping, Performance issues, CPU, Memory, Backup/Restore, Query tuning, Link Server
  • Worked in cross Environment in Azure Cloud SQL Database (PaaS) and Azure VM (IaaS)
  • Solid understanding Design, build and administration cloud service including PaaS (Azure SQL DB, Elastic Pool, Manage Instance), IaaS
  • Experienced wif lift and shift from On-Prem to Azure Manage Instance and IaaS
  • Configured Mirroring between On-Prem server to Azure Server for Migration
  • Good understanding Azure data Factory, Azure Event HUB, Azure Log Analytics
  • Expert on Database pricing model, Azure Service Tier, Azure deployment model, Azure automation, Azure Data sync, Migration, Setup Alert and troubleshoot
  • Skilled automating SQL Server deployment, configuration, and administrative tasks wif PowerShell
  • Worked wif developers, application owners, system administrators and users to deploy software release across Development, Testing, and promoting into Production or resolve issues
  • Proven experience in teh areas of Database Performance Tuning using SQL Server Profiler, Extended event, Database Tuning Advisor, Execution plan, Performance Monitor and Activity Monitor, DMV, DBCC, Windows Event Viewer, SQL Server Error Log, Agent Error Log
  • Extensive work experience in Monitoring Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving teh problem as needed
  • Has solid experience in SQL Server High Availabilityand Disaster Recovery solutions like Log shipping, Mirroring, Replication, Fail Over-clustering and Always On wif multi subnet
  • Strong knowledge and experience in capacity planning and implementing disaster recovery solutions- database Backup, Restore, Point-in-Time Recovery in accordance wif RTO and RPO guidelines
  • Expertise in RDBMS concepts and constructs. Working wif data modeler on Logical and Physical data modeling using Erwin and native tools
  • Proficient in writing T-SQL batches and developing Indexes, Stored Procedures, User Defined Functions, CTEs, Triggers, SQL joins, Views, Cursors, table variables, sub-queries
  • Strong skills in reporting using SQL Server Reporting Services/Power-BI (SSRS) and creating various types of reports and managed security/troubleshoot day to day basis
  • Excellent in High-Level Design of SSISPackages for integrating data usingOLE DB/ODBCconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Teradata, PostgreSQL, DB2) and managed security/troubleshoot day to day basis
  • Working Experience and teh good understanding ofSSAS, OLAP cube/Security and Architecture
  • Hands on experience in upgrade/ migrate from SQL Server 2005/2008R2/2012 to SQL Server 2012/2014/ 2016/2017/2019
  • Strong working experience on migrating databases from others platform in different version from Oracle/DB2/PostgreSQL/Teradata to SQL Server 2016/2017/2019
  • Good experience in Operating Systems (OS) Windows Server 2008 R2, Windows Server 2012, 2016
  • Extensive knowledge of creating, supporting, and maintaining database administration scripts
  • Expertise in implementing SQL Server security, managing users, granting/revoking access, encryption, TDE, data masking, auditing, and monitoring to comply wif Microsoft and industry best practices
  • Extensive work experience in Temp DB configuration, Table partitioning, shrinking, Link server, compression, and database optimization
  • Good experience wif teh phases Software Development Life Cycle SDLC and TFS
  • Experience in supporting Very Large Databases (VLDB) and troubleshooting teh problems.
  • Excellent ability to work as part of a team and independently and able to manage time too TEMPeffectively to meet deadlines and prioritize workload
  • Performed Production support in 24/7 and on Call duties

TECHNICAL SKILLS

Database: SQL Server 2019, 2017/2016/2014/2012/2008 R2/2005, MS Access 2007 &2003/Excel 2007/2010/2013/ MySQL

Operating System: Windows 2012/2008 R2/2003 R2/ Windows XP/7/8, UNIX, VMware

Languages: T-SQL, My/SQL, HTML, XML, JavaScript, ASP, ASP.net, PHP

ETL Tools: Native Tools (SSDT, BIDS, DTS and SSIS) Export/Import

Reporting: SSRS (SQL Server Reporting Services) Report Builder 3.0/2.0

Data Modeling: Erwin, Toad Data Modeler, SSDD (SQL Server Database Diagram

Third-Party Tools: Solar-Winds, New Relic, Erwin, Toad Data Modeler, ServiceNow, Zendesk, Commvault

Networking: Active Directory, TCP/IP, DHCP/, LAN/, DNS/, HTTP/, HTTPS/, SMPT

Hardware/Storage: SAN, NAS, RAID, ISCSI

Native Tools: SSMS, Performance Monitor, Query Analyzer, Extended Event, SQL Profiler, Execution Plan, Activity Monitor, Database Tuning Advisor, DMV, DBCC

PROFESSIONAL EXPERIENCE

Confidential, Boise, ID

Azure SQL DBA

Responsibilities:

  • Installed and configured SQL Server 2016,2019 on Azure VM wif FCI environments
  • Worked on daily operation for service requests, incident, change request, outage and Break fix, Index Optimization, update Statistics, recompile, Backup and Restore, Security, Jobs, Replication, Always on Availability Group, SSRS, SSIS, Server Connectivity, Link Server issues, Disk Space, performance tuning, troubleshooting long running queries, locks, block, deadlocks, CPU, me/O, and Memory
  • Migrated SQL Server 2012/2014/2016 from On-Prem to On-Prem/Azure VM and Managed Instance
  • Configured and managed Always on Availability Group from On-Prem to Azure VM for migration
  • Performed database backup and restore from On-Prem to On-Prem/Azure VM/MI instances
  • Configured IaaS Extension for Azure automated database and server backup
  • Configured Geo Replication between West and East region and configured Elastic pools for adding database
  • Configured NSG Rules for different application in Azure
  • Configured ADF in Azure portal for Migration
  • Configured Mirroring between On-Prem server to Azure Server for Migration
  • Configured Load balancer Rules for multi - Subnet Always on in Azure Portal
  • Configured Storage account in Azure Portal also Experience adding disk in Azure.
  • Perform VM- SKU size for different critical application in azure Portal
  • Configured Link sever Between Azure IaaS to Managed Instance
  • Securing On-Prem Server/Azure VM/MI Instances and, databases users, Transparent Data Encryption (TDE)
  • Setup Replication and troubleshoot from On-Prem to On-Prem/Azure VM/Azure SQL Database
  • Monitored and troubleshoot SQL agent jobs daily and resolved issues if any job failed
  • Applied Service Pack (SP)/CU on SQL Server2012/ 2016/2017/2019 on DEV/UAT/Prod environments
  • Deployed database objects/changes to different environments including DEV/UAT/Production
  • Moved data from Flat file, CSV file, Excel to SQL Server database using Import/Export wizard
  • Deployed, Managed, and migrated SSIS packages and maintain security
  • Deployed, Managed, and migrated SSRS reports in different environments
  • Troubleshoot and resolved lock, block, deadlock, performance issues for databases and, performed Server/Database health check proactively, Application performance and connection issues
  • Configured, Managed and troubleshoot Always on Availability Group, Windows Server Failover Cluster, Log Shipping, Replication
  • Worked wif performance tuning of T-SQLqueries, stored procedures and debugging teh poorly written code and halping application teams to optimize query
  • Created maintenance process including index fragmentation job, rebuild index, DB-statistics and, automate DB refresh process for multiple databases
  • Worked wif PM, developers and vendors wif ideas and solutions to meet project deadline

Environment: MS SQL Server 2019/2017/2016/2014/2012 IaaS/PaaS, MI, Oracle, DB2, MySQL, Redgate, Rubrik, Service Now, Jira, SharePoint Server, Visual Studio, and Windows Server 2016/2012/2008 R2/ SSRS, SSIS, SSAS, SQL Cluster, AAG, Log Shipping, Replication

Confidential, Beaverton, OR

SQL Server DBA

Responsibilities:

  • Manages and troubleshoot SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, and 2019 on Dev/UAT/QA/Prod environments.
  • Supports day to day operational activities for teh databases platform like service requests, incident Change request, outage and Break fix, monitoring, performance tuning, troubleshooting long running queries, Lock, blocks, deadlocks, missing index, and performance issue CPU, me/O, Memory, and Backup/Restore, jobs, database optimization, Disk space, DB security
  • Monitoring Server Activity using DPA/Foglight, SQL server log, Error Log, space usage, database health, failed job, critical alert, cleaning history and solving teh problem as needed
  • Review application SQL query and improve performance by creating missing index, remove unused index and recommending query design
  • Working on hoc request like DB refresh, code deployments, and user requests on daily basis
  • Worked on monitoring project to send automated alert by Solar Wind DPA for SQL Server
  • Migrated Azure VM (IaaS) SQL Server 2012 databases to On-Premises to SQL Server 2016
  • Setup Replication to migrate data from On-Premises to Azure DB (PaaS) and manage Azure DB security
  • Migrated On-Prem SQL databases to Azure IaaS, PaaS using DMA, DMS, Replication, Log Shipping
  • Configured and managed on Azure Geo-replication for High Availability solution
  • Configured Azure Storage explorer for database backup and restore for database migration
  • Upgrade/Migrate SQL servers from 2008R2/2012/2014 to SQL server 2016/2017/2019
  • Migrated Teradata/DB2/PostgreSQL and Oracle Server databases to SQL Server 2106/2019
  • Migrated databases from SQL Server 2008/2008R2/2012/2014 to SQL Server 2016/2019 using backup and restore process over multiple applications and over multiple servers
  • Configured and Troubleshoot SQL Server 2016/2019 Always on Availability On-Multi-Subnet, Replication, Log Shipping, Mirroring, SQL Server Failover Cluster
  • Installed, configured, and troubleshoot Oracle client driver, Antiunity driver for Oracle/SSIS, .Net provider for Teradata, IBM iSeries Driver, Access Driver for Excel, CSV, PostgreSQL Driver
  • Installed, Configured, and troubleshoot SQL Server Reporting services, creating folder, managing subscription, privilege, and migrated Report Servers from 2012/2014 to Report server 2016/2019
  • Configured/manage and troubleshoot Power BI report and maintain Security daily basis
  • Deployed SSAS database on SQL Server 2019 and manage security also process SSAS CUBE
  • Migrated SSIS Projects, Packages and, Environments from SQL server 2012/2014 to SQL Server 2016/2019, deploy SSIS project/Package and troubleshoot SSIS jobs
  • Created and deploy Tables, Indexes, Constraints, Views, Stored Procedures, Function, Triggers
  • Managed user access privilege Granting/Revoking/Denying access/ Client Server Connectivity
  • Implemented TDE for Database Encryption, data Masking, Always Encrypted
  • Manages and troubleshoot NetBackup on SQL Server 2012/2014/2016 for databases backup
  • Created Linked Server wif native and foreign platform including Oracle, MySQL, DB2, Teradata
  • Provide 24/7 On-Call support on a rotational basis

Environment: Windows Server 2016, 2012, 2008r2, IIS 8.5, 7.5, SQL Server 2019, 2017, 2016, 2014, 2012, 2008r2, 2008, 2005, AD (Active Directory), JavaScript, ASP and ASP.net. VM server, TFS, Service Now, Commvault, SolarWinds, Idera

Confidential, LONG ISLAND NY

SQL Server DBA

Responsibilities:

  • Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, Database Engine Tuning Advisor
  • Installed, Configured, and Maintained SQL Server 2016, 2014, 2012, 2008 R2in development, test, and production environment and SQL Server 2016 on Test environment.
  • Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2008 R2 and SQL Server 2012/2014/2016.
  • Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgrade related issues.
  • Worked on Database refresh in Dev/Test servers wif PROD data and reinstate teh server.
  • Configured and Maintained Always-On Availability Group using SQL Server 2014/2012 wif Synchronous automatic-failover mode.
  • Configured, managed, and monitored Transactional/Snapshot Replication and Log Shipping
  • Scheduled many jobs to automate different database related activities including monitoring database health, disk space, backup verification.
  • Involved in monitoring, troubleshooting, optimizing, and tuning lock, block, deadlock, index fragmentation, slow running queries, etc. using native and third-party tools.
  • Developed Different Maintenance Plans for database monitoring.
  • Setup Jobs, Maintenance plans for backups, rebuilding indexes, check server health, alert, notifications Implementation of SQL Logins, Roles, and Authentication Modes as a part of Security Policies for various categories of users.
  • Deploying new code base release to UAT and Production Environments.
  • Deployed SSIS packages to move data across server, move logins, load data from different data sources.
  • Used Import/Export Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel, and many other data sources supports ODBC, OLE DB Data Sources

Environment: Windows Server 2016, 2012, 2008r2, IIS 8.5, 7.5, SQL Server 2017, 2016, 2014, 2012, 2008r2, 2008, 2005, AD (Active Directory), JavaScript, ASP and ASP.net. VM server, TFS, Service Now, SolarWinds, Idera

Confidential, Princeton,NJ

SQL Database Administrator/SQL DBA

Responsibilities:

  • Installed, Configured, and Maintained SQL Server 2016, 2014, 2012, and 2008 R2 in development, test, and production environments.
  • Configured and Maintained Fail-Over Clustering, FCI, Always On using SQL Server 2012, 2016
  • Installed and Configured SQL Server Reporting Services (SSRS)
  • Developed and deployed different types of Reports using different data sources like SQL Server, Oracle, Excel, CSV files
  • Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats.
  • Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability.
  • Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2000/2005 to 2008 R2 and 2008 R2 to 2012, 2016.
  • Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues.
  • Performed database and SQL/TSQL Performance Tuning
  • Wrote SQL/T-SQL queries, Stored-Procedures, functions, and triggers.
  • Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification.
  • Setup Jobs, Maintenance plans for backups, rebuilding indexes, check server health, alert, notifications.
  • Create and managed different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check)
  • Deployed SSIS packages to move data across server, move logins, load data from different data sources.
  • Manual, on Demand and setup jobs for Database Backup, and design backup strategy
  • Monitor Server Activity, Error Log, space usage and solving problem as needed.

Environment: Windows Server 2016, 2012, 2008r2, IIS 8.5, 7.5, SQL Server 2016, 2014, 2012, 2008r2, 2008, 2005, AD (Active Directory), JavaScript, ASP and ASP.net. VM server, TFS, Service Now, SolarWinds, Idera

Confidential, McLean, VA

SQL Database Administrator/SQL DBA

Responsibilities:

  • Installed, configured, optimized, and managed enterprise-wide SQL Server2008 R2 and 2012 instances in development, test, and production environment.
  • Applied SQL Server Service Packs and Cumulative Updates as required
  • Setup, Configured, monitors and Maintained Database Replications and Mirroring
  • Setup, configured, maintain, and monitored troubleshoots SQL Server Clustering
  • Configured and Maintained Log Shipping as Standby database for Reporting Purposes.
  • Data Encryption and Data Decryption for data security in Database & Column level
  • Implemented SQL Logins, Roles, and Authentication Modes as a part of Security Policies for various categories of users.
  • Extensively worked wif SQL Profiler, Activity monitor, Perfmon, DMVs, DMFs and DTA to tune thedatabases, queries, performance related issues like memory CPU and me/O issues.
  • Managed Backup/Restore, Point-in-Time Recovery including backup verification, security.
  • Monitored data activities such as logs, space utilization, locks, long transaction.
  • To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
  • Used T-SQL, Stored-Procedures, Triggers, Function, Views, Indexes
  • Export & Import data from Flat file (CSV, Excel) to SQL Server Database using export/import tools and SSIS.
  • Installed and Configured SQL Server Reporting Services (SSRS) and Report migration
  • Developed and Managed Report in SSRS (SQL Server Reporting Services) including securities.
  • Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, and moving databases from environment to environment including creating test environment.
  • Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files.

Environment: SQL Server 2008R2, 2012, IIS 7.5, 8.5, Windows Server, 2003, 2003R2, 2008R2, 2012, ASP, ASP.net, Java, ETL and AD, SQL Sentry, ServiceNow, TFS

Confidential, MANHATTAN, NY

SQL Database Administrator/SQL DBA

Responsibilities:

  • Installed, Configured and Maintained SQL 2005, 2008 r2 in development, test, and production environment.
  • Responsible for implementing different types of Replication Models such as Transactional, Snapshot.
  • Implemented high availability SQL Server solutions wif SQL Server Failover Clustering and Database Mirroring
  • Creating SSIS Packages and deployed from different sources like SQL Server Database, Flat file, CSV, Excel, and many other data sources supports OLEDB Data sources
  • Applied SP (Service Pack) and patches on SQL Server 2005, 2008r2
  • Fixed Missing Indexes and Excess indexes using DMV/Profiler/Execution Plan
  • Worked on database Performance tuning, Server tuning and Query tuning.
  • Managed Database Backup Restore and Point-in-Time Recovery process based on RPO/RTO.
  • Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification.
  • Installed and Configured SSRS and Generated Report using SSRS/Report Builder
  • Export/Import data from Excel/Flat/CSV files, and Oracle to SQL Server Database using DTS, SSIS, and BCP utility

Environment: SQL Server 2005, 2008R2 IIS Server 6.5, 7.5, Windows Server 2008R2, ASP.net, Java, ETL and AD (Active Directory) Share Point, Visual Studio, ServiceNow, OpNet

We'd love your feedback!