We provide IT Staff Augmentation Services!

Senior Sql Dba Resume

Piscataway, NJ

PROFESSIONAL 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/20 R2.
  • 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.

TECHNICAL SUMMARY:

Databases: MS SQL Server 2012/2008R 2/2008/2005/2000 & 7.0, Oracle8i.

Programming: Visual Basic 6, Visual Basic 5, C, C++, JAVA, .NET & SQL

Operating System: Windows 2008 R2/2003/2000 Advanced Server, NT & Windows 9x, Linux

Other Software: Active X, IIS, Microsoft Transaction Server, VBScripts, HTML, XML

Tools: SQL DB Access, Performance Monitor, Backup Utility, SQL Lite Speed, Visio 2000, Red Gate, Fog Lite

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

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, Coconut Creek, FL

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, Miami, FL

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.

Confidential

SQL Server Developer/DBA

Responsibilities:

  • Created Database tables with constraints and relationships between multiple tables.
  • Created Views, User Defined Functions and Triggers.
  • Extensively used the VB coding and HTML usage.
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
  • Administered the MS SQL Server 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.
  • Responsible for creating Stored Procedures and Scheduled to run them by creating SQL Agent Jobs.
  • Performed various data transfers between various servers using BCP and DTS.
  • Supported team in resolving in DTS and T-SQL related issues.
  • Involved in performance tuning and query optimization.
  • Performed Database and Performance testing for the database objects.
  • Created backup/restore and disaster recovery plans for production servers.
  • Backing and Restoring of Databases on Scheduled basis.
  • Involved in documenting the entire technical process.
  • Supported technical teams involved with MS SQL issues and operations.
  • Involved in the maintenance of the database.

Environment: SQL Server 2000, Oracle 8i, VB 6.0, Windows 2000, Erwin, IIS 5.0, Crystal Reports 9.0 and Microsoft Reporting services 2.0

Confidential

SQL Developer

Responsibilities:

  • Applied Normalization rules in designing the database.
  • Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.
  • Developed database objects like tables, views, stored procedures, indexes etc.
  • Tuned SQL statements using views and stored procedures.
  • Rebuilding the indexes at regular intervals better performance.
  • Coded various stored procedures for the purpose of application development.
  • Design and implemented data access stored procedures and triggers for automating tasks.
  • Extensively used joins and sub-queries to simplify complex queries involving multiple tables.
  • Responsible for creating DTS packages and scheduling packages.
  • Performed various data transforms between various servers using BCP and DTS.
  • Worked on crystal reports with many complex stored procedures.
  • Created multi-format reports using Crystal report.

Environment: SQL Server 2000/2005, java1.3 and Windows 2000.

Hire Now