Manager Aws

ONYENENIM IWEBUKE

New York, NY 917-***-**** ************@*****.***

SUMMARY

Dedicated and hardworking database administrator with 5 plus years of experience working in the field. Provides full life cycle of SQL Server database support across global enterprises. Create high-level analyzed findings reports for management and clients, specifically identifying database issues that lead to overall database health improvements. Exceptional, analytical, problem-solving, and communication skills. Ability to work well in a team, and individually.

SKILLS

• RDBMS: Microsoft SQL Servers 2008/2008 R2, 2012, 2014, 2016, 2017,MySQL

• Extensive experience with configuring high availability and Disaster recovery scenarios like clustered environments. Set up different topologies in replication, Log shipping and mirroring

• Expertise in setting up Active/Passive and Active Clusters for high availability

• Performance & Monitoring Tools: IDERA SQL Diagnostic Manager, Solarwinds DB Performance Analyzer, Perfmon, Error log, System DMV, Database Tuning Advisor, Index Tuning Wizard, Extended Events, SQL Database Performance Analyzer

• ETL Reporting Tools: SQL Server Integration Services SSIS, SQL Server Reporting Services SSRS, SQL Server Analysis Services SSAS, Data Integrator, Data transformation services DTS

• Operating Systems: Windows Server 2008/2012, Windows 2008/2012

• Cloud: AWS

• Documentation: Design Document of SQL Architectural design of the whole environment

• Strong SQL scripting skills.

• Strong organizational skills and ability to effectively handle multiple concurrent assignments • Great communication skills

• Proven analytic skills, strong judgment and works effectively with others

• Outstanding team leadership abilities

• Windows 7/10, Mac OS

• Microsoft Office Suite

• IOS and Android mobile Devices • Microsoft Server 2012/2016 - Active Directory, File server, DHCP, DNS • Microsoft Office 365 • SCCM 1702Cloud: AWS

• Languages: T-SQL, C++, Java, Python, HTML, CSS

EXPERIENCE

SONMORI GROUP (NEW YORK, NY)

DATABASE ADMINISTRATOR (OCTOBER 2015 - PRESENT)

• Responsible for SQL Server Physical Database design, implementation, maintenance and capacity planning

• Extensively worked on setting up Always On Availability Groups on a Multi-subnet failover network. Experience with high availability disaster recovery solutions, including Database Mirroring, Transactional Replication and Always-On to take advantage of the access to various endpoints in SQL Server 2012, 2014,2016

• Worked along with the Windows team to configure Windows Failover Cluster on which the Always-On setup was done.

• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery

• Using IDERA SQL Diagnostic Manager to quickly pinpoint and predict database issues before they happen, from query monitoring to transactional application monitoring, getting built in tuning advice and best practices and guidance to address problem issues

• Cloud migration – Migrate workloads to the cloud on the AWS platform using Database Migration Service (AWS DMS) and Schema Conversion Tool (SCT)

• Experience with Amazon Aurora RDS and EC2 instances

• Initiate Database Migration from source server to destination server (our newly acquired SQL server 2017)

• Experience with high availability disaster recovery solutions, including Database Mirroring, Transactional Replication and Always-On to take advantage of the access to various endpoints in SQL Server 2012, 2014,2016

• Develop SQL Server Logins, Groups, Users and assigning roles and authentication modes as a part of Security Policies for Various Categories of User Support

• Schedule jobs to automate different database related activities including Backup, CPU usage, Monitor Database health, Disk space and Backup verification

COMPUTER WAREHOUSE GROUP PLC (LAGOS, NIGERIA)

DATABASE ADMINISTRATOR (DECEMBER 2012 – JANUARY 2014)

• Performed backup/restore, created database objects such as tables, procedures, constraints, indexes and views, user security management. Designed database tables and relations between them through Normalization. Involved in project planning, scheduling for database module with project managers.

• Performance tuning of databases by windows performance monitor and SQL Profiler

• Hands on experience in Performance issues and troubleshooting database issues

• Worked on Complete Backing up of Database using full, differential and transactional log back up methods and Restored the Database from Disaster Recovery. Experience with Point-in-Time Recovery

• Monitored server activities, Error Log, space usage. Also created operators and proxies

• Recommended and implemented best practices for SQL architecture

COMPUTER WAREHOUSE GROUP PLC (LAGOS, NIGERIA)

2ND LINE IT SUPPORT (NOVEMBER 2010 – DECEMBER 2012)

• PC and Laptop configuration • Investigating and fault-finding hardware and software issues • Liaising with 3rd party providers to support hardware issues • Asset management • Vast experience in Networking (DNS/DHCP, LAN/WAN), Virtual Machines and Active Directory• Resolving mobile device queries

• Anti-virus / malware, encryption deployment

• Diagnosing and resolving hardware, software and end-user problems

• Acting as the first point of contact for all IT and technical queries

• Involved in the rollout of software updates and patches

• Investigated IT support issues

SYSTEMSPECS (ABUJA, NIGERIA)

IT SUPPORT (AUGUST 2009 – OCTOBER 2010)

• Maintaining WordPress company website • Data updates and Imports • Responding to queries and tickets • Database management and reporting (SQL)• Microsoft Office Suite, Microsoft Lync, Citrix & TeamViewer

• Creating user and email accounts

• Maintaining a wide range of computer hardware and software programs

• Physically fit and able to lift IT equipment, crawled under desks to access cabling, etc

• Able to communicate complex IT issues to suppliers and non-technical staff

• Improved existing programs by reviewing specifications and objectives and making necessary changes

EDUCATION

KINGSBOROUGH COMMUNITY COLLEGE (BROOKLYN, NY)

A.S. Computer Science (DECEMBER 2020)

SAE INSTITUTE (NEW YORK, NY)

Audio Engineering Certification (OCTOBER 2014)

UNIVERSITY OF LAGOS (LAGOS, NIGERIA)

B.Sc. Estate Management (MAY 2007)

Contact this candidate