RAHITOSH MONDOL

Alexandria, VA - *****

Email: aczga8@r.postjobfree.com

Contact No.: 804-***-**** (Cell)

Status: US Citizen

Career Perspective:

Seeking for a ‘‘MS SQL Database Administrator (DBA)’’ position in a fast-paced technology company with varied responsibilities & the potential for advancement.

Summary of Experience:

Over Four (04) years of experience in SQL Server DBA for Very Large and Complex databases using SQL Server 2014, 2012, 2008R2, 2008.

Installation, Configuration & Maintenance of SQL Server Management Studio (SSMS), Exposure to Active Directory (AD), Creating & Manipulation of data, tables, views, indexes, using SSMS & T-SQL Scripts following RDBMS, Designing ER Diagram.

Strong technical background includes performing tuning & optimization, following business policy, Process Documentation, Using of T-SQL, DMVs, DBCCs, Stored Procedures, & Triggers etc.

Strong knowledge and working experience in Database Backup, Restore strategy, Determining Disaster Recovery model & Backup Retention for production & development environment.

Installed, Config & Maintained Database High-Availability/Recovery Solution of Mirroring, Log Shipping, Replication, SQL Clusters & have concepts on always-on and Clustering etc.

Experience in Database Update, applying Service Packs & Hot Fixes, Upgrade and Migration within RDBMS as Oracle, DB2 or Flat Files through RDC/ODBC/OLEDB & Application Support.

Experiences working on BI Suites as MS SQL Integration Services (SSIS), SQL Server Analysis Services (SSAS) & SQL Server Reporting Services (SSRS).

Experience in managing large database in 24/7 Environment & On Call Rotation basis

Experience on MS SharePoint 2010 & 2013

Worked on 3rd party software and Ticketing tools; Jira/Zoho/Solarwinds Web LLC Help Desk system

Motivated, proactive, Team player, manage projects efficiently for on-time delivery.

Excellent verbal, written & presentation skills & Independent problem solving

Proven ability to manage multiple tasks working directly with different vendors.

Excellent coordination, organizational, interpersonal skills & collaboration.

Technical Expertise:

Database & Server : MS SQL Server 2014, 2012/2008 R2, MS Access, Excel.

Operating Systems : SQL in Windows Server2012R2/ 2008R2, VMware Environment

Programming Languages : Worked & Deployed SQL, T-SQL, SPs, Trigger, Cogsdale, ASP.Net

Reporting Tools : SQL Server Reporting Services (SSRS)

Database Design : Database Normalization/Denormalization, ERD, Flow Charting

Database Migration : Upgrade & Patch Management, Migration to SQL Server using SSMS

Networking & Protocol : Knowledge on Active Directory, TCP/IP, DHCP, LAN/WAN

3rd Party Tools : Solarwinds (Orion), Idera, OpNet

Financial Software : MS GP Dynamics, Transportation Magt. Sys & Warehousing (TMSW), CSM-Cogsdale, ERP system

Professional Work Experiences

Pittsburgh Water & Sewer Authority (PWSA), Pittsburgh, PA July 2016 – Current

Microsoft SQL Server DBA

Responsibilities:

The project involved Backup, Restore, Manage Security, Database & Server Health Check, Monitor & Manage Performance in a 24/7 basis Business environment.

Installation, Configuration SQL Server 2008 R2, 2014 and upgrading SQL Server

Migrated databases from SQL 2005 to 2008 to 2014 in Test and Production environment

Configuration and management of GP Microsoft Dynamics

Establish and maintain Data and Database Backups; and Determine Point-in-time Recovery

Config & Maintained Database High-Availability/Recovery Solutions; Mirroring, Log Shipping, Replication etc.

Identify and address database performance issues and capacity issues, perform database Tuning and Performance Monitoring

Working with Data Architecture on Flat Files, Excel, Access and SQL Server and other RDBMS

Data Modelling; Create data models, advocate proper data access and database maintenance

Export & Import data from Relational Database Management System (DBMS) including flat files like Notepad, Text files, Excel, Access, XML and so.

Working on MS BI Suite/Dynamics, Working experience with ETL tool of SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Data Warehouses etc.

Used SPs, DMVs, DBCC and SQL scripting and other tools to check physical and logical consistency of database, data validation and smooth transition of business flow.

Scheduled and maintained new and existing jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, database statistics, rebuild or reorganize indexes

Write stored procedures, functions, and triggers & Assist SQL developers to optimize SQL queries and Stored Procedures (SPs) to balance the in-memory issues

Working on Data Analysis and Development project as well Review developer SQL queries and stored procedures for optimization performances and ensure data security purposes.

Developing Business Requirements Documents (BRD) for next phase and elicitation, test and research the feasibility and successful implementation of the BRD

Managed security by creating Groups, Logins & users with proper authentication & grant appropriate permission on Server – Database - Object level.

Attended weekly/monthly meetings with other IT team, Project Manager, Dev. and Test Team regarding project status, deadline, technical issues & solution.

DataGroupUSA, Alexandria, VA Jan 2014 – June 2016

MS SQL Database Administrator/DBA

Administered production and development servers running on Window environment and monitoring MS SQL Server2014, 2012, 2008R2.

Installed and Configured, and Managed SQL Server in development, test and production environment following ERD Database Design.

Installed, Config & Maintained Database High-Availability/Recovery Solution of Mirroring, Log Shipping, Replication & Clustering & Concepts on Always On

Installed, Configured & Administered Business Intelligence (BI) tools; Integration Services (SSIS), Analysis Services (SSAS) & Report Services (SSRS).

Managed security of Reports and Report Server, Developed Ad-hoc Reports

Worked in a team for Upgrading SQL Server 2008/2008 R2 2012 or 2014

Migrated Databases from Oracle, DB2 Databases to SQL Server 2008R2 and 2012

Applied Service Packs & HOT Fixes on SQL Server 2008R2 and 2012 & 2014

Worked on data modeling projects; managed E-R Diagram Data Modeling tools.

Experienced in creating, modifying tables, Index (Clustered/Non-Clustered), Constraints (Unique/Check), Views; Developed, Maintenance Plans & Monitoring

Experienced on database monitoring, performance tuning and Query Optimization & monitoring SQL Server Error Log, space usage and solution

Scheduled and maintained new and existing jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, database statistics, rebuild or reorganize indexes.

Created notification/alerts in any failure, error, warning or disk issue to Services Account

Wrote and Deployed codes on T-SQL, Trigger and Stored Procedures

Exported & Imported data from Flat file, Excel file, CSV file to/from SQL Server Database using DTS, SSIS etc.

User Experience on Microsoft SharePoint 2013

Exported & Imported data to/from Oracle, My-SQL, and Access & SQL Server

Strong knowledge and working experience in Database Backup & Disaster Recovery & Backup strategy for production & development environment.

Experienced with Point-in-Time Recovery, Restored Database from backups

Managed security by creating Groups, Logins & users with proper authentication & grant appropriate permission on Server – Database - Object level.

Attended weekly/monthly meetings with other DBA, Project Manager, Dev. and Test Team regarding project status, deadline, technical issues & solution.

Community Health Solution, Richmond, VA March 2013 – Dec 2013

Junior SQL Database Administrator/DBA

Key Responsibilities:

Database Monitoring/Performance Tuning:

database Monitoring and Performance tuning, Monitor SQL Server Error Log, space usage, Server Activity, Maintenance Plans for database monitoring, & solving problems.

Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification

Used DBCCs to check database conditions, Rebuilding indexes and database Maintenance purposes

Working with tables, Index (Clustered/Non-Clustered), Constraints (Unique/Check), Views

Installed SQL Server 2008R2 and SQL Server 2012 for testing different features and stability

User interface on Microsoft SharePoint 2010 for documents sharing purposes

Patch Management:

Applied SP (Service Pack) on SQL Server 2008 and 2008R2

Applied Hot Fixes on SQL Server 2008 and 2008R2

Database High Availability:

Installed, Configured and Maintained Database Mirroring of SQL Server 2008 and 2012, Log Shipping from Production database for Reporting purposes, Configured and Maintained Replications.

Report Development:

Installed, Configured, and administered SQL Server Reporting Services (SSRS), Developed Reports using SSRS, Deployed Reports to Report Server or share within Shared Drives etc.

Database Upgraded:

SQL Server 2008 to 2008R2, SQL Server 2008R2 to SQL Server 2012

Microsoft Certifications:

MCAS - F364-4988 (Microsoft Certified Administering SQL Server): SQL Server 2012 – Admin.

MCDW- F364-4988 (Microsoft Certified Implementing a Data Warehouse): SQL Server 2012

MCTS - F364-4990 (Microsoft Certified Technology Specialist): SQL Server 2008R2

MCITP - F369-9411 (Microsoft Certified IT Professional): SQL Server 2008 - Administration

Education:

Bachelor of Science (BS) in ‘Computer Science’

Year of Completion: 2002

Dhaka University, Bangladesh

US Residence Status: US Citizen (Citizenship by Naturalization)

References: Available upon request

Relocation: Willing to relocate

Government Clearance: Eligible to obtain any Government Clearance

Contact this candidate