We provide IT Staff Augmentation Services!

Sql Server Dba Developer Resume

NJ

SUMMARY:

  • Around 3 years of strong professional experience in SQL Server 2008/2005/2000 as Database Administrator and Developer.
  • Highly experienced in installing, configuring and administering SQL Server 2008/2005/2000 .
  • Upgraded and migrated several servers and databases from SQL Server 2000 to SQL Server2008/2005.
  • Extensive knowledge in architecting, designing and administrating in multi node clustering with Active/Active, Active/Passive Architecture.
  • Experienced in Configuring, Implementing and Maintaining Database Mirroring.
  • Good Knowledge in implementing in different Replication Models (Snapshot, Merge and Transactional) with different topologies.
  • Highly experienced in Configuration, Implementation and Maintenance of Log Shipping.
  • Extensive experience with backup and Restore methodologies using Native and third party tools (LITE SPEED, NetBackup, and Red Gate).
  • Highly experienced with Business Intelligence in MS SQL Server 2005/2008 in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS).
  • Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning and Data Normalization.
  • Expertise in migrating servers using in place and side by side upgrade.
  • Experience in capacity planning, performance tuning, and disaster recovery and troubleshoot performance issues.
  • Extensive knowledge in design of logical and physical data modeling using Erwin data modeling tool.
  • Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.
  • Developed Dash Board Reports on COGNOS 8.4 report studio
  • Highly experienced in creating Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
  • Experienced in programming tasks - Stored Procedures, Triggers, and Cursors for SQL Server 2000/2005/2008 .

TECHNICAL SKILLS:

Databases: SQL SERVER 2000/2005/2008, Oracle 9i, MS-Access

Programming Languages: SQL, PL/SQL, VB 6.0, VB.Net, C, C++, C#

Web Technologies: Asp.Net, HTML, DHTML, XML, IIS 6.0, Java Script

Tools: SQL Server Management Studio / Enterprise Manager, SQL Navigator SSRS, SSAS, SSIS, SSMS, Toad, Visual Studio, Cognos 8.4, Excel Macro 2007/2003, Erwin

Utility Tools: MS Office, MS Project, ClearQuest, Visual Source Safe 6.0, Rational Clearcase

Operating Systems: Windows 95/98/2000/2003/2008/ XP/NT 4.0, Unix, Linux, MS-DOS

PROFESSIONAL EXPERIENCE:

SQL Server DBA Developer

Confidential, NJ

Responsibilities:

  • Worked extensively on installation, upgrade and configuration of MS SQL Server 2008/2005 and 32/64 bit SQL Server Cluster for SQL 2008 and SQL 2005.
  • Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.
  • Configured Merge and Transaction Replication from Production to DR Servers and Reporting Server with Multiple subscribers.
  • Supported production servers in Fail over cluster environment.
  • Implemented several new features of SQL Server 2008 including Resource Governor, native SQL Server encryption, Data Compression.
  • Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
  • Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
  • Designed and populated reporting tables, views and stored procedures.
  • Worked extensively on data maintenance like re-indexing, integrity checking, and database shrinking.
  • Verified 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.
  • Respond to trouble tickets assigned to me and fix any database issues promptly.
  • SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
  • Developed SSIS packages to export data from OLTP database to OLAP database.
  • Responsible for Physical Storage Structures and Index Design and Tuning.
  • Used SQL Profiler to find badly performing queries and deadlocks.
  • Created Dash board reports using COGNOS report studio.

Jr. SQL Server DBA Developer

Confidential

Responsibilities:

  • Installing, configuring and deploying SQL Server 2005 and 2008 in Clustered and non-clustered environment.
  • Migrated from SQL Server 2000/2005 to SQLServer 2005/2008.
  • Configured security and access per SOX and PCI standards.
  • Created Linked Servers for OLEDB Data Source and Native Sources.
  • Responsible for creating, maintaining and monitoring mirrored servers, configured using synchronous and asynchronous updates with witness server.
  • Created alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, alerts, activity logs, error logs to capture any possible errors.
  • Used 3rd party tools like Quest Lite Speed in taking the backups to optimize performance and restoring.
  • Analyzed business requirements and build logical and Physical data models that describe all the data and relationships between the data.
  • Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
  • Configured Database mirroring, multi-instance SQL Server clusters as part of high availability solutions for mission critical TJX database Servers.
  • Monitored backup jobs daily and run the jobs manually in case of failure depending upon the necessity. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
  • Implemented table and index partitioning to resolve performance issues for Instant Credit application.
  • Verified 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.
  • Fixed several SQL Query performance issues by examining execution plans, tuning indexes, creating plan guides, adding hint words.
  • Monitored SQL Servers to examine top resource consuming queries and tuned them to reduce the server load.

Hire Now