We provide IT Staff Augmentation Services!

Sql Server Dba Resume

5.00/5 (Submit Your Rating)

MN

Summary

  • Over Eight years of IT experience with more than Five years in Database Administration, Architecture, System Analysis, Design, Development and Support of MS SQL Server 2008, 2005, 2000, 7.0.
  • Proficient in Database Backup/Restore, Installing, Configuring, Monitoring, Maintenance, Migration, Disaster Recovery Plan, Cluster Administration, Configuring Replication (Snapshot, Transactional, and Merge), Log Shipping, Mirroring, Linked Servers, Data Archiving, Table Partitioning, and Mining.
  • Experience in installing and configuring SQL Server 2005/2000 Clusters in Active/Active or Active/Passive.
  • Experience in Code Review, Mentoring Developers, Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
  • Expert in Scheduling SQL Agent Jobs, Alerts, Operators, Configuring Database Mail, Automating the DBA tasks, Good at analyzing System Catalog info, Writing Administrative Processes, Profiler Tracing, Performance Monitor, and Monitoring activities.
  • Extensive experience in writing complex and large stored procedures, also User Defined Functions, Triggers, and Views.
  • Experience in developing build process, Database Maintenance, Deploying database releases.
  • Worked in Multi Server environment with Stand alone, Clusters (Active/Passive and Active/Active) and 64 bit OS, 32 GB Ram, 7000 + Servers and Servers with High volume of data.
  • Attended CCB (change control Board) meetings on regular basis to get approve the Production change requests.
  • Proficient in setting up Database security, Active Directory users and Groups.
  • Proficient in DTS, SSIS, SSRS, Tuning advisor, Export/Import utility, Command Line Utilities( BCP, OSQL, ISQL, SQLCMD), and Configuration tools.
  • Expert in Deploying SSIS packages and SSRS reports from TFS server to Production SQL Servers using Visual Studio.
  • Extensively used tools like Red Gate, LiteSpeed, SQLSAFE, PVCS, VSS, NETIQ (Active Directory), Toad (DB Administration), and Foglight (Performance Analysis).
  • Successfully upgraded near to 600 Databases from 2000 to 2005 including many number of DTS packages to SSIS.
  • Created complex SSIS Packages in SQL SERVER 2005 for Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
  • Experience in mentoring developers, Code review, giving training to Junior DBAs and documenting T-SQL Coding Standards.
  • Good interpersonal, Analytical and Communication skills.
  • Proven ability to deliver productivity and quality improvements through well-managed, on-time Projects and can work independently as well as team member.
  • Assisted Application Developers on SQL Servers issues and provided 24/7 on call support.

Education:

  • Bachelor of Engineering in Information Technology

Certifications:

  • Microsoft Certified Database Administrator (SQL Server 2000).
  • Designing, Optimizing and Maintaining a Database Administrative Solution.

Technical Skills:

Languages: C, C++, C#, T-SQL, PL/SQL XML, HTML Script, VB script
RDBMS: MS SQL Server 2008, 2005, 2000, 7.0, Oracle, MS-Access
Version Control Tools: Rational Clear Case, Visual Source Safe, PVCS
Operating Systems: Windows2003/2000 Server, Windows NT
Other Tools: Compaq Insight Manager, Idera Diagnostics Manager,
Net Q, Quest Lite Speed, Toad, SQL Safe, Red Gate, Erwin 4.0, PVCS, SSRS, SSIS, Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential,October’2008 – Till Date
MN

Role: Sr. SQL Server DBA

Confidential,is a federation of 39 separate health insurance organizations and companies in theUnited States. Combined, they directly or indirectly provide health insurance to over 100 million Americans.

Responsibilities:

  • Involved in code review of Stored Procedures, Triggers, and User Defined Functions and giving recommendations to developer for improving the performance.
  • Created stored procedures and user defined functions for database administration purpose.
  • Responsibility to handle SQL 2005, 2000 backup/Restore using third party tool Light Speed.
  • Involved in Performance Repository Project, where we collect data and generate report to Proactively Monitor the Servers and try to avoid any kind of Server and database related issues.
  • Performed Production On-call support ( 24/7 rotation), trouble shooting issues, Researched and resolved Problem management tool tickets, many performance issues like tempdb contention, Poor performing Stored Procedures, Monitoring, Deadlocking, and space issues.
  • Creating Maintenance plan for consistency checks, Rebuilding Indexes and Update statistics, performing fine Tuning of Database Application. Cleansing and solving Database troubles.
  • Involved in Microsoft native encryption implementation using Symmetric keys for Quest Lite Speed Backups for Credit Databases.
  • Monitoring of database size and disk space in Production and Staging environments.
  • Experience in setting up Database Mirroring with and without witness Server in SQL server 2005 (Manual / Automatic fail-Over).
  • Successfully Implemented Multi–Server Administration in SQL Server 2005 and developed scripts for database Administration.
  • Actively involved in CCB (Change control Board) meeting and applied hot fixes for the issues.

Technical Environment:
SQL Server 2008, 2005, 2000 Windows 2003 Server, .Net, Log Shipping, Mirroring, Replication, Clustering, Microsoft Visual Studio, Lite Speed, and Erwin.

Confidential,May’2007 –September’2008
Moline, IL
Role: Sr. SQL Server DBA

Confidential,consists of three major business segments (agriculture and turf, construction and forestry, and credit).

Responsibilities:

  • Built the SQL Server 2005 Servers on 64 bit Windows 2003 Servers and standalone HP servers in enterprise Data Centers.
  • Database space management, Monitoring Performance tuning and also Scheduled SQL Agent jobs, Alerts and Operators.
  • Performed Data upgradation from SQL Server 2000 to 2005.
  • Mentored developers in Developing T-SQL code like Stored Procedures, UDF, Triggers, and Views. I also involved in Database designing, Normalization, Data models, E-R diagrams using Erwin tool.
  • Involved in data extraction, transformation and loading (ETL). Used SSIS Packages to load data into database.
  • Performed Production support and did 24/7 on Call rotation, trouble shooting, researching, and resolving remedy tickets and provided permanent solutions for production issues.
  • Involved in stored procedure tuning and query optimization. Monitoring the performance monitor for production server issues.
  • Used DBCC commands to check the database consistencies.
  • Configured SQL server database Mail on Production servers.
  • Implemented and maintained Transactional Replication.
  • Assisted the application development team to perform T-SQL code review and send recommendations to improve the performance.
  • Administered Active/Active and Active/Passive Clustered servers, linking heterogeneous database servers in SQL Server 2000/2005.
  • Installed SQL Lite speed, configured and maintained for SQL Server backup and restore operations.

Technical Environment:
MS SQL 2005/2000, Windows 2003 Server, T-SQL, Replication,Query Analyzer, Query Editor, Ms-Visio, Lite Speed, Visual Studio, .NET, C#.

Confidential,February’2006 –April’2007
Minneapolis, MN
Role: Sr. SQL Server DBA

Confidential,is the General merchandise Retailer, Includes careers, news releases, Investors, community, Diversity etc.

Responsibilities:

  • I have involved in all aspects of the SQL Server infrastructure and operations, including the plan, design, engineering, implementation, up gradation,and administration of Databases.
  • I have been doing on-call for different pager rotations 24\\7(SQL Team), 9/5(DSS), 15/7 (Night and Weekend), 12\\7(Current) for around two years on 7000 + Target Corporation SQL Servers including POS, ISP, APS, RFID and Head Quarter Servers which have Replication and Log shipping. We provide RCA for Gold and G2 tickets in Remedy (Problem Management Tool).
  • Creating ISP packages with DDL statements by generating from Erwin model once change requests have been approved by IA and DBA team, and maintaining its version in PVCS Version control tool and implementing them remotely on multiple ISP SQL Servers.
  • Expert in rebuilding Stand alone SQL Servers as well as Cluster Servers when they are crashed due to Hard Disk failure.Involved in Disk up gradation, migration, expanding data and log file space.SQL Server jobs set up on SQL Agent as well as Control-M Agent, DB backup set up to Legato Server which keeps 1Month’s Backups.
  • Providing security on SQL Servers according to SOX Standard, created automated DBA Scripts (Sps and UDFs) for saving DBA time and fixing production problems permanently on high volume of Data (2 GB – 2.5 TB), Expert in using DBA monitoring Utilities developed by DBA team when we are doing on-call, analyzing and problem solving.
  • Internal Project support and maintain its status in Infra quest work request tool. Troubleshooting of repeating problems and providing technical assistance to IT and Business Unit customers including analyze, test and implementations.
  • SQL Server jobs set up on SQL Agent as well as Control-M Agent, DB backup set up to Legato Server.MaintainingReplication,Log shippingon POS store servers, and DB Backup/Restore on SQL Servers.
  • Creating Stored Procedures, User Defined Functions, Views and Triggers. Code review and Performance tuning, resolving connectivity issues, Data Integrity and monitoring.
  • Involved in designing Databases with IA group and building the schema all over the Target Corporation SQL Server databases.
  • Performance tuning, fixing the production problems, Installing SQL Server for Head Quarter Servers by using automated build process, Clustering and CMN implementations on all HQ Production Servers.
  • Involved in SQL server 2005 up gradation, implementing new features in DBA Scripts, SQL Server Consolidation on Poly Serve cluster utility, working on Infra Quest WorkRequests (IWRs) and DBA tasks. Appropriate Documentation on DBA automated tasks, and weekly seminars on technical topics.


Environment:SQL Server 7.0/2000/2005, Windows NT 4.0/2000/2003,
Erwin (4.1.4.4045), Poly Serve Cluster Utility, C#, VB.net, ASP.net, Java, VBScript, Windows Script and XML.

Confidential, July’2004–December’2005
Irving, TX
Role: SQL Server DBA

Confidential,is an American broadband and telecommunications company. This is a consumer e-ordering project at Verizon, where customer places an order for wireless as well as internet connection. These orders are from customers all over the country.

Responsibilities:

  • Involved in consumer e-ordering redesigning project by analyzing requirements, Gap Analysis, Data Modeling, Constructing Entity-Relationship, Logical and Physical data modeling.
  • Creating and modifying the Tables and Stored Procedures related to consumer group.
  • Resolving flow through IRs (Incident Report) by investigating and fixing the issues which were opened by application manager.
  • Investigating and finding the bugs in T-SQL code related to Production IRs and making kits by putting all Bootstraps and modified stored procedures.
  • Updating, Inserting and Deleting the Data in Database table to fix the Production IRs.
  • Loading the missing data in database tables to resolve the Flow trough and Production IRs with T-SQL scripts.
  • Putting IR database changes in System Integration Test environment to be certified by the application developer.
  • Building the Kits to drop into the System Test environment to test and certify.
  • Maintaining the Jobs, replication process and loading the Data from Central Source to OrderPlacement Database.
  • Created stored procedures, Triggers, User defined Functions, T-SQL scripts and Views.
  • Connecting SQL servers remotely using Terminal services.

Technical Environment:
SQL Server 2000 and 2005, Windows 2000 Server, .Net, Microsoft Visual Studio, T-SQL, SQL Profiler.

Confidential, January’03-May’04
Sanfransisco, CA
Role: SQL Server Developer DBA

Confidential,is the largest independently owned insurance brokerage consultant across 30 states in the U.S. The project is all about integrating data into a centralized database with dynamic design and user friendly web application, to keep track of Direct Bill Payments and Commissions from various Clients across the nation. Process involves data entry and verification of Payments, Commissions, Journal Entry, Unpaid Policies verifications.
Responsibilities:

  • Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
  • Wrote complex stored procedures, Functions, Views, and Triggers.
  • Experience in Understanding structured data analysis, data models, data normalization.
  • Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible.
  • Solid experience and knowledge with SQL 2000 backup and recovery procedures.
  • Creating and Maintaining the Users, roles, groups and granting the privileges to users and Groups and maintaining security up to date.
  • Experience in analysis and troubleshooting skills to be able to analyze the data or resolve complex errors.
  • Given proposal for servers and hardware RAID configuration solutions for Enterprise Solutions.

Technical Environment:
SQL Server 2000/7.0, .NET Framework, Visual Studio, HTML, Reporting services, XML, Windows 2000/2003.

Confidential,November’01-November’03
Chennai, India
Role: SQL Server Developer

Confidential,is a technology-driven engineering and construction organization, and one of the largest companies in India\'s private sector. It has additional interests in manufacturing, services and Information Technology. L&T has an international presence, with a global spread of offices.

Responsibilities:

  • Managing of database objects like Tables, views, indexes etc.
  • Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
  • Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
  • Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
  • Transformed data from various data sources using OLE DB connection by creating DTS packages.
  • Used BCP utility to publish table output to text files.
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
  • Documented daily tasks & operations.

Technical Environment:
SQL Server 7.0/ 2000, Enterprise Manager, Query Analyzer, Windows 2000 Server, DTS, T-SQL, BCP.

We'd love your feedback!