BABAK DEZFOULIAN

Fairfax VA ***** 571-***-**** ad4h92@r.postjobfree.com

Senior SQL SERVER DATABASE ADMINISTRATOR DATA OPS

Production Servers Server Configuration Data Security & Automation Performance Tuning & Maintenance Troubleshooting Database management High Availability Agile Environment

Jira Confluence & BMC remedy ticketing GitLab and Test Overmined

TECHNICAL SKILLS

Databases: MS SQL Server 2008,2012,2014,2016, 2017,2019, Oracle 19 C, MS Access

Languages: T-SQL, PL/SQL, PowerShell, SQLCMD, HTML

Hardware: RAID Operating System: Windows Server 2008, 2012, 2016,2017and 2019

Software: Microsoft Office, Power BI, Visual Studio, Team Foundation Server, MS SQL

PROFESSIONAL EXPERIENCE

Globys Inc/Harris Remote Oct 2020 to Present

Senior SQL Database Administrator

Oversaw billing processing across multiple companies including T-Mobile, AT&T, TELUS, Orange Belgium, Vodafone, Telstra, and Frontier. Installed and managed SQL servers from 2008 to 2019 and over 900 databases with multiple sizes (VLDB).

• Performed database backup, restore, disaster recovery, Maintained documentation for technical systems.

• Led High availability groups Always on, replication, and log shipping and clustering.

• Managed ETL processing, including development and maintenance of data extraction processes.

• Improved performance and stability of SQL database systems. Used methods to tune SQL statements and Stored Procedures.

• Created and Developed SQL scripts and Stored Procedures. Tune the scripts to find data, alter data models, and data correction.

• Investigated and implemented solutions for data quality issues, tested and debugged SQL packages and Stored Procedures.

• Worked and supported developers with SSIS packages and coordinated between application and DBA team.

• Translated business into technical requirements.

• Collaborated with DBA and Development team to create and implement standards and meet expectations.

• Migrated SQL databases to Azure (IAAS and PAAS). Working with Azure databases.

• Maintained Subversion code in accordance with company policy.

• Upgraded SQL server from lower versions to higher versions (e.g., 2008,2014 and 2016 to 2019) and worked with data migration.

• Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS).

• Knowledge in data analyst and data modeling.

Niyam IT- IBM Global Business Service Apr 2018 to Oct 2020

SQL Database Administrator

Worked on government project; September Eleventh Victim Compensation Fund (VCF). Responsible for SQL server security as a System Admin. Helped and supported Oracle Developer on TSA Project.

Managed 85 SQL servers and 435 databases with different sizes from 20G to the largest size of 13T in development, QA, Test, Stage, UAT and Production.

Worked with SQL Server Performance Monitoring Tool. Also troubleshooting such as indexing, CPU and memory configuration, slow running queries, lock and blocking and using try and catch process to eliminate deadlocks.

Implemented the new SQL Server 2016 mechanisms including data compression, online indexing, contained databases, security principals and AAG.

Worked on configuring SQL Server with minimum privileged access.

Installed and managed database from SQL Server 2008 to 2016 and 2017.

Worked on SQL Server 2012 migration from SQL Server 2008 to 2016,2017and 2019.

Implemented Always-ON (AAG) on SQL Server 2016.

Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

Oversaw Memory configurations for SQL Server 2008 to 2017.

Managing SQL Server transparent data encryption (TDE) and monitored all encrypted databases.

Worked with IBM JAZZ change management.

Created VM in Azure environment and installed Always ON high availability.

Assisted and supported SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), and SSAS (SQL Server Analysis Services) functionalities to enhance data integration, reporting, and analytics capabilities.

Wal-Mart (Lab) Reston Virginia Feb 2014 to Apr 2018

SQL Database Administrator

Installed, configured, maintained SQL Server in development, UAT and production environments on different platforms including stand alone and windows cluster. Managed SQL servers from 2008 to 2016 and databases with multiple sizes (VLDB)

Upgraded earlier versions of SQL Server to SQL Server latest version.

Migrated MS Access databases into MS SQL Server

Configured and maintained database Always On, Replication

On-call requirements to ensure 24 x 7 support of database operations

Worked closely with other teams to deploy databases and manage availability.

Performed day-to-day and long-term monitoring of system health as it relates to database usage and performance.

Wrote T-SQL, including complex stored procedures, functions, views, and triggers.

Maintained indexes for performance improvement.

Implemented data partitioning to improve performance.

EDUCATION

Bachelor of Science, Azad University of Iran

CERTIFICATIONS And Trainings

MCITP (Microsoft Certified IT Professional) SQL Server – Database Administration (MCSA)

Microsoft Azure Administrator Certified ICDL Licensed (Microsoft Office)

Training on AWS AZURE

Contact this candidate