Henry Ike

adwgey@r.postjobfree.com

240-***-****

Professional Summary

Henry has served as an innovative Data Base Administrator in multiple projects, delivering extra ordinary value to various organization. A great team player and a problem-solver, always paying close attention to details and communicating effectively to every stakeholder. My aim is to always be the best at everything I do so am open to always developing my skills and learning new skills to be effective. I have almost 12 years’ experience with MSSQL, and 15 years passed of Oracle Database Administrator.

Certification, Training and Skillset

• Scrum Master Certification

• MS Azure Advance Certification

• SQL Fundamentals Associate Certification

• OCA, OCP

• AWS Associate and Advance

• Bs Computer Science 2000 University of Buea Cameroon

• Excel (Advanced)

• MS Word (Advanced)

• MS PowerPoint (Advanced)

• Sharepoint

• Jira

• Power BI

• Postgres fundamentals

• Azure Security Center

• Big Data Platforms (Azure, Databricks)

• Database version 12.0,13.0,14.0 Mssql 2012,2016, . SSIS, SSRS SSAS T-sql, sql fundamentals, Azure.

• SQL Server 2000, 2005,2008,2012,2016,2018 on Windows 2007,2010

• Data Privacy, Identity and Access Management (IAM), Cryptography / Key

Education: -

University of Houston

Bachelor of Science - BS, Computer/Information Technology Administration and Management

Mar 1996 - Jun 2000

WORK HISTORY

Bank Of America Germantown MD

Jan2016- Present

SQL Server Production DBA

Roles and Responsibilities

Working on several IT change programs, with focus on systems replacement and development.

• Manage SQL server databases through multiple product life cycle environments, from development to mission-critical production systems.

• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.

• Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.

• Refine and automate regular processes, track issues, and document changes.

• Assist developers with complex query tuning and schema refinement.

• Perform scheduled maintenance and support release deployment activities after hours.

• Share domain and technical expertise, providing technical mentorship and cross-training to peers and team members.

• Migrate data from enterprise-hosted databases to cloud-hosted data services like AWS RDS.

• Work with the following tools and technologies: MS SQL server administration; performance tuning and optimization (PTO) using native monitoring and troubleshooting tools; backup, restore, and recovery models; windows server, including active directory; high availability (HA) and disaster recovery (DR) options for SQL server; and leading cloud platforms like AWS, Azure, or Google Cloud.

Migrated SQL Server Databases from Legacy version to Target New SQL Server

• Migrated On-Premises SQL Server databases to Azure Single SQL Database and MI in PaaS and SQL Server on Azure VM Environment (IaaS)

• Travel / relocate to various unanticipated locations to interact with clients and train users for short and long-term assignments.

• Migrating data from one platform to the other using tools like azure migration winscp and securecrt file transfer. Migrating data from one platform to the other using tools like winscp and securecrt file transfer. SQL Server 2019,2017/2016/2014/2012/2008R2/2005, MS Access 2007 &2003/Excel 2007/2010/2013/MySQL

• Expertise in T-SQL, DW Concepts, Tabular Cube.

• Monitoring postgress db and creating users and granting privileges as needed.

• Deploy scripts created by developers.

• Design an implementing new structural tables by using ewin.

• Design instance for the database as required

Montgomery County federal Credit Union

Jan 2011-Dec2016

SQL Server Production DBA

• Installation and configuration of sql server management studio 2012, 2016. Creating new instances,

• Database import new data (csv files). Patching, Upgrade, migration of sql server database from 2012 to 2016. Perform refreshes and debugging hard queries from a data virtualization platform.

• Creating users, granting privileges, Monitoring audit logs and run audit for developers to know what they are doing.

• Configure Azure platform and link servers to another server.

• Configure monitoring with stack flow and toad for sql. Using Ewin for data engineering and adding tables to the database.

• Work on a 24/7 support using t-sql scripts for critical systems.

• Design and develop MSSQL automation workflow.

• Using different virtualization tools to manage the sql server database (Denodo)

• Migrating data from one platform to the other using tools like WinSCP and securer file transfer. Migrating data from one platform to the other using tools like WinSCP and securecrt file transfer.

• Performing deployment as needed by the developer.

• Creating administration account for denodo and linking them to active directory.

• Rebuilding indexes to increase performance. Dropping used and unuse indexes and creating new once.

• Implementing new strategy for disaster recovery by creating always on availability groups.

AT$T Silver Spring MD

Jan 2008 Dec2010

SQL Server Production DBA

• Installs, configures, and maintains Databases as per product requirement and industry best practices. Ensure that database is available, secure, healthy, efficient, and recoverable as expectations.

• Performing regular system review using Solar wins, plan and implement solutions for current and future needs.

• Run database maintains as required, backup and restores different databases.

• Complete first level of analysis (CPU, memory, space, blocking sessions, failed jobs, tuning queries for performance etc.)

• Create database users/logins and security groups. Making sure that all privileges are set as required.

• Performing database import and export of CSV files, migration, upgrade, patching from one system to the other.

• Rebuilding cluster and non-cluster indexes off and online.

• Design and develop MSSQL automation workflows using Python and PowerShell.

• Import and Export csv files from one database to another using MSSMS Import and Export wizard.

• Recover tables from existing backup tables. Making Azure sure that tables match their character sizes.

• Data Modeling Skills compare two different environment using ERWIN Data Modeling tool.

• Migrating data from Oracle to SQL Server Environment using WinSCP.

• Apply MS Patch, version control and vulnerability management as needed.

• Migrating data from one platform to the other using tools like winscp and securecrt file transfer. Migrating data from one platform to the other using tools like winscp and securecrt file transfer.

• Using operating system like linux, Unix and Aix for creating of database mount point and job scheduler

• Making changes on batch profiles as required on a linux operating system.

Contact this candidate