| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Upper Marlboro, Maryland Contact: PHONE NUMBER AVAILABLE MCSA MTA EMAIL AVAILABLEAn experienced IT Professional, an MCSA and CMT certified SQL Server database administrator with over 5+ years of experience administering Microsoft SQL Server ranging from SQL Server 2005 to 2017. I have expertise in both stand alone and clustered environments. A Devoted and inspired team worker and self starter. Mastery in Interacting with clients, application team and project managers to design, implement and support solutions to meet client needs. My experience spans from SQL Server installation following Microsoft best practices, Post installation changes, Manage Instance and Database, Performance turning, monitoring, SQL Server Upgrade (In place, Side-by-Side), Database Migration (Backup and Restore, Detach and Attach, Log Shipping). More so, I am verse with planning and implementation of disaster recovery strategies and high availability solutions (Mirroring, log shipping, Replication, Traditional Failover Clustering, Always On Availability Group). Experienced creating and maintaining indexes, update statistics and create maintenance plan to automate jobs. Advanced skills in third party tools (Spotlight, and Solar Winds) for Monitoring to increase optimized efficiency of database performance. Implement virtualization, with hyper-v and VM Ware, Active Directory, Create and manage logins and users following the principle of least privileges. I configure and manage contained databases and Orphan users and maintain database security at high priority following company security policies. Transparent Data masking, Always encrypted, and Dynamic Data masking. Update security tables, database auditing and limiting data access to defined groups. Proificient at documentation.MS SQL SERVER DATABASE ADMINISTRATOR January 2020 PresentCIS& H Inc. MDProvide DBA support and technical expertise for multiple applications in development, test, QA and production environments and Interacting with clients, application team and project managers to design, implement and support solutions to meet client needs.Maintain database security and availabilityProvide guidance and expertise for database Performance Tuning, Performance Base lining and Query Optimization using both SQL Server inbuilt and third-party tools (Query Store, Extended Event, SQL server Profiler, SQL Server turning Advisor.Manage and develop long-term strategies for data storage and capacity planning.Have mastery with creating maintenance plan to automate Administrative task (rebuilding and reorganizing Indexes, updating statistics to enhance performance.Work with third party tools and platform to achieve deployment steps across servers.Create and manage database backup and restore strategy following companys SLA (RTO, RPO and Retention Policy).Refresh databases in a Test, Dev Environment.Install and configure SQL Server following Microsoft Best practices.Design and build new databases, tables, schemers, view and other objectsAbility to react quickly to priority or situations to meet deadline and changes need to business.Answering costumers and users call and attending to them base on which is most prioritized.Set Up and manage Disaster recovery and high Availability solution (Always-On Availability Groups (AG), log shipping and database mirroring, replication).Apply both SQL Server and windows patches.Upgrade and migrate databases from SQL Server 2008 to SQL Server 2016 using in place and side-by-side migration as well as backup and restore, Detach and Attach. Apply patchesMaintaining databases and servers by creating jobs and maintenance plan to monitor large(MULTIPLE) database serversEnhancing performance by creating table partition files and file groups, table compression.Creating and managing logins and users following the principal of list privileges.Ensure security and confidentiality of client data stored in the system with the use of inbuilt toolsCreating and managing users in active directory.Building and configuring VMs in Hyper-V environment.Developing and updating tables, stored procedures, views, indexes, user-defined functions, and triggers in accordance with SQL Server Environments.Maintained and achieved high availability of database via coordinating with infrastructure teams to allocate system resources to database.MS SQL Database Administrator September 2016 January 2020Government Technical High School Fundung.Northwest, Cameroon.Created and integrated DB backup/restore and disaster recovery strategies on companys SLA leveraging proven methodologies.Monitoring performance of databases to ensure maximum performance.Mitigated downtime fixed overall database access and performance issue, and uncovered anomalies while patching and upgrading database.Modifying import/output scripts to handle database needs,Leveraged expertise including extended events and SQL profiler while monitoring SQL server performance.Migrated from SQL Server 2005 to SQL Server 2008, from SQL Server 2008 to SQL Server 2012.Ensured databases security through Transparent Data Encryption, Dynamic data masking and Always encrypted.Maintained database response times in 24/7 Production environments.Performed routine database changes such as upgrades and migrations from SQL server 2012 to 2017 (in-place) and from SQL server 2008 to 2016 (side-by-side).Manage large database in terabytes housing objects such as tales, views, store procedures, partitions, schemers, triggers.Completed tasks prior to deadline involving SQL automation, installation, Azure configuration, site recovery, and backup to ensure optimal performance and disaster recovery of database.Devised effective solutions for slow running queries, deadlock, and blocking issues to optimize overall productivity.Monitored and administered databases for SQL Server 2008, SQL 2012, SQL 2012, SQL 2014, and SQL 2016.Documentation of procedures. Carry on deployment across servers / instances with the team work with developers.User Security Access Control, Permissions & Privileges, Data Encryption using TDE. Maintain database security at high priority following company security policies, database auditing and limiting data access to defined groups.Data Modeling and Database Application Design.Created DB Links for Remote UsersMigrating databases from on-perm to Azure (Azure SQL Database, Azure SQL manage instance and SQL on Azure VMs)Install and configure SQL SERVER SSIS and SSRS Packages.Use Powershell and SQL server management studio to automate jobs, migrate to other servers and manage applications.Act or work in the best interest of the company to ensure availability and optimum functionality of well maintainance of databases and their servers.EDUCATION AND CERTIFICATIONSMicrosoft SQL 2016 Database Administration (MCSA)- CertifiedMicrosoft Database Fundamentals (MTA)-CertifiedBachelors Degree.CURRENT PROJECTSUpgrading and Migrating from SQL Server 2008 to 2016.Settings Always-on and Log shipping for HA and DR solutionEvaluating and accessing on-perm database to be migrated to Azure |
