We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Philadelphia, PA

Summary:

  • Over Eight years of experience in Database Administration and support of SQL Server in Production/QA/Development environments.
  • Expertise in installation, configuration, monitoring, maintenance and troubleshooting of SQL Server 2000/2005/2008.
  • Involved in the migration of SQL Server 2005 databases to SQL Server 2008 databases.
  • Proficient in server capacity planning in clustered and non-clustered SAN environment and experience with logical and physical database designing.
  • Planning and implementation of high availability and disaster recovery for SQL Server databases, including Windows 2000/ 2003 clustering, log shipping, replication (Snapshot, merge, transactional), database mirroring and database snapshot.
  • Strong knowledge in implementing backup strategy using Complete, Differential, Transactional, files and file-group backups depending on database recovery model.
  • Proficient in running database consistency checks using DBCC utilities, updating index statistics, monitoring database and disk space.
  • Tracing and monitoring databases activities and performance using SQL Profiler and windows Perf Mon tool.
  • Experience in migration and maintenance of data using various utilities like SSIS, DTS, Import and Export, ATTACH/DETACH Data Migration tools.
  • Experience in SQL Server 2005 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
  • Proficient with Management Studio, Enterprise Manager, SQL Query Analyzer, scheduling regular and on-demand jobs with SQL Server Agent.
  • Experience in planning and implementing Microsoft SQL Server security which Includes database permissions, roles, securable and principles.
  • Good knowledge of DBA third party tools like SQL Navigator, Toad, Litespeed.
  • Good knowledge of DB2 UDB LUW 8x/9x.
  • Implementing SQL server best practices and improvising server and instance consolidation, understanding of RAID-1, RAID-5, and RAID-10 implementation for OLTP environments.
  • 24 X 7 production database on call support.
  • Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill.

TECHNICAL SKILLS:

Operating Systems:

Windows 2008 Server, Windows 2000 Server, Windows 2000 Advanced server, Windows 2003 Server, SP3 ,Windows NT 4.0, Windows XP, UNIX (AIX 4.x,5.x,Linux, Sun Solaris2.6/2.8

Languages:

C++, T-SQL, html, XML, Shell scripting, Perl scripting

RDBMS:

SQL Server 2008R2/2008/2005 /2000 /7.0, MS Access, DB2 UDB 8x, 9x

Application:

Crystal Report, Erwin, Visual Studio, SSRS, SSIS, Litespeed, Spotlight, Disk keeper, Tracer, Bugzilla.

Database Query Tools:

MS SQL Server Query Analyzer, SQL Profiler, Perf-Mon.

PROFESSIONAL EXPERIENCE

Confidential, Dec`10-till date
Philadelphia, PA
SQL SERVER DBA

Responsibilities:

  • Installed, maintained and administered SQL Server 2008R2/2008 and 2005 servers.
  • Installation of SQL 2008 servers including SSIS, SSRS and SSAS.
  • Involved in migration of SQL Server 2005 databases to SQL Server 2008 and applied service packs.
  • Involved in migration of SQL databases to a new server.
  • Administered SQL security by adding and removing login ID`s and monitoring the user accounts, creation of groups, granting the privileges to users and groups.
  • Managed permissions and security by using role based security model for SQL Server reporting services.
  • Designed and implemented strategies for recovery model, Backups including file groups.
  • Implemented read only file groups, file group backup and peace meal recovery strategy when read-only file groups do not necessarily need to be recovered.
  • Build and Schedule SSIS packages for periodic data refresh.
  • Implemented data partitioning for new SQL server 2005 to achieve better performance for access and writes.
  • Created and scheduled maintenance plans for database and log backups, update statistics and database integrity checks.
  • Regularly monitor replication processes and jobs to ensure they are working.
  • Designed, implemented and maintained Replication, Log shipping and database mirroring for servers.
  • Tuned the Production server to get performance improvement by using SQL Profiler, SQL Commands and Database Tuning Advisor and Performance Monitor.
  • Monitor the system bottlenecks –CPU, RAM, and DISK I/O using performance monitor counters.
  • Setup alerts for database space, backup status and server health check.
  • Configured Server for sending automatic mails to the respective people when a SQL Job is failed, log files are grown beyond the predefined limit, or free space of the hard disks fall below the threshold limit.
  • Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
  • Provided 24x7 support for production environments.

Environment: MS SQL Server 2008/ 2005/2000, Win 2003/2008, IIS, FTP, DTS, SSIS, and MS SQL Reporting Services.

Confidential, New York, NY Oct`07-Dec`10
SQL Server DBA

Responsibilities:

  • Managed and administrated SQL Server 2008/2005 and 2000 servers.
  • Involved in migration of SQL Server 2005 databases to SQL Server 2008 and applied patches.
  • Involved in Architectural design for the databases and database tables and capacity planning.
  • Implemented SQL logins, roles and Authentication Modes as a part of security policies for various categories of users.
  • Build and Schedule SSIS packages for periodic data refresh.
  • Scheduling database backups, restoring databases and maintained data accuracy and consistency.
  • Implemented and administered SQL Server snapshot and transactional replication in OLTP databases.
  • Regularly monitor replication processes and jobs to ensure they are working.
  • Extensively worked on High Availability Solutions which include log shipping and database mirroring for 2000 and 2005 Production servers.
  • Implemented LiteSpeed for disk space savings and faster backup for very large databases.
  • Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
  • Tuned the Production server to get performance improvement by using SQL Profiler, SQL Commands and Database Tuning Advisor and Performance Monitor.
  • Running DBCC consistency checks, and fixing data corruption in application databases
  • Partitioned tables to achieve better performance for access and writes.
  • Rebuilding indexes at regular intervals for better performance.
  • Configured Server for sending automatic mails to the respective people when a SQL Job is failed, log files are grown beyond the predefined limit, or free space of the hard disks fall below the threshold limit.
  • Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
  • Provided 24x7 support for production environments.

Environment: MS SQL Server 2008/ 2005/2000, Win 2003/2008, IIS, FTP, DTS, SSIS, and MS SQL Reporting Services.

Confidential,Oct`06 – Sep`07
New York, NY
SQL Server DBA

Responsibilities:

  • Involved as an MS SQL Server 2005/2000 administrator and responsible for requirement analysis, design, document, development, enhancement and support of MS SQL Server databases.
  • Involved in migration of the Server SQL Server 2000 to 2005.
  • Implemented SQL logins, roles and authentication modes as a part of security policies for various categories of users.
  • Migrating DTS Packages to SSIS using Upgrade Advisor and DTS Designer.
  • Created and deployed SSIS packages for data cleansing and data migration.
  • Implemented data partitioning for new SQL server 2005 databases (Created partition function, partition scheme mapped to a partition function and created the table on the partition scheme).
  • Implementation of backup and recovery plans for all databases and maintain documentation. Schedule administrative tasks (like database integrity checks and maintenance plans).
  • Implemented and maintained snapshot and transactional replication.
  • Installed and configured 2-node cluster configuration (Active/Passive) in SQL Server 2005.
  • Successfully implemented Log Shipping to maintain a standby server backup for disaster recovery.
  • Monitor database status on CPU, memory, I/O, space, paging and dead-locks using performance monitor and SQL Server Profiler.
  • Experience in using Performance Monitor, SQL Profiler and Database Tuning Advisor to solve dead Locks / long running queries.
  • Configured mail profile for sending automatic mails to respective people when job is failed or succeeded.
  • Extensive exposure to creation of databases, objects, stored procedures, triggers, security, DTS (i.e. Import and Export), BCP, Transact-SQL, and SQL Server Agent and SQL Server profiler.
  • Worked on Client/Server tools like SQL Server Management Studio, Enterprise manager, Query Analyzer to administer SQL Server.
  • Created Database Maintenance Planner for the Performance of SQL Server, which covers database integrity checks, update database statistics and re-indexing.
  • Expertise in trouble shooting of client connections, viewing error log and applications.
  • Maintaining the database consistency with DBCC, DMF and DMV’s at regular intervals.
  • 24 X 7 production database on call support.

Environment: MS SQL SERVER 2000/2005, Windows 2000/2003, SSRS, SSIS and Erwin.

Confidential,Falls Church, VA
SQL Server DBA July`05 – Aug `06

Responsibilities:

  • Involved in upgrading the instance of development environment of SQL Server 2000 to SQL Server 2005.
  • Pre installation check before installing SQL Server 2005 that identified unsupported configurations.
  • Migration of databases from MS SQL server 2000 to MS SQL server 2005.
  • Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
  • Created database maintenance plans, managed database structures, disk spaces, DTS packages, scheduling database backups, restoring databases and maintained data accuracy and consistency.
  • Analyzed, fine-tuned and optimized MS SQL Server applications by using performance monitor, setting up traces using SQL Profiler.
  • Tuned SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
  • Implementation and administration of SQL Server snapshot and transactional replication.
  • Implemented SQL Server Log Shipping.
  • Solid experience with creating alerts, schema management, database reorganization, data loading.
  • Wrote and scheduled scripts using DBCC commands like re-index, checkdb/checktable, showcontig, showstatistics etc. for maintaining database and checking database/table consistency and system performance and scheduled them to run as job.
  • On daily basis reviewed performance monitoring and Windows and SQL Event Logs and System Logs.
  • Development of DTS Packages, stored procedures, views, triggers, index and SQL scripts.
  • Supported DB2 UDB development/production servers.

Environment: Windows 2000 Advanced Server/Server 2003 ,SQL Server 2000 & SQL Server 2005, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, Upgrade Advisor, DTS Designer Tools, Windows Performance Monitor.DB2 UDB .

Confidential,Chicago,IL
SQL Server DBA April`04 – June`05

Responsibilities:

  • Installed MS SQL Server 2000 and maintained 21 servers.
  • Creating and managing schema objects such as tables, views, indexes and referential integrity depending on user requirements and converting them into technical specifications.
  • Designed, tested DTS package required for data transfer from consolidated files to database tables.
  • Designed and implemented comprehensive backup plan and disaster recovery strategies.
  • Monitored and modified performance using execution plans and index tuning. Rebuilt the indexes at regular intervals for better performance
  • Involved in trouble shooting and fine-tuning of databases for its performance and high availability.
  • Monitored SQL server performance using SQL Profiler to find performance and dead-locks and blockings.
  • Recovered databases from backups in disasters.
  • Analyze long running slow queries & tune the same to optimize application and system performance.
  • Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
  • Implemented transactional replication to enhance the failover capabilities.
  • Successfully tested and implemented log shipping for disaster recovery.
  • Performed performance monitoring, reviewing Windows and SQL event logs and system logs.
  • Configured SQL Server settings using configuration manager.
  • Day to Day basis reviewing performance monitor and event logs on all SQL Servers

Environment: Windows 2000, MS SQL Server 2000/2005, SQL, T-SQL, SQL Query Analyzer, SQL Profiler.

Confidential,Long Island, NY July`03- March`04
Jr.SQL Server DBA

Responsibilities:

  • Installing and Configuring of SQL Server 2000 on windows 2000 OS.
  • Migrated SQL 7 databases to SQL 2000 databases as per requirement.
  • Created logins and maintained user permissions appropriately.
  • Managing of databases objects like tables, views, indexes, functions, procedures, etc.
  • Managing disk space, memory and user connections.
  • Implementing backups and restoring strategy and maintaining them.
  • Used BCP utility to publish table output to text files.
  • Developed DTS packages to transfer the data between SQL server database and files.
  • Implemented snapshot and transactional replication from SQL 7 to 2000 database.
  • Creation and management of database maintenance plan for various database consistency checks.
  • Used SQL profiler to monitor the server performance, debug T-SQL and slow running queries
  • Extensively used joins and sub queries to simplify complex queries involving multiple tables.
  • Developed scripts for maintaining administration tasks.

Environment: Windows 2000/NT4.0, MS-SQL Server 2000,SQL Scripting Visual Basic6.0, VB Script, Visual SourceSafe, Crystal Report

EDUCATION:

MS in Electrical Engineering

Hire Now