We provide IT Staff Augmentation Services!

Sql Server Dba Resumi, Nj

OBJECTIVE

To obtain a challenging SQL SERVER DBA related position where I can utilize my skills and broad experience in database management, which also gives the inspiration to learn new technologies and apply those for the benefit of the company.

SUMMARY

  • Over Seven years of SQL Server Database Administration experience in teams of DBAs located in multiple countries to support accounts with hundreds of servers (including stand alone and clustered servers), and thousands of databases
  • Hands on Experience in installing, configuring, managing, monitoring, applying sql service pack, and troubleshooting SQL Server 2000 , SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012 on stand alone and clustered servers
  • Migration from SQL Server 2000 to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 including stand alone and clustered servers
  • Hands on Experience in SQL Server Security, Replication, Data Migration, Data Transformation Services, SSIS, Log Shipping, Database Mirroring, Backup and restore
  • Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse
  • Extensive experience with data modeling, logical and physical database design using Erwin
  • Hands on experience with SQL Server T-SQL in constructing triggers, tables, stored procedures , user defined functions, views, indexes, relational database models, and data integrity
  • Hands on experience SQL Performance tuning
  • Hands on experience and outstanding knowledge of SQL Server high availability solutions, including replication, log shipping and SQL Server clustering
  • Familiar with Veritas Backup, Red-gate Backup and compare, Idera tools, spotlight, BIXpress, Litespeed
  • Develop, implement, maintain and exercise disaster recovery processes
  • Strong experience in Window Cluster technology
  • Excellent communication, presentation and interpersonal skills
  • Strong troubleshooting and organizational skills
  • Detail oriented

AREAS OF EXPERTISE

Category

Technology

Database

SQL Server 2000/2005/2008/2008 R2/2012, SQL Server 6.5, SQL Server 7.0, PostgreSQL, MySQL, Access

T-SQL, SQL, PL/SQL, SQL PLUS

Performance Tuning

Capacity Planning

Installation, Upgrade, & Migration

ODBC, JDBC, OLE DB, DTS, SSIS

Operating Systems

Windows Enterprise 2012/2008/2003/2000 Advanced Server/2000 Server/Windows 2000 Professional/Windows XP Professional/NT 4.0 Server

UNIX (Sun Solaris), Red Hat Linux, mandrake Linux

UNIX Shell Scripting

Applications

Erwin 3.5/4.1

Crystal Report 8.5/9/10, Crystal Enterprise 10

UML, Rational Rose

Visual Studio 6.0/.NET

Client / Server

Language

C/C++, Java, .NET, C#, COM+, Visual C++, HTML, XML, ASP, JSP, JavaScript, VB, PHP,

Protocols

HTTP, TCP/IP, FTP

EXPERIENCE

Confidential

  • I was engaged for the supporting of the account from the first day the account were on board IBM. Including 1 month knowledge transfer, 1 month of DE DBA shadowing IBM DBA, plus 1 month of IBM DBA shadowing DE DBA. The supporting team include 8 DBAs ( 5 in India, 1 in Canada, 2 in US). We support around 300 SQL Server instances with around 3500 databases, which include the following environments: log shipping, snapshot/transactional/merge replication, mirroring with stand along server also clustered server. It includes SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012. I work there as a production SQL Server DBA. My duties included:
  • Build DE's first SQL Cluster server with SQL 2008 and SQL 2012 instances.
  • Preform Level II incident on call 24X7 support. Troubleshoot databases and custom application issues
  • Responsible to apply service pack and hot fix to all version of SQL Server.
  • Designing, implementing, maintaining, and generating daily report to monitor the backup job for all the SQL Server.
  • Hand on experience in Performance tuning using Dynamic Management Views (DMVs) and System Catalog Views, Profiler and Server Side Traces, Windows Performance Monitor, Built in performance reports in SSMS, Query Plans, Database Tuning Advisor.
  • Responsible to install SQL Server on the new build stand alone and clustered servers
  • Review and apply stored procedures, triggers and other TSQL code developed by developers.
  • Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases
  • Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check
  • Eased administrative work through automatic script performing daily/weekly backups
  • Responsible for database security of the testing and developmental application system databases
  • Managed the granting of access to testing, development application and system databases
  • Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks
  • Disaster recovery for critical database

Environment: SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012.

Confidential

Production SQL Server DBA

  • I work for IBM to support the Disney account within a team including more than 20 DBAs (more than half of them are in India). Our SQL DBA team support more than 300 servers (including stand alone and cluster servers), more than 6000 database for Disney (includes east coast and west coast), which include the following: environments: log shipping, snapshot replication, transactional replication, merge replication, mirroring with stand along server also clustered server. It includes SQL Server 6.5, SQL Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2. I work there as a production SQL Server DBA. My duties included:
  • Technical lead in the project of migrating SQL Server 2000 to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2
  • Designed and prepared pre-upgrade plan
  • Migrated DTS packages in SQL Server 2000 to SSIS of SQL Server 2005
  • Perform post-upgrade tasks including updating statistics, changing database compatibility level, reconfiguring log shipping, executing upgrade testing, verifying agent jobs and maintenance tasks, bringing system online and monitoring system activity
  • Responsible to apply newest service pack and hot fix to all the SQL Server of Disney account.
  • Designing, implementing, maintaining, and generating daily report to monitor the backup job for all the SQL Server of Disney account
  • Designing, implementing, maintaining, and documenting all the SQL Server database of Disney account
  • Hand on experience in Performance tuning using Dynamic Management Views (DMVs) and System Catalog Views, Profiler and Server Side Traces, Windows Performance Monitor, Built in performance reports in SSMS, Query Plans, Database Tuning Advisor
  • Responsible to install SQL Server on the new build stand alone and clustered servers
  • Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis
  • Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases
  • Created and administered multiple development, testing and production databases
  • Developed and created stored procedures, advanced queries, triggers, views, indices, and functions for databases
  • Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check
  • Responsible for creating standards and operating procedures to maintain all databases
  • Ensured developers coordinated their efforts in managing and maintaining different application databases
  • Troubleshoot databases and custom application issues
  • Eased administrative work through automatic script performing daily/weekly backups
  • Reduced systems downtime risk through automatic offsite backup and recovery over network
  • Responsible for database security of the testing and developmental application system databases
  • Managed the granting of access to testing, development application and system databases
  • Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks
  • Disaster recovery for critical database
  • 24X7 on-call support

Environment: SQL Server 6.5, SQL Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.

Confidential

Production SQL Server DBA

  • Daily DBA task: fixing failed job, monitoring, refreshing production from QA, granting user access, running scripts, moving database, performance turning,
  • Hand on experience on Disaster Recovery for high demand database (with transactional replication under cluster servers) in a tight timeframe.
  • 24X7 on-call support
  • Design and implement the statistics to generate a daily Backup Report for all severs.
  • SQL server installation and upgrade.
  • Developed stored procedures, advanced queries, trigger, views, indexes by using T-SQL
  • Maintained databases, configured permissions, and backup and recovery
  • Performed daily administration, monitoring, and documentation of SQL Servers
  • Responsible for tuning data, indexes, and queries
  • Provided assistance to development teams on tuning data, indexes and queries
  • Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring
  • Created alerts and notifications for system errors, insufficient resources, fatal database errors
  • Scheduled and monitored all maintenance activities including database consistency check, index defragment
  • Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code
  • Managed the integration of data and monitored exceptions of highlight data from customers
  • Monitored all databases status including CPU, memory, I/O, space Management, block, and dead lock
  • Provided technical support to internal developers and external clients

Confidential

Software Engineer

  • Embedded SQL and Transact SQL Programmer
  • Troubleshooting of existed systems (C/C++)
  • Tested and recommended adjustments for enhancement
  • The thirteen middle school information System (VB, Windows NT)
  • Tian He Information System (Unix Solaris, Oracle, C/C++)
  • Yunnan government information system (C/C++, SQL Server)

Hire Now