We provide IT Staff Augmentation Services!

Senior Sql Dba Resume

Piscataway, NJ

SUMMARY

  • 8 years of IT experience which includes System Analysis and Design, Development, Support & MS SQL Servers 2000/ 2005/2008/2008 R2/2012 Production, Development and Testing in Clustered and Standalone Server Environment.
  • Experience in installing MS SQL SERVER 2000,2005,2008,2008R2,2012 updating with the hot fix and service packs.
  • Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
  • Performed In - place upgrade and side- by - sideupgrade of MSSQL server 2000/2005/2008 to 2008R2.
  • Implemented Disaster Recovery techniques like Database Mirroring, Log Shipping and Replication Models.
  • Configured HADR Always ON on SQL Server 2012.
  • Hands-on experience with SQL Server 2008 new features like Change Data Capture (CDC), Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
  • Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot Isolation, Database Mirroring, Database Snapshot, DDL triggers, Try-Cache blocks, Online indexing, DMV’s, DMF’s, SQLCMD and Dedicated admin connection.
  • Implemented SSMA (SQL Server migration Assistant) database migration tool for migrating Oracle/Sybase/MySQL and Microsoft Access databases to SQL Server.
  • Explicitly used third party tool Idera SQL Diagnostic Manager to monitor performance.
  • Analyzing and troubleshooting the IIS crashes.
  • Extensively used the native tools like Index tuning wizard, Database tuning advisor, Profiler, Perfmon, Activity monitor, Event viewer for performance analysis.
  • Experience in administrative activities comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, and Updating Statistics.
  • Experience in analyzing Locks, Dead Locks and handling the Isolation Level and Concurrency Effects.
  • Experience in Backing up, restoring the database manually and by scheduling the jobs and Maintenance Plans.
  • Configured Security at Active Directory and SQL Server Level by Creating Principals (logins) and mapping users to roles (Securable and Permissions).
  • Experience in using the DMVS, DMFS, SP PROCS, Information Scheme, and System Views and in built Global Variables for the instant analysis.
  • Expert level skills in creating objects like Tables, Views, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing using T- SQL statements.
  • 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 MSVISIO, Normalization, DE normalization, and Database design.
  • Expertise in analyzing and estimating the Execution Plan for better Query Optimization.
  • Configured SMTP Server for Database Mail setup and received alerts for the threshold values.
  • 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
  • Deployed and debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
  • Experience in generating Reports (SSRS) in Business Intelligence Development Studio (BIDS).
  • Explicitly used third party tools like Lite Speed, Fog Light and Red Gate.
  • Created linked servers between Oracle 10g and MS SQL SERVER 2008 R2 and also deployed SSIS packages for data transfer.
  • Good knowledge of Oracle Database 10g Administration and Creating pl/sql packages, procedures and functions
  • Capable of scheduling jobs, backup and restore in Oracle 10g using SQL plus(html mode)
  • 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
  • Involved in all phases of the SDLC (Software Development Life Cycle).
  • Strong experience in mentoring with team members, documentation and 24/7 on call production support.

PROFESSIONAL EXPERIENCE

Confidential, Piscataway, NJ

Senior SQL DBA

Responsibilities:

  • Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).
  • Configured the Mirroring between servers
  • Set up database Backup jobs for more efficient recovery by setting up Full/Differential Backup and more frequent Transaction Log Backup for more dynamic databases
  • Schedule SQL Agent jobs in shrinking fast growing log files, deleting junk records or old logins, updating statistics, and checking integrity of databases
  • Create and schedule stored procedures as jobs to check SQL Server Error Logs and identify issues;
  • Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
  • Monitoring constantly growth of databases and transaction logs, change of server configuration, database settings, and schemas for possible issues.
  • Performance tuning of Windows and IIS servers.
  • Analyzing and troubleshooting the IIS crashes.
  • Constantly check the SQL Server Performance Dashboard Reports for Memory Consumption, top queries by Average/Total CPU Time, Average/Total IO, Top Sessions, among others
  • Set up Transactional Replication to sync up data between servers on demand
  • Create, alter, drop, maintain system Roles and Permissions to users on various database objects on demand
  • Verify that backup files are complete and valid when alerted by the error message in the Error Logs;
  • Document SQL server/database settings, configuration change history, maintenance plans, and MS Tech Support, surveyed and document the use of databases in all applications
  • Troubleshoot performance issues
  • Designed and implemented Backup Plans for mission-critical databases
  • Use Performance Monitor to collect and view real-time info about memory, disk, processor, databases, and network activity
  • Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
  • Apply the workload SQL Profiler collected to feed Database Tuning Advisor (DTA)
  • Use DBCC utilities to check for and rectify problems, thus proactively avoid performance issues down the line
  • Run system procedures, such as sp lock, sp who, sp who2, sp monitor, to monitor on-going performance
  • Set up system alerts when a counter’s value is above or below a defined threshold;
  • Check the performance of all indexes on a weekly basis, identify and drop indexes that have never been used for at least one month since last restart of the Server, in order to reduce maintenance overhead;
  • Rebuild highly fragmented indexes, reorganize indexes with fragmentation, and defragmenting heaps by creating clustered indexes;
  • Update statistics with full scan on a weekly basis to make sure that the query optimizer uses the most recent statistics.
 

Environment: MS SQL Server 2005,2008 R2,2012 Windows 2003 Server, Windows 2008 R2 Server, ERWIN, MS Visual Studio 2010, Excel, HTML,JIRA 4.3.

 

Confidential

Senior SQL DBA

Responsibilities:

  • Verifying and maintaining database backups, integrity checks, and scheduled jobs;
  • Migrating databases and database objects between multiple servers across production and development platforms;
  • Created stored procedures for backup and restore of system and user databases from Disaster Recovery;
  • Managing day-to-day SQL Server operations in SQL Servers 2005/2008/2008 R2;
  • Designing and implementing Disaster Recovery Procedures like Log Shipping, Replication;
  • Created and implemented DTS/SSIS Packages for importing and exporting data to other data storage;
  • Conducting Root Cause Analysis of application availability related to coding practices, database bottlenecks, or network latency;
  • Deploying IDERA Diagnostic Manager for monitoring SQL Server;
  • Creating Linked Servers to move data from Oracle Server to other production servers;
  • Documenting all the databases, database objects, jobs and the changes made to the database;
  • Troubleshooting, monitoring, and tuning SQL server and databases performance using SQL Profiler, System Monitor;
  • Resolving issues related to Query Optimization and Index Tuning;
  • Checking the Configuration and performance of the existing databases including data file allocation, index, fill factor, fragmentation;
  • Analyzing potential problems, e.g., Response Delay, Locking, server down time, for Optimization of performance;
  • Resolved Locking and Blocking issues during peak period of website highest hits.

Environment: SQL Server 2008R 2/2008/2005/2000 , Windows 2008/2003/2000 Server, SQL Lite speed 4.5, MSE, ME Change Request, Visio Enterprise Manager, IDERA, SQL Query Analyzer, and SQL Profiler.

Confidential

SQL DBA

Responsibilities:

  • Installing, configuring and maintaining SQL Server 2008 R2.
  • Design and normalize the databases and created different objects like tables, views, Stored Procedures, Functions, indexes rules and defaults on MS SQL server using T-SQL.
  • Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
  • Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
  • Migrated MS Access, MySQL database to SQL Server 2008 R2 using SSMA tool
  • Developed stored procedures for generating Reports as per management requirement.
  • Tuned complex SQL Queries.
  • Provided day-to-day administration tasks like space and log management.
  • Responsible for fine tuning of the database, troubleshooting, memory management.
  • Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
  • Created reports based on database usage and perform capacity planning.
  • Responsible for creating user groups and assigning permissions.
  • Optimized stored procedures and indexed query using Index Tuning Wizard.
  • Worked on database Design and Architecture based on business user requirements and performed Normalization (Third Normal Form) and De-Normalization.
  • Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
  • Setup and maintained Linked Servers.
  • Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
  • Managed user access. Created and managed new security accounts.
  • Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
  • Extensively used Toad tool Connect to SQL server implementing the scripting.
  • Designed and facilitated the implementation of data warehouses required by application systems
  • Supported OLAP team to providing data from SQL Servers.
  • Published the databases from old servers to new servers using snapshot replication.
  • Assisted with various ad hoc query requests.
  • Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2000/2005 ETL, DTS, SSIS, Windows 2003 Server, ERWIN, MS Access, Toad, Excel.

Confidential, Minneapolis, MN

SQL DBA

Responsibilities:

  • Installation of SQL Server 2008/2005, service packs, hot fixes, security patches, Lite speed
  • Implemented and maintained Database mirroring as a Disaster Recovery Solution
  • Worked on the migration of SQL Server 2000 to SQL Server 2005
  • Used Data Partitioning, Snapshot Isolation in SQL Server 2005
  • Update statistics, database integrity check and Backup operations
  • Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages
  • Designed and implemented comprehensive Backup plan and disaster recovery model
  • Worked extensively in Query Analyzer and Profiler for tuning queries using variable for characteristics and query costs
  • Created and modified Stored Procedures and Functions to generate reports
  • Used log shipping for synchronization of database
  • Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM
  • Configuring Perfmon, blocking analysis, enabling of AWE and PAE, Max degree Parallelism
  • Practical experience in managing the internal and external MS SQL database security.
  • Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
  • Responsible for creating user groups and assigning permissions.
  • Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
  • Setup and maintained Linked Servers.
  • Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
  • Provided back-end support for functional testing and performance testing.

Environment: MS SQL Server 2000/2005 ETL, DTS, SSIS, Windows 2003 Server, ERWIN, MS Access, Toad, Excel.

Hire Now