We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume

Austin, TX

PROFESSIONAL SUMMARY:

  • 8+ years of experience with the 32bit, 64 - bit Microsoft SQL Server in Production, Development and Testing in Clustered and Stand - alone Server Environment.
  • Experience installing MS SQL SERVER 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016 updating with hot fix and service packs.
  • Experience as SQL Server DBA (2016, 2014, 2012, 2008, 2005, 2000) in Production, Development and Data Warehouse Environments (OLTP and OLAP).
  • Domain knowledge in multiple industries, such as Healthcare, Banking, Insurance, Manufacturing and Software. 24/7 on Call Support for Production Database.
  • Implemented Side by Side Migration and in-place upgrade of MS SQL SERVER 2000/2005/2008 to 2008R2, 2012 to 2014.
  • Experience in Migrating DTS 2008 and 2012 packages to SSIS packages in 2012 and 2014 using Migration Wizard.
  • Good at SQL Server 2008 new features like Policy management, Data Compression, Resource Governor, Performance data collector and Transparent Data Encryption (TDE).
  • Extensive hands-on experience on 2012/2014and 2016 with MS SQL Server upgrades/migrations and VMWare environments.
  • Experience in working with Information Technology Infrastructure Library Processes (ITIL) methodologies and Change controls regards to ITIL Service Management.
  • Experience in creating Constraints, Tables, Indexes, Views, Stored Procedures, Functions, Triggers and Dynamic SQL queries.
  • Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication.
  • Creating Conceptual/logical/physica l data model level using Erwin tool.
  • Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
  • Experience in analyzing Locks, Dead Locks and Handling the Isolation Level.
  • Experience in Backing up, restoring the data base manually and using Tivoli Storage manager (TSM) also by scheduling the jobs and Maintenance Plans.
  • Extensive experience in implementing High Availability Solutions like Replication, Log shipping, Clustering and Mirroring on physical and virtual machines.
  • Extensively worked on Active-Active and Active-Passive Clustering.
  • Worked on High Availability 2012 Solutions Always On.
  • Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
  • Scripted VB.net in the script task for data conversions in XML file in SSIS packages.
  • Created Packages and Procedures to automatically drop/create indexes for the tables.
  • Configured SMTP Server for DB Mail setup and received Alerts for Threshold values.
  • Handled multiple SQL Instances on Cluster built on SAN using RAID levels.
  • Explicitly used third party tools like Lite Speed, Data Mirror, Fog light and Red gate.
  • Auditing of database for user’s transaction, login and removing orphan users.
  • Actively involved in SLAs and management of Change Control Requests.
  • Strong experience in mentoring with team members, documentation.
  • Excellent Problem Solving Skills, Communication, Strong troubleshooting and Organizational skills.

TECHNICAL SKILLS:

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, CSS, Java Script

Operating Systems: Windows 95/2000/2003/2008/ XP/VISTA/7, Sun Solaris 9, LINUX, VMware ESX servers, ERP SAP

Databases: Microsoft SQL Server 2014,2012/2008R 2/2008/2005/2000, Oracle 11g/12c, MYSQL, DB2, MS Access

ETL & Reporting Tools: DTS, SSIS, SSRS, SSAS, Crystal Reports

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Tools: SQL DB Access, Performance Monitor, Backup Utility, Idera, SQL LiteSpeed, Visio 2000, RedGate, FogLite, Erwine 9.5, Data mirror

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Sr. SQL Server DBA

Responsibilities:

  • Installation & configuration 2008/2008 R2/2012/2016 Enterprise & Express Editions.
  • Working on MS SQL Server 2016, 2012/2008R2/2008/2005 and responsible for installation, configuration and provided 24 X 7 support to all production Servers.
  • Security issues dealing related to logins, DB users, application roles and linked Servers.
  • Migrated SQL data from SQL Server 2000, 2005 and 2008 to 2012. Resolved the issues after migration of the Database.
  • Handled the upgrading, patching and troubleshooting of the PDW APS, as well as user access and creation of new databases, schemas and deployments.
  • In-place and side-by-side Migration from SQL Server 2005, 2008 and 2008R2 to 2012.
  • Efficiently carried out DBA responsibilities in planning migration activities from DB2 to SQL server and SQL to ORACLE/MY SQL (RDBMS Databases) in migration.
  • Build and support Data Sync job on Windows Azure to synchronize data from SQL 2012 databases to SQL Azure.
  • Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
  • Experience in analyzing Locks, Dead Locks and Handling the Isolation Level.
  • Experience in writing automated Test scripts, designing stored procedures.
  • Planning for manual failover and Automatic failover for checking the failover test.
  • Expert in analyze execution plan and index management for better Query Optimization.
  • Extensive experience in implementing High Availability Solutions like Replication, Log shipping, Clustering and Mirroring on physical and VM’s.
  • Designed products, offerings and technologies relating to cloud computing and virtualization along with IT engineering teams.
  • Created Database Maintenance Plan for the Performance of SQL Server this includes Database Integrity Checks, Update Statistics and Re-indexing.
  • Expertize in taking SQL server Backup/Restore using Tivoli storage manager (TSM).
  • Taking Database Full Backup, Transaction log backup & differential backup as per backup strategy daily/Weekly Routine.
  • Maintained the database consistency with DBCC commands at regular intervals.
  • Extensive experience in utilities and tools used for database monitoring (SQL traces, online performance monitors, reports and catalog queries).
  • Excellent Communication, Strong troubleshooting and Problem Solving Skills. Able to work with all type of people and Organizational skills.

Environment: SQL Server 2000/2005/2008 /2008 R2, 2012, Oracle 12c, MS-Access, DB2, Windows 2008, T-SQL, HPQC, SSIS, Query Analyzer, SQL Profiler, BCP, DTS.

Confidential, Jackson, MI

SQL Server DBA

Responsibilities:

  • Installed, configured and maintained SQL server 2008/2012 enterprise Edition.
  • Working as a MS SQL Server Administrator and responsible for installation, configuration, tuning and provided 24 X 7 support to all production Servers.
  • Strong experienced in all insurances such as Property and Casualty Insurance including Auto, Home and Marine.
  • Resolved the issues after migration of the Database. Migrated the SQL 2000, 2005 and 2008 to 2012.
  • Expertise in Administration, Database Design, Performance Analysis, Production Support for Large (VLDB) and Complex Databases up to 5 Terabytes.
  • Converting DTS packages to SSIS packages.
  • Project DBA for database applications. Activities - Installing/configuring SQL server, patching, troubleshooting, performance tuning.
  • Transformation of data (Millions of records) to SQL server by SSIS, DTS, BCP.
  • Rebuilding the indexes at regular intervals for better performance.
  • Hands on experience and outstanding knowledge of High availability SQL Server solutions, including replication and SQL Server clustering.
  • Maintaining the database consistency with DBCC at regular intervals.
  • Generated Script files of the database changes are made to stored procedures or views.
  • Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
  • Performance tuning and optimization of Query of SQL server.
  • Converted and imported data from an Oracle/DB2 to a SQL Server Database.
  • Worked in tune with strategic planning for improving the mapping and data migration.

Environment: SQL Server 2000/2005/2008 Enterprise, Windows Enterprise Server 2003, T-SQL, DB2, VMware, SQL Server Reporting Services and Integration Services.

Confidential, Louisville, KY

SQL Server DBA and Developer

Responsibilities:

  • Planned, installed, configured and maintained the SQL Server 2008/2012 in Environment of Active/Active Cluster.
  • Implemented and maintained Database mirroring as a Disaster Recovery solution.
  • Involved in migrating data from DB2 to SQL Server and SQL Server to DB2 through import/export and BCP utility.
  • Hands on experience as DB2 DBA for mainframes. Provided mentoring services in DB2 DBA, Data Modeling and Development.
  • Extensively worked on migrating the databases from SQL Server 2005 to 2008 and also SQL Server 2005 / 2008 to SQL 2008 R2.
  • Implemented new features in SQL 2008 like Table Compression & backup compression, SQL Server Auditing, Resource Governor in T-SQL.
  • Extensively worked on Profiler, Perfmon, DMVs, DMFs and DB and query tuning.
  • Developed SSIS packages, scheduled them as jobs and deployed packages in SQL Server Integration Services.
  • Planned and worked on Table Partition setup for rebuild and update statistics.
  • Extract, Transform and Load data from heterogeneous data sources to SQL Server using the SSIS Packages.
  • Plan, analyze and develop Ad-hoc Reports using the SSRS and Report Manager to support various user requirements.
  • Involved in physical storage configuration of SAN with different RAID levels.
  • Worked with TDP and TSM tool for backup and recovery and also written SSIS packages for the backup and restores for few applications
  • Developed and optimized database structures, stored procedures, DMVs, DDL triggers and user-defined functions.
  • Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.

Environment: MS SQL Server 2008R2/2008/05/00, Windows 2008 Server, SSRS, SSAS, SSIS, Microsoft Visual Studio, DB2, MS BI Studio 2008, Fog light.

Confidential

SQL Server DBA

Responsibilities:

  • Install and configure SQL Server Instances and Management tools using SQL Setup.
  • Administer SQL Server using Client/Server tools like SQL Server Enterprise Manager and Query Analyzer.
  • Create Database Maintenance Plans for the Performance of SQL Server which covering Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Complete Back-up and Restore for Disaster Recovery. Manage replication servers.
  • Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Databases.
  • Experienced in Data Extraction, Transforming and Loading (ETL) using various tools like Data Transformation Service, SSIS, SSRS, Insert, BCP, Mirroring and Replication.
  • Data migration (import & export - BCP) from Text to SQL Server.
  • Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
  • Monitoring SQL server performance using profiler to find performance and dead locks.
  • Recovering the databases from backup in disasters.
  • Maintaining the database consistency with DBCC at regular intervals.
  • Monitoring SQL server performance using profiler to find performance and dead locks.

Environment: SQL Server 2005/2008, Transact- SQL, Query Analyzer, SQL Profiler, BCP, DTS, MS-ACCESS

Confidential

SQL Server Developer/DBA

Responsibilities:

  • Installation of SQL Server 2000/2005 on Windows 2000 environment.
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
  • Created Database Maintenance Plan for the Performance of SQL Server this includes Database Integrity Checks, Update Statistics and Re-indexing.
  • Developed DTS packages to transfer data from heterogeneous data sources and different files like Flat Files, Spread Sheets to SQL Server.
  • Data migration (import & export - BCP) from Text files to SQL Server 2005/2008.
  • Created Triggers to enforce data and referential integrity.
  • Developing SQL scripts for maintaining administration tasks. Tuned the SQL queries using SQL profile.
  • Involved in developing stored procedures, triggers for the application.
  • Designed and developed Stored Procedures, functions and DTS packages and error handling using T-SQL for SQL Server 2000, 2008.
  • Created stored procedures/Packages using Pl/SQL programming according to the business requirements.
  • Performed Query Optimization by use of Index implementation and Tuning Wizard.
  • Dropped and recreated the indexes on tables for performance improvements.

Environment: SQL Server 2000/2005/2008, Oracle 9i, Informatica, MS-Access, Windows 2003, T-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, BCP, DTS.

Hire Now