We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Deerfield, IL

PROFESSIONAL SUMMARY

Highly skilled software professional with 7 + years of experience in MS SQL Server 2008 R2 /2005 database development and administration in enterprise production environment.

  • Proficient in server installation, configuration, maintenance, upgrade, backup and restore, recovery, migration, performance tuning, monitoring and troubleshooting.
  • Extensive practical exposure to database administration, Cloning, Performance Optimization, Security management, Capacity planning and documentation.
  • Expertise in mentoring and setting up High Availability environments like active-active and active-passive clustering, Database Mirroring, Replications, Log shipping, setting up servers from scratch on clustered environment, linked servers.
  • Implemented Recovery and Backup Strategies, Database Mirroring and snapshots for Disaster Recovery and reporting purposes.
  • Expertise in developing stored procedures, triggers, user defined functions using T-SQL.
  • Experience in implementing Database Mirroring, Log shipping and clustering as the Disaster Recovery and High availability solution.
  • Expertise in planning and implementing Snapshot and Transactional Replications of MS SQL Server Databases.
  • Experience in regular maintenance activities like Query Tuning, statistics update, Index rebuild, log file monitoring, temp DB monitoring, deadlock resolutions, and fragmentation issues.
  • Experience in analysis, development and deploying of windows applications and web services in Microsoft Visual Studio .Net IDE using ASP.NET, ADO.NET and SQL Server.
  • Experience working with production and 24 x 7 on call environments.
  • Flexible, Enthusiastic and project oriented team player with excellent analytical skills to develop creative solutions for challenging client needs.

TECHNICAL PROFICIENCY

  • Operating Systems: Win 2008/2003, Win 7/XP, Win NT 4.0, Win server 2003/2008/ 2008 R2, Linux, UNIX.
  • Databases: MS SQL Server 2008/2005/2000/7.0, MYSQL, Oracle 11g, MS Access 2002/2003/2007.
  • ETL TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)
  • Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.
  • Languages: T-SQL, C#, Java, Java script, PHP, XML, HTML, ASP.NET
  • Development Tools: Microsoft Visual Studio, Web Matrix, Adobe Dreamweaver

EDUCATIONAL BACKGROUND

  • Bachelor of Technology in Electronics and Communication Engineering

WORK EXPERIENCE

Confidential- Deerfield, IL Mar 2011 - June 2012 Role: SQL Server DBA

Lundbeck is a Danish international pharmaceutical company engaged in the research and development, production, marketing, and sales.

Responsibilities:

  • To ensure all scheduled administrative jobs are running / completed for Microsoft SQL Servers.
  • Responsible for database backups, restore and Disaster Recovery.
  • To prepare Servers/Databases metrics and implement new technical features in current environment.
  • Responsible for setting up Clusters, Log shipping and Replication.
  • Implementing Performance Tuning, Analysis, tuning and optimization of SQL Server Applications using performance monitor. Assisting SQL Developers in query tuning and optimization.
  • Running Index tuning wizard and rebuilding indexes (Clustered / Non Clustered) for faster query response.
  • To troubleshoot, analyze and fix issues related to Performance Tuning of various processes during daily ETL Cycle. Optimizing various objects like Stored Procedures, triggers, views and implementing performance improvement issues using Query Analyzer, Profiler and Index Tuning Wizard.
  • Setting up High Availability environments like active-active and active-passive clustering, Database Mirroring, Replications, Log shipping, setting up servers from scratch on clustered environment, linked servers.
  • Worked on 45 instance of SQL server with around 415 databases of SQL.
  • Responsible for monitoring Jobs, SQL auditing, Disk spaces, error logs and making recommendations for performance improvement in hosted databases which involved file group modifications, and scheduling jobs to rebuild/reorg indexes, update statistics and security.
  • Interaction with client and onsite team members.

Environment: SQL Server 2005/2008, Windows 2003/2008 Server, T-SQL, ASP.NET

Confidential- Miami, FL Jun 2010 - Mar 2011 Role: SQL Server DBA

Ryder is one of America’s largest providers of transportation and supply chain management products. Headquartered in Miami, Ryder has satellite locations in 50 US States and also in Mexico, Canada, Singapore, China and the United Kingdom.

Responsibilities:

  • Complete daily administration of prod/test/development servers, including backup recovery.
  • Performance Fine tuning of database, carrying out major database changes and object changes.
  • Creating logins, users and maintaining server security.
  • Handled up to 1.5 TB Size databases with Clustered and Log shipping environment.
  • Maintaining the database consistency with DBCC at regular intervals.
  • Using log shipping for synchronization of database.
  • Checking database integrity, creating new databases, tables.
  • Migration project of all databases from SQL 2005 to SQL 2008.
  • Configuring setup for high availability and implementing optimum disaster recovery strategies.
  • Wrote dynamic stored procedures to create Database Roles and grant permission to roles and adding logins to specified roles.

Environment: SQL Server 2005/2008, Windows 2003/2008 Server, T-SQL, ASP.NET Confidential - Miami, FL Aug 2009 - Jun 2010 Role: Database Administrator

Comcast is the nation's largest provider of broadband Cable, high-speed internet and broadband phone services. As part of the database management services team, we maintain all databases owned by Comcast.

Responsibilities:

  • Administrated the SQL Server 2008/2005 servers and production, pre-production, non-production databases, Application support and Performance Analysis/tuning.
  • Performed all aspects of database administration including installs, builds, upgrades, backup and recovery, patching, monitoring and cloning.
  • Installation of SQL Server 2008/05 and on Windows Server Clustered environment.
  • Planning, managing, assigning and scheduling database tasks to the team members.
  • Migrated/Consolidated from Two Data centers into one Data center.
  • Data transferred using BCP/Bulk insert from Excel, Flat files to SQL Server vice-versa with different formats.
  • Extensively worked on snapshot and merge replication disaster recovery environments.
  • To ensure all scheduled administrative jobs are running / completed for Microsoft SQL Servers.
  • Setup, configured and monitored Log Shipping and Database Mirroring for 2000 and 2005 Production servers for disaster recovery across multiple domains and SQL server 2005 security Audit.
  • Involved in configuring table/data partitioning on huge tables for better performance.

Environment: SQL Server 2008/05/00, Oracle 9i/10g, Linux AS, Advanced Windows 2008/03 Server, T-SQL, PL/SQL, C#.Net, ASP.Net, MS Visio.

Confidential - New Jersey, NJ Nov 2007 - Jul 2009 Role: SQLDBA/DEVELOPER

Patient Management Programs: Member eligibility & Participation Check Patient Management program, where the member is identified with member ID and the member eligibility, participation, provider details are verified.

Responsibilities:

  • Implementation of SQL Server - Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Writing Stored User Defined Data Types, Procedures, Triggers and Functions, Rebuilding the indexes at regular intervals for better performance.
  • Designed and implemented comprehensive Backup plan and Disaster Recovery strategies.
  • Implemented and Scheduled Replication process for updating our parallel servers.
  • BCP, Bulk Copy, Select into are used to move data.
  • Monitoring/troubleshooting the existing DTS packages.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Recovering the databases from backup in disasters.
  • Using log shipping for synchronization of database.
  • Monitoring SQL server performance using profiler to find performance and dead locks.

Environment: TSQL, MS SQL Server 2000, Enterprise Manager, VB.NET, Windows Server 2003, IIS

Confidential- Bangalore, India Apr 2005 - July 2007 Role: SQL SERVER Developer Airtel is one of Asia’s leading integrated telecom services providers with operations in 19 countries across Asia and Africa. Responsibilities:

  • Installed and configured MS SQL Server and Clients.
  • Created and managed schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained Referential Integrity
  • Performed Data migration (import & export BCP) from Text to SQL Server. Data transfer using BCP and DTS
  • Managed Disk space, memory and User connections
  • Established DR sites using log-shipping and Wrote dynamic stored procedures for moving Databases from production server to DR server
  • Performed query tuning and reduced response time by 60%
  • Performed query plans and enforced indexing in each and every query
  • Designed DTS packages to refresh data on Development and QA/Staging
  • Designed new schema for data partition and creating Partition views for better performance.
  • Programmed in T-SQL to implement Stored Procedures and Functions for different tasks

Environment: MS SQL server 2000, Windows 2000, VB .Net, Enterprise manager, Query Analyzer, SQL profiler

Hire Now