Maxwell Igbinovia

• Assembling large, complex sets of data that meet non-functional and functional business requirements.
• Identifying, designing and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes.
• Building required infrastructure for optimal extraction, transformation and loading of data from various data sources using AWS and SQL technologies.
• Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition.
• Working with stakeholders including data, design, product and executive teams and assisting them with data-related technical issues. Supports all aspects of the Digital Network Solutions payment processing system including but not limited to MS SQL Databases, data integrity, reporting, performance, disaster recovery and data translation.
• Developed scripts and processes for data integration and maintenance.
• Set up and controlled user access levels across databases to protect important data.
• Modified databases to meet needs and goals determined during planning process.
• Conducted tests to identify issues and make necessary modifications.
• Transparent Data Encryption (TDE): transparently encrypts data at rest in MSSQL and Oracle Databases. Stops unauthorized attempts from the operating system to access database data stored in files, without impacting how applications access the data using SQL.

❖ Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers
❖ Managed and Administered databases in SCOM
❖ Manage IAS and PASS database in azure
❖ Migrate database from on-prem to Azure Cloud
❖ Installed and configured SQL Server
❖ Managed SQL Server Clusters in a SAN environment
❖ Produced data models and designing logical and physical models of database
❖ Implemented Database Mirroring on SQL Server 2008 environments for DR/HA
❖ Configured and maintained Log shipping architecture to provide a backup server solution for 4 environments in a DR
❖ Performed Backups, DBCC utilities, updated index statistics, monitored database and disk space
❖ Managed the migration of SQL Server 2012 databases to SQL Server 2016/2019
❖ Implemented Failover clustering for Active/Active and Active/Passive for HA
❖ Created and maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions, and other
schema objects
❖ Designed and implemented comprehensive Backup plan and disaster recovery strategies
❖ Resolved and tweaked memory pressures caused during production release
❖ Worked with customers on Application rollouts and server migrations
❖ Experience in supporting Very Large databases (VLDB) and troubleshooting related problems
❖ Strong experience in mentoring team members and writing documentation
❖ Troubleshoot performance problems and fine-tuning of databases.
❖ Applied expertise in designing databases and capacity planning.
❖ Rebuilt indexes and statistics update at regular intervals for better performance.
❖ Designed and implemented comprehensive Backup plan and disaster recovery strategies.
❖ Provided 24x7 production support for SQL Server databases on standalone and Clustered Servers.
❖ with sizes ranging from 100s of GB to 3.8 TB to achieve maximum performance and uptime in
production environment.
❖ Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
❖ Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
❖ Implemented and Scheduled Replication process for updating our parallel servers.
❖ Designed and created databases, tables, views, store procedures and triggers.
❖ Handled memory configurations for SQL Server 2012 and SQL Server 2008R2 on Windows Server.

❖ Performed SQL Server and Windows service pack updates across enterprise production environment
❖ Migrated legacy databases with upgrade from SQL 2005 and 2008R2 to SQL 2012 and SQL 2014
❖ Worked in Query analyzer and profiler for tuning queries using variable for characteristics and query costs
❖ Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
❖ Implemented and Scheduled Replication process for updating our parallel servers
❖ Designed and created databases, tables, views, store procedures and triggers
❖ Worked closely with Network, Server and Storage teams to create a smooth-running environment
❖ Installed and configured of MS SQL Server 2000/2005/2008/2012 Database Servers
❖ Troubleshooted hardware bottleneck, system issues and proactively monitoring the performance of SQL Server databases
❖ Collaborated with application teams on migration of application databases from legacy/regional servers to Data Center
❖ Deployment of code/Builds into QA and Production environments
❖ Worked with Development, QA, Application Engineering, Release Management and Project
Management Teams
❖ Served users Ad-hoc requests for pulling reports/results
❖ On call Production Support DBA for 24X7 Critical production OLTP/OLAP Systems
❖ Supported environments such as Development, QA, Stress, and Standalone
❖ Installed, configured, of SQL Server 2005, 2008 and 2008 R2
❖ Installed and configured SSIS and SSRS
❖ Responded to SQL Server alerts for disk space, Job failures and other performance related issues
❖ Documented best practices for ongoing production support.
❖ Automated DB Refreshes Production to QA/Staging/Development based on user requests or Application team needs.
❖ After hours and Weekend Support for any Database maintenance related activity.
❖ Worked as on call support DBA in a 24x7 environment on a weekly rotational basis.

❖ Installed SQL Server with standard access privileges service account to improve security and to attain high ratings in SOX audits.
❖ Installed, configured SQL Server 2008R2 Clustering on Microsoft Clustering services (MSCS) for Active-Passive and Active-Active cluster Nodes.
❖ Involved in Analyzing and Upgrading SQL Server 2005 and 2008R2 test and production servers to SQL Server 2012 and 2014 with AlwaysOn AG configuration of up to 4 replicas.
❖ Gained experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments.
❖ Performed SQL Server and Windows service pack updates across enterprise production environment.
❖ Designed robust backup strategy and implemented comprehensive backup plan using Native SQL and Lite Speed.
❖ Resolved and tweaked memory pressures caused during production release.
❖ Worked with customers on Application rollouts and server migrations.
❖ Migrated legacy databases with upgrade from SQL 2005 and 2008R2 to SQL 2012 and SQL 2014.
❖ Experience in supporting Very Large databases (VLDB) and troubleshooting related problems.
❖ Strong experience in mentoring team members and writing documentation.
❖ Troubleshoot performance problems and fine-tuning of databases.
❖ Applied expertise in designing databases and capacity planning.
❖ Rebuilt indexes and statistics update at regular intervals for better performance.
❖ Designed and implemented comprehensive Backup plan and disaster recovery strategies.
❖ Provided 24x7 production support for SQL Server databases on standalone and Clustered Servers with sizes ranging from 100s of GB to 3.8 TB to achieve maximum performance and uptime in production environment.
❖ Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query
costs.
❖ Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
❖ Implemented and Scheduled Replication process for updating our parallel servers.
❖ Designed and created databases, tables, views, store procedures and triggers.
❖ Handled memory configurations for SQL Server 2012 and SQL Server 2008R2 on Windows Server.