We provide IT Staff Augmentation Services!

Sql Dba Database Administrator Resume Profile

Chandler, VA

Summary

A Microsoft Certified Professional 7 years of solid experience maintaining and developing business systems using Microsoft technologies. Experience covers all parts of the SQL Server 2012, 2008 R2, and 2005 and all aspects and levels of database and report development including data modeling and design as well as development of database objects including stored procedures, triggers, views, functions and constraints in SQL server, as well as reports using Microsoft, Reporting Services and Crystal Reports technologies.

AREAS OF EXPERTISE:

  • Many years of Relational Database Management System RDBMS experience in different environments
  • Expert on Reporting Server/Services Installation and Administration
  • Monitoring, diagnosing problems, Performance Tuning/Optimization with SQL/T-SQL Tuning
  • Programming with T-SQL and working experience SQL Developers for writing Stored-Procedures, Triggers, functions and debug/maintenance existing codes
  • Expert in customer service or clients support and managing team
  • Ability to adapt to changing environments
  • Have extensive work experience in Installing, Configuration Maintenance of MS SQL Server 2012, 2008 R2 and 2005 on a standalone and Clustered Servers Active/Active and Active/Passive Cluster Design
  • Performed successful migrations for any version of MS SQL Server
  • Good experience with the phases Software Development Life Cycle SDLC such as requirement gathering analysis, design, development, testing, implementation maintenance in the Client/Server and web based environments based on Functional Requirements Documents
  • Worked on Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC, OLE DB drivers
  • Experience in Online Indexing, Query Optimization, Performance Tuning and Database Consistency Checks using DBCC commands
  • Experience in usingProfiler and Windows Performance Monitor to resolve Dead Locks or long running queries and slow running server
  • Knowledge of Redundant Array of Independent Disks RAID system and Clustering
  • Self-motivated proactive a team player able to manage own projects efficiently for on-time delivery

Professional Experiences:

Confidential

SQL DBA Database Administrator

Key Responsibilities:

  • Installing, Configuring,and Managing SQL Server 2012, 2008 R2 2005in development, test, and production environment
  • Installing, Configuring, MaintainingReplication and Fail-Over Clustering using SQL Server 2008 R2 for High availability solutions.
  • Remedyusingfor Creating and Solving all type of INC and CRQ tickets.
  • Configuring and Managing Database Mirroring
  • Installing,Configuring, Developing and Managing Report in SSRS SQL Server Reporting Services including managing securities
  • Managing Backup/Restore, Point-in-Time Recovery
  • Responsible for developing and implementing SSIS Solutions
  • Managing SQL Server Error Logs, space usage, growth pattern
  • Upgrading MS Access 2000 and 2005 databases into MS SQL Server 2008 R2
  • Applying SP Service Pack on SQL Server 2008 R2, 2005, and 2000
  • Expertise in database Performance tuning
  • ManagingBLOCK and LOCK
  • ETL Tools: Used ETL tools like DTS, SSIS, Import/Export, BCP Bulk Copy , to import export data from flat files, and excel to MS SQL Server databases
  • Security Management: Creating and Managing users, roles, security at object level, data encryption
  • Experience in Quest Product Idera, Perform Analysis, Spotlight, Toad, LiteSpeed
  • Stored-Procedures, Triggers and User defined functions
  • Involve in creating and modifying tables, Index Cluster/Non-Cluster , Constraints Unique/Check , Views, Stored Procedures, Triggers
  • Setup automated jobs for different purposes including backup, monitoring database health check, disk space, backup verification, and moving databases from environment to environment including creating test environment
  • DevelopingDifferent Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files

Confidential

SQL DBA Database Administrator

Key Responsibilities:

  • Installed, Configured,and Managed SQL Server 2005, 2008 R2 2012 in development, test, and production environment
  • Configured and Managed Database Replications Snapshot/Transactional/Merge
  • Installed and ConfiguredSQL Server Reporting Services SSRS
  • Managed Backup/Restore, Point-in-Time Recovery
  • Responsible for developed and implementedSSIS Solutions and Configuring, Deploying, and Maintaining SSIS
  • Managed SQL Server Error Logs, space usage, growth pattern
  • Upgraded MS Access 2000 databases into MS SQL Server 2005 and 2008
  • Expertise in database Performance tuning
  • ETL Tools: Used ETL tools like DTS, SSIS, Import/Export, BCP Bulk Copy , to import export data from flat files, and excel to MS SQL Server databases
  • Security Management: Created and Managed users, roles, security at object level, data encryption
  • Created and managed Index, Constraints, Keys PK, FK
  • Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008 for High availability solutions.
  • Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering
  • Export Import data from Oracle, Excel, Flat file, CSV fileto SQL Server Database using EXP/Imp and DTS tools
  • Have experience on other tools like Share point, VPN, AD Active Directory , Portals, Bulletin Board, Visio
  • Migrated MySQL 4.1.0, Oracle 10g/11gdatabases to SQL Server2008 R2

Confidential

SQL DBA / Developer

Key Responsibilities:

  • Installed, Configured and Maintained SQL Server 2005 2008R2Fail-Over Cluster Servers, Replication and Log Shipping set up and maintaining
  • Migrated databases from SQL Server 2000 and 2005 to 2008 in test and production environment
  • Experience with DTS/SSIS/ETL processes and implementation of metadata driven solutions/Move data from one place to another place.
  • Configured and Maintained Replications Transactional
  • WrittenT-SQL and Stored-Procedures
  • Performance tuning index tuning
  • Assisted SQL developers to optimize SQL queries and Stored Procedures
  • Created Backup strategy for production and development environment
  • Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes
  • Export Import data from Oracle Database, My SQL, and Access Database including flat files like text, excel, and CSV files
  • Extensively experience in using DTS, BCP to import export data from flat files, excel and MS Access to MS SQL Server databases
  • Designed Logical Physical Database using ER Win

Confidential

SQL DBA Database Administrator

Responsibilities:

DBA Related Tasks:

  • Installed, Configured, and Managed SQL Server 2000 and 2005 in development, test, and production environment
  • Installed, Configured VM Ware server and System running on VM Ware
  • Installed and Configured Operating Systems, Windows Server 2000 Enterprise Edition
  • Installed and Configured SQL Server Reporting Services SSRS
  • Configured and Maintained Replications Transactional
  • Configured Log Shipping as Standby database from Production database
  • Upgraded databases from SQL Server 7.0 to 2000 in testing and production environment
  • Applied Patch on Windows Server 2000 Enterprise Edition
  • Expertise in database Performance tuning
  • Backward Forward Engineering with data modeling tools mentioned above
  • Strong knowledge and working experience in Database Backup, Restore and Point-in-Time Recovery

Hire Now