PROFESSIONAL SUMMARY:

• Over Six years of experience as DBA with ability to analyze and troubleshoot very large and highly transactional database systems. Solid working experience in designing and implementing database solutions. Highly motivated and takes initiative to manage and work on different projects individually and as a team. Strong business and technical vision with effective people skills, innovative, problem solver, result oriented, and has high aptitude to learn new technologies. I am looking to join a dynamic team that works under high pressure and challenging environment to build and deliver high quality solutions.
• Install and configure MS SQL Server .
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission - critical production systems.
• Design, implement and manage high availability & disaster recovery solutions including Failover Clustering, Replication, Log shipping, Database Mirroring and AlwaysOn.
• Monitor database overall health, consistencies and performances Tunning.
• Identify, tune and optimize SQL server databases performance issues.
• Mange Backup/Recovery, archiving and cleanups of files.
• Manage and audits logins, groups, roles and permissions.
• Expert in analyzing query plans and troubleshooting performance issues using indexes.
• Monitor server performance issues and alerts using SQL builtin and third-party tools.
• Implement SQL Server Patching and upgrades.
• Perform on premise and cloud database migrations.
• Migration of SQL server database from on premise to Azure IAAS/PAAS
• Perform database capacity planning and scale ups on different environments.
• Manage, monitor and troubleshoot SQL server agent jobs.
• Manage and administer SQL server reporting services and report subscriptions.
• Deploy, schedule and monitor SSIS & SSRS jobs and SQL scripts.
• Excellent analytical and problem-solving skills, self-motivated and possess ability for critical thinking
• Experience configuring backups and restoring database from recovery vault.
• Configuring Server level and database auditing for SQL server.

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton, CA

Database Administrator

Responsibilities:

• Provide technical support for the database environment starting from MS SQL Server 2005 to SQLServer 2019
• Managed Critical production environment databases, and performance tuning whenever there is an issue with performance to ensure high levels of performance and availability.
• Analyze, solve, and correct issues in real time, providing problem resolution end-to-end
• Perform scheduled maintenance and support release deployment activities after hours.
• Refine and automate regular processes, track issues, and document changes
• Manage data backup, recovery, security, integrity and SQL
• Implement Transactional SQL, and DTS stored procedures.
• Implement High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Design, implement and manage high availability & disaster recovery solutions including Failover Clustering, Replication, Log shipping, Database Mirroring and AlwaysOn.
• Migrated on premise database servers into Azure SQL Databases
• Create Microsoft SQL Server Integration Services (SSIS) package and deployment
• Experience in Installation of IIS and HTTP configuration access to Analysis Services on IIS 8.0
• Experience in working with Performance Metrics, set up alerts and Plan Management
• Ability to working with multi-instance management.
• Configured server level and database level firewalls as per security compliance.
• Experience implementing TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking) Features.
• Configured Always on Availability groups using Cloud VMs.
• Used Power Shell to execute batch files and other scripting tasks.
• Experience in migrating the on-premise database to Cloud and from cloud to on premise using multiple methods.
• Used Database Migration Assistant Database Migration Service tool to migrate the databases to PAAS Server and VM server.
• Installation of MS SQL Server enterprise on Clustered Production, Azure VM, Test and Development boxes.
• Used Nagios and other third-party tools to monitor the performance of SQL Server.
• Performing rebuild and reorganize Index and statistics maintenances using maintenance features.
• Performing backup file managements, archiving and cleanups.
• Performing database consistency and allocation checks and troubleshooting where problem arise.
• Experienced IN Power BI gateway Installer and upgrade
• Implemented TLS.1.2 Transport Layer Security on multiple databases for an encryption protocol to keep data secure over a network
• Setup and monitored high availability solutions such as AlwaysOn and Clustering.
• Debugged complex queries and stored procedures.
• Implemented log shipping as part of disaster recovery plan.
• Implemented mirroring with master key and for DR purpose.
• Monitored log space usages and troubleshoot issues arising with log files.
• Designed and implemented backup and recovery plan strategies.
• Performed databases maintenances using maintenance wizard features.
• Managed SQL data and log files and hard drive storages for maximum performance.
• Performed data loads using SSIS, scripts and BCP from different data sources.
• Managed users and permissions of SQL Server reporting services.
• Optimized the performance of ETL jobs scheduled on staging and SSIS servers.
• Implemented automated database refresh in lower environments using backup and restore.
• Setup databases mails and alerts for critical jobs and server issues.
• Implemented job history cleanup and managed SQL server log files.
• Provide 24/7technical support and monitoring.

Confidential, Alexandria, VA

SQL DBA

Responsibilities:

• Installation of MS SQL Server enterprise on Clustered Production, Test and Development boxes.
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Migrated databases from SQL Server 2005/2008toSQL Server 2016.
• Configured 4 Node widows failover clustering and SQL 2016 Alwayson
• Performed SQL service pack & security patch on failover cluster and AVG.
• Installed and configured SQL Server Reporting Services.
• Regularly monitor the performance of UAT and PROD server (CPU, Memory, I/O) using SQL Profiler, Performance monitor, DMVs, Wait Stats and Events.
• Experience in T-SQL writing Stored Procedures, Functions and Triggers.
• Created login id, passwords and roles in production and non-production environment.
• Experience on creating and maintains on SQL Virtual Machine running at VM ware and Microsoft Hyper-V environment.
• Used Power Shell to execute batch files and other scripting tasks.
• Set up transactional and snapshot replication among SQL Server 2008/2012 boxes.
• Auditing stored procedures for optimization and improving performance.
• Backing up system and user databases and restoring them when necessary.
• Schedule the jobs for the Database Maintenance.
• Re-align the database structure for performance and space management.
• Run DBCC commands to check the database consistency and shrink the databases.
• Extensively used DMV, SQL profiler and performance Monitor, and Performance Dash board for troubleshooting.
• Maintain index rebuild and re-organize indexes periodically.
• Transfer data among SQL boxes using SSIS, BCP, and Back up & restore.
• Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, task assignment and tracking.
• Working with external clients and business analysts in gathering, understanding and documenting requirements.
• Tuning SQL server performance issues by using indexes, partitions and by implementing best practices.
• Implementing Code Deployments to Higher Environments.
• Tuning and enhancing slow running queries and stored procedures
• Installing and configuring SQL server and other applications.
• Managing logins, users, roles, securable and permissions for all environments.
• Preparing security compliance and implementing Audit/Check balance procedures for each server.
• Analyzing database workloads and planning capacity changes of the servers.
• Monitoring, identifying and troubleshooting SQL Server performance bottle necks.
• Supporting all Production Environments and External Clients in a daily basis.
• Monitoring and troubleshooting SQL Server Agent jobs.
• Upgrading and Patching SQL Server boxes in all Environments (Production, QA and Development).
• · Provide 24/7technical support and monitoring.