Senior MSSQL/Azure Database Administrator with High Availability

ELERNO NDUM

MSSQL/AZURE Server Database Administrator

VISA : GC Email : *********@*****.*** Phone: +1-614-***-**** LinkedIn CAREER OBJECTIVES

Led IT initiatives by leveraging over 6 years of advanced SQL Server expertise to design and implement robust database solutions, emphasizing high availability and disaster recovery.

Implemented and managed solutions like Always On Availability Groups, log shipping, mirroring, replication, and failover clustering to ensure system resilience and optimal performance.

Executed seamless SQL Server upgrades and migrations, ensuring compatibility and minimal downtime, while adhering to best practices and security protocols.

Enforced stringent security measures, including Transparent Data Encryption (TDE), Always Encrypted, and Dynamic Data Masking, to safeguard data and ensure compliance with industry standards.

Conducted in-depth performance tuning using tools like SQL Server Profiler and Extended Events, resulting in significant improvements in query response times and overall system efficiency.

Developed and utilized T-SQL and PowerShell scripts to automate routine database tasks, enhancing operational efficiency and reducing manual intervention.

Managed comprehensive backup strategies aligned with Recovery Time Objectives (RTO) and Recovery Point Objectives

(RPO), ensuring rapid data recovery and minimal data loss.

Collaborated with cross-functional teams in Agile/SCRUM environments, contributing to all phases of the Software Development Life Cycle (SDLC) and facilitating effective communication and problem-solving.

Stayed abreast of the latest SQL Server developments and best practices through ongoing training and certifications, ensuring the application of cutting-edge solutions to database management challenges. PROFESSIONAL EXPERIENCE

BDO, Remote APR 2022 – Present

Senior MS SQL Server Database Administrator

• Proficiently architect, configure, and oversee Azure SQL servers, databases, and elastic pools, orchestrating seamless data import and export processes to optimize cloud database performance and scalability.

• Implement proactive measures to ensure high availability, including vigilant standby database monitoring and the establishment of Database Mail and Operator alerts, enabling rapid detection and response to job failures for uninterrupted operations.

• Expertly manage and administer SQL Server instances across both Infrastructure as a Service (IAAS) and Platform as a Service

(PAAS) environments, meticulously optimizing performance to meet demanding business needs.

• Execute SQL Server installation, configuration, backup, and recovery protocols with precision, safeguarding data integrity and fortifying system resilience against potential disruptions.

• Spearhead the development of ETL processes and generation of reports using SSIS, SSAS, and SSRS, harnessing the power of Azure Data Factory and Azure Synapse for advanced data integration and analysis, while implementing robust security measures to uphold data confidentiality and integrity.

• Harness the capabilities of PowerShell scripting to automate critical database administration tasks, enhancing operational efficiency and streamlining workflows.

• Provide unparalleled technical support to end-users, swiftly resolving database-related issues and ensuring seamless high availability and disaster recovery procedures for continuous service delivery.

• Develop and implement efficient change management processes utilizing ServiceNow, facilitating streamlined resolution of tickets and user requests, ensuring optimal system performance and user satisfaction.

• Orchestrated the setup and fine-tuning of database performance, optimizing operations through meticulous configuration of maintenance tasks such as Index Rebuilds and Statistics updates, ensuring peak efficiency and reliability.

• Led end-to-end planning, installation, and configuration of Microsoft SQL Server versions spanning 2012 through 2019, executing seamless upgrades, migrations, and patch applications during scheduled after-hours database downtimes in complex virtualized environments.

• Executed flawless migration of database objects including tables, indexes, views, stored procedures, functions, and triggers, resolving discrepancies between source and target databases with precision and agility.

• Implemented cutting-edge security protocols like Transparent Data Encryption (TDE), dynamic data masking, and Always Encrypted to bolster database security and safeguard sensitive information.

• Pioneered automation initiatives by designing and implementing maintenance plans for tasks ranging from rebuilding and reorganizing to statistic updates, backups, and cleanup, spanning both on-premises and Azure environments, streamlining workflows and enhancing operational efficiency.

• Ensured database integrity and security through proactive measures such as validation checks, consistency checks, and leveraging Dynamic Management Views (DMVs), playing a pivotal role in seamless data center migration projects from on-premises to cloud environments.

• Provided round-the-clock database and application support on-premises, exemplifying unwavering dedication to operational excellence and uninterrupted service delivery.

• Adhered meticulously to change management protocols, flawlessly executing scripted change requests across diverse environments, while applying optimization strategies to refine SQL code and ensure peak performance.

• Spearheaded On-Prem to Azure Migration Projects, orchestrating seamless transitions and preserving operational continuity throughout the migration process.

• Orchestrated a 99% reduction in access-related incidents by meticulously crafting and managing logins/access levels within Azure IAAS and PAAS environments, establishing a fortified and streamlined user access protocol.

• Elevated operational efficiency through the implementation of automated resource monitoring and tuning strategies, yielding a remarkable 98% reduction in incidents and maintaining an impressive 95% success rate in recovering deleted databases, while executing seamless point-in-time database recovery to ensure uninterrupted data continuity.

• Significantly augmented database performance by deploying optimized SQL queries and refining indexing methodologies, culminating in a notable 30% reduction in query response times and an overall enhancement in system performance, showcasing a commitment to continuous improvement and optimization. Mindtree/Microsoft - Hybrid DEC 2021– MAR 2022

Sr DBA/ Support Engineer

• Architected and configured Windows fail-over clusters to establish resilient High Availability (HA) solutions, ensuring continuous database availability. Vigilantly monitored and managed Always-On availability groups to uphold seamless database operations in dynamic environments.

• Executed server decommissioning processes with meticulous precision, guaranteeing seamless transitions and minimizing operational disruptions. Safeguarded database integrity and fortified security measures by expertly managing users, logins, and access permissions.

• Streamlined operations through efficient task automation using SQL Server Agent and PowerShell scripting, ensuring optimal resource utilization and operational efficiency. Administered database backups using a combination of SQL Server native tools and cutting-edge third-party solutions to ensure data integrity and rapid recovery.

• Conducted database refreshes and expertly managed data, executing successful upgrades from SQL Server 2008 to SQL Server 2016 while implementing rigorous performance tuning techniques and query optimization strategies to enhance system responsiveness and efficiency.

• Utilized advanced monitoring tools including Dynamic Management Views (DMVs), Perfmon, Profiler, and other sophisticated utilities to meticulously monitor and tune databases, ensuring optimal performance and scalability.

• Spearheaded database migration initiatives across SQL servers, managing a diverse portfolio of databases and automating daily backup and maintenance plans to streamline operations and ensure data integrity.

• Conducted comprehensive database capacity planning, managed data migrations, and executed SQL scripting to optimize system performance and scalability, ensuring seamless integration and compliance with organizational standards.

• Built and deployed SQL Server Reporting Services (SSRS) to enrich reporting capabilities and enhance data visualization, leveraging PowerShell, IDERA, and Rubrik for streamlined administrative tasks and optimized system operations.

• Collaborated on SQL Server Integration Services (SSIS) for ETL processes, deploying and troubleshooting stored procedures with precision, while seamlessly integrating IAAS and PAAS Azure services to optimize cloud infrastructure management for scalability and performance.

• Led migration initiatives, ensuring robust disaster recovery solutions and implementing High Availability and Disaster Recovery

(HADR) strategies such as Always On, replication, and mirroring. Skillfully migrated PSQL Databases to MS SQL Server, ensuring seamless transition and compatibility.

• Implemented strategic solutions to resolve SQL Server issues, delivering a remarkable 20% enhancement in system performance across on-premise and Azure cloud environments, ensuring optimal operations and reliability.

• Enhanced operational efficiency by an impressive 30% through adept management of IaaS/PaaS database solutions within public cloud environments, driving heightened system performance and generating substantial cost savings. Luxottica - Onsite MAR 2019 - OCT 2021

SQL Server Database Administrator

• Spearheaded the establishment of robust computer networks facilitating seamless internal and external data exchange, leveraging advanced analysis of future user requirements to optimize network design and functionality.

• Collaborated closely with the network team to fortify company data security measures, ensuring stringent protection protocols and facilitating secure access in dynamic and fast-paced operational environments.

• Provided comprehensive customer support via multiple channels including phone calls, email, and chat services, delivering unwavering assistance and guidance around the clock, exemplifying dedication to customer satisfaction and operational excellence.

• Expertly navigated challenging customer issues, elucidating responsibilities, communicating transparently regarding next steps and status updates, fostering trust and confidence in the resolution process. Conducted rigorous troubleshooting and performance tuning activities, ensuring optimal system functionality and performance levels.

• Conducted thorough SQL Server health checks across all databases, meticulously adhering to Microsoft best practices to uphold peak database performance and data integrity, ensuring a robust and reliable database ecosystem.

• Expertly installed and configured new SQL Server instances, orchestrating seamless setups of database environments with precision and efficiency, setting the foundation for optimal database functionality.

• Successfully orchestrated the planning, installation, and testing of software upgrades and patches, safeguarding the continued reliability and security of the database infrastructure, and ensuring adherence to industry-leading standards.

• Skillfully spearheaded the migration and upgrade process from SQL Server 2016 to SQL Server 2019, driving enhanced database capabilities and positioning the organization at the forefront of technological advancements.

• Spearheaded a remarkable 95% enhancement in database performance by employing meticulous monitoring and evaluation techniques, leveraging both inbuilt SQL Server tools and cutting-edge third-party solutions to proactively identify anomalies and errors, ensuring swift resolution and optimal database health.

• Implemented advanced automated backup and recovery strategies, yielding an impressive 98% reduction in potential data loss and guaranteeing rapid recovery in the event of system failures, thereby safeguarding critical data assets and minimizing business disruptions.

• Demonstrated expert administration of all database objects, including tables, clusters, indexes, views, sequences, packages, and stored procedures, ensuring 100% data object integrity and fostering operational excellence across the database ecosystem. SKILLS & STRENGTHS:

Languages: T-SQL, Windows CMD, PowerShell, Shell Scripting RDBMS: SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008/R2 Database Tools: MS Azure, SSMS, SSIS, SSRS, SharePoint, Index Tuning Advisor, Database Engine Tuning Advisor, SQL Profiler, Performance Monitor, Activity Monitor, DMVs & DMFs, Policy Based Management, Resource Governor, DMA (Data Migration Assistance), Azure Database Migration Service, OEM 13c, AWS, RDS, EC2.

Third Party Tools: IDERA, Red Gate, Commvault, Jira, ServiceNow. EDUCATION

Associate Degree in Marketing – University of Bamenda, Cameroon.

Certification for Microsoft Azure Data Engineering (DP 203).

Certified Azure Database Administrator Associate (DP 300).

Certified Microsoft Azure Data Fundamentals (DP-900).

Certified Microsoft SQL Server Database Administrator (MTA). DECLARATION

The information provided above is true to the best of my knowledge. ELERNO NDUM

Contact this candidate