| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLE EMAIL AVAILABLE Chicago, IL Street Address
LINKEDIN LINK AVAILABLEAuthorized to work in the US for any employer.SummaryHighly skilled SQL Server DBA with over six years of experience in database administration, technical support, and troubleshooting across various operating systems and SQL Server versions. Proficient in backup/recovery, high availability (HA) solutions, performance tuning, security, and managing virtual machines on VMware, Azure, AWS, and Windows Hyper-V platforms.Extensive experience in managing large OLTP and OLAP databases in production environments.Proficient in installing and configuring Microsoft SQL Server, backup and recovery, performance monitoring and tuning maintenance with outstanding troubleshooting abilities.Expertise in administering High availability and Disaster Recovery (Mirroring, Log shipping, replication, Always-ON Availability Group).Excellent in creating technical documentations and process archiving and change management.Expertise in upgrading and migrating several existing production databases, jobs, packages, reports, linked server, logins, and other computer objects to new versions of SQL Servers in-place and Side-by-Side migration methods.Support in Microsoft SQL Server VM/ Azure platform (Iaas, Paas) and AWS.Experience in performing database security using audit and encryption.Well-versed in main data manipulation languages and principles of database design.Meticulous; approaches database administration keeping in mind minute attention to detail.Excellent work ethic and professionalism.Proven track record of problem-solving skills and good team player with a sharp learning curve for new technologies.Superb verbal, written Communication, and interpersonal skills.Hands on support for mission critical MS-SQL databases in production.Proficiency in MS-SQL Databases maintenance, patching, upgrades.Exceptional multi-tasking, time management, and prioritization skills.Analyze system or application usage and plan for growth/Monitors optimize and allocate physical data storage for the database system..Work experience.Lakeshore Recycling SystemMarch 2022 - PresentInstalled SQL Server 2012/2017/2019 on a new 32-bit and x64-bit Operating System. Migrating SQL Server 2012 to Azure SQL Server 2019 and from SQL Server 2012 to SQL Server 2017.Experience in upgrading SQL server software to new versions and applying service packs and patches.Design, create, and maintain SSIS packages for data integration and workflow automation.Generate and maintain SSRS paginate reports and subscriptions, ensuring accurate and timely reporting.Conduct code reviews for SQL-related work, providing guidance on best practices and coding standards. Creating DB Maintenance plans, rebuild/reorganize indexes & performing integrity checks.Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans. Experience with High Availability and Disaster Recoveries like Replication, Log Shipping, H/DR and Clustering.Experience in Implementing Always on in SQL Server 2012 and 2019.Auditing database configuration and security configurations.Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor, Windows performance monitor, DMVs, Perfmon, Extended Event, DBCC and Custom Script, Built-in performance Report and Activity Monitor. Customer management and teaming skills, supporting customers on the phone, teams and written correspondence regarding technical questions and issues.Experience in PowerBI, SSIS, SSRS, ADF and FiveTranDetail-oriented, team player, verity on work.Ability to adapt and learn quickly.Competent to work on multiple projects concurrently.Work experience.SQL Server DBA SupportMicrosoft CorporationJune 2020 - March 2022Installing SQL server and managing reporting, backups, and restores.Monitoring SQL server performance using SQL Profiler, PerfMon, DMVs, Disk I/O, Memory, and CPU.Creating alerts and notification for system errors and hardware errors.Configuring log shipping, replication, SQL Server Failover Clustering, and Always-On availability group.Managing day to day database maintenance operations, SQL server database backup-restore point in-time recovery, job scheduling in a real time production and lower environments.Working on partition of the tables, index to improve the performance, estimated the table space to hold the ETL process and bulk data flow from source to target.Troubleshoot database performance issues and tune database objects by perfmon, activity monitor, Extended Events and SQL profiler.Creating and maintained various databases for Production, using SQL Server and managed the location of data, transaction log and Tempdb files on the disk.Migrating SQL Server from older version to newer versions and built servers according to Microsoft best practices.Configuring and monitored SQL server agent jobs, system logs for alerts, errors and warnings, and available/free space on the OS and storage volumes and analyzed space usage history and recommend changes as needed.Have the drive and intellectual horsepower to resolve difficult customer issues.Experience directly supports customers through telephone, email, and chat services as applicable Demonstrable troubleshooting skills Cross-team collaboration.Managing point in time recovery of the production databases and SQL server locking and blocking.Creating indexes, indexed views in observing business rules and creating effective functions and appropriate triggers to assist efficient data manipulation and data consistency.Maintaining security by managing logins, users and role and the permission for different SQL Server objects under the security Principle of Least Privilege (PLP).SQL Server DBABank of America - Chicago, ILJune 2019 to June 2020Configured and monitored SQL server agent jobs, system logs for alerts, errors and warnings, and available/free space on the OS and storage volumes and analyzed space usage history and recommend changes as needed.Worked on tables, views and wrote complex store procedures based on business unit request.Managed point in time recovery of the production databases and SQL server locking and blocking.Created indexes, indexed views in observing business rules and creating effective functions and appropriate triggers to assist efficient data manipulation and data consistency.Created various SSIS, SSRS packages to serve company needs.Configured and supported HARD solutions Log shipping and Mirroring.Performed performance tuning and maintenance with outstanding troubleshooting capabilities.Monitor SQL Servers using third party monitoring tools like Idera.Installing service packs and patching on SQL Server.Strong understanding of indexes, index management, integrity check and statistics.Run Database Consistency Checks (DBCC), scheduling the DBCC to run on a daily and weekly basis.SQL Server DBACOPD INCMarch 2015 to May 2019Performed performance tuning and query optimization in SQL Server 2012,2016.Configured Backup and recovery process using maintenance plans and/or T-SQL for database servers.Performed daily DBA tasks such as monitoring scheduled SQL Agent Jobs, monitoring database growth, monitoring health and consistency of databases, etc.Monitored the use of disk space, memory, connections in relation to database servers.Installed, configured and upgraded installations of SQL server 2012/2016.Involved in planning and administration of Failover clustered environment.Implemented SQL server high availability tools like log shipping and mirroring to minimize downtime.Worked on performance tuning for the optimization of slow running queries and index maintenance.Automated SQL Server Agent jobs for Periodic Backups with Backup Devices and Database Maintenance Plan.Report on daily basis of server backup status.Administered MS SQL Server security by creating user logins with appropriate roles and permissions.EnvironmentMicrosoft Windows Server 2008R2,2016,2019 SQL Server 2012/2014/2016/2017/2019, Standard, developer and Enterprise Edition, Clustering OLTP & OLAPEducation & CertificationBachelor of Information Technology Addis Ababa UniversityMicrosoft Certified Professional (MCTS) SQL Server 2012/2014 (Administration).Microsoft Certified: Azure Data Fundamentals AZ-900 and AZ-400 |
