We provide IT Staff Augmentation Services!

Sql Server Dba Consultant Resume Profile

Nj, UsA

SUMMARY:

  • Around 8 years of experience as a SQL Database Administrator with Banking, Clinical and Financial Sectors.
  • Good Experience in installing MS SQL SERVER 2000,2005,2008,2008 R2,2012 updating with hot fix and service packs
  • Good experience in implementing High availability solutions like Replication Snapshot and Transactional , Log shipping, clustering and Mirroring on physical and virtual machines.
  • Solid experience in MS SQL 2008 R2/2008/2005/2000 database development and administration in enterprise production environment including server installation, configuration, upgrade, maintenance, performance tuning, optimization, backup/restore, recovery, migration, monitoring, security planning and trouble-shooting.
  • Good experience on MS SQL Server 2012 server builds and up gradations from lower editions.
  • Implemented Side by Side Migration and in-place upgrade of MS SQL SERVER 2000/2005/2008 to 2008R2.
  • Proficient with client tools SQL Management Studio, Configurations Manager and Upgrade Advisors, BIDS, report builder 2.0.
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities and Index Tuning Wizard.
  • Good Experience on scheduling database maintenance jobs like DBCC Check DB, Update statistics and Index rebuild jobs and troubleshooting failures.
  • Experience in supporting Very Large databases VLDB and troubleshooting the problems.
  • Experience in writing Stored Procedures, User Defined Functions, Cursors and Triggers.
  • Strong understanding of components of SQL Server Architecture and Expertise in mentoring and setting up High availability environments like active-active and active-passive clustering, Database Mirroring, Replication Snapshot, merge, transactional , Log shipping and creating Linked servers and troubleshooting the same.
  • Experience in extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
  • Experience in Database Backup, Recovery and Disaster Recovery procedures.
  • Experience in maintaining the security for databases creating logins for users, roles, and assigning permissions to them .
  • Proficient with database backup and recovery models.
  • Extensively Monitored Performance with multiple tools like Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, Resolve Dead Locks/Long Running Queries, Blocking, accessibility and efficiency.
  • Experience in Troubleshooting all database related issues.
  • Expertise in Installs, deployments, certificate renewals, service accounts resets, add patches, performing upgrades / migrations, process job tickets bugs, test verify backups and recovery.
  • Expert in performance tuning and handling blocking situation and dead lock situations.
  • Experience in troubleshooting blockings and log space issues and Tempdb issues.
  • Experience in Migrating SQL Server 2000 to SQL Server 2005 and higher versions.
  • Assist Internal DBA's with SQL server 2012 builds 100 SQL Servers Installation, and configuration
  • Storage Management and provisioning Backup/Restore Setup, Process and Documentation using NetBackup
  • Server Monitoring, Compliance, Alerts and Notification Setup and documentation
  • Set up SQL cluster and Availability groups and Always on technologies
  • Act as a backup to internal DBA's assist in test efforts
  • Assist with maintenance setup SQL databases, Replication and Link Server setup
  • Experience with 2005 new concepts like data partitioning, online indexing, DDL triggers, DMV, DMF, DTA, SSIS and performance dash board.
  • Intensive experience in monitoring database performance using SQL Profiler and Windows Performance Monitor.
  • Good experience with Integration, Reporting and Analysis Services.
  • Good experience in analyzing the execution plan and index management for better Query Optimization.
  • Good experience in Identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans
  • Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
  • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
  • Explicitly used third party tools like Lite Speed, Fog light and BMC Patrol.
  • Auditing of database for users transaction, login and database action and removing orphan users
  • Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
  • Actively involved in management of Change Control Requests.
  • My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
  • Strong experience in mentoring with team members, documentation and 24/7 on call production support
  • Excellent Problem Solving Skills, Communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.

TECHNICAL SKILLS:

Databases:

MS SQL Server 2012 2008R2/2008/2005/2000

Programming:

T-SQL, VB.NET, C ASP. NET, C/C , Java

DBA:

Database Administration of MS SQL Server 2012,2008, 2005,2000

Operating System:

Windows 2000/2003/2008/XP/VISTA/7, Sun Solaris 9

ETL Reporting Tools:

DTS, SSIS, SSRS, SSAS

DB Utilities:

SQL Server Management Utility, Query Analyzer

Application Software:

Visual Studio 2005/2008, MS Office Suite

Tools:

Performance Monitor, Backup Utility, BMC Patrol, SQL LiteSpeed, FogLite

EXPERIENCE:

Confidential

SQL Server DBA Consultant

Responsibilities:

  • Providing 24/7 support for critical production databases.
  • Providing Primary DBA responsibilities for around 10 applications.
  • Migrated the SQL Server 2008 to SQL Server 2012.
  • Migrated the SQL Server 2000/2005 to SQL Server 2008 and 2008 R2 versions.
  • Managed 200 databases and few huge databases which are more than 5TB.
  • Installed of MS SQL 2012 on production, Test and Development boxes.
  • Working on Projects to provide DBA support for building SQL Servers for new applications begin to end support
  • Monitoring the data files, log file space issues, blockings, Tempdb space issues.
  • Planning for backup and recovery of database information and maintaining Hot Backups, Cold Backups.
  • Working with BMC Patrol Monitoring tool and Litespeed Backup tool
  • Administering the MS SQL Server 2012, 2008, 2005 2000 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
  • Performed Physical and Logical Data Modeling using Erwin tool for databases of varied sizes including VLDBs.
  • Designing, Creating and Migration of DTS/SSIS packages to Development and QA Servers.
  • Using SSIS, building high performance data integration solutions, including extraction, transformation, and load ETL packages for data warehousing.
  • Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
  • Migrating the database from existing 2000/2005 to 2008R2/2012 servers.
  • Involved in General Database Administration, Query Performance tuning.
  • Involved in projects like Script Automation ESM Remediation
  • Created with respect to standards Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
  • Created various multi-dimensional cubes SSAS , processed facts, dimensions and populated data for front end users.
  • Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks other locking issues.
  • Performed Database consistency checks with DBCC Utilities like DBBCC DBREINDEX,DBBCC INDEXDEFRAG, Index tuning and monitored error logs
  • Developed few reports using MS SQL Reporting Services.
  • Created Databases and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Using SQL server reporting services SSRS delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
  • Refreshes from Production backup to Stage and Development environments.
  • Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
  • Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
  • Extracted data from various sources like SQL Server 2005/2008/2012, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
  • Working with Nexus Tickets Any changes on staging and development environment need to Create Nexus Tickets
  • Working with Change Request Any changes in Production database need to Create CR Tickets this should be approved by Global DBA team after changes made in stage and development environment
  • Involved in all ITIL process like Change management, Incident Management Problem Management.

Environment: Windows 2008/2003/2000/NT4.0, MS-SQL Server 2012/2008R2/2008/2005/2000, SSIS, SSAS, SSRS, System Monitor / Performance Monitor, Foglight and BCM PATROL LiteSpeed.

Confidential

SQL Server Production DBA

Responsibilities:

  • Involved in installation, configuration, and upgrade MS SQL Server 2000/2005/2008 servers.
  • Involved in Data modeling, designing and building Relational Databases using Tools like Erwin and SQL Database Diagrams.
  • Performed huge data transfers between various servers using BCP and SSIS for developer requests, Environment Migrations, Backing up and Archiving Data for various business requests.
  • Heavily involved in writing stored procedures with complex logic for both Reporting needs and DBA Script libraries.
  • Security Administration by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granted privileges to users and groups.
  • Setting up monitoring through batch scripts
  • Installing, upgrading and applying the latest service packs/hot fixes.
  • Provided High availability through Clustering, Mirroring, Replication Transactional
  • Production database administration of highly critical databases.
  • Migration/Moving database servers between different platforms/locations and setting up test, QA and production database environments.
  • Installation of SQL Server 2005. Upgrading SQL Server 2000 to SQL Server 2005 using side-by-side methods

Environment: Windows 2008/2005/2003/2000/NT4.0, MS-SQL Server 2012/2008R2/2008/2005/2000, SSIS, SSAS, SSRS, System Monitor / Performance Monitor, BMC Patrol, LiteSpeed.

Confidential

Database Administrator

Responsibilities:

  • Technologies involved in this application include SQL Server 2000, 2005 Replication, Microsoft Analysis Services and Microsoft DTS ETL .
  • Created DTS packages for the data cleansing/transfer ETL and transformation.
  • Designed Database Schema using third party tools.
  • Created job schedules to automate the routine tasks.
  • Performed Database Normalization.
  • Coding of several database Triggers, Stored Procedures and maintaining Integrity Constraints.
  • Generated report using Microsoft report analyzer.
  • Migrated databases from SQL server 2000 to SQL server 2005.
  • Migrated old DTS packages into SSIS packages.
  • Determine the problems such as dead lock, blocking and fix the problem.
  • Partitioned tables, Views to run query faster.
  • Administering the MS SQL Server 2008, 2005 2000 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
  • Created Databases and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Monitoring and troubleshooting blockings and log space issues and Tempdb issues.
  • Supported 24 7 production support and solved all kinds of critical problems.

Environment: Windows 2008/2005/2003/2000/NT4.0, MS-SQL Server 2008R2/2008/2005/2000, SSIS, SSAS, SSRS, System Monitor / Performance Monitor, BMC Patrol, LiteSpeed.

Confidential

Jr SQL Server DBA

RESPONSIBILITIES:

  • Migrated the SQL Server 2000/2005 to SQL Server 2008 versions.
  • Installed of MS SQL 2008 on production, Test and Development boxes.
  • Working on Projects to provide DBA support for building SQL Servers for new applications begin to end support
  • Monitoring the trace files, and Alert log file.
  • Responsible for troubleshooting of the connectivity problems for end-users
  • Working with Fog light Monitoring tool and Lite speed Backup tool
  • Administering the MS SQL Server 2008, 2005 2000 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
  • Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
  • Migrating the database from existing 2000/2005 to 2008.
  • Involved in General Database Administration, Query Performance tuning.
  • Created with respect to standards Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
  • Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks other locking issues.
  • Performed Database consistency checks with DBCC , Defrag, Index tuning and monitored error logs
  • Developed few reports using MS SQL Reporting Services.
  • Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Using SQL server reporting services SSRS delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
  • Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
  • Extracted data from various sources like SQL Server 2005/2008/2012, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
  • Working with Nexus Tickets Any changes on staging and development environment need to Create Nexus Tickets

Environment: Windows 2008/2003/2000/NT, MS-SQL Server 2008R2/2008/2005/2000, SSIS, SSAS, SSRS, System Monitor / Performance Monitor, Foglight, LiteSpeed.

.

Hire Now