We provide IT Staff Augmentation Services!

Sql/azure Sql Dba Resume

Stamford, CT

SUMMARY

  • Excellent understanding of conceptual, logical, and physical database modeling and software development life cycle (SDLC)
  • Strong understanding of the database development life cycle including data modeling, database coding, testing, and implementation
  • Provisioning an Azure SQL Server and SQL Azure database through Azure web portal and Azure PowerShell
  • Configuring server level and database level firewall rules to connect to secure SQL Azure server
  • Setting up Active Geo - Replication using Azure web portal and PowerShell
  • Database administration on Production and non-production MSSQL Servers with server configuration, performance tuning, and maintenance with troubleshooting capabilities.
  • Installing and configuring SQL Server on standalone and clustered environments, SSIS, SSRS and SSAS and Applying Service packs, patches, hotfixes, and cumulative updates.
  • Excellent understanding of SQL Server architecture and Database storage structure
  • Have experience with Normalization (1NF, 2NF, and 3NF) techniques for improved database performance in OLTP environments.
  • Experience in implementing Business logic by using T-SQL Objects like stored procedures, triggers, and user-defined functions (UDF).
  • Worked on Virtualization technologies like VMware, Virtual Box, and Hyper -V
  • Migration of databases Side-by-side and in place upgrade from old version to newer version and from one edition to another edition
  • Experience in analyzing Performance, Query optimization and tuning, creating Indexes and re-writing and tuning stored procedures
  • Worked with system administrators and developers to migrate databases from SQL Server 2008 to SQL Server 2012 and SQL Server 2016
  • Identified the I/O and memory bottlenecks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, Dynamic Management Views (DMV) and handling them by implementing better Query Execution plans
  • Solid experience and outstanding knowledge on High availability (HA) and Disaster recovery (DR) solutions like log shipping, Mirroring (HIGH safety and High performance), Replication (Snapshot & Transactional), Clustering and Always on
  • Designing and implementing database Backups including Full, Differential & Transactional log and restoring databases based on the company’s RPO and RTO
  • Excellent knowledge of point-in-time recovery of databases
  • Experience in automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL agent and monitoring and troubleshooting Job Failures
  • Owning, tracking, and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs.
  • Responding to database related alerts and escalations and working with engineers
  • Experience in Managing Windows server, Active Directory and SAN disk configurations
  • Experience in Creating and deploying SSRS reports
  • Experience in Data Extraction, Transforming and Loading (ETL) packages and deploying on a production server
  • Experience in Azure Big Data technologies
  • Adding and monitoring servers via SCOM
  • Expert knowledge on cloud technologies with hands on experience in Microsoft azure
  • Managed and configured azure data factory, data warehouse, data lake store/analytics, logic apps,
  • Monitored and troubleshooted azure data factory pipelines
  • Performed azure VM migration using Azure site recovery services
  • Performed a VM migration from on-premise to azure using a lift and shift method
  • Created extended events session for performance-related issues and for auditing purpose
  • Created azure automation accounts for patching and resource optimization
  • Created and configured Azure virtual machines and storages, integration runtimes, Azure data warehouse, Azure SQL database
  • Scaled down underutilized VMs, SQL databases, azure data warehouse that resulted in big cost saving
  • Converted unmanaged disks to managed disks and cleaned up orphaned disks that resulted in cost saving, fewer footprints, and improved performance
  • Created and configured alerts and audits for tracking administrative operations like resource creation, deletion etc. in our azure subscriptions
  • Troubleshooted CPU, Disk I/O and Memory related bottlenecks, blocking and deadlocks by using activity monitor, SQL logs, extended events, perfmon, azure metrics, query store, and other mechanisms
  • Created and applied system-hardening checklists for our virtual machines that resulted in performance improvement
  • Created a maintenance plan that will save backups to azure blobs as part of our disaster recovery plans
  • Configured ASR and azure VM backup as a disaster recovery plan
  • Created and managed azure virtual networks

TECHNICAL SKILLS

  • SQL DBA
  • DBA
  • ETL
  • PostgreSQL
  • Azure
  • Microsoft SQL Server
  • SSIS
  • Disaster Recovery
  • Scripting
  • MySQL
  • Linux
  • ADF, Azure Data Lake, Azure Databricks, Azure Log Analytics, Azure DevOps, Azure Active Directory

PROFESSIONAL EXPERIENCE

SQL/Azure SQL DBA

Confidential - Stamford, CT

Responsibilities:

  • Worked on Azure SQL database and Azure SQL data warehouse (PaaS)
  • Worked on Migration and SQL upgrade projects. Migrated on premise databases to the cloud (Azure)
  • Used Azure DevOps CI/CD pipelines for deploying Azure SQL Servers and Databases.
  • Worked on securing Azure SQL databases and Data warehouse in terms of Server level and database level firewalls.
  • Worked on troubleshooting performance and connectivity issues in Azure SQL databases
  • Worked on Azure Data Factory, Azure Synapse Analytics, Azure Storage Accounts, Azure Databricks for data engineering workflows
  • Managed Identity and Role based Access (RBAC) using Privileged Identity Management (PIM)
  • Worked on Setting up different Vnet and Subnets for different environments
  • Worked on Azure Database for PostgreSQL, MySQL, and Azure Cosmos Db
  • Implemented different auto scale down and up jobs for Cost Optimization for Azure SQL Data Warehouse.
  • Managed SQL Servers on Azure Virtual Machine (IaaS)
  • Worked on setting up High availability and Disaster Recovery solutions like Geo-replication
  • Planned and implemented Database Backup strategy with associated Disaster Recovery procedures according to RPO, RTO, and SLA of the company
  • Used Windows PowerShell and different Maintenance plans to automate tasks like updating statistics, reorganizing, and rebuilding Indexes and check the consistency of databases
  • Removed Security Vulnerabilities from Multiples Machines on both On Premise and Azure by consistently applying patches and hot fixes
  • Solved Concurrency problems of blocking and deadlocks, by viewing and tracking them using Activity Monitor and Management Studio summary page and Profiler
  • Configured SQL Server Reporting service, developing, and publishing reports
  • Implemented and monitored SQL server high availability and disaster recovery solutions like Log Shipping, Mirroring, Clustering and Always on Availability Group
  • Evaluating CPU, Disk I/O and Memory related bottlenecks, blocking and deadlocks by using activity monitor, SQL logs, SQL Profiler & other tools
  • Installed and Configured SQL Server on virtual like VMware and Virtual server
  • Responding to requested tickets and fixes any database issues.
  • Working with CDC, Data Compression, and TDE
  • Set up baseline workloads using the SQL profiler and database tuning advisor (DTA) which resulted in providing the missing and superfluous indexing on tables.
  • Configured SSRS using configuration manager, created, and maintained security roles
  • Responsible for creating and deploying reports based on requirements using SSRS.
  • Used Various SSIS tasks such as Conditional Split, Derived column for Data Scrubbing
  • Used SSDT to extract data from multiple sources (Excel and flat files) and load into SQL Server databases and from SQL Server to Spreadsheets.
  • Deploy SQL scripts in production environments, applying patches, performing code review/optimize SQL for reporting, interfaces, and data conversions.
  • Executed Change management scripts on daily/weekly basis

Environment: MSSQLServer2008R2/2012/2014, MS Access, Azure DevOps, Azure Portal, PowerShellWindows 2003/2008/2012 /2016/2017 DTS/ SSIS, SSRS, Visio, Lite speed, SQL Diagrams, Index tuning wizard, SQL Profiler, Query Analyzer, HPSM, PowerShell, Service Now, Jira

MSSQL Server Production DBA

Confidential - Richmond, VA

Responsibilities:

  • Responding to developer issues and guiding them to write performing T-SQL codes.
  • Worked on Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to multiple Terabytes.
  • Developed and created new database objects including tables, views, index, stored procedures and functions
  • Created Entity-Relationship diagrams and flow diagrams using Visio and documenting
  • Created maintenance plans to automate updating statistics, reorganizing, and rebuilding Indexes and check the consistency of databases
  • Addressed SQL Server security issues by creating user logins with the principle of least privilege and monitoring those user accounts regularly by using SQL Profiler
  • Planned and implemented Database Backup strategy with associated Disaster Recovery procedures according to RPO, RTO, and SLA of the company
  • Used Windows PowerShell and different Maintenance plans to automate tasks like updating statistics, reorganizing, and rebuilding Indexes and check the consistency of databases
  • Solved Concurrency problems of blocking and deadlocks, by viewing and tracking them using Activity Monitor and Management Studio summary page and Profiler
  • Configured SQL Server Reporting service, developing and publishing reports
  • Worked with developers during Capacity planning, logical and conceptual modeling and ER- diagram development of databases and placement of data
  • Implemented and monitored SQL server high availability and disaster recovery solutions like Log Shipping, Mirroring, Clustering and Always On Availability Group
  • Evaluating CPU, Disk I/O and Memory related bottlenecks, blocking and deadlocks by using activity monitor, SQL logs, SQL Profiler & other tools
  • Installed and Configured SQL Server on virtual like VMware and Virtual server
  • Responding to requested tickets and fixes any database issues.
  • Working with CDC, Data Compression, and TDE
  • Set up baseline workloads using the SQL profiler and database tuning advisor (DTA) which resulted in providing the missing and superfluous indexing on tables.
  • Configured SSRS using configuration manager, created and maintained security roles
  • Responsible for creating and deploying reports based on requirements using SSRS.
  • Used Various SSIS tasks such as Conditional Split, Derived column for Data Scrubbing
  • Used SSDT to extract data from multiple sources (Excel and flat files) and load into SQL Server databases and from SQL Server to Spreadsheets.
  • Deploy SQL scripts in production environments, applying patches, performing code review/optimize SQL for reporting, interfaces, and data conversions.
  • Executed Change management scripts on daily/weekly basis

Environment: MSSQLServer2008R2/2012/2014, MS Access, Azure, Windows 2003/2008/2012 , DTS/ SSIS, SSRS, Visio, Lite speed, SQL Diagrams, Index tuning wizard, SQL Profiler, Query Analyzer, HPSM, PowerShell

SQL Server Production DBA

Confidential - Houston, TX

Responsibilities:

  • Installed, configured, administered, and secured SQL server 2005, 20008R2, 2012/2014 on production and non-production in Clustered and Standalone server environments.
  • Configured and monitored Always On availability group on windows failover cluster
  • Re-synced availability database on all replicas using T- SQL script and manually.
  • Implemented SQL Security and object permissions like creating end users and logins and assigning roles to the users and managing user permissions
  • Identify orphan users in the servers, successfully migrated end users between multiple servers.
  • Developed and approved T-SQL scripts to production SQL server databases
  • Worked on production issues like log space full, blocking and deadlocking
  • Worked in a process-based environment, responded to trouble tickets with various severity levels and fix any database issues promptly to meet SLA of the company
  • Implemented Change requests and infrastructure service requests on a regular basis
  • Redesigned and placed the physical files of a tempdb database on their own drives.
  • Reassessed database capacity growth patterns and set up accounts for the SQL Server to avoid using the SA account.
  • Posting an Incident resolution ticket, perform Root cause analysis and documenting solutions
  • Performed Server buildups and decommissioning on a regular basis
  • Monitored Maintenance plans and jobs to maintain database quality and troubleshooting Job failures when they occur in the system.
  • Tested Backup and Recovery strategies by simulating various recovery scenarios like loss of datafiles, Transaction logs, Point in time recovery
  • Worked on data maintenance tasks like Reorganizing and rebuilding indexes
  • Checked database Health and consistency by using DBCC commands and DMVs
  • Created SSIS Packages to Extract, Transform and Load data into Reporting instance to generate the reports easily and quickly

Environment: Windows 2008R2, 2012R2, MS-SQL Server 2016/ 2014/2012/2008 r2, T-SQL, MS SQL Server Integrated Services (SSIS), SQL Server Agent, SSRS, SQL Profiler, Visual Studio, TFS, Service Now and JIRA Ticketing System.

SQL Server DBA

Confidential

Responsibilities:

  • Installed and configured SQL Server 2008 on Windows 2003/2008 servers applied service packs and security fixes in Clustered and Standalone environments.
  • Worked extensively on installation, upgrade and configuration of MS SQL server 2008 and 32/64 bit SQL Server Cluster for SQL 2008
  • Configured Merge and Transaction Replication from production to DR Servers and reporting server with multiple subscribers.
  • Implemented high availability solutions for mission-critical databases with clustering and Always on Availability group
  • Configured Log shipping using SQL Server Management Studio.
  • Created and scheduled maintenance plans for tasks like backups and cleanups
  • Monitored job and alerts, CPU utilization, Data and log file sizes and space availability Verify backups and error logs on the servers and troubleshoot any failures alerts
  • Tested Backup and Recovery strategies by simulating various recovery scenarios
  • Monitored database quality including database consistency check with DBCC, Defrag, and index tuning and monitored error logs.
  • Created ETL packages with different data sources (SQL Server, Flat Files, and Excel ETC) and loaded the data into destination tables by performing different transformations using SSDT.
  • Created and modified tables, stored procedures, views, indexes trigger and UDFs
  • Tuned queries and improve performance by using tools like DTA and SQL Server Profiler
  • Created Active Directory Users, Computers, and Organizational Units and assigned NTFS permissions by interacting with system administrator
  • Installed Virtual box and created multiple VMs and installed Windows Server 2008 R2
  • Worked with System administrator for configuring DHCP and Static IP Addresses for different machines

Environment: MS SQL Server 2008 R2/2008/2005, T-SQL, MS SQL Server Integrated Services (SSIS) SQL Agent, SSRS, SQL Profiler, Windows 2008/2003 server, Visual Studio, and.Net Framework.

Hire Now