We provide IT Staff Augmentation Services!

Sql Server Dba Consultant Resume

NJ

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 R 2/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/20 R2.
  • 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, 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 R 2/2008/2005/2000

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, NJ

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/ R2/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/2008R 2/2008/2005/2000 , SSIS, SSAS, SSRS, System Monitor / Performance Monitor, Foglight and BCM PATROL LiteSpeed.

Confidential, Chicago, IL

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/2008R 2/2008/2005/2000 , SSIS, SSAS, SSRS, System Monitor / Performance Monitor, BMC Patrol, LiteSpeed.

Confidential, PA

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 2008R 2/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/ .
  • 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 2008R 2/2008/2005/2000 , SSIS, SSAS, SSRS, System Monitor / Performance Monitor, Foglight, LiteSpeed.

Hire Now