Nusrat Sultana

Centerville, VA *****.

571-***-****

ad0ipu@r.postjobfree.com

U.S. Citizen pursuing a point as a Database Administrator, utilizing over seven (7) years of experience in the Relational Database Management System, skills in MS SQL Server in the areas of Installation, Configuration, Migration, Security, SSIS, SSRS, ETL, Data Modeling, Maintenance, Performance Tuning as well as development of database stored procedures, triggers, views, functions, constraints etc. Detail concerned with hardworking professional with an active combination of logical, analytical, communication and documentation skills.

SUMMARY OF EXPERIENCE

• Experience in Indexing, and Database Consistency Checks using DBCC commands.

• Great as a team player. Also, can work independently with little supervision

• Extensive work experience in Installing, Configuration & Maintenance of MS SQL Server 2000, 2005, 2008, and 2008R2 2012,2016 on a standalone and Clustered Servers. Experience as an Azure administrator

• Work experience in applying latest Service Packs, patch and hot fixes

• Performed successful migrations and Upgrade for any version of MS SQL Server

• Experienced in T-SQL Programming and performance tuning, optimization.

• Involved administrative activities like creating user logins with appropriate roles, granting and denying login privileges, monitoring user accounts, creation of groups, granting database and application roles to users and groups

• Have good data normalization and Database design experience.

• Experience in Database Backup, Recovery and Disaster Recovery procedures.

• Implemented a recovery plan to a point in time failure

• Implement and maintain database replication, Log shipping, Database mirroring for high availability and DR solution.

• Import and export data (Dev toQA, QA to Prod)

• Implement and maintain database mail appropriate message for specific user.

• Worked on Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC, OLE DB drivers.

• Ability to troubleshoot day-to-day problems encountered on production as well as development database environments.

• Good experience of Monitoring and scheduling existing/new jobs on production environment.

• Experience in Online Indexing, Query Optimization, Performance Tuning and Database Consistency Checks using DBCC commands.

• Experience in using Profiler and Windows Performance Monitor to resolve Dead Locks or long running queries and slow running server.

• Experience writing Database Management Plan (DMP).

Database Administrator 2021-Present REMOTE

AT&T Middletown, NJ

Developed PL/SQL triggers and master tables for automatic creation of

primary keys.

Involved in migrating the entire database setup from test environment to

production.

Preformed proactive monitoring/managing database space utilization

and growth.

Kaiser Permanente

Database Administrator

09/2018 – 09/2021

Metter’s Inc

McLean, VA

• Installed, Configured, and Managed SQL Server 2000 & 2005 in development, test, and production environment • Successfully migrated SQL 2000 databases to SQL 2005 • Applied SP (Service Pack) on SQL Server 2000, 2005’ • Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2000 to MSSQL 2005. • Automated daily backup/restore processes, implemented batch jobs to automate DBA maintenance tasks. • Implemented and maintained high availability systems (database mirroring, log shipping, replication) • Create and manage database maintenance plans and design and implement backup and disaster recovery plans. • Export & Import data from Flat file, CSV file, Oracle, MySQL, and Access to/from SQL Server Database using DTS, SSIS, and BCP • Data modeling using Toad Data Modeler and Visio • Generated Report using SSRS (SQL Server Reporting Services) • Responsible for Database Backup, Restore and Point-in-Time Recovery • Monitor database systems performance, capacity and availability. • Work on data mapping and conversion; manage disk space, change control and bug fixes. • Developed and implemented Disaster Recovery (DR) on production SQL Server 2005 • Manage and resolve trouble tickets (Web Track) for database-related issues submitted by customers. TECHNICAL SKILLS • Web Application: Share Point foundation, Share point enterprise • Database: SQL Server 2000, 2005, 2008, 2008 R2, Microsoft Access • Operating System: Windows Server 2000/2003/2003R2/2008/2008 R2

PROFESSIONAL EXPERIENCE

Department of Defense (DOD)

11/2016 –08/2018

Enterprise Information Services, Inc. (EIS)

Database Administrator

Vienna, VA

Work as a Database Administrator Responsibilities included: • Monitors and maintains large scale (1000+) databases and 45+ SQL Servers • Maintain mix of standalone and clustered SQL instances • Plans, performs, and monitors database backups. • Assists users with database problems. • Installs and upgrades database software. • Standardizes the implementation of databases and improves management of DAU production and test environments. • Supports users by resolving problems with applications. • Works professionally in any size team, department or customer. • Involved in installing, configuration and administration of SQL Server 2005 & 2008& 2012 as well. • Provide support to application developers in designing and implementing physical database structures. • Wrote stored procedure to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization • Researched, designed and tested a migration plan from SQL Server 2008 to SQL Server 2012. • Designed DR database backup and restore plan. • SQL Server performance statistics collection, Server monitoring and performance tuning. • User account management and connection troubleshooting. • Database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting. • Implement and maintain database security, replication, stand by server, DTS, Log shipping, SQL Mail Manage small, medium and large SQL Server 2000 projects. • Experience writing SQL queries, Stored Procedures, Triggers, and Functions, creating Tables, Views and Indexes • Involved in installing, configuration and administration of SQL Server 2012. • Provide support to application developers in designing and implementing physical database structures. • Wrote stored procedure to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization • Researched, designed and tested a migration plan from SQL Server 2008 R2 to SQL Server 2012. • Designed DR database backup and restore plan. • SQL Server performance statistics collection, Server monitoring and performance tuning. • User account management and connection troubleshooting. • Database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting. • Implement and maintain database security, replication, stand by server, DTS, Log shipping, SQL Mail Manage small, medium and large SQL Server 2000 projects. • Experience writing SQL queries, Stored Procedures, creating Tables, Views and Indexes. • Promote/migrate SQL-Server objects from development to QA and QA to production instances.

USCIS

Database Management Specialist

01/2014 – 10/ 2016

ABBTech

McLean, VA

•Upgraded databases and database objects, including logins, stored procedures, and jobs from SQL 2000 to SQL 2005 and SQL 2005 to SQL 2008, and SQL 2008 R2. • Migrated and consolidated databases from Dev server to Prod server. • Update DTSX packages and point to the target server. • Independently setup transactional replication using a remote distributor in DMZ... • Create, deploy, configure and monitor complex ETL/SSIS packages • Configured SSIS services, Database Mail, and Alerts. • Automated daily database refreshes from production to staging an on – demand refreshes from production to test environments, involving SQL versions 2005 & 2008 • Tested and applied latest service packs and cumulative Hotfix for SQL 2005/2008. • Installed and configured SQL 2005 Report and Analysis Services • Created DDL triggers for auditing any DDL change in SQL 2005 • Reduces contention and increases availability of data • Installed, configured and maintained Log shipping to create Standby Server. • Created maintenance plan for database consistency and optimization. • Document server and database policies and procedures. • Involved in Change Management, Problem management activities using Service Now tool before implementing database changes in production and development activities. • Created the backup and restore strategy for production, development and test environments. • Involved in Disaster recovery and created the documentation • Promote/migrate SQL-Server objects from development to QA and QA to production instances • Provide support to application developers in designing and implementing physical database structures.

TECHNICAL SKILLS

• Web Application: Share Point foundation, Share point enterprise

• Database: SQL Server 2000, 2005, 2008, 2008 R2, Microsoft Access

• Operating System: Windows Server 2000/2003/2003R2/2008/2008 R2

• Tools: -SQL, Idera DBA Suite, Idera (SQL Compliance Manager), Quest (LiteSpeed, Spotlight), Toad Data Modeller, Microsoft Office Word, Excel, PowerPoint, Visio, NotePad++

EDUCATION

B.S in Information Technology Asia University,

Dhaka, Bangladesh

Training/Certification

oMSCA: Microsoft AZURE Administrator 2021

oMCITP: Database Administrator 2008, 2012

oMCTS: Microsoft Certified Technology Specialist, SQL Server 2008

oTraining on Database Log Shipping, Mirroring, T-SQL, SSIS

oTraining on SQL Server Reporting service: Agni System

Contact this candidate