Summary
Overview
Work History
Education
Skills
Certification
Affiliations
Area Of Expertise
Timeline
Generic

Onyemauche Anosike

Atlanta,USA

Summary

More than 7years experience MS-SQL DBA, Windows Server and Linux server for diverse industries, including telecom, retail, manufacturing and high-tech environments managing more than 6,000 MS SQL instances, 7,000 databases, clustered, replicated and mirrored mixed (2008R2, 2012 and 2014, 2016, 2017 & 2019 MS SQL) environment and a record of increased responsibility with 10mins MTTR SLA with our clients. Proficient in prioritizing and completing projects and assigned tasks in accordance with budget and time schedule, yet flexible to multitask when necessary. A DBA who enjoys learning new programs and processes; a team player who is attentive to detail and able to work in a fast-paced environment. Excellent oral and written communication skills, as well as problem solving and negotiation skills.

Overview

7
7
years of professional experience
1
1
Certification

Work History

MSSQL DBA

Barrister Global Resources
08.2022 - Current
  • Migrating Databases from different platforms like SQL Server 2005 to 2008, 2012 , 2014, 2016 and 2019
  • Installing and configuring database software, associating database tools and performance monitoring software
  • Performing database/infrastructure physical design, database upgrades & applying software patches to databases as per application/client requirements
  • Performing acceptance testing to verify that database changes perform without adverse consequences and carrying out load balancing and stress test
  • Estimating disk storage requirements for database software, database files & database administration needs and general capacity planning
  • Developing and maintaining scripts, utility jobs and implementing needed software for database maintenance
  • Implementing and managing database clustering, failover and load balance technologies as per client requirement
  • Developing, testing & implementing a robust database backup and recovery strategy with client assistance
  • Requesting refreshes pre or post restore activities (e.g
  • Data loads)
  • Conducting root cause analysis for database incidents and problems
  • Participating in designing, testing and implementing an enterprise Disaster Recovery Plan
  • Monitoring data activities (i.e
  • Database status, logs, space utilization, extents, Checkpoints, locks and long transactions)
  • Adhering to Change Control Procedures and attending CAB meetings
  • Developing and executing scripted changes requests in accordance with change control procedures
  • Conducting research and collaborating with vendor if necessary for additional patches
  • Providing stopgap solutions if possible and acceptable by business and application team owners
  • Researching, reviewing and recommending for preventive maintenance
  • Interfacing with database vendors & client technical support teams to isolate & resolve database related problems
  • Managing Databases of more than 6 TB replications and disk cloning
  • Setting up Log Shipping, MSSQL Mail, SMTP, always On, Clustering, Mirroring and Replications
  • Creating, administering & maintaining SQL Server Databases (Production, Development, QA, Test and Staging Environment.) for various groups such as Developer, QA, DA and User and ensuring Availability of Database Server in 24X7 Environment
  • Scanning data pages, Indexes and checking storage space used by each table
  • Managed security by defining roles and rights
  • Handling Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize maximum resources for Database and Applications
  • Monitoring database server performance and if required go for tuning of TSQL queries, Stored procedures.

MSSQL DBA

ACS Inspiroz
01.2022 - 12.2022
  • Worked with a team of 15 staff in the development, design, and implementation of new applications and changes to existing hardware systems and software packages, resulting in increase in efficiency and return on investments for clients
  • Create, assign, accept and manage all incidents in BMC Remedy
  • Responsible for Windows troubleshooting of all incoming incidents and performs requests for service
  • Managed environment and system configuration changes and application of problem management upon available skills and experiences
  • Management and Carried out Resources planning, operations and cooperation on application of projects for continual environment and procedure improvement
  • Carry out Windows Server Health Status (Network Connectivity, Hardware Health Status)
  • Managed OS Health checks (Disk Usage, CPU and Memory Monitoring)
  • Managed Backup status (on applicable servers)
  • Configuring and setting up of Disaster Recovery (DR) and High Availability (HA) using Alwayson High Availability solutions for customers
  • Performs Windows analysis, acquisition, installation, maintenance, and upgrade of server/computer hardware, operating systems, and software utilities; Manage deployment, upgrades, and maintenance of, servers, hardware, software, desktop operating systems, and printers.
  • Provide system administration of hardware, operating systems, application software, and overall solutions
  • Maintain server backup systems and monitor system performance
  • Creating and managing Windows Server clustering
  • Building contained Databases and creating Memory-Optimized Tables and migrating existing tables to filegroups.
  • Carry out requirement gathering and analysis and design ER Diagrams and EER Diagrams
  • Design, implement and administer High Availability solutions, (clustering, log shipping mirroring and replication)
  • Provide 24/7 remote support to SQL Servers on customer sites of various companies to prevent downtime
  • Writing, debugging, and tuning T-SQL, ETL and Stored Procedures for system performance
  • SQL Server database physical model creation and implementation (data type, indexing, table design)
  • Development, deployment and management of SSIS, SSAS, SSRS and publication for end users using given KPIs and KPAs
  • Using SQL Sentry and light-speed application for optimizing queries and database performance
  • Setup and administering SQL Server Database Security environments using profiles, database privileges and roles to prevent data theft and increase data integrity
  • Database maintenance, replication and tuning
  • Migration of systems data from different databases and platforms to MS-SQL databases
  • Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers
  • Designing, Implementing and maintaining database schema, entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, functions, views, rules, defaults and complex SQL statements
  • Generate complex stored procedures and functions for better performance and flexibility
  • Ensure database performance monitoring and tuning is regularly accomplished
  • Design backup and restore strategies and Disaster Recovery solutions
  • Implement security policy design for current and new applications
  • Coordinate team meetings with groups for new design/strategies
  • Load data into oracle and SQL database from DB2 extracts using SQL loader
  • Responsible for maintenance, Backup & Recovery, testing, alerts (job failures, database & server capacity, etc), and database integrity checks
  • Review logs, update database statistics and index management
  • Troubleshoot application performance issues, database maintenance & configuration, patching, and upgrading
  • Security, auditing, configuring, documenting, enhancement & corrective changes, emergency changes
  • Participate in DBA On-call monthly and document environments and processes where applicable
  • Work with other DBA team members and various application teams
  • Auditing systems and developing standards and implementation of best practices for performance and clarity
  • Identify, update, develop, implement and manage ITIL management best practice processes.

MSSQL DBA

Inalfa Roofing Systems
06.2017 - 11.2021
  • Created, administered & maintained SQL Server databases (production, development, test and staging environment) for various groups such as developers, QA, DA and users and ensured availability of database server in 24/7 environment.
  • Used Red-gates and SQL-Sentry for Database/SQL Server performance tuning and query optimization.
  • Trained MS DBAs and BI Administrators before deployed to customer sites for optimum relationship.
  • Managed the development, design, and implementation of new applications, as well as changes to existing hardware systems and software packages resulting in high performance for clients
  • Provided remote support to SQL Servers on customer sites of various companies to prevent downtime
  • Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node for high availability
  • Writing, debugging, and tuning T-SQL, ETL and stored procedures for developers and customers
  • SQL Server database physical model creation and implementation (data type, indexing, table design)
  • Developed, deployed and managed SSIS, SSAS, SSRS and published them for end users in SharePoint
  • Set up and administered SQL Server Database Security environments using profiles, database privileges and roles
  • Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery for high availability
  • Ensured regular database performance monitoring and tuning to prevent downtime
  • Designed backup and restore strategies and Disaster Recovery solutions to prevent data loss
  • Implemented security policy design for current and new applications to prevent data corruption and theft
  • Coordinated team meetings with groups for new design/strategies
  • Created database design for new projects support
  • Worked with light-speed application for optimizing queries and database performance
  • Coordinated change review meetings and facilitated in management of incidents according to SLAs
  • Planned and administered projects, as well as overall programs using PMI Guide and expert judgment
  • Collected requirements, performed project scoping, and served as SPOC (Single Point Of Contact) for clients
  • Ensured that project and program deliverables and benefits align with clients’ objectives and advice for change
  • As needed and appropriate but no less than annually, provided written technology policy guidance to managers, supervisors, staff and consumers/participants
  • Managed desktop & printer maintenance contracts based on the ITIL Service Management model in line with the overall customer strategy of reducing Total Cost of Ownership
  • Developed annual technology goals and detailed plans for goal accomplishment
  • Prepared, maintained and tested technology disaster recovery plans
  • Managed external technology projects.

Education

Bachelor of Arts - Accounting

Federal Polytechnic Nekede Owerri
Nigeria
04.2006

Skills

  • Organization and Time Management
  • Relationship Building
  • MS Office
  • Flexible and Adaptable
  • VMware

Certification

  • Linux System Administrator – (Red Hat Certified System Administrator)
  • Google IT Support Specialist
  • Chartered Manager – (Nigerian Institute of Management)

Affiliations

  • Project Management Institute
  • Nigerian Institute of Management

Area Of Expertise

  • Strong experience in Database Administration in SQL Server
  • Installation, configuration, and upgrade of Microsoft Windows Server 2008r2, 2012, 2014, 2016, 2017 and 2019
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
  • Configuring and setting up windows Server Failover Clustering environment Strong.
  • Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
  • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
  • Administering Windows Server 2003, 2008r2, 2012
  • Experience with BMC Remedy for incident, problem and asset management (including BMC Patrol)
  • Experience with Windows environment, VM
  • Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
  • SQL Development - ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
  • Performed Windows Software installs/upgrades, monitoring/alert configuration
  • Manage the production and development of databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity on SQL Server 2008 R2, 2012 and SQL Server 2014.
  • Tables partitioning, file and file-group management, Knowledge of High Availability of database servers using Database mirroring, replications, and Log Shipping.
  • Design and implement 2005, 2008 R2, 2012 and MS SQL 2014 databases for mission-critical business.
  • Experienced on Disk and Server configuration through Raid for SQL Server.
  • Use SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.
  • Develop and modify stored procedures, queries, triggers, views, indexes, and functions to handle business rules, history data and audit analysis.
  • Use Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) and Extract Transform Loading (ETL) tools of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
  • Configure and support SSIS and SSRS for 2005, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014
  • Troubleshoot databases and custom application issues for 2005, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014
  • Experienced in working with end users to define, implement, and maintain their reporting requirements.
  • Experienced in the design, coding, testing and implementation of high volume transactional (OLTP) SQL databases instances.
  • Generate the weekly, monthly, and quarterly report by using SQL Standard Report.
  • Create reports that ran daily for jobs running in SQL Server Agent.
  • Experienced with monitoring and troubleshooting in 24x7 operations.

Timeline

MSSQL DBA

Barrister Global Resources
08.2022 - Current

MSSQL DBA

ACS Inspiroz
01.2022 - 12.2022

MSSQL DBA

Inalfa Roofing Systems
06.2017 - 11.2021

Bachelor of Arts - Accounting

Federal Polytechnic Nekede Owerri

Similar Profiles

CREATE PROFILE
Onyemauche Anosike