Sql Database Administrator

Summary

An experienced and Certified in Azure SQL and MS SQL Server Database with over 6 years of experience in IT, Database Administration, Development, Azure Cloud, SQL/TSQL programming, seasoned in managing databases & servers in Dev, Test, UAT/Staging and Production Environment and keep up-to-date with industry knowledge, looking for SQL Server Database Administrator position.

Professional experience entails configuring and managing Databases and Database Instances using SQL Server 2019/2016/2014/2012/2008 R2 including backup, restoration, HA/DR solution with Database Mirroring, Replication, Always-On, and Clustering, upgrading, migration, apply patches/Patch Management, supporting clients, Database Monitoring, troubleshooting, Performance Tuning, Database Security, Database Development, Data Modeling, SSIS (ETL) and SSRS (Data Analytics) and Operating System Windows Server 2016, 2012, 2008 R2, including Virtual and Azure cloud Environment. Dedicated and responsive professional requiring minimum or no supervision and be productive from the first day of the job.

Technical skills:
Installed, Configured, VM Machines, and Managed Database Instances in Virtual Environment.
Database Administration in Azure SQL, MS SQL Server (2019/2016/2014/2012/2008R2/) in Production, Development, UAT, and Test Environment.
Performance Tuning: Monitored Server, Database, Query Performance, Memory, CPU, Disk IO issues and performed Troubleshooting of long running query, used different tools (Native & Third-Party tools) SQL Server Profiler, Extended events, Database Tuning Advisor, Execution plan, Performance Monitor and Activity Monitor, DMV, DBCC, Windows Event Viewer, SQL Server Error Log, Agent Error Log,
Index Management: created, modified, deleted indexes not required reorganized and rebuilt indexes.
SQL/T-SQL Programming wrote queries, procedures for Database Administration, Application and troubleshoot purposes.
High Availability and Disaster Recovery solutions (Log shipping, Mirroring, Replication, SQL Server Fail Over-clustering and Always On)
Data Transfer/Move ETL Projects Created ETL Packages to feed data into reporting, Data Warehouse databases, setup jobs, monitored, troubleshoot issues like failure or delayed tasks. Besides that, load data into Azure SQL/SQL Database from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) and used data transformations wherever needed
Capacity planning and implementing disaster recovery solutions, Backup, Restore, Point-in-Time Recovery according to RTO and RPO.
Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed.
Performed Data Modeling Tasks for new app and redesigned existing schema for Logical and Physical data modeling used different data modeling tools like ERWin.
SQL Server Reporting Services (SSRS): created various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
Security Management: SQL Servers and Databases, users and Logins, Data Encryption TDE and Column and Row Level Encryption, and Dynamic data masking and Always Encrypted.
System Databases configuration and Management: TempDB, MSDB and Master DB
Created and updated all required documentation such as SOP (Standard Operating Procedures), Migration runbook, Upgrade runbook, Apply SP, Install and configure Instances, Install and Configure HA solutions and so on

Expectations

Diversified work environment and integrated with the new technology

Employment Preferences

Expected Base Salary

**,000 USD

Expected Hourly Rate

** USD/hr

Academic Degree

Security Clearance Level

Experience

Skills

• SQL Server Database Administration