Sql Server Data
Resume:
Sabbir M ahmud
Phone : 703-***-****
Email : ********@*******.***
SQL DBA, have over 6 years of extensive experience in SQL Server Database in the
a reas of Database Administration, Reporting, Data Modeling, Advanced
I nstallation/ Configuration, Backup/Recovery, Upgrade, Migrate
(Oracle/MySQL/Access DBs), Service Pack (SP), SQL/T-SQL, Stored Procedure,
T rigger, DMV, Replication and other related technologies of SQL Server ( 2000,
2005, 2008, 2008R2). P roficient in other related technologies including migrating
O racle 10g/11g, MySQL databases, ODBC, ER Win, Toad Data Modeler, DB Artisan,
Toad for SQL Server DBA, I IS Web Server.
I entail effective communication, mul ti-tasking and prioritizing skills, excellent
i nterpersonal skills, strong customer focus, quick learner and dependable seeking for
SQL Server DBA job.
General Skills:
• Ability to adapt to changing environments
• Excellent team player and quick learner
• Excellent in Technical Support
• Excellent in working non-technical or Business Analyst
D atabase Management:
• Strong knowledge and working experiences as Database Administrator of MS
SQL Server (2000, 2005, 2008, 2008R2 )
• Strong work experience and knowledge with SQL Server Standby/Replication,
Log shipping, Mi r roring, Performance tuning, Backup/Recovery, Query
Optimization and Security Management
Data Modeling:
• Worked multiple projects in Database – Conceptual, Logical, and Physical
Data Model
• Tools used Toad Data Modeler, ER Win, SSDG
Database Reporting Tools:
• SQL Server Reporting Services (SSRS) – Installation, Configuration, and
M anagement
• Developed, Deployed, and Managed Reports
• Managed Security for the Reports and Reporting Server
Operating Systems:
• Working experience on Operating Systems (O/S) – Windows Server 2008/2008
R2, 2003, and 2000 Advanced Sever
• V MWare: I nstalled, Configured, and Managed SQL Server VMware
E nvironment
• Active Directory
P rogramming:
• T-SQL, Store Procedures, Trigger, basic idea about .NET and ASP.NET
E xperience
Me rcom
SQL Database Administrator
September/2013-P resent
K ey Responsibilities:
• Installed, Configured, and Managed SQL Server 2012
• Database Upgraded ( development, testing and production environment) :
SQL Server 2008 to 2012
B ackup/Recovery:
• Database Backup and Disaster Recovery
• Point-in-Time Recovery
• Restored Database from backup
• Move user login and password SQL server 2008 – 2012
Database Monitoring/Performance T uning:
• Strong on database Monitoring and Performance tuning
• Scheduled jobs to automate different database related activities including
backup, monitoring database health, disk space, backup verification
• Monitor SQL Server Error Log, space usage
• Deployment from different environments to Production
I DS June/2011-
August/2013
SQL Database Administrator
Key Responsibilities:
• Installed, Configured, and Managed SQL Server 2008, 2005 & 2000 in
development, test, and production environment
• Installed and Configured SQL Server 2008 for testing different features and
s tability
Database H igh Availability:
• Installed, Configured and Maintained Fail-Over Clustering using SQL Server
2008/2005
• Installed, Configured and Maintained Database M i r roring using automatic fail-
over option in SQL Server 2008
• Configured Log Shipping as Standby database from Production database for
Reporting purposes
• Configured and Maintained Replications (Transactional)
Report Development:
•Installed, Configured, and administered SQL Server Reporting Services ( SSRS)
• Developed Reports using SSRS
• Deployed Reports
• Developed Ad-hoc Reports using Report Builder 3.0, 2.0
Database Upgraded ( development, testing and production environment) :
• SQL Server 2000 to 2005/2008
• SQL Server 2005 to SQL Server 2008
Database M ig rated ( testing and production environment)
• MS Access 2003/2000/97 databases into MS SQL Server 2000, 2005, and 2008
• Oracle 10g databases to SQL Server 2008
• My-SQL 4.1.0/5.0.1 databases to SQL Server 2005 and 2008
Data Modeling:
• Worked on data modeling projects and generated E-R Diagram
• Data Modeling tools used using ER Win, Oracle SQL Developer, SQL Server
Data Diagram
• Backward & Forward Engineering with data modeling tools mentioned above
Patch Management :
• Applied SP (Service Pack) on SQL Server 2000, 2005, 2008
• Applied HOT Fixes on SQL Server 2000, 2005, 2008
• Applied Patch on Windows Server 2003 Enterprise Edition
Database Monitoring/Performance T uning:
• Strong on database Monitoring and Performance tuning
• Scheduled jobs to automate different database related activities including
backup, monitoring database health, disk space, backup verification
• Monitor SQL Server Error Log, space usage
Database P rogramming:
• Writing T-SQL, Trigger, and Stored-Procedures
• Assisted Database Developers to optimize SQL queries and Stored Procedures
D TS/SSIS:
• Export & Import data from Flat file, CSV file to/from SQL Server Database
using DTS, SSIS, and BCP
• Export & Import data from/to databases like Oracle, My-SQL, and Access
to/from SQL Server
Backup/Recovery:
• Strong knowledge and working experience in Database Backup and Disaster
Recovery
• Experienced with Point-in-Time Recovery
• Restored Database from backup
Verizon Ma r/2007 – Nov 2010
SQL Database Administrator
R esponsibilities:
• 24/7 Supports, work in a emergency support group
Performance tuning and monitoring; worked on rebuild index, reorganized index
based on fragmentation level, created stored procedures and t r iggers for
d ifferent tasks purposes
• Rebuild Servers (Restore & Recovered from tape/CD backup) from backup
Configured Log Shipping from Production to Standby Server (Running as
Reporting Server), backup and recovery
• Designed and created databases, tables, views, stored procedures and
t r iggers
• Configured and Maintain Replications (Transactional)
• Designed and implemented monitoring tool for capturing Log Events for
P roduction Servers performance monitoring and alert messages for blockings
• Writing T-SQL and Stored-Procedures
• Performance tuning & index tuning
• 3rd party back up tool such as L i teSpeed, Idera, Toad
• Create SSIS packages using BIDS, set up SQL agent jobs, loading data
f rom different databases to SQL Server database
• Developed Database Maintenance Plan
• Monitor Servers activity, solving problem
• Export & Import data from other data sources like f lat files using
I mport/Export through DTS and SSIS
• Setting up and maintaining security at the database as well as server
level
• Worked on SQL Server tools like Enterprise Manager and SQL Query
A nalyzer
• Prepared and implemented documentation for new server configuration
and software installation
• Deployment, Migration, Upgrading for various databases like Access,
D B2, Oracle
• Worked on data ware housing such as load and retrieve data from
d ifferent source and move to various destination
• Set up or scheduling jobs for different locations and servers for back ups
• Database health checks, tuning, performance for databases and systems
• Worked on replication, clustering, log shipping
• Used Share Point server for a compilation of SQL Server related tasks
• Worked on various databases that are managed by Share Point
• Developed database maintenance plan
• Installed and Configure SQL Server 2000, 2005 & 2008 in development,
test, and production environment
• Installed, Configured and Maintained SQL Server 2000,2005 &2008 Fail-
Over Cluster Servers
• Deployment from different environments to Production
• Migration between Sybase, MYSQL, Oracle, SQL Server 2000, 2005 and
2008.
• Migrated MS Access 2000/97 databases into MS SQL Server 2000 databases
Education & Training
Bachelor of Science (BS)
• MC ITP (Microsoft Certified IT Professional) – Database Admin - 2008
• Database Administrator Training – SQL Server 2008
• Microsoft Reporting Server Services (SSRS) Training – SQL Server 2008
• Data Modeling and Design Training on SQL Server – Using Toad Data Modeler
• SSIS, Data warehouse and developing packages
References: Available upon request
Contact this candidate