We provide IT Staff Augmentation Services!

Sql Dba Resume

Boston, MA

Summary

  • Over 6 years of Database Administration for very large and complex databases in SQL Server 2008 R2, 2008, 2005 and 2000.
  • Experienced in Installation, Configuration, Maintenance and Administration ofSQLServer 2008R2/2008/2005/2000/7.0 in standalone and clustered environments.
  • Hands on experience with administering large to very large databases with sizes up to 1.3 TB.
  • Expertise in T-SQL skills in creating tables, stored procedures, views, Indexes, triggers, user defined data types and functions.
  • Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
  • Migration from SQL server 2000 to 2005 and 2000/2005 to 2008/2008R2 by using In - place as well as side–by-side upgrade process with detailed documented upgrade process.
  • Intensive experience in monitoring, optimizing and tuningSQLServerdatabase performance.
  • Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication, Log shipping, Clustering (Active/Passive) and Database Mirroring.
  • Worked extensively on Clustering and server consolidation, Troubleshooting production issues and raising high availability.
  • Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
  • Experience in 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.
  • Handful of Experience on SQL server features like data compression, performance data collector and resource governor.
  • Experience in Migrating DTS packages into SSIS packages using upgrade advisor tool.
  • Expertise in performing data transformations between servers using BCP, DTS, SSIS and bulk insert.
  • Experience in configuring Database Mail, Operators and alerts on large scale systems.
  • Good at Data availability solutions like online index operation, database snapshot, and resource governor.
  • Experience in Rebuilding and Reorganizing indexes for better performance.
  • Experience in using DMV and dynamic management functions for finding out long running queries.
  • Working knowledge in Integration Services (SSIS), Reporting Services (SSRS) and Clustering.
TECHNICAL SKILLS

Databases:

MS SQL Server 2008, 2008R2, 2005, 2000

Programming:

Visual Basic 6, Visual Basic 5, C, C++ & SQL

DBA:

Database Administration of MS SQL Server 2008,2008R2, 2005, 2000

Operating System:

Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Tools:

Backup Utility, SQL LiteSpeed, Visio

Network Topologies:

TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

EDUCATION

Bachelor of Engineering from Visvesvaraya Technological University

Professional Experience

Confidential,Boston, MA Nov 2010 – To Date
Role: Senior SQL DBA
Projects: MAGIC Modernization / Correspondence System

Confidential,started MAGIC Modernization project to replace Mainframe ADABASdatabase with SQL Server 2008 R2.It mainly involves in designing relational database system, migrating data from various sources into SQL server and hence maintaining it. Correspondence System is used to process incoming and outgoing correspondence of GIC.

Responsibilities:

  • Installing, configuring SQL server 2008 R2 instances, components on Clustered (Active/Passive) and non-Clustered environments.
  • Involved in database design. This involved converting Non-Relational database to Relational database (i.e. converting from ADABAS to SQL).
  • Created Schemas for enabling role based access of SQL server objects.
  • Provided optimal database backup strategy layout for utilization of storage and performance acceptable to client.
  • Automated various SQL Server Jobs that involved collecting data from various agencies.
  • Creating and Reviewing Security features for all the servers.
  • Working on SQL server audit for DDL and DML changes performed on the database.
  • Configured various roles to limit access to database.
  • Planned, executed and documented database Migration from SQL Server 2005 to 2008R2.
  • Performed database mail configuration, partitioning, and shrinking, registering operator for email notifications.
  • Used import and export data wizard, Bulk Insert, Generate scripts from various sources to objects in database.
  • Implement Data Compression for high performance of SQL Server on various situations
  • Monitored jobs, backups, server stats, server ping, SQL server permissions and SQL Safe for backups using encryption
  • Implemented Database Mirroring with witness server as a High Availability option.
  • Automated high availability solution by coming up with custom-tailored plans for production servers (Enabling non SQL Server Replication Process).
  • Configuring Alerts, maintenance plans for backing up the database, Rebuild index/update statics for better performance of the databases.
  • Monitoring SQL server LOGS, Application logs (Event Viewer), Tuning SQL server databases using SQL Profiler, Performance monitor, database tuning advisor.
  • Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
  • Installed and Configured SSIS for data migration purposes.
  • Configuring, Managing, Creating, subscribing SQL server reporting services

Environment: ADABAS, SQL Server 2008R2, Oracle 10i, Subversion, Microsoft One Note, SSIS, SSRS, SQL Server Profiler, Visio 2007.

Confidential,Los Angeles, CA Jan 2009 – Oct2010
Title: SQL DBA
Project: Life Insurance Claims System

Confidential,is used to process Death, Accidental Death and Dismemberment claims of insured.

Responsibilities:

  • Involved in database administration, database development, database design and database Release Management.
  • Created documentation for steps undertaken while migrating SQL 2005 to SQL 2008.
  • Extensively used database upgrade advisor during migration process.
  • Planned and implemented high availability technique using database mirroring on user databases on SQL server 2008.
  • Monitored database mirroring by creating performance alerts and mirroring status alerts.
  • Implemented SQL server audit for Payments and Beneficiary tables so as to maintain confidentiality.
  • Created documentation which is a step by step guide to Implement/Troubleshoot Database Mirroring.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Rebuilding the indexes at regular intervals for better performance
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Monitored and modified Performance using execution plans and Index tuning.

Environment: Windows 2008 64-bit, SQL Server 2005/2008, Database Mirroring, T-SQL, Subversion, Profiler.

Confidential,Baton Rouge, LA Sep 2007 – Dec2008
Title: SQL DBA/Developer
Project: LAOMV (Louisiana Office of Motor Vehicles)

Confidential, is complete rebuild of motor vehicle registration, driver licensing laws with integration with external systems.

Responsibilities:

  • Installing SQL Server with minimum access privileges service account to improve security.
  • Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services.
  • Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005.
  • Perform SQL Server service pack and Windows Service pack upgrades.
  • Designed and implemented comprehensive Backup plan using SQL LiteSpeed.
  • Worked with customers on Application rollouts and server migrations.
  • Troubleshoot performance problems and fine-tuning of databases.
  • Expertise in designing databases and capacity planning.
  • Rebuilding the indexes at regular intervals for better performance.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
  • To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 0.5 GB to 1 TB to achieve maximum performance and uptime in production environment.
  • Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
  • Implemented and Scheduled Replication process for updating our parallel servers.
  • Designed and created databases, tables, views, store procedures and triggers.

Environment: SQL Server 2005 and SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, VSS.

Confidential,Bangalore, India Jun2006 –Aug2007
Title: Junior SQL DBA
Project: Confidential,

Confidential,is an online banking system to enable users to perform online account activities.

Responsibilities:

  • Installing, configuring, administering SQL server 2005.
  • Setup new SQL Server instances and databases.
  • Capacity planning of SQL Servers.
  • Planned and implemented high availability technique using database log shipping on user database on SQL server2005.
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
  • Running DBCC consistency checks, and fixing data corruption in application databases.
  • Designed new job process, new database maintenance plans, DTS programs.
  • Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
  • Data conversions and data loads from various databases and file structures.
  • Monitor failed and long running SQL Server jobs.
  • Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server 2005, Transact-SQL, Enterprise Manager, Query Analyzer.

Hire Now