We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume

2.00/5 (Submit Your Rating)

Fortworth, Tx

PROFESSIONAL SUMMARY

  • Having 10+ years of experience as SQL Server Database Administrator 2016,2014,2012,2008, 2008R2, 2005, and 2000.
  • Installation, Backup & Restore, Security, LogShiping, Mirroring, Replication, Always - on, Clustering
  • Experience as Microsoft Windows Systems Administrator for Implementation and Support ofWindows 2012, Windows 2008 R2, 2008, 2003, 2000 and NT Servers on HP, Dell, IBM andUCS Blade Servers.
  • Strong experience in Upgrades from lower level to higher level version.
  • Worked on Configuration, Implementation and Maintenance for Disaster Recovery Solutions using Log Shipping, Database Mirroring and Replication such as Transactional, Snapshot & Merge replication in SQL Server 2016,2014,2012/2008/2005/2000.
  • Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (Lite Speed, SolarWinds, Redgate, sql dba SQL Sentry etc.)
  • Experience in configuring AlwaysOn wif High Availability (HA) and Disaster Recovery (DR)and Windows Server Failover Clusters, Contained Databases, Online Index Rebuilds, CDC, TDE
  • Experience in AWS design and Administration wif knowledge in EC2 and RDS
  • Experience in configuring AlwaysOn wif High Availability (HA) and Disaster Recovery (DR)and Windows Server Failover Clusters, Contained Databases, Online Index Rebuilds, CDC, TDE
  • Experience in AWS design and Administration wif knowledge in EC2 and AWS.
  • Participated in planning of Disaster Recovery Planning, Execution and Testing.
  • Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
  • Expert in Disaster Recovery plans by configuring Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
  • Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes
  • Basic T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers.
  • Extensive experience in controlling teh User Privileges, Monitoring teh Security and Audit issues as per Enterprise Standards plus good knowledge of Database Architecture & Modeling.
  • Experience in solving Database issues wif Index fragmentation, CPU Bottleneck, me/O Bottleneck, DBCC checks, Optimization of Query, Data Integrity, Index Tuning, Update Statistics, Error and Event Handling.
  • Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
  • Managing database systems using Query Governor and Activity Monitor.
  • Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
  • Good knowledge in Active Directory Configuration.
  • Expert in Database Capacity Planning and Maintenance.
  • Expert in database object change impacts analysis at teh database and application levels.
  • Supporting and configuring SQL Server Reporting Services.
  • Implementing efficient Database Design principles including Partitions and Compression techniques.
  • Experience in BCP (Bulk Copy Program) to take backup.
  • Hands-on Administration of teh Azure SQL DW / SSAS / SSRS platform including installs, upgrades and configuration of DB’s on teh Azure platform
  • Experience wif setup and scaling of Azure SQL DW instances, install of SSAS / SSRS client and server components
  • Powershell scripting-sql,
  • Execute and document SQL DW / SSAS / SSRS configuration including tuning changes for teh Development, Test and Production environments beyond initial configuration

TECHNICAL SKILLS

Databases: MS-SQL Server 2000/2005/2008/2008R2/2012/2014/2016

Languages: T-SQL

Operating systems: Windows 2012/2008/2003/2000

Backup Tools: REDGATE SQL Safe, LiteSpeed

Monitoring Tools: Idera, solarwinds, sscom, redgate

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server DBA

Responsibilities

  • SQL Server 2008 R2/2012/2014 Database Administration
  • Installed, managed and administrated MS SQL Server 2014/2012/2008R2/2008/2005 Production and Non-Production Servers.
  • Experience wif SQL monitoring tools - Red Gate; SQL Sentry
  • Migration of SQL Server 2008 R2 to 2012/2014.
  • Set up SQL server Clustering andAlways Ontechnologies
  • Extensive experience wif AWS (AWS Cloud Formation, AWS ECS and EC2), Azure SQL
  • Designed, Implemented and Migrated databases to AWS, Azure SQL
  • Used Microsoft Project to monitor and track; tasks and resources.
  • Setting databases wif company policies in place and deploy user data as requested by teh application teams.
  • Backed up SQL Server Databases participating in AlwaysOn Availability Groups and using Extended Events to Monitor SQL Server Availability Groups
  • Configured Transparent Data Encryption wif SQL Server 2012 Monitored AlwaysOn Availability Groups
  • Worked on Security Audit Logins, had deployed Audit on Development, QA, UAT environments
  • Worked on installation of MSSQL Server Module on Production and Non-Production Servers.
  • Configured AlwaysOn Availability Groups for DR and Reporting., Azure SQL
  • Worked wif Transparent Data Encryption (TDE), table compression, database compression and merge statements using SQL server 2012, Azure SQL
  • Worked extensively on Data Refreshes from Production to Test environments, automated teh whole data refresh process at database level using Power Shell scripts, stored procedures, Backups, and SQL Agent jobs wifout having any performance impact on Production server.Azure SQL
  • Monitored Log shipping/Transactional Replication and troubleshooting of errors.
  • Installed, configured Team Foundation Server (TFS). Also, Deployed code from TFS to SQL Server.
  • Use teh third part tools such asREDGATEfor comparing teh databases and to overwrite any changes on teh new servers, Azure SQL
  • Involved in teh migration of teh data across different databases and different servers using SSIS, BCP and Import/export tools.
  • Worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune teh databases, servers, and query tuning.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Extensively worked on Business Intelligence tools such as SSQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analytical tool (SSAS).
  • Implemented Database Mirroring and Transactional Replication as a part of DR plan.
  • Rebuilt indexes wif different fill factors and update statistics manually.
  • Written T-SQL code to automate teh SQL Server failed logins, SQL database restore jobs.
  • Configured PowerShell and ADO.NET connection String settings for SQL Server.
  • Used PowerShell to determine teh number of DML Operations in Scripts and PowerShell Script to delete old files of SQL Server
  • Extensively ImplementedServiceNowprocess of implementation for Incident Management, Problem Management, Change Management, Asset Management, Service Request Management (Service-Catalog)Experience in using Change Data Capture (CDC)
  • Ensure all database environments (Development, QA, UAT and Production) are coordinated (DB Refresh when requested).
  • Created DB objects such as Tables, Stored Procedures, Views, and Triggers as required.
  • Proactively monitored, determined and solved issues at SQL/database/server levels

Environment: SQL Server 2014/2012/2008 R2 /2008/2005 Enterprise Edition wif Clustering, OLTP & OLAP environment that includes Production (24x7), Service Now, Replication, Mirroring, Log shipping, Migration, Microsoft, Windows 2003/ 2008R2/2012, SQL Azure, SSIS, SSAS.

Confidential, Fortworth, TX.

Sr SQL Server DBA

Responsibilities

  • SQL Server 2008 R2/2012Database Administration/Development.
  • Updating database systems by reviewing, planning, testing and installing database security patches and service packs, SQL Azure,Aws
  • Design, document, and promote security "best practices", policies, standards and protocols.
  • Migrating application code and objects from development/test environments to production.
  • Working wif development and systems teams to perform application and database tuning.
  • Migrating Databases from SQL Server 2005 to SQL Server 2012, SQL Azure, Aws
  • Performed Backup/Restore by using VERITAS Net Backup.
  • Setup and maintenance of appropriate database and application monitoring.
  • Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
  • Providing highly available database and application infrastructure per Business Continuity requirements using SQL clustering, SQL Azure etc.
  • Evaluating data modeling, database administration, and database backup and recovery tools and provide recommendations.
  • Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
  • Responsible to Monitor and troubleshooting Log Shipping, SQL Azures
  • Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
  • Prepared Implementation Plan for every release inServiceNowand provide Walkthrough to teh entire team to execute teh steps.
  • Assist clients address business needs through teh application of theServiceNowplatform in support of ITIL best practices.
  • Deployed Extract Transform Load (ETL) packages using SQL Server Integration Services (SSIS).
  • Created Linked servers accordingly in between teh different servers based on teh requirement.
  • Created new database objects such as Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
  • Worked in Active, Active Passive Cluster environment as a High availability solution. Wif SQL Azure
  • Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup wif Microsoft Operations Manager and backup teams.
  • 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.
  • Checking Database Health by using DBCC Commands.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Prepared Documentation for teh Disaster Recovery plan
  • Daily routine DBA tasks such as handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
  • Responsible for routine DBA jobs such as Backups and Restores.
  • Supported different Oracle Environments such as Production, Development and Staging.
  • Performed basic DBA tasks such as monitoring, user management, permission management, creating database objects.

Environment: Windows 2000/2003/2008, MSSQLServer2000/2005/2008, MSCS, Microsoft IIS 6, SharePoint2007, Microsoft.NET, SSRS, SSAS, Oracle 9i, MS Office Access 2003, MS Visio Pro 2002.

Confidential, Phoenix, AZ

SQL DBA

Responsibilities

  • Installed SQL Server 2008/2008R2/2012 on Standalone and Clustered Environments.
  • Upgraded /Migrated of SQL Server from version 2005 to 2008 R2.
  • Installed Microsoft Service Packs/Patches/Hot fixes.
  • Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.
  • Created Tables, Stored Procedures, Views, Triggers, Cursors and Complex Queries on SQL Server 2005/2008.
  • Worked wif Transparent Encryption (TDE), table compression, database compression and merge statements using SQL server 2012.
  • Query Optimization and Performance tuning for optimization such as maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.
  • Analyzed Performance using Performance monitor to identify teh bottleneck such as CPU, memory, IO, paging and SQL Server and bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
  • Troubleshoot Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
  • Troubleshoot and resolved Blocking, Deadlocks and Long Running Queries.
  • Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
  • Utilized DMV’s, Data partitioning and Performance Dashboards reports wif SQL Server2005.
  • Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshoot Replication Problems.
  • Created and Managed SQL Server Logins and Users as per teh requirement wif specific roles and permissions on production servers.
  • Provide 24X7 support for teh Critical issues such as Server Failures and Database inconsistencies such as Database Log File full, Suspect, Offline, Missing log files etc.

Confidential, Irving, TX

SQL Database Administrator

Responsibilities

  • Installed and configured SQL Server 2008, 2008 R2 and maintained 100 servers.
  • Upgraded and migrated teh servers from SQL Server 2000 to SQL Server 2005
  • Migrated SQL Server 2000 DTS Packages to SQL Server 2005, 2008, 2008 R2 SSIS packages and resolved issues during migration.
  • Migrated Stored Procedures from 2000 to SQL Server 2005 to refer to Dynamic Management Views.
  • Implemented Replication and Log Shipping to overcome Disaster Recovery Plan.
  • Suggested Disk Capacity, Processors and Memory based on teh Capacity planning.
  • Analyzed database growths for Capacity Planning, Normalized teh data for efficient performance and Partitioned data into multiple Files and File groups.
  • Implemented backup and retention strategies based on business policies.
  • Used SQL Profiler to monitor teh server performance, debug T-SQL and slow running queries.
  • Monitored teh application & database performance using SQL Profiler, Performance Monitor.
  • Used Index tuning wizard to get a better idea of implementing indexes on teh existing databases and rebuilding only necessary indexes for faster query response.
  • Extensively used Database Tuning Advisor to improve teh performance of Query.
  • Implemented and maintained SQL Server Agent Jobs, Monitor SQL Server Agent Job history.
  • Created SSIS Packages to (ETL) Extract, Transform and Load teh data into Reporting instance to generate teh reports easily and quickly.

Confidential, Louisville, KY

Jr. SQL Database Administrator

Responsibilities

  • Planned and Successfully Installed SQL Server 2000, 2005 on teh Production and Development Servers.
  • Developing teh successful Backup strategies based on Recovery models.
  • Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
  • Administration of all database objects such as Indexes, Views and Tables
  • Involved in implementation of replications such as Transactional.
  • Implement and creation of security policies and controls, user access and role management
  • Implementing Database maintenance plan for Database consistence & Integrity.
  • Export or Import data from other data sources such as flat files using Import/Export through DTS, SSIS.
  • Created various Jobs scheduled& ran jobs and troubleshoot teh failed jobs.
  • Monitoring SQL server performance using profiler to find teh performance and dead locks.
  • Creating teh Jobs using maintenance Plans for Full, Differential and transactional log backups.
  • Maintaining and Monitoring Production, Pre-Production and Development database server environment.
  • Having good knowledge on creation and scheduling of T-SQL jobs to run daily.
  • Improved performance of slow running queries using Profiler and Statistics me/O by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.

We'd love your feedback!