We provide IT Staff Augmentation Services!

Sql Server Resume Profile

2.00/5 (Submit Your Rating)

Summary:

  • Having 9 Years of IT experience in Microsoft Database Technologies with various Industry like Financing, Manufacturing, and Hospitality as a SQL Server DBA in MS SQL SERVER 2008/2005/2000/7.0/ Database Administration Developer in Windows environment.
  • Good knowledge of Relational Database Management Systems RDBMS .
  • Expertise in Database administration activities like Installation, Configuration, Backup Recovery, Database Security, Data Transformation Services, Database designing and Query optimization.
  • Good working experience with VMWARE BAU.
  • Deployment of Excess and Excel data creating SSIS Packages using BIDS.
  • Experience with Adhoc and implementation of services on request.
  • Good working experience in maintaining SQL Server Active/Passive cluster environment.
  • Worked in an environment with setting and configuration of Team Foundation Server.
  • Experience in Migration from MS SQL 2000 to MS SQL Server 2008 R2 MS SQL Server 2005 to MS SQL Server 2008 R2.
  • Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
  • Experience with Database High Availability Performance Tuning
  • Worked with Windows Cloud VMware Environment.
  • Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008 databases.
  • Experience in MS SQL Server 2000 and 2005 installation with latest service pack, configuration, performance tuning, client/server connectivity, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC.
  • Extensive experience in Capacity planning, Disaster Recovery, troubleshooting, backup and restore procedures.
  • Implemented SAN Replication Snap Mirror for Disaster Recovery for the business
  • Worked in OLTP environments with web sphere as the application server, java code interacting with the oracle database server
  • Experience in implementing and configuring various RAIDS 1-5 10 technologies.
  • Worked on different SAN EMC and HP Arrays for SQL Server Databases and good understanding in capacity planning.
  • Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
  • Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
  • Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
  • Extensive knowledge in Tuning SQL queries improving the performance of the Database.
  • Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS and SSIS.
  • Creation and maintenance of Databases, creating Roles and managing user permissions.
  • Good experience in resolving blocking and Dead lock Issues by using SQL commands.
  • Experience working in Production support including weekend and Change control support over nights.
  • Documented disaster recovery plans and participated in disaster recovery drills.
  • Monitoring SQL Server job logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
  • Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in DB.
  • A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

Languages

:

T-SQL, PL/SQL,C, C , HTML, VB script, XML

RDBMS

:

MS SQL Server 2008R2, 2008, 2005, 2000, 7.0, Oracle 8i/9i,10g,MS-Access

Front End

:

VB 6.0

Version Control

:

Visual Source Safe, Rational Clear Case,

Operating

Systems

:

Windows Server 2008R2/2003, Windows 2000 Advanced Server, Windows NT 4.0 / 3.51, Windows 95/98/XP

Other Tools

:

Idera Diagnostic Manager, NetIQ, Compaq Insight Manager, Quest Spotlight, Lumigent Log Explorer, SQL Light speed , ERWIN 4.0, Crystal Reports, Toad for Oracle 9.5

Hardware

:

Compaq ProLiant 8000, 6500, 6000, 5000 Servers, IBM PC AT, HP ProLiant BL25P, IBM x225, Dell PowerEdge 8450

APPLICATION AREAS

  • Installed, configured and maintained MS SQL Server 2008/2005/2000/7 on Windows NT Windows 2008/2003 Server.
  • Developed form tools from end for the business according to their requirement.
  • Expertise in DTS, SSIS, SQL Server Reporting Services SSRS .
  • Expert in writing and debugging complex stored procedures, Functions, Views and DML/DDL Triggers.
  • Setting up Log-Shipping on MS SQL Server 2008 / 2005/2000.
  • Implemented Log Shipping technique for DR solution for Microsoft SQL Server 2008R2/2005/2000/7 also solved and automated manual log shipping issues.
  • Database Mirroring.
  • Configuring Cluster Server
  • Implemented Configured cluster server in Active/Passive node.
  • Database security optimization.

PROFESSIONAL EXPERIENCE:

  • Installed, configured and maintained MS SQL Server 2008R2 on a Windows 2008R2 Server clustered environment.
  • Helped team to implement the business with Logistics Application for all Plants
  • Migration of 200 Instances were done at only 22 Instances as a part of Consolidation Migration.
  • Traced orphan users after the Migration as part of the Migration process.
  • Worked with Data Import / Export terminology using the SSIS Packages between different tables.
  • Expertise in writing and debugging complex stored procedures, Functions, Views and DML/DDL Triggers.
  • Setting up Log-Shipping on MS SQL Server 2008 / 2005
  • Implemented Log Shipping technique for DR solution for Microsoft SQL Server 2008R2/2005 also solved and automated manual log shipping issues.
  • Configuring Cluster Servers for High Availability
  • Implemented Configured cluster server in Active/Passive node.
  • Database security optimization.
  • Monitoring current environment for optimization and fixing the errors on daily basis.
  • Keep a track of Backups with the team that is running Commvault agent.
  • Implemented ACL Audits for all our Databases for any unauthorized use using trace jobs.
  • Maintained Integrity Checks adding Maintenance plans for all our databases on weekly basis.
  • Added Consistency Checks for all our databases on weekly basis.
  • Worked on setting up Reindexing and Reorganizing jobs along with Statistics Updates on all our databases on weekly basis.
  • Created Linked Server for connectivity between two servers to share reports.
  • Performed SQL 2008R2 Service packs and Hotfixes for the new Clustered environment.
  • Worked with Application team to upgrade their applications to support current environment.
  • Worked with setting up Test Environment for our teams.

Responsibilities:

  • Interacting and reporting directly with the Business Executives.
  • Leads team of 4 others that are directly involved in Production.
  • DataCenter Move from McKinney Texas to Denver Colorado.
  • Responsible to monitor all the Database servers and Application Servers at all Blockbuster distribution centers remotely.
  • Suggestions were made to make the environment more smooth using best practices.
  • Worked with VMWARE Citrix.
  • Created SOP's documents for the business with full details of hardware and software and that also includes all the steps of maintenance plans and daily scheduled jobs.
  • Database Indexing Clustering.
  • Created managed the Database Users, Login and Security.
  • Optimizing and fine-tuning the SQL servers.
  • Solid experience and knowledge with SQL 2000 backup and recovery procedures.
  • Involved working in live Production for all Alerts and Maintenance work.
  • Responsible for all the change in production using the Change Request standard procedure.
  • Daily monitoring with automated Email Alerts.
  • Documentation for all the Servers, Instances, Reports, Stored Procedures, Automated or Manual Job.
  • Monitoring for all the Daily and Weekly Full Backups and TLog backups
  • Involved in Production, development, QA, knowledge transfer.
  • Monitoring of Database Instances for inactive Instances using best practices.
  • Monitor for all the failures and errors on daily basis and fix it if required.
  • Deployment of latest release versions in testing and to deploy the latest release in production after testing approval.
  • Updating daily operation status reports with errors and their solutions.
  • Used Jira and ServiceNow ticketing tools for monitoring and assigned tickets.
  • Responsible for resolving Deadlocks issues.
  • Monitoring Analysis of SQL Log, Perfmon counters and Performance Tuning for all development and staging environment.
  • Data deployment for XML using Integrated Services.
  • Provided 24 X 7 dedicated supports for SQL Server production server

Environment: Microsoft Windows Server 2003 Enterprise Edition, Microsoft Windows 2000 Server, Microsoft SQL Server 2000, Microsoft SQL Server Data Transformation Services, Microsoft SQL Server 2008R2 on all Testing and QA Environment.

Responsibilities:

  • Documentation for all the Servers, Instances, Reports, Stored Procedures, Automated or Manual Job.
  • Documentation for Daily, Weekly, Bi-Weekly, Monthly, Quarterly and Yearly Report.
  • Data migration using SAN storage.
  • Responsible to run the Daily Checklist to see if there was anything wrong at the Database Production side and then fix it if any.
  • Worked with VMWARE BAU L1
  • Deployed Excel Data into SQL creating SSIS Packages
  • Database Indexing Clustering.
  • Daily monitoring using Idera Dashboard.
  • Creating of Daily Jobs using Idera Monitoring Tool.
  • Researched Lotus notes to extract .PDF files and save it to any other location using the third party tool.
  • Monitoring the Server health and Database health using Idera third party tool and Symphonic third party tool.
  • Monitoring of Database Instances for inactive Instances using best practices.
  • Monitor for all the failures and errors on daily basis and fix it if required.
  • Executing the Daily SSIS Package manually and manual queries scripts daily to check the load of data from previous day.
  • Deploying data using SSIS Packages and generating reports using SSRS Reporting tools.
  • Designing for custom built data Integration using SSIS. Output for all the custom reporting using SSRS.
  • Monitor for any Slow Web Response related to Database and keep a track of all slow down for possible fix.
  • Update the Documentation of all the daily errors in Daily Failure Matrix and keep a track of it to make sure the production gets better and better every day.
  • Update the Web Response Matrix Documentation and keep a track of all the errors, and do keep a track of the contribution to it.
  • Created Complex SSIS packages for the extracting, transforming and loading the data from SQL Server 2005, flat files, Excel files
  • Designed New Reports and Customised existing reports of older version to New version
  • Responsible for resolving Deadlocks issues.
  • Monitoring Analysis of SQL Log, Perfmon counters and Performance Tuning for all development and staging environment.
  • Testing and Deployment software upgrades and release at Database Level.
  • Data deployment for XML using Integrated Services.
  • Provided 24 X 7 dedicated supports for SQL Server production server

Environment: Microsoft Windows Server 2003 Enterprise Edition, Microsoft Windows 2000 Server, Microsoft SQL Server 2000/2005, Microsoft SQL Server Data Transformation Services, Microsoft SQL Server Reporting Services, Idera Moniroting tool and Symphonic third party tool.

Confidential

SQL SEVER DBA

Responsibilities:

  • Installed and configured edition of SQL Server 2008 like Enterprise edition.
  • Successfully migrated from SQL Server 2005 to SQL Server 2008 R2 on Development and Testing Environment.
  • Created Complex SSIS packages for the extracting, transforming and loading the data from SQL Server 2005, flat files, ORACLE, Excel files.
  • Expertise in Data Cleansing, mapping columns, Lookup with Various SSIS OBJECTS,
  • Converted all existing DTS package of MS SQL 2005 to SSIS packages by using package migration wizard and Deployed new Package in different Server.
  • Expertise with Adhoc and request services.
  • Use ERWin for developing and maintaining Data Model
  • Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment.
  • Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements.
  • Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.
  • Designed New Reports and Customised existing reports of older version to New version
  • Implemented transactional replication to enhance the failover capabilities increased over all database manageability and improved performance.
  • Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
  • Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system using diagnostic manager from Idera.
  • Creating logins and roles with the appropriate permissions.
  • Monitoring Analysis of SQL Log, Perfmon counters and Performance Tuning for all development and staging environment.
  • Responsible for resolving blocking and locking issues.
  • Successfully implemented database mirroring between Primary server and Mirror Server.
  • Implemented log shipping in standby mode to support DR servers.
  • Provided 24 X 7 dedicated supports for SQL Server production server.

Environment: Microsoft Windows Server 2008 Enterprise Edition, Microsoft Windows 2003 Server, Microsoft SQL Server 2005, 2008, Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services , Microsoft OFFICE 2003.

Confidential

SQL SEVER DBA

Responsibilities:

  • Installation, Configuration and Maintenance of MS SQL Server 2000 and 2005.
  • Involved in setting up Transactional Replication and Snapshot replication.
  • Involved in Setting up Log shipping.
  • Involve Active Passive SQL Clustering to provide High Availability for mission critical Development server.
  • Involved in setting up Team Foundation Server and Configure
  • Involved in Adhoc and request services.
  • Extensively involved in database mirroring.
  • Extensively Involved in Creating Back up Strategy.
  • Extensively Involved in Designing Logical and Physical of Customer Database.
  • Created managed the Database Users, Login and Security.
  • Worked with LITE-speed for backup and restore of database.
  • Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using SQL.
  • Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail
  • Administrator tasks such as managing users, roles, and profiles.
  • Used DTS Packages for data import and export data from SQL Server to Access, text and EXCEL files.
  • Created Packages and jobs to perform filtering operations and to import the data on daily basis from the Oracle DB to SQL server. Worked as SQL Server administrator.
  • Resolving Dead locks and blocking issues.
  • Extensively worked on performance tuning of Database and Query tuning.
  • Involved in resolving blocking and dead lock Issues by using SQL commands Using T-SQL.
  • Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Experienced in performance tuning using Windows performance monitor and SQL profiler of SQL server.
  • Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility. Extracting, Transforming and loading of data using SSIS and DTS.
  • Deployed and scheduled SSIS Package.
  • Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, with a lot of interaction with the client.
  • Performed analysis and design of the application.
  • Experience in with tools like Microsoft Reporting Services SSRS .
  • Expert in creating traditional as well as Web-based interactive reports using SSRS.
  • Created and deployed and scheduled report using SSRS.

Environment: M SQL Server 2000/2005, T-SQL, Enterprise Manager, Query Analyzer, Visio, Windows 2003 Server , SSIS,SSRS,DTS, ERWIN, MS Excel and Windows XP

We'd love your feedback!