Bilkis Akter, Washington DC.

Phone: 202-***-****

Email: ad2vzx@r.postjobfree.com

An experienced Certified Microsoft SQL Server Database Administrator with over 6 years of experience. Professional experience entails in configuring, and managing Databases and Database Servers using SQL Server 2019/2016/2014/2012/2008 R2

Summary of expertise

Extensive experience in SQL Server Database Management System in the areas of Database Administration, Reporting (SSRS), Data Modeling, Database Design and Development, Advanced Installation, Configuration, Backup and Recovery, Upgrade, Service Pack (SP), SQL/T-SQL, Stored Procedure, Trigger, DMV, DBCC, Clustering, Always On, Log Shipping, Mirroring and Replication.

Configured and managed High Availability and Disaster Recovery solutions.

Working on multiple data modeling projects including gathering, analysis, conceptual, Logical and Physical data modeling using tools ERWin, Toad Data Modeler, SSDD.

Extensive work experience in Compression, Database maintenance and Optimization.

Experienced with SQL/T-SQL scripts including scripts/SQL/TSQL

ETL: SSIS & DTS Packages: Created, configured, deployed, and managed including Migrate and Upgrade.

Reports: SSRS - Highly proficient in Installed, Configured, and administered SQL Server Reporting Services (SSRS), created, deployed, managed reports including migrating reports.

Manage Security Management: Securing SQL Servers and Databases, Manage users, Data encryption, granting/ revoking access.

Tools: SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, Performance Monitor, Activity Monitor, Execution plan, Toad Data Modeler, SQL Server Data Diagram (SSDD), ERWin, RedGate and SolarWinds.

Ticketing tools: Service Now and JIRA

Power BI Desktop

Microsoft Azure Cloud Architecture

Education & Certifications

Masters- 2012

MCSA 70-462

MCSA 70-463

DP-300

Training in Microsoft Azure Cloud Architecture.

Training in Microsoft SQL Server Database Administration.

PROFESSIONAL EXPERIENCE

Data Group Sep 2020-current

Alexandria, VA

Azure SQL Server Database Administrator

Responsibilities:

On-Premise Based Migration: Migrated platforms to Azure Cloud Platform/systems.

Cloud Based Migrations: Migrated Active Directory to Azure Active Directory, databases, and applications to Microsoft Azure Cloud.

Designed and Implemented Disaster Recovery and Backup Strategy using Azure BLOB storage considering RTO and RPO requirements.

Managed users access onto environments based on roles, access policy and resource groups.

Creating and Implementing azure Networking port in Azure Network Security Group.

Architected and delivered scalable enterprise solutions using various Azure services.

Configure Azure Active Directory (Azure AD) Application Proxy connectors to work with outbound proxy servers.

Creating and Implementing Virtual Machine in Azure Platform and managing the virtual Machine.

Creating Azure Virtual Network Peering.

Implementing Azure App Services.

Managed SQL Database Servers in Development, Test, and Production environment.

Created conceptual, logical, and physical data model.

Designed, developed, and managed Azure SQL and SQL DB databases to support various business applications, ensuring optimal performance, security, and scalability.

Implemented data warehousing solutions and ETL processes using Azure Data Factory, enabling efficient data integration and transformation for business intelligence and analytics.

Collaborated with cross-functional teams of developers, business analysts to deliver data-driven solutions that met business objectives.

Configured and managed Azure SQL Database elastic pools for efficient resource utilization and cost savings, optimizing costs based on workload demands.

Utilized Azure SQL Database Hyperscale for handling large-scale OLTP workloads and enabling fast data ingestion and query performance.

Implemented high availability and disaster recovery solutions for Azure SQL and SQL DB using features such as failover groups, replication, and geo-replication.

Ensured compliance with data governance policies and procedures, maintaining alignment with regulatory requirements and data privacy laws.

Monitored and optimized database performance using Azure SQL Database Query Performance Insight, Azure SQL Analytics, and other performance-tuning tools.

Integrated Azure SQL and SQL DB with other Azure services such as Azure Functions, Azure Logic Apps, and Azure Event Grid for building serverless applications.

Installed, configured database associated tools and performance monitoring Software.

Setup, Configured, monitors and Maintained Database Replications.

Installed, configured, maintain and monitored SQL Server Database Mirroring.

Configured and Maintained Log Shipping as Standby database for Reporting

Securing SQL Servers and Databases, managing users, Data encryption, and granting/ revoking access.

Data Encryption and Data Decryption for data security in Database & Column level.

Managed Backup/Restore, Point-in-Time Recovery including backup verification.

Applied SP (Service Pack) on SQL Server 2008R2 and 2012.

Monitored data activities such as logs, space utilization, locks, long transaction, T-SQL, Stored-Procedures, Triggers, Function, Views, Indexes.

Created and managed Indexes, Constraints, and Keys (Primary Key, Foreign Key).

Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering

Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.

Monitor SQL Server Error Log, Space usage, SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, Performance Monitor, Activity Monitor, Execution plan.

Besides Native tool, used SolarWinds Third-Party Tool for monitoring and Performance Tuning.

Automated jobs for backup, monitored database health, disk space, backup verification.

Developed maintenance plans such as backups, index management, fragmentation management, cleaning history, deleting old files.

Monitored Server Activity, Error Log, space usage, and solving problem as needed.

Environment: Azure Cloud, VM, Vet, Azure App Services, Automation, Monitoring, Azure Storage, Database Services, Azure SQL, SQL Server, Secure Data, TDE, Encryption, IIS, Windows Server 2016 R2, 2012, JIRA, SSIS ETL, Informatica, SolarWinds

From Oct 2018 to Aug 2020

NOAA (National Oceanic and Atmospheric Administration)

Washington DC

SQL Database Administrator

Responsibilities:

Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.

Monitor SQL Server Error Log, Space usage. Identifying the memory, I/O and bottlenecks, blocking and deadlocks triggered by complex queries where using SQL Server Activity monitor and profiler and implement better Query Execution plans.

Besides Native tool used OpNet as a Third-Party Tool for monitoring and Performance Tuning.

Performed High Availability and Disaster Recovery administrative tasks such as Design and implementation of Disaster Recovery (DR) solutions based on RTO and RPO guidelines, performed Restore, and Point-in-Time Recovery. Configured AlwaysOn, managed Availability groups and clusters, Created and managed Replication, Configured WSFC Cluster Software.

Used DMVs and Various tools to monitor the health of a server instance, diagnose problems, and performance tune. Applied SP (Service Pack) and patching on SQL Server 2012, 2014, 2016 on a routine basis.

Security and Encryption: Implemented Database and Data Security, managing users, granting/revoking access, auditing, and monitoring to comply with the requirements. Implemented Transparent Data Encryption (TDE), Encrypted data on Column and Row level and Data Masking

Performed performance tuning for servers, databases, SQL/T-SQL queries and Stored Procs. Optimized queries, managed indexes and maintained stats.

Data modeling tools used: Toad Data Modeler, SQL Server Data Diagram.

Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues.

Implement Transparent Data Encryption (TDE) encrypts SQL Server, SQL Database and SQL Data Warehouse data files and encrypting data at rest.

Move a TDE Protected Database to another SQL Server. Managed Security using SQL Logins, Roles and Security Modes for various user

Writing T-SQL, Functions, Trigger, Partition, View, and Stored-Procedures, joins, union and writing scripts for job set-up.

Assisted Database Developers to optimize SQL queries and Stored Procedures. Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using BIDS, SSDT.

Export & Import data from/to databases as My-SQL, and Access to/from SQL Server.

Creating SSIS Packages and deployed from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports OLEDB Data sources.

Experience with logical and physical data modeling and database design using Erwin Package Configuration, SSRS, SSAS and Data-warehousing.

Created report snapshots to improve the performance of SSRS.

Improved the accuracy of the source data by implementing data validation on the source Data for reporting

Strong working experience in Database Backup and Disaster Recovery, Experienced with Point-in-Time Recovery.

Environment: SQL Server 2019, 2016, 2014, 2012, IIS 7.5, 8.5, Windows Server 2008 R2, 2012 R2, ASP.net, ETL and AD (Active Directory), HR, Project Management App, Visitor App, Financial Application, Service-Now, SolarWinds, and Redgate.

Work Authorization: US Citizen

Security Clearance: Clearable

References: Available upon request

Contact this candidate