We provide IT Staff Augmentation Services!

Sr Sql Dba Resume

Oak Brook Chicago, IL

SUMMARY

  • 12+ years of experience as SQL Server Database Administrator (2017,2016,2014,2012, 2008,2008R2, 2005, and 2000) expertise in Installation, Configuration, Patches, Upgrades & Administration for SQL Servers in Clustered (Failover) & Non - Clustered Environments.
  • AWS Solution Architect - Associate Level (EC2,EBS,S3,Glacier,RDS,Dynamo DB,RedShift,VPC,Load Balancer)
  • Hadoop Administration(installation, configuration, supporting and managing Hadoop Clusters using Apache 1.X, 2.X, Cloudera - CDH4, CDH5,HottonWorks, Flume,Oozi)
  • Oracle Administration (installations, Backups, user Permissions,DataGuard)
  • MYSQL Administration (installations, backups, user Permissions,Replication)
  • Managing Large Size of SQL Server Databases up to 6TB
  • 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 (LiteSpeed, SolarWinds, Redgate, sql dba SQL Sentry etc.)
  • Experience in configuring AlwaysOn with 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 with 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 the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards plus good knowledge of Database Architecture & Modeling.
  • Experience in solving Database issues with Index fragmentation, CPU Bottleneck, I/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,Hyper v FrameWork
  • Good knowledge in Active Directory Configuration.
  • Expert in Database Capacity Planning and Maintenance.
  • Expert in database object change impacts analysis at the database and application levels.
  • Supporting and configuring SQL Server Reporting Services.
  • Implementing efficient Database Design principles including Partitions and Compression techniques.
  • Certified in ITIL Foundation and implemented ITIL best practices in supporting projects.
  • Experience in BCP (Bulk Copy Program) to take backup.
  • Proven ability to work effectively and collaboratively, with internal business and technical teams, vendors and consultants.
  • Worked closely with application developers and business users to assist in the planning and execution of the database and jobs upgrades across the Development, Test and Production environments.
  • Hands - on Administration of the Azure SQL DW / SSAS / SSRS platform including installs, upgrades and configuration of DB s on the Azure platform
  • Experience with setup and scaling of Azure SQL DW instances, install of SSAS / SSRS client and server components
  • Powershell scripting,t-sql Execute and document SQL DW / SSAS / SSRS configuration including tuning changes for the Development, Test and Production environments beyond initial configuration
  • Unix and linux Administration

TECHNICAL SKILLS

Databases: MS-SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016 , SQL Aure,IAAS,PAAS

Languages: T-SQL, PL/SQL, C, C#, HTML, VB.NET, XML,Linux,unix

Operating systems: Windows 2012/2008/2003/2000 , Azure VM,Hyper-V

Software Packages: MS Office 97/2000/XP, 2003, 2007, MS Outlook 2003, 2007, MS Project

Backup Tools: REDGATE SQL Safe, LiteSpeed

Data Modelling Tools: ER/Studio, MS Visio

Monitoring Tools: Idera,solarwinds,sscom,redgate

PROFESSIONAL EXPERIENCE

Confidential

Sr Sql dba

Responsibilities:

  • SQL Server 2008 R 2/2012/2014/2016 /2017 Database Administration.
  • Installed, managed and administrated MS SQL Server 2016/2014/2012/2008 R2/2008/2005 Production and Non-Production Servers.
  • Hands on experience on 2016 Stretch Database
  • Created 2016 Distributed Availability Groups
  • Know ledge on 2016 Live Query Statistics
  • Experience In-Memory OLTP
  • Installed TempDB with 2016 New Feature Files
  • Experience with SQL monitoring tools - Red Gate; SQL Sentry
  • Migration of SQL Server 2008 R2 to 2012/2014.
  • Set up SQL server Clustering andAlwaysOntechnologies
  • AWS Solution Architect - Associate Level (EC2,EBS,S3,Glacier,RDS,Dynamo DB,RedShift,VPC,Load Balancer)
  • Designed, Implemented and Migrated databases to AWS, Azure SQL
  • Migration from MSSQL Server to AWS SQLServer(RDS,EC2)
  • Migration from MSQL Server to MySQL Servers with SQL workBench
  • Used Microsoft Project to monitor and track; tasks and resources.
  • Setting databases with company policies in place and deploy user data as requested by the 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 with 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 with 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 the whole data refresh process at database level using Power Shell scripts, stored procedures, Backups, and SQL Agent jobs without 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 the third part tools such asREDGATEfor comparing the databases and to overwrite any changes on the new servers, Azure SQL
  • Involved in the migration of the 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 the 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 with different fill factors and update statistics manually.
  • Written T-SQL code to automate the SQL Server failed logins, SQL database restore jobs.
  • Configured PowerShell and ADO.NET connection String settings for SQL Server.
  • Used PowerShell to determine the 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)
  • Working as aDeveloperto incorporate the requirements in theServiceNowtool in an optimal way.
  • Debug and fine tune the application code SQL for the optimal performance of the database.
  • Experience in Maintaining SQL Server Security including the creation of logins and users, configuring permissions, and assigning roles to users as required.
  • Configured Database alert scripts such as database size increase, log size full, maintenance script for all SQL Server versions.
  • Used Database Consistency Checks- DBCC commands for database maintenance
  • Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools such as Profiler and the Activity Monitor
  • Running Index Tuning wizard for optimal query performance
  • Performed all aspects of database administration, including backups andrecovery
  • Handled orphaned users while moving databases.
  • Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP.
  • Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
  • 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 2017/ 2016/2014/2012/2008 R2 /2008/2005 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Service Now, Replication, Mirroring, Log shipping, Migration, Microsoft, Windows 2003/ 2008R2/2012, SQL Azure, SSIS, SSAS,Ec2

Confidential, Oak Brook, Chicago IL

Sr Sql dba

Responsibilities:

  • SQL Server 2008 R 2/2012/2014/2016 Database Administration.
  • Participated in tera data to Redshift (AWS)
  • Users,roles,Vacumm,cloud watch(alerts) on Redshift (Aws)
  • Installed, managed and administrated MS SQL Server 2016/2014/2012/2008 R2/2008/2005 Production and Non-Production Servers.
  • Hands on experience on 2016 Stretch Database
  • Created 2016 Distributed Availability Groups
  • Know ledge on 2016 Live Query Statistics
  • Experience In-Memory OLTP
  • Installed TempDB with 2016 New Feature Files
  • Experience with SQL monitoring tools - Red Gate; SQL Sentry
  • Migration of SQL Server 2008 R2 to 2012/2014.
  • Set up SQL server Clustering andAlwaysOntechnologies
  • AWS Solution Architect - Associate Level (EC2,EBS,S3,Glacier,RDS,Dynamo DB,RedShift,VPC,Load Balancer)
  • Designed, Implemented and Migrated databases to AWS, Azure SQL
  • Migration from MSSQL Server to AWS SQLServer(RDS,EC2)
  • Migration from MSQL Server to MySQL Servers with SQL workBench
  • Used Microsoft Project to monitor and track; tasks and resources.
  • Setting databases with company policies in place and deploy user data as requested by the application teams.
  • Knowledge in PDW
  • APS or PDW combines SQL Server and Hadoop into a single offering that Microsoft is touting as providing “big data in a box”
  • Backed up SQL Server Databases participating in AlwaysOn Availability Groups and using Extended Events to Monitor SQL Server Availability Groups
  • Configured Transparent Data Encryption with 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 with Transparent Data Encryption (TDE), table compression, database compression and merge statements using SQL server 2012, Azure SQL

Confidential, New York, NY

Lead associate

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 with 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.
  • Migration from MSSQL Server to AWS SQLServer(RDS,EC2)
  • Migration from MSQL Server to MySQL Servers with SQL workBench
  • 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 the entire team to execute the steps.
  • Assist clients address business needs through the 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 the different servers based on the 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. With SQL Azure
  • Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with 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 the 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.

Confidential, Redmond, WA

Senior SQL Database Administrator (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 with 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 the 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 with 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 the requirement with specific roles and permissions on production servers.
  • Provide 24X7 support for the Critical issues such as Server Failures and Database inconsistencies such as Database Log File full, Suspect, Offline, Missing log files etc.

Confidential, McLean, VA

Senior SQL Database Administrator (DBA)

Responsibilities:

  • Installed and configured SQL Server 2008, 2008 R2 and maintained 100 servers.
  • Upgraded and migrated the servers from SQL Server 2000to 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 the Capacity planning.
  • Analyzed database growths for Capacity Planning, Normalized the 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 the server performance, debug T-SQL and slow running queries.
  • Monitored the application & database performance using SQL Profiler, Performance Monitor.
  • Used Index tuning wizard to get a better idea of implementing indexes on the existing databases and rebuilding only necessary indexes for faster query response.
  • Extensively used Database Tuning Advisor to improve the 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 the data into Reporting instance to generate the reports easily and quickly.

Confidential, Louisville, KY

Senior SQL Database Administrator (DBA)

Responsibilities:

  • Planned and Successfully Installed SQL Server 2000, 2005 on the Production and Development Servers.
  • Developing the 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 the failed jobs.
  • Monitoring SQL server performance using profiler to find the performance and dead locks.
  • Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
  • Maintaining and Monitoring Production, Pre-Production and Development database server environment,Hyper-V
  • Having good knowledge on creation and scheduling of T-SQL jobs to run daily.
  • Improved performance of slow running queries using Profiler and Statistics I/O by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.

Hire Now