Resume

Sign in

Sql Server Data

Location:
Anaheim, California, United States
Salary:
negotiations
Posted:
January 22, 2019

Contact this candidate

Resume:

SABA TEKLE

ac79ph@r.postjobfree.com 657-***-**** ANAHEIM, CA 92805

SUMMARY

* ***** ** ********** ** SQL Server DBA (2012, 2014,2016,2017) in Production, Development and Design Environments.

**/* ** Call Support for Production Database.

experience in Configuration, Implementation, and Maintenance for HA DR High Availability Disaster Recovery techniques like Log Shipping, Mirroring High safety High performance, Replication (Snapshot, Transactional and Merge) and Clustering Active-Passive and Active-Active in SQL Server 2012-2016.

Experience with deployments, Maintenance and troubleshooting applications on Microsoft Cloud infrastructure Azure.

Experience working with Azure SQL Database Import and Export Service.

Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.

Experience in Installation, Upgrades, Patches, Configuration, and Administration for SQL Server in a Clustered and Non-Clustered Environment.

Experience working with data-tier application DAC for Migration.

Having good experience in daily database maintenance and administrative tasks like Space issues, transaction log file size growth, connectivity issues and regular monitoring of SQL Server error logs and Windows event viewer, Policy-Based Management, Resource Governor, Data Compression.

Migrated and maintained data using various utilities like DTS, SSIS, Import and Export, Attach/Detach Data Migration tools and used ETL packages to move login/jobs from one server to another server.

Working experience T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, Distributed Queries, cursors using SQL Server 2012/2014.

Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.

Auditing of a database for user transactions, login and database action and removing orphan users and working with contained users and scheduling database tasks (Jobs, Alerts, Email, Notifications).

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Extensively used tools like SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server performance and Performance Data Collector/TDE.

Experience in using DMVs, DMFs, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and inbuilt Global Variables for instant analysis along with 3rd party tools.

Experience in identifying the I/O and memory, bottlenecks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, and handling them by implementing better Query Execution plans.

Strong Communication & Management skills and Excellent Team player.

EDUCATION AND CERTIFICATIONS

Bachelor of Arts in Business Management and Accounting, Halhale College, July 2012

Certificate for MS SQL Server DBA, December 2012, MAY 2016

Microsoft Certified Professional (MCP) certification 70-461,70-462,70-463 for 2012/2014.

PROFESSIONAL SUMMARY

FedEx (Santa Ana, CA) 9/2018--12/2018

AZURE SQL DBA

Responsibilities

Experience working with SQL Database Migration Wizard SQLAzureMW and Azure SQL Database Preview v12.

Associated routes with VNets via the route table per relationship constraints.

Setup Azure Virtual Appliances (VMs) to meet security requirements as software-based appliance functions (firewall, WAN optimization, and intrusion detections).

Experience configuring and troubleshooting Geo-Replication and OMS Storage for Event Audits

Experience implementing TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking) Features.

Experience working with Database Synchronizations and HUB - MEMBER Topologies.

Experience troubleshooting automated backups and metric management.

Ability to select correct tier for Azure SQL Databases and Azure SQL Date warehouses.

Experience working with Performance Metrics and Plan Management.

Ability to working with multi-instance management and authorization.

Working with OMS for Log Analysis and Threat Detections. Database / Server Perfmon Counters.

Provided high availability for IaaS VMs and PaaS role instances for access from other services in the VNet with Azure Internal Load Balancer.

Working experience on designed and built cloud service models including Infrastructure-as-a-Service, Platform-as-a-Service, and Software-as-a-Service.

123 URGENT CARE (Tustin, CA ) 9/2016-5/2018

SQL Server DBA

Responsibility

•Provided support for 24x7 availability of Database Services.

•Involved in Migration and Upgraded SQL server of Databases from SQL Server 2012/2014 to SQL Server 2014/2016 using in place and side by side migration techniques.

•Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels.

Responsible for Monitoring and Troubleshooting SQL Jobs, Scheduled Tasks, Disk spaces, Error logs and making recommendations for performance improvement in hosted databases which involved Index creation, Index removal, file group modifications, and scheduling jobs to rebuild/reorg indexes and update statistics.

•Working experience on Planned, Configured, Installed, Maintained SQL Server in an environment of for Active/Active/Passive Clustering in SQL Server 2012.

•Working experience in developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers, user-defined functions and Cursors to handle database automation tasks.

•Work involvement in performance monitoring of Memory, Processor, Disk I/O and fine-tuning.

•Experience in Using DMV's, Performance dashboard, Mirroring, database snapshot.

•Configured Disaster Recovery solution with Transaction Replication from Distribution Server with multiple subscriptions with Updatable Subscribers for (Push & Pull) methods.

•Working experience in (ETL) Extracting, Transforming and Loading data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using OLE DB connection by creating various SSIS/DTS packages.

•Experience in Index Maintenance, Index tuning and monitored error logs, Rebuild Reorganizing according to Index fragmentation, running DBCC checks and Update Statistics to check Data Integrity.

Environment: SQL Server 2012/2014/2016, Windows 2012, Lite Speed 5.0, Performance monitor, Replication, MS Failover, High availability and disaster recovery, SSIS and ETL.

ADEL PRIVATE COMPANY (Kampala, Uganda) 1/2015-7/2015

SQL Server DBA

Responsibility

•Involved in assisting SQL Server prime customers with Configuration, Administration, Implementation, and Trouble-shooting for Business workflow with Log Shipping mechanism.

•Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Experience in handling the Isolation Levels and Concurrency Effects.

•Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks and Performed security tasks like Grant, Revoke permissions.

•Resolved issues for mission-critical high usage of system CPU, Disk, Deadlocks and Transaction per/sec, Memory.

•Involved in performing and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.

•Implemented SSIS packages for the exchange of data between different data sources.

Environment: Microsoft SQL Server 2012/2014, Management Studio, Query Analyzer, Profiler, T-SQL, SSIS, Mirroring, High Availability.

MOE CENTRE (Asmara, Eritrea) 1/2013-8/2014

Junior SQL DBA/Developer

Responsibility

•Responsible for General Database Administration, Query Performance tuning with SQL Profiler for better performance and monitoring job backups, integrity and optimization on all databases

•Installed and configured the necessary component to ensure that the database is accessible

•Maintaining the Database consistency using DBCC and Troubleshooting Problems by using SQL server profiler.

•Prepare Data Flow Diagrams (DFD’s) and Entity Relationship (ER) Diagrams.

•Implemented Point-In-Time recovery solutions and recovering the data from backup in disasters.

•Involved in creating and managing schema objects such as Tables, Views, Indexes, Procedures, Triggers and maintaining referential integrity Constraints and data consistency.

•Creating and monitoring all maintenance jobs backups, integrity, and optimization on all database

•Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

•Migrate SQL Server 2008R2 to SQL Server 2012 and SQL 2012 to 2014 in Microsoft Windows Server 2012 Enterprise Edition. Successfully migrate 150 SQL 2008R2 database to SQL 2012.

•Setup and configured database mirroring in High performance, High availability mode as standard Disaster recovery strategies. And handle PRO\DEV servers with more than 2TB of Database size.

Environment: window 2008/2010, MS SQL Server 2008/2008R2/2012 Enterprise, T-SQL, Lite speed, SQL Query Analyzer, Access, Word, SQL server profiler, SSMS.



Contact this candidate