This resume is made with CVwizard.com.availability and DR solution.o Maintaindatabase DTS, SSIS for ETL operations.o Ability totroubleshoot day-to-day problems encountered on production as well as developmentdatabase environments.oGood experience of Monitoring andscheduling existing/new jobs on production environment.o Experience in OnlineIndexing, Performance Tuningand Database Consistency Checks using DBCC commands.oExperience in using Profiler and Windows Performance Monitor to resolve Dead Locks or long running queries and slow running server.oExperiencewriting Database Management Plan (DMP).PROFESSIONAL EXPERIENCEDatabaseManagement specialistUSCISMetter’sInc.8200 Greensboro Drive, McLean VA - Jan 2013 –presentWork as a Database Administrator in IDCMS(Investigations Division Case Management system and BCPS(Badge and credential Processing System), Responsibilitiesincluded: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.oMigratedand consolidated databases from Dev server to Prod server.o Update DTSXpackages and point to the target server.oIndependentlysetup transactional replication using a remote distributor in DMZ..o Create,deploy, configure and monitor complex ETL/SSIS packageso ConfiguredSSIS services, Database Mail,and Alerts .o Automated daily databaserefreshes from production to staging an on – demand refreshes from productionto test environments , involving SQL versions 2005 & 2008o Tested andapplied latest service packs and cumulative Hotfix for SQL 2005/2008.oInstalled and configured SQL 2005 Report and AnalysisServiceso
This resume is made with CVwizard.com.Automated daily database refreshes from production tostaging and on-demand refreshes from,Tested and applied latest service packsand cumulative Hotfix for SQL 2000/2005/2008.oInstalled and configured SQL 2005 Report and AnalysisServices,o Installed,configured and maintained Log shipping to create Standby Server.o Createdmaintenance plan for database consistency and optimization.o Documentserver and database policies and procedures.o Involved inChange Management, Problem management activities using Service Now tool beforeimplementing database changes in production and development activities.o Created thebackup and restore strategy for production, development and test environments.o Promote/migrateSQL-Server objects from development to QA and QA to production instanceso Providesupport to application developers in designing and implementing physicaldatabase structures.DatabaseAdministratorDepartment of Labor- SoftConEnterprisesWashington, DC - June2011 to December 2012Work as a Database Administrator in the Main Study Information Management System,Responsibilities included:o SupportedSQL 2005/2008 databases in clustering environment (A/P A/A) including databasemirroring on critical databases and databases 400+ Gig in size.o SuccessfullyUpgraded databases and database objects, including logins, stored procedures,and jobs from SQL 2000 to SQL 2005 andSQL 2005 to SQL 2008o Setup andconfigured Database mirroring in High Performance, High availability mode.o Configuredand maintain transactional, merge replications.o Designed anddeployed SSIS packages in production environment to implement business logics.o Create,deploy, configure and monitor complex ETL/SSIS packageso ConfiguredSSIS services, Database Mail,and Alerts .o Automated daily databaserefreshes from production to staging an on – demand refreshes from productionto test environments , involving SQL versions 2005 & 2008o Tested andapplied latest service packs and cumulative Hotfix for SQL 2005/2008.o Implementeddata partitioning to improve the performance of large table, reduces contention
This resume is made with CVwizard.com.and increases availability of datao Installed,configured and maintained Log shipping to create Standby Server.oCreated maintenanceplan for database consistency and optimization.o Documentserver and database policies and procedures.o Created thebackup and restore strategy for production, development and test environments.oInvolved in Disaster recovery and created thedocumentation.DatabaseAdministratorKaiser Permanente –Washington,DC - August 2010 to May 2011Work as a Database Administrator for insurance provider. Responsibilitiesincluded:oInstalled,Configured, and Managed SQL Server 2000 & 2005 in development, test,and production environmento Successfullymigrated SQL 2000 databases to SQL 2005oAppliedSP (Service Pack) on SQL Server 2000, 2005’o Upgradeddatabases and database objects, including logins, stored procedures, and jobsfrom MSSQL 2000 to MSSQL 2005.o Automateddaily backup/restore processes, implemented batch jobs to automate DBAmaintenance tasks.o Implementedand maintained high availability systems ( database mirroring, log shipping,replication)o Create andmanage database maintenance plans and design and implement backup and disasterrecovery plans.o Define andenforce database standards, policies, security and documentation.o Preparecurrent database structure and configuration for high-performance throughanalysis and optimization.o Diagnoseproblems using tools such as SQL Profiler and System Monitor, work with vendorsand developers as needed to resolve issues.oResponsiblefor creating, modifying and managing tables, Index (Cluster/Non-Cluster),Constraints (Unique/Check), Views, Stored Procedures, TriggersoExport
This resume is made with CVwizard.com.& Import data from Flat file, CSV file, Oracle, MySQL, and Access to/fromSQL Server Database using DTS, SSIS, and BCPoDatamodeling using Toad Data Modeler and VisiooGeneratedReport using SSRS (SQL Server Reporting Services)oResponsiblefor Database Backup, Restore andPoint-in-Time Recoveryo Monitordatabase systems performance, capacityand availability.o Work on datamapping and conversion; manage disk space, change control and bug fixes.o Developedand implemented Disaster Recovery (DR) on production SQL Server 2005oManage and resolve trouble tickets (WebTrack) for database-related issues submitted by customers.Database AdministratorAgni Corporation - QueensVillage, NY- September 2007 toJuly 2010Hired as a Database Administrator.Responsibilities included:o Providesupport to application developers in designing and implementing physicaldatabase structures.o Wrote storedproc to audit SQL servers, establish and enforcing security auditing mechanismand performance tuning, optimizationo Researched,designed and tested a migration plan from SQL Server 2000 to SQL Server 2005.o Designed DRdatabase backup and restore plan.o SQL Serverperformance statistics collection, Server monitoring and performance tuning.o User accountmanagement and connection troubleshooting.o Implementand maintain database security, replication,Stand by server, DTS, Log shipping, SQL Mail Manage small, medium andlarge SQL Server 2000 projects.o Experiencewriting SQL queries, Stored Procedures, Triggers, Functions, creating Tables,Views and Indexeso Created thedatabase, tables, table spaces, data objects, setting privileges, indexes, userlogins, and passwords (security).o Manage andresolve trouble tickets (Peregrine service center) for database-related issues
This resume is made with CVwizard.com.submitted by customers.o Promote/migrateSQL-Server objects from development to QA and QA to production instanceso Implementedsecurity, generate and review report periodically and enforce securitymechanismo Proactivelymonitored the production database(s) and optimize stored procedures for betterperformance. Resolve locking conflicts and resource utilizationo Hardwarerequirements and storage capacity planning for Development, Testing, QA,Staging, and Production for scalable database growth and performanceo Participatesin emergency recovery of databases as well as manages physical structures,space utilization and participates disaster recovery testing.o Manage andresolve trouble tickets (Remedy) for database-related issues submitEDUCATION And CERTIFICATIONS/TRAINING§ B.S in Information Technology AsiaUniversity, Dhaka , Bangladesh§ MCITP: Database Administrator 2008§ MCTS: Microsoft Certified TechnologySpecialist, SQL Server 2008§ Training on Database Log Shipping, Mirroring, T-SQL,SSIS§ Training on SQL Server Reporting service: Agni SystemCOMPUTER 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 R2Tools:-SQL, Idera DBA Suite, Idera (SQL Compliance Manager),Quest (LiteSpeed, SpotLight), Toad Data Modeller, MicrosoftOffice Word, Excel, PowerPoint, Visio, NotePad++REFERENCESReferences available upon request.