| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
SQL DATABASE ADMINISTRATOR,LINCOLN NEBRASKA,PHONE NUMBER AVAILABLE: EMAIL AVAILABLESUMMARYFive years experienced SQL Server Certified Database Administrator adept at maintaining database integrity and security by developing policies and procedures. Highly skilled in orchestrating high availability and disaster recovery solutions by implementing failover clustering, log-shipping, replication, Always On, analyzing performance and tuning data. Proficient in reviewing database designs and documents for providing suggestions for enhancement base and optimal performance of databases, ETL, Windows Clustering. Ensuring security by implementing TDE, DDM, Always Encrypted & Auditing. Patching and DB upgrades and Managing Relational Databases on Azure, Virtualization Hyper-V, Build Domains Controllers and Active Directories, strong experience with SQL server migration from older to newer versions. Managing of large size databases.PROFESSIONAL EXPERIENCE5 years of experience in Database Administration for very large and complex databases in SQL Server 2005 through 2019.Performed all day-to-day aspects of MS SQL server database administration. Responsibilities include database design, installation, configuration, upgrades, security, managing users and logins, performance monitoring and tuning, database availability, backup and restore, troubleshooting and problem resolution.Configured High Availability Solution- Clustering, Always On and Log Shipping.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 as requirement on SQL Server environments.Planning and implementation of Database backup/restore and disaster recoveryInstalled SQL Server 2005-2019 following Microsoft best practices, applied Patches and security fixes.SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance.Configured and supported replication and log shipping in both SQL 2008 and 2012.Maintained database response times 24/7 in Production environments.Monitoring standby Databases to ensure high availabilityAutomation of DBA tasks using PowerShell scripts and monitoringConfigured and managed Contained DatabasePerformed Database Migration from an On-Premises SQL environment to Azure Database in the cloud. 2RECENT PROJECtSQL 2008/R2, SQL 2012 and SQL 2017 Upgrades, both In-Place and Side-By-Side upgrades.Applying windows and SQL Server patches on Production/Non-Production ServersConfigured database backups and restoration, monitored and tuned database.Migration of SQL Server Databases and Managed instances WORK HISTORY07/07/2021 Current,SQL SERVER DBA Lincoln IndustriesResponsibilitiesPerformed all day-to-day aspects of MS SQL database administration. Responsibilities include database design, installation, security, managing users and logins, performance monitoring and tuning, database availability, backup and recovery, troubleshooting and problem resolution.Configure and currently working on High Availability(HA) and Disaster Recovery(DR) solutions for SQL server with clustering, Always ON and Log ShippingInvolved in the planning, setup, and implementation of new servers in our companyInvolved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database.Planned and deployed monthly windows and SQL server patches.Planning and implementation of Database backup/restore and disaster recoveryImplementation of snapshot isolation and DDL triggersMigration of SQL Server 2005 to SQL Server 2008Perform all types of ReplicationInstalled SQL Server 2008 on advanced servers, applied security fixesSQL Server Upgrade and updatesOriented other database administrators on SQL Server management including upgrades and migration.Monitoring standby databases to ensure high availabilityProduction level support for onsite and offshore ClientsSupport Patch ManagementAutomation of database tasks and monitoringMaintained database response times in 24X7 Production environmentsDeveloping SQL scripts for maintaining administration tasksMonitoring standby databases to ensure high availability 10/2017 03/2021Junior Database Administrator, University of Douala. ResponsibilitiesInstalled and configured SQL Server 2005/2008/2012/2016/2017Performed Backups, DBCC utilities, updated index statistics, monitored database and disk spaceManaged the migration of SQL Server 2012 databases to SQL Server 2016Created and maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions, and other schema objectsDesigned and implemented comprehensive Backup plan and disaster recovery strategiesRebuilding indexes at regular intervals for better performance. 3Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database serversUsed log shipping for synchronization of databaseReviewing and optimizing virtual machines environmentReviewing and optimizing storageResponsible for monitoring and troubleshooting Log shippingUpdate statistics, database integrity check and backup operationsCreating and Maintaining database maintenance plansConfigured High Availability Solution- Clustering, Always On and Log Shipping.Planning and implementation of Database backup/restore and disaster recoveryInstalled SQL Server 2012 on advanced servers, applied security fixes.SQL Server Profiler, Extended Events, for performance.Implementation of snapshot isolationConfigured and supported replication and log shipping in both SQL 2008 and 2012.Monitoring standby Databases to ensure high availabilityConfigured and managed Contained DatabaseConfigured and supported replication and log shipping in both SQL 2008 and 2012. 10/2015 08/2017Academic Placement Representative,University of Douala.ResponsibilitiesOffer list of programs carried out by the universityDirect questions to the right department when neededKeep new commers informed about the various schools in the universityDirect students to their various faculties and schoolsMaintain accurate records of the number of students in the school of technologyFollow up with parents or new students as needed to ensure any problems they faced are resolve EDUCATIONUniversity of Yaound II SOA- CameroonAssociates degree in Computer science.Microsoft Certified Azure Database Administrator Associate (AZ104) PursuingAdvanced SQL server Database Administration training at KiawitechIT Academy Ltd 2015-2017 Application experienceMicrosoft SQL server 2005-2019Windows server 2008, 2012, 2012 r2, 2016, 2019Microsoft office suite (Word, Excel, power point, office 365)Service NowActive directoryWindows (7,8,10)Hyper-V, Workstation |
