SUMMARY

• I’m a DBA with almost 10years industry experience in database design, creation, administration, performance tuning, high availability, disaster recovery, MS SQL, SSAS, SSIS, SSRS, Azure, and AWS.
• I have garnered experience from a variety of clients/industries like telecommunication, Banking & Finance, airline/aviation and construction, medicine & surgery.
• My contributions have guided my clients through a range of services including proper deployment, on - going maintenance, and troubleshooting of their On-Line Transaction Processing (OLTP) environments; as well as managing smooth server farm expansion of rapidly growing international enterprises.
• I also serve as a mentor and trainer to other IT professionals both within my teams and among the DBA community.

PROFESSIONAL EXPERIENCE

Lead SQL Database Administrator

Confidential

Responsibilities:

• Migrate large - scale environments to the all-new Windows Server 2016/ SQL Server 2016 environment.
• Provision and configure Windows servers for infrastructure/ product restructuring projects, cost-saving SQL server projects and deployments in AWS.
• Manage the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Proactively monitor, manage and troubleshoot large data farms comprising SQL and Progress database using native tools as well as 3rd party tools like Solarwinds, Devart, and ProMonitor.
• Administer ETL packages to support reporting services, business Intelligence systems and large data warehouses.
• Implement SSIS scripting solutions to develop BI tools and stored procedures for table automations.
• Document procedures and activities and ensure that the documentations are valid and up-to-date
• Champion periodic maintenance activities with my team and ensure best practices are followed.
• Deploy numerous development and production high-availability solutions in various MS SQL Server environments from SQL Server 2008 through SQL Server 2016 on Windows Server 2012, 2012R2 and 2016.
• Engage in Strategic Planning, implementation and support of high availability (HA) and disaster recovery (DR) solutions via log shipping and database mirroring, Replication, Always On Availability Groups along with deploying responsive backup strategies across multiple SQL Server instances into Amazon S3
• Review configuration changes and developers scripts; and ensure proper testing and rollback procedures are followed.
• Review create report of 3rd party tools and software in terms of functionality, need, usage and cost.
• Train colleagues on setting up HA & DR solutions like Always ON, Replication and troubleshooting these technologies.
• Train and mentor colleagues on carrying out SQL server maintenance & upgrade activities, and safe practices in trouble shooting SQL server in a timely manner in other to maximize resource availability.
• Serve as lead point of contact for internal clients, installing, configuring, updating, upgrading and supporting our database systems.
• Exceed Service Level Agreements for uptime and performance of SQL Server databases by implementing PAAS infrastructures using AWS.

Senior Database Administrator

Confidential

Responsibilities:

• Migrated large - scale environments to the all-new Windows Server 2016/ SQL Server 2016 environment.
• Migrated data sources and NoSQL databases like RavenDB to Relational 99.99% cloud-based Azure platform (PAAS).
• Developed ETL packages to support SSRS and Reports Server databases.
• Implemented SSIS scripting solutions to develop BI tools and stored procedures for table automations.
• Deployed numerous development and production high-availability solutions in various MS SQL Server environments from SQL Server 2005 through SQL Server 2012 as well as SQL Server 2014 and SQL Server 2016 on Windows Server 2003, 2003r2, 2008, 2008r2, 2012, 2012R2 and 2016.
• Implemented HA solutions to support domain infrastructure (DNS, Active Directory) on-site and in cloud Azure using VMware and Hyper-V (IAAS).
• Created Azure Virtual Machines (VMware) at IAAS architect level to support production and DEV/SIT environments.
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Ensured continuous monitoring and troubleshooting in 24x7 environment including On-Call Support.
• Trained and mentored colleagues on setting up HA & DR solutions like Always ON, Replication and troubleshooting these technologies.
• Trained and mentored colleagues on carrying out SQL server maintenance & upgrade activities, and safe practices in trouble shooting SQL server in a timely manner in other to maximize resource availability.
• Served as lead point of contact for internal clients, installing, configuring, updating, upgrading and supporting our Database platforms.

Sr. SQL Server DBA

Confidential

Responsibilities:

• Made use of PowerShell and SQL Server Management Objects to manage SQL Server databases for high availability.
• Successfully engaged in various DR (Disaster Recovery) scenarios for my customers.
• Served as lead point of contact for internal clients, installing, configuring, updating, upgrading and supporting our Database platforms.
• Worked with BI teams in the full development and production lifecycle administration of the SQL Server 2005 - 2012 enterprise data warehouses (SSIS) and SSRS Report Servers.
• Made recommendation on systems hardware and software implementation for management approval and took responsibility for complete and timely implementation.
• Automated repetitive maintenance tasks such as database backups, restores, performance tuning, Index maintenance & rebuilding as well as capacity analysis and set up alerts systems for such jobs.
• Organized and coordinated daily operations and project delivery meeting to identify all possible problems and ensure they are rectified to keep project on schedule and report any project variance to the appropriate upper management personnel.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code.
• Performed various data migration tasks for mission critical databases. Migration involving non-relational databases and relational databases using SSIS and VB scripting.
• Effectively managed over 2000 databases ranging from 350GB to 2.3TB along with 6 other DBAs.
• Maintained large data warehouses (multidimensional and relational).
• Set up policies to guide database usage in SQL Server.

IT & SQL Server Administrator

Confidential

Responsibilities:

• Designed storage layout plan for new servers and recommended improvements for existing servers.
• Made hardware resource (CPU, Memory) sizing recommendations for new server and improvements for existing servers as needed.
• Performed SQL Server installation (cluster and standalone) for SQL Servers Version 2000/2005/2008/2008 R2/2012.
• Configure various High Availability solutions; Failover Clustering (Windows and Database), Mirroring and Log - shipping.
• Perform support duties including: performing backups and restore, Query and Index performance tuning, and capacity analysis, troubleshooting and fixing failed jobs.
• Served as lead point of contact for internal clients, installing, configuring, updating, upgrading and supporting our Database platforms.
• Managed database security across environments by performing tasks like creating logins, assigning adequate user permissions and removing unused logins.
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering and database security configuration.

IT Project Engineer

Confidential

Responsibilities:

• Planning, design and implementation of access control and automation systems for office building, private residential villas, schools, hostels, industrial factories etc. with the aid of AutoCAD, Proteus7.
• Custom design, installation and after-sale maintenance of computer hardware, peripherals and operating system for luxury apartments, villas and schools.
• Design and after-sale maintenance of cleaning robots and cranes.
• Maintenance planning and repair of cleaning robots, cranes, residential automation systems.
• Supervision and motivation of group of subordinate engineers and technicians.