Assistant Sql Server

Faranak “Fara” Dezfoolian Arlington, VA 571-***-**** ****.**********@*****.***

Objective

Certified Microsoft SQL Server database administrator (DBA) with six years of professional experience that maintains and develops different business systems in using Microsoft technologies. Systems and policies providing me with the opportunity to use my background in Information Technology and expand my professional experience in this field.

Project History

AcariaHealth/Centene November 2014-Present SQL Server DBA Falls Church, VA

DB Administration/Configuration

SQL Server 2008-2016 installation/configuration across all environments (Development to Production)

Administer SQL Server High Availability and Disaster Recovery strategies

Configure SQL Server access controls, multi-failover Always On (e.g. Quorum setting), High Availability best practices (e.g., active/passive clustering, mirroring, log shipping, transaction replication)

Optimize memory, CPU, and IO configurations

Linked servers across SQL Server & Oracle 9i/10g

Configured database mail, linked servers, Transparent Data Encryption (TDE), Change Data Capture (CDC), and Change Tracking (CT)

Performed administrative tasks using PowerShell scripts

Performed backup restoring using LiteSpeed tool, and restore individual objects

Conducted meetings with teams to meet corporate milestones for database merging/data movement

Reviewed technical designs, reports, documentation, and other materials produced by team members

Configured/Maintained database replication across disparate SQL Server instances and remote sites

Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build

Create/maintain corresponding documentation (e.g., Build Guide, Database Decommissioning/Restore)

Execute SQL Server upgrades from 2008 through 2016

Install, configure, and administer SQL Server Reporting Services (SSRS) and Integration Services (SSIS)

Created SSIS packages for data validation and cleaning utilizing various transformations

Used DMA (Data Migration Assistant) for migration On premise to on premise & On premise to cloud

Monitoring/Troubleshooting

Regular query analysis via query execution plan (e.g., slow running, high resource consumption)

Day-to-day activities included troubleshooting issues around memory usage, query performance,

sever issues, as well as auto-job failures

Executed tasks of inventorying user permissions, disk space usage across Production and Semi-Production servers

Oversaw scheduling of database projects, database and transaction log backups, notifications

Corrected findings of orphan users after SQL database migration from 2012/2014 to 2016

Used extended events, Dynamic Management Views (DMV), and Wait Stats to tune/optimize DB performance

On-going index analysis/tuning

Identified bottlenecks related to database, query, and server performance issues from slow running/blocking queries, high CPU Utilization

Resolve deadlocks, blocking/locking conflicts stemming from high resource utilization

Troubleshoot application connectivity issues in availability groups

Production Support

On-call Production database support

Disaster Recovery planning and implementation

Infrastructure monitoring of application/server logs, space usage, scheduled tasks, log shipping, mirroring configuration, and agent job history via PowerShell scripts

Regular application of Service Packs and hot fixes

Collaborated with developers to implement SQL code change control process in using TFS, SQL compare

Created/Scheduled maintenance plans to update statistics, check fragmentation, database integrity,

and backup plans

Conducted database backup/response using native functionality as well as using third party tools

Implemented maintenance plans for index optimization, rebuild, and reorg based on fragmentation

SQL Development

Write T-SQL, Triggers, and Stored-Procedures

Assist database developers to optimize SQL queries, Stored Procedures, functions

Export data from SQL Server to multiple destinations for sales forecast and other use cases

Coordinate acquisition and movement of data using Extract, Transform, Load (ETL)

Fine-tuned T-SQL stored projects using SQL Server execution plans for optimal performance

Created T-SQL database objects including tables, views, functions, stored procedures and indexes for various business rules/logic

Facets Care September 2012-October 2014 Help desk Supporter Centerville, VA

Answers questions about installation, operation, configuration, customization, and usage

Applies troubleshooting to identify problems, investigate causes and recommend solutions to correct common failures and provide follow-up.

Escalates complex problems

Performs root cause analysis and develops checklist for typical problems

Enters information into call tracking database

Works in a team setting, sharing information and assisting others with calls

Quick learning of technical and procedural topics; a self-motivation and self-learning work approach

Worked on unique projects simultaneously; an analytical mind and excellent team player

Technical Skills

Databases: MS SQL Server 2016, 2014, 2012, 2008 R2, 2008, MS Access, MySQL (4.0.3, 5.0.1), Oracle 11G

ETL Tools: MS SQL Server Integration Services (SSIS)

Programming Languages: T-SQL, ASP, ASP.net, VB/JavaScript C, C++, XML

Operating Systems: Windows 2012/2008 server, Ubuntu, Red Hat

Web Servers: IIS 5.0,6.0,6.5,7.0,7.5

Other Tools: MS SQL Server Migration Assistant (SSMA) and ODBC/DB Link, Data Migration Assistant (DMA), JIRA, MS Always On, MS Azure, MS SQL Server Clustering and Performance Tuning, Toad Data Modeler, Red Gate, VISIO, LiteSpeed, Service Desk, Idera, AWS, Spotlight.

Education & Training

Bachelor of science (George mason University) Fairfax, VA September 2008-July 2012

Languages

English, Farsi

Training & Certification

MCSA: SQL 2016 Database Administration- Certified 2020

Administering a Microsoft SQL database Infrastructure

Azure Administrator Associate

In progress: CompTIA Security+

Contact this candidate