We provide IT Staff Augmentation Services!

Senior Ms Sql Server Dba Resume

Charlotte, NC

SUMMARY

  • Senior MS SQL Server database administrator with 9+ Years of quality experience in managing and supporting Production system
  • Extensive SQL DBA experience in Administration, Backup/Recovery, Installation, Testing and Disaster Recovery using SQL Server 2016/2014/2012 /2008 R2/2008/2005 and Oracle 9i, 10g, 11g.
  • Experience in different industry sectors including Banking/Finance, Insurance, Telecommunication, Airlines, Health Care and Retail.
  • Extensive experience in Installation and Configuration of MS SQL Server 2005, 2008, 2008R2, 2012 and 2014 versions.
  • Expert in Microsoft Azure systems including SQL Server hosted on Azure Virtual Machines (IAAS,PaaS)
  • Extensive work experience on AlwaysOn (Synchronous/Asynchronous) and Azure/Cloud Servers.
  • Experience in Migration from SQL Server 2005 to SQL Server 2008 to 2008 R2 to 2012 to 2014/2016.
  • Expert in High Availability and Disaster Recovery with Clustering/Mirroring and Log Shipping
  • Supports day to day operational duties for the database platform such as service requests and tickets, backups, monitoring, performance tuning, system troubleshooting, and other tasks as assigned or expected from DBAs
  • Extensive work experience on system analysis, design, development, testing and implementation of projects, Trend reporting in the business with full SDLC (Software Development Life Cycle).
  • Expert in Relational Database Management System (RDBMS) concepts and constructs to design relational databases model and implementation as per business needs.
  • Experienced in database design, Relational Integrity Constraints, OLAP, OLTP, Cubed Data and Normalization of transactional database schema and legacy systems.
  • Experience in Implementing SQL Server Clustering (Active - Active, Active-Passive), Multi Node cluster.
  • Expertise in Security Issues such as creating logins and granting permissions on various objects as well as Administering security for server’s logins regularly (Windows and SQL Accounts) and guest user logins.
  • Configured SMTP server for Database mail setup and received alerts for the threshold values.
  • Excellent T-SQL Programming skills, Execution Plan, query optimization & performance tuning.
  • Used SQL Profiler, Performance Monitor and DBCC Commands.
  • Implemented the concepts like Data partitioning, snap shop isolation, Database snapshot, try-cache blocks, indexing, and dedicated administration connection.
  • Exposure to Water fall and Agile methodologies.
  • Planning, creating and Optimizing Indexes in SQL Server.
  • Experience in Database Maintenance Plans to keep indexes and statistics updated.
  • Experience in Scheduling and creating jobs, alerts and troubleshooting when jobs fail.
  • Expert in SSIS package creating and deploying SSIS packages to various environments
  • Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
  • Experience in performing BCP, BULK INSERT, Imported and Exported data from different Data Sources.
  • Extensively worked on SSIS in SQL Server, Hot and Cold Backups, Disaster Recovery Planning, Managing server and clients, T-SQL, PL/SQL, Stored Procedures, Functions, Cursors, Triggers, Packages, Data Transformation Services (DTS) Packages and SSAS etc.
  • Excellent analytical, problem-solving, coding, analytical and communication skills.
  • Handled numerous Change Management requests on production servers and Supported 24/7 Production on Call.
  • Experienced in Documenting procedures in Run-books.

TECHNICAL SKILLS

  • MS SQL Server 2016/2014/2012 R2/2012/2008R2/2005
  • Microsoft Azure IAAS
  • Microsoft Azure PAAS
  • MS Access
  • Oracle 11g/10g/9i/8i/7.x
  • Windows Server 2016/2012 R2
  • AlwaysON Availability Groups
  • Clustering
  • Mirroring
  • Log Shipping
  • Replication
  • SQL Server Management Studio
  • Database Tuning Advisor
  • SQL Profiler
  • Enterprise Manager
  • Query Analyzer
  • SSAS
  • SSIS
  • DTS
  • Resource governor
  • Replication
  • Business Intelligence Development Studio (BIDS)
  • Red Gate and Ideara Diagnostic Manager
  • ERWIN
  • VISIO

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Senior MS SQL Server DBA

Responsibilities:

  • Responsible for Installing/configuring and patching MS SQL Server 2016/2014/2012 on Windows servers.
  • Responsible for monitoring and managing production servers on HA and DR
  • Involved in requirement analysis, planning, design and architecture for new build servers.
  • Worked on large scale database administration environment with huge number of servers.
  • Extensive work on Azure Server migration.
  • Extensive work on AlwaysOn (Synchronous/Asynchronous) and Azure/Cloud Servers.
  • Involved in Installation & configuration Failover Cluster, LogShipping, database Mirroring and Replication.
  • Worked on Windows Server Failover Cluster (WSFC), Active-active and active-passive Failover cluster instances (FCI), DB mirroring, logshipping, AlwaysOn and FCI+AlwaysOn as a high availability solution.
  • Supported various Microsoft Azure systems including SQL Server hosted on Azure Virtual Machines (PaaS)
  • Responsible for Azure system configuration, database migration, backup and recovery, performance monitoring and tuning, geographic data replication and disaster recovery configuration.
  • Used DBCC to check and fix physical and logical consistency of databases.
  • Development of database maintenance plan including backups, DBCC, index management, history and backup cleanup and fragmentation management.
  • Worked to improve performance by running index tuning wizard which would create, rebuild and reorganize indexes on various tables.
  • Used Powershell scripts for SQL Server installation, AlwaysOn configuration and maintenance jobs.
  • Database recovery and restoration from backup also based on Recovery Point Objective (RPO) and Recovery Time Objective (RTO).
  • Worked extensively with fine tuning and performance tuning SQL Queries and slow running processes
  • Hands-on experience in resolving locks, deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
  • Database upgrade from SQL Server 2008R2 to SQL Server 2012/2014.
  • Monitoring server activities, error logs, space usage and solving any alarming problems.
  • Created notification and alert system for jobs tracking and any errors arising in servers such as system errors, hardware errors, insufficient resource and fatal database/server errors.
  • Worked with SCOM monitoring.
  • Worked as a back-end support for SSRS team as well as Report Server databases migration.
  • Responsible for administering the MS SQL Server security system.
  • Creating and monitoring user and group accounts. Assigning appropriate roles and privileges for various user accounts and groups.
  • Working closely with application team to fix database issues, changes

Environment: MS SQL Server 2008 R 2/2012/2014/2016 , Windows Server 2016/2008/2012 , Virtualization, Azure servers, AlwaysOn, FCI, SSIS, SSRS, SAN, NAS, LUN, Power-Shell, SSRS, Microsoft platform as a services (PaaS), SCOM.

Confidential, Boston, MA

MS SQL Server DBA

Responsibilities:

  • Responsible for Installing and configuring SQL Server 2008 and 2012 on Windows 2003 and 2008 servers.
  • Involved in Installation & configuration Failover Cluster, Log Shipping, Database Mirroring and Replication.
  • Worked with SQL DBA team and SQL Developers to optimize the SQL queries and stored procedures.
  • Extensive use of DBCC commands to investigate the Database issue and formulate the remediation.
  • Installed and configured SQL server 2008 Reporting Services (SSRS), created user roles, managed security built reports and deployed them to production. Worked with configured SSRS to monitor all jobs on daily basis, fixed the failed jobs and re-ran them.
  • Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures. Configure and maintain Report Server for SSRS.
  • Implement migration SQL Server databases, DTS packages from one server to another.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
  • Created standard operation procedures (SOP) for initial database shell creations for specific customer package builds.
  • Developed the metrics and trending processes for SQL database sizing and growth.
  • Daily monitoring of two-node active-passive SQL cluster in a host environment.
  • Applied service packs and security fixes for all SQL Servers, and provided database administration support.
  • Involved in upgrading from SQL Server 2008 to SQL Server 2012 including all SSIS and SSRS packages.
  • Performed the database backups for production, test and development environments.
  • Created the backup and restore strategy for the all three environments.
  • Worked with the Database optimization, Performance tuning and index tuning for optimization of queries.
  • Meet the SLA (Service Level Agreement) established.

Environment: MS SQL Server 2008/2005, Windows Server 2008/2003,Virtualization, Ideara Diagnostic Manager, Red Gate, SSIS, SSRS.

Confidential, Birmingham, AL

MS SQL Server DBA

Responsibilities:

  • Installed /configured / Patched SQL Server 2008 R2/2012.
  • Involved in Planning, Defining and Designing database based on business requirements, Data Migration from SQL Server 2005 to SQL Server 2008 R2/2012 and provided documentation.
  • Helped development team with point in time database recoveries.
  • Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
  • Responsible for 24x7availability of production databases.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area, then used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, and finally transfer into data warehouse.
  • Developed and deployed data transfers packages to the appropriate destinations using SSIS.
  • Created SQL server configurations for SSIS packages and experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
  • Extensively worked on trouble shooting and fine-tuning of databases for its performance.
  • Worked with Performance Tuning/Query tuning, execution plans, trace flags and SQL Profiler
  • Responsible for creating reports based on the business requirements using SSRS 2008
  • Identified the database tables for defining queries to generate reports for analysis of data using SSRS in Report Builder.
  • Created various reports including Cross-tab, Conditional, Drill-down, Sub reports, parameterized reports and also created number of complex formulae in sub report.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data also scheduled monthly/weekly/daily reports to run automatically.
  • Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
  • Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
  • Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.
  • Designed both logical and physical data models in Erwin 7.2

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2008 (SSRS), SQL Server Integration Services 2008(SSIS), VSS, Microsoft Visual Studio, SSMS, ASP.NET, MS Excel, T-SQL, Erwin.

Confidential, Fort Worth, TX

MS SQL Server DBA

Responsibilities:

  • Installed and configured MS SQL Server 2012 and 2008 R2 on Windows Server 2012/2008 R2, also applied service packs and security fixes on these servers.
  • Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
  • Responsible for a large scale of database migration from SQL server 2005 to SQL server 2012 and 2008 R2
  • Providing 24x7 dedicated production support for SQL Server problem resolution and server outages.
  • Involved in database and log backups and restoration, planning backup strategies, and scheduling.
  • Backing up master & system databases and restoring them when necessary.
  • Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
  • Created Indexes, Views, complex Stored Procedures, user defined functions, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
  • Involved in creating Logical & Physical Database Design using data modeling tool Erwin.
  • Using third party tool Red Gate, ensuring all the databases are backing up on the regular basis and then restoring this databases on requests.
  • Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
  • Using third party tool Idera, monitor all the servers and their jobs in a single Management Console.
  • Working with creation, installation and configuration of SSRS.
  • Responsible for securing SQL Server, user management, and taking care of permissions and roles.
  • Working with SSIS package to import and export operations in and out of the SQL Servers.
  • Scheduling jobs and alerts using SQL Server Agent. Administrating Microsoft Operation Manager (MOM) 2005 in an existing IT infrastructure.

Environment: MS SQL Server 2012/2008 R2/2008/2005, Windows Server 2008 R2/2003, SQL Server Reporting Services 2008 (SSRS), SQL Server Integration Services 2008(SSIS), Microsoft Visual Studio, SSMS, MS Excel, T-SQL, Erwin.

Confidential, Baltimore, MD

SQL Server Developer/ SQL Server DBA

Responsibilities:

  • Involved in Planning, Defining and Designing database based on business requirements, Data Migration from SQL Server 2005 to SQL Server 2008 R2 and provided documentation.
  • Responsible for maintaining SQL Server Database for High Availability.
  • Responsible to maintain Backups of all Databases for Disaster Recovery.
  • Building and re-building indexes to optimize the database performance.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area, then used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, and finally transfer into data warehouse.
  • Developed and deployed data transfers packages to the appropriate destinations using SSIS.
  • Created SQL server configurations for SSIS packages and experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
  • Responsible for creating reports based on the business requirements using SSRS 2008
  • Gauged the effectiveness and efficiency of existing reporting systems. Developed and implemented strategies for improving and further leveraging these reports in order to transfer/convert existing Reports to SQL Server Reporting Services.
  • Helped developers to write queries by extensively using Joins and Sub-Queries to simplify complex queries involving multiple tables and worked with database objects like Tables, views and indexes.
  • Identified the database tables for defining queries to generate reports for analysis of data using SSRS in Report Builder.
  • Created various reports including Cross-tab, Conditional, Drill-down, Sub reports, parameterized reports and also created number of complex formulae in sub report.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data also scheduled monthly/weekly/daily reports to run automatically.
  • Performed Report Testing and Verification as per Internal Reporting system requirements.
  • Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
  • Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
  • Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.
  • Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
  • Responsible for transferring packages using SSIS on to production Server.
  • Designed both logical and physical data models in Erwin 7.2

Environment: MS SQL Server 2005/2008 R2, SQL Server Reporting Services 2008 (SSRS), SQL Server Integration Services 2008 (SSIS), VSS, Microsoft Visual Studio, SSMS, MS Excel, T-SQL, Erwin.

Hire Now