Sql Server Data
Resume:
MD. ABDUL MOMEN Phone: 301-***-****
Gaithersburg, MD ***********@*****.***
Certified SQL Server Database Administrator with over six (6) years of experiences w ith detail
o riented, analytical and t roubleshooting experiences in different Microsoft products like SQL
Server (2000, 2005, 2008), Operating Systems, AD (Active Directory), Data Modeling including
gathering and analyzing business requirement, solid working experiences in managing large
databases in 24/7 environment including backup/recovery, developing and managing reports
using SSRS (SQL Server Reporting Services), Monitoring, Performance Tuning, Stored
P rocedures, T riggers, Functions, Constraints, DBCC, using Third Party Tools etc. Working
experiences entails strong working experiences on using database thi rd party tools (SpotLi te,
RedGate, ER Win, V isio, and Toad Data Modeler) .
Professional experiences also entails developing/managing database objects such as tables, views,
s tored procedures, t r iggers, functions, constraints, database movement, managing/moving
securi ties, managing jobs, highly professional, excellent team player and multi-tasking in timely
manner.
Experience on Test, Development, and P roduction Envi ronment
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
C areer Summa ry:
• Has working experiences in a fast paced environment as a Database Administrator (DBA)
For VLDBs in S QL Server 2008 R2/2008 and S QL Server 2005/2000 over the Windows
Server 2000/2003/2008 R2
• Proficiency in Database Administration on Production Servers with server configuration,
performance tuning and maintenance with outstanding t roubleshooting capabili ties
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster Recovery
P lanning and Security Management. Configured Service Broker and Table Partitioning
1/7
MD. ABDUL MOMEN Phone: 301-***-****
Gaithersburg, MD ***********@*****.***
• Implemented the new S QL Server 2005/2008 concepts like Data Parti tioning, Snapshot
I solation, Database Mi r roring, DDL Triggers, Online Indexing, DMV’s, DMF’s, Mail
Setup, Jobs, and Alerts, DTA, SQLCMD, dedicated admin connection, MERGE statement
• Worked on H igh Availabili ty atmosphere (Active-Active/Active-Passive Cluster,
T ransactional Replication). Mi r roring, Log Shipping and Replication. Evicting (dropping)
nodes and adding node in cluster 2005/2008. Documentation and Inventory maintenance
for various S QL Servers
• Used PerfMon, profiler, DTA (Database Engine Tuning Advisor), DMV’s and DMF’s for
t roubleshoot performance problems, fine-tuning of databases, for finding long running
queries and index analysis. Worked on 32 and 64 bit SQL Server and MSCS
Configurations
• Extensively Worked on Transactional Replication, Snapshot Replication and Merge
Replication
• Handled multiple SQL I nstances on Cluster for Server Consolidation projects built on
SAN using RAID levels. Worked on S QL Server 2008 migration from SQL Server 2000
and 2005
• Worked on configuring SQL Server i n Single user mode and Minimal Configuration Mode
• Data modeling experience in Physical and logical data modeling by using ERWin and
V ISIO
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and
A pplication support. Extensive usage of Proactive Monitoring tools of S QL Server
• Handling Memory configurations, S QL Server 2000/2005/2008 on Windows
2000/2003/2008
• Sound knowledge stored procedures, Indexed views, User Defined Functions, Triggers,
D istributed Queries and Common Table Expressions, UDFs
Experience in Batch processes, SSIS (SQL Server In tegration Services), DTS ( Data
•
Transformation Services), BCP (bulk copy), Bulk Insert, Import, Export, Backup, Database
Monitoring tools and Application support
Have experience on other tools like VPN (Virtual Private Network), AD, Portals, Bulleting
•
Board, Visio
• Third party tools used RedGate, Idera, ERWin, Toad Data Modeler, SpotLi te,
• Reporting tools - BI (Business In telligence) and SSRS
P rofessional Experiences:
2
MD. ABDUL MOMEN Phone: 301-***-****
Gaithersburg, MD ***********@*****.***
U nited Health Care, NY December 12, 2011 to P resent
Working on fast paced, constantly changing, and a very responsible environment, which requires
a continuous Team Effort. A pplication consists of different in terface for different functionalities
and for different level of users in Client/Server Web-Based Applications in a Microsoft Windows
Server Environment using I IS. As part of backend for Data Storage, the System is using MS
SQL Server 2008 R2.
S QL DBA
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 stability
Backup/Recovery:
Strong knowledge and working experience in Database Backup and Disaster
Recovery
Experienced with Point-in-Time Recovery
Restored Database from Backup
Database H igh Availability:
Installed, Configured and Maintained Database M i r roring including automatic fail-
over option in SQL Server 2008
Configured Log Shipping as Standby Database from Production Database for
Reporting purposes
Clustering using SQL Server 2008/2005
Configured and Maintained Replications
DBCC :
Used D BCC to check database conditions, fix database corruption, rebuild indexes
and other database maintenance purposes as well
Report Development:
Installed, Configured, and Administered SSRS
3/7
MD. ABDUL MOMEN Phone: 301-***-****
Gaithersburg, MD ***********@*****.***
Developed Reports for different purposes like DBA Reports, User Reports using
SSRS and Report Builder 3.0 & 2.0
Deployed Reports and Managed Security of Report Server including Folder Level
SSIS:
SSIS Package create, deploy and manage
Moved Data from Flat File, Excel, MySQL, MS Access, OLEDB Data Sources to
SQL
Server
Database Upgrade:
SQL Server 2000 to 2005/2008/2008 R2
SQL Server 2005 to SQL Server 2008/2008 R2
Database M ig ration:
MS Access 2003/2000/97 Databases in to MS SQL Server 2000, 2005, 2008 and 2008
R2
My-SQL 4.1.0/5.0.15 Databases to SQL Server 2005 and 2008 R2
Data Modeling:
Strong Theoretical and Practical work experience on Conceptual, Logical, and
Physical Data Model
Worked on Data Modeling projects from starting to finishing, generated scripts for
objects, Developed Relationship, and Created E-R Diagram
Backward & Forward Engineering for Logical and Physical Data Model respectively
Tools used: ER Win, Toad Data Modeler, and SSDD
Created and Managed Object, Schema, Indexes, Constraints
Patch Management :
Applied SP (Service Pack) on SQL Server 2000, 2005, 2008, 2008 R2
Applied Patch on Windows Server 2003, 2003 R2
Database Monitoring/Performance T uning:
Strong on Database Monitoring and Performance tuning
Scheduled jobs to automate different activities such as monitoring database health,
d isk space, job alert, index monitoring, stats monitoring etc.
Database P rogramming:
T-SQL, Trigger, and Stored-Procedures
Assisted Database Developers to optimize SQL queries and Stored Procedures
D TS/SSIS:
4
MD. ABDUL MOMEN Phone: 301-***-****
Gaithersburg, MD ***********@*****.***
Export & Import data from Flat file, CSV file to/from SQL Server Database using
D TS, SSIS, and BCP
Export & Import data from/to databases like My-SQL, and Access to/from SQL
Server
Work Envi ronment : Windows Server 2008 R2, 2003 R2, I IS 7.5, 6.5, Apache Tomcat 5.5, SQL
Server 2008 R2, 2005, ASP, ASP.net, PHP, AD
C IBC - World Ma rkets (Equities Division), NY A pr il 9, 2007 to Nov
18, 2011
Worked on Developed Electronic Trade Confi rmation (ETC) automated System for Trade Related
T ransactions. The system is linked to the OASYS GLOBAL in doing Electronic Trade Allocation
and Confi rmation Services. I t links investment managers and broker/dealers. Worked on Data
Modeling,
T-SQL Scripting, Database Implementations, Management, Deployment of Database, and
A pplications
i n Development, Test, and Production Environment. The application is writ ten in ASP.net,
JavaScript
using I IS7.5.
SQL DBA
Responsibilities:
• I nstalled, Configured, and M anaged SQL Server 2000, 2005, 2008 i n Development,
Test, and Production environment
• I nstalled and Configured SSRS
• Developed and Managed Report i n SSRS
• Created and Managed Securities for Reports
• Configured and Maintained Database R eplications
• Configured and Managed L og Shipping i ncluding S tandby database for reporting
p urposes
5/7
MD. ABDUL MOMEN Phone: 301-***-****
Gaithersburg, MD ***********@*****.***
• Administered Fail-Over Clustering i n SQL Server 2008
• Managed Backup/Restore, Point-in-T ime Recovery i ncluding backup verification
• Managed Server, Database Roles and Security for different users and user groups
• Upgraded databases from SQL Server 2000 /2005 to SQL Server 2008/2008 R2 i n Test
and Production Environment
• Upgraded M S Access 2003/2000 databases into MS SQL Server 2000, and 2008
• Applied SP (Service Pack) on SQL Server 2000, 2005, and 2008
• Applied Patch SP2 on Windows Server 2003 Enterprise Edition
• Expertise in database P erformance tuning
• T-SQL, S tored-P rocedures, T r iggers
• C reated and managed I ndex, Constraints, Keys (PK, FK)
• Worked on different Data Modeling projects including creating scripts, E-R
D iagram, backward/forward engineering
• P rocessed data dump and Exported & I mported data from F lat file, CSV file, M y-
SQL, and Access to/from SQL Server Database using D TS, SSIS, and E XP/ I M P tool
• Setup automated jobs for different purposes including backup, monitoring database
health, disk space, backup verification, moving databases from environment to environment
i ncluding creating test environment
• Developed D ifferent M aintenance Plans such as backups, index management,
f ragmentation management, cleaning history, deleting old files
• Monitored Server Activity, E r ror Log, space usage, and solving p roblem as needed
SQL Server 2000:
• Installed, Configured, and Managed SQL Server 2000 on Windows Server 2000 SP3
• Configured and Maintained Log Shipping as Standby database for Reporting Purposes
• Upgraded MS Access 97 databases into SQL Server 2000
• Applied SP (Service Pack) SP3 on SQL Server 2000
• Data Modeling for different applications
• Export & Import data from Flat file (CSV, Excel) to SQL Server Database using EXP/IMP
and DTS tool
• Monitor Server Activity, Error Logs, space usage, and solving problem as needed
• Performed Backup, and Database Restoration
• Scheduled jobs to automate different database related activities
6
MD. ABDUL MOMEN Phone: 301-***-****
Gaithersburg, MD ***********@*****.***
Work Envi ronment : Windows Server 2008 R2, 2003 R2, I IS 6.5, SQL Server 2008 R2, 2005,
2000, ASP, PHP, AD, In ternal (Registration System, Reporting System)
ED UCAT ION:
• B.S. in Computer Science and Engineering
Certification & T raining:
SQL Server Database:
• MC ITP - Certified SQL Server DBA - SQL Server 2008
• Training on T-SQL Programming
• Training on Database Clustering Installation and Administration
Security Clearance: C learable
Citizenship: U.S Citizen
References: S trong references available upon request
7/7
Contact this candidate