| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateContinuedCandidate's Name
Street Address Newark New Jersey PHONE NUMBER AVAILABLE E-Mail: EMAIL AVAILABLE LinkedIn: LINKEDIN LINK AVAILABLEMS SQL Server Database AdministratorAn adept IT specialist with over 6 years of expertise in SQL Server Administration and Database Design, possessing strong analytical abilities. Proficient in comprehensive database management, encompassing security protocols, issue resolution, and the oversight of backup and recovery models.AREAS OF EXPERTISEComprehensive knowledge of SQL Server deployment, migration, patching, troubleshooting, optimization, maintenance (modeling, High-Availability (HA) and Disaster Recovery (DR)).Skilled in building complex environments using functions such as Traditional failover clustering, Log Shipping, and AlwaysOn high availability and disaster recovery, migration, backup and restore.Excellent attention to detail, cross-functional communication, and teamwork skills.A good team player.RECENT PROJECTSMigration of over 100 SQL Server Databases and Managed instances.Managed Projects such as Cloud infrastructure deployment from conception to completion of the project.SQL 2008/R2 Upgrades, SQL 2012 Upgrades, Application Migration and SQL Server Consolidation.Applying windows and SQL Server patches on Production/Non-Production Servers.Configured database backups and restoration, monitored and tuned database. TECHNICAL PROFICIENCIESPlatforms: Windows, Microsoft SQL Server (2012 2019) Tools &Functions:PowerShell, COBOL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Transparent Data Encryption(TDE), Dynamic Data Masking (DDM), Always Encrypted, High Availability, Database Mirroring, Log Shipping, Traditional Failover Clustering, AlwaysOn, Database Mail, SQL Operator, Snapshot, Transaction, MergeProfessional ExperienceSQL Server Database AdministratorJADD Newark, New Jersey 3/2021 PresentImplement and monitor High Availability solutions, such as Database Mirroring, Log Shipping, Failover Clustering, and AlwaysOn Cluster methods, effectively minimizing downtime and ensuring system reliability.Maintain robust database security, including the implementation of Transparent Data Encryption (TDE), to safeguard sensitive information and ensure compliance with security standards.Successfully upgraded and migrated SQL Server instances and databases from older versions (e.g., 2000/2005 to 2008 R2, 2008 R2 to 2012, 2012 to 2016), ensuring system compatibility, support, and access to the latest features.Automate various database activities by scheduling jobs for backups, monitoring database health, disk space management, and maintenance plans, optimizing system performance and reducing manual intervention.Established a comprehensive backup system, including manual backups, on-demand backups, and scheduled backup jobs, enhancing data protection, and implementing point-in-time recovery measures to mitigate data loss or corruption risks.MSSQL Database AdministratorSERVITECO NIGERIA LIMITED Lagos, Nigeria7/2018 2/2021Spearheaded 24/7 production database administration, providing unwavering support and proactive monitoring to recognize and resolve database issues promptly, ensuring uninterrupted operations.Configured and managed High Availability solutions, including AlwaysOn Cluster, Traditional Failover Clustering, Database Mirroring, and Log Shipping, ensuring data availability, and minimizing downtime for critical applications.Led database upgrades and migrations, seamlessly transitioning databases from lower versions of SQL to higher versions, both vertically and horizontally, in standalone and clustered environments, ensuring compatibility with evolving technologies.Orchestrated the migration of databases from on-premises SQL environments to Azure Database in the cloud, showcasing expertise in cloud integration, and developed and implemented a robust Disaster Recovery (DR) plan for data protection and business continuity.Implemented diverse physical and logical backup and recovery methods, including Point-In-Time and Media Recovery, conducted maintenance jobs, and performed daily health check-ups on all databases, ensuring comprehensive data protection, integrity, and system optimization. Jr. Database AdministratorBAKLANG CONSULTANTS LTD Lagos, Nigeria 5/2016-6/2018Designed and implemented comprehensive business intelligence solutions leveraging SQL Server Analysis Services(SSAS) for multidimensional modeling and SQL Server Reporting Services (SSRS) for interactive, visually appealing reports, ensuring actionable insights and facilitating informed decision-making across the organization.Communicated with corporate clients via telephone, written correspondence, or electronic service regarding problems identified in Microsoft SQL Server software.Supported SQL Server experts on configuring transaction replication and resolving replication lag issues in production environment and setup replication alerts.Effectively managed SQL Server backup and recovery operations, meticulously validating backups to guarantee data integrity and minimize downtime across diverse database environments, ensuring business continuity and adherence to disaster recovery protocols.Collaborated with seasoned SQL Server Professionals to execute 40+ database migrations supporting with creating rollback plans as well as capacity planning.Education and TrainingMaster Degree Transportation Planning and Management University of Lagos, Nigeria, 2013Bachelor of Art Public Administration Ambrose Alli University, Nigeria, 2005KiawiTechIT Consulting LLC, Richmond, TX, Advanced SQL Database Administration Training, December 2017 |
