| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Pittsburgh, PA Street Address (PHONE NUMBER AVAILABLE EMAIL AVAILABLE High Availability Solution- Clustering, Always On, Log shipping SQL Server Configuration T-SQL Scripting Database Migration Key Technologies OBJECTIVEOver 6 years of extensive database administrator (DBA) experience in SQL Server Administration and Database Design. Highly Skilled in all aspects of database management including Security checks and policies, performance Tuning, Troubleshooting, managing Backup and recovery models, installing, configuring and upgrading various servers, simplifying administrative process through proper documentation, generating reports, setting up high availability, disaster recovery solutions in SQL such as Always On availability groups, log shipping, mirroring and replication.TECHNICAL EXPERIENCE Strong Experience with SQL Server 2008 through 2019 Administration standalone and cluster environments Increased efficiency 25% by providing optimum database performance with efficient backup and restore processes. Enhanced database performance implemented recovery procedures and achieved 99.9% up time on all SQL Servers. Transparent Data Encryption (TDE), DDM, T-SQL, PowerShell, SQL Server Integration Services(SSIS), SSRS. Advanced skills in IDERA/SCOM, Redgate and Solar Winds Monitoring Tools Interacts with clients, application team and project managers to design, implement and support solutions to meet client needs Responsible for daily maintenance of large environments comprising of over 200 servers, 500+ Instances and 750+ databases Production level support for onsite and offshore - On Call 24/7 environment Excellent experience configuring and managing Azure virtual machines Attributed savings from hardware and MS SQL licensing costs Excellent knowledge on Server Virtualization with Hyper-V or VMWare RECENT PROJECTS Configured database backups and restoration, monitored and tuned database. SQL 2008/R2 Upgrades, SQL 2012 Upgrades, Application Migration and SQL Server Consolidation. Applying windows and SQL Server patches on Production/Non-Production Servers PROFESIONAL EXPERIENCEInvision Human ServicesMS SQL Database Administrator 10/2018 PresentCandidate's Name
Pittsburgh, PA 15102 (PHONE NUMBER AVAILABLE EMAIL AVAILABLE High Availability Solution- Clustering, Always On, Log shipping SQL Server Configuration T-SQL Scripting Database Migration Key Technologies 2Responsibilities: Performed all day-to-day aspects of MS SQL Server database administration including database design, installation, configuration, upgrades, security, managing users and logins, performance monitoring and tuning, database availability, backup and recovery, troubleshooting and problem resolution. Responded to and resolved all database access and performance issues. Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc. as requirement on SQL Server Environments. Supported clustered and non-clustered environments including standby databases. Configured High Availability Solution such as Always On Cluster, Traditional Failover Clustering, Database Mirroring and Log Shipping. Developed several automated database monitoring and alerting processes Oriented other database administrators on SQL Server management including upgrades and migration. Ensured databases adhere to corporate standards and policies, including database auditing. Installed SQL Server 2012, 2014, 2016, 2017 and 2019 on advanced servers, applied security fixes. SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance. Oversee Server Lease Replacement Decommissioning for the entire Data center Spark IncMS SQL Database Administrator 01/2017 09/2018Responsibilities: Monitoring standby Databases to ensure high availability Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc Maintained database response times in 24/7 Production environments. Planning and implementation of Database backup/restore and disaster recovery SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance. Configured High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping. Implementation of snapshot isolation and DML triggers Configured and supported replication and log shipping in both SQL 2008 and 2012. Configured and managed Contained Database Firewall Rule, Triger, Change Data Capture (CDC) etc. Installed SQL Server 2012 on advanced servers, applied security fixes. Brought company technology current by assisting with upgrade from SQL Server 2008 to 2017. NTAHelpdesk Technician 03/2012 12/2016Responsibilities:Candidate's Name
Pittsburgh, PA 15102 (PHONE NUMBER AVAILABLE EMAIL AVAILABLE High Availability Solution- Clustering, Always On, Log shipping SQL Server Configuration T-SQL Scripting Database Migration Key Technologies 3 Monitor and respond quickly and effectively to requests received through the Service Desk ticket system (ServiceNow) Provide day-to-day telephone support to the end-user community. Monitor and track existing incidents and service requests in ServiceNow. Prioritize tickets based on need and criticality Support end-users with installation, configuration, and troubleshooting of hardware and software to ensure continued usability of equipment and software at a Tier II level - including, but not limited to: Network Connectivity, MS Office, Microsoft Outlook, tablet/smartphone support, Windows 7/10, Software and Image Management Systems (e.g. SCCM) Provided Service Desk support to end-users, both in the office and remotely. Assisted with hardware, software, and network issue Technical knowledge of and experience with installing, upgrading, configuring and deploying end-user hardwareEDUCATION: Bachelor of Technology in Electronic and Electrical Engineering 2010 o Ladoke Akintola University of Technology, Nigeria. KIAWITECH Advanced Database Administrator Training Program 2015 CERTIFICATIONS:Microsoft Certified Azure Database Administrator Associate (AZ104) Pursuing |
