We provide IT Staff Augmentation Services!

Sr Sql Server Dba Resume

Chandler, AZ

SUMMARY:

  • Overall 7+ years of IT experience and extensive experience in MS SQL SERVER 2016, 2014, 2012, 2008R2, 2008 and 2005 Database Administration in Production, Test and Development environment.
  • Involved in all phases of Software Development Life Cycle (SDLC) and worked on all activities related to the design, development, implementation, administration and support for SQL Server.
  • Experience in Installing, Configuring and Maintaining of MS SQL Server 2016, 2014, 2012, 2008R2, 2008 and 2005.
  • Expertise in installing Slipstreams, rolling patches, rolling upgrades in Clustered environment.
  • Experience in Upgrading and Migrating in and from SQL Server 2016, 2014, 2008R2, 2008 and 2005.
  • Experience on SQL Server 2005, 2008, 2012, 2014, 2016 tools like SQL Server Management Studio (SSMS), SQL Server Profiler, SQL Server Agent, Execution Plan, Performance Monitor, Database Consistency Checks (DBCC) commands and troubleshooting and SQL Server Surface Area Configuration, Database Engine Tuning Advisor.
  • Experience in Maintaining High Availability and Disaster Recovery using Failover Clustering, Database Mirroring and Log shipping capabilities of MS SQL Server 2005, 2008, 2008R2 to provide robust database solutions.
  • Experience in configuring and managing Always - on Availability Group feature with multiple replicas synchronously and asynchronously in SQL Server 2012 and 2014 version.
  • Experience in deploying Active/Passive and Active/Active Cluster.
  • Experience in implementing different types of Replication Models like Snapshot and Transactional according to the business requirements.
  • Hands on experience in configuring Tempdb with considerable Memory and Raid Levels for better performance.
  • Experience in performance tuning of complex SQL statements and procedures using show plan.
  • Experience in writing scripts to automate day-to-day maintenance activities using PowerShell and converting existing T-SQL batch scripts to PowerShell scripts to improve the job performance.
  • Experience in creating and maintaining Data Warehouses using SQL Server.
  • Experience in creating maintenance plans to perform index defragmentation, re-indexing and update Statistics.
  • Worked on Full, Differential and Transaction log backups, restoration, scheduling the back-up jobs for System and User databases and restoring them based on the requirement.
  • Experience in creating triggers, tables, user-defined functions, views, indexes and user profiles.
  • Experience in creating roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.
  • Good experience in utilizing the Teradata tools and Console Utilities.
  • Extensive knowledge on Teradata View point Alert setup and configurations.
  • Worked on AWS service such as RDS, EC2, S3.
  • Deploying and managing applications in Datacenter, Virtual environment and Azure platform as well.
  • Migrated SQL Server 2008 database to Windows Azure SQL Database and updating the Connection Strings.
  • Worked Extensively on ETL process using SSIS packages.
  • Data Modeling Experience including Physical and Logical data modeling using Erwin tool.
  • Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe.
  • Hands on generating different types of Reports using SQL Server Reporting Services (SSRS).
  • Good Team player, Strong Communication and interpersonal skills with Self-motivation.
  • Provided 24 x 7 Production support for the database and application issues.

TECHNICAL SKILLS:

Relational Databases: - SQL Server 2016/2014/2012/2008 R2/2008/2005, MS-Access 2000 2003/2007/2010, MySQL 4/5, Oracle 9i/10g.

Database Tools: - Management Studio, Query Analyzer, SQL Profiler, Business Intelligence Studio, Crystal Reports.

Languages: - JAVA, C, HTML, XML, SQL, T-SQL.

Operating Systems: - Windows 2012/2008/2005/2000, Windows 98/ XP/ Professional, Unix.

Web Servers: - IIS 5.0/6.0/7.0, Apache, Tomcat, Amazon web services (AWS), Service Center, Virtual Private Cloud (VPC).

Architecture: - Relational DBMS, Client-Server Architecture, Clustering, ReplicationOLAP: OLTP.

ETL: SSIS, SSRS, DTS.

Other Tools: - Github, Jenkins, Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005 /2008, MS Visual SourceSafe, Source Control, Windows System monitor.

PROFESSIONAL EXPERIENCE:

Confidential, Chandler, AZ

Sr SQL Server DBA

Responsibilities:

  • Installed and configured SQL Server 2016, 2014 and 2012 Enterprise and Standard edition in the Production, Development and Test environments.
  • Extensive experience in configuring Always-on Availability Group with multiple replicas synchronously and asynchronously in SQL 2012 and 2014
  • Installed, configured SQL Server 2014 Clustering on Microsoft Clustering services (MSCS) for Active-Passive and Active-Active Cluster Nodes.
  • Scheduling and implementing Patching activities i.e. Service packs and Cumulative upgrades as per baseline standards.
  • Involved in Migration of databases both side by side and in-place from SQL Server 2012 to 2014.
  • Extensive experience in configuring Mirroring, Replication and Log Shipping solutions for MS SQL Server databases.
  • Worked on configuring Snapshot Replication and Transactional Replication.
  • Worked on creating a new Application database from the scratch, and deploy them in Dev, QA and Production environments.
  • Developed and Optimized Stored Procedures, Views and User-Defined Functions for the Application.
  • Extensively worked on Profiler, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
  • Assigned tickets and complete the work as requested by creating tables , views , functions and stored procedures in Dev and QA databases.
  • Create change orders with implementation instructions by deploying scripts in Production environments.
  • Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
  • Responsible for maintaining SQL Server Security and granting access to users as per requirement and database security policies .
  • Used DMV's to diagnose problems and monitor health of server instances.
  • Worked on creating and maintaining jobs like Integrity Check, Rebuild Indexing, Update Statistics and clean up Jobs.
  • Detected and Resolved Locks and Deadlocks using the Trace Flags T and Native tools like Profile and the Activity Monitor.
  • Performed Backup and recovery plans; Automation of Backups using maintenance plans.
  • Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
  • Analyze the Disk Space of the target server for the new database, if the disk space is not enough to add more space on the target server.
  • Expertise in data Extraction, Transformation and Loading ( ETL ) tools.
  • Extensively worked on SQL Server Reporting Services (SSRS) for creating the reports based on the requirements.
  • Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from other sources to SQL databases.
  • Experience in Migrating the on-premises Databases onto AWS Cloud Environment.
  • Experience in Planning and analyzing Migration requirement of application by coordinating with various application support team.
  • Resolving Migration issue & come up with solutions. Support post Migration activities
  • Experience in using AWS services such as Redshift, EC2, S3.
  • Worked in the Agile environment.
  • Involved in writing System Documentation and Code Documentation.
  • Participated in on-call rotation and worked with production support team for ticket resolution.
  • Providing 24/7 On-Call supports for critical production databases.

Confidential, Richardson, TX

SQL Server DBA

Responsibilities:

  • Installation of SQL Server 2012 and 2014 Enterprise and Standard Edition on VMware Machines.
  • Installations and Configurations of SQL Server 2012 Cluster with Active/Passive cluster, in addition to that we configure Always-On availability group.
  • Involved in Migrating databases from SQL server 2008/2008R2 to SQL server 2012 and SQL Server 2012 to SQL Server 2014.
  • Setup and Configuration of Always-On Availability Groups (AAG) and HA/DR .
  • Configured High Availability and Disaster Recovery plans like Clustering , Mirroring and Log Shipping methodologies.
  • Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
  • Implemented and configured Central Management Servers to centralize and manage about 30 instances of SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.
  • Scheduling and implementing patching activities i.e. Service packs and Cumulative upgrades as per baseline standards.
  • Created stored procedures, views, triggers, user-defined functions to apply business rules to the data.
  • Perform the activities by Backing up the databases and restoring them in different environments.
  • Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
  • Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates.
  • Created logical and physical design of new database to fit new business requirements and implemented new design into SQL Server.
  • Created and scheduled maintenance plans (database and log backups and cleanups).
  • Used server scoped DMV’s and database scoped DMV’s to troubleshoot issues.
  • Monitor the bottlenecks of Blocking, Deadlocks, CPU, Memory, Network and Disk IO on SQL Server Instances using Perfmon and Idera Diagnostic manager.
  • Identified and analyzed deadlocks in databases using SQL Server Profiler.
  • Involved in full life cycle of the project from Requirement analysis, Design, Development and Test
  • Analyzed the requirements and significantly contributed in developing database architecture for the application.
  • Troubleshooting and fine-tuning of databases for its performance and concurrency.
  • Checking the SQL Error logs for any errors that may have occurred overnight .
  • Experience in providing security permissions and enabling fire walls on SQL Azure databases.
  • Deploying and managing applications in Datacenter, Virtual environment and Azure platform as well.
  • Migrated SQL Server 2008 database to SQL Azure Database and updating the Connection Strings.
  • Managing ETL implementation and enhancements, testing and quality assurance, troubleshooting issues and ETL/Query performance tuning.
  • Designed and implemented custom solutions using Waterfall mythologies.

Confidential . Medford, MA

SQL Server DBA

Responsibilities:

  • Installed and Upgraded from SQL Server 2005 to SQL server 2008 and SQL Server 2008R2 to SQL Server 2012 on various Dev , QA and Production Servers.
  • Worked in Active/Active Cluster environment as a High availability solution.
  • Experience in setting up Database Mirroring on Production and QA servers.
  • Configured and monitored Replication methods like snapshot and transactional replications.
  • Used log shipping for synchronization of databases.
  • Prepared Documentation for the Disaster Recovery plan.
  • Managing Databases spread across multiple servers in Production , Development , Staging and Testing environments.
  • Handled monthly Database Refresh in QA, UAT environment for testing of new Deployments and Build.
  • Planned the Complete Backing-up of Database and restoring the Database from Disaster Recovery.
  • Checking Database Health by using DBCC commands and DMV's.
  • Monitor SQL Server Instances across the environment using redgate SQL Monitor tool, to capture deadlocks, locks, query plans, database growths and so on.
  • Tuning queries which are running slow using SQL Monitor by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
  • Compare and synchronize your database schemas or data by using redgate .
  • Monitor Zabbix alerts and resolve the alerts with necessary tools.
  • Managed Commvault backup tools to manage backups on Dev, QA, UAT and Production environments.
  • Experience in Database security and integrity planning .
  • Designed Data Integrator jobs with Error Handling and email notifications.
  • Performed daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
  • Automated DBA jobs like Full , Differential and Transactional log Backups and Restores .
  • Implemented SQL Data Compression for compressing Data and Log Files .
  • Monitored and modified Performance using Execution plans and Index tuning .
  • Expert in configuring Tempdb.
  • Created complex Stored Procedures , Triggers , Cursors , Tables and other SQL Joins statements for applications by using T- SQL.
  • Recovered the System and User databases from Suspect mode
  • Worked with the table Partitioning ( Sql Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level
  • Worked with Transparent Encryption , Table compression , Database compression and Merge statements using SQL server 2008.
  • Used Policy Based Administration feature ( SQL Server 2008).
  • Rendered Reports to Microsoft Word using SQL Server 2008.
  • Designed the functional and technical documents , Report templates and reporting standards for the developers to work on the report development.
  • Good experience in data modeling and metadata services .

Confidential

SQL Server DBA

Responsibilities:

  • Installed SQL Server 2005/2008/2008R2/2012, on windows 2008 and 2003 servers, applied Service packs and Security Patches for all servers.
  • Installed, configured and maintained MS-SQL failover cluster to provide server high availability solution for 6 different environments.
  • Involved in setting up database Mirroring for production server.
  • Configured replication methods like snapshot and transactional replications.
  • Planned the Complete Backing-up of Database and restoring the Database from Disaster Recovery.
  • Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Planned and modified the permission issues in the server.
  • Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
  • Created Database Maintenance Plan for the Performance of SQL Server which covers.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Interacted with concern application team in fixing the problems whenever needed.
  • Created performance baseline reports using RML tool and documented for future use.
  • Interacted with concern application team in fixing the problems whenever needed.
  • Monitoring and scheduled jobs on production and staging environment.
  • Used the Execution Plan to improve the optimization of the T-SQL code.

Confidential

SQL Server Developer/DBA

Responsibilities:

  • Involved in various stages of SDLC like Design (Logical and Physical), Development, Implementation and Testing.
  • Upgraded SQL server 2005 to SQL Server 2008 on Standalone and Clustered environments and applied Service pack..
  • Troubleshooting High Availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
  • Experience in setting up and Monitoring transactional replication, Database mirroring on Production and QA servers.
  • Routine DBA jobs like Full , Differential and Transactional log Backups and Restores.
  • Creating, maintaining the users, roles and granting privileges.
  • Performance tuning, and optimization of procedures and queries.
  • Involved in writing queries and optimizing the performance of the queries.
  • Worked with SQL server Profiler.
  • Written complex stored procedures and functions according to business requirements.
  • Used BCP utility to publish table output to text files.
  • Involved in creating complex tables, views, indexes, cursors and stored procedures.
  • Involved in creating data models and designing logical and physical models of database.
  • Worked on database schema changes and Database Restore requests
  • Gave training sessions to the end users for the new product such as using the product.

Hire Now