We provide IT Staff Augmentation Services!

Sql Server Dba  Resume

SUMMARY:

  • 3+ years of experience in Database Administration for different applications as a SQL Server DBA Consultant.
  • Experience in Installation of SQL Server configuring server options, Creating and managing Database for SQL Server. Applying SQL Server latest Service Packs and Security updates.
  • Good Experience in high availability and recoverability of databases in 24/7 environment by using clustering, replication, mirroring, log shipping, backup and restore to meet RTO/RPO objectives.
  • Experience in deploying, configuring and administering Always On: Availability Groups.
  • Upgrading/Migrating SQL Server to higher versions 2008, 2012, 2014.
  • Strong command of performance tuning and proven experience in troubleshooting performance problems (Indexing, Optimizer, server configuration, Profiler, DMV etc.) including TSQL programming and debugging skills.
  • Expert in implementing High Availability options Failover Clustering, Log shipping, Mirroring and Replication (Transactional, Snapshot & Merge) and migration.
  • Experience in SSIS packages and SSRS reports deployment.
  • Experience in creating Security by setting up groups and then logins for each Roles or Users for Maintenance of Databases.
  • Expertise in dimensional modeling in Star and Snowflake models.
  • Proficient in implementing different types of Replication models like Snapshot, Transactional, Merge and Peer - Peer.
  • Excellent T-SQL skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, User defined data types, Cursors and functions.
  • Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans.
  • Experience in Managing and Configuring Backup and Recovery strategies for Databases.
  • Working knowledge in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) to manage ETL environment.
  • Proficient with Client/Server tools like SQL Server Enterprise Manager, SQL Server management studio and Query Analyzer to Administer SQL Server.
  • Exposure to multiple database platforms like Oracle, MySQL and Mongo DB.
  • Experience in working with huge databases, troubleshooting issues and documenting the causes.
  • 24 X 7 Production Database on Call Support.
  • Excellent communication and inter-personal skills, technical documentation and reporting skills, accustomed to working in both large and small team environments.
  • Good leadership qualities to support the goals of the organization.

TECHNICAL SKILLS:

Databases: MS SQL Servers 2000, 2005, 2008, 2008r2, 2012 and 2014,Mysql, Tableau, Oracle 11g, 10g, 9i, PostgreSQL, SQL Azure and AWS.

SQL Server Tools: SQL Server management studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, Perfmon, DTA, TOAD, TKPROOF, Enterprise manager and IMPORT/EXPORT.

Languages: SQL, T-SQL, PL/SQL, SQL*Loader, XML, Shell scripting, Visual Studio, ASP.NET, LINQ,VB.NET, C#.

Design Tools: Magic Draw, Rational Software Architect, Visio, Erwin

Operating Systems: Windows, Linux, Ubuntu

PROFESSIONAL EXPERIENCE:

Confidential, Union, NJ

SQL Server DBA

Responsibilities:

  • Working as a Production DBA and Responsible for performance of the SQL Server instance and safety of the data in database.
  • Installed and Configured SQL Server 2014, 2012 and 2008r2 in enterprise cluster and standalone environments.
  • Migration of databases from SQL Server 2005 to SQL Server 2008r2 and SQL Server 2012.
  • Working Knowledge on AWS and Azure cloud technologies.
  • Configured, tuned and maintained MySQL database servers.
  • Solid hands - on skills in migrating/upgrading SQL Server 2005 to 2008/2008R2&SQL Server 2005, 2008/2008R2 to 2012 and .2014 and applying service packs, extensive experience in migrating and new installations of SQL Server on Hyper-V and VMWARE environments.
  • Responsible for working on different kinds of Replication on the Production Servers.
  • Involving in Database creation, Backup, Restoration, Recovery and Space Management.
  • Creating SQL jobs to extract data from available databases to tables and flat files.
  • Performing various point in time recoveries of various SQL Server databases in production and test environments.
  • Work with windows team to failover the cluster if needed after windows patching.
  • Working with developers to tune SQL queries to improve the performance.
  • Working on LINQ for query the data objects in C++, C#, VB.net.
  • Distributing huge tables to different file groups to maximize the performance.
  • Monitored and modified performance using execution plans with query hints and index tuning.
  • Migrated Oracle databases to SQL Server for SAP migration.
  • Worked on High Availability Disaster Recovery during SQL 2014 migration.
  • Frequently maintaining the databases and reorganizing the defragmented the data.
  • Created SSIS packages to load robust data from different Heterogeneous data sources like Oracle, DB2 to SQL Server.
  • Creating views, store procedures and optimizing them as required by the front-end developers for easier implementation on web pages and performance testing on store procedures, indexes, and triggers.
  • Performing database consistency checks with DBCC, Defrag, Index tuning and monitoring error logs.
  • Configured and managed virtual servers.
  • Experience in implementing and migration databases to Microsoft Cloud Environment.
  • Created DB master key, symmetric keys, asymmetric keys and certificates for encryption.
  • Scheduling the jobs using SQL Server agent and providing the security to databases.
  • Maintaining database consistency with DBCC at regular intervals, Managed Disk space and memory, User connections and Monitored SQL Server performance using profiler to find performance and deadlocks.
  • AWS migration- RDS and EC2 instance creation and administration.
  • Troubleshooting the issues using outputs of SQL Trace, SQL Diag, error log, Blocker script and event log.
  • Performing partition for efficient management database tables and indexes.
  • Utilizing the SQL Server tools like SQL Server Profiler, Perfmon, and Index tuning wizard, Database tuning advisor and Activity monitor to optimize the queries and improve the performance of database servers.
  • Created a dimensional data warehouse and converted the Oracle database to Amazon AWS Redshift cloud environment due to enterprise data move to cloud solution.
  • Scheduling and Maintaining FULL, DIFF, and LOG database backups as per the company strategy to meet the recovery point objectives.
  • Providing 24/7 support for critical production databases (OLTP and OLAP).

Environment: SQL Servers (2014,2012 and 2008r2), DBCC, Defrag, SQL Server profiler, Perfmon, SQL Diag, SQL Trace, VMWare, Index Tuning Wizard, DTA, AWS, Oracle, OLTP and OLAP.

Confidential, Weehawken, NJ

Jr. SQL DBA

Responsibilities:

  • Database Administrator/Database Programming/Product specialist.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
  • Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
  • Extensively worked on compliance issues.
  • To analyze long running slow queries and tune the same to optimize application and system performance.
  • Worked on key performance indicators for customizable metrics.
  • To set up SQL Server configuration settings.
  • Monitoring SQL server performance using profiler to find performance and dead locks.
  • Rebuilding the indexes at regular intervals for better performance.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
  • Involved in trouble shooting and fine - tuning of databases for its performance and concurrency.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Rebuilding the indexes at regular intervals for better performance.
  • Using log shipping for synchronization of database.
  • To setup, implement, and maintain industry standards in database management.
  • Monitoring SQL server performance using profiler to find performance and dead locks.
  • Monitoring the servers using spot light third party Quest software.
  • Implemented the online indexing on 24X7 environments.
  • Migrated data to new location using Snapshot Replication, and implemented Transactional Replication to support up to date record of Inventory Information.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedure.
  • Involved in DATA Analysis like Analyzing and Accessing collection of Data.
  • To analyze long running slow queries and tune the same to optimize application and system performance.
  • To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
  • To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
  • To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases

Environment: SQL Server with clustering, Replication, T-SQL, Windows 64-bit, SQL, PL/SQL, DTS, SSIS, Profiler.

Hire Now