SQL Server DBA Resume Detroit, MI - Hire IT People

PROFESSIONAL SUMMARY:

For a past 7+ years working as a MS-SQL Server (2000, 2005, 2008) DBA in various critical projects resolving connectivity, performance and ad-hoc user issues , involved in installing both SQL Server standby installation , cluster failover installation (Active-Active, Active-Passive) and administration in handling of production.

High proficiency with SQL Server Architecture (Fundamentals of SQL Server Architecture, Features of SQL Server, Relational Database Components, Database Architecture, Relational Database Engine Architecture, Administration Architecture, Application Development Architecture).

Closely worked with client services and development team for analysis of client requirement and worked with development team to configure those changes into database management configuration.

Excellent experience in working with databases deployed using virtual technologies such as VMware.

High proficiency with Administering SQL Server (Starting, Pausing, and Stopping SQL Server, Failover Clustering, Managing Servers, Managing Clients, Automating Administrative Tasks, Managing Security, Monitoring Server Performance and Activity).

Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008/2008-R2.

Strong SQL Server Administration skills using various backup strategies, Model (simple, bulk and full), database maintenance plan, user (NT/SQL) security authorizations, database creation, Tables, indexes.

In depth knowledge of developing complex stored procedures, views, efficient triggers, required functions, and creating indexes and indexed views for speedy performance using SSMS and SQLCMD.

Proficient in monitoring SQL Server Performance using SQL Profiler(Dead Locks/Long running queries), Query Analyzer, Index Tuning Wizard, Database Engine Tuning Wizard and Windows Performance Monitor.

Experience in implementation and maintenance of Very Large Databases (VLDB) and estimating the growth of the databases and maintaining Fill Factors.

Having experience on handling Performance issues like handling CPU issues, handling slow running queries, finding the bottleneck and recommending for better performance.

Highly skilled in data migration of data from Excel, Flat File, Sybase, Oracle to MS SQL Server using tools like DTS, SQL Server Integration Services (SSIS), BULK_INSERT, BCP and Replication between SQL Server (heterogeneous/homogenous).

Experience in Disaster Recovery with Backup and Restore Strategies and scheduling those backups.

Experience in creating jobs, SQL Mail Agent, Alerts, operators and schedule SSIS and DTS Packages.

Experience in Setting up High availability solutions like Log shipping, Replication, Clustering and mirroring.

Managed day-to-day User activities like creating logins, granting permissions, applying security for new users and creating user Roles and Role Members to ensure Database Security.

Experience with ER-win data modeler for generating physical and logical schemas.

Expertise in Server failure issues like dealing cluster failover issues, finding out root cause for failovers by analyzing the dumps and configuration, taking precautionary steps to follow for server failures and handling server failures by bringing back the server online.

High level proficiency with various types of Replication Models such as Snapshot, Transactional and Merge Replication (Planning for Replication, Types of Replication, Replication Tools, Implementing Replication).

Experience in using third party tools like Lite Speed (Backup and Database Recovery), and data modeling tools like ERWIN.

Rebuilding indexes with different fill factors and updating statistics.

Good knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.

Self-motivated and Flexible to adapt to any new environment and work on any project.

EDUCATION:

Bachelor of technology

TECHNICAL SKILLS:
Databases : MS SQL Server 2008 R2 / 2008 / 2005 / 2000.
Language : T-SQL, C, C++, Visual studio2005 / 2003.
Operating Systems : Windows Vista / XP / 2000 / NT, Server 2003.
ETL Tools : SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Integrator, Data Transformation Services.
Third Party Tools : Erwin, Red gate, lite speed, fog lite.
Database Tools : SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.
Applications : Microsoft Office Suite, Adobe Photoshop.
Ticketing Tools : Heat, BMC remedy, Picasso.

PROJECT SUMMARY:

Confidential,Detroit, MI January 2011 – Till Date
Sr. SQL Server DBA

Confidential,is a unit ofAlly financial, headquartered in Detroit, Michigan, which became a bank holding company. Ally Bank is adirect bankthat markets to customers offering simple, transparent products at competitive interest rates. It offers FDIC-insured savings products, including no-penaltycertificates of deposit(CDs), onlinesavings accounts,money market accounts and interestchecking accounts. MIGRATION AND SUPPORT on day to day activities in production.

Responsibilities:

Creation of users, Logins and database objects as per requirements and fixing orphaned users

Actively involved in designing the logical and physical architecture of the Databases.

Created tables, indexes, constraints and Views to facilitate easy user interface implementation, and triggers on them facilitate consistent data entry into the database.

Involved in creating Schemas, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures and troubleshooting problems by using SQL server profiler.

Created Database Maintenance Planner for the Performance of SQL Server, which covers database Integrity Checks, Update Database Statistics and Re-indexing.

Involved in Migration to newer version of SQL server 2008 R2 and support on daily basis.

Configured Linked Servers and dealt with all related issues.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies for various categories of user support.

Management of MS SQL 2008 and 2005 servers on Production, Pilot and Development Environments.

Responsible for design, setup, installation, and implementation of DB’s, data maintenance (re-indexing, integrity checks, statistics update, log file monitoring), Performance tuning (fragmentation, compression drive distribution, load balancing, replication), technical documentation and implementation of SQL Server disaster recovery models.

Expertise in monitoring and setting up high availability environment like active\\active and active\\passive clustering.

Creating and monitoring all maintenance jobs (backups, integrity, optimization, etc.) on all databases.

Conducting the root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, or network latency.

Checking database health by using DBCC Commands and created maintenance plan.

Reconfigure the default locations of the data files, log files and error log files onto the SAN environment for all the servers.

Advanced SQL Server Maintenance through custom SQL scripts (Index Management and maintenance, Statistics Update, Consistency checks, History Cleanup).

Optimized database performance by monitoring activity using tools like SQL Profiler, Perfmon

Implemented table partitioning on tables in excess of 300 GB increasing load performance by more than 800 percent and report performance by more than 60 percent..

Environment: SQL server 2008/2005, SSIS/SSRS, Microsoft Visual Studio 2008, Remedy, Win 2003, Microsoft Visual Source Safe, MS Office Communicator, Change Control Manager.

Hardware/ Software Tool: SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.

Confidential,NJ May 2009 – December 2010
SQL Server Database Administrator

Confidential,is an international insurance company, serving customers in more than 130 countries. Chartis offers insurance products and services to businesses and individuals worldwide. AIG companies are providers of life insurance and retirement services in the United States. AIG’s segments include Chartis, Sun America Financial Group (Sun America), Aircraft Leasing and Other Operations.

Responsibilities:

Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.

Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.

Actively monitored performances of queries on SQL server using SQL Profiler and optimized it by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation language.

Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.

Performed DBCC checks which will helps to maintain physical consistency of the database.

Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node.

Expertise in data/table partitioning, online indexing, rebuild/reorg indexes and update statistics at regular intervals for better performance. On a weekly basis these indexes are rebuilding and reorganized.

Reduced systems downtime risk through automatic offsite backup and recovery over network.

Eased administrative work through automatic script performing daily/weekly backups.

Assessment of database security, and perform necessary action to protect database such as Security patching, Remove unnecessary privilege, and get the customer to sign Risk Acceptance Form.

Involved in improving the server performance using Performance monitor using I/O, memory and CPU counters.

Performed software installation and upgrade, capacity planning.

Developed SSIS packages and deployed into Dev, Test and Production Environments.

Developed SSIS packages to extract and transform data and Involved in Scheduling SSIS Packages.

Performed huge data transfers between various servers using BCP and Environment Migrations, Backing up and Archiving Data for various business requests.

Actively Involved in SQL Replication in sharing the access load between several databases servers having identical databases.

Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules as well as Monitored Connections, locks and Performance of SQL server.

Environment: SQL server 2008/2005, Microsoft Visual Studio 2008, Win 2003, Microsoft Visual Source Safe, Office communicator, Change Control Manager.

Hardware/ Software Tools: BMC Remedy ticketing tool, SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, Lite Speed.

Confidential,Addison, TX November 2007 – April 2009
MS SQL Server DBA

Confidential,Mortgage segment produces mortgage loans through a variety of channels on a national scale. Nearly all of the mortgage loans the company produces in this segment are sold into the secondary market, primarily in the form of mortgage-backed securities. Bank of America Home Loans is a marketing brand engaged primarily in residential mortgage banking and related businesses. Mortgage Banking, which originates purchases, securitizes, and services mortgages.

Responsibilities:

Managed and Administrated SQL Server 2008/2005 production and non-production servers.
Migrated servers from SQL SERVER 2005 to 2008 both in place and side by side.
Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
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, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
Daily routine DBA tasks like handling user’s permissions and handling maintenance jobs.
Checked Database Health and consistency by using DBCC commands and DMVS.
Extensively worked on trouble shooting dead locks and fine-tuning of databases for its performance using native SQL Server tools like profiler and performance monitor.
Managing the Lite speed backups, restore the databases transaction log on Production/Development servers as per Business/IT needs using SQL safe.
Hands on experience in trouble shooting database issues.
Performed all basic Database activities like moving databases between servers, copy databases etc.
Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
Designed and developed SSIS packages for data migration.
Implemented the SQL Server 2008 new features like Policy Based Management, Data Compression, Backup Compression Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
Implementation of SQL server logins, roles and authentication modes as a part of security policies.
Configure the RAID levels for data files, log files and tempdb at server level.
Implement data availability solutions like online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
Successfully implemented the capacity planning for different servers.
Performed data partitioning for efficient management of database tables and indexes.
Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
Export or Import data from other data sources like flat files using Import/Export through SSIS.

Environment: SQL Server 2008/2005/2000, Windows 2003 server, MS Visio, Microsoft SQL Server Visual Studio 2005/2008.

Hardware/ Software Tools: Heat Ticketing Tool, SQL Profiler, Index Analyzer, SQL Server Management Studio, Lite Speed.

Confidential,Hyderabad, India August 2005 – September 2007
SQL DBA

Confidential,is a premier integrated financial services provider. Karvy covers the entire spectrum of financial services such as Stock broking, Depository Participants, Distribution of financial products like mutual funds, bonds, fixed deposit, Merchant Banking & Corporate Finance, Insurance Broking, Commodities Broking, Personal Finance Advisory Services, placement of equity, IPOs, among others. Karvy has a professional management team and ranks among the best in technology, operations and more importantly, in research of various industrial segments.

Responsibilities:
Monitor and maintain SQLServer2005 databases in Production, UAT and Development Environments. Design, propose and Implement database environmentto achieve agreed database availability commitment.

Implemented database standards and naming convention for the database objects.
Conversion the legacy systems data into MS SQL server using DTS packages.
Developing SQL scripts for maintaining administration tasks.
Tuned the SQL queries using SQL profiler. Involved in tuning the database.
Involved in developing stored procedures, triggers for the application.
Estimating of Table sizes and Record sizes. Maintaining proper licenses.
Maintain all the SQL documents include installation and data conversion Procedures documents.
Trouble shooting Problems by using SQL server profiler.
Solved critical production problems and performed point in time recovery plans.
Installing all software upgrades for SQL Server.
Identified and resolved the query performance using SQL Profiler and Index tuning wizard.
Used Data Transformation Services (DTS) to populate data from various data sources.
Research on upgrading the SQL Server from 2000 to 2005
Research on database issues (specifically performance issues).
Worked on Migration of SQL Server 2000 instances to SQL Server 2005.
Involved in Creating SSIS packages to integrate the data coming from various data sources.
Monitoring of database size, disk space in all (Production, Model & Development) the environments.
Configured Log Shipping to create a stand by server for production server.
Creating and monitoring all maintenance jobs (backups, integrity, optimization, etc.) on all databases.
Creating, modifying and monitoring replication on all databases.
Worked on upgrading DTS packages to SSIS packages.
Maintaining security permissions for the internal and external users of the respective databases and servers.
Worked on 24/7 shifts to monitor the servers and to assist the users.
Management of SQL Servers, databases, storage management for databases sizing from 100GB to 450GB.

Environment: MS SQL Server 2005, Windows Server 2003, , SQL Server Enterprise Manager, DTS, MS Access.

We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Detroit, MI

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship