We provide IT Staff Augmentation Services!

Ms Sql Server Dba Resume

NY

SUMMARY

  • 7 years of experience in data analysis, Database Installation, creation, configuration, maintenance and development support using MS SQL Server 2005/2008/2012/2014/2016.
  • Experienced in troubleshooting during a crisis, incident or disaster. Whether it is a planned mock event or production outage.
  • Experienced in performance analysis, tuning, query optimization and system monitoring techniques.
  • Good experience in database partitioning such as creating file groups, table and index partitioning.
  • Experienced with Clustering, Standby Servers, Mirroring and Log Shipping for ensuring High Availability.
  • Experienced in implementing Replication models like Snapshot, Merge and Transactional Replication.
  • Expert in creating linked servers to run distributed queries between Oracle10g and SQL Server 2014, 2012, and 2008R2.
  • Good Experienced in monitoring views, stored procedures and functions for better performance.
  • Experienced in data modeling, design of OLTP, OLAP using normalization and de normalization methods.
  • Experienced in database logical design and converting into physical Model using Ervin and Visio.
  • Experienced in fine tuning SQL queries, views, stored procedures, functions and triggers.
  • Experienced in implementing SQL Server security like maintaining Database authentication modes, creation of users and login, configuring permissions and assigning roles to users.
  • Excellent knowledge with SQL Server Storage Structures, Index and Security Architecture.
  • Experienced in creating clustered and non clustered indexes and full text indexing for better performance.
  • Experienced in database Migration, Backup, Restore and Recovery procedures.
  • Experienced in taking full, differential, log and file group backups for SQL 2016, 2014, 2012, 2008R2, 2008 and 2005.
  • Experienced in using System Monitor, Profiler and Database tuning advisor to resolve long running queries.
  • Good Experience in Monitoring SQL Server logs and performance counters for better productivity.
  • Experience in performance tuning and query optimization using database tuning adviser.
  • Experienced in SQL Script development and scheduling Agent jobs in SQL 2016, 2014, 2012, 2008R2, 2008.
  • Experienced in writing T - SQL code for joints, sub queries and co-related sub queries in Stored Procedures.
  • Experience using Oracle database system, customer relation management (CRM), service management system (SMS) and Trouble ticketing system.
  • Extensive Knowledge of data mining and Time Series algorithms and statistics.
  • Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, Snow Flakes Schema, Star Schema.
  • Expert level ability to sort, mine and analyze data using Microsoft Excel, including pivot table.
  • Expert level ability in Microsoft Word, PowerPoint, Microsoft Outlook, Microsoft publication, Microsoft lync, Microsoft project and Internet Applications.
  • Strong skills in application of oracle.
  • Demonstrated ability to make use of large databases by means of analytical tools.
  • Experienced working with group and independent in 24/7 production environment.

TECHNICAL SKILLS

Operating Systems: MS Windows 10/8/7/XP/2000/NT, DOS and Unix/Linux, Citrix, Sharepoint.

Windows Servers: Windows 2016/2014/ 2012 R2/2012/2008R2/2008/2003R2/2003.

SQL server tools: MS SQL Server Management Studio 2016/2014/ 2012 /2008R2/2008/2005, Business Intelligence Development Studio, MS SQL Server 2000 Enterprise Manager, Query Analyzer, SQL Profiler, DTS, SQL Server 2014/ 2012/2008 R2/2008/2005 Integration Services (SSIS), SSRS, SQL Server 2005 Analysis Services (SSAS), SQL Performance Monitor, Database Tuning Advisor.

Databases: MS SQL Server 2016/2014/ 2012 /2008R 2/2008/2005/2000 , MS Access 2010/2007/2003 , Oracle 12c, 11g, 10g,9i MY SQL, DB2, Power Builder, Sybase, ASE 15.0, Mongo DB, Hadoop, Teradata & Oracle Clinical 4.6.

Oracle Tools: Toad 12.0, PL/SQL, Ora-Excel, Shell Scripting, Power Shell, VB Script & Java Script.

Languages: T-SQL, C, C++, VB6, Oracle PL/SQL,ASP.NET,VB.NET,C#.NET,Java,Assembly Language, High Level Fortran 77,Smil,XML,HTML,DHTML, SAS,OpenCdisc,CDARS R,CDM,SapMaker, SPLUS and SPSS.

Reporting Tools: SQL Server 2016/2014/2012 /2008 R2/2008/2005 Reporting Services (SSRS), Crystal Reports XI, Cognos, Abinitio, Macromedia Director 8, Quality Center, Loadrunner8.0, Winrunner 7.6,Testdirector 8.0.

Web technologies: XML, HTML, XSLT, Ado.Net, VBScript, IIS, Web logic, IE, Web Fair Netscape & Active Server Pages.

Modeling Tools: ER Diagrams, Erwin 4.x,9.2, MS Visio 2013/ 2010/2007/2003 .

Other Tools: SQL LiteSpeed, SQL Watch, DB Artisan, Rapid SQL.

PROFESSIONAL EXPERIENCE

Confidential, NY

MS SQL Server DBA

Responsibilities:

  • Established and maintained the direction of the SQL Server service and managed the acquisition and implementation of the hardware, software, and storage components to achieve that direction.
  • Managed SQL Server services including availability, performance, backups, security, software updates, customer support, communication, and documentation.
  • Involved in defining, creating, and maintaining SQL Server databases and instances.
  • Maintained SQL Server database backup and recovery procedures.
  • Involved in Troubleshooting and resolving any Database performance issues.
  • Involved in designing of high-availability methods such as Clustering, AlwaysON, Transactional Replication and Log Shipping.
  • Involved in monitoring and fine tuning the database indexes and performance.
  • Migrated and refreshed SQL Server databases between the development and production environments.
  • Monitored and tuned databases and underlying subsystems (like windows and storage) for improving performance.
  • Monitored database space utilization and reorganize as needed.
  • Supported the implementation of new versions of the MS SQL Server software.
  • Assisted with problem determination isolating the source of problems in the SQL instances, tools, applications.
  • Performed operational DBA duties, such as installation, database upgrades, patching, environment cloning, implementing backup/recovery and monitoring procedures, capacity planning, site failover/switchover.
  • Created various reports using SSRS.
  • Loaded the data into another data sources (SQL SERVER, MY SQL, ORACLE) using SSIS.
  • Created various SSIS packages based upon the requirement.
  • Involved to Azure Cloud Technologies.

Environment: SQL Server 2016/2014/2012 , Windows Server 2008/2012/2012 R2, SQL LiteSpeed, MSE, VSS, Password Updater,Idera, Sql Diagnostic Manager, Microsoft Azure and SCOM.

Confidential, MI

Microsoft SQL Server DBA

Responsibilities:

  • Installed and Upgraded from SQL Server 2008 to 2008 R 2/2012/2014.
  • Migrated Databases from SQL Server SQL 2008r2 to SQL 2012/2014.
  • Migrating and new installations of SQL Server on VMWARE environment and supporting the SQL Server instances, which are lying on the VM servers.
  • Installed and configured SQL 2012/2014 AlwaysOn Availability Groups.
  • Installed and configured clustering and AlwaysOn Availability Groups environment as a High availability DR solution.
  • Tuning queries which are running slow using Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
  • Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Involved in performing Database security and integrity planning
  • Designed Data Integrator jobs with Error Handling and email notifications.
  • Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
  • Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
  • Routine DBA jobs like Backups and Restores.
  • Performed Encryption on table level, TDE encryption (database level) and SSL encryption (server level).
  • Setup and maintained Linked Servers.
  • Used SQL compare tool to generate SQL upgrade advisory reports for the application teams.
  • Monitored SQL server performance using spotlight.
  • Create custom and Ad-hoc reports using SSRS.
  • Create Event Handlers for the Packages using Event Handler Tab for Error Handling.

Environment: SQL Server 2014/2012, IIS, Windows Server, Performance Monitor, Backup Utility, MOM, MSE and Sitescope.

Confidential, NJ

MS SQL DBA

Responsibilities:

  • Installed and upgraded all software from SQL 2008 to 2008 r2.
  • Identified and resolved the query performance using SQL Profiler and Index tuning wizard.
  • Created and monitored jobs on backup, recovery and other maintenance services on specific databases.
  • Involved in managing backup strategy, monitoring logs, advising on hardware configurations.
  • Implemented and tuned queries developed by other members, and worked with QA teams to test and verified solutions.
  • Acted as the subject matter expert SME for database-related matters.
  • Participated in creating and implementing Disaster Recovery and High Availability Plans Backup/restore, Clustering, Database Mirroring, Replication etc.
  • Analyzed, designed, and architected the infrastructure of the migration of standalone environments to clustered and mirrored environments.
  • Involved in implementing Quest Lite Speed for SQL Backup and Restore.
  • Worked closely with project managers and technical project leads to develop and formalize tasks relative to database development within each project.
  • Worked on Merge, Merge Join and Multicast Transformations while migrating data using SSIS.
  • Worked on monitoring SSIS data flow transformations using data viewers and event handlers.
  • Worked on moving data into flat files, OLEDB destinations and SQL server using SSIS packages.
  • Developing Crystal Reports used to generate all daily, weekly, monthly and quarterly Report including current status.

Environment: MS SQL Server 2008 r2, MS Office, Oracle, Windows, XML, MS Project.

Hire Now