We provide IT Staff Augmentation Services!

Sql Server Dba Resume

PROFESSIONAL SUMMARY:

  • 7 + years of experience in Database Administration, System Analysis, Development & Support of MS SQL Servers 2008/2012/ 2014/ 2016 in Production, Development, Testing and Data warehouse Environment.
  • Working on SQL Server 2016/ 2014/2012/2008 R2 Versions.
  • Implementing High Availability solutions like Replication (Snapshot, Merge and Transactional), Log shipping, Mirroring, Always on and Clustering.
  • Implemented Side - by- Side Migration of MS SQL SERVER 2008/2012/2016.
  • SQL Server Profilers, Index Tuning Wizard and monitor DB blocking.
  • Partitioning tables to achieve better performance for access and writes.
  • Database Backup, Recovery and Disaster Recovery Procedures. Extensive knowledge in Tuning SQL queries & improving the performance of the database by creating and updating clustered and non-clustered indexes.
  • Experience in writing T-SQL (DDL, DML and DCL), Expert in implementing business logic in backend and reviewing T-SQL Code.
  • Always-On Availability Groups (AAG) and DR Troubleshooting.
  • Creating deployment utility to deploy SSIS packages over Production, QA and Local systems.
  • Administering SQL Server High Availability and Disaster Recovery strategies.
  • Creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic SQL queries.
  • Analysing Execution Plan, managing indexes and troubleshooting deadlocks.
  • Performed SQL server installation and patching on both Standalone and Clustered environment.
  • Utilizing Delphix to refresh Databases to Reporting.
  • Using Attunity to implement Change data Capture and to obtain real time data integration.
  • Monitoring tools like Red gate and Solar winds to monitor server health
  • Experience in analysing SQL wait types, execution plans for troubleshooting performance issues.
  • Good communication and interpersonal skills.
  • Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETS and have good knowledge on FACETS business rules.
  • Self-motivated individual with strong Technical & Analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.
  • Creating Perspectives, Partitions and Design Aggregations in cubes using SSAS. Developed the SSAS 2012 Tabular model reports from Data warehouse using SSDT.
  • Creating groups and measures, KPIs.
  • Hands-on experience with Oracle APEX 3.2/4.0/4.1 (Oracle Application Express)
  • Created reports such as Parameterized, Cascading, drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.

TECHNICAL SKILLS:

Operating System: Windows OS

Databases: SQL Server 2000/20, 2016, Microsoft Access, MySQL, Informix, AWS RDS, AWS S3, Azure

T: SQL, SQL Plus, Pl/Sql

Script, XML, HTML, DHTML, T: SQL Programming, VB 6, C++, JAVA, .Net, C#, ASP.NET, Perl, PowerShell, Ruby, Crystal Reports, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

  • Maintained SQL Server Database; ensured accuracy of information and automated numerous functions.
  • Fine tuning of database objects and server to ensure efficient data retrieval.
  • Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor.
  • Designed and implemented incremental and full backup policies and procedures.
  • Created and implemented database design solutions in collaboration with programming team.
  • Developed user defined functions and triggers to implement the requirements of the business.
  • Experience in Windows Azure, migrating database to Azure
  • Formulated oracle process, data retrieval methods and SQL code blocks
  • Application Express (APEX) and client/server configurations
  • Created some oracle objects for OLAP.
  • Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.
  • Used database consistency checks using DBCC utilities.
  • Perform all database management responsibilities in Microsoft Azure for production and non-production workloads
  • Incident Management, closing out high priority tickets though Track-it Ticketing software.
  • Involved in monthly maintenance to reboot clusters, failing over instances from one node to another after windows patches pushed by the network team.
  • Performed Database migration of PeopleSoft database involving DB2, MS SQL Server and Oracle
  • Upgrading SQL SERVER and applying service packs and hot fixes and unattended Installations.
  • Strong expertise on clustering and troubleshooting alerts when cluster goes down.
  • Supported APEX applications and conducted performance tuning for PLSQL
  • Populated data into PeopleSoft Database via Datamover Scripts
  • Involved in daily production server check list, SQL Backups, Disk Space, Job Failures, System Checks, Checking performance statistics for all servers using monitoring tool and research and resolve any issues, checking connectivity

Environment: MS SQL Server 2005/2008/2012/2014/2016 , Windows 2008,2012, Excel, HTML, XML, VSTS 2008, VB and LiteSpeed, spotlight, fog light MS Visio, C#, SSIS, Microsoft SQL Server Visual Studio 2005/2008.

Confidential, Michigan

SQL Server DBA/Azure

Responsibilities:

  • Performance Analysis of SQL Server Hardware, installation and configuration, Architecture design, Storage.
  • Information gathering using tools like Solar winds DPA, SP BLITZ, custom script.
  • Document Pain-points and Existing issues with Root cause and remediation plan.
  • Analyze reports from tools and propose architectural changes and providing solutions with New SQL 2012 & 2014 Features like Always ON, Column store index, Partitioning, compression.
  • Did the forward and backward data mapping between the fields in mainframe and FACETS.
  • Analyzed the mainframe reports for member/eligibility/claims and mapped the fields with FACETS batch jobs and reports.
  • Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration
  • Designed solutions with Resource governor to prioritize users and their access
  • Created builds and release pipelines in VSTS and done deployments using SPN (secure endpoint connection) for implementing CI/CD
  • Installed and configured SQL Server 2012, 2014, 2016 in a 5-node production cluster.
  • Deployed and designed pipelines through Azure data factory and debugged the process for errors.
  • Configuring mount points SAN drives for clustering environment. Storage team assigns the disks and I used to bring them online and configuring the mount points.
  • Troubleshoot database status, performance, Replication, Log-shipping, Always On Availability as well as various errors on production, development and UAT servers.
  • Incident Management, closing out high priority tickets though Track-it Ticketing software.
  • Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor
  • Involved in monthly maintenance to reboot clusters, failing over instances from one node to another after windows patches pushed by the network team.
  • Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware
  • Upgrading SQL SERVER and applying service packs and hot fixes and unattended Installations.
  • Strong expertise on clustering and troubleshooting alerts when cluster goes down.
  • Involved in daily production server check list, SQL Backups, Disk Space, Job Failures, System Checks, Checking performance statistics for all servers using monitoring tool and research and resolve any issues, checking connectivity.
  • Created Severity Alerts, Database Mail, Operators, and Maintenance Plans for system databases.
  • Expertise in Setting up database backup and recovery procedures for production, QA and development servers.
  • Involved in the Query optimization and Performance tuning, and also tuned SQL queries using Show plans and Execution plans.
  • Loaded data from various sources like flat files, to SQL Server database Using SSIS Package.
  • Review T-SQL code to verify and meets standards for both performance and error handling according to DBA standards
  • Capacity Planning and Optimizing the sizes of Databases& Worked Extensively on Disk Space Utilization and Capacity Planning
  • Actively Participated in meetings, recommended the necessary changes required in present database or business systems.

Environment: MS SQL Server 2005/2008/2012/2014/2016 , Windows 2008,2012, Excel, HTML, XML, VSTS 2008, VB and LiteSpeed, MS Visio, C#, SSIS, Microsoft SQL Server Visual Studio 2005/2008.

Confidential, Eagan, MN

SQL DBA

Responsibilities:

  • Installation and maintenance of SQL Server 2008R2, 2012, 2014 on Test, Development and Production Environments, Active Directory Administration.
  • Worked with SQL Server 2012 in place and side by side upgrade from 2005.
  • Strong experience in working on Very Large Databases (VLDB) over 2 TB for OLTP.
  • Implemented Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
  • Implemented Database Mirroring and Transactional Replication as a part of DR plan.
  • Worked with upgrading, cloning and migrating SQL databases in SQL Server 2012/2008R2.
  • Implemented the new SQL Server 2012 concepts like HADR Always ON, Availability Groups.
  • Developed various Administration Reports of SQL inventory, Objects modified by Logins and Error reports.
  • Expertise in performance Tuning OLAP environments Implementing Data Partitioning, Compression, Efficient data purging, partition elimination queries.
  • Implement Data Encryption and Decryption on Databases and effective process and procedure for applications using symmetric key.
  • Automate a process to collect system and databases information using Catalog views and functions.
  • Coordinate with Network and storage team for Planning, building and Performance tune Blade chasis at datacenter level.
  • Experience of Database Administration, maintenance and production support of MYSQL 5.1 through third party tools like DB Artisan, Toad
  • Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
  • Expertise in SQL server Reporting Services (SSRS) to design and develop different reports of performance metrics.
  • Checking Database Health by using DBCC Commands and DMVS.
  • Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations.
  • Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
  • Created and managed schema objects such as tables, views, clusters, indexes, procedures and triggers and maintained Referential Integrity.
  • Generated Script files of the databases whenever changes are made to stored procedures or views and worked on Performance Tuning of the Stored Procedures.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part Security Policies.
  • Write T- SQL Scripts for database backup jobs and daily/weekly jobs.
  • Setting up High availability DR solutions over Azure. SQL Server Patching on 2005, 2008, 2008R2, 2012, 2014.
  • Creating and Maintaining Database Maintenance Plans. Optimized working process.
  • Migrate SQL databases and data sources to Relational cloud-based Azure platform (PAAS).
  • Rebuilding the indexes at regular intervals for better performance.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
  • Performance testing on stored procedures, indexes and triggers.
  • Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Environment : SQL Server 2014/2012/2008 R2/08/05, Windows 2003, 2008, 2008 R2, 2012 Servers, Azure, ADO.NET, Red gate, MS Visio, Microsoft SQL server Visual Studio 2005/2008, T- SQL, MS Business Intelligence Development Studio 2008, Fog Lite.

Confidential

SQL DBA

Responsibilities:

  • Managing and administering SQL Server 2000/2005/2008 R2/2012 production and non-production servers.
  • Documents created and compared databases to track changes in one of the database using Red Gate tool.
  • SSIS packages created to load warehouse databases from production databases.
  • Access databases created to generate reports according to needs of analysts.
  • Working with business unit closely and solve the issues immediately.
  • Databases restored from SQL Server 2005 to SQL server 2005/2008R2/2012 using generate scripts option.
  • Side by side migration of databases from SQL server 2000/ r2.
  • Configured minimum SQL server memory for one of the production server in case of server facing memory bottlenecks.
  • Did troubleshooting, performance tuning and query optimization using DMVs, profiler and performance monitor.
  • Installed and configuration of SQL Server 2008R2 and 2012.
  • Created maintenance plans for updating indexes.
  • Worked with developers and application teams to assign permissions and fixing security problems.
  • Configured and troubleshooting Merge replication, transactional and snapshot replication.
  • Creating Linked servers for distributed queries.
  • Data stage jobs scheduling and troubleshooting.

Environment: SQL Server 2000/20 R2/2012, replication, windows 2000/2003/2008 R2, 64 bit, SQL profiler, performance monitor, SSIS.

Hire Now