We provide IT Staff Augmentation Services!

Database Analyst/dba Resume

Dhaka, BangladesH

Microsoft Certified Professional seeking a SQL server DBA position with new challenges and opportunities to build upon my extensive knowledge and experience in MS SQL Server in the areas of Database Management/Administration, Development, Maintenance, Performance Tuning, Security, Data Transformation and Business Intelligence. Experience covers all aspects of database administration, Database Design/development, and Supporting MSSQL Server 2008/2005/2000 including data modeling, developing database objects including stored procedures, triggers, views, functions, constraints, developing and managing reports using SQL Server Reporting Services. I hold more than 6 years of experience as a SQL Server DBA and a team-player with excellent analytical, interpersonal, problem solving and communication skills.

Quick Profile

  • Industry Focus: MS SQL Server DBA in Information Technology
  • Job Title: SQL Server Database Administrator
  • Experience: 6 Years
  • Current Job: Prince William County School System
  • Work Authorization: U.S Citizen
  • Security Clearance: Clearable

Level of Education

  • BS in Computer Science

Certificates

MCITP: Microsoft Certified IT Professional (DBA - SQL Server 2008)

Highlights of Technical Expertise:

Database Management:

  • About 6 years of Relational Database Management System experience in different environments, Development, Test, and Production Environment (7.0 & 2000, 2005, 2008)
  • Writing SQL/T-SQL, Triggers, Stored Procedure and working with developers in writing queries and debugging codes
  • Reporting Services:
  • Expert on Reporting Server/Services (SSRS) including installation, configuration and administration
  • Developed and managed reports
  • Managed security of users and reports
  • Monitoring, diagnosing problems, and Performance Tuning
  • Expert and experienced as a Database Administrator of MS SQL Server (7.0 & 2000, 2005, 2008)
  • Strong work experience Database High Availability Solutions with SQL Server Database Mirroring, Standby/Replication, Log shipping
  • Solid experience on Backup and Disaster Recovery
  • Upgrading SQL Server 2000 databases to SQL Server 2005/2008 and SQL Server 2005 to SQL Server 2008
  • Migrating to MS SQL Databases from Oracle, MySQL and MS Access Databases
  • Familiar with DB2 and Sybase Database environments

Networking: Managing User accounts in Active Directory, Managing File Server, Backup Server, Configuring Network using ROUTER, SWITCH/'
Data Modeling:

  • Worked on more than 8 Information Systems for data modeling
  • Tools used for Data Modeling: SQL Server Database Diagrams, Visio, Erwin, Oracle SQL Developer
  • Reporting Services:
  • Expert on Reporting Server/Services (SSRS) including installation, configuration and administration
  • Developed and managed reports
  • Managed security of users and reports

Hardware: SAN, NAS, RAID

Operating Systems:

  • Good knowledge and working experience on Operating Systems (O/S) include Windows Server 2003, Windows 2000 server, Windows 2000 Advanced Sever, Windows 2008 Server professional, NT 4.0, Windows XP Professional, and SMS-DOS. Windows 7 Professional
  • Working experience also includes installing, configuring, and administering the above operating system

Programming:

  • SQL, T-SQL, Store Procedures, Trigger, .NETkl and ASP.NET

Database Tools Used

SQL Server:

  • SQL Server Management Studio (SQL 2005 & 2008), Enterprise Manager (SQL 200),
  • Upgrade Advisor
  • Query Analyzer
  • SQL Profiler
  • Database Tuning Advisor and Index Tuning Wizard
  • Business Intelligence Development Studio
  • SQLCMD
  • Reporting Services Report Manager, Reporting Services Configuration and Report Builder
  • SQL Configuration manager

Third-Party Tools Used:

  • Data Modeling:
  • ERWin, Visio, Toad Data Modeler
  • Database Administration/Management:
  • Idera SQL Admin Toolset
  • Toad for SQL Server DBA
  • Spotlight

Professional Experience

Current Job

Confidential, Jan, 2007 - Present
Woodbridge, VA

Database Administrator/DBA

Responsibilities:

  • Installed, Configured, and Administered SQL Server 2000, 2005 & 2008 in development, test, and production environment.
  • Installed, Configured and Administered Database High Availability Solutions using SQL Server Fail-Over Cluster Servers, Database Mirroring, Replication and Log Shipping in 2005, 2008 and 2000
  • Migrated databases from SQL Server 2000 to 2005/2008 and 2005 to 2008 as well.
  • Wrote SQL/T-SQL, Stored-Procedures and Triggers
  • Assisted Database Developers to optimize SQL queries and Stored Procedures
  • Monitoring and Performance tuning database & indexes
  • SQL Server Error Log, space usage.
  • Monitor Servers activity, solving problem.
  • Created Backup strategy for production and development environment.
  • Worked database backup and disaster recovery
  • Rebuild Databases from backup (Restore & Recovered from media backup)
    Developed Database Maintenance Plan for different maintenance tasks
  • Used DBCC for different database maintenance tasks and Rebuilding indexes
  • Worked on Data Modeling projects for designing 4 systems
  • Designed Logical & Physical Database using ERWin.
  • Backward & Forward engineering using ERWin.
  • Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints , Views, Stored Procedures, Triggers.
  • ETL: DTS & SSIS:
  • Solid experience with Import/Export Wizard, DTS Designer, DTSRun, DTSRunUI, and SQLAgent
  • Transform data— Transform Data task, Data Driven Query task, Parallel Data Pump task
  • Copy and manage data— Bulk Insert task, Execute SQL task, Copy SQL Server Objects task, Transfer Database task, Transfer Logins task, Transfer Master Stored Procedures task
  • Run tasks as jobs from within a package— ActiveX Script task, Dynamic Properties task, Execute Package task, Send Mail task, File Transfer Protocol (FTP) task
  • Analysis Services processing task
  • Export & Import data from Oracle Database, MySQL, and Access Database including flat files like text, excel, and CSV files.
  • Migrated MS Access 2000/97 databases into MS SQL Server 2000 and 2008
  • Migrated Oracle and MySQL Databases to SQL Server 2005 and 2008

Confidential, Jan, 2005 - Nov, 2006
Alexandria, VA

Database Analyst/DBA

Responsibilities:

  • Installed, Configure, and Administered SQL Server 2000, and 2005 in development, test, and production environment.
  • Installed, Configured and Maintained Database High Availability Solutions using Replication and Log Shipping in SQL Server 2000 and 2005
  • Configured and Administered Database Mirroring in SQL Server 2005
  • Database Backup & Restored.
  • Upgraded SQL Server 7.0 and 2000 databases to SQL Server 2005
  • Migrated Oracle, MySQL, and MS Access 2000/2002/2003 databases to MS SQL Server 2000 and 2005
  • Wrote SQL/T-SQL, Stored-Procedures and Triggers
  • Monitoring and Performance tuning
  • Monitor Servers activity, solving problem.
  • SQL Server Error Log, space usage.
  • Index tuning and Rebuilding
  • Assisted SQL developers to optimize SQL queries and Stored Procedures.
  • Created Backup strategy for production, test and development environment
  • Worked on Backup and Disaster Recovery
  • Created and Scheduled different jobs for backup and other different database maintenance tasks
  • Developed Database Maintenance Plan.
  • Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes.
  • Data Modeling using ERWin.
  • Designed Logical & Physical Database using ERWin.
  • Backward & Forward Engineering using ERWin.
  • Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints , Views, Stored Procedures, Triggers.
  • Export & Import data from Oracle Database, MySQL, and Access Database including flat files like text, excel, and CSV files.
  • Imported data from Oracle, Excel, Flat file, CSV file to SQL Server Database.

Security Clearance: Clearable
Citizenship: US Citizen
References: Available upon on request

Hire Now