Sql Server Database Administrator

Amina Islam

Phone: 571-***-****

Sterling, VA ***64

Email: *******@*****.***

Summary:

US Citizen, Microsoft SQL Server certified DBA. 14+ years’ experience working with several companies in various enterprise environments. In depth experience includes production and non-production environments. Possess excellent interpersonal, verbal, written, analytical and presentation skills. Proficient in organizing and planning work independently also able to work in a rapidly changing environment. Flexible, multi-tasking, team player, and personality.

Technical Skills and Expertise:

• 12 years of experience in SQL server Database Administration for large and complex databases using SQL Server 2019, 2016, 2014, 2012, 2008 R2, 2005 and

• Worked in development, test, and production environment supporting customers, QA team, developers and upper management

• Strong technical background includes performing business analysis, writing documentation and specifications, T-SQL, stored procedures, triggers, functions, DTS, BCP/Bulk insert.

• Strong knowledge and working experience also include in managing security, disaster recovery/High Availability Solutions (Replication, Mirroring, Log Shipping), SSIS, SSRS, data modeling, backup/recovery, performance tuning, stored procedures, triggers, functions, constraints, setting up jobs, applying SP, upgrading and migrating databases, and troubleshooting different problems.

•Hardware/Storage: SAN, RAID

•Third Party Tools: Toad Data Modeler, ERWin,

I have strong knowledge of automation concepts, tools, and scripting languages (PowerShell, Bash Ansible, CMD etc.)

IA Vulnerability Management (IAVM) and Working Knowledge of DoD STIGs.

Certification:

CompTIA Security +701 Certified

DP-300 Certified

AZ-104 Certified

MCSA

MCITP - 070-462 - 2012, (Microsoft Certified IT Professional - Database Administration)

MCITP- 070- 463- 2012, (Microsoft Certified IT Professional - Database ETL Administration)

MCITP- 070-***-****/2014(Microsoft Certified IT Professional-Microsoft SQL Query

MCITP - 070-432 - 2008, (Microsoft Certified IT Professional - Database Administration)

MCITP - 070-450 - 2008, (Microsoft Certified IT Professional - Database Administration)

Security Clearance: DOD Top Secret

Education: B.S in Computer Science, Dhaka, Bangladesh.

Professional Experiences:

COGGINS INTERNATIONAL/DLA

Start date 28 DEC 2022 to 14 March 2025

Maintaining and Upgrading SQL Server 2008/2008R2/2012/2014/2016/2019

Provides all activities related to the administration of

Microsoft SQL databases.

Projects long-range requirements for database administration

and design in conjunction with others working

Microsoft SQL-based applications.

Conducts quality control and auditing of databases in required environments to ensure accurate and appropriate use of data.

Performs database related to Security Technical Implementation Guides (STIGs) and Vulnerability Management System (VMS) reporting.

Database designing, development and management; to include,

performance tuning, and database modeling.

Strong knowledge of backups, restores, recovery models,

database shrink operations, clustering, database mirroring, replication.

Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues, etc.

manages all Microsoft SQL database administrator functions; to include, database design, recoverability, integrity, security, availability, performance, development, and testing support. Performing change management, testing, and implementation of required upgrades and operational modifications to accommodate all business requirements of the database. Working closely with Developers, cybersecurity specialists, other internal customers, and government agencies such as DLA Energy, DISA and DLA IA to ensure that security compliance is strictly complied with.

USArmy

Start date 22 April 2019 to 23 December 2022

Prime Technical Services Inc (Army Human Resource Systems contract) Chantilly, VA

Responsibilities:

• Installing, Configuring, Patching, Maintaining and Upgrading SQL Server 2008/2012/2014/2016 Databases and scripting.

• Tuning and optimizing SQL Server Database.

• Maintaining production, COOP, and test environments in the SIPRNet and NIPRNet domains

• Configured and managed SQL Server failover clustering and AlwaysON availability groups using SQL Server 2012.

• Monitor and support High Availability DB server including Availability Groups and Replication.

• Performed database encryption through TDE using certificate, symmetric and asymmetric keys.

• Air Gap using FTP and data transfer platforms to synchronize external interfaces, unclassified/classified components, and additional applications

• Experience with databases and instance level security, patching and auditing support.

• Ability to troubleshoot performance and database issues impacting production databases

• Hardening databases per DISA STIGs, preparing whole project for DoD Authority to Operate (ATO), and mitigating findings per DoD ATOs.

• Synchronizing data between interface partners and classified/unclassified environments using VPN.

• Proactively monitoring database health and managing Backups, Restoration, Security patching and vulnerability analysis, Disaster Recovery, responsible for regular backups and monitoring of the backups

• Responsible for performance and tuning of databases hosted on standalone hosts or on virtual nodes

• Lead the effort of communicating with different application teams and coordinating the upgrade of databases on old releases (SQL server 2008 R2, 2012, 2014) to latest release 2016 and above.

• Recommending and applying solutions to strengthen database security.

Pentagon USAF/IA

SQL Server Database Administrator

Arlington, 22202

From Jan 16, 2019, to 22 April

Responsibilities:

Responsible for installation and configuration of SQL server

Responsible for day-to-day tasks like backup and recovery

Applying service pack.

Conduct project-based work to design, document and implement infrastructure solutions to solve business problems.

Define, create and maintain database metrics and documentation for database configuration and support.

Conduct database systems and application requirements analysis, design, development, implementation and support.

Design, implement, and automate SQL job and security for database

Diagnosis and Resolving highly complex database problems

Monitored Database health and troubleshoot as needed

Database Refresh for test environment

Setup jobs for database maintenance related tasks, backup strategy

Performed database recovery management

Performed database performance tuning, worked customers and developers to troubleshot and help on different issues

Database design, data modeling, database structural change, created tables, views, stored procedures and triggers

USCG Operations System Center

SQL Server Database Administrator

Kearneysville, WV from August 2016- to November 23, 2018

Duties:

• Applied Service Pack (SP) and Hot fixes on SQL Server 2000, 2005, 2008 R2, 2012 and 2014

Handful experience working with STIG at different versions of SQL server 2008 R2, 2012 and 2014

• Accomplish ongoing Operations

• Provide 24x7x365 Duty Analyst Support

• Perform periodic Operations (daily, weekly, monthly, yearly)

• Application monitoring and tuning, Log checking

• Capacity analysis and resource monitoring

• Release package deployments

• Design and execute database backup and recovery procedures including disaster recovery.

• Managed five node SQL Database Clustering.

• Evaluates and recommends available DBMS products to support validated user requirements.

• Defines file organization, indexing methods and security procedures for specific user applications.

• Designs, implements and maintains low to moderately complex databases, access methods, access time, device allocation, validation checks, organization, protection and security, documentation and statistical methods.

• Maintains database dictionaries, monitors standards, procedures, and integration of systems through database design.

• Execute ad-hoc queries and generate reports for users in a timely manner.

• Monitor servers, database health, disk space, backup verification, database growth pattern

Excellent Disaster/Recovery experience including point-in-time recovery, backup verification, testing backups, security backups.

• Configured, Maintained, and troubleshoot Replications, Database Mirroring, and Log Shipping including Standby reporting databases

• Managed SQL Database Clustering (Active/passive)

• Created, managed, and troubleshoot jobs and set up maintenance plans as needed for different tasks such as backups, index management, cleaning history, deleting old files

• Monitored servers, database health, disk space, backup verification, database growth pattern

• Scheduled jobs to automate different database related activities

• Performed Performance tuning

• T-SQL, Stored-Procedures, Triggers

• Created and managed Index, Constraints, Keys

• Monitored Server Activity, Error Log, space usage, and solving problems as needed

Work Environment: Windows Server 2012, 2008 R2 SQL Server 2014, 2012, 2008 R2, 2005, AD (Active Directory)

US Census Bureau

SQL Server DBA Suitland, MD December 2011 –July 2016

THE KEMTAH GROUP, INC.

SQL Database Administrator March 2010 – November 2011

References: References available upon request.

Contact this candidate