We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Boston, MA

SUMMARY:

  • 13+ years of experience with the 32bit, 64 - bit environments as Microsoft SQL SERVER DBA in Production, Development and Testing in Clustered and Stand alone Server Environment.
  • Experience in installing MS SQL SERVER 2017, 201, 2008R2, 2008, 2005, 2000; updating with hot fix and service packs.
  • Good knowledge and handful of experience on implementing Always ON High availability feature.
  • Extensive experience in implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
  • Extensively worked on Active-Active and Active-Passive Clustering.
  • Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
  • Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
  • Experience in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
  • Experience in Backing up, restoring the databases manually and also by scheduling the jobs and Maintenance Plans.
  • Expert in analyzing the execution plan and index management for better Query Optimization.
  • Handful of experience in PowerShell Scripting.
  • Implemented In place and Side by Side Migration of MS SQL SERVER 2005/2008/2008 R2 to MS sql server 2012, 2014 & 2016 environments.
  • Expert in Data Integrity, Performance Tuning, Query Optimization
  • Expert level skills in Objects creation such as Tables, Functions, Normalization, Indexes, Stored Procedures, Cursors, Triggers, Views and other SQL joins and query writing.
  • Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc. for finding out long running queries.
  • Explicitly used third party tools like Lite Speed, Fog light and Red gate.
  • Auditing of database for users transaction, login and database action and removing orphan users.
  • Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
  • Strong experience in mentoring with team members, documentation and 24/7 on call production support.
  • Expert in developing T-SQL (DDL, DML, DCL ) statements.
  • Expertise in Data Modeling Concepts.
  • Also Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
  • Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
  • Experience in logical and physical data modeling of the database in ERWIN and MS VISIO.
  • Configured the AWE and /3 GB switch for the SQL server 2005 on 32-bit boxes.
  • Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server.
  • Experience in handling the Change Data Capture (CDC) with different retention time.
  • Experience in SQL Upgrades SQL and Building SQL Clustering.
  • Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
  • Experience in using the DMVs, DMFs, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
  • Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
  • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
  • Worked with a team of business analysts, data architects, application developers, ETL developers and testers. My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
  • Experience with Microsoft SQL Server Integration Services or any compatible ETL tool and Reporting tool with SQL Server Reporting Services using Business Intelligence Development Studio (BIDS)
  • Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
  • Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
  • Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
  • Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
  • Expert in creating SQL Server Reports using SSRS 2005 and 2008.
  • Expert in using Version Control Software like Visual SourceSafe (VSS).
  • Extensive experience in the development of Reports using SQL Server 2000/2005 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, Drilldown reports in multiple formats using multi - dimensional objects.
  • Strong ability in Scheduling and deploying reports on Report manger.
  • Experience working with change control process
  • Expert in using MS Office suite 2007 including MS Access.
  • Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

Tools: SQL, My SQL, C#, ASP. NET, HTML, XML, C/C++, Java Script

Operating Systems: Windows 2000/2003/2008/2008 r2/2012/2016/XP/VISTA/7, UNIX (Sun Solar), LINUX (RHEL, CentOS)

MS: SQL Server 7.0/2000/2005/2008/2012/2014/2016/2017 , mysql, MS Access

ETL Tools: Data Transformation Services, SSIS, SSISDB

Reporting Tools: SSRS, SSAS

DB Utilities: SQL Server Management Utility, Query Analyzer, Profiler, Database Tuning Advisor, DMVs, DMFs, server side trace.

Application Software: Visual Studio 2005/2008/2010/2012/2013/2015/2017 , Visual Source Safe, TFS, MS Office Suite

Third party Tools: Erwin, Visio, Red gate products, Lite Speed, spotlight, SCOM

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

SQL Server DBA

Environment: MS SQL Server 2017, 2016, 2014, 2012, 2008R2, 2008,2005, TSQL,OLTP,OLAP, Windows 2008/2008R2/2012/2016 versions, Redgate’s DataMasker, Erwin, Redgate Monitoring tool and other redgate products, EMC networker backup tool, SSIS, SSRS, SSAS.

Responsibilities:

  • Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
  • Masking Sensitive/PII data in non-production databases using Redgate’s Product called DataMasker.
  • Have good experience in Automation of the Data Masking PII/Sensitive data on all Non-Production Databases.
  • Installation of MSSQL Server 2017, 201, 2008R2 on Production, UAT, Testing and Development environments.
  • Working on tickets\incidents within the SLA’s, as a part of operations support DBA in all sql environments.
  • Plan, create, implement, and maintain database maintenance plan,s including DBCC commands, defragging indexes etc. including all supporting documentation.
  • Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
  • Strong knowledge in working on Very Large databases (OLTP) and involved in troubleshooting the problems and dealing with complex databases.
  • Managing and maintaining the current database deployment process. Maintain proper Patch levels in all environments of SQL Servers.
  • Migrated databases from sql server 2008, 2008R2, 2012 to Sql Server 2014, 2016, 2017.
  • Implemented & managed database clustering, failover as per client requirement Active/Passive & executed of any upgrade such as Service Pack, Hot fixes in Active/Passive clustering.
  • Mirroring experience with both synchronous and Asynchronous and applying service packs.
  • Handful of experience in configuring Log shipping and troubleshooting the related issues.
  • Extensively used Repositories like Team Foundation Server (TFS) and Visual Source Safe.
  • Plan, implement and maintain Backup and Disaster Recovery Solutions.
  • Assigned for Database Optimization that involved re-engineering the databases, data and index organizing, performance tuning and query tuning.
  • As a part of the team, configured Transactional Replication with multiple publishers and centralized subscriber for real time reporting.
  • Participate in strategic planning of database technology usage such as SQL Server Version levels, hardware levels, jobs automations, failure notifications, server monitoring etc.
  • Good knowledge and handful of experience in configuring and working with Always on Availability Groups. Also Used Powershell to automate admin tasks.
  • Querying the databases using the Power shell scripts.
  • Expertise in working on Virtual Machines with SAN and NAS Storages.
  • Familiar with Virtualization technology and running Windows inside a Virtual Machine .
  • Fixed the failed PRINCIPALS (logins), user permissions and security in Active Directory and SQL Server Level.
  • Used the Powershell scripting to get the most consistent production environment.
  • Created numerous reports using reporting services SSRS and deploying them on SharePoint.
  • Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments.
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Expertise on physical storage SAN configuration on different RAID levels.
  • Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal, vertical partitioning and Setting up clustered Instances.
  • Handful of experience in PowerShell Scripting.
  • Creating Logins and Roles with appropriate permissions. Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
  • Resolving blocking and deadlocks using DMVs, Profiler and killing respective SPIDs and also optimizing the queries, which are involved in blocking and deadlock issues.
  • Good knowledge and handful of experience on implementing & maintaining Always on High availability starting on sql server 2012, 2014, 2016 & 2017.
  • Plan, monitor, request allocation and maintain appropriate amounts of disk storage for all SQL Server, communicate storage estimates to Network Solutions group.
  • Scheduling SQL Server Agent Jobs for updating statistics, checking fragmentation, checking database integrity and backup plans.
  • Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
  • Involved in capacity planning, sizing and database growth projections.
  • Monitor and modify performance using execution plans and Index tuning.
  • Optimize the performance of queries with modifications in T-SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
  • Interacting with development team in writing good standard TSQL queries. Rebuilding indexes with different fill factors and updating statistics
  • Extensively worked on Backup compression and data compression in SQL Server 2017/2016/2014/2012/2008 R2/2008.
  • Good Knowledge and experience in implementing SQL database in SQL Azure and AWS cloud computing platform.
  • Handful of experience in implementing automation of operational tasks using scripts.
  • Applied patches, hot fixes, cleared .NET framework corruption errors.
  • Provide technical support, troubleshooting and resolution for database related issues. Actively participated in forums, newsgroups and as a volunteer in Technology Meetings.
  • Handful of experience in implementing & maintaining SQL databases in SQL Azure and AWS RDS cloud Computing platforms.
  • Extensively worked on Active-Active and Active-Passive Clustering
  • Review query plans, optimize index usage, perform TSQL code review and optimization as needed.
  • Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Confidential, Charlotte, NC

SQL Server DBA

Environment: MS SQL Server 2005, 2008R2, 2012, 2014, 2016 TSQL,OLTP,OLAP, Windows 2008/2008r2/2012, Spotlight, LiteSpeed, Fog light, SSIS, SSRS, SSAS, Visio 2007/2010/2013.

Responsibilities:

  • Installation of MSSQL Server 201, 2008R2 on Production, UAT and Development environments.
  • Working on tickets\incidents within the SLA’s, as a part of operations support DBA.
  • Maintaining the database consistency with DBCC at regular intervals, Managed Disk space and memory and User connections and Monitored SQL server performance using profiler to find performance and deadlocks.
  • Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
  • Strong knowledge in working on Very Large databases (OLTP) and involved in troubleshooting the problems and dealing with complex databases.
  • Migrated databases from sql server 2008, 2008R2, 2012 to Sql Server 2014.
  • Implemented & managed database clustering, failover as per client requirement Active/Passive & executed of any upgrade such as Service Pack, Hot fixes in Active/Passive clustering.
  • Mirroring experience with both synchronous and Asynchronous and applying service packs.
  • Handful of experience in configuring Log shipping and troubleshooting the related issues.
  • Extensively used Repositories like Team Foundation Server (TFS) and Visual Source Safe.
  • Good experience in migrating data from MySQL to Sql server databases.
  • Handful of experience in configuring and trouble shooting Master-slave replication in Mysql both in windows and linux operating system.
  • Migrated the 5.7.21 MySQL servers from RHEL linux to CentOS 7 environments and coonfigured same Disaster recovery plan, backup strategies, users, cron jobs, logins in new environment as well.
  • Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
  • Assigned for Database Optimization that involved re-engineering the databases, data and index organizing, performance tuning and query tuning.
  • As a part of the team, configured Transactional Replication with multiple publishers and centralized subscriber for real time reporting.
  • Also implemented Mirroring for DR Plan.
  • Good knowledge and handful of experience in configuring and working with Always on Availability Groups. Also Used Powershell to automate admin tasks.
  • Querying the databases using the Power shell scripts.
  • Expertise in working on Virtual Machines with SAN and NAS Storages.
  • Familiar with Virtualization technology and running Windows inside a Virtual Machine .
  • Fixed the failed PRINCIPALS (logins), user permissions and security in Active Directory and SQL Server Level.
  • Used the Powershell scripting to get the most consistent production environment.
  • Created numerous reports using reporting services SSRS and deploying them on SharePoint.
  • Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments.
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Handful of experience in PowerShell Scripting.
  • Creating Logins and Roles with appropriate permissions. Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
  • Resolving blocking and deadlocks using DMVs, Profiler and killing respective SPIDs and also optimizing the queries, which are involved in blocking and deadlock issues.
  • Good knowledge and handful of experience on implementing Always on High availability starting from sql server 2012 and 2014 versions.
  • Good experience with handling 15 to 20 TB sizes of Databases and configured Disaster Recovery Plans to meet the application partner's requirements.
  • Scheduling SQL Server Agent Jobs for updating statistics, checking fragmentation, checking database integrity and backup plans.
  • Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
  • Involved in capacity planning, sizing and database growth projections.
  • Monitor and modify performance using execution plans and Index tuning.
  • Optimize the performance of queries with modifications in T-SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
  • Interacting with development team in writing good standard TSQL queries.
  • Handful of experience in implementing automation of operational tasks using scripts.
  • Applied patches, hot fixes, cleared .NET framework corruption errors.
  • Documentation, Training and mentoring the staff.
  • Actively participated in forums, newsgroups and as a volunteer in Technology Meetings.
  • Handful of experience in implementing SQL databases in SQL Azure and AWS cloud Computing platform.
  • Good Knowledge and experience in implementing SQL database in SQL Azure and AWS cloud computing platform.
  • Extensively worked on Active-Active and Active-Passive Clustering
  • As a part of the team, was always involved in production deployment or production release.
  • Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Confidential, Wilson, NC

SQL Server DBA

Environment: MS SQL Server 2005, 2008R2, 2012, 2014, 2016, TSQL,OLTP,OLAP, Windows 2008/2012, Visio 2007, SSIS, SSAS, SSRS.

Responsibilities:

  • Reviewed and analyzed requirements for New Projects with Application and Business teams.
  • Coordinated with SAN Team and involved in Capacity Planning and Storage allocation for Test, Dev, Stage and Prod environments.
  • Installed SQL Server 2008R2/2012/2014 manually and by using HP Server Automation tool.
  • Installed, configured and administered SQL Server Integration and Reporting Services.
  • Migrated Servers from SQL Server 2000 and 2005 and 2008R2 to 2008R2 and 2012 and 2014 based on the application team requests.
  • Based on the business need created Transactional Replication on Different applications.
  • Configured and maintained database mirroring for high availability.
  • Implemented AlwaysOn Availability Group as a High Availability solution on SQL Server 2012 and 2014.
  • Applying the Hot fixes and patches based on the requirements for different stores within the maintenance window.
  • Applying the Service packs and Cumulative Updates based on the Requirement to fix the issues.
  • Routine DBA activities: Backup and Data recovery, Data security, Data Migration, Performance Tuning, Data Integrity analysis, User Management.
  • Created Database Maintenance Plan to implement Database backups, Integrity Checks and indexing.
  • Evaluated 3rd party SQL Server Monitoring Tools that could be used for database administration.
  • Configured SQL Server 2008R2/2012 Active/Passive Clusters in different environments applying the installation and configuration standards.
  • Handling of the database backup failures, fixing the issues and make sure the availability of daily backups.
  • Resolving the Database I/O Consistency errors and Allocation errors.
  • Performing Health checks and Monitoring performance of the Production Servers.
  • Implemented SQL Server Security Standards by granting minimal permissions, using database Roles, Windows Authentication and Active Directory Groups.
  • Providing the accesss to users based on the requirement to the Production/UAT/QA/Development Servers with appropriate approvals.
  • Handful of experience in implementing SQL databases in SQL Azure and AWS cloud Computing platform
  • Handling of the low Logical disk space issues, Tempdb issues, Data file and Log file issues.
  • Monitored the event logs and server logs for troubleshooting and problem solving.
  • Used Powershell to automate admin tasks.
  • Querying the databases using the Powershell scripts.
  • Used the Powershell scripting to get the most consistent production environment.
  • Database refreshments from Production to DEV/UAT/QA environments.
  • Maintained SQL Inventory documented backup strategies, SQL Server best practices, and installation and configuration procedures.
  • Used DMVs, Alerts, SQL Profiler, Performance Monitor to proactively monitor and tune the Database Environment
  • Adhered to the Change Management procedures.
  • Evaluated new features in SQL Server 2012 and SQL Server 2014 in lab environment namely Enhanced to Backups, contained databases, Security Principals and AAG.

Provided 24/7 Production Support (on-call) and resolved all tickets related to SQL Server Database and tickets opened by application and operations team including SSIS/SQL Job failures, Disk space, Blocking

Confidential, Omaha, NE

SQL Server DBA

Environment: MS SQL Server 2008R2/2012, TSQL,OLTP,OLAP, Windows 2008, Idera, Erwin, Visio 2007, SSIS, SSAS, SSRS.

Responsibilities:

  • Migration of databases from SQL Server 2005 to SQL Server 2008R2.
  • Migrated the SCOM (System Center Operations Manager) 2007 R2 and installed required Service packs and cumulative updates to the SQL Server 2008R2 environment.
  • Installed SQL Server 2008R2 on windows 2008R2 and migrated SSIS packages.
  • To analyze long running slow queries and tune the same to optimize application and system performance.
  • To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via Active Directory.
  • Providing 24/7 support for critical production databases (OLTP and OLAP).
  • Hands on experience in Batch Processes, Import, Export, Backup, BCP, DTS and SSIS.
  • Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
  • Expert in migrating the DTS Packages to SSIS Packages by using Package migration Wizard.
  • Implemented SQL Server Security Standards by granting minimal permissions, using database Roles, Windows Authentication and Active Directory Groups.
  • Expert in Deploying, Scheduling and running SSIS jobs by using Proxy Accounts.
  • Experience in managing OLAP Database Warehouse by using services like Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
  • Data migration using bulk copy program (BCP) and DTS to Flat files and Expertise in Data Staging.
  • Handful of experience in working with 12-15 TB sizes of databases and did partition of tables involved and configured Disaster recovery plans.
  • Experience in writing scripts like retention of data using batch deletes.
  • Export or Import data from other data sources like oracle, flat files using Import/Export, SSIS.
  • Good Knowledge and experience in implementing SQL database in SQL Azure and AWS cloud computing platform.
  • Developing T-SQL stored procedures, Log on & DDL triggers, views and adding/changing tables for data load and transformation, and data extraction and loading to data ware house.
  • Working on different environments and a key resource for deployment of modified objects to production environments.
  • Developed, deployed and monitored SSIS Packages, Incremental loading and dynamic SSIS Packages with parent package variables.
  • Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
  • Incremental loading of dimensions, facts, error handling in SSIS.
  • Created Dynamic SSIS packages, to load Stage tables from text files.
  • Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
  • Worked on SQL Server Reporting Services (SSRS), drill down, parameterized reports, and cascading reports deployed them on Report server from Report Manager.
  • Performed horizontal data partitioning for efficient management of database tables and indexes, Full text indexes, Using Contains, Tuning LOB, BLOB data types.
  • Maintaining the database consistency with DBCC at regular intervals, Managed Disk space and memory and User connections and Monitored SQL server performance using profiler to find performance and deadlocks.
  • Implemented & managed database clustering, failover as per client requirement Active/Passive & executed of any upgrade such as Service Pack, Hot fixes in Active/Passive clustering.
  • Mirroring experience with both synchronous and Asynchronous and applying service packs.
  • Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
  • Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
  • Generated Script files of the databases whenever changes are made to stored procedures or views.
  • Configured and managed virtual Servers and worked on virtualization and clustering environment.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
  • Created DB master key, symmetric keys, asymmetric keys, certificates for encryption.
  • Monitored and modified Performance using execution plans with query hints and Index tuning.
  • Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
  • Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages and performance testing on stored procedures, indexes, and triggers.
  • Experience in using ERWIN tool for Entity Relationship diagrams and reverse engineering.

Confidential, Atlanta, GA

SQL Server DBA

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2012, 2008 (R2), Microsoft SQL Server 2005, Windows 2003/2008 Server, IIS Server 7, MS Visual Source Safe, IIS 6.0, XML.

Responsibilities:

  • Installation and Maintenance of SQL Server 2005/2008(R2)/2012 on Test, Development and Production Environments.
  • Create and manage databases across Development and Production instances using SQL Server Management Studio.
  • Usage of new compression Techniques in SQL Server 2005/2008(R2) for backup and restore jobs.
  • Experience working with TSM Backups and Restore.
  • Disaster Recovery Planning, Testing and analyzing and continuous update of documentation.
  • Implemented Database Mirroring, Log Shipping, Transactional Replication as a part of DR plan.
  • Creating Logins and Roles with appropriate permissions.
  • Creating and Maintaining Database Maintenance Plans.
  • Configured Database Mail for failure Job notifications
  • Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
  • Enabling and Disabling Change Data Capture (CDC).
  • Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
  • Tune slow running queries using SQL Server Profiler
  • Worked with database tuning advisor, SQL server profiler, Performance monitor and activity monitor for Performance tuning
  • Experience working with IDERA in Server Monitoring for Performance Monitoring, Dead Lock, Blocking.
  • Import data across multiple instances using BULK INSERT and BCP Utility.
  • Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
  • Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
  • Worked with DTS Packages to load the massaged data into Data Warehousing System.
  • Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
  • Create Clustered and Non-Clustered Indexes to improve the performance of database access.
  • Extensively worked on performance issues like Update statistics and Autostats
  • Involved in Capacity Planning, Database Normalization and De-normalization process.
  • Optimized the database server using DMV’s and DMF’s and performed a code review and tuning for the best performance of the application.
  • Involved in Logical and Physical Data Modeling process using MS Visio.
  • Use MS Visual Source Safe as a Version Control System.
  • Involved in Change Data Capture process.
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Mentored team members to optimize SQL Queries.

Confidential, Columbus, OH

SQL Server DBA

Environment: MS SQL Server 2000/2005, IIS Server 5.0, Windows 2000/2003 servers, Outlook Express, .NET, MS Access.

Responsibilities:

  • Installing and configuring and tuning and providing 24X7 support for SQL Server 2000 and 2005 in development and production environments.
  • Created and scheduled jobs to setup log shipping between production servers.
  • Implemented Database Mirroring on the SQL Server 2005 production databases.
  • Job Monitoring and making sure all jobs run successfully every night.
  • Creating databases and logins with permissions in SQL Server 2005 as per the developer’s request.
  • Worked extensively on SQL Server Reporting Services to generate reports.
  • Created Linked Servers between SQL server 2000 and 2005 servers.
  • Did Migration from SQL Server .
  • Created Database Diagrams using E RW in Data Modeler.
  • Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
  • Migrated and tested DTS packages to SQL Server 2005 Integration Services.
  • Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Involved in the creation of cubes in the MS SQL Analysis Services.
  • Restore Development and Staging databases from production backups as per the requirement.
  • Extensively used SSIS to move data from text files to SQL Server.
  • Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
  • Prepare daily report on the job failures, backup failures and disk space.
  • Extensively used Database Performance Monitoring tools for performance tuning.
  • Designed and implemented database maintenance plan.
  • Used Index tuning wizard and rebuilding indexes for faster Query Performance .
  • Involved in resolving dead lock issues and performance issues.

Confidential

SQL Server DBA/Developer

Environment: MS SQL Server 2000/2005, Excel, Query Analyzer windows NT/2000 server & Professional

Responsibilities:

  • Installation and configuration of MS SQL Server 2003/2000/7.0
  • Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project.
  • Created ER diagrams
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and configured IIS and Worked on Index tuning, stored Procedure tuning.
  • Involved in Optimization and normalization of database and tables.
  • Involved in conceptual and physical modeling of data using ERWin tool.
  • Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
  • Part of team for analyzing and implementing the physical design for database.
  • Writing complex Stored Procedures to meet the business requirements.
  • Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
  • Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000\2005.
  • Designing and building data load procedures, using MS SQL Server.
  • Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
  • Responsible for transferring of database and database objects from Development to Production Server using DTS.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
  • Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.

Hire Now