Location – TX

Contact No – 832-***-****

Email - ad11em@r.postjobfree.com

SQL GILBERT DATABASE ADMINISTRATOR N TASHI

SUMMARY

• Certified Premise an SQL Azure Database cloud administrator and Development with 6+ for years very of large IT Experience and complex in Database databases Administration in Microsoft SQL ON

• • • • • • • • Server Possess high maintaining, Experience servers, Experience Working Functions, Experience Azure Experienced business Migrations Highly (SSIS)availability . PaaS articulate 2019/SQL comprehensive processes experience Constraints from in in in Server in and 2017/Extract Developing Synapse Data on-with troubleshooting and within Database prem 2016/Modeling Transform excellent on and disaster SQL skills High Performance the the 2014/Views. Pools, and scope Power Availability communication, used in Load 2012/recovery excel. managing databases of Azure to BI (corresponding 2008 ETL) define Tuning, report clusters configurations. SQL development R and on in and leadership using Server, Development, creating both administering to analyze Microsoft information different two-Databricks, using and and node data This interpersonal Test Data SQL tuning Azure requirements and Microsoft includes systems and Server Sources Azure three-PaaS Stored Production in expertise Integration SQL node and Data organizations. skills. like needed Procedures, IaaS. Server SQL clusters. Factory Environments. in Server to Services databases configuring, support (ADF)Triggers, Analysis, and the in

• Excellent with ability interpersonal to effectively and understand communication the business skill. Good requirement documentation to develop and a process quality product. management skills SKILLS

Languages SQL, T-SQL, Azure SQL Databases

Databases MySQL, MS SQL Server 2008-2019

Visualization Tools Power BI

Cloud Azure SQL Manage Instances, SQL Azure VMS, Azure Database Migration Service

Reporting Tools SQL Server Reporting Tools (SSRS)

Other Security, Group, Replication, Backup and Log Restore, Shipping, Hyper-SSIS, V, SSAS, IaaS, SaaS, Performance PaaS, Always Tuning, on Monitoring Availability and Capacity planning

Operating Systems macOS, Windows, Linux, iOS, Android EDUCATION & CERTIFICATION

Bachelor University of of Science Buea, in Computer Science DP-300 Administering Microsoft Azure SQL Solutions EXPERIENCE

KPMG, NJ Nov 2019

– Present

Senior SQL Database Administrator

Responsibilities:

• • • • • • • • • • • • • • Maximize environments index Installed performance Manage space, Create access Perform Manage Monitors and Create plans Install maximize Coordinate Troubleshoot recovery Ensures Time Install, Create according follow-Objectives for rebuilds, requesting to and upgrade and Logins, upgrades, database the routine all and the information. and and system to the up. release execute maintain database storage Security SQL in configured through audits application up file other Users, demanding and and backup Server stability. users additional service time compression, management SQL test environments Disaster issues Policies corporate detailed servers Participate and system and of and database environment. Server high packs SQL database production permissions security. in storage, recovery Recovery defined are monitoring, production availability operating backup DBAs Server statistical & in for software backed deployment for disaster and connectivity, by testing, SQL during the testing. environments. and databases the and providing procedures, and to up SQL performance updates, Server in recovery company. recovery ensure addition including managed meeting change development Perform Server activities. database supporting growth Azure and data policies planning, configuration planning, databases, to Recovery testing recovery Security database tuning, troubleshooting redundancy, SQL statistics. environments and and the and implementation, scheduling, issues, exercises Point issues consistency including maintain documenting Production, routine documentation, failover Objectives, query of database as the optimal maintenance integrity to tracking, needed. checks. readiness, secure performance, Server staging and recovery including issues sizing, and testing. and implementation, and databases and tasks maintenance reliability scenarios. and monitoring Databases Recovery Test/disaster optimal such Dev and as of

• Troubleshooting deadlocking issues, and replication resolving issues, database log shipping integrity issues, issues, connectivity performance issues, security issues, issues. blocking and Dell, TX

Jul 2017 - Oct 2019

SQL Database Administrator Responsibilities:

• • • • • • • • • • • • • Automated space Upgraded sideby-Setting Server Used database Created Created Configured Designed reporting Backup Wrote user Identified data Designed, distributions Increased processes. Wrote dynamically cleansing defined SQL and complex Management side T-up and Azure SSIS SQL code applications. and Profiler the backup efficiency and Connection Developed SQL migration different restore based function package (field Hash, created SQL and queries and migrated SQL mail verification for T-on error and DB, Azure queries, Replicated Studio SQL agent by database troubleshooting, to inputs. to as Strings data Azure column Azure and providing implement Export checking well code databases SQL for (extracts, SSMS) stored procedures SQL as using sending and from Databases. SQL and level related and backup Data in optimum connecting for procedure, Round-the developers SSIS from Data the Import data supporting Developers. automatic monitoring, warehouse, business activities and ETL package to quality Monitor SQL warehouse Robin) restore, data database generate packages. SQL Triggers, and Server logic. SSRS, issues mails. from and including while and Server Azure and QA. Detach different performance optimize SQL 2008 DML Power Fact optimization of views creating Analysis AZURE the Server backup, and scripts to and source BI, & queries. the Attach. SQL index Fact\Databases Tableau Services, Dimension to performance with monitoring of Server that Access, systems Dim. using SQL efficient modified or Azure Server from DML, 2016 Text other to tables. database drive of locally Data and DDL backup using and cloud visualization database the EXCEL Used Factory. command nonproduction Installed in database data health, and place files different quality, restore objects tools sand disk SQL and and