Ufuoma Miller
Summary
High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Senior SQL Server Database Administrator/Azure DBA
Aetna/CVS Maryland USA
06.2018 - Current
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Proficient in installation, configuration, maintenance, and troubleshooting of SQL Server instances (2008, 2012, 2014, 2016, 2017, 2019) on Windows Server platform
- Experienced in database backup and recovery, performance tuning, security management, and capacity planning
- Expertise in identifying and resolving performance bottlenecks through query optimization, index tuning, and server configuration
- Proficient in implementing and enforcing security measures to protect sensitive data
- Skilled in designing and implementing backup strategies to ensure data integrity and availability
- Hands-on experience in configuring and managing high availability solutions like Always Availability Groups and database mirroring
- Familiarity with monitoring tools like SQL Server Management Studio (SSMS), SQL Server Agent, and third-party monitoring tools
- Proficient in scripting languages like T-SQL, PowerShell, and batch scripting
- Ability to analyze complex database systems, identify issues, and develop effective solutions
- Assisting with supporting ETL processes, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
- Familiarity with POWER BI and Tableau
- Expert in storage planning, Virtual warehouse sizing, database setup including data encryption, masking, Policies managing and monitoring
- Performance management and support of snowflake across production and cross functional teams and experience in Cost containment and disaster recovery system.
SQL Server Database Administrator
Mtn Nigeria, Mobile Telecommunication Network
04.2014 - 04.2018
- Installed, configured, and maintained SQL Server instances across multiple environments, including development, testing, and production
- Developed and implemented backup and recovery strategies to ensure data integrity and minimize downtime
- Conducted regular database health checks and implemented proactive measures to mitigate potential issues
- Monitored database performance and identified and resolved performance issues through query optimization, index tuning, and server configuration
- Configured and managed high availability solutions like AlwaysOn Availability Groups and performed regular failover testing
- Implemented and enforced security measures to protect sensitive data, including user access management, role-based security, and auditing
- Collaborated with development teams to optimize database schemas, indexes, and queries for improved performance
- Created and maintained documentation related to database configurations, procedures, and troubleshooting guidelines
- Assisting with creating and supporting ETL processes, SQL Server Integration Services (SSIS), and SQL Server, Familiarity with POWER BI and Tableau
- Assisted in capacity planning and resource allocation to ensure optimal performance and scalability
- Coordinated setting up of High Availability Solutions, and Disaster Recovery solutions to ensure stability, reliability, and high performance
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Provided technical support to application developers for seamless integration of databases within software solutions.
- Participated in troubleshooting efforts for complex database-related issues as part of a collaborative problem-solving approach among colleagues.
- Oversaw disaster recovery planning initiatives to ensure minimal disruption in the event of unexpected system outages or failures.
- Reviewed SQL code for optimization opportunities, leading to more efficient processing times across various applications.
IT Support Consultant
Petrolog Group
03.2010 - 01.2014
- Assisted in the migration of legacy systems to modern platforms, minimizing disruption to daily operations.
- Provided ongoing support for clients post-implementation, ensuring a smooth and successful transition to new technologies.
- Installed, configured and maintained computer systems and network connections.
- Documented support interactions for future reference.
- Configured hardware, devices, and software to set up work stations for employees.
- Broke down and evaluated user problems, using test scripts, personal expertise, and probing questions.
- Monitored system performance to identify potential issues.
- Participated in the design and development of user-friendly documentation for IT support processes and procedures.
- Optimized system performance by conducting regular hardware and software maintenance tasks.
- Implemented effective data backup protocols to protect vital information from potential loss or corruption.
- Conducted thorough assessments of existing client networks to identify areas for improvement or expansion opportunities.
- Responded promptly to incoming sales leads and requests for technical support.
- Enhanced IT infrastructure by implementing comprehensive network security measures and monitoring systems.
- Collaborated with cross-functional teams to develop and implement IT solutions, increasing overall efficiency.
- Developed customized IT strategies for clients to align technology solutions with business objectives.
Education
Bachelor of Science - Environmental Biology
Delta State University
Nigeria 04.2007
Skills
- Data Migration
- Log Shipping
- Interdepartmental communication
- Strong Knowledge of database backups and restore/recovery models, query optimization, SQL server installation, Configuration of stand-alone and clustered environments
- Expert in Performance Tuning, Maintenance, High Availability and Disaster Recovery (HADR) Solutions including backup and restore, Always On, Database Mirroring, Log Shipping, and Replication models (Snapshot, Transactional/Merge) to protect and retain valuable company data
- Experienced in migration/upgrade, applying service packs and routine DBA operations like database health checks, index optimization, updating statistics, client/server connectivity and capacity planning
- Proficiency in T-SQL and PowerShell languages
- Experienced in using Query Store, Extended Events, Database Engine Tuning Advisor (DTA), SQL Profiler, Scripts, and other third-party tools to resolve bottlenecks, deadlocks and slow running queries
- Experience in SQL Server Installation, Server and Database Security through configuring, Transparent Database Encryption (TDE) and Dynamic Data Masking (DDM)
- Experience with supporting ETL processes, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) Familiarity with POWER BI and Tableau
- Proficient in using Monitoring tools for SQL/Azure including SolarWinds, SQL Profiler, SQL sentry, Fog light and Event Viewer for monitoring and tracing activities in my environment
- Excellent communicator with advanced presentation creation, delivery skills, Attention to Detail and Leadership
- Problem-Solving and analytical and Critical Thinking
- A self-starter who is versatile with database technologies, always motivated to learn, grow, and stay current
Certification
Microsoft Certified: Azure Administrator Associate
Accomplishments
- Automated processes to reduce workflow by creating maintenance plan that runs daily to reorganize, rebuilt and update statistics, Backup, and cleanup task in my environment.
- Setup and Manage Always-ON High Availability for HA/DR, High availability and Disaster Recovery. Setup and manage Replication, Log Shipping to automate and Synchronize Backups and restore to a Secondary server for Disaster Recovery and addition security for Mission Critical databases in our environment.
- Maintain Database Security and Consistency in SQL server by running database validation Checks with RMAN and database consistency checks with DBCC and DMVs in SQL server Database respectively to proactively resolve data corruption and inconsistencies.
References
Available on request
Timeline
Senior SQL Server Database Administrator/Azure DBA
Aetna/CVS Maryland USA
06.2018 - Current
SQL Server Database Administrator
Mtn Nigeria, Mobile Telecommunication Network
04.2014 - 04.2018
IT Support Consultant
Petrolog Group
03.2010 - 01.2014
Bachelor of Science - Environmental Biology
Delta State University
Similar Profiles
IVETTE DAGONIVETTE DAGON
Mail Processor at Viva USA Inc/CVS-AetnaMail Processor at Viva USA Inc/CVS-Aetna
JENNIFER PATTERSONJENNIFER PATTERSON
Supervisor, Plan Sponsor Services at Aetna, a CVS Health CompanySupervisor, Plan Sponsor Services at Aetna, a CVS Health Company
Jennifer ScallaJennifer Scalla
IFP-Individual and Family Plans-Quality Assurance at Aetna/CVS HealthIFP-Individual and Family Plans-Quality Assurance at Aetna/CVS Health
Venkata PaletyVenkata Palety
Sr. PostgreSQL DBA, MySQL DBA, Mongo DBA, SQL Server DBA & Sr. Oracle Database Administrator at Cisco Systems IncSr. PostgreSQL DBA, MySQL DBA, Mongo DBA, SQL Server DBA & Sr. Oracle Database Administrator at Cisco Systems Inc
Bismark NkansahBismark Nkansah
Senior SQL Server/Azure Database Administrator at QuiverData Solution IncSenior SQL Server/Azure Database Administrator at QuiverData Solution Inc