We provide IT Staff Augmentation Services!

Sql Dba Resume

Alexandria, VA

SUMMARY

  • Over Eight 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.
 

AREAS OF EXPERTISE

  • Install and configure MS SQL Server 2008 - 2017.
  • 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.
  • Identify, tune and optimize SQL server 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.
  • Develop and troubleshoot TSQL and stored procedures.
  • Implement SQL Server Patching and upgrades.
  • Perform on premise and cloud database migrations.
  • 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 and analysis, good interpersonal and communication skills.

PROFESSIONAL EXPERIENCE

Confidential, Alexandria, VA

SQL DBA

  • Working with external clients and business analysts in gathering, understanding and documenting requirements.
  • 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.
  • Tuning SQL server performance issues by using indexes, partitions and by implementing best practices.
  • Monitoring and troubleshooting SQL Server Agent jobs.
  • Upgrading and Patching SQL Server boxes in all Environments (Production, QA and Development).
  • Implementing Code Deployments to Higher Environments.
  • Performing on demand backups and restores in operational systems.
  • Setting up, monitoring and troubleshooting replications on multiple servers.
  • Configuring and managing SQL server reporting and integrations services.
  • Tuning and Enhancing slow running queries and stored procedures.
  • Tracing, capturing and troubleshooting locking, blocking and deadlock graphs.
  • Performing Index and statistics maintenances using maintenance features.
  • Implementing backup file managements, archiving and cleanups.
  • Performing database consistency and allocation checks and troubleshooting where problem arise.
  • Expertise in using different utility tools such as SQL builtin tools as well as third party tools.
  • Setting up, monitoring & troubleshooting high availability solutions such as mirroring and replication.
  • Involving in Agile methodologies, sprint planning, grooming, review and retrospective.

Confidential, Alexandria, VA

SQL DBA

  • Installation of MS SQL Server enterprise on Clustered Production, Test and Development boxes.
  • Migrated databases from SQL Server 2005/2008 to SQL Server 2014.
  • Configured 3 Node widows failover clustering and SQL 2014 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.
  • Provide 24/7technical support and monitoring.

Confidential, Chvey Chase, MD

Database Administrator

  • Designed, reverse engineered and documented data warehouse solutions.
  • Setup and monitored high availability solutions such as AlwaysOn and Clustering.
  • Developed, configured and deployed SQL Scripts, SSIS packages and SSRS Reports.
  • Debugged complex queries and stored procedures.
  • Implemented service patching and cumulative updates in a quarterly basis.
  • Implemented log shipping as part of disaster recovery plan.
  • 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.
  • Used Solar winds and other third party tools to monitor the performance of SQL Server.
  • Performed data loads using SSIS, scripts and BCP from different data sources.
  • Managed users and permissions of SQL Server reporting services.
  • Monitored and troubleshoots SQL Server agent jobs.
  • Optimized the performance of ETL jobs scheduled on staging and SSIS servers.
  • Debugged SQL queries and stored procedures by working with Developers.
  • Implemented automated database refresh in lower environments using backup and resotre.
  • Setup databases mails and alerts for critical jobs and server issues.
  • Implemented job history cleanup and managed SQL server log files.
  • Migrated on premise database servers into AWS (EC2 and RDS) using database migration service.
  • Provide 24/7technical support and monitoring.

Tools Used: Solar Winds, Red Gate, Idera, Apex, TFS, AWS(RDS & EC2), ERWIN, VMware, ORACLE, SQL Built in tools(profiler & DTA).

Hire Now