Ade A. Email & Phone Number

Kennesaw, Ga - Georgia, Us

• Administer and maintain high-performance databases across multiple data centers, ensuring 99.9% uptime for mission-critical applications in a large-scale production environment.• Manage over 500 databases, including Very Large Databases (VLDBs), and provide 24x7 Database Administration (DBA) and production support for over 180 SQL Server databases on clustered servers.• Led a team of 5 junior DBAs, offering mentorship and technical guidance to enhance team productivity and knowledge sharing.• Collaborate with business analysts, client teams, and application developers to design and deploy new databases, resulting in a 25% improvement in data flow efficiency and faster decision-making capabilities.• Implement advanced backup, disaster recovery strategies, and high-availability solutions, reducing potential data loss risks by 40% and successfully executing large-scale database migrations from SQL Server 2005 to SQL Server 2016.• Migrate SQL data from on-premises to Azure SQL Database, achieving a 20% reduction in infrastructure costs and improving system scalability.• Optimize database performance, resulting in a 30% increase in query speed through SQL query fine-tuning and indexing.• Configure and manage data integration solutions using SSIS for ETL processes, including physical and logical data modeling, and deploy SSRS reports across various topologies.• Conduct data analysis to identify trends, anomalies, and areas for improvement in database performance and usage, contributing to more informed business decisions and enhanced data-driven strategies.• Utilize SQL for complex data manipulation, extraction, and analysis to support business intelligence initiatives, enhancing reporting accuracy and operational efficiency.• Enforce database security protocols, ensuring full compliance with GDPR and HIPAA standards.• Perform scheduled backups, restores, and database refresh tasks, while providing on-call support for mission-critical environments.

New York, New York, Us

• Administered and supported SQL Server database systems for diverse clients, ensuring high availability, data integrity, and optimal performance across multiple production and development environments.• Performed regular health checks and monitoring of SQL Server databases, promptly identifying and resolving issues to maintain system reliability.• Developed and implemented automated maintenance scripts, reducing manual workload by 35% and improving response times by 25%.• Executed comprehensive backup and recovery procedures, leveraging Clustering, Always On Availability Groups, Log Shipping, Database Mirroring, and Replication to ensure zero data loss and high availability.• Assisted in planning and executing database upgrades and migrations, minimizing downtime to achieve seamless transitions.• Managed server security by configuring logins, roles, and permissions, and implementing robust measures to safeguard data against unauthorized access.• Enhanced query performance through SQL indexing and optimization tools, including SQL Profiler, Dynamic Management Views (DMVs), Windows Performance Monitor, Foglight, and Red Gate.• Installed and maintained SSIS, SSRS, and Power BI environments, facilitating data integration, reporting, and visualization to support business insights.• Conducted detailed data analysis to identify trends, improve data quality, and provide actionable insights, using SQL and data visualization tools.• Developed SQL queries, stored procedures, and functions to support in-depth data analysis, trend identification, and predictive insights.• Automated administrative tasks, including job scheduling and alerting, through SQL Server Agent, enhancing operational efficiency with event notifications via Database Mail.• Collaborated with business analysts and stakeholders to understand data requirements, ensuring accurate and timely data delivery for business intelligence and reporting needs.

Nutley, Nj, Us

• Assisted with database installation, configuration, and upgrades, ensuring minimal downtime and smooth transitions.• Performed routine maintenance tasks to maintain database health and availability including backups, restores, integrity checks, and log shipping.• Monitored and optimized database performance, identifying and resolving issues to enhance system efficiency.• Supported high-availability solutions, such as database mirroring and clustering, to reduce downtime risks.• Provided technical support for database-related issues, ensuring swift resolution to reduce business impact.• Developed SQL scripts, stored procedures, and triggers to automate data management tasks and enforce business rules.• Managed and maintained critical documentation, ensuring compliance with operational standards.• Conducted data analysis using SQL and SAS, maintaining data integrity and supporting high-quality deliverables.• Created reports, visualizations, and dashboards using SAS, Power BI, and Tableau to present findings and support data-driven decision-making.• Processed client invoices using SAP, ensuring accuracy and timely billing.• Optimized SAS code and workflows, reducing processing time by 30% for complex data analysis.• Utilized advanced Excel functions for financial analysis, generating clear and actionable reports.• Improved data management platforms through data cleaning, standardization, and validation for accurate analysis and reporting.• Facilitated collaboration and document sharing using Google Docs.

Master Of Business Administration (Mba), Business Administration And Management, General

Bachelor Of Science (Bsc), Accounting