We provide IT Staff Augmentation Services!

Sql Dba Resume

SUMMARY

  • 12 years of experience in IT Services and Operations with expertise in SQL Database Administration in a global 24x7 OLTP environment.
  • Supported over 160 database servers of low to high complexity in Production, UAT, Test and Dev environments. Maintained 7 TB of database.
  • Experienced in Installation, Configuration, Maintenance and Administration of SQL Server 2008R 2/2008/2005/2000/7.0 in standalone and clustered environments. Configured more than 2GB RAM for 32 - bit and 64-bit systems using AWE switches.
  • Experienced in migration of SQL Server from version 2000 to 2005/2008/2008R2 .And documented the Upgrade process. Handful of Experience on SQL server new features like Microsoft SQL multi server administration, resource governor, performance data collector.
  • Experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures
  • Experience configuring and working Microsoft SQL server 2005, Microsoft SQL Server 2008 on VMware Environment. Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard. Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication (Snapshot and Transactional with updatable subscriptions), Log shipping, Clustering (Active-Active and Active Passive) and Database Mirroring.
  • Worked with Tivoli Data Protection (TDP) and TSM for backup of databases and scheduling the backups on the Microsoft SQL Server 2005/2008.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
  • Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.
  • Expertise on physical storage SAN configuration on different RAID levels.
  • Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions.
  • Hands on experience with administering large databases, managed databases of size above 3 terabytes, database design, normalization and database application development using varied development tools.
  • Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
  • Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
  • Experience in trouble shooting sql server jobs, and job monitoring tool.
  • Good at Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
  • Auditing of database for users transaction, login and database action and removing orphan users.
  • Expertise in using DBCC trace flags, handling blocking and dead lock situations.
  • Intensive experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV’s, Index Tuning Wizard and Windows Performance Monitor.
  • Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
  • Creation and maintenance of Databases, creating Roles and managing user permissions.
  • Experience in Troubleshooting and documenting root cause analysis.
  • Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.
  • Explicitly used third party tools like Litespeed, Fog light and Red gate, Tivoli Storage Manager (TSM).
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Checking the threshold values and baselines and monitoring in perfmon and SCOM.
  • Rebuilding indexes with different fill factors and updating statistics.
  • 24 X 7 Production Database on Call Support.
  • Experience in Database Security and Management
  • Experience in Security Patches & Hot fixes installation and management (schedule-coordinate-install)
  • Experienced in performing various SQL Server 2000 & 2005, 2008R2 High Availability activities like Installation, Configuring and Maintaining SQL Clustered Servers (Active/Active & Active/Passive), Network load balanced servers, working with transactional Replication, Log Shipping and Database Mirroring.
  • Created maintenance plans to perform Index De-Fragmentation, Re-Indexing and update the Index Statistics.
  • Data Transfer from and to SQL Server Databases using utilities / tools like SSIS, SSRS, DTS, BCP, BULK INSERT etc.
  • Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.
  • Good hands on experience on Resolving database performance issues and monitoring the growth of the database to ensure the smooth running of daily activities.
  • Worked extensively on monitoring the databases, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases in response to the Tivoli Alerting System.
  • Experience in strong SQL debugging skills, application level troubleshooting skills, experience with monitoring tools and techniques, good understanding of security practices.
  • Experience in successfully resolving SQL Server problems in conformance with in SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, backup/restore, database corruption, security etc
  • Experience in using tools like SQL Profiler and Performance counters for Monitoring, Fog light, Performance Analyzer and Tuning MS SQL Server Performance.
  • Experience in working with Windows Server 2000/2003/2008.
  • Experienced in creating/maintaining automation Scripts with SQL.
  • Hands on experience in trouble shooting deadlock issues, resolving performance issues, data archival on every three months, rebuilding indexes.
  • Self-motivated person with strong analytical, problem solving and communication skills. Capable of working under pressure and a good team player who can be flexible and work individually.
  • Experienced in ITIL process (Change Management, Release Management, Problem Management, and Incident Management) and IT Infrastructure, Networking, and RAID environment.
  • Experienced in query optimization, DMV’s, Maintenance Plans, Upgrades
  • Experienced in database designing, Normalization
  • Assisted and supported customers, developers,QA’s in database related issues
  • Experienced scheduling all the alerts in database server using
  • MOM,Tivoli,Maximo,Control-M,SQL default alerting system
  • Experienced in writing SQLqueries,stored procedures, functions, triggers
  • Upgrading to SQL Server 2008(Resources for SQL Upgrade with Consolidation /Virtualization experience

TECHNICAL SKILLS

Databases: MS SQL Server 2008R 2/2008/2005/2000/7.0 , Oracle, MYSQL

Languages: T-SQL, C, C++, C#, vb.net, JAVA, ASP.NET, Visual studio2005/2003

Technologies: VB.NET, .NET FRAMEWORK, ASP.NET, Microsoft Office Suite, Share Point.

Tools: Active X, IIS, MTS, Litespeed, Spotlight, Visual Studio 2003/2005, VSS, Visio 2003, Office Visio 2007, SharePoint Designer 2007, Erwin 4.0,SSIS,SSRS,SSAS,SCOM,Tivoli TSM

Operating System: Windows 2000, Windows NT, Windows Server 2003/2008/2008 R2, Windows 95/98/XP/Vista/7.

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA

Responsibilities:

  • Worked in Active passive cluster environment.
  • Implemented and maintained Database mirroring as a Disaster Recovery Solution.
  • SQL Server 2K8 R2, 2K8 & 2005 Database Administration.
  • To handle the migration of SQL Server 2000 to SQL Server 2008 & 2K8 R2.
  • Responsible to Monitor and troubleshooting Log Shipping.
  • Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
  • Used Data Partitioning, Snapshot Isolation.
  • Update statistics, database integrity check and Backup operations
  • Expertise in SQL server Reporting Services(SSRS)
  • Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.
  • Expertise in creating and supporting in OLAP Cubes
  • Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.
  • Daily tasks of Developer/DBA like space issues on Production and Semi-Production Servers and handling maintenance Jobs handling and user’s permissions.
  • Designed and implemented comprehensive Backup plan and disaster recovery.
  • Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
  • Performed Performance Tuning of the Stored Procedures.
  • Experience in trouble shooting database issues.
  • Monitoring SQL server performance using profiler to find the performance and deadlocks.
  • Experience in using ERWIN tool for designing the reporting databases.
  • Performance Monitoring using SQL Profiler and Windows System Monitor.
  • Backup & Restore Plans.
  • Creating and Maintaining Database Maintenance Plans.
  • Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM.
  • SQL Server installation, configurations, backup/restore& handled large databases Monitoring SQL Server agent jobs and troubleshooting the Trouble tickets
  • Space optimization & Working knowledge of SQL Server advanced technologies (e.g. Replication, Log Shipping )
  • Configuring perfmon, blocking analysis, Enabling of AWE and PAE, Maxdegree Parallelism.
  • Installation of SQLSERVER 2005, service packs, hot fixes, Security patches, Litespeed.
  • Practical experience in managing the internal and external MS SQL database security
  • Install SQL Server instance and database (including Service Pack), Upgrade SQL Server (Service Pack)

Environment: SQL Server 2012,2K8R2, 2K8 & 2005 with clustering, Replication & DBM

Confidential

SQL DBA

Responsibilities:

  • To provide day to day support to user queries and customer advice Due to the nature of the environment, there is often a necessity to carry out scheduled work outside of Working hours.
  • SQL Server Performance Monitoring and problem resolution
  • Excellent team working skills balanced with ability to work alone and a positive attitude .
  • Backing up System, User databases (Complete Backup, Differential Backup, Transaction log backup) and Scheduling
  • Restoring (Complete Backup file restore, Differential Backup file restore, Transaction logs backup files restore), Monitoring (Error Logs, Jobs)
  • Trouble shooting (Memory Bottlenecks (log), D-drive space issue, Blocking etc)
  • Worked on basic Administration, DTS packages, Database Security, Performance Tuning,
  • Worked on the KFS & PCI SOX Compliance MAPI areas
  • Managing Database vs. Data files (.Mdf, .Log files)
  • Hands on Experience in Enterprise, Standard Edition, Developer edition & Personal Edition
  • Creating Databases, Database Size estimation, File growth, log data files
  • System & User Databases Maintenance and Administration
  • Setting Database properties, SP Migration, Tables migration, Database Security
  • Available production support for 24*7 whenever required.
  • Worked on ITIL process Ticket handling, Change Management, Problem management, Incident management.
  • Support International customers to fulfill their MS SQL SERVER DB Maintenance and Administration needs
  • Expertise in SQL server Reporting Services(SSRS)
  • Worked on tickets sent by customers for migrating objects and data from test server to production server, restoring and backing up databases in production environment.

Environment: ASP, MS SQL Sever 2005, 2000 Windows NT/XP, VB, Query Analyzer, Enterprise Manager, MS Access and SSIS,Veritas net backup, Tivoli, Share Point .

Confidential

SQL Database Administrator

Responsibilities:

  • Installing, Configuring and Administering SQL server 2000, 7. Worked with SQL Server 2000 inplace and side by side upgrade from SQL server 7.
  • Strong experience in working on Very Large Databases (VLDB) over 80 GB for OLTP and 2TB for OLAP databases.
  • Configured more than 2 GB ram on 32 bit Environment.
  • Implemented Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
  • Implemented Database Mirroring and Transactional Replication as a part of DR plan.
  • Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
  • Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
  • Worked in Active passive cluster environment.
  • Performed data partitioning for efficient management of database tables and indexes.
  • Developed Backup strategies for Database Recovery.
  • Export or Import data from other data sources like flat files using Import/Export through DTS. Experience in applying Service Packs at database and OS Level.
  • Technical Analysis, Code Review, Implementation, 24 x 7 production support.
  • Experience in using ERWIN tool for Entity Relationship diagrams.
  • Did Performance Tuning of the Stored Procedures.
  • Performing Database maintenance activities like Backups, Restoring.
  • Creating DTS packages and Maintenance plans and jobs for automation of the repetitive task.
  • As a part of the DBA team providing 24/7 production support to the clients
  • Monitoring the Scheduled jobs
  • Monitoring the Disk spaces on all the servers
  • Implemented and maintaining Log shipping, Replication, Mirroring High-Availability options
  • Migration of SQL Server 7 to 2000and also side-by-side upgrade
  • Strictly adhering to SLA and ensuring all the metrics are met without a breach
  • Maintaining instance/database documentation and ensuring it is Up-to-date
  • Weekly status calls and also preparing Minutes of meeting
  • Good experience in resolving blocking/locking and dead lock Issues
  • Verifying Index Fragmentation and performing re-org and rebuild as per %
  • Perform SQL Installations and configuration - SQL Server 2000.
  • Worked on rolling out the latest security patches across all the SQL servers in the organization
  • Worked on capacity planning for existing production servers before consolidation and moving them to new data center
  • Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc
  • Performing code reviews and approving before deploying to production
  • Code deployments to production servers
  • Worked on setting up Log Shipping using Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.
  • Working with various vendors in implementing new projects
  • Worked on setting up backup jobs for OLAP databases
  • Expertise in SQL server Reporting Services(SSRS)

Hire Now