SUMMARY:

DBA with over 6 years of experience as an SQL SERVER Database Administrator . Worked on SQL SERVER 2017/ 2016/2014/2012/2008 Versions. Work areas include production and development and test support, installation and configuration, backup and recovery, performance tuning, database cloning, and refreshes, security, database upgrades, and patching, database migration, Always on, clustering, log shipping, Mirroring and replication technologies.

TECHNICAL SKILLS:

Environment: Windows 2012/2008/2003/2000/ NT4.0, VMware, MS - SQL Server 2016/2014/2012/2008 R2/2008, SSIS, SSRS, SSAS, PowerShell, System Monitor / Performance Monitor, SQL -Profiler, Foglight, Lite Speed, Red Gate

PROFESSIONAL EXPERIENCE:

SQL SERVER DBA

Confidential, Detroit, Michigan

Responsibilities:

• Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD, DFD) along with extensive knowledge of Relational Database Management Systems with in - depth of T- SQL .
• Experience in creating Maintenance plans for backups, indexing and database integrity check, update database stats using SQL server native tools and OLA Hallengren’s scripts.
• Experience in different types of backups, restoration of the database and using SQL Server agent to schedule jobs and Maintenance Plans and set Database Mail settings for notifications or alerts.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Created Jobs and maintenance plans for better performance of the server some of the jobs include index rebuild/reorgs, DBCC check, update database stats, database cleanup and other SSIS packages to help with data migration .
• Created alerts with database mail Simple Mail Transfer Protocol (SMTP).
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Setup and maintained Linked Servers .
• Implemented Transparent Data Encryption (TDE) to protect sensitive data and backups.
• Used Database Consistency Checks - DBCC Commands for database maintenance.
• Experience in managing database security by creating logins, users, groups and assigning them just the required privileges.
• Also experience implementing database audits and reviewing audit logs in case of any database security abnormalities.
• Hands on experience in troubleshooting database issues, update statistics, backup and restore operations.
• Maintained database response times in 24/7 Production environments, proactively generated performance reports. Automating most of the DBA jobs and monitoring stats.

SQL SERVER DBA

Confidential, Houston, TX

Responsibilities:

• Experience in implementing High availability solutions like Replication (Snapshot, Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
• Experience on setting up/configuring Always on Availability Groups and Node Clustering
• Experience in conducting Performance Tuning, Query Optimization and Client/ Server Connectivity, Database health Check, Indexing and Updating Statistics etc.
• Extensively used the native tools like Index Tuning Wizard or Database Engine Tuning advisor, SQL Profiler, Performance Monitor, Activity Monitor, DMV’s, SQL server error log and Event viewer for performance analysis and fix any performance related issues, ensuring optimum performance.
• Expertise in designing and implementing the processes and standards for database systems recovery and back-up checks as well as user performance and data security.
• Experience analyzing current database performance and making projections for future growth (CPU usage as well as storage growth) and fix data corruption.
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held and avoid keeping transactions open for long durations after completion depending on app logic, breaking large transactions to smaller ones.
• Knowledgeable in T- SQL Development skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Queries.
• Experience in Creating Databases and setting up connection string and connecting SQL Server Azure Databases from locally Installed SSMS for Developers
• Contributed to automation of many daily administrative activities like backups, thresholds, monitoring server resources and proactive problem diagnosis.
• Expertise in troubleshooting SQL Server Agent jobs, Error Logs, Windows Logs to resolve failure job component.
• Administered multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in Implementing Side by Side Migration and in-place upgrade of MS SQL SERVER. Implement over 200+ database migration from SQL SERVER and from using best practice and troubleshooting related issues post migrations
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Familiarity with using third party tools like Lite Speed, Fog light, IDERA, DB Moto, SQL Compare and Red gate Products
• Experience with moving data across servers using BCP, BULK INSERT, Imported and Exported data from different Data Sources using SSIS tools.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.
• Excellent Problem-Solving Skills, Communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.

SQL SERVER DBA

Confidential, DALLAS, TX

Responsibilities:

• Day-to-day DBA responsibilities for backups, server uptime, performance tuning and optimization of code developed by developers.
• Successfully migrated from SQL server 2008 to SQL server 2012 and SQL Server 2014. Implementation and Support of Always On High Availability Group.
• Performance tuning of slow running queries and providing timely advice on Indexes and query logic.
• Monitoring SQL Servers through Spotlight for SQL Servers and resolving various alerts generated by systems.
• Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using the ticketing tool Service Central/Now.
• Comprehensive experience utilizing VMware technologies in the deployment of mission critical SQL Server environments
• Worked on SCSM Incident Management tool to accept user requests as tickets and provide appropriate results.
• Helped in tune and optimize 100+ SQL Servers running Microsoft Clustering on Windows Server 2012 r2, and 2008 R2 & SQL Server 2012, and 2014.
• Solid acquaintance with windows server, security delegation, SPNs, storage components.
• Deploying Service Packs and hot fixes for SQL Server as per deployment schedule.
• Ensure the compatibility level changes and perform database checkup routines to ensure consistency and integrity is preserved.
• Involve in change review meeting to discuss database changes before rolling them out after approvals and troubleshooting and application issues dues to change rollout.
• Implemented different types of Replication Models like Snapshot, Transactional and Merge.
• Proficiency in developing Maintenance plans, backup, recovery strategies and Rebuild/Reorganize strategies.
• Reviewing and verifying Database backup details, Database user privileges, Inactive user accounts
• Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Server Management Studio, SQL Profiler, Database Engine Tuning Advisor Activity Monitor, Query Execution Plan, Debugging, and SQL Query Analyzer
• Experience in fixing Orphan users after the SQL database migration from 2005/2008R2/2 .
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Implemented TDE for critical PROD databases/ database tables with sensitive information to adhere to SOX and PCI compliances
• Knowledgeable and very experience in SQL server database migrations and upgrades. As part of a project, I upgraded over 100+-database instance using different techniques like side by or parallel upgrade after careful planning and testing with the application team.
• Knowledge in setting up SQL AZURE databases and migration on PREM database workload to azure.
• Supported a 24/7 on call rotation database infrastructure and a very willing team player