We provide IT Staff Augmentation Services!

Sql Server Database Administrator Resume

NY

SUMMARY:

  • Over Eight years of Information Technology experience in Database Administration, Design, and Development & Support of MS SQL Server / 2000 in Health care, Manufacturing, Financial and Transportation domains, with over two years experience in Healthcare Products like QNXT (3.4, 4.7,4.8) Claim Check, Microdyn.
  • Expertise in
  • Database Administration, Design, Performance Analysis and Tuning, Replication, Log Shipping.
  • Performance Monitor / Profiler, Spotlight (3rd party tool)
  • Code Optimization and improving database efficiency through Maintenance tasks (Re - Indexing, Updating Statistics, Recompiling Stored Procedures)
  • Experience in Building Virtual Servers (Full Clones, Linked Clones) using VMWare LabManager 4.0.
  • Build, configure and deploy VMs and templates.
  • Exposure in using Vsphere to check various activities of VMware servers.
  • Installation of EMC Networker agent.
  • Validated and thoroughly tested Deduplication of backup data by integrating Networker backups with EMC Data Domain.
  • Using Report builder, Report manager and Report designer.
  • Installation and Configuration of SQL Server 20 bit and 64 bit), SQL Reporting Services (SSRS) i.e. both Stand Alone and Web farm installations.
  • Installing and Administering Microsoft Office SharePoint Services 2007.
  • Designed and implemented Backups and Restore strategies using Native SQL and Light speed (3rd party) tools.
  • Designed and implemented a configurable Application and Data security model to ensure controlled access to the data on Production, Test and Development environments.
  • Participated in implementing Active / Passive cluster as a part of Disaster Recover.
  • Provided 24 x 7 Production support for the database and application issues.
  • Worked on Oracle Identity Management to centralize and automate provisioning and coordinating User Security.
  • Excellent Analytical, Fast Learner, Hardworking and Versatile Team Player, Communication and Interpersonal skills, desire to excel.

TECHNICAL SKILLS:

Databases: RDBMS- SQL Server / 2000, Oracle10g, MS Access

Operating Systems: MS-DOS, Windows 95 & 98, Windows Server R server/XP/NT

GUI s: Visual Basic 6.0, VB.NET

Third Party Applications: Clarify eFront Office 9.0, Veritas 8.60, Spotlight, Lightspeed 4.8/5.0, TidalJobScheduler, VMInfrastructure Client, VMLabManager, ProClarity, PerformancePoint.

SQL Server Tools: Enterprise Manager, Profiler,Query Analyzer,Export & Import (DTS), SSIS Packages.

Oracle Tools: PL/SQL Developer, Oracle Enterprise Manager

PROFESSIONAL EXPERIENCE:

Confidential, NY

SQL SERVER Database Administrator

Responsibilities:

  • Installation, configuration, customization, maintenance and performance tuning of SQL Server 2005/2008/ 2008 R2 Standard and Enterprise Editions (32 &64 BIT) including SSIS, SSAS and SSRS.
  • Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
  • Monitor database server capacity/performance and make infrastructure and architecture recommendations to management for necessary changes/updates.
  • Work with internal IT operations teams to troubleshoot network and server issues and optimize the database environment.
  • Establish and enforce database change management standards including pushes from development to QA, on to production, etc
  • Provide development and production support to troubleshoot day-to-day database or related application issue.
  • Design and implement all database security to ensure integrity and consistency among the various database regions.
  • Monitor the health and performance of Production servers using Quest Fog light monitoring tools.
  • Suggested Application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
  • Suggested, developed & implemented Scaling out solution with Data partitioning.
  • Set up Log Shipping, MSSQL Mail and SMTP.
  • Implemented MS SQL Clustering (Active/Passive & Active/Active).
  • Interfaced with database vendors & client technical support teams to isolate & resolve database related problems.
  • Worked on Deploying and Scheduling SSIS packages on Different environments.
  • Installed and configured Biztalk 2009 on Windows 2008 servers.
  • Implemented and tested new SQL Server 2008 features such as Database/Backup Compression on SQL 2008 Databases.
  • Experience in using third party Applications such as Litespeed and RedGate Compare tools, Networker backup tools.
  • Experienced in installing EMC networker agent.
  • Tested and implemented backups and restores with EMC Networker software to centralize and automate Data backups across IT environment.
  • Validated and thoroughly tested Deduplication of backup data by integrating Networker backups with EMC Data Domain.
  • Exposure working on VMware ESX 4.1
  • Experience building Templates, Fenced configurations, Full Cloned and Linked clone servers on Vmware labmanager 4.0
  • Experience in fixing VMware Lab Manager Issues.
  • Experience in installing and configuring SQL server 2005/2008 on VM servers.
  • Administered and Monitored Production databases servers which have been virtualized.
  • Worked with VMware Engineers in fixing performance issues on Database Servers.
  • Exposure in using Vsphere to check various activities of VMware servers
  • Installed and implemented custom configurations of QNXT 4.8 application. On Execution Units, Web Servers and Distribution Hubs.

Project Specific Skills: Windows Server R2, Windows Server /64 BIT, SQL Server 2008/2008 R2, SQL Server 2005, SSRS 2008, Foglight, LiteSpeed, VMWare Lab manager, VSphere.

Confidential, MD

SQL Server Programmer

Responsibilities:

  • Involved in understanding User requirements, writing stored procedures, coding, unit testing and deployment.
  • Worked on developing and modifying an existing code to include encryption and Decryption functionality for an internal provider portal application to suite the encrypted data.
  • Created SSIS packages to send out weekly and monthly outbound files of Medicaid Providers.
  • Modified over 50 Stored Procedures to identifying the existing PCP criteria and modify it to the new PCPC criteria as per the changing user requirements.
  • Involved in building configuring and deploying VMware servers.
  • Experienced in installing various application software’s and SQL server on VMware servers.
  • Worked on Fine Tuning the performance of the existing Stored procedures
  • Worked on setting up the security as a part of post migration tasks.
  • Worked on Monitoring and fixing the day-to-day jobs and maintenance tasks.
  • Experience in working on issue tracking and ticket management system Gemini
  • Experience in using tools such as SQL Prompt and SQL Refractor to format SQL code

Project Specific Skills: SQL Server 2005, SSIS, QNXT 3.4 SP6, Vsphere 4.0

Confidential, VA

Database Administrator

Responsibilities:

  • Installation and Configuration of SQL Server bit and 64 bit).
  • Developed T-SQL scripts and ETL processes to load and transform data extracts from legacy systems into a SQL Server staging database.
  • Support data migration and testing activities in Integration, user acceptance testing and production environments.
  • Developed, publish and maintain database operations manual under revision control.
  • Handled storage management, performance, monitoring and tuning of the database.
  • Windows system administration including Active Directory and Group Policy.
  • Manage availability, backup, restoration and recovery systems with the database.
  • Designed and automated the process of QNXT (quser and qenvironment) security as per business needs.
  • Worked with business users in analyzing the legacy data with tools such as encoder pro, fixed the data and migrated all CPT/HCPCS to QNXT 4.6 environment.
  • Understanding the business logic and moving data across environments as per user request.

Project Specific Skills: SQL Server 2005, Net 3.0 Visual Studio .NET 2005

Confidential, NY

SQL SERVER Database Administrator

Responsibilities:

  • Managed up to 30 Production servers and 50 Development environments.
  • Installation and Configuration of Microsoft office SharePoint Services (MOSS 2007).
  • Involved in SQL Reporting Services Web-Farm installation and configuration.
  • Redesigned existing SQL Server security to use Active Directory Groups and implement Active Directory Groups into SQL Server Security.
  • Created User defined roles on SQL Server 2005 to address security gaps.
  • Scheduling Jobs and Alerting using SQL Server Agent and a Tidal Job Scheduler.
  • Monitored and debugged various bottlenecks through a Spotlight (3rd party monitoring tool).
  • Set up alerts for various critical issues such as CPU utilization, Disk space usage and critical Job status.
  • Integrated Sql traces with Performance monitor to have better graphical analysis to find system bottlenecks.
  • Involved in designing efficient backup strategies.
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Experience in using data modeling tool such as Visio

Project Specific Skills: SQL Server, Net 3.0 Visual Studio .NET 2005, Oracle Identity Manager

Confidential, NY

SQL Server Analyst

Responsibilities:

  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server
  • Involved in requirement gathering, analysis, design, development, change management, deployment and user .
  • Installed and Configured SQL Server 2000 successfully.
  • Integrated Sql traces with Performance monitor to have better graphical analysis to find system bottlenecks.
  • Implemented SQL Server 2005 new concepts like data partitioning, snapshot isolation, data base snapshot, DDL triggers and DMV’s.

Project Specific Skills: SQL Server, Dot.Net 3.0, Visual Studio .NET 2005, XML

Confidential

SQL SERVER DBA

Responsibilities:

  • Worked as Database Administrator in support solution division supporting on an average of 100 Database Servers to protect critical data.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies
  • Export or Import data from other data sources like flat files using Import/Export through DTS and SSIS.
  • Converting DTS packages into SSIS.
  • Responsible for scheduling the job steps which trigger the process to run daily and on weekends, monitoring the status of Maintenance jobs.
  • Resolving the cases which were escalated by the offshore teams to solve machine critical problems in the database Servers using Clarify case management system

Project Specific Skills: Windows 2000 server, VB.NET, ASP 3.0, SQL Server 2000/2005, UNIX based DMS Clarify case management tool, VERITAS backup.

Hire Now