NUSARAT SULTANA BASIC INFORMATION nusrat . sultanabd11 @ gmail . com This resume is made with CVwizard . com . WORK EXPERIENCE Database Administrator jan/2013 - june/2014 Metter's Nusarat Sultana Sql Server Database Administrator Centerville , VA 20120 Email : nusratsultana0711 @ gmail . com Tel : 571 - 247 - 6224 U . S Citizen CAREER OBJECTIVE 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 o Extensive work experience in Installing , Configuration & Maintenance of MS SQL Server 2000 , 2005 , 2008 , and 2008R2 on a standalone and Clustered Servers . o Performed successful migrations and Upgrade for any version of MS SQL Server Experienced in T - SQL Programming and tuning and optimization . o 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 o Have good data normalization and Database design experience . o Experience in Database Backup , Recovery and Disaster Recovery procedures . o Implement and maintain database replication , Log shipping , Database mirroring for high
This resume is made with CVwizard . com . availability and DR solution . o Maintain database DTS , SSIS for ETL operations . o Ability to troubleshoot day - to - day problems encountered on production as well as development database environments . o Good experience of Monitoring and scheduling existing/new jobs on production environment . o Experience in Online Indexing , Performance Tuning and Database Consistency Checks using DBCC commands . o Experience in using Profiler and Windows Performance Monitor to resolve Dead Locks or long running queries and slow running server . o Experience writing Database Management Plan ( DMP ) . PROFESSIONAL EXPERIENCE Database Management specialist USCIS Metter s Inc . 8200 Greensboro Drive , McLean VA - Jan 2013 present Work as a Database Administrator in IDCMS ( Investigations Division Case Management system and BCPS ( Badge and credential Processing System ) , Responsibilities included : o 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. o Migrated and consolidated databases from Dev server to Prod server . o Update DTSX packages and point to the target server . o Independently setup transactional replication using a remote distributor in DMZ . . o Create , deploy , configure and monitor complex ETL/SSIS packages o Configured SSIS services , Database Mail , and Alerts . o Automated daily database refreshes from production to staging an on demand refreshes from production to test environments , involving SQL versions 2005 & 2008 o Tested and applied latest service packs and cumulative Hotfix for SQL 2005/2008. o Installed and configured SQL 2005 Report and Analysis Services o
This resume is made with CVwizard . com . Automated daily database refreshes from production to staging and on - demand refreshes from , Tested and applied latest service packs and cumulative Hotfix for SQL 2000/2005/2008. o Installed and configured SQL 2005 Report and Analysis Services , o Installed , configured and maintained Log shipping to create Standby Server . o Created maintenance plan for database consistency and optimization . o Document server and database policies and procedures . o Involved in Change Management , Problem management activities using Service Now tool before implementing database changes in production and development activities . o Created the backup and restore strategy for production , development and test environments . o Promote/migrate SQL - Server objects from development to QA and QA to production instances o Provide support to application developers in designing and implementing physical database structures . Database Administrator Department of Labor - SoftCon Enterprises Washington , DC - June 2011 to December 2012 Work as a Database Administrator in the Main Study Information Management System , Responsibilities included : o Supported SQL 2005/2008 databases in clustering environment ( A/P A/A ) including database mirroring on critical databases and databases 400 + Gig in size . o Successfully Upgraded databases and database objects , including logins , stored procedures , and jobs from SQL 2000 to SQL 2005 and SQL 2005 to SQL 2008 o Setup and configured Database mirroring in High Performance , High availability mode . o Configured and maintain transactional , merge replications . o Designed and deployed SSIS packages in production environment to implement business logics . o Create , deploy , configure and monitor complex ETL/SSIS packages o Configured SSIS services , Database Mail , and Alerts . o Automated daily database refreshes from production to staging an on demand refreshes from production to test environments , involving SQL versions 2005 & 2008 o Tested and applied latest service packs and cumulative Hotfix for SQL 2005/2008. o Implemented data partitioning to improve the performance of large table , reduces contention
This resume is made with CVwizard . com . and increases availability of data o Installed , configured and maintained Log shipping to create Standby Server . o Created maintenance plan for database consistency and optimization . o Document server and database policies and procedures . o Created the backup and restore strategy for production , development and test environments . o Involved in Disaster recovery and created the documentation . Database Administrator Kaiser Permanente Washington , DC - August 2010 to May 2011 Work as a Database Administrator for insurance provider . Responsibilities included : o Installed , Configured , and Managed SQL Server 2000 & 2005 in development , test , and production environment o Successfully migrated SQL 2000 databases to SQL 2005 o Applied SP ( Service Pack ) on SQL Server 2000 , 2005 o Upgraded databases and database objects , including logins , stored procedures , and jobs from MSSQL 2000 to MSSQL 2005. o Automated daily backup/restore processes , implemented batch jobs to automate DBA maintenance tasks . o Implemented and maintained high availability systems ( database mirroring , log shipping , replication ) o Create and manage database maintenance plans and design and implement backup and disaster recovery plans . o Define and enforce database standards , policies , security and documentation . o Prepare current database structure and configuration for high - performance through analysis and optimization . o Diagnose problems using tools such as SQL Profiler and System Monitor , work with vendors and developers as needed to resolve issues . o Responsible for creating , modifying and managing tables , Index ( Cluster/Non - Cluster ) , Constraints ( Unique/Check ) , Views , Stored Procedures , Triggers o Export
This resume is made with CVwizard . com . & Import data from Flat file , CSV file , Oracle , MySQL , and Access to/from SQL Server Database using DTS , SSIS , and BCP o Data modeling using Toad Data Modeler and Visio o Generated Report using SSRS ( SQL Server Reporting Services ) o Responsible for Database Backup , Restore and Point - in - Time Recovery o Monitor database systems performance , capacity and availability . o Work on data mapping and conversion ; manage disk space , change control and bug fixes . o Developed and implemented Disaster Recovery ( DR ) on production SQL Server 2005 o Manage and resolve trouble tickets ( Web Track ) for database - related issues submitted by customers . Database Administrator Agni Corporation - Queens Village , NY - September 2007 to July 2010 Hired as a Database Administrator . Responsibilities included : o Provide support to application developers in designing and implementing physical database structures . o Wrote stored proc to audit SQL servers , establish and enforcing security auditing mechanism and performance tuning , optimization o Researched , designed and tested a migration plan from SQL Server 2000 to SQL Server 2005. o Designed DR database backup and restore plan . o SQL Server performance statistics collection , Server monitoring and performance tuning . o User account management and connection troubleshooting . o Implement and maintain database security , replication , Stand by server , DTS , Log shipping , SQL Mail Manage small , medium and large SQL Server 2000 projects . o Experience writing SQL queries , Stored Procedures , Triggers , Functions , creating Tables , Views and Indexes o Created the database , tables , table spaces , data objects , setting privileges , indexes , user logins , and passwords ( security ) . o Manage and resolve trouble tickets ( Peregrine service center ) for database - related issues
This resume is made with CVwizard . com . submitted by customers . o Promote/migrate SQL - Server objects from development to QA and QA to production instances o Implemented security , generate and review report periodically and enforce security mechanism o Proactively monitored the production database ( s ) and optimize stored procedures for better performance . Resolve locking conflicts and resource utilization o Hardware requirements and storage capacity planning for Development , Testing , QA , Staging , and Production for scalable database growth and performance o Participates in emergency recovery of databases as well as manages physical structures , space utilization and participates disaster recovery testing . o Manage and resolve trouble tickets ( Remedy ) for database - related issues submit EDUCATION And CERTIFICATIONS/TRAINING § B . S in Information Technology Asia University , Dhaka , Bangladesh § MCITP : Database Administrator 2008 § MCTS : Microsoft Certified Technology Specialist , SQL Server 2008 § Training on Database Log Shipping , Mirroring , T - SQL , SSIS § Training on SQL Server Reporting service : Agni System COMPUTER 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 + + REFERENCES References available upon request .